btnupdate9 not working :(
<%@ Control Language="C#" AutoEventWireup="true" CodeFile="UC_tahsilat.ascx.cs" Inherits="SNN.islemler_tahsilat_UC_tahsilat" %>
<
table
width
=
"100%"
>
<
tr
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
</
tr
>
</
table
>
<
telerik:RadTabStrip
runat
=
"server"
ID
=
"RadTabStrip1"
SelectedIndex
=
"0"
MultiPageID
=
"RadMultiPage1"
>
<
Tabs
>
<
telerik:RadTab
Text
=
"Genel Bilgiler"
Selected
=
"True"
>
</
telerik:RadTab
>
<
telerik:RadTab
Text
=
"Tutar Giriş"
>
</
telerik:RadTab
>
</
Tabs
>
</
telerik:RadTabStrip
>
<
telerik:RadMultiPage
runat
=
"server"
ID
=
"RadMultiPage1"
SelectedIndex
=
"0"
Height
=
"218px"
Width
=
"100%"
CssClass
=
"multiPage"
>
<
telerik:RadPageView
runat
=
"server"
ID
=
"Genel_Bilgiler"
>
<
table
width
=
"100%"
>
<
tr
>
<
td
>
</
td
>
<
td
>
</
td
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
<
td
>
<
table
style
=
"width: 100%; border: 1px solid #f0f0f0;"
>
<
tr
>
<
td
style
=
"width: 160px;"
>
Proje
</
td
>
<
td
style
=
"width: 50px;"
>
</
td
>
<
td
style
=
"width: 195px;"
>
<
telerik:RadComboBox
ID
=
"cmbProje"
runat
=
"server"
AppendDataBoundItems
=
"true"
SelectedValue='<%# DataBinder.Eval( Container, "DataItem.PROJE_KODU")%>'
DataSourceID="dsProje" DataTextField="KISA_ADI" DataValueField="PROJEKOD" Width="200px"
Culture="tr-TR" TabIndex="1" AllowCustomText="True" AutoPostBack="True" OnSelectedIndexChanged="cmbProje_SelectedIndexChanged">
</
telerik:RadComboBox
>
<
asp:RequiredFieldValidator
runat
=
"server"
ForeColor
=
"Red"
ID
=
"RequiredFieldValidator4"
ControlToValidate
=
"cmbProje"
Display
=
"Dynamic"
ErrorMessage
=
"*"
ValidationGroup
=
"FormValidationGroup"
/>
</
td
>
<
td
style
=
"width: 150px;"
>
</
td
>
<
td
style
=
"width: 180px;"
>
İşlem Tutarı
</
td
>
<
td
style
=
"width: 50px;"
>
<
telerik:RadComboBox
ID
=
"cmbParaBirim"
runat
=
"server"
AppendDataBoundItems
=
"true"
Culture
=
"tr-TR"
DataSourceID
=
"dsParaBirim"
DataTextField
=
"PARABIRIM"
DataValueField
=
"PARABIRIM"
TabIndex
=
"6"
Width
=
"50px"
>
</
telerik:RadComboBox
>
</
td
>
<
td
style
=
"width: 195px;"
>
<
telerik:RadNumericTextBox
ID
=
"txtTutarLokal"
runat
=
"server"
Culture
=
"tr-TR"
NumberFormat-DecimalDigits
=
"0"
TabIndex
=
"7"
Width
=
"195px"
>
<
NumberFormat
DecimalDigits
=
"0"
ZeroPattern
=
"n"
/>
<
EnabledStyle
HorizontalAlign
=
"Right"
/>
</
telerik:RadNumericTextBox
>
<
asp:RequiredFieldValidator
ID
=
"RequiredFieldValidator3"
runat
=
"server"
ControlToValidate
=
"txtTutarLokal"
Display
=
"Dynamic"
ErrorMessage
=
"*"
ForeColor
=
"Red"
ValidationGroup
=
"FormValidationGroup"
/>
</
td
>
</
tr
>
<
tr
>
<
td
>
İşveren
</
td
>
<
td
>
</
td
>
<
td
>
<
telerik:RadComboBox
ID
=
"cmbIsveren"
runat
=
"server"
AppendDataBoundItems
=
"true"
SelectedValue='<%# DataBinder.Eval( Container, "DataItem.ISVEREN_KODU")%>'
DataSourceID="dsIsveren" DataTextField="ADI" DataValueField="KOD" Width="200px"
Culture="tr-TR" TabIndex="2">
</
telerik:RadComboBox
>
<
asp:RequiredFieldValidator
runat
=
"server"
ForeColor
=
"Red"
ID
=
"RequiredFieldValidator7"
ControlToValidate
=
"cmbIsveren"
Display
=
"Dynamic"
ErrorMessage
=
"*"
ValidationGroup
=
"FormValidationGroup"
/>
</
td
>
<
td
>
</
td
>
<
td
>
Tutar (€)
</
td
>
<
td
>
</
td
>
<
td
>
<
telerik:RadNumericTextBox
ID
=
"txtTutarEuro"
runat
=
"server"
Width
=
"195px"
Culture
=
"tr-TR"
NumberFormat-DecimalDigits
=
"0"
TabIndex
=
"9"
>
<
EnabledStyle
HorizontalAlign
=
"Right"
/>
</
telerik:RadNumericTextBox
>
<
asp:RequiredFieldValidator
runat
=
"server"
ForeColor
=
"Red"
ID
=
"RequiredFieldValidator1"
ControlToValidate
=
"txtTutarEuro"
Display
=
"Dynamic"
ErrorMessage
=
"*"
ValidationGroup
=
"FormValidationGroup"
/>
</
td
>
</
tr
>
<
tr
>
<
td
>
Tarih
</
td
>
<
td
>
</
td
>
<
td
>
<
mark:DateTimePicker
ID
=
"dateTarih"
runat
=
"server"
ShowClearButton
=
"true"
UseImageButtons
=
"true"
PickerCssClass
=
"Picker"
Culture
=
"tr-TR"
Format
=
"dd-MM-yyyy"
Text='<%# DataBinder.Eval( Container, "DataItem.ISLEM_TARIHI") %>'
CancelButtonText="Seç" ClearButtonText="Temizle" SelectButtonText="Seç..." TabIndex="3"
NoCurrentValueText="Tarih Seçilmedi" OKButtonText="Tamam" Width="150px" />
<
asp:RequiredFieldValidator
runat
=
"server"
ForeColor
=
"Red"
ID
=
"RequiredFieldValidator2"
ControlToValidate
=
"dateTarih"
Display
=
"Dynamic"
ErrorMessage
=
"*"
ValidationGroup
=
"FormValidationGroup"
/>
</
td
>
<
td
>
</
td
>
<
td
>
Tutar ($)
</
td
>
<
td
>
</
td
>
<
td
>
<
telerik:RadNumericTextBox
ID
=
"txtTutarDolar"
runat
=
"server"
Culture
=
"tr-TR"
NumberFormat-DecimalDigits
=
"0"
TabIndex
=
"11"
Width
=
"195px"
>
<
EnabledStyle
HorizontalAlign
=
"Right"
/>
</
telerik:RadNumericTextBox
>
<
asp:RequiredFieldValidator
ID
=
"RequiredFieldValidator5"
runat
=
"server"
ControlToValidate
=
"txtTutarDolar"
Display
=
"Dynamic"
ErrorMessage
=
"*"
ForeColor
=
"Red"
ValidationGroup
=
"FormValidationGroup"
/>
</
td
>
</
tr
>
<
tr
>
<
td
>
İşlem
</
td
>
<
td
>
</
td
>
<
td
>
<
telerik:RadComboBox
ID
=
"cmbIslem"
runat
=
"server"
AppendDataBoundItems
=
"true"
SelectedValue='<%# DataBinder.Eval( Container, "DataItem.HAREKET_TIPI")%>'
DataSourceID="dsIslemTip" DataTextField="ADI" DataValueField="KOD" Width="200px"
Culture="tr-TR" TabIndex="4">
</
telerik:RadComboBox
>
</
td
>
<
td
>
</
td
>
<
td
>
Pasif
</
td
>
<
td
>
</
td
>
<
td
>
<
asp:CheckBox
ID
=
"chkPasif"
runat
=
"server"
Checked='<%# (DataBinder.Eval(Container,"DataItem.PASIF")) %>' TabIndex="13" />
</
td
>
</
tr
>
<
tr
>
<
td
>
Tahsilat Ülkesi
</
td
>
<
td
>
</
td
>
<
td
>
<
telerik:RadComboBox
ID
=
"cmbTahsilatUlke"
runat
=
"server"
AppendDataBoundItems
=
"true"
SelectedValue='<%# DataBinder.Eval( Container, "DataItem.ULKE_KODU")%>' DataSourceID="dsUlke"
DataTextField="ADI" DataValueField="KOD" Width="200px" Culture="tr-TR" TabIndex="5"
EnableAutomaticLoadOnDemand="False" EnableTextSelection="True" AllowCustomText="True">
</
telerik:RadComboBox
>
<
asp:RequiredFieldValidator
runat
=
"server"
ForeColor
=
"Red"
ID
=
"RequiredFieldValidator6"
ControlToValidate
=
"cmbTahsilatUlke"
Display
=
"Dynamic"
ErrorMessage
=
"*"
ValidationGroup
=
"FormValidationGroup"
/>
</
td
>
<
td
>
<
asp:Label
ID
=
"lblHareketID"
runat
=
"server"
Text='<%# DataBinder.Eval( Container, "DataItem.ID") %>'></
asp:Label
>
</
td
>
<
td
>
</
td
>
<
td
>
</
td
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
style
=
"width: 25px; vertical-align: middle;"
>
Açıklama
</
td
>
<
td
align
=
"left"
>
</
td
>
<
td
colspan
=
"5"
align
=
"left"
>
<
telerik:RadTextBox
ID
=
"txtAciklama"
runat
=
"server"
Text='<%# DataBinder.Eval( Container, "DataItem.ACIKLAMA") %>'
TextMode="MultiLine" TabIndex="14" Width="99%" MaxLength="150">
</
telerik:RadTextBox
>
</
td
>
</
tr
>
</
table
>
</
td
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
<
td
>
</
td
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
<
td
style
=
"border: 1px solid #f0f0f0;"
>
<
telerik:RadButton
ID
=
"btnUpdate"
Text
=
"Güncelle"
runat
=
"server"
CommandName
=
"Update"
Visible='<%# !(DataItem is Telerik.Web.UI.GridInsertionObject) %>' ValidationGroup="FormValidationGroup">
</
telerik:RadButton
>
<
telerik:RadButton
ID
=
"btnInsert"
Text
=
"Kaydet"
runat
=
"server"
CommandName
=
"PerformInsert"
Visible='<%# DataItem is Telerik.Web.UI.GridInsertionObject %>' ValidationGroup="FormValidationGroup">
</
telerik:RadButton
>
<
telerik:RadButton
ID
=
"btnCancel"
Text
=
"Kapat"
runat
=
"server"
CausesValidation
=
"False"
CommandName
=
"Cancel"
>
</
telerik:RadButton
>
</
td
>
<
td
>
</
td
>
</
tr
>
</
table
>
</
telerik:RadPageView
>
<
telerik:RadPageView
runat
=
"server"
ID
=
"Tutar_Giris"
>
<
table
width
=
"100%"
>
<
tr
>
<
td
>
</
td
>
<
td
>
</
td
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
<
td
>
<
table
style
=
"width: 100%; border: 1px solid #f0f0f0;"
>
<
tr
>
<
td
>
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
AllowAutomaticInserts
=
"True"
AllowAutomaticUpdates
=
"True"
CellSpacing
=
"0"
DataSourceID
=
"dsTutar"
GridLines
=
"None"
ShowFooter
=
"True"
>
<
ClientSettings
>
<
Selecting
AllowRowSelect
=
"True"
/>
</
ClientSettings
>
<
MasterTableView
AutoGenerateColumns
=
"False"
CommandItemDisplay
=
"Top"
DataKeyNames
=
"KOD"
DataSourceID
=
"dsTutar"
EditMode
=
"PopUp"
NoMasterRecordsText
=
"Gösterilecek kayıt bulunamadı."
Width
=
"100%"
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
AddNewRecordText
=
"Ekle"
RefreshText
=
"Yenile"
>
</
CommandItemSettings
>
<
RowIndicatorColumn
FilterControlAltText
=
"Filter RowIndicator column"
Visible
=
"True"
>
</
RowIndicatorColumn
>
<
ExpandCollapseColumn
FilterControlAltText
=
"Filter ExpandColumn column"
Visible
=
"True"
>
</
ExpandCollapseColumn
>
<
Columns
>
<
telerik:GridBoundColumn
DataField
=
"KOD"
DataType
=
"System.Int64"
FilterControlAltText
=
"Filter KOD column"
HeaderText
=
"KOD"
ReadOnly
=
"True"
SortExpression
=
"KOD"
UniqueName
=
"KOD"
Visible
=
"false"
>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"HAREKET_ID"
DataType
=
"System.Int64"
FilterControlAltText
=
"Filter HAREKET_ID column"
HeaderText
=
"HAREKET_ID"
SortExpression
=
"HAREKET_ID"
UniqueName
=
"HAREKET_ID"
>
</
telerik:GridBoundColumn
>
<
telerik:GridDropDownColumn
DataField
=
"DOVIZ"
FilterControlAltText
=
"Filter DOVIZ column"
HeaderText
=
"Döviz"
SortExpression
=
"DOVIZ"
UniqueName
=
"DOVIZ"
DataSourceID
=
"dsDoviz"
DataType
=
"System.String"
ListTextField
=
"PARA_BIRIM"
ListValueField
=
"PARA_BIRIM"
>
</
telerik:GridDropDownColumn
>
<
telerik:GridBoundColumn
DataField
=
"SOZLESME_TUTAR"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter SOZLESME_TUTAR column"
HeaderText
=
"Tahsilat Tutarı"
SortExpression
=
"SOZLESME_TUTAR"
UniqueName
=
"SOZLESME_TUTAR"
DataFormatString
=
"{0:N0}"
>
<
HeaderStyle
HorizontalAlign
=
"Right"
/>
<
FooterStyle
HorizontalAlign
=
"Right"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"YEREL_PARITE"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter YEREL_PARITE column"
HeaderText
=
"Yerel Parite"
SortExpression
=
"YEREL_PARITE"
UniqueName
=
"YEREL_PARITE"
DataFormatString
=
"{0:N4}"
>
<
HeaderStyle
HorizontalAlign
=
"Right"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"YEREL_TUTAR"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter YEREL_TUTAR column"
HeaderText
=
"Yerel Tutar"
SortExpression
=
"YEREL_TUTAR"
UniqueName
=
"YEREL_TUTAR"
DataFormatString
=
"{0:N0}"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:N0}"
ReadOnly
=
"true"
>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"True"
/>
<
HeaderStyle
HorizontalAlign
=
"Right"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"EUR_PARITE"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter EUR_PARITE column"
HeaderText
=
"EUR Parite"
SortExpression
=
"EUR_PARITE"
UniqueName
=
"EUR_PARITE"
DataFormatString
=
"{0:N4}"
>
<
HeaderStyle
HorizontalAlign
=
"Right"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"EUR_TUTAR"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter EUR_TUTAR column"
HeaderText
=
"EUR Tutar"
SortExpression
=
"EUR_TUTAR"
UniqueName
=
"EUR_TUTAR"
ReadOnly
=
"true"
DataFormatString
=
"{0:N0}"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:N0}"
>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"True"
/>
<
HeaderStyle
HorizontalAlign
=
"Right"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"USD_PARITE"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter USD_PARITE column"
HeaderText
=
"USD Parite"
SortExpression
=
"USD_PARITE"
UniqueName
=
"USD_PARITE"
DataFormatString
=
"{0:N4}"
>
<
HeaderStyle
HorizontalAlign
=
"Right"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"USD_TUTAR"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter USD_TUTAR column"
HeaderText
=
"USD Tutar"
SortExpression
=
"USD_TUTAR"
UniqueName
=
"USD_TUTAR"
ReadOnly
=
"true"
DataFormatString
=
"{0:N0}"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:N0}"
>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"True"
/>
<
HeaderStyle
HorizontalAlign
=
"Right"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"KDV_ORANI"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter KDV_ORANI column"
HeaderText
=
"Kdv Oranı"
SortExpression
=
"KDV_ORANI"
UniqueName
=
"KDV_ORANI"
DataFormatString
=
"{0:N0}"
>
<
HeaderStyle
HorizontalAlign
=
"Right"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"YEREL_TUTAR_KDVLI"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter YEREL_TUTAR_KDVLI column"
HeaderText
=
"Yerel Tutar + Kdv"
SortExpression
=
"YEREL_TUTAR_KDVLI"
UniqueName
=
"YEREL_TUTAR_KDVLI"
ReadOnly
=
"true"
DataFormatString
=
"{0:N0}"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:N0}"
>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"True"
/>
<
HeaderStyle
HorizontalAlign
=
"Right"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"EUR_TUTAR_KDVLI"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter EUR_TUTAR_KDVLI column"
HeaderText
=
"EUR Tutar + Kdv"
SortExpression
=
"EUR_TUTAR_KDVLI"
UniqueName
=
"EUR_TUTAR_KDVLI"
ReadOnly
=
"true"
DataFormatString
=
"{0:N0}"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:N0}"
>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"True"
/>
<
HeaderStyle
HorizontalAlign
=
"Right"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridBoundColumn
DataField
=
"USD_TUTAR_KDVLI"
DataType
=
"System.Double"
FilterControlAltText
=
"Filter USD_TUTAR_KDVLI column"
HeaderText
=
"USD Tutar + Kdv"
SortExpression
=
"USD_TUTAR_KDVLI"
UniqueName
=
"USD_TUTAR_KDVLI"
ReadOnly
=
"true"
DataFormatString
=
"{0:N0}"
Aggregate
=
"Sum"
FooterAggregateFormatString
=
"{0:N0}"
>
<
FooterStyle
HorizontalAlign
=
"Right"
Font-Bold
=
"True"
/>
<
HeaderStyle
HorizontalAlign
=
"Right"
/>
<
ItemStyle
HorizontalAlign
=
"Right"
/>
</
telerik:GridBoundColumn
>
<
telerik:GridEditCommandColumn
CancelText
=
"Kapat"
EditText
=
"Düzenle"
FilterControlAltText
=
"Filter EditCommandColumn column"
InsertText
=
"Kaydet"
UpdateText
=
"Güncelle"
>
<
ItemStyle
Width
=
"30px"
/>
</
telerik:GridEditCommandColumn
>
</
Columns
>
<
EditFormSettings
EditFormType
=
"Template"
InsertCaption
=
"Tutar Giriş"
CaptionFormatString
=
"Tutar Giriş"
>
<
FormTemplate
>
<
table
width
=
"100%"
>
<
tr
>
<
td
>
</
td
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
<
td
>
<
table
style
=
"width: 100%; border: 1px solid #f0f0f0;"
>
<
tr
>
<
td
style
=
"width: 160px;"
>
Döviz
</
td
>
<
td
style
=
"width: 160px;"
>
<
telerik:RadComboBox
ID
=
"cmbDoviz1"
runat
=
"server"
DataSourceID
=
"dsDoviz"
DataTextField
=
"PARA_BIRIM"
Filter
=
"Contains"
DataValueField
=
"PARA_BIRIM"
TabIndex
=
"2"
Width
=
"200px"
SelectedValue='<%# Bind("DOVIZ")%>'>
</
telerik:RadComboBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Tahsilat Tutarı
</
td
>
<
td
>
<
telerik:RadNumericTextBox
ID
=
"RadNumericTextBox3"
runat
=
"server"
DbValue='<%# Bind("SOZLESME_TUTAR")%>'
Width="195px" Culture="tr-TR" NumberFormat-DecimalDigits="0" TabIndex="3">
<
EnabledStyle
HorizontalAlign
=
"Right"
/>
</
telerik:RadNumericTextBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Yerel Parite
</
td
>
<
td
>
<
telerik:RadNumericTextBox
ID
=
"RadNumericTextBox1"
runat
=
"server"
DbValue='<%# Bind("YEREL_PARITE")%>'
Width="195px" Culture="tr-TR" NumberFormat-DecimalDigits="4" TabIndex="4">
<
EnabledStyle
HorizontalAlign
=
"Right"
/>
</
telerik:RadNumericTextBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
EUR Parite
</
td
>
<
td
>
<
telerik:RadNumericTextBox
ID
=
"RadNumericTextBox2"
runat
=
"server"
DbValue='<%# Bind("EUR_PARITE")%>'
Width="195px" Culture="tr-TR" NumberFormat-DecimalDigits="4" TabIndex="5">
<
EnabledStyle
HorizontalAlign
=
"Right"
/>
</
telerik:RadNumericTextBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
USD Parite
</
td
>
<
td
>
<
telerik:RadNumericTextBox
ID
=
"RadNumericTextBox4"
runat
=
"server"
DbValue='<%# Bind("USD_PARITE")%>'
Width="195px" Culture="tr-TR" NumberFormat-DecimalDigits="4" TabIndex="6">
<
EnabledStyle
HorizontalAlign
=
"Right"
/>
</
telerik:RadNumericTextBox
>
</
td
>
</
tr
>
<
tr
>
<
td
>
Kdv Oran
</
td
>
<
td
>
<
telerik:RadNumericTextBox
ID
=
"RadNumericTextBox5"
runat
=
"server"
DbValue='<%# Bind("KDV_ORANI")%>'
Width="195px" Culture="tr-TR" NumberFormat-DecimalDigits="0" TabIndex="7">
<
EnabledStyle
HorizontalAlign
=
"Right"
/>
</
telerik:RadNumericTextBox
>
</
td
>
</
tr
>
</
table
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
<
td
style
=
"border: 1px solid #f0f0f0;"
>
<
telerik:RadButton
ID
=
"btnUpdate9"
Text='<%# (Container is GridEditFormInsertItem) ? "Kaydet" : "Güncelle" %>'
runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'
TabIndex="8" ValidationGroup="FormValidationGroup">
</
telerik:RadButton
>
<
telerik:RadButton
ID
=
"btnCance9"
Text
=
"Kapat"
runat
=
"server"
CausesValidation
=
"False"
CommandName
=
"Cancel"
TabIndex
=
"9"
>
</
telerik:RadButton
>
</
td
>
</
tr
>
</
table
>
</
FormTemplate
>
<
EditColumn
FilterControlAltText
=
"Filter EditCommandColumn column"
CancelText
=
"Kapat"
InsertText
=
"Kaydet"
UpdateText
=
"Güncelle"
>
</
EditColumn
>
<
PopUpSettings
CloseButtonToolTip
=
"Kapat"
Width
=
"310px"
Height
=
"300px"
/>
</
EditFormSettings
>
</
MasterTableView
>
<
FilterMenu
EnableImageSprites
=
"False"
>
</
FilterMenu
>
</
telerik:RadGrid
>
</
td
>
</
tr
>
</
table
>
</
td
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
<
td
>
<
asp:SqlDataSource
ID
=
"dsTutar"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>"
DeleteCommand="DELETE FROM [HAREKET_TUTAR] WHERE [KOD] = @KOD"
InsertCommand="INSERT INTO HAREKET_TUTAR(HAREKET_ID, DOVIZ, SOZLESME_TUTAR, YEREL_PARITE, EUR_PARITE, USD_PARITE, KDV_ORANI) VALUES (@HAREKET_ID, @DOVIZ, @SOZLESME_TUTAR, @YEREL_PARITE, @EUR_PARITE, @USD_PARITE, @KDV_ORANI)"
SelectCommand="SELECT KOD, HAREKET_ID, DOVIZ, SOZLESME_TUTAR, YEREL_PARITE, YEREL_TUTAR, EUR_PARITE, EUR_TUTAR, USD_PARITE, USD_TUTAR, KDV_ORANI, YEREL_TUTAR_KDVLI, EUR_TUTAR_KDVLI, USD_TUTAR_KDVLI FROM HAREKET_TUTAR WHERE (HAREKET_ID = @HAREKET_ID)"
UpdateCommand="UPDATE HAREKET_TUTAR SET DOVIZ = @DOVIZ, SOZLESME_TUTAR = @SOZLESME_TUTAR, YEREL_PARITE = @YEREL_PARITE, EUR_PARITE = @EUR_PARITE, USD_PARITE = @USD_PARITE, KDV_ORANI = @KDV_ORANI WHERE (KOD = @KOD)">
<
DeleteParameters
>
<
asp:Parameter
Name
=
"KOD"
Type
=
"Int64"
/>
</
DeleteParameters
>
<
InsertParameters
>
<
asp:ControlParameter
ControlID
=
"lblHareketID"
Name
=
"HAREKET_ID"
PropertyName
=
"Text"
Type
=
"Int64"
/>
<
asp:Parameter
Name
=
"DOVIZ"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"SOZLESME_TUTAR"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"YEREL_PARITE"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"EUR_PARITE"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"USD_PARITE"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"KDV_ORANI"
Type
=
"Double"
/>
</
InsertParameters
>
<
SelectParameters
>
<
asp:ControlParameter
ControlID
=
"lblHareketID"
Name
=
"HAREKET_ID"
PropertyName
=
"Text"
/>
</
SelectParameters
>
<
UpdateParameters
>
<
asp:Parameter
Name
=
"DOVIZ"
Type
=
"String"
/>
<
asp:Parameter
Name
=
"SOZLESME_TUTAR"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"YEREL_PARITE"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"EUR_PARITE"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"USD_PARITE"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"KDV_ORANI"
Type
=
"Double"
/>
<
asp:Parameter
Name
=
"KOD"
Type
=
"Int64"
/>
</
UpdateParameters
>
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"dsDoviz"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>"
SelectCommand="SELECT [PARA_BIRIM] FROM [_ULKE] ORDER BY [ADI]"></
asp:SqlDataSource
>
</
td
>
<
td
>
</
td
>
</
tr
>
<
tr
>
<
td
>
</
td
>
<
td
style
=
"border: 1px solid #f0f0f0;"
>
</
td
>
<
td
>
</
td
>
</
tr
>
</
table
>
</
telerik:RadPageView
>
</
telerik:RadMultiPage
>
<
asp:SqlDataSource
ID
=
"dsParaBirim"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>"
SelectCommand="SELECT PARA_BIRIM AS PARABIRIM FROM _ULKE ORDER BY PARABIRIM">
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"dsProje"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>"
SelectCommand="SELECT KOD AS PROJEKOD, KISA_ADI FROM _PROJE WHERE (PASIF = 0) ORDER BY KISA_ADI">
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"dsUlke"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>"
SelectCommand="SELECT KOD, ADI FROM _ULKE WHERE (PASIF = 0) ORDER BY ADI"></
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"dsIslemTip"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>"
SelectCommand="SELECT KOD, ADI, PASIF FROM _HAREKET_TIPI WHERE (PASIF = 0) ORDER BY ADI">
</
asp:SqlDataSource
>
<
asp:SqlDataSource
ID
=
"dsIsveren"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>"
SelectCommand="SELECT _FIRMA.KOD, _FIRMA.ADI, _PROJE_ISVEREN.PROJE_KODU FROM _PROJE_ISVEREN INNER JOIN _FIRMA ON _PROJE_ISVEREN.FIRMA_KODU = _FIRMA.KOD WHERE (_PROJE_ISVEREN.PASIF = 0) AND (_PROJE_ISVEREN.PROJE_KODU = @PROJE)">
<
SelectParameters
>
<
asp:ControlParameter
ControlID
=
"cmbProje"
Name
=
"PROJE"
PropertyName
=
"SelectedValue"
/>
</
SelectParameters
>
</
asp:SqlDataSource
>