public ActionResult Register(RegisterViewModal rg) { sayazilimEntities db = new sayazilimEntities(); try { var firmalarlist = db.Firmalar.Where(x => x.FirmaEMail == rg.Email).ToList(); if (firmalarlist.Count == 0) { Firmalar fr = new Firmalar(); fr.FirmaAdi = rg.FirmaIsmi; string sifre = rg.Password; fr.FirmaEMail = rg.Email; fr.FirmaTel = rg.FirmaTel; var firmalist = db.Firmalar.OrderByDescending(x => x.ID).FirstOrDefault(); if (firmalist != null) { int i = Convert.ToInt32(firmalist.FirmaID + 1); fr.FirmaID = i; } else { fr.FirmaID = 2; } DateTime kayittarih = DateTime.Now; kayittarih = kayittarih.AddDays(15); fr.KayitTarih = kayittarih; Personel pr = new Personel(); pr.Adi = "Admin"; pr.Soyadi = ""; pr.Pozisyonu = "Admin"; pr.PersonelGrubu = "Admin"; pr.FirmaID = Convert.ToInt16(fr.FirmaID); pr.sCariID = -1; pr.WebKA = rg.KullaniciAdi; pr.WebSifre = GirisKontrol.hash(sifre, true); fr.Demo = true; db.Personel.Add(pr); db.Firmalar.Add(fr); db.SaveChanges(); #region YeniFirmaKontrol int firmaid = Convert.ToInt16(pr.FirmaID); var setting = db.Ayarlar.Where(x => x.FirmaID == firmaid).ToList(); if (setting.Count == 0) { DataRow dt = null; using (SqlConnection con = new SqlConnection(AyarMetot.conString)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter( "select * from AYARLAR where ID='1'", con)) { using (SqlCommandBuilder cb = new SqlCommandBuilder(da)) { DataSet ds = new DataSet(); da.Fill(ds, "AYARLAR"); DataRow[] adf = ds.Tables["AYARLAR"].Select("ID='1'"); if (adf.Length != 0) { dt = adf[0]; } } } } using (SqlConnection con = new SqlConnection(AyarMetot.strcon)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select Top 1 * from AYARLAR where FirmaID=" + firmaid.ToString(), con)) { using (SqlCommandBuilder cb = new SqlCommandBuilder(da)) { DataSet ds = new DataSet(); da.Fill(ds, "AYARLAR"); DataRow df = ds.Tables["AYARLAR"].NewRow(); df.ItemArray = dt.ItemArray.Clone() as object[]; df["FirmaID"] = fr.FirmaID; df["Version"] = KODLA.Kapa(rg.Pakettipi, AyarMetot.ilhan_Control); df["fMail"] = ""; df["fMailSifre"] = ""; df["fMailSender"] = ""; df["SMSUser"] = ""; df["SMSPass"] = ""; df["MesajSonu"] = ""; df["BorcMesajSonu"] = ""; df["SmsSender"] = ""; df["EFatGB"] = ""; df["EFatKA"] = ""; df["EFatSifre"] = ""; df["EIrsKA"] = ""; df["EIrsSF"] = ""; df["KurumKodu"] = ""; df["EIrsGB"] = ""; df["Entegrator"] = ""; df["PostaSunucu"] = ""; df["ServisBorclandirsin"] = 1; string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0'); df["Company_Code"] = company_code; ds.Tables["AYARLAR"].Rows.Add(df); da.Update(ds, "AYARLAR"); } } } } var compony = db.COMPANY_DETAIL.Where(x => x.FirmaID == firmaid).ToList(); if (compony.Count == 0) { DataRow dt = null; using (SqlConnection con = new SqlConnection(AyarMetot.conString)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter( "select * from COMPANY_DETAIL where ID='1'", con)) { using (SqlCommandBuilder cb = new SqlCommandBuilder(da)) { DataSet ds = new DataSet(); da.Fill(ds, "COMPANY_DETAIL"); DataRow[] adf = ds.Tables["COMPANY_DETAIL"].Select("ID='1'"); if (adf.Length != 0) { dt = adf[0]; } } } } using (SqlConnection con = new SqlConnection(AyarMetot.strcon)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter da = new System.Data.SqlClient.SqlDataAdapter("select Top 1 * from COMPANY_DETAIL", con)) { using (SqlCommandBuilder cb = new SqlCommandBuilder(da)) { DataSet ds = new DataSet(); da.Fill(ds, "COMPANY_DETAIL"); DataRow df = ds.Tables["COMPANY_DETAIL"].NewRow(); df.ItemArray = dt.ItemArray.Clone() as object[]; Firmalar frm = db.Firmalar.Where(x => x.FirmaID == firmaid).FirstOrDefault(); df["FirmaAdi"] = frm.FirmaAdi; string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0'); df["Company_Code"] = company_code; Personel pb = db.Personel.OrderByDescending(x => x.ID).FirstOrDefault(); df["IlgiliKisi"] = (pb.Adi + pb.Soyadi).TrimEnd(); Firmalar dr = db.Firmalar.Where(x => x.FirmaID == firmaid).FirstOrDefault(); df["Telefon"] = dr.FirmaTel; df["Faks"] = ""; df["ePosta"] = dr.FirmaEMail; df["WebSite"] = ""; df["VergiDairesi"] = ""; df["VergiNo"] = ""; df["Ulke"] = ""; df["Sehir"] = ""; df["PostaKodu"] = ""; df["Adres"] = ""; df["TicaretSicilNo"] = ""; df["MersisNo"] = ""; df["Ilce"] = ""; df["FirmaID"] = fr.FirmaID; ds.Tables["COMPANY_DETAIL"].Rows.Add(df); da.Update(ds, "COMPANY_DETAIL"); } } } } var stk_ktg = db.STK_KATEGORI.Where(x => x.FirmaID == firmaid).ToList(); if (stk_ktg.Count == 0) { int i = 7; for (int j = 1; j < i; j++) { STK_KATEGORI stk = new STK_KATEGORI(); stk.FirmaID = fr.FirmaID; stk.Name = "Stok Kategori " + j; string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0'); stk.Company_Code = company_code; db.STK_KATEGORI.Add(stk); db.SaveChanges(); } } var special = db.SPECIAL_TECH.Where(x => x.FirmaID == firmaid).ToList(); if (special.Count == 0) { int i = 11; for (int j = 1; j < i; j++) { SPECIAL_TECH stk = new SPECIAL_TECH(); stk.FirmaID = Convert.ToInt16(fr.FirmaID); stk.Name = "Özel Alan " + j; string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0'); stk.Company_Code = company_code; db.SPECIAL_TECH.Add(stk); db.SaveChanges(); } } var carikategori = db.CARI_KATEGORI.Where(x => x.FirmaID == firmaid).ToList(); if (carikategori.Count == 0) { int i = 7; for (int j = 1; j < i; j++) { CARI_KATEGORI stk = new CARI_KATEGORI(); stk.FirmaID = firmaid; stk.Name = "Cari Kategori " + j; string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0'); stk.Company_Code = company_code; db.CARI_KATEGORI.Add(stk); db.SaveChanges(); } } var faturaekbilgi = db.INVOICE_OZEL.Where(x => x.FirmaID == firmaid).ToList(); if (carikategori.Count == 0) { int i = 9; for (int j = 1; j < i; j++) { INVOICE_OZEL stk = new INVOICE_OZEL(); stk.FirmaID = firmaid; stk.Name = "Fature Ek Bilgi " + j; stk.EfaturadaGonder = false; string company_code = "SA01" + fr.FirmaID.ToString().PadLeft(3, '0'); stk.Company_Code = company_code; db.INVOICE_OZEL.Add(stk); db.SaveChanges(); } } #endregion Session["FirmaAdi"] = fr.FirmaAdi; MailOkey(rg); return(RedirectToAction("Login", "Login")); } else { return(View()); } } catch (Exception e) { return(View()); } }
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)); }