private void SistemKodlariniGetir() { try { WSSKRSSistemlerClient client = new WSSKRSSistemlerClient(); client.ClientCredentials.UserName.UserName = ConfigurationManager.AppSettings["KullaniciAdi"].ToString(); client.ClientCredentials.UserName.Password = ConfigurationManager.AppSettings["Sifre"].ToString(); client.Open(); DataGridViewRow dataGridViewRow = dgvSistemler.SelectedRows[0]; responseSistemler sistem = dataGridViewRow.DataBoundItem as responseSistemler; kodDegerleriResponse kodDegerleriResponse = new kodDegerleriResponse(); dgvSistemKodlari.DataSource = null; dgvSistemKodlari.Columns.Clear(); kodDegerleriResponse = client.SistemKodlari(sistem.kodu, DateTime.Now.AddDays(-100000)); if (kodDegerleriResponse.kodDegerleri != null) { TabloyuOlustur(kodDegerleriResponse.kodDegerleri); } } catch (Exception exception) { Console.WriteLine(exception); } }
private void button2_Click(object sender, EventArgs e) { try { Cursor.Current = Cursors.WaitCursor; WSSKRSSistemlerClient client = new WSSKRSSistemlerClient(); client.ClientCredentials.UserName.UserName = ConfigurationManager.AppSettings["KullaniciAdi"].ToString(); client.ClientCredentials.UserName.Password = ConfigurationManager.AppSettings["Sifre"].ToString(); client.Open(); wsskrsSistemlerResponse wsskrsSistemlerResponse = client.Sistemler(); List <responseSistemler> testList = new List <responseSistemler>(wsskrsSistemlerResponse.sistemler); dgvSistemler.DataSource = testList.OrderBy(z => z.adi).ToList(); dgvSistemler.AutoResizeColumns(); } catch (Exception exception) { Console.WriteLine(exception); } }
private void button5_Click(object sender, EventArgs e) { try { WSSKRSSistemlerClient client = new WSSKRSSistemlerClient(); client.ClientCredentials.UserName.UserName = ConfigurationManager.AppSettings["KullaniciAdi"].ToString(); client.ClientCredentials.UserName.Password = ConfigurationManager.AppSettings["Sifre"].ToString(); client.Open(); DataGridViewRow dataGridViewRow = dgvSistemler.SelectedRows[0]; responseSistemler sistem = dataGridViewRow.DataBoundItem as responseSistemler; kodDegerleriResponse kodDegerleriResponse = new kodDegerleriResponse(); long deger = 0; int sayac = 0; int sayac2 = 0; //Microsoft.Office.Interop.Excel.Application XcelApp = new Microsoft.Office.Interop.Excel.Application(); //XcelApp.Application.Workbooks.Add(Type.Missing); burasi: kodDegerleriResponse = client.SistemKodlariSayfaGetir(sistem.kodu, DateTime.Now.AddDays(-100000), Convert.ToInt32(deger)); // kodDegerleriResponse = client.SistemKodlariSayfaGetir("c3eade04-4f91-5dab-e043-14031b0ac9f9", DateTime.Now.AddDays(-100000), Convert.ToInt32(deger)); if (kodDegerleriResponse.kodDegerleri != null) { sayac++; if (sayac == 1) { //for (int index = 0; index < kodDegerleriResponse.kodDegerleri[0].Length ; index++) //{ // XcelApp.Cells[1, index + 1] = kodDegerleriResponse.kodDegerleri[0][index].kolonAdi; //} //XcelApp.Visible = true; //XcelApp.Columns.AutoFit(); } foreach (kodDegeriKolonu[] kodDegeriKolonus in kodDegerleriResponse.kodDegerleri) { //int sayac3 = 0; //sayac2++; //foreach (kodDegeriKolonu kodDegeriKolonu in kodDegeriKolonus) //{ // sayac3++; // if (kodDegeriKolonu.kolonIcerigi.Value != null) // { // XcelApp.Cells[sayac2 + 1, sayac3] = kodDegeriKolonu.kolonIcerigi.Value.ToString(); // } //} } //XcelApp.Columns.AutoFit(); deger = deger + 1000; goto burasi; } } catch (Exception exception) { Console.WriteLine(exception); } }