public JsonResult UpdateSetting(FirmaDetail dk, Array[] data, Array[] carikat, Array[] serviskat, Array[] faturakat) { string Message = "Kayıt Eklendi"; int firmaid = Convert.ToInt32(Session["FirmaID"].ToString()); Ayarlar car = db.Ayarlar.Where(x => x.FirmaID == firmaid).FirstOrDefault <Ayarlar>(); COMPANY_DETAIL fr = db.COMPANY_DETAIL.Where(x => x.FirmaID == firmaid).FirstOrDefault <COMPANY_DETAIL>(); dk.settings.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); dk.detail.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); car.EFatKA = dk.settings.EFatKA; car.Entegrator = dk.settings.Entegrator; car.FaturaAutoNo = dk.settings.FaturaAutoNo; car.EFatSifre = dk.settings.EFatSifre; car.EFatGB = dk.settings.EFatGB; car.EIrsGB = dk.settings.EIrsGB; car.EIrsKA = dk.settings.EIrsKA; car.EIrsSF = dk.settings.EIrsSF; if (dk.settings.Version != null) { car.Version = KODLA.Kapa(dk.settings.Version, AyarMetot.ilhan_Control); } car.KurumKodu = dk.settings.KurumKodu; car.Terminalturu = dk.settings.Terminalturu; car.FPort = dk.settings.FPort; car.fMail = dk.settings.fMail; car.fMailSender = dk.settings.fMailSender; if (dk.settings.fMailSifre != null) { car.fMailSifre = KODLA.Kapa(dk.settings.fMailSifre, AyarMetot.ilhan_Control); } else { car.fMailSifre = ""; } car.PostaSunucu = dk.settings.PostaSunucu; car.SmsFirma = dk.settings.SmsFirma; if (dk.settings.SMSPass != null) { car.SMSPass = KODLA.Kapa(dk.settings.SMSPass, AyarMetot.ilhan_Control); } else { car.SMSPass = ""; } car.SMSSender = dk.settings.SMSSender; car.SMSUser = dk.settings.SMSUser; car.BorcMesajSonu = dk.settings.BorcMesajSonu; car.MesajSonu = dk.settings.MesajSonu; if (dk.detail.FirmaAdi != null) { fr.FirmaAdi = dk.detail.FirmaAdi; } else { fr.FirmaAdi = ""; } fr.VergiDairesi = dk.detail.VergiDairesi; fr.Telefon = dk.detail.Telefon; fr.IlgiliKisi = dk.detail.IlgiliKisi; fr.VergiNo = dk.detail.VergiNo; fr.Faks = dk.detail.Faks; fr.Sehir = dk.detail.Sehir; fr.Ilce = dk.detail.Ilce; fr.PostaKodu = dk.detail.PostaKodu; fr.Ilce = dk.detail.Ilce; fr.Adres = dk.detail.Adres; fr.SicilNo = dk.detail.SicilNo; fr.WebSite = dk.detail.WebSite; fr.MersisNo = dk.detail.MersisNo; fr.TicaretSicilNo = dk.detail.TicaretSicilNo; string Sifre = ""; if (car.SMSPass != "") { Sifre = KODLA.Ac(car.SMSPass, AyarMetot.ilhan_Control); } if (dk.settings.vrsPBName == "") { car.vrsPBName = "Türk Lirası"; car.vrsPBCode = "TL"; } else if (dk.settings.vrsPBName == "TL") { car.vrsPBName = "Türk Lirası"; car.vrsPBCode = "TL"; } else if (dk.settings.vrsPBName == "EUR") { car.vrsPBName = "Euro Üye Ülkeler"; car.vrsPBCode = "EUR"; } else if (dk.settings.vrsPBName == "USD") { car.vrsPBName = "ABD Doları"; car.vrsPBCode = "USD"; } for (int i = 0; i < data.Length; i++) { string ID = ""; string NAME = ""; int kolon = 0; foreach (var veri in data[i]) { if (kolon == 0) { ID = veri.ToString(); } else if (kolon == 1) { NAME = veri.ToString(); } kolon++; } kolon = 0; using (SqlConnection con = new SqlConnection(AyarMetot.strcon)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select * from STK_KATEGORI where ID='" + ID + "'", con)) { using (SqlCommandBuilder cb = new SqlCommandBuilder(da)) { DataSet ds1 = new DataSet(); da.Fill(ds1, "STK_KATEGORI"); DataRow[] adf = ds1.Tables["STK_KATEGORI"].Select("ID='" + ID + "'"); if (adf.Length != 0) { DataRow dr = adf[0]; dr["Name"] = NAME; da.Update(ds1, "STK_KATEGORI"); } } } } } for (int i = 0; i < carikat.Length; i++) { string ID = ""; string NAME = ""; int kolon = 0; foreach (var veri in carikat[i]) { if (kolon == 0) { ID = veri.ToString(); } else if (kolon == 1) { NAME = veri.ToString(); } kolon++; } kolon = 0; using (SqlConnection con = new SqlConnection(AyarMetot.strcon)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select * from CARI_KATEGORI where ID='" + ID + "'", con)) { using (SqlCommandBuilder cb = new SqlCommandBuilder(da)) { DataSet ds1 = new DataSet(); da.Fill(ds1, "CARI_KATEGORI"); DataRow[] adf = ds1.Tables["CARI_KATEGORI"].Select("ID='" + ID + "'"); if (adf.Length != 0) { DataRow dr = adf[0]; dr["Name"] = NAME; da.Update(ds1, "CARI_KATEGORI"); } } } } } for (int i = 0; i < serviskat.Length; i++) { string ID = ""; string NAME = ""; int kolon = 0; foreach (var veri in serviskat[i]) { if (kolon == 0) { ID = veri.ToString(); } else if (kolon == 1) { NAME = veri.ToString(); } kolon++; } kolon = 0; using (SqlConnection con = new SqlConnection(AyarMetot.strcon)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select * from SPECIAL_TECH where ID='" + ID + "'", con)) { using (SqlCommandBuilder cb = new SqlCommandBuilder(da)) { DataSet ds1 = new DataSet(); da.Fill(ds1, "SPECIAL_TECH"); DataRow[] adf = ds1.Tables["SPECIAL_TECH"].Select("ID='" + ID + "'"); if (adf.Length != 0) { DataRow dr = adf[0]; dr["Name"] = NAME; da.Update(ds1, "SPECIAL_TECH"); } } } } } for (int i = 0; i < faturakat.Length; i++) { string ID = ""; string NAME = ""; int kolon = 0; foreach (var veri in faturakat[i]) { if (kolon == 0) { ID = veri.ToString(); } else if (kolon == 1) { NAME = veri.ToString(); } kolon++; } kolon = 0; using (SqlConnection con = new SqlConnection(AyarMetot.strcon)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select * from INVOICE_OZEL where ID='" + ID + "'", con)) { using (SqlCommandBuilder cb = new SqlCommandBuilder(da)) { DataSet ds1 = new DataSet(); da.Fill(ds1, "INVOICE_OZEL"); DataRow[] adf = ds1.Tables["INVOICE_OZEL"].Select("ID='" + ID + "'"); if (adf.Length != 0) { DataRow dr = adf[0]; dr["Name"] = NAME; da.Update(ds1, "INVOICE_OZEL"); } } } } } db.SaveChanges(); Message = "Kayıt Güncellendi"; var result = new { sonuc = 1, Message = Message }; return(Json(result, JsonRequestBehavior.AllowGet)); }
// GET: Settings public ActionResult Index() { FirmaDetail fd = new FirmaDetail(); COMPANY_DETAIL cr = new COMPANY_DETAIL(); Ayarlar ay = new Ayarlar(); List <Kategoriler> kat = new List <Kategoriler>(); List <Kategoriler> carikat = new List <Kategoriler>(); List <Kategoriler> ServisKat = new List <Kategoriler>(); List <Kategoriler> FaturaList = new List <Kategoriler>(); List <CURRENCY_LIST> pbler = new List <CURRENCY_LIST>(); using (SqlConnection bag = new SqlConnection(AyarMetot.strcon)) { if (bag.State == ConnectionState.Closed) { bag.Open(); } using (SqlCommand sayarlar = new SqlCommand("Select * From STK_KATEGORI Where FirmaID=" + Session["FirmaID"].ToString(), bag)) { using (SqlDataReader dr = sayarlar.ExecuteReader()) { while (dr.Read()) { Kategoriler KT = new Kategoriler(); KT.ID = Convert.ToInt32(dr["ID"]); KT.Name = dr["Name"].ToString(); kat.Add(KT); } } } } using (SqlConnection bag = new SqlConnection(AyarMetot.strcon)) { if (bag.State == ConnectionState.Closed) { bag.Open(); } using (SqlCommand sayarlar = new SqlCommand("Select * From SPECIAL_TECH Where FirmaID=" + Session["FirmaID"].ToString(), bag)) { using (SqlDataReader dr = sayarlar.ExecuteReader()) { while (dr.Read()) { Kategoriler KT = new Kategoriler(); KT.ID = Convert.ToInt32(dr["ID"]); KT.Name = dr["Name"].ToString(); ServisKat.Add(KT); } } } } using (SqlConnection bag = new SqlConnection(AyarMetot.strcon)) { if (bag.State == ConnectionState.Closed) { bag.Open(); } using (SqlCommand sayarlar = new SqlCommand("Select * From CARI_KATEGORI Where FirmaID=" + Session["FirmaID"].ToString(), bag)) { using (SqlDataReader dr = sayarlar.ExecuteReader()) { while (dr.Read()) { Kategoriler KT = new Kategoriler(); KT.ID = Convert.ToInt32(dr["ID"]); KT.Name = dr["Name"].ToString(); carikat.Add(KT); } } } } using (SqlConnection bag = new SqlConnection(AyarMetot.strcon)) { if (bag.State == ConnectionState.Closed) { bag.Open(); } using (SqlCommand sayarlar = new SqlCommand("Select * From INVOICE_OZEL Where FirmaID=" + Session["FirmaID"].ToString(), bag)) { using (SqlDataReader dr = sayarlar.ExecuteReader()) { while (dr.Read()) { Kategoriler KT = new Kategoriler(); KT.ID = Convert.ToInt32(dr["ID"]); KT.Name = dr["Name"].ToString(); FaturaList.Add(KT); } } } } using (SqlConnection bag = new SqlConnection(AyarMetot.strcon)) { string srg = "Select * From COMPANY_DETAIL where FirmaID=" + Session["FirmaID"].ToString(); if (bag.State == ConnectionState.Closed) { bag.Open(); } using (SqlCommand sayarlar = new SqlCommand(srg, bag)) { using (SqlDataReader dr = sayarlar.ExecuteReader()) { while (dr.Read()) { cr.FirmaAdi = dr["FirmaAdi"].ToString(); cr.VergiDairesi = dr["VergiDairesi"].ToString(); cr.VergiNo = dr["VergiNo"].ToString(); cr.Telefon = dr["Telefon"].ToString(); cr.Faks = dr["Faks"].ToString(); cr.ePosta = dr["ePosta"].ToString(); cr.IlgiliKisi = dr["IlgiliKisi"].ToString(); cr.Sehir = dr["Sehir"].ToString(); cr.Ilce = dr["Ilce"].ToString(); cr.PostaKodu = dr["PostaKodu"].ToString(); cr.Adres = dr["Adres"].ToString(); cr.SicilNo = dr["SicilNo"].ToString(); cr.WebSite = dr["WebSite"].ToString(); cr.MersisNo = dr["MersisNo"].ToString(); cr.TicaretSicilNo = dr["TicaretSicilNo"].ToString(); } } } } using (SqlConnection bag = new SqlConnection(AyarMetot.strcon)) { if (bag.State == ConnectionState.Closed) { bag.Open(); } using (SqlCommand sayarlar = new SqlCommand("Select * From Ayarlar where FirmaID=" + Session["FirmaID"].ToString(), bag)) { using (SqlDataReader dr = sayarlar.ExecuteReader()) { while (dr.Read()) { ay.KurumKodu = dr["KurumKodu"].ToString(); ay.Entegrator = dr["Entegrator"].ToString(); ay.EFatGecis = DateTime.Now; ay.EFatKA = dr["EFatKA"].ToString(); ay.EFatSifre = dr["EFatSifre"].ToString(); ay.EFatGB = dr["EFatGB"].ToString(); ay.FaturaGonderimi = dr["FaturaGonderimi"].ToString(); ay.EIrsGB = dr["EIrsGB"].ToString(); ay.EIrsKA = dr["EIrsKA"].ToString(); ay.EIrsSF = dr["EIrsSF"].ToString(); ay.IrsaliyeAutoNo = dr["IrsaliyeAutoNo"].ToString(); ay.vrsPBCode = dr["vrsPBCode"].ToString(); ay.FPort = Convert.ToInt32(dr["FPort"].ToString()); ay.fMail = dr["fMail"].ToString(); ay.fMailSender = dr["fMailSender"].ToString(); if (dr["fMailSifre"].ToString() != "") { ay.fMailSifre = KODLA.Ac(dr["fMailSifre"].ToString(), AyarMetot.ilhan_Control); } else { ay.fMailSifre = ""; } ay.PostaSunucu = dr["PostaSunucu"].ToString(); ay.SmsFirma = dr["SmsFirma"].ToString(); if (dr["SMSPass"].ToString() != "") { ay.SMSPass = KODLA.Ac(dr["SMSPass"].ToString(), AyarMetot.ilhan_Control); } else { ay.SMSPass = ""; } ay.SMSSender = dr["SMSSender"].ToString(); ay.SMSUser = dr["SMSUser"].ToString(); ay.BorcMesajSonu = dr["BorcMesajSonu"].ToString(); ay.MesajSonu = dr["MesajSonu"].ToString(); } } } } var parabirimi = db.CURRENCY_LIST.Where(x => x.Durumu == true).ToList(); foreach (var item in parabirimi) { CURRENCY_LIST cl = new CURRENCY_LIST(); cl.ParaBirimi = item.ParaBirimi; cl.ParaBirimiN = item.ParaBirimiN; pbler.Add(cl); } int FirmaID = Convert.ToInt32(Session["FirmaID"].ToString()); var renklist = db.RENKLER.Where(x => x.FirmaID == FirmaID).ToList(); ViewBag.RenklerList = renklist.ToList(); fd.ParaBirimleri = pbler; fd.settings = ay; fd.detail = cr; fd.kat = kat; fd.carikat = carikat; fd.serviskat = ServisKat; fd.FaturaList = FaturaList; return(View(fd)); }