public JsonResult YeniDepo(STORE dk) { STORE car = null; string Message = "Kayıt Eklendi"; int sonuc = 1; var result = new { sonuc = sonuc, Message = Message }; int firmaid = Convert.ToInt32(Session["FirmaID"].ToString()); if (dk.ID == -1) { car = new STORE(); car = dk; if (dk.Varsayilan == null || dk.Varsayilan == "") { car.Varsayilan = "Evet"; } int firmaidsrg = Convert.ToInt32(Session["FirmaID"].ToString()); var depolist = db.STORE.Where(x => x.FirmaID == firmaidsrg && x.Kodu == car.Kodu).ToList(); if (depolist.Count == 0) { car.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); car.KayitT = DateTime.Now.ToString("dd.MM.yyyy"); car.DegT = DateTime.Now.ToString("dd.MM.yyyy"); car.Merkez = false; string firmaid2 = Session["FirmaID"].ToString(); string company_code = "SA01" + firmaid2.PadLeft(3, '0'); car.Company_Code = company_code; db.STORE.Add(car); db.SaveChanges(); } else { Message = "Aynı Depo Kodu İle Kayıt Eklenemez."; sonuc = 0; } } else { car = db.STORE.Where(x => x.ID == dk.ID).FirstOrDefault <STORE>(); car.Adres = dk.Adres; car.DepoAdi = dk.DepoAdi; car.Kodu = dk.Kodu; car.DegT = DateTime.Now.ToString("dd.MM.yyyy"); car.EkBilgiler = dk.EkBilgiler; car.Durumu = dk.Durumu; db.SaveChanges(); Message = "Kayıt Güncellendi"; } result = new { sonuc = 1, Message = Message }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteStoreProcess(int id) { using (sayazilimEntities db = new sayazilimEntities()) { string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; using (SqlConnection conp = new SqlConnection(strcon)) { if (conp.State == ConnectionState.Closed) { conp.Open(); } using (var sqlWrite = new SqlCommand("DELETE STORE_PROCESS where ID='" + id + "'", conp)) { sqlWrite.ExecuteNonQuery(); } if (conp.State == ConnectionState.Closed) { conp.Open(); } using (var sqlWrite = new SqlCommand("DELETE STORE_PROCESS_DETAIL where DepoIslemID='" + id + "'", conp)) { sqlWrite.ExecuteNonQuery(); } } db.SaveChanges(); return(Json(new { success = true, message = "Kayıt Silindi" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteKasa(int id) { if (Session["Grubu"].ToString() == "Teknik Servis Kullanıcısı") { return(Json(new { success = false, message = "Yetkiniz Yoktur." }, JsonRequestBehavior.AllowGet)); } else { using (sayazilimEntities db = new sayazilimEntities()) { Kasa emp = db.Kasa.Where(x => x.ID == id).FirstOrDefault <Kasa>(); if (emp.Merkez == true) { return(Json(new { success = false, message = "Merkez Kasa Silinemez" }, JsonRequestBehavior.AllowGet)); } else { using (SqlConnection conp = new System.Data.SqlClient.SqlConnection(AyarMetot.conString)) { conp.Open(); SqlCommand cmd = new SqlCommand("IslemKontrolKasa", conp); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@KasaID", emp.ID); // input parameter // output parameter SqlParameter average = new SqlParameter("@deger", SqlDbType.NVarChar, 50); average.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(average); // return value SqlParameter count = cmd.CreateParameter(); count.Direction = System.Data.ParameterDirection.ReturnValue; cmd.Parameters.Add(count); cmd.ExecuteNonQuery(); if (Convert.ToInt32(count.Value) != 0) { if (average.Value.ToString() == "İşlem") { return(Json(new { success = false, message = "Bu kasaya ait " + average.Value.ToString() + " işlem bulunmaktadır.Silinemez" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = "Seçili Kasa Bakiyesi 0'dan Büyüktür.İşlemlerinizi Kontrol Ediniz" }, JsonRequestBehavior.AllowGet)); } } else { db.Kasa.Remove(emp); db.SaveChanges(); return(Json(new { success = true, message = "Kayıt Silindi" }, JsonRequestBehavior.AllowGet)); } } } } } }
public ActionResult NotlarDelete(int id) { using (sayazilimEntities db = new sayazilimEntities()) { Notlar_Listesi emp = db.Notlar_Listesi.Where(x => x.ID == id).FirstOrDefault <Notlar_Listesi>(); db.Notlar_Listesi.Remove(emp); db.SaveChanges(); return(Json(new { success = true, message = "Kayıt Silindi" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult YeniMaas(SALARYPERSON dk) { SALARYPERSON car = null; string Message = "Kayıt Eklendi"; if (dk.ID == -1) { car = new SALARYPERSON(); car = dk; car.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); string firmaid = Session["FirmaID"].ToString(); string company_code = "SA01" + firmaid.PadLeft(3, '0'); car.Company_Code = company_code; db.SALARYPERSON.Add(car); db.SaveChanges(); } else { car = db.SALARYPERSON.Where(x => x.ID == dk.ID).FirstOrDefault <SALARYPERSON>(); if (dk.ParaBirimi == "") { car.ParaBirimi = "TL"; } car.OdenenPersonel = dk.OdenenPersonel; car.OzelKodID = dk.OzelKodID; car.IslemNo = dk.IslemNo; car.IslemTarihi = dk.IslemTarihi; car.VadeTarihi = dk.VadeTarihi; car.IslemTipi = dk.IslemTipi; car.Tutar = dk.Tutar; car.AlacakBorcTipi = dk.AlacakBorcTipi; car.Aciklama = dk.Aciklama; car.ID = dk.ID; car.ParaBirimi = dk.ParaBirimi; db.SaveChanges(); Message = "Kayıt Güncellendi"; } var result = new { sonuc = 1, Message = Message }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteDekont(int id) { using (sayazilimEntities db = new sayazilimEntities()) { Dekont emp = db.Dekont.Where(x => x.ID == id).FirstOrDefault <Dekont>(); db.Dekont.Remove(emp); db.SaveChanges(); return(Json(new { success = true, message = "Kayıt Silindi" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult GuncelleOrders(int id, string durum, string aciklama) { using (sayazilimEntities db = new sayazilimEntities()) { ORDERS emp = db.ORDERS.Where(x => x.ID == id).FirstOrDefault <ORDERS>(); emp.Durumu = durum; // emp.IptalAciklama = aciklama; db.SaveChanges(); return(Json(new { success = true, message = "Durum Güncellendi" }, JsonRequestBehavior.AllowGet)); } }
public JsonResult YeniNot(Notlar_Listesi dk) { Notlar_Listesi car = null; string Message = "Kayıt Eklendi"; if (dk.ID == -1) { car = new Notlar_Listesi(); car = dk; car.KategoriID = dk.KategoriID; car.NotBasligi = dk.NotBasligi; car.NotIcerik = dk.NotIcerik; car.Tarih = dk.Tarih; car.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); string firmaid = Session["FirmaID"].ToString(); string company_code = "SA01" + firmaid.PadLeft(3, '0'); car.Company_Code = company_code; db.Notlar_Listesi.Add(car); db.SaveChanges(); } else { car = db.Notlar_Listesi.Where(x => x.ID == dk.ID).FirstOrDefault <Notlar_Listesi>(); car.KategoriID = dk.KategoriID; car.NotBasligi = dk.NotBasligi; car.NotIcerik = dk.NotIcerik; car.Tarih = dk.Tarih; car.ID = dk.ID; db.SaveChanges(); Message = "Kayıt Güncellendi"; } var result = new { sonuc = 1, Message = Message }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteCari(int id) { using (sayazilimEntities db = new sayazilimEntities()) { Cari emp = db.Cari.Where(x => x.ID == id).FirstOrDefault <Cari>(); using (SqlConnection conp = new System.Data.SqlClient.SqlConnection(AyarMetot.conString)) { conp.Open(); SqlCommand cmd = new SqlCommand("IslemKontrolCari", conp); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@CariID", emp.ID); // input parameter // output parameter SqlParameter average = new SqlParameter("@deger", SqlDbType.NVarChar, 50); average.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(average); // return value SqlParameter count = cmd.CreateParameter(); count.Direction = System.Data.ParameterDirection.ReturnValue; cmd.Parameters.Add(count); cmd.ExecuteNonQuery(); if (Convert.ToInt32(count.Value) != 0) { if (average.Value.ToString() == "İşlem") { return(Json(new { success = false, message = "Seçili Cariye Ait " + average.Value.ToString() + " bulunmaktadır" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = "Seçili Cari Bakiyesi 0'dan Büyüktür.İşlemlerinizi Kontrol Ediniz" }, JsonRequestBehavior.AllowGet)); } } else { db.Cari.Remove(emp); db.SaveChanges(); return(Json(new { success = true, message = "Kayıt Silindi" }, JsonRequestBehavior.AllowGet)); } } } }
public ActionResult DeleteDepo(int id) { using (sayazilimEntities db = new sayazilimEntities()) { STORE str = db.STORE.Where(x => x.ID == id).FirstOrDefault(); if (str.Merkez == true) { return(Json(new { success = false, message = "Merkez Depo Silinemez." }, JsonRequestBehavior.AllowGet)); } else { STORE emp = db.STORE.Where(x => x.ID == id).FirstOrDefault <STORE>(); db.STORE.Remove(emp); db.SaveChanges(); return(Json(new { success = true, message = "Kayıt Silindi" }, JsonRequestBehavior.AllowGet)); } } }
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)); }
public JsonResult yeniCari(Cari cr, string alacakINT, string borcINT) { ViewBag.Sıradaki = AyarMetot.GetNumara; Cari car = null; int islemsonuc = 1; string Message = "Kayıt Eklendi"; if (cr.ID == -1 || cr.ID == 0) { int firmaidsrg = Convert.ToInt32(Session["FirmaID"].ToString()); var list = db.Cari.Where(x => x.FirmaKodu == cr.FirmaKodu && x.FirmaID == firmaidsrg).ToList(); if (list.Count == 0) { car = new Cari(); car = cr; car.WebKA = cr.WebKA; try { car.WebSifre = GirisKontrol.hash(cr.WebSifre, true); } catch (Exception e) { } if (cr.paraBirimi == null) { car.paraBirimi = "TL"; } else { car.paraBirimi = cr.paraBirimi; } car.CariList = true; if (cr.MusteriTemsilcisi == null) { cr.MusteriTemsilcisi = 1; } try { car.FirmaID = (short)Convert.ToInt32(Session["FirmaID"]); } catch (Exception e) { car.FirmaID = 1; } if (car.KTipi != "BAYİİ") { car.DepoID = -1; } else { car.DepoID = cr.DepoID; } car.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); string firmaid = Session["FirmaID"].ToString(); string company_code = "SA01" + firmaid.PadLeft(3, '0'); car.Company_Code = company_code; db.Cari.Add(car); db.SaveChanges(); decimal alacak = 0; decimal borc = 0; if (alacakINT != "") { alacak = Convert.ToDecimal(alacakINT); } if (borcINT != "") { borc = Convert.ToDecimal(borcINT); } var carilist = db.Cari.OrderByDescending(x => x.ID).Take(1).ToList(); foreach (var item in carilist) { if (alacak > 0) { Bakiyeekle("CAF", item.ID, alacak, item.paraBirimi); } if (borc > 0) { Bakiyeekle("CBF", item.ID, borc, item.paraBirimi); } } } else { islemsonuc = 0; Message = "Aynı Firma Koduna Ait Ver Mevcuttur."; } } else { car = db.Cari.Where(x => x.ID == cr.ID).FirstOrDefault <Cari>(); car.CariUnvan = cr.CariUnvan; car.FirmaKodu = cr.FirmaKodu; car.Il = cr.Il; car.Yetkili = cr.Yetkili; car.GSM = cr.GSM; car.Telefon1 = cr.Telefon1; car.PostaKodu = cr.PostaKodu; car.Ilce = cr.Ilce; car.Faks = cr.Faks; car.Iskonto = cr.Iskonto; car.MersisNo = cr.MersisNo; car.TicaretSicilNo = cr.TicaretSicilNo; car.VergiDr = cr.VergiDr; car.VergiNo = cr.VergiNo; car.Adres = cr.Adres; car.EkBilgi = cr.EkBilgi; car.EPosta = cr.EPosta; car.KTipi = cr.KTipi; car.StokFG = cr.StokFG; car.CariGrubu = cr.CariGrubu; car.Milleti = cr.Milleti; car.WebKA = cr.WebKA; car.paraBirimi = cr.paraBirimi; try { car.WebSifre = GirisKontrol.hash(cr.WebSifre, true); } catch { } db.SaveChanges(); islemsonuc = 1; Message = "Kayıt Güncellendi"; } var result = new { sonuc = islemsonuc, Message = Message }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public ActionResult Index(Resim file) { if (file.Dosya.ContentLength > 0) { var filenamecmr = Path.GetFileName(file.Dosya.FileName); var kayityeri = Path.Combine(@"C:/FRANCBELGELER", filenamecmr); if (System.IO.File.Exists(kayityeri)) { kayityeri = Path.Combine(@"C:/FRANCBELGELER", DateTime.Now.ToString("HHmmss") + filenamecmr); } else { } file.Dosya.SaveAs(kayityeri); DataTable dt = ConvertExcelToDataTable(kayityeri); int EmpID = -1; string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; try { using (SqlConnection conp = new SqlConnection(strcon)) { if (conp.State == ConnectionState.Closed) { conp.Open(); } using (SqlCommand command = new SqlCommand("SELECT MAX(ID)+1 From Cari", conp)) { EmpID = Convert.ToInt32(command.ExecuteScalar()); } } } catch { } if (EmpID == -1 || EmpID == 0) { EmpID = 1; } try { System.IO.File.WriteAllText(Path.Combine(@"C:\Users\alper\AppData\Local\Sayazilim", "sonuç.xml"), dt.Rows.Count.ToString()); } catch { } int aktarimsay = 0; using (sayazilimEntities db = new sayazilimEntities()) { for (int i = 0; i < dt.Rows.Count; i++) { string Yetkili = ""; bool kayitvar = false; using (SqlConnection con = new SqlConnection(strcon)) { con.Open(); using (SqlCommand carigetir = new SqlCommand(@"SELECT ID From Cari where ID='" + Convert.ToInt32(file.ID) + "'", con)) { using (SqlDataReader dr = carigetir.ExecuteReader()) { while (dr.Read()) { kayitvar = true; } } } } string FirmaKodu = ""; if (kayitvar == false) { try { FirmaKodu = dt.Rows[i]["Kod"].ToString(); } catch { } int FirmaID = Convert.ToInt32(Session["FirmaID"].ToString()); Cari cr = db.Cari.Where(x => x.FirmaKodu == FirmaKodu && x.FirmaID == FirmaID).FirstOrDefault <Cari>(); if (cr == null) { if (FirmaKodu != "") { string SonGorusme = ""; DateTime Duzenleme = DateTime.Now; try { Duzenleme = Convert.ToDateTime(dt.Rows[i]["Duzenleme"]); } catch { } string BasvuruSira = "BN" + EmpID.ToString(); string FirmaSira = "F" + EmpID.ToString(); Cari kayit = new Cari(); kayit.CariUnvan = dt.Rows[i]["Müşteri Adı"].ToString(); try { kayit.KTipi = dt.Rows[i]["C.Tipi"].ToString(); } catch { } kayit.Adres = dt.Rows[i]["Grubu"].ToString(); kayit.GSM = dt.Rows[i]["İletişim Bilgileri"].ToString(); kayit.FirmaKodu = FirmaKodu; kayit.paraBirimi = "TL"; string PersonelAdi = dt.Rows[i]["Temsilci"].ToString(); Personel pr = db.Personel.Where(x => x.Adi == PersonelAdi || x.FirmaID == FirmaID).FirstOrDefault <Personel>(); if (pr != null) { kayit.MusteriTemsilcisi = pr.ID; } try { kayit.Il = dt.Rows[i]["Şehir"].ToString(); } catch { } try { kayit.Ilce = dt.Rows[i]["İlçe"].ToString(); } catch { } db.Cari.Add(kayit); db.SaveChanges(); aktarimsay++; EmpID++; decimal alacak = Convert.ToDecimal(dt.Rows[i]["Alacak"].ToString()); decimal borc = Convert.ToDecimal(dt.Rows[i]["Borç"].ToString()); var carilist = db.Cari.OrderByDescending(x => x.ID).Take(1).ToList(); foreach (var item in carilist) { if (alacak > 0) { Bakiyeekle("CAF", item.ID, alacak, item.paraBirimi); } if (borc > 0) { Bakiyeekle("CBF", item.ID, borc, item.paraBirimi); } } } } } } } ViewBag.Aktarilan = "Başarılı Aktarılan Cari Sayısı: " + aktarimsay.ToString(); ViewBag.Sayi = "Toplam Cari Sayısı :" + aktarimsay.ToString(); ViewBag.Success = "CARİLER BAŞARIYLA AKTARILDI"; } //if the code reach here means everthing goes fine and excel data is imported into database return(View()); }
public ActionResult Data(Resim file) { if (file.Dosya.ContentLength > 0) { var filenamecmr = Path.GetFileName(file.Dosya.FileName); var kayityeri = Path.Combine(@"C:/FRANCBELGELER", filenamecmr); if (System.IO.File.Exists(kayityeri)) { kayityeri = Path.Combine(@"C:/FRANCBELGELER", filenamecmr); } else { } file.Dosya.SaveAs(kayityeri); DataTable dt = ConvertExcelToDataTable(kayityeri); int EmpID = -1; string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; try { using (SqlConnection conp = new SqlConnection(strcon)) { if (conp.State == ConnectionState.Closed) { conp.Open(); } using (SqlCommand command = new SqlCommand("SELECT MAX(ID)+1 From Stok", conp)) { EmpID = Convert.ToInt32(command.ExecuteScalar()); } } } catch { } if (EmpID == -1 || EmpID == 0) { EmpID = 1; } try { System.IO.File.WriteAllText(Path.Combine(@"C:\Users\alper\AppData\Local\Sayazilim", "sonuç.xml"), dt.Rows.Count.ToString()); } catch { } int aktarimsay = 0; using (sayazilimEntities db = new sayazilimEntities()) { for (int i = 0; i < dt.Rows.Count; i++) { string Yetkili = ""; bool kayitvar = false; if (kayitvar == false) { using (SqlConnection conp = new SqlConnection(strcon)) { if (conp.State == ConnectionState.Closed) { conp.Open(); } using (SqlDataAdapter daBASVURULAR = new System.Data.SqlClient.SqlDataAdapter("select Top 1 * from Stok", strcon)) { using (SqlCommandBuilder cb = new SqlCommandBuilder(daBASVURULAR)) { try { DateTime Duzenleme = DateTime.Now; string stokkodu = dt.Rows[i]["Kod"].ToString(); short firmaID = Convert.ToInt16(Session["FirmaID"].ToString()); Stok stk = db.Stok.Where(x => x.FirmaID == firmaID && x.StokKodu == stokkodu).FirstOrDefault <Stok>(); Stok st = new Stok(); if (stk != null) { AyarMetot.Siradaki("", "Stok", "StokKodu", Session["FirmaID"].ToString()); st.StokKodu = AyarMetot.GetNumara; } else { st.StokKodu = stokkodu; } st.UrunAdi = dt.Rows[i]["Ad"].ToString(); try { st.Marka = dt.Rows[i]["Marka"].ToString(); } catch { }; try { st.Grubu = dt.Rows[i]["Grubu"].ToString(); } catch { }; try { st.StoktaKalan = Convert.ToInt32(dt.Rows[i]["Ürün Miktarı"].ToString()); } catch { }; try { st.Kategori1 = dt.Rows[i]["Kategori1"].ToString(); } catch { }; try { st.Kategori2 = dt.Rows[i]["Kategori2"].ToString(); } catch { }; try { st.Kategori3 = dt.Rows[i]["Kategori3"].ToString(); } catch { }; try { st.Kategori4 = dt.Rows[i]["Kategori4"].ToString(); } catch { }; try { st.UrunTuru = dt.Rows[i]["Ürün Türü"].ToString(); } catch { }; try { st.AlishFiyat = Convert.ToInt32(dt.Rows[i]["Alış Fiyatı"].ToString()); } catch { }; try { st.SatishFiyat = Convert.ToInt32(dt.Rows[i]["Satış Fiyat"].ToString()); } catch { }; try { st.KDV = Convert.ToInt32(dt.Rows[i]["Kdv"].ToString()); } catch { }; try { st.ParaBirimi = dt.Rows[i]["Satış PB"].ToString(); } catch { }; try { st.Barkod = dt.Rows[i]["Barkod"].ToString(); } catch { }; try { st.F2 = Convert.ToInt32(dt.Rows[i]["F2"].ToString()); } catch { }; try { st.F4 = Convert.ToInt32(dt.Rows[i]["F4"].ToString()); } catch { }; try { st.F5 = Convert.ToInt32(dt.Rows[i]["F5"].ToString()); } catch { }; try { st.F3 = Convert.ToInt32(dt.Rows[i]["F3"].ToString()); } catch { }; try { string depoadi = dt.Rows[i]["Depo Adı"].ToString(); STORE store = db.STORE.Where(x => x.DepoAdi == depoadi && x.FirmaID == firmaID) .FirstOrDefault <STORE>(); st.SdepoID = store.ID; } catch { } st.FirmaID = firmaID; string firmaid = Session["FirmaID"].ToString(); string company_code = "SA01" + firmaid.PadLeft(3, '0'); st.Company_Code = company_code; aktarimsay++; db.Stok.Add(st); db.SaveChanges(); if (stk.StoktaKalan != 0) { int depoIslId = 0; using (SqlConnection con = new SqlConnection(AyarMetot.strcon)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter daDepoIslm = new System.Data.SqlClient.SqlDataAdapter("select Top 1 * from STORE_PROCESS", con)) { using (SqlCommandBuilder cb1 = new SqlCommandBuilder(daDepoIslm)) { DataSet dsDepoIslm = new DataSet(); daDepoIslm.Fill(dsDepoIslm, "STORE_PROCESS"); DataRow dd = dsDepoIslm.Tables["STORE_PROCESS"].NewRow(); dd["IslemKodu"] = stk.ID + "STK"; dd["IslemTarih"] = DateTime.Now.ToString("dd.MM.yyyy"); dd["GonderenDepoID"] = -1; dd["AlanDepoID"] = Session["vDepoID"].ToString(); dd["Aciklama"] = "Stok Açılış Depo Girişi " + DateTime.Now.ToString("dd.MM.yyyy"); dd["Tutar"] = stk.AlishFiyat * stk.StoktaKalan; dd["paraBirimi"] = stk.ParaBirimi; dd["personelID"] = AyarMetot.PersonelID; dd["Donem"] = AyarMetot.Donem; dd["KayitPersonelID"] = AyarMetot.PersonelID; dsDepoIslm.Tables["STORE_PROCESS"].Rows.Add(dd); daDepoIslm.Update(dsDepoIslm, "STORE_PROCESS"); } } } using (SqlConnection conp1 = new SqlConnection(AyarMetot.strcon)) { if (conp1.State == ConnectionState.Closed) { conp1.Open(); } using (SqlCommand sID = new SqlCommand(@"select top (1) ID FROM STORE_PROCESS Order BY ID Desc", conp1)) { depoIslId = Convert.ToInt32(sID.ExecuteScalar()); } } using (SqlConnection con = new SqlConnection(AyarMetot.strcon)) { if (con.State == ConnectionState.Closed) { con.Open(); } using (SqlDataAdapter daSDepoIslm = new System.Data.SqlClient.SqlDataAdapter("select Top 1 * from STORE_PROCESS_DETAIL", con)) { using (SqlCommandBuilder cb1 = new SqlCommandBuilder(daSDepoIslm)) { DataSet dsSDepoIslm = new DataSet(); daSDepoIslm.Fill(dsSDepoIslm, "STORE_PROCESS_DETAIL"); DataRow ds = dsSDepoIslm.Tables["STORE_PROCESS_DETAIL"].NewRow(); ds["DepoIslemID"] = depoIslId; ds["IslemTarihi"] = DateTime.Now.ToString("dd.MM.yyyy"); ds["gDepoID"] = -1; ds["aDepoID"] = Session["vDepoID"].ToString(); ds["urunID"] = stk.ID; ds["urunFiyat"] = stk.AlishFiyat; ds["urunMiktar"] = stk.StoktaKalan; ds["paraBirimi"] = stk.ParaBirimi; ds["variyantID"] = -1; ds["Kur"] = 1; ds["Donem"] = AyarMetot.Donem; ds["personelID"] = AyarMetot.PersonelID; ds["OzelKodID"] = -1; dsSDepoIslm.Tables["STORE_PROCESS_DETAIL"].Rows.Add(ds); daSDepoIslm.Update(dsSDepoIslm, "STORE_PROCESS_DETAIL"); } } } } EmpID++; } catch (Exception E1) { try { System.IO.File.WriteAllText(Path.Combine(@"C:\Users\alper\AppData\Local\Sayazilim", "sonuç.xml"), E1.ToString()); } catch { } } } } } } } } ViewBag.Aktarilan = "Başarılı Aktarılan Stok Sayısı: " + aktarimsay.ToString(); ViewBag.Sayi = "Toplam Stok Sayısı: " + aktarimsay.ToString(); ViewBag.Success = "STOKLAR BAŞARIYLA AKTARILDI"; } //if the code reach here means everthing goes fine and excel data is imported into database return(View()); }
public ActionResult DeletePersonel(int id) { using (sayazilimEntities db = new sayazilimEntities()) { Personel emp = db.Personel.Where(x => x.ID == id).FirstOrDefault <Personel>(); if (id == 1 || emp.PersonelGrubu == "Admin") { return(Json(new { success = false, message = "Bu kullanıcı silinemez." }, JsonRequestBehavior.AllowGet)); //if (Session["Grubu"].ToString() != "Admin") //{ // return Json(new {success = false, message = "Bu kullanıcı silinemez."}, // JsonRequestBehavior.AllowGet); //} //else //{ // using (SqlConnection conp = new System.Data.SqlClient.SqlConnection(AyarMetot.conString)) // { // conp.Open(); // SqlCommand cmd = new SqlCommand("IslemKontrolPersonel", conp); // cmd.CommandType = CommandType.StoredProcedure; // cmd.Parameters.AddWithValue("@PersonelID", emp.ID); // input parameter // // output parameter // SqlParameter average = new SqlParameter("@deger", SqlDbType.NVarChar, 50); // average.Direction = System.Data.ParameterDirection.Output; // cmd.Parameters.Add(average); // // return value // SqlParameter count = cmd.CreateParameter(); // count.Direction = System.Data.ParameterDirection.ReturnValue; // cmd.Parameters.Add(count); // cmd.ExecuteNonQuery(); // if (Convert.ToInt32(count.Value) != 0) // { // if (average.Value.ToString() == "İşlem") // { // return Json(new { success = false, message = "Bu Personele ait " + average.Value.ToString() + " işlem bulunmaktadır.Silinemez" }, JsonRequestBehavior.AllowGet); // } // else // { // return Json(new { success = false, message = "Kayıt silinirken bir hata oluştu." }, JsonRequestBehavior.AllowGet); // } // } // else // { // db.Personel.Remove(emp); // Yetkiler yet = db.Yetkiler.Where(x => x.PersonelID == id).FirstOrDefault<Yetkiler>(); // db.Yetkiler.Remove(yet); // db.SaveChanges(); // return Json(new { success = true, message = "Kayıt Silindi" }, JsonRequestBehavior.AllowGet); // } // } //} } else { using (SqlConnection conp = new System.Data.SqlClient.SqlConnection(AyarMetot.conString)) { conp.Open(); SqlCommand cmd = new SqlCommand("IslemKontrolPersonel", conp); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@PersonelID", emp.ID); // input parameter // output parameter SqlParameter average = new SqlParameter("@deger", SqlDbType.NVarChar, 50); average.Direction = System.Data.ParameterDirection.Output; cmd.Parameters.Add(average); // return value SqlParameter count = cmd.CreateParameter(); count.Direction = System.Data.ParameterDirection.ReturnValue; cmd.Parameters.Add(count); cmd.ExecuteNonQuery(); if (Convert.ToInt32(count.Value) != 0) { if (average.Value.ToString() == "İşlem") { return(Json(new { success = false, message = "Bu Personele ait " + average.Value.ToString() + " işlem bulunmaktadır.Silinemez" }, JsonRequestBehavior.AllowGet)); } else { return(Json(new { success = false, message = "Kayıt silinirken bir hata oluştu." }, JsonRequestBehavior.AllowGet)); } } else { db.Personel.Remove(emp); Yetkiler yet = db.Yetkiler.Where(x => x.PersonelID == id).FirstOrDefault <Yetkiler>(); db.Yetkiler.Remove(yet); db.SaveChanges(); return(Json(new { success = true, message = "Kayıt Silindi" }, JsonRequestBehavior.AllowGet)); } } } } }
public JsonResult YeniOzel(OzelKod dk) { OzelKod car = null; string Message = "Kayıt Eklendi"; if (dk.ID == -1) { car = new OzelKod(); car = dk; car.GrupAdi = dk.KodAdi; if (dk.ustKodID == null) { car.ustKodID = -1; } car.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); string firmaid = Session["FirmaID"].ToString(); string company_code = "SA01" + firmaid.PadLeft(3, '0'); car.Company_Code = company_code; db.OzelKod.Add(car); db.SaveChanges(); OzelKod car2 = db.OzelKod.OrderByDescending(x => x.ID).FirstOrDefault <OzelKod>(); KOD_BALANCE kd = new KOD_BALANCE(); kd.paraBirimi = "TL"; kd.Borc = 0; kd.Alacak = 0; kd.bakiye = 0; kd.ozelKodID = car2.ID; kd.FirmaID = -1; kd.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); firmaid = Session["FirmaID"].ToString(); company_code = "SA01" + firmaid.PadLeft(3, '0'); kd.Company_Code = company_code; db.KOD_BALANCE.Add(kd); db.SaveChanges(); } else { car = db.OzelKod.Where(x => x.ID == dk.ID).FirstOrDefault <OzelKod>(); car.KodAdi = dk.KodAdi; car.Kod = dk.Kod; car.paraBirimi = dk.paraBirimi; car.Kdv = dk.Kdv; car.ustKodID = dk.ustKodID; car.Aciklama = dk.Aciklama; car.ID = dk.ID; db.SaveChanges(); Message = "Kayıt Güncellendi"; } var result = new { sonuc = 1, Message = Message }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult yeniPersonel(Personel pr, Yetkiler yt) { string Message = "Kayıt Eklendi"; var result = new { sonuc = 0, Message = Message }; Personel per = null; if (pr.ID == -1) { per = new Personel(); per = pr; per.PB = "Varsayılan"; per.vKasaID = pr.vKasaID; per.vBankaID = pr.vBankaID; per.sCariID = Convert.ToInt32(Session["sCariID"].ToString()); per.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); string firmaid = Session["FirmaID"].ToString(); string company_code = "SA01" + firmaid.PadLeft(3, '0'); per.Company_Code = company_code; try { per.WebSifre = GirisKontrol.hash(pr.WebSifre, true); } catch (Exception e) { } try { db.Personel.Add(per); db.SaveChanges(); Personel person = db.Personel.OrderByDescending(x => x.ID).FirstOrDefault <Personel>(); Yetkiler yetki = new Yetkiler(); yetki = yt; yetki.PersonelID = person.ID; yetki.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); firmaid = Session["FirmaID"].ToString(); company_code = "SA01" + firmaid.PadLeft(3, '0'); yetki.Company_Code = company_code; db.Yetkiler.Add(yetki); db.SaveChanges(); } catch (Exception e) { Message = "Kayıt eklenirken bir hata oluştu."; result = new { sonuc = 0, Message = Message }; return(Json(result, JsonRequestBehavior.AllowGet)); } } else { per = db.Personel.Where(x => x.ID == pr.ID).FirstOrDefault <Personel>(); per.ID = pr.ID; per.Adi = pr.Adi; per.Soyadi = pr.Soyadi; per.PersonelGrubu = pr.PersonelGrubu; per.Milleti = pr.Milleti; per.TCNo = pr.TCNo; per.Cinsiyet = pr.Cinsiyet; per.Telefon1 = pr.Telefon1; per.Adres = pr.Adres; per.EkBilgiler = pr.EkBilgiler; per.BabaAdi = pr.BabaAdi; per.Maasi = pr.Maasi; per.IL = pr.IL; per.Ilce = pr.Ilce; per.EPosta = pr.EPosta; per.SicilNo = pr.SicilNo; per.WebKA = pr.WebKA; try { per.WebSifre = GirisKontrol.hash(pr.WebSifre, true); } catch (Exception e) { } per.Telefon2 = pr.Telefon2; per.vKasaID = pr.vKasaID; per.vBankaID = pr.vBankaID; Yetkiler yetki = db.Yetkiler.Where(x => x.PersonelID == per.ID).FirstOrDefault <Yetkiler>(); yetki.StokEG = yt.StokEG; yetki.StokSil = yt.StokSil; yetki.CariEG = yt.CariEG; yetki.CariSil = yt.CariSil; yetki.FaturaEG = yt.FaturaEG; yetki.FaturaSil = yt.FaturaSil; yetki.KasaEG = yt.KasaEG; yetki.KasaSil = yt.KasaSil; yetki.BankaEG = yt.BankaEG; yetki.BankaSil = yt.BankaSil; yetki.ServisEG = yt.ServisEG; yetki.ServisSil = yt.ServisSil; yetki.PersonelEG = yt.PersonelEG; yetki.PersonelSil = yt.PersonelSil; yetki.KrediKEG = yt.KrediKEG; yetki.KrediKSil = yt.KrediKSil; yetki.MaasEG = yt.MaasEG; yetki.MaasSil = yt.MaasSil; yetki.YazdirSec = yt.YazdirSec; yetki.KasaIslem = yt.KasaIslem; yetki.BankaIslem = yt.BankaIslem; yetki.ServisIslem = yt.ServisIslem; yetki.PersonelGorme = yt.PersonelGorme; yetki.IslemSilme = yt.IslemSilme; yetki.RaporGorme = yt.RaporGorme; yetki.Hatirlatma = yt.Hatirlatma; yetki.GelirGiderIslem = yt.GelirGiderIslem; yetki.MesajGonderme = yt.MesajGonderme; yetki.IslemGorme = yt.IslemGorme; yetki.DepoGorme = yt.DepoGorme; yetki.CariKartGor = yt.CariKartGor; yetki.CariBakiyeGor = yt.CariBakiyeGor; yetki.HizliSatisMenusuGor = yt.HizliSatisMenusuGor; yetki.SadeceKendiCarisi = yt.SadeceKendiCarisi; yetki.StokKartGor = yt.StokKartGor; yetki.StokBakiyeGor = yt.StokBakiyeGor; yetki.KendiDepoMiktari = yt.KendiDepoMiktari; yetki.FiyatDegistirme = yt.FiyatDegistirme; yetki.DusukFiyatSatis = yt.DusukFiyatSatis; yetki.EIrsaliyeKullan = yt.EIrsaliyeKullan; yetki.KasaDevri = yt.KasaDevri; yetki.KasaBankaBakGor = yt.KasaBankaBakGor; yetki.UretimGorunumuKullan = yt.UretimGorunumuKullan; yetki.HizliSatisSime = yt.HizliSatisSime; db.SaveChanges(); Message = "Kayıt Güncellendi"; } result = new { sonuc = 1, Message = Message }; return(Json(result, JsonRequestBehavior.AllowGet)); }
public JsonResult YeniKasa(Kasa dk) { Kasa car = null; string Message = "Kayıt Eklendi"; var result = new { sonuc = 1, Message = Message }; int firmaidsrg = Convert.ToInt32(Session["FirmaID"].ToString()); if (dk.ID == -1) { var kasalist = db.Kasa.Where(x => x.KasaKodu == dk.KasaKodu && x.FirmaID == firmaidsrg).ToList(); if (kasalist.Count == 0) { car = new Kasa(); dk.KayitT = DateTime.Now.ToString(""); car = dk; DateTime now = DateTime.Now; dk.KayitT = now.Day.ToString() + "." + now.Month.ToString() + "." + now.Year.ToString(); if (dk.ParaBirimi == "") { car.ParaBirimi = "TL"; } dk.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); dk.Merkez = false; string firmaid = Session["FirmaID"].ToString(); string company_code = "SA01" + firmaid.PadLeft(3, '0'); dk.Company_Code = company_code; db.Kasa.Add(car); db.SaveChanges(); var list = db.Kasa.OrderByDescending(x => x.ID).Take(1).ToList(); foreach (var item in list) { decimal tutar = Convert.ToDecimal(dk.Bakiye); Bakiyeekle("KAF", item.ID, tutar, dk.ParaBirimi); } } else { result = new { sonuc = 0, Message = "Aynı Kasa Kodu İle Kayıt Yapamazsınız." }; } } else { car = db.Kasa.Where(x => x.ID == dk.ID).FirstOrDefault <Kasa>(); car.KasaKodu = dk.KasaKodu; car.KasaAdi = dk.KasaAdi; car.ParaBirimi = dk.ParaBirimi; //car.Aciklama = dk.Aciklama; DateTime now = DateTime.Now; dk.KayitT = now.Day.ToString() + "." + now.Month.ToString() + "." + now.Year.ToString(); car.KayitT = dk.KayitT; car.ID = dk.ID; db.SaveChanges(); Message = "Kayıt Güncellendi"; } return(Json(result, JsonRequestBehavior.AllowGet)); }
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 YeniDekont(Dekont dk) { Dekont car = null; string Message = "Kayıt Eklendi"; if (dk.ID == -1) { car = new Dekont(); car = dk; if (dk.ParaBirimi == "") { car.ParaBirimi = "TL"; } if (dk.IslemTarih == "") { car.IslemTarih = DateTime.Now.ToString("dd.MM.yyyy"); } else { car.IslemTarih = Convert.ToDateTime(car.IslemTarih).ToString("dd.MM.yyyy"); } if (dk.VadeTarihi.ToString() == "") { car.VadeTarihi = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); } car.FirmaID = Convert.ToInt16(Session["FirmaID"].ToString()); car.PersonelID = Convert.ToInt32(Session["PersonelID"].ToString()); car.KayitPersonelID = Convert.ToInt32(Session["PersonelID"].ToString()); car.Donem = AyarMetot.Donem; car.Kur = 1; car.TLUSDKUR = 1; string firmaid = Session["FirmaID"].ToString(); string company_code = "SA01" + firmaid.PadLeft(3, '0'); car.Company_Code = company_code; db.Dekont.Add(car); db.SaveChanges(); } else { car = db.Dekont.Where(x => x.ID == dk.ID).FirstOrDefault <Dekont>(); car.IslemNo = dk.IslemNo; car.IslemTipi = dk.IslemTipi; car.ParaBirimi = dk.ParaBirimi; if (dk.ParaBirimi == "") { car.ParaBirimi = "TL"; } car.OzelKodID = dk.OzelKodID; if (dk.IslemTarih == "") { car.IslemTarih = DateTime.Now.ToString("dd.MM.yyyy"); } else { car.IslemTarih = Convert.ToDateTime(car.IslemTarih).ToString("dd.MM.yyyy"); } if (dk.VadeTarihi.ToString() == "") { car.VadeTarihi = Convert.ToDateTime(DateTime.Now.ToString("yyyy-MM-dd")); } car.Tutar = dk.Tutar; car.Aciklama = dk.Aciklama; car.ID = dk.ID; db.SaveChanges(); Message = "Kayıt Güncellendi"; } var result = new { sonuc = 1, Message = Message }; return(Json(result, JsonRequestBehavior.AllowGet)); }