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>

