public List <DTOTanimDetay> sorulistele() { List <DTOTanimDetay> sorulistesi = new List <DTOTanimDetay>(); if (Globals.Globals.con.State == System.Data.ConnectionState.Closed) { Globals.Globals.con.Open(); } MySqlCommand cmd = new MySqlCommand("select * from sgt_tanimdetay where tanim_id in ('4')", Globals.Globals.con); var rd = cmd.ExecuteReader(); while (rd.Read()) { //AÇIKLAMA: Detay1 : Tanim Kodu, Detay2 : Tanim Adi, Detay3 : Soru Adi , Detay4: İnput Tipi DTOTanimDetay detay = new DTOTanimDetay(); detay.id = Convert.ToInt16(rd.GetString("id")); detay.Detay1 = rd.GetString("detay1"); detay.Detay2 = rd.GetString("detay2"); detay.Detay3 = rd.GetString("detay3"); detay.Detay4 = rd.GetString("detay4"); detay.Detay5 = rd.GetString("detay5"); sorulistesi.Add(detay); } Globals.Globals.con.Close(); return(sorulistesi); }
public JsonResult DuzenleComponent(DTOTanimDetay detay) { detay.id = Globals.Globals.duzenleid; SComponentDuzenle servicecomponentduzenle = new SComponentDuzenle(); servicecomponentduzenle.componentduzenle(detay); return(Json(detay)); }
public ActionResult Duzenle(DTOTanimDetay dTO) { dTO.id = Globals.Globals.duzenleid; SDuzenleUrun serviceduzenle = new SDuzenleUrun(); serviceduzenle.Duzenle(dTO); return(View("UrunTanimi")); }
//Soruyu Duzenler public JsonResult DuzenleSoru(DTOTanimDetay detay) { detay.id = Globals.Globals.duzenleid; SSoruDuzenle servicesoruduzenle = new SSoruDuzenle(); servicesoruduzenle.soruduzenle(detay); return(Json(detay)); }
//Cevabı Duzenler public JsonResult DuzenleCevap(DTOTanimDetay detay) { detay.id = Globals.Globals.duzenleid; SCevapDuzenle servicecevapduzenle = new SCevapDuzenle(); servicecevapduzenle.CevapDuzenle(detay); return(Json(detay)); }
public void guncellecomponent(DTOTanimDetay detay) { if (Globals.Globals.con.State == System.Data.ConnectionState.Closed) { Globals.Globals.con.Open(); } MySqlCommand cmd = new MySqlCommand("update sgt_tanimdetay set Detay1='" + detay.Detay1 + "' where id='" + detay.id + "'", Globals.Globals.con); cmd.ExecuteNonQuery(); Globals.Globals.con.Close(); }
public void guncelleurun(DTOTanimDetay detay) { if (Globals.Globals.con.State == System.Data.ConnectionState.Closed) { Globals.Globals.con.Open(); } MySqlCommand cmd = new MySqlCommand("update sgt_tanimdetay set Detay1='" + detay.Detay1 + "',Detay2='" + detay.Detay2 + "',Detay3='" + detay.Detay3 + "',Detay4='" + detay.Detay4 + "',Detay5='" + detay.Detay5 + "',Detay6='" + detay.Detay6 + "',Detay7='" + detay.Detay7 + "',Detay8='" + detay.Detay8 + "',Detay9='" + detay.Detay9 + "',Detay10='" + detay.Detay10 + "' where id='" + detay.id + "'", Globals.Globals.con); cmd.ExecuteNonQuery(); Globals.Globals.con.Close(); }
//Soruları Kaydeder. public JsonResult SoruKaydet(DTOTanimDetay detay) { if (detay.Detay1 != null && detay.Detay2 != null && detay.Detay3 != null && detay.Detay4 != null && detay.Detay5 != null) { SSoruKaydet servicesorukaydet = new SSoruKaydet(); servicesorukaydet.sorukaydet(detay); return(Json(detay)); } else { return(Json("boş")); } }
//Cevap Kaydeder. public JsonResult CevapKaydet(DTOTanimDetay detay) { if (detay.Detay1 != null && detay.Detay2 != null && detay.Detay3 != null && detay.Detay4 != null) { SCevapEkle servicecevapekle = new SCevapEkle(); servicecevapekle.EkleCevap(detay); return(Json(detay)); } else { return(Json("boş")); } }
//Component Ekler. public JsonResult ComponentKaydet(DTOTanimDetay detay) { if (detay.Detay1 != null) { SComponentKaydet servicecomponentkaydet = new SComponentKaydet(); servicecomponentkaydet.componentekle(detay); return(Json(detay)); } else { return(Json("boş")); } }
//Düzenlenen Sorunun Verilerini Getir-Götür İşlemi public JsonResult DuzenleGetirSoru(int id) { Globals.Globals.duzenleid = id; SSoruListele servicesoru = new SSoruListele(); DTOTanimDetay detay = new DTOTanimDetay(); foreach (var item in servicesoru.soruistele()) { if (item.id == id) { detay = item; } } return(Json(detay)); }
//Düzenlenen Ürünün Verilerini Getir-Götür işlemi public JsonResult DuzenleGetirUrun(int id) { Globals.Globals.duzenleid = id; SUrunListele serviceurun = new SUrunListele(); DTOTanimDetay detay = new DTOTanimDetay(); foreach (var item in serviceurun.listeleurun()) { if (item.id == id) { detay = item; } } return(Json(detay)); }
//Düzenlenen Sorunun Verilerini Getir-Götür işlemi public JsonResult DuzenleGetirComponent(int id) { Globals.Globals.duzenleid = id; SComponentListele servicecomponent = new SComponentListele(); DTOTanimDetay detay = new DTOTanimDetay(); foreach (var item in servicecomponent.componentlistele()) { if (item.id == id) { detay = item; } } return(Json(detay)); }
//Düzenlenen Sorunun Verilerini Getir-Götür işlemi public JsonResult DuzenleGetirCevap(int id) { Globals.Globals.duzenleid = id; SCevapListele servicecevap = new SCevapListele(); DTOTanimDetay detay = new DTOTanimDetay(); foreach (var item in servicecevap.cevaplistesi()) { if (item.id == id) { detay = item; } } return(Json(detay)); }
public List <string> CevapGetir(DTOTanimDetay detay) { List <String> cevaplistesi = new List <String>(); if (Globals.Globals.con.State == System.Data.ConnectionState.Closed) { Globals.Globals.con.Open(); } MySqlCommand cmd = new MySqlCommand("select Detay4 from sgt_tanimdetay where Detay3='" + detay.Detay3 + "' and tanim_id='5' ", Globals.Globals.con); var rd = cmd.ExecuteReader(); while (rd.Read()) { cevaplistesi.Add(rd.GetString(0)); } Globals.Globals.con.Close(); return(cevaplistesi); }
public List <DTOTanimDetay> componentlistele() { if (Globals.Globals.con.State == System.Data.ConnectionState.Closed) { Globals.Globals.con.Open(); } MySqlCommand cmd = new MySqlCommand("select id,detay1 from sgt_tanimdetay where tanim_id='6'", Globals.Globals.con); List <DTOTanimDetay> componentlistesi = new List <DTOTanimDetay>(); var rd = cmd.ExecuteReader(); while (rd.Read()) { DTOTanimDetay detay = new DTOTanimDetay(); detay.id = Convert.ToInt16(rd.GetString("id")); detay.Detay1 = rd.GetString("Detay1"); componentlistesi.Add(detay); } Globals.Globals.con.Close(); return(componentlistesi); }
public void sorukaydet(DTOTanimDetay detay) { if (Globals.Globals.con.State == System.Data.ConnectionState.Closed) { Globals.Globals.con.Open(); } MySqlCommand cmd = new MySqlCommand("insert into sgt_tanimdetay(tanim_id, Detay1, Detay2, Detay3, Detay4,Detay5) values('4', '" + detay.Detay1 + "', '" + detay.Detay2 + "', '" + detay.Detay3 + "', '" + detay.Detay4 + "','" + detay.Detay5 + "')", Globals.Globals.con); cmd.ExecuteNonQuery(); cmd = new MySqlCommand("select max(id) from sgt_tanimdetay", Globals.Globals.con); var rd = cmd.ExecuteReader(); int tanimdetay_id = 0; while (rd.Read()) { tanimdetay_id = Convert.ToInt16(rd.GetString(0)); } rd.Close(); cmd = new MySqlCommand("insert into `sgt_tanimdetayaciklamasi`(`tanimdetay_id`,`Detay1`,`Detay2`,`Detay3`,`Detay4`,`Detay5`,`Detay6`,`Detay7`,`Detay8`,`Detay9`,`Detay10`) values('" + tanimdetay_id + "', 'TanimKodu', 'TanimAdi', 'SoruAdi', 'İnputTipi', 'SoruKodu', '', '', '', '', '')", Globals.Globals.con); cmd.ExecuteNonQuery(); Globals.Globals.con.Close(); }
public List <DTOTanimDetay> kaskosoru(DTOTanimDetay detay) { if (Globals.Globals.con.State == System.Data.ConnectionState.Open) { Globals.Globals.con.Close(); } Globals.Globals.con.Open(); MySqlCommand cmd = new MySqlCommand("select * from sgt_tanimdetay where Detay1='" + detay.Detay1 + "' and Detay2='" + detay.Detay2 + "' and tanim_id='4';", Globals.Globals.con); var rd = cmd.ExecuteReader(); List <DTOTanimDetay> kaskosorulistesi = new List <DTOTanimDetay>(); while (rd.Read()) { DTOTanimDetay detayekle = new DTOTanimDetay(); detayekle.Detay3 = rd.GetString("Detay3"); detayekle.Detay4 = rd.GetString("Detay4"); detayekle.Detay5 = rd.GetString("Detay5"); kaskosorulistesi.Add(detayekle); } Globals.Globals.con.Close(); return(kaskosorulistesi); }
public List <DTOTanimDetay> cevaplistesi() { List <DTOTanimDetay> detaylistesi = new List <DTOTanimDetay>(); if (Globals.Globals.con.State == System.Data.ConnectionState.Closed) { Globals.Globals.con.Open(); } MySqlCommand cmd = new MySqlCommand("select id,Detay1,Detay2,Detay3,Detay4 from sgt_tanimdetay where tanim_id in ('5')", Globals.Globals.con); var rd = cmd.ExecuteReader(); while (rd.Read()) { DTOTanimDetay tanimdetay = new DTOTanimDetay(); tanimdetay.id = Convert.ToInt16(rd.GetString("id")); tanimdetay.Detay1 = rd.GetString("Detay1"); tanimdetay.Detay2 = rd.GetString("Detay2"); tanimdetay.Detay3 = rd.GetString("Detay3"); tanimdetay.Detay4 = rd.GetString("Detay4"); detaylistesi.Add(tanimdetay); } Globals.Globals.con.Close(); return(detaylistesi); }
public List <DTOTanimDetay> GetirKaskoSoru(DTOTanimDetay detay) { EGetirKaskoSoru egetir = new EGetirKaskoSoru(); return(egetir.kaskosoru(detay)); }
public void componentduzenle(DTOTanimDetay detay) { EComponentDuzenle ecomponent = new EComponentDuzenle(); ecomponent.guncellecomponent(detay); }
public void componentekle(DTOTanimDetay detay) { EComponentEkle ecomponent = new EComponentEkle(); ecomponent.ComponentEkle(detay); }
public void sorukaydet(DTOTanimDetay detay) { ESoruKaydet eSoruKaydet = new ESoruKaydet(); eSoruKaydet.sorukaydet(detay); }
public void Duzenle(DTOTanimDetay detay) { EUrunDuzenle eurunduzenle = new EUrunDuzenle(); eurunduzenle.guncelleurun(detay); }
public List <String> GetirCevap(DTOTanimDetay detay) { EGetirCevap cevap = new EGetirCevap(); return(cevap.CevapGetir(detay)); }
public void EkleCevap(DTOTanimDetay detay) { ECevapEkle eCevapEkle = new ECevapEkle(); eCevapEkle.EkleCevap(detay); }
public List <DTOTanimDetay> urunlistele() { List <DTOTanimDetay> urunlistesi = new List <DTOTanimDetay>(); if (Globals.Globals.con.State == System.Data.ConnectionState.Closed) { Globals.Globals.con.Open(); } MySqlCommand cmd = new MySqlCommand("select * from sgt_tanimdetay where tanim_id=2", Globals.Globals.con); var rd = cmd.ExecuteReader(); while (rd.Read()) { DTOTanimDetay detay = new DTOTanimDetay(); detay.id = Convert.ToInt16(rd.GetString("id")); detay.tanim_id = Convert.ToInt16(rd.GetString("tanim_id")); if (!rd.IsDBNull(rd.GetOrdinal("Detay1"))) { detay.Detay1 = rd.GetString("Detay1"); } if (!rd.IsDBNull(rd.GetOrdinal("Detay2"))) { detay.Detay2 = rd.GetString("Detay2"); } if (!rd.IsDBNull(rd.GetOrdinal("Detay3"))) { detay.Detay3 = rd.GetString("Detay3"); } if (!rd.IsDBNull(rd.GetOrdinal("Detay4"))) { detay.Detay4 = rd.GetString("Detay4"); } if (!rd.IsDBNull(rd.GetOrdinal("Detay5"))) { detay.Detay5 = rd.GetString("Detay5"); } if (!rd.IsDBNull(rd.GetOrdinal("Detay6"))) { detay.Detay6 = rd.GetString("Detay6"); } if (!rd.IsDBNull(rd.GetOrdinal("Detay7"))) { detay.Detay7 = rd.GetString("Detay7"); } if (!rd.IsDBNull(rd.GetOrdinal("Detay8"))) { detay.Detay8 = rd.GetString("Detay8"); } if (!rd.IsDBNull(rd.GetOrdinal("Detay9"))) { detay.Detay9 = rd.GetString("Detay9"); } if (!rd.IsDBNull(rd.GetOrdinal("Detay10"))) { detay.Detay10 = rd.GetString("Detay10"); } urunlistesi.Add(detay); } Globals.Globals.con.Close(); return(urunlistesi); }
public string SatisKasko(List <String> satisevraklari) { EMusteriDogrula emusteribul = new EMusteriDogrula(); if (emusteribul.musteridogrula(satisevraklari[0]) == "Müşteri Bulunamadi") { return(emusteribul.musteridogrula(satisevraklari[0])); } else if (emusteribul.musteridogrula(satisevraklari[1]) == "Müşteri Bulunamadi") { return(emusteribul.musteridogrula(satisevraklari[1])); } else { int policenumarası = 0; List <DTOTanimDetay> satiskimligi = new List <DTOTanimDetay>(); DTOTanimDetay satiskimlik = new DTOTanimDetay(); DTOTanimDetay satiskimlik2 = new DTOTanimDetay(); satiskimlik.tanim_id = 8; satiskimlik2.tanim_id = 8; satiskimlik.Detay2 = emusteribul.musteridogrula(satisevraklari[0]); satiskimlik2.Detay2 = emusteribul.musteridogrula(satisevraklari[0]); satiskimlik.Detay3 = "1"; satiskimlik2.Detay3 = "2"; XElement SatisKasko = new XElement("Satis"); XElement yenibilgi; int i = 0; EGetirKaskoSoru SoruGetir = new EGetirKaskoSoru(); DTOTanimDetay detay = new DTOTanimDetay(); DTOTanimDetay satiskaskodetayi = new DTOTanimDetay(); detay.Detay1 = "ComponentTanimi"; detay.Detay2 = "Müsteri Componenti"; foreach (var item in SoruGetir.kaskosoru(detay)) { yenibilgi = new XElement(item.Detay5); yenibilgi.Add(satisevraklari[i]); SatisKasko.Add(yenibilgi); i++; } SoruGetir = new EGetirKaskoSoru(); detay = new DTOTanimDetay(); detay.Detay1 = "UrunTanimi"; detay.Detay2 = "Kasko"; foreach (var item in SoruGetir.kaskosoru(detay)) { yenibilgi = new XElement(item.Detay5); yenibilgi.Add(satisevraklari[i]); SatisKasko.Add(yenibilgi); i++; } int j = i; SoruGetir = new EGetirKaskoSoru(); detay = new DTOTanimDetay(); detay.Detay1 = "ComponentTanimi"; detay.Detay2 = "Satis Componenti"; foreach (var item in SoruGetir.kaskosoru(detay)) { yenibilgi = new XElement(item.Detay5); yenibilgi.Add(satisevraklari[i]); SatisKasko.Add(yenibilgi); i++; } if (Globals.Globals.con.State == System.Data.ConnectionState.Closed) { Globals.Globals.con.Open(); } MySqlCommand policeno = new MySqlCommand("select (max(Detay8)) from sgt_tanimdetay;", Globals.Globals.con); var rd = policeno.ExecuteReader(); while (rd.Read()) { policenumarası = Convert.ToInt16(rd.GetString(0)) + 1; } satiskimlik.Detay1 = policenumarası.ToString(); satiskimlik2.Detay1 = policenumarası.ToString(); satiskaskodetayi.tanim_id = 7; satiskaskodetayi.Detay1 = "Kasko"; satiskaskodetayi.Detay2 = SatisKasko.ToString(); satiskaskodetayi.Detay3 = satisevraklari[j]; satiskaskodetayi.Detay4 = satisevraklari[j + 1]; satiskaskodetayi.Detay5 = satisevraklari[j + 2]; satiskaskodetayi.Detay6 = satisevraklari[j + 3]; satiskaskodetayi.Detay7 = satisevraklari[j + 4]; satiskaskodetayi.Detay8 = (policenumarası).ToString(); satiskaskodetayi.Detay9 = "10"; satiskaskodetayi.Detay10 = "10"; satiskimligi.Add(satiskimlik); satiskimligi.Add(satiskimlik2); rd.Close(); MySqlCommand cmd = new MySqlCommand("insert into sgt_tanimdetay(`tanim_id`,`Detay1`,`Detay2`,`Detay3`,`Detay4`,`Detay5`,`Detay6`,`Detay7`,`Detay8`,`Detay9`,`Detay10`) values('" + satiskaskodetayi.tanim_id + "','" + satiskaskodetayi.Detay1 + "','" + satiskaskodetayi.Detay2 + "','" + satiskaskodetayi.Detay3 + "','" + satiskaskodetayi.Detay4 + "','" + satiskaskodetayi.Detay5 + "','" + satiskaskodetayi.Detay6 + "','" + satiskaskodetayi.Detay7 + "','" + satiskaskodetayi.Detay8 + "','" + satiskaskodetayi.Detay9 + "','" + satiskaskodetayi.Detay10 + "')", Globals.Globals.con); cmd.ExecuteNonQuery(); cmd = new MySqlCommand("select max(id) from sgt_tanimdetay", Globals.Globals.con); rd = cmd.ExecuteReader(); int tanimdetay_id = 0; while (rd.Read()) { tanimdetay_id = Convert.ToInt16(rd.GetString(0)); } rd.Close(); cmd = new MySqlCommand("insert into `sgt_tanimdetayaciklamasi`(`tanimdetay_id`,`Detay1`,`Detay2`,`Detay3`,`Detay4`,`Detay5`,`Detay6`,`Detay7`,`Detay8`,`Detay9`,`Detay10`) values('" + tanimdetay_id + "', 'TanimKodu', 'SatisXML', 'Baslangic', 'Bitis', 'HesapNo', 'OdemeAraci', 'Teminat', 'PoliceNo', 'Tutar1', 'Tutar2')", Globals.Globals.con); cmd.ExecuteNonQuery(); foreach (var item in satiskimligi) { cmd = new MySqlCommand("insert into sgt_tanimdetay(`tanim_id`,`Detay1`,`Detay2`,`Detay3`,`Detay4`,`Detay5`,`Detay6`,`Detay7`,`Detay8`,`Detay9`,`Detay10`) values('" + item.tanim_id + "','" + item.Detay1 + "','" + item.Detay2 + "','" + item.Detay3 + "','','','','','','','')", Globals.Globals.con); cmd.ExecuteNonQuery(); cmd = new MySqlCommand("select max(id) from sgt_tanimdetay", Globals.Globals.con); rd = cmd.ExecuteReader(); while (rd.Read()) { tanimdetay_id = Convert.ToInt16(rd.GetString(0)); } rd.Close(); cmd = new MySqlCommand("insert into `sgt_tanimdetayaciklamasi`(`tanimdetay_id`,`Detay1`,`Detay2`,`Detay3`,`Detay4`,`Detay5`,`Detay6`,`Detay7`,`Detay8`,`Detay9`,`Detay10`) values('" + tanimdetay_id + "', 'Poliçe ID', 'Müşteri NO', 'Sigorta Kişi Tipi', '', '', '', '', '', '', '')", Globals.Globals.con); cmd.ExecuteNonQuery(); } Globals.Globals.con.Close(); return("ÜrünSatildi\n" + SatisKasko.ToString()); } }
public void soruduzenle(DTOTanimDetay detay) { ESoruDuzenle soruDuzenle = new ESoruDuzenle(); soruDuzenle.guncellesoru(detay); }
public void CevapDuzenle(DTOTanimDetay detay) { ECevapDuzenle cevapDuzenle = new ECevapDuzenle(); cevapDuzenle.guncellecevap(detay); }