or
using
System;<br>
using
System.Collections.Generic;<br>
using
System.Linq;<br>
using
System.Web;<br>
using
System.Web.UI;<br>
using
System.Web.UI.WebControls;<br>
using
Telerik.Web.UI;<br>
using
System.Data.SqlClient;<br>
using
System.Data;<br>
using
System.Configuration;<br>
<br>
<br>
public
partial
class
kayi_firmalar : System.Web.UI.Page<br>
{<br>
protected
void
Page_Load(
object
sender, EventArgs e)<br>
{<br>
if
(!Page.IsPostBack)<br>
// Fill the continents combo.<br>
LoadUlke();<br>
else
if
(!Page.IsCallback)<br>
{<br>
// On regular postbacks restore the items of the related ComboBoxes.<br>
// Their selected items will be automatically restored from their ClientState.<br>
LoadSehir(cmbSehir.SelectedValue);<br>
}<br>
}<br>
protected
void
cmbKayit_SelectedIndexChanged(
object
sender, Telerik.Web.UI.RadComboBoxSelectedIndexChangedEventArgs e)<br>
{<br>
dsFirma.DataBind();<br>
}<br>
<br>
<br>
protected
void
LoadUlke()<br>
{<br>
SqlConnection connection =
new
SqlConnection(<br>
ConfigurationManager.ConnectionStrings[
"DASHBOARD_KAYIConnectionString"
].ConnectionString);<br>
<br>
<br>
SqlDataAdapter adapter =
new
SqlDataAdapter(
"SELECT * FROM _ULKKE ORDER By ADI"
, connection);<br>
DataTable dt =
new
DataTable();<br>
adapter.Fill(dt);<br>
<br>
<br>
cmbUlke.DataTextField =
"ADI"
;<br>
cmbUlke.DataValueField =
"KOD"
;<br>
cmbUlke.DataSource = dt;<br>
cmbUlke.DataBind();<br>
// Insert the first item.<br>
cmbUlke.Items.Insert(0,
new
RadComboBoxItem(
"- Ülke Seçiniz... -"
));<br>
}<br>
<br>
<br>
protected
void
LoadSehir(
string
ulke_kodu)<br>
{<br>
SqlConnection connection =
new
SqlConnection(<br>
ConfigurationManager.ConnectionStrings[
"DASHBOARD_KAYIConnectionString"
].ConnectionString);<br>
<br>
<br>
// Select a country based on the continentID.<br>
SqlDataAdapter adapter =
new
SqlDataAdapter(
"SELECT * FROM _SEHIR WHERE ULKE_KOD=@ULKE_KOD ORDER By ADI"
, connection);<br>
adapter.SelectCommand.Parameters.AddWithValue(
"@ULKE_KOD"
, ulke_kodu);<br>
<br>
<br>
DataTable dt =
new
DataTable();<br>
adapter.Fill(dt);<br>
<br>
<br>
cmbSehir.DataTextField =
"ADI"
;<br>
cmbSehir.DataValueField =
"KOD"
;<br>
cmbSehir.DataSource = dt;<br>
cmbSehir.DataBind();<br>
}<br>
<br>
<br>
<br>
<br>
<br>
<br>
protected
void
cmbUlke_ItemsRequested(
object
o, RadComboBoxItemsRequestedEventArgs e)<br>
{<br>
LoadUlke();<br>
}<br>
<br>
<br>
protected
void
cmbSehir_ItemsRequested(
object
o, RadComboBoxItemsRequestedEventArgs e)<br>
{<br>
LoadSehir(e.Text);<br>
}<br>
<br>
<br>
}
<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true"<
br
>
CodeFile="kayi_firmalar.aspx.cs" Inherits="kayi_firmalar" %><
br
>
<
br
>
<
br
>
<
asp:Content
ID
=
"Content1"
ContentPlaceHolderID
=
"head"
runat
=
"Server"
><
br
>
<
style
type
=
"text/css"
><
br
>
<
br
>
</
style
><
br
>
<
title
>Kayı Grup Şirketleri</
title
><
br
>
</
asp:Content
><
br
>
<
asp:Content
ID
=
"Content2"
ContentPlaceHolderID
=
"ContentPlaceHolder1"
runat
=
"Server"
><
br
>
<
table
><
br
>
<
tr
><
br
>
<
td
style
=
"width: 70px"
><
br
>
<
asp:Label
ID
=
"Label3"
runat
=
"server"
Style
=
"font-family: Verdana; font-size: xx-small"
<br>
Text="Kayıt Durumu"></
asp:Label
><
br
>
</
td
><
br
>
<
td
><
br
>
<
telerik:RadComboBox
ID
=
"cmbKayit"
runat
=
"server"
AutoPostBack
=
"True"
OnSelectedIndexChanged
=
"cmbKayit_SelectedIndexChanged"
><
br
>
<
Items
><
br
>
<
telerik:RadComboBoxItem
runat
=
"server"
Text
=
"Aktif"
Value
=
"0"
Owner
=
"cmbKayit"
/><
br
>
<
telerik:RadComboBoxItem
runat
=
"server"
Text
=
"Pasif"
Value
=
"1"
Owner
=
"cmbKayit"
/><
br
>
</
Items
><
br
>
</
telerik:RadComboBox
><
br
>
</
td
><
br
>
</
tr
><
br
>
</
table
><
br
>
<
table
width
=
"100%"
><
br
>
<
tr
><
br
>
<
td
style
=
"border: 1px solid #f0f0f0; text-align: center;"
><
br
>
<
asp:Label
ID
=
"Label5"
runat
=
"server"
Style="font-size: small; font-family: Verdana;<br>
font-weight: 700; color: #800000; text-align: center;" Text="Kayı Grup Şirketleri"></
asp:Label
><
br
>
</
td
><
br
>
</
tr
><
br
>
</
table
><
br
>
<
telerik:RadGrid
ID
=
"RadGrid1"
runat
=
"server"
AllowAutomaticInserts
=
"True"
AllowAutomaticUpdates
=
"True"
<br>
CellSpacing="0" DataSourceID="dsFirma" GridLines="None" AllowSorting="True" ShowGroupPanel="True"<
br
>
AllowPaging="True" AllowFilteringByColumn="True" Width="100%"><
br
>
<
ClientSettings
><
br
>
<
Selecting
AllowRowSelect
=
"True"
></
Selecting
><
br
>
<
Scrolling
UseStaticHeaders
=
"true"
/><
br
>
</
ClientSettings
><
br
>
<
ClientSettings
AllowDragToGroup
=
"True"
><
br
>
<
Selecting
AllowRowSelect
=
"True"
/><
br
>
<
Selecting
AllowRowSelect
=
"True"
></
Selecting
><
br
>
<
Scrolling
UseStaticHeaders
=
"True"
></
Scrolling
><
br
>
</
ClientSettings
><
br
>
<
GroupPanel
Text
=
"Gruplamak istediğiniz kolonu buraya sürükleyiniz."
><
br
>
</
GroupPanel
><
br
>
<
MasterTableView
AutoGenerateColumns
=
"False"
CommandItemDisplay
=
"Top"
DataKeyNames
=
"KOD"
<br>
DataSourceID="dsFirma" EditMode="PopUp" NoMasterRecordsText="Gösterilecek kayıt bulunamadı."<
br
>
HorizontalAlign="Center"><
br
>
<
CommandItemSettings
ExportToPdfText
=
"Export to PDF"
AddNewRecordText
=
"Ekle"
RefreshText
=
"Yenile"
><
br
>
</
CommandItemSettings
><
br
>
<
RowIndicatorColumn
Visible
=
"True"
FilterControlAltText
=
"Filter RowIndicator column"
><
br
>
</
RowIndicatorColumn
><
br
>
<
ExpandCollapseColumn
Visible
=
"True"
FilterControlAltText
=
"Filter ExpandColumn column"
><
br
>
</
ExpandCollapseColumn
><
br
>
<
Columns
><
br
>
<
telerik:GridEditCommandColumn
ButtonType
=
"ImageButton"
EditText
=
"Düzenle"
FilterControlAltText
=
"Filter EditCommandColumn column"
><
br
>
<
FooterStyle
Font-Bold
=
"True"
/><
br
>
<
ItemStyle
HorizontalAlign
=
"Center"
Width
=
"20px"
/><
br
>
</
telerik:GridEditCommandColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"KOD"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter KOD column"
<br>
HeaderText="KOD" ReadOnly="True" SortExpression="KOD" UniqueName="KOD" Visible="False"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"ADI"
FilterControlAltText
=
"Filter ADI column"
<br>
HeaderText="Adı" SortExpression="ADI" UniqueName="ADI"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"ULKE_LBL"
FilterControlAltText
=
"Filter ULKE_LBL column"
<br>
HeaderText="Ülke" SortExpression="ULKE_LBL" UniqueName="ULKE_LBL"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"SEHIR_LBL"
FilterControlAltText
=
"Filter SEHIR_LBL column"
<br>
HeaderText="Şehir" SortExpression="SEHIR_LBL" UniqueName="SEHIR_LBL"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridCheckBoxColumn
DataField
=
"MUTEAHHIT"
DataType
=
"System.Boolean"
FilterControlAltText
=
"Filter MUTEAHHIT column"
<br>
HeaderText="Müteahhit" SortExpression="MUTEAHHIT" UniqueName="MUTEAHHIT" DefaultInsertValue="true"<
br
>
Visible="False"><
br
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/><
br
>
<
ItemStyle
HorizontalAlign
=
"Center"
Width
=
"50px"
/><
br
>
</
telerik:GridCheckBoxColumn
><
br
>
<
telerik:GridCheckBoxColumn
DataField
=
"YUKLENICI"
DataType
=
"System.Boolean"
FilterControlAltText
=
"Filter YUKLENICI column"
<br>
HeaderText="Yüklenici" SortExpression="YUKLENICI" UniqueName="YUKLENICI" DefaultInsertValue="false"<
br
>
Visible="False"><
br
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/><
br
>
<
ItemStyle
HorizontalAlign
=
"Center"
Width
=
"50px"
/><
br
>
</
telerik:GridCheckBoxColumn
><
br
>
<
telerik:GridCheckBoxColumn
DataField
=
"ISVEREN"
DataType
=
"System.Boolean"
FilterControlAltText
=
"Filter ISVEREN column"
<br>
HeaderText="İşveren" SortExpression="ISVEREN" UniqueName="ISVEREN" DefaultInsertValue="false"<
br
>
Visible="False"><
br
>
<
HeaderStyle
HorizontalAlign
=
"Center"
/><
br
>
<
ItemStyle
HorizontalAlign
=
"Center"
Width
=
"50px"
/><
br
>
</
telerik:GridCheckBoxColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"ULKE_KODU"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter ULKE_KODU column"
<br>
HeaderText="ULKE_KODU" SortExpression="ULKE_KODU" UniqueName="ULKE_KODU" Visible="False"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"SEHIR_KODU"
DataType
=
"System.Int32"
FilterControlAltText
=
"Filter SEHIR_KODU column"
<br>
HeaderText="SEHIR_KODU" SortExpression="SEHIR_KODU" UniqueName="SEHIR_KODU" Visible="False"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"ADRES"
FilterControlAltText
=
"Filter ADRES column"
<br>
HeaderText="ADRES" SortExpression="ADRES" UniqueName="ADRES" Visible="False"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"ACIKLAMA"
FilterControlAltText
=
"Filter ACIKLAMA column"
<br>
HeaderText="ACIKLAMA" SortExpression="ACIKLAMA" UniqueName="ACIKLAMA" Visible="False"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"OZEL1"
FilterControlAltText
=
"Filter OZEL1 column"
<br>
HeaderText="OZEL1" SortExpression="OZEL1" UniqueName="OZEL1" Visible="False"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"OZEL2"
FilterControlAltText
=
"Filter OZEL2 column"
<br>
HeaderText="OZEL2" SortExpression="OZEL2" UniqueName="OZEL2" Visible="False"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"OZEL3"
FilterControlAltText
=
"Filter OZEL3 column"
<br>
HeaderText="OZEL3" SortExpression="OZEL3" UniqueName="OZEL3" Visible="False"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"OZEL4"
FilterControlAltText
=
"Filter OZEL4 column"
<br>
HeaderText="OZEL4" SortExpression="OZEL4" UniqueName="OZEL4" Visible="False"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridBoundColumn
DataField
=
"ERP_KODU"
FilterControlAltText
=
"Filter ERP_KODU column"
<br>
HeaderText="ERP_KODU" SortExpression="ERP_KODU" UniqueName="ERP_KODU" Visible="False"><
br
>
</
telerik:GridBoundColumn
><
br
>
<
telerik:GridCheckBoxColumn
DataField
=
"PASIF"
DataType
=
"System.Boolean"
FilterControlAltText
=
"Filter PASIF column"
<br>
HeaderText="PASIF" SortExpression="PASIF" UniqueName="PASIF" Visible="False"<
br
>
DefaultInsertValue="false"><
br
>
</
telerik:GridCheckBoxColumn
><
br
>
</
Columns
><
br
>
<
EditFormSettings
EditFormType
=
"Template"
InsertCaption
=
"Kayı Grup Şirketleri"
CaptionFormatString
=
"Kayı Grup Şirketleri"
><
br
>
<
FormTemplate
><
br
>
<
table
width
=
"100%"
><
br
>
<
tr
><
br
>
<
td
><
br
>
<
br
>
</
td
><
br
>
<
td
><
br
>
<
br
>
</
td
><
br
>
<
td
><
br
>
<
br
>
</
td
><
br
>
</
tr
><
br
>
<
tr
><
br
>
<
td
><
br
>
</
td
><
br
>
<
td
><
br
>
<
table
style
=
"width: 100%; border: 1px solid #f0f0f0;"
><
br
>
<
tr
><
br
>
<
td
style
=
"width: 160px;"
><
br
>
Adı<
br
>
</
td
><
br
>
<
td
style
=
"width: 160px;"
><
br
>
<
telerik:RadTextBox
ID
=
"txtAdi"
runat
=
"server"
Text='<%# Bind("ADI") %>' Width="195px"<
br
>
TabIndex="1" MaxLength="100"><
br
>
</
telerik:RadTextBox
><
br
>
<
asp:RequiredFieldValidator
runat
=
"server"
ForeColor
=
"Red"
ID
=
"RequiredFieldValidator5"
<br>
ControlToValidate="txtAdi" Display="Dynamic" ErrorMessage="*" ValidationGroup="FormValidationGroup" /><
br
>
</
td
><
br
>
<
td
style
=
"width: 150px;"
><
br
>
</
td
><
br
>
<
td
style
=
"width: 160px;"
rowspan
=
"2"
><
br
>
Açıklama<
br
>
</
td
><
br
>
<
td
style
=
"width: 160px;"
rowspan
=
"2"
><
br
>
<
telerik:RadTextBox
ID
=
"txtAciklama"
runat
=
"server"
Text='<%# Bind("ACIKLAMA") %>'<
br
>
Width="195px" TabIndex="6" TextMode="MultiLine" MaxLength="150"><
br
>
</
telerik:RadTextBox
><
br
>
</
td
><
br
>
</
tr
><
br
>
<
tr
><
br
>
<
td
><
br
>
Ülke<
br
>
</
td
><
br
>
<
td
><
br
>
<
telerik:RadComboBox
ID
=
"cmbUlke"
runat
=
"server"
AppendDataBoundItems
=
"true"
SelectedValue='<%# Bind("ULKE_KODU")%>'<
br
>
DataSourceID="dsUlke" DataTextField="ADI" DataValueField="KOD" Width="200px"<
br
>
Culture="tr-TR" TabIndex="2"><
br
>
</
telerik:RadComboBox
><
br
>
</
td
><
br
>
<
td
><
br
>
</
td
><
br
>
</
tr
><
br
>
<
tr
><
br
>
<
td
><
br
>
Şehir<
br
>
</
td
><
br
>
<
td
><
br
>
<
telerik:RadComboBox
ID
=
"cmbSehir"
runat
=
"server"
AppendDataBoundItems
=
"true"
SelectedValue='<%# Bind("SEHIR_KODU")%>'<
br
>
DataSourceID="dsSehir" DataTextField="ADI" DataValueField="KOD" Width="200px"<
br
>
Culture="tr-TR" TabIndex="3"><
br
>
</
telerik:RadComboBox
><
br
>
</
td
><
br
>
<
td
><
br
>
</
td
><
br
>
<
td
rowspan
=
"3"
><
br
>
Adres<
br
>
</
td
><
br
>
<
td
rowspan
=
"3"
><
br
>
<
telerik:RadTextBox
ID
=
"txtAdres"
runat
=
"server"
Text='<%# Bind("ADRES") %>' Width="195px"<
br
>
TabIndex="7" TextMode="MultiLine" Height="60px" MaxLength="200"><
br
>
</
telerik:RadTextBox
><
br
>
</
td
><
br
>
</
tr
><
br
>
<
tr
><
br
>
<
td
><
br
>
Muhasebe Kodu<
br
>
</
td
><
br
>
<
td
><
br
>
<
telerik:RadTextBox
ID
=
"txtMuhasebeKodu"
runat
=
"server"
Text='<%# Bind("ERP_KODU") %>'<
br
>
Width="195px" TabIndex="4"><
br
>
</
telerik:RadTextBox
><
br
>
</
td
><
br
>
<
td
><
br
>
</
td
><
br
>
</
tr
><
br
>
<
tr
><
br
>
<
td
><
br
>
Pasif<
br
>
</
td
><
br
>
<
td
><
br
>
<
asp:CheckBox
ID
=
"chkPasif"
runat
=
"server"
Checked='<%#Bind("PASIF") %>' TabIndex="5" /><
br
>
</
td
><
br
>
<
td
><
br
>
</
td
><
br
>
</
tr
><
br
>
</
table
><
br
>
</
td
><
br
>
<
td
><
br
>
</
td
><
br
>
</
tr
><
br
>
<
tr
><
br
>
<
td
><
br
>
<
br
>
</
td
><
br
>
<
td
><
br
>
<
br
>
</
td
><
br
>
<
td
><
br
>
<
br
>
</
td
><
br
>
</
tr
><
br
>
<
tr
><
br
>
<
td
><
br
>
</
td
><
br
>
<
td
style
=
"border: 1px solid #f0f0f0;"
><
br
>
<
telerik:RadButton
ID
=
"btnUpdate"
Text='<%# (Container is GridEditFormInsertItem) ? "Kaydet" : "Güncelle" %>'<
br
>
runat="server" CommandName='<%# (Container is GridEditFormInsertItem) ? "PerformInsert" : "Update" %>'<
br
>
TabIndex="8" ValidationGroup="FormValidationGroup"><
br
>
</
telerik:RadButton
><
br
>
<
br
>
<
telerik:RadButton
ID
=
"btnCancel"
Text
=
"Vazgeç"
runat
=
"server"
CausesValidation
=
"False"
<br>
CommandName="Cancel" TabIndex="9"><
br
>
</
telerik:RadButton
><
br
>
</
td
><
br
>
<
td
><
br
>
</
td
><
br
>
</
tr
><
br
>
</
table
><
br
>
</
FormTemplate
><
br
>
<
FormTableItemStyle
Wrap
=
"False"
></
FormTableItemStyle
><
br
>
<
FormCaptionStyle
CssClass
=
"EditFormHeader"
></
FormCaptionStyle
><
br
>
<
FormMainTableStyle
GridLines
=
"None"
CellSpacing
=
"0"
CellPadding
=
"3"
BackColor
=
"White"
<br>
Width="100%" /><
br
>
<
EditColumn
UniqueName
=
"EditCommandColumn1"
FilterControlAltText
=
"Filter EditCommandColumn1 column"
><
br
>
</
EditColumn
><
br
>
<
FormTableStyle
CellSpacing
=
"0"
CellPadding
=
"2"
Height
=
"110px"
BackColor
=
"White"
/><
br
>
<
FormTableAlternatingItemStyle
Wrap
=
"False"
></
FormTableAlternatingItemStyle
><
br
>
<
FormTableButtonRowStyle
HorizontalAlign
=
"Right"
CssClass
=
"EditFormButtonRow"
></
FormTableButtonRowStyle
><
br
>
<
PopUpSettings
CloseButtonToolTip
=
"Kapat"
ScrollBars
=
"Auto"
Width
=
"720px"
Height
=
"260px"
/><
br
>
</
EditFormSettings
><
br
>
</
MasterTableView
><
br
>
<
FilterMenu
EnableImageSprites
=
"False"
><
br
>
</
FilterMenu
><
br
>
</
telerik:RadGrid
><
br
>
<
asp:SqlDataSource
ID
=
"dsFirma"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>"<
br
>
DeleteCommand="DELETE FROM [_FIRMA] WHERE [KOD] = @KOD" InsertCommand="INSERT INTO _FIRMA(ADI, MUTEAHHIT, ULKE_KODU, SEHIR_KODU, ADRES, ACIKLAMA, ERP_KODU, PASIF) VALUES (@ADI, 1, @ULKE_KODU, @SEHIR_KODU, @ADRES, @ACIKLAMA, @ERP_KODU, @PASIF)"<
br
>
SelectCommand="SELECT _FIRMA.KOD, _FIRMA.ADI, _FIRMA.MUTEAHHIT, _FIRMA.YUKLENICI, _FIRMA.ISVEREN, _FIRMA.ULKE_KODU, _FIRMA.SEHIR_KODU, _FIRMA.ADRES, _FIRMA.ACIKLAMA, _FIRMA.ERP_KODU, _FIRMA.PASIF, _ULKE.ADI AS ULKE_LBL, _SEHIR.ADI AS SEHIR_LBL FROM _FIRMA LEFT OUTER JOIN _SEHIR ON _FIRMA.SEHIR_KODU = _SEHIR.KOD LEFT OUTER JOIN _ULKE ON _FIRMA.ULKE_KODU = _ULKE.KOD WHERE (_FIRMA.PASIF = @PASIF) ORDER BY _FIRMA.ADI"<
br
>
<
br
>
UpdateCommand="UPDATE _FIRMA SET ADI = @ADI, MUTEAHHIT = 1, ULKE_KODU = @ULKE_KODU, SEHIR_KODU = @SEHIR_KODU, ADRES = @ADRES, ACIKLAMA = @ACIKLAMA, ERP_KODU = @ERP_KODU, PASIF = @PASIF WHERE (KOD = @KOD)"><
br
>
<
DeleteParameters
><
br
>
<
asp:Parameter
Name
=
"KOD"
Type
=
"Int32"
/><
br
>
</
DeleteParameters
><
br
>
<
InsertParameters
><
br
>
<
asp:Parameter
Name
=
"ADI"
Type
=
"String"
/><
br
>
<
asp:Parameter
Name
=
"MUTEAHHIT"
Type
=
"Boolean"
/><
br
>
<
asp:Parameter
Name
=
"YUKLENICI"
Type
=
"Boolean"
/><
br
>
<
asp:Parameter
Name
=
"ISVEREN"
Type
=
"Boolean"
/><
br
>
<
asp:Parameter
Name
=
"ULKE_KODU"
Type
=
"Int32"
/><
br
>
<
asp:Parameter
Name
=
"SEHIR_KODU"
Type
=
"Int32"
/><
br
>
<
asp:Parameter
Name
=
"ADRES"
Type
=
"String"
/><
br
>
<
asp:Parameter
Name
=
"ACIKLAMA"
Type
=
"String"
/><
br
>
<
asp:Parameter
Name
=
"ERP_KODU"
Type
=
"String"
/><
br
>
<
asp:Parameter
Name
=
"PASIF"
Type
=
"Boolean"
/><
br
>
</
InsertParameters
><
br
>
<
SelectParameters
><
br
>
<
asp:ControlParameter
ControlID
=
"cmbKayit"
Name
=
"PASIF"
PropertyName
=
"SelectedValue"
/><
br
>
</
SelectParameters
><
br
>
<
UpdateParameters
><
br
>
<
asp:Parameter
Name
=
"ADI"
Type
=
"String"
/><
br
>
<
asp:Parameter
Name
=
"MUTEAHHIT"
Type
=
"Boolean"
/><
br
>
<
asp:Parameter
Name
=
"YUKLENICI"
Type
=
"Boolean"
/><
br
>
<
asp:Parameter
Name
=
"ISVEREN"
Type
=
"Boolean"
/><
br
>
<
asp:Parameter
Name
=
"ULKE_KODU"
Type
=
"Int32"
/><
br
>
<
asp:Parameter
Name
=
"SEHIR_KODU"
Type
=
"Int32"
/><
br
>
<
asp:Parameter
Name
=
"ADRES"
Type
=
"String"
/><
br
>
<
asp:Parameter
Name
=
"ACIKLAMA"
Type
=
"String"
/><
br
>
<
asp:Parameter
Name
=
"ERP_KODU"
Type
=
"String"
/><
br
>
<
asp:Parameter
Name
=
"PASIF"
Type
=
"Boolean"
/><
br
>
<
asp:Parameter
Name
=
"KOD"
Type
=
"Int32"
/><
br
>
</
UpdateParameters
><
br
>
</
asp:SqlDataSource
><
br
>
<
asp:SqlDataSource
ID
=
"dsUlke"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>"<
br
>
SelectCommand="SELECT KOD, ADI, PARA_BIRIM, PASIF FROM _ULKE WHERE (PASIF = 0) ORDER BY ADI"><
br
>
</
asp:SqlDataSource
><
br
>
<
asp:SqlDataSource
ID
=
"dsSehir"
runat
=
"server"
ConnectionString="<%$ ConnectionStrings:DASHBOARD_KAYIConnectionString %>"<
br
>
<
br
>
<
br
>
SelectCommand="SELECT KOD, ULKE_KOD, ADI, PASIF FROM _SEHIR WHERE (PASIF = 0) ORDER BY ADI"><
br
>
</
asp:SqlDataSource
><
br
>
</
asp:Content
><
br
>
<
div
></
div
>