public ActionResult DekontBilgi(int id) { using (sayazilimEntities db = new sayazilimEntities()) { Dekont emp = db.Dekont.Where(x => x.ID == id).FirstOrDefault <Dekont>(); emp.IslemTarih = Convert.ToDateTime(emp.IslemTarih).ToString("yyyy-MM-dd"); string vadetarihi = Convert.ToDateTime(emp.VadeTarihi).ToString("yyyy-MM-dd"); Cari cr = db.Cari.Where(x => x.ID == emp.CariID).FirstOrDefault(); return(Json(new { success = true, data = emp, vadetarihi = vadetarihi }, 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 BankaBilgi(int id) { ViewBag.BankaIslemID = 0; int FirmaID = Convert.ToInt32(Session["FirmaID"].ToString()); using (sayazilimEntities db = new sayazilimEntities()) { Banka emp = db.Banka.Where(x => x.ID == id).FirstOrDefault <Banka>(); if (emp != null) { ViewBag.BankaID = emp.ID; ViewBag.BankaBakiye = emp.Bakiye.ToString(); } return(Json(new { success = true, data = emp }, 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 ActionResult PersonelBilgi(int id) { using (sayazilimEntities db = new sayazilimEntities()) { Personel emp = db.Personel.Where(x => x.ID == id).FirstOrDefault <Personel>(); string websifre = GirisKontrol.unhash(emp.WebSifre, true); emp.WebSifre = websifre; Yetkiler yt = db.Yetkiler.Where(x => x.PersonelID == id).FirstOrDefault <Yetkiler>(); PersonelBilgiEk personel = new PersonelBilgiEk(); personel.pr = emp; personel.yt = yt; return(Json(new { success = true, data = personel }, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteDepoDetay(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_DETAIL where ID='" + id + "'", conp)) { sqlWrite.ExecuteNonQuery(); } } db.SaveChanges(); return(Json(new { success = true, message = "Kayıt Silindi" }, JsonRequestBehavior.AllowGet)); } }
public ActionResult KasaBilgi(int id) { ViewBag.KasaIslemID = 0; using (sayazilimEntities db = new sayazilimEntities()) { Kasa emp = db.Kasa.Where(x => x.ID == id).FirstOrDefault <Kasa>(); if (emp != null) { ViewBag.KasaTutar = emp.Bakiye.ToString(); ViewBag.KasaID = id; } //if (emp.ParaBirimi == "TL") //{ // emp.Bakiye = emp. //} return(Json(new { success = true, data = emp }, JsonRequestBehavior.AllowGet)); } }
public ActionResult DeleteFinans(int id, string tablo) { string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; string tabloadi = ""; using (sayazilimEntities db = new sayazilimEntities()) { string sorg2 = "DELETE FROM " + tablo + " WHERE ID = " + id.ToString(); using (SqlConnection conp1 = new SqlConnection(AyarMetot.strcon)) { conp1.Open(); using (SqlCommand cu = new SqlCommand(sorg2, conp1)) { cu.ExecuteNonQuery().ToString(); } } return(Json(new { success = true, message = "Kayıt Silindi" }, 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 FileResult PerkandeYazdir(string ID = "") { sayazilimEntities db = new sayazilimEntities(); int firmaid = Convert.ToInt32(Session["FirmaID"].ToString()); RETAIL perakende = db.RETAIL.Where(x => x.FirmaID == firmaid).OrderByDescending(x => x.ID).FirstOrDefault(); FastReport.Utils.Config.WebMode = true; FastReport.Report report1 = new FastReport.Report(); report1.Prepare(true); try { report1.Load(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "Cash.frx")); } catch { report1.Load(Path.Combine(Server.MapPath("~/REPORTS/Default"), "Cash.frx")); } using (SqlConnection conp = new SqlConnection(AyarMetot.strcon)) { if (conp.State == ConnectionState.Closed) { conp.Open(); } using (SqlCommand getir = new SqlCommand("Select CariID From CASH_PAY where ID='" + ID + "'", conp)) { using (SqlDataReader dr = getir.ExecuteReader()) { while (dr.Read()) { using (DataTable Teklifler = GetDataTable("set dateformat dmy;SELECT * ,(Select Adi+' '+Soyadi from Personel where ID=PersonelID) as PersonelAdi From CASH_PAY where ID = '" + ID + "'")) { report1.RegisterData(Teklifler.DefaultView.ToTable(), "NakitHavale"); report1.GetDataSource("NakitHavale").Enabled = true; } report1.RegisterData(AyarMetot.CariBil(Convert.ToInt32(dr["CariID"]), "Tümü", "", "Tümü", "Tümü"), "CariBilgileri"); report1.RegisterData(AyarMetot.FirmaBil(), "FirmaBilgileri"); report1.GetDataSource("CariBilgileri").Enabled = true; report1.GetDataSource("FirmaBilgileri").Enabled = true; } } } } using (FastReport.Export.Pdf.PDFExport pdf = new FastReport.Export.Pdf.PDFExport()) { byte[] dosya; try { dosya = System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "Cash.pdf")); } catch { dosya = System.IO.File.ReadAllBytes(Path.Combine(Server.MapPath("~/REPORTS/Default"), "Cash.pdf")); } try { report1.Prepare(true); try { report1.Export(pdf, Path.Combine(Server.MapPath("~/REPORTS/" + Session["FirmaID"].ToString()), "Cash.pdf")); } catch { report1.Export(pdf, Path.Combine(Server.MapPath("~/REPORTS/Default"), "Cash.pdf")); } System.IO.MemoryStream ms = new System.IO.MemoryStream(); //report1.Save(Path.Combine(Server.MapPath("~/REPORTS/ATTACHMENT"),"b.frx")); report1.Dispose(); return(File(dosya, "application/pdf")); } catch (Exception e) { return(File(dosya, "application/pdf")); } } }
public ActionResult Login(LoginViewModel model, string returnUrl) { if (!ModelState.IsValid) { return(View(model)); } var data = GirisKontrol.EntranceControl(model.UserName, model.Password, AyarMetot.strcon); Session["Bayi"] = ""; if (data.PersonelID == 0) { ModelState.AddModelError("", "Kullanıcı Bulunamadı.Kullanıcı Adı ve Şifrenizi Kontrol Ediniz!"); return(View()); } else { Session["UserName"] = data.UserName; Session["PersonelID"] = data.PersonelID; Session["PersonelType"] = data.PersonelType; if (data.PersonelType == 3) { Session["Bayi"] = "Bayi"; } Session["User"] = data; Session["RaporGor"] = data.RaporGor; Session["PersonelAdi"] = data.PersonelAdi; Session["vDepoID"] = data.vDepoID; Session["vKasaID"] = data.vKasaID; Session["FirmaID"] = data.FirmaID; ViewBag.AyarmetotFirmaID = data.FirmaID; Session["Company_Code"] = data.Company_Code; Session["vBankaID"] = data.vBankaID; Session["vKKTID"] = data.vKKTID; Session["Grubu"] = data.PersonelGrubu; AyarMetot.pKasaID = Convert.ToInt32(data.vKasaID); try { AyarMetot.pKKTID = Convert.ToInt32(data.vKKTID); } catch { } AyarMetot.pBankaID = Convert.ToInt32(data.vBankaID); Session["PaketTipi"] = data.PaketTipi; if (data.UserName == "tani") { Session["PaketTipi"] = "Servis"; } Session["sCariID"] = data.sCariID; Session["FirmaKodu"] = data.FirmaKodu; Session["sCariID"] = data.sCariID; ViewBag.ParaBirimi = data.PB; sayazilimEntities db = new sayazilimEntities(); try { Personel list = db.Personel.Where(x => x.ID == data.PersonelID).FirstOrDefault <Personel>(); ViewBag.TemsilciID = list.Adi; } catch (Exception e) { } if (Session["vDepoID"] != null) { if (Session["vDepoID"].ToString() == "") { Session["vDepoID"] = 1; } } else { Session["vDepoID"] = 1; } using (SqlConnection bag = new SqlConnection(AyarMetot.strcon)) { if (bag.State == ConnectionState.Closed) { bag.Open(); } using (SqlCommand sayarlar = new SqlCommand("Select * From Ayarlar where FirmaID=" + data.FirmaID, bag)) { using (SqlDataReader dr = sayarlar.ExecuteReader()) { while (dr.Read()) { if (dr["vrsPBName"] != DBNull.Value) { AyarMetot.PB_Long = dr["vrsPBName"].ToString(); } if (dr["vrsPBCode"] != DBNull.Value) { AyarMetot.PB_Short = dr["vrsPBCode"].ToString(); } if (dr["NegatifUrunKontrolu"] != DBNull.Value) { AyarMetot.NegatifUrunKontrolu = dr["NegatifUrunKontrolu"].ToString(); } try { if (dr["HizliBitir"] != DBNull.Value) { AyarMetot.HizliBitir = dr["HizliBitir"].ToString(); } } catch { } if (dr["SslDurumu"] != DBNull.Value) { AyarMetot.MailSsl = Convert.ToBoolean(dr["SslDurumu"]); } if (dr["EmanetTakibi"] != DBNull.Value) { AyarMetot.EmanetTakibi = Convert.ToBoolean(dr["EmanetTakibi"]); } if (dr["Fabrika"] != DBNull.Value) { AyarMetot.EmanetTakibi = Convert.ToBoolean(dr["Fabrika"]); } if (dr["KodileArama"] != DBNull.Value) { AyarMetot.KodileArama = Convert.ToBoolean(dr["KodileArama"]); } if (dr["fMail"] != DBNull.Value) { AyarMetot.FMail = dr["fMail"].ToString(); } if (dr["fMailSifre"] != DBNull.Value) { if (dr["fMailSifre"].ToString() != "") { AyarMetot.fMailSifre = KODLA.Ac(dr["fMailSifre"].ToString(), AyarMetot.ilhan_Control); } } if (dr["fMailSender"] != DBNull.Value) { AyarMetot.fMailSender = dr["fMailSender"].ToString(); } if (dr["fPort"] != DBNull.Value) { AyarMetot.FPort = Convert.ToInt32(dr["fPort"]); } if (dr["SMSUser"] != DBNull.Value) { AyarMetot.SMSUser = dr["SMSUser"].ToString(); } if (dr["SMSPass"] != DBNull.Value) { if (dr["SMSPass"].ToString() != "") { try { AyarMetot.SMSPass = KODLA.Ac(dr["SMSPass"].ToString(), AyarMetot.ilhan_Control); } catch { AyarMetot.SMSPass = ""; } } } if (dr["SMSSender"] != DBNull.Value) { AyarMetot.SMSSender = dr["SMSSender"].ToString(); } if (dr["PostaSunucu"] != DBNull.Value) { AyarMetot.PostaSunucu = dr["PostaSunucu"].ToString(); } if (dr["EFatPK"] != DBNull.Value) { AyarMetot.CompanyaliciKutusu = dr["EFatPK"].ToString(); } if (dr["EFatGB"] != DBNull.Value) { AyarMetot.CompanyGIBKutusu = dr["EFatGB"].ToString(); } if (dr["EFatKA"] != DBNull.Value) { AyarMetot.CompanyKullanici = dr["EFatKA"].ToString(); } if (dr["EFatSifre"] != DBNull.Value) { AyarMetot.CompanySifre = dr["EFatSifre"].ToString(); } if (dr["StokYuvarlamaSayisi"] != DBNull.Value) { AyarMetot.Amount_Yuvarlama = Convert.ToInt32(dr["StokYuvarlamaSayisi"]); } if (dr["StokYuvarlamaSayisi"] != DBNull.Value) { AyarMetot.Stok_Yuvarlama = Convert.ToInt32(dr["StokYuvarlamaSayisi"]); } if (dr["FiyatYuvarlamaSayisi"] != DBNull.Value) { AyarMetot.Price_Yuvarlama = Convert.ToInt32(dr["FiyatYuvarlamaSayisi"]); } if (dr["GenelYuvarlamaSayisi"] != DBNull.Value) { AyarMetot.YuvarlamaSayisi = Convert.ToInt32(dr["GenelYuvarlamaSayisi"]); AyarMetot.General_YuvarlamaString = "N" + dr["GenelYuvarlamaSayisi"].ToString(); } if (dr["SmsFirma"] != DBNull.Value) { AyarMetot.SmsFirma = dr["SmsFirma"].ToString(); } if (dr["OrtakBelge"] != DBNull.Value) { AyarMetot.OrtakBelge = dr["OrtakBelge"].ToString(); } if (dr["TerminalTuru"] != DBNull.Value) { AyarMetot.ProTerminal = dr["TerminalTuru"].ToString(); } if (dr["FaturaEkranindaCari"] != DBNull.Value) { AyarMetot.FaturaEkranindaCari = Convert.ToBoolean(dr["FaturaEkranindaCari"]); } if (dr["OzelKodOrderNo"] != DBNull.Value) { AyarMetot.OzelKodOrderNo = Convert.ToBoolean(dr["OzelKodOrderNo"]); } if (dr["FaturadaFireGirisi"] != DBNull.Value) { AyarMetot.FaturadaFireGirisi = Convert.ToBoolean(dr["FaturadaFireGirisi"]); } if (dr["BoyutSecimi"] != DBNull.Value) { AyarMetot.BoyutSecimi = dr["BoyutSecimi"].ToString(); } try { data.PaketTipi = KODLA.Ac(dr["Version"].ToString(), AyarMetot.ilhan_Control); Session["PaketTipi"] = KODLA.Ac(dr["Version"].ToString(), AyarMetot.ilhan_Control); } catch { } var pakettipi = Session["PaketTipi"].ToString(); break; } } } } Session["TerminalTuru"] = AyarMetot.ProTerminal; data.TerminalTuru = AyarMetot.ProTerminal; int firmaid = Convert.ToInt32(data.FirmaID); Firmalar fr = db.Firmalar.Where(x => x.FirmaID == firmaid).FirstOrDefault <Firmalar>(); if (DateTime.Now < fr.KayitTarih) { TimeSpan kalangun = Convert.ToDateTime(fr.KayitTarih) - DateTime.Now; int kalangun2 = Convert.ToInt32(kalangun.TotalDays); Session["KalanGun"] = kalangun2; bool demodurum = Convert.ToBoolean(fr.Demo); int firmaid2 = Convert.ToInt32(fr.FirmaID); var stok = db.Stok.Where(x => x.FirmaID == firmaid2).ToList(); var cari = db.Cari.Where(x => x.FirmaID == firmaid2).ToList(); Session["DemoDurum"] = demodurum.ToString(); if (demodurum == true) { Session["DemoDurum"] = "Demo"; ViewBag.DemoDurum = "Demo"; } else { } if (demodurum == true && stok.Count == 0 && cari.Count == 0) { return(RedirectToAction("DemoAnasayfa", "AnaSayfa")); } if (data.PersonelGrubu == "Kurye") { return(RedirectToAction("Orders", "Orders")); } else if (data.PersonelType == 4) { return(RedirectToAction("Index", "ServisList")); } else if (data.PersonelType == 5) { return(RedirectToAction("OnMuhasebeAnaSayfa", "AnaSayfa")); } else if (data.PaketTipi == "Ön Muhasebe 1") { return(RedirectToAction("OnMuhasebeAnaSayfa", "AnaSayfa")); } else if (data.PaketTipi == "Ön Muhasebe 2") { return(RedirectToAction("OnMuhasebeAnaSayfa", "AnaSayfa")); } else if (data.PaketTipi == "Servis1") { return(RedirectToAction("AnaSayfa", "AnaSayfa")); } else if (data.PaketTipi == "Servis") { return(RedirectToAction("AnaSayfa", "AnaSayfa")); } else if (data.PaketTipi == "Servis2") { return(RedirectToAction("AnaSayfa", "AnaSayfa")); } else if (data.PaketTipi == "Ön Muhasebe 2") { return(RedirectToAction("OnMuhasebeAnaSayfa", "AnaSayfa")); } else if (data.PaketTipi == "Perakende 1") { return(RedirectToAction("OnMuhasebeAnaSayfa", "AnaSayfa")); } else { return(RedirectToAction("OnMuhasebeAnaSayfa", "AnaSayfa")); } } else { return(RedirectToAction("Login", "Login")); } } }
public ActionResult DeleteBanka(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()) { Banka emp = db.Banka.Where(x => x.ID == id).FirstOrDefault <Banka>(); if (emp.Merkez == true) { return(Json(new { success = false, message = "Merkez Banka Silinemez." }, JsonRequestBehavior.AllowGet)); } else { using (SqlConnection conp = new System.Data.SqlClient.SqlConnection(AyarMetot.conString)) { conp.Open(); SqlCommand cmd = new SqlCommand("IslemKontrolBanka", conp); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@BankaID", 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 Bankaya Ait " + average.Value.ToString() + " 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.Banka.Remove(emp); db.SaveChanges(); return(Json(new { success = true, message = "Kayıt Silindi" }, JsonRequestBehavior.AllowGet)); } } } } } }
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 ActionResult OnMuhasebeAnaSayfa() { #region bankakontrol using (SqlConnection con45 = new System.Data.SqlClient.SqlConnection(AyarMetot.conString)) { con45.Open(); using (SqlConnection con = new System.Data.SqlClient.SqlConnection(AyarMetot.conString)) { con.Open(); using (SqlCommand kasacik = new SqlCommand("select ID from Banka", con)) { using (SqlDataReader rdr1 = kasacik.ExecuteReader()) { while (rdr1.Read()) { using (SqlCommand BN = new SqlCommand("BakiyeBanka", con45)) { BN.CommandType = CommandType.StoredProcedure; BN.Parameters.AddWithValue("@BankaID", rdr1["ID"].ToString()); BN.Parameters.AddWithValue("@ParaBirimi", "TL"); BN.ExecuteNonQuery(); } using (SqlCommand BN = new SqlCommand("BakiyeBanka", con45)) { BN.CommandType = CommandType.StoredProcedure; BN.Parameters.AddWithValue("@BankaID", rdr1["ID"].ToString()); BN.Parameters.AddWithValue("@ParaBirimi", "EUR"); BN.ExecuteNonQuery(); } using (SqlCommand BN = new SqlCommand("BakiyeBanka", con45)) { BN.CommandType = CommandType.StoredProcedure; BN.Parameters.AddWithValue("@BankaID", rdr1["ID"].ToString()); BN.Parameters.AddWithValue("@ParaBirimi", "USD"); BN.ExecuteNonQuery(); } } } } } } #endregion #region kasakontrol using (SqlConnection con45 = new System.Data.SqlClient.SqlConnection(AyarMetot.conString)) { con45.Open(); using (SqlCommand kasacik = new SqlCommand("select ID from Kasa", con45)) { using (SqlDataReader dr = kasacik.ExecuteReader()) { while (dr.Read()) { using (SqlConnection conp = new System.Data.SqlClient.SqlConnection(AyarMetot.conString)) { conp.Open(); using (SqlCommand kasasay = new SqlCommand("BakiyeKasa", conp)) { kasasay.CommandType = CommandType.StoredProcedure; kasasay.Parameters.AddWithValue("@KasaID", dr["ID"].ToString()); kasasay.Parameters.AddWithValue("@ParaBirimi", "TL"); kasasay.ExecuteNonQuery(); } using (SqlCommand kasasay = new SqlCommand("BakiyeKasa", conp)) { kasasay.CommandType = CommandType.StoredProcedure; kasasay.Parameters.AddWithValue("@KasaID", dr["ID"].ToString()); kasasay.Parameters.AddWithValue("@ParaBirimi", "EUR"); kasasay.ExecuteNonQuery(); } using (SqlCommand kasasay = new SqlCommand("BakiyeKasa", conp)) { kasasay.CommandType = CommandType.StoredProcedure; kasasay.Parameters.AddWithValue("@KasaID", Convert.ToInt32(dr["ID"].ToString())); kasasay.Parameters.AddWithValue("@ParaBirimi", "USD"); kasasay.ExecuteNonQuery(); } using (SqlCommand kasasay = new SqlCommand("BakiyeKasa", conp)) { kasasay.CommandType = CommandType.StoredProcedure; kasasay.Parameters.AddWithValue("@KasaID", Convert.ToInt32(dr["ID"].ToString())); kasasay.Parameters.AddWithValue("@ParaBirimi", "GBP"); kasasay.ExecuteNonQuery(); } } } } } } #endregion GelirGider gt = new GelirGider() { GelirPzt = 0, GelirSali = 0, GelirCar = 0, GelirPer = 0, GelirCuma = 0, GelirCmr = 0, GelirPaz = 0, GiderPzt = 0, GiderSali = 0, GiderCar = 0, GiderPer = 0, GiderCuma = 0, GiderCmr = 0, GiderPaz = 0, AylikGelirKaydi = 0, AylikGiderKaydi = 0, }; DateTime haftaninilkgunu = HataninIlkgunu(); for (int j = 0; j < 6; j++) { decimal sonucGelir = 0; decimal sonucGider = 0; decimal AylikMasraf = 0; decimal AylikGelir = 0; DateTime bas = haftaninilkgunu; try { using (SqlConnection conp = new SqlConnection(AyarMetot.conString)) { conp.Open(); string srg = "set dateformat dmy;select Sum(Tutar) from IslemlerListesi where BA='(A)' and (CONVERT(datetime, IslemTarihi) BETWEEN convert(datetime, '" + bas.ToString("dd.MM.yyyy") + " 00:00:00.000" + "') AND convert(datetime, '" + bas.ToString("dd.MM.yyyy") + " 23:59:59.000" + "')) "; SqlCommand command = new SqlCommand("set dateformat dmy;select Sum(Tutar) from IslemlerListesi where BA='(A)' and (CONVERT(datetime, IslemTarihi) BETWEEN convert(datetime, '" + bas.ToString("dd.MM.yyyy") + " 00:00:00.000" + "') AND convert(datetime, '" + bas.ToString("dd.MM.yyyy") + " 23:59:59.000" + "')) ", conp); sonucGider = Convert.ToDecimal(command.ExecuteScalar()); } } catch (Exception e1) { } try { using (SqlConnection conp = new SqlConnection(AyarMetot.conString)) { conp.Open(); SqlCommand command = new SqlCommand("set dateformat dmy;select Sum(Tutar) from IslemlerListesi where BA='(B)' and (CONVERT(datetime, IslemTarihi) BETWEEN convert(datetime, '" + bas.ToString("dd.MM.yyyy") + " 00:00:00.000" + "') AND convert(datetime, '" + bas.ToString("dd.MM.yyyy") + " 23:59:59.000" + "')) ", conp); sonucGelir = Convert.ToDecimal(command.ExecuteScalar()); } } catch { } try { using (SqlConnection conp = new SqlConnection(AyarMetot.conString)) { conp.Open(); SqlCommand command = new SqlCommand( " set dateformat dmy;Select SUM(Tutar) as Toplam from CASH_PAY where IslemTarih>dateadd(day,-30,getdate()) and (IslemTipi = 'A' or IslemTipi = 'E')", conp); AylikMasraf = Convert.ToDecimal(Convert.ToDecimal(command.ExecuteScalar()).ToString("N2")); gt.AylikGiderKaydi = AylikMasraf; } } catch (Exception e1) { } try { using (SqlConnection conp = new SqlConnection(AyarMetot.conString)) { conp.Open(); SqlCommand command = new SqlCommand( " set dateformat dmy;Select SUM(Tutar) as Toplam from CASH_PAY where IslemTarih>dateadd(day,-30,getdate()) and (IslemTipi = 'M' or IslemTipi = 'B')", conp); AylikGelir = Convert.ToDecimal(Convert.ToDecimal(command.ExecuteScalar()).ToString("N2")); gt.AylikGelirKaydi = AylikGelir; } } catch (Exception e1) { } if (j == 0) { gt.GelirPzt = sonucGelir; gt.GiderPzt = sonucGider; } else if (j == 1) { gt.GelirSali = sonucGelir; gt.GiderSali = sonucGider; } else if (j == 2) { gt.GelirCar = sonucGelir; gt.GiderCar = sonucGider; } else if (j == 3) { gt.GelirPer = sonucGelir; gt.GiderPer = sonucGider; } else if (j == 4) { gt.GelirCuma = sonucGelir; gt.GiderCuma = sonucGider; } else if (j == 5) { gt.GelirCmr = sonucGelir; gt.GiderCmr = sonucGider; } else if (j == 6) { gt.GelirPaz = sonucGelir; gt.GiderPaz = sonucGider; } haftaninilkgunu = haftaninilkgunu.AddDays(1); } GelirGider GT1 = gt; string strcon = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString; string SorguFirmaID = Session["FirmaID"].ToString(); string TLSorgu = @"select top 5 c.ID,c.CariUnvan,c.paraBirimi, SUM(alacakB-borcB) as [Bakiye] from Cari C INNER JOIN BALANCE B ON cariID=C.ID and C.paraBirimi='TL' and C.FirmaID =" + SorguFirmaID + @"group by c.CariUnvan,c.ID,c.paraBirimi having SUM(alacakB-borcB) <= 0 order by [Bakiye]"; string EuroSorgu = @"select top 5 c.ID,c.CariUnvan,c.paraBirimi, SUM(alacakB-borcB) as [Bakiye] from Cari C INNER JOIN BALANCE B ON cariID=C.ID and C.paraBirimi='EUR' and C.FirmaID =" + SorguFirmaID + @"group by c.CariUnvan,c.ID,c.paraBirimi having SUM(alacakB-borcB) <= 0 order by [Bakiye]"; string USDSorgu = @"select top 5 c.ID,c.CariUnvan,c.paraBirimi, SUM(alacakB-borcB) as [Bakiye] from Cari C INNER JOIN BALANCE B ON cariID=C.ID and C.paraBirimi='USD' and C.FirmaID =" + SorguFirmaID + @"group by c.CariUnvan,c.ID,c.paraBirimi having SUM(alacakB-borcB) <= 0 order by [Bakiye]"; #region ViewBagler int i = 0; string bakiye1 = ""; int bakiye = 0; ViewBag.TLName1 = ""; ViewBag.TlBakiye1 = 0; ViewBag.TLName2 = ""; ViewBag.TlBakiye2 = 0; ViewBag.TLName3 = ""; ViewBag.TlBakiye3 = 0; ViewBag.TLName4 = ""; ViewBag.TlBakiye4 = 0; ViewBag.TLName5 = ""; ViewBag.TlBakiye5 = 0; ViewBag.USDName1 = ""; ViewBag.USDBakiye1 = 0; ViewBag.USDName2 = ""; ViewBag.USDBakiye2 = 0; ViewBag.USDName3 = ""; ViewBag.USDBakiye3 = 0; ViewBag.USDName4 = ""; ViewBag.USDBakiye4 = 0; ViewBag.USDName5 = ""; ViewBag.USDBakiye5 = 0; ViewBag.EURName1 = ""; ViewBag.EURBakiye1 = 0; ViewBag.EURName2 = ""; ViewBag.EURBakiye2 = 0; ViewBag.EURName3 = ""; ViewBag.EURBakiye3 = 0; ViewBag.EURName4 = ""; ViewBag.EURBakiye4 = 0; ViewBag.EURName5 = ""; ViewBag.EURBakiye5 = 0; ViewBag.TlBankaName = ""; ViewBag.TlBankaBakiye = 0; ViewBag.EurBankaName = ""; ViewBag.EurBankaBakiye = ""; ViewBag.UsdBankaName = ""; ViewBag.UsdBankaBakiye = 0; ViewBag.TlKasaName = ""; ViewBag.TlKasaBakiye = 0; ViewBag.EurKasaName = ""; ViewBag.EurKasaBakiye = ""; ViewBag.UsdKasaName = ""; ViewBag.UsdKasaBakiye = 0; #endregion try { using (SqlConnection con = new SqlConnection(strcon)) { i = 0; con.Open(); using (SqlCommand carigetir = new SqlCommand(TLSorgu, con)) { using (SqlDataReader dr = carigetir.ExecuteReader()) { while (dr.Read()) { if (i == 0) { ViewBag.TLName1 = dr["CariUnvan"].ToString(); ViewBag.TlBakiye1 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.TlBakiye1 = dr["Bakiye"].ToString(); } } if (i == 1) { ViewBag.TLName2 = dr["CariUnvan"].ToString(); ViewBag.TlBakiye2 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.TlBakiye2 = dr["Bakiye"].ToString(); } } if (i == 2) { ViewBag.TLName3 = dr["CariUnvan"].ToString(); ViewBag.TlBakiye3 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.TlBakiye3 = dr["Bakiye"].ToString(); } } if (i == 3) { ViewBag.TLName4 = dr["CariUnvan"].ToString(); ViewBag.TlBakiye4 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.TlBakiye4 = dr["Bakiye"].ToString(); } } if (i == 4) { ViewBag.TLName5 = dr["CariUnvan"].ToString(); ViewBag.TlBakiye5 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.TlBakiye5 = dr["Bakiye"].ToString(); } } i++; } } } } using (SqlConnection con = new SqlConnection(strcon)) { i = 0; con.Open(); using (SqlCommand carigetir = new SqlCommand(USDSorgu, con)) { using (SqlDataReader dr = carigetir.ExecuteReader()) { while (dr.Read()) { if (i == 0) { ViewBag.USDName1 = dr["CariUnvan"].ToString(); ViewBag.USDBakiye1 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.USDBakiye1 = dr["Bakiye"].ToString(); } } if (i == 1) { ViewBag.USDName2 = dr["CariUnvan"].ToString(); ViewBag.USDBakiye2 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.USDBakiye2 = dr["Bakiye"].ToString(); } } if (i == 2) { ViewBag.USDName3 = dr["CariUnvan"].ToString(); ViewBag.USDBakiye3 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.USDBakiye3 = dr["Bakiye"].ToString(); } } if (i == 3) { ViewBag.USDName4 = dr["CariUnvan"].ToString(); ViewBag.USDBakiye4 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.USDBakiye4 = dr["Bakiye"].ToString(); } } if (i == 4) { ViewBag.USDName5 = dr["CariUnvan"].ToString(); ViewBag.USDBakiye5 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.USDBakiye5 = dr["Bakiye"].ToString(); } } i++; } } } } using (SqlConnection con = new SqlConnection(strcon)) { i = 0; con.Open(); using (SqlCommand carigetir = new SqlCommand(EuroSorgu, con)) { using (SqlDataReader dr = carigetir.ExecuteReader()) { while (dr.Read()) { if (i == 0) { ViewBag.EURName1 = dr["CariUnvan"].ToString(); ViewBag.EURBakiye1 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.EURBakiye1 = dr["Bakiye"].ToString(); } } if (i == 1) { ViewBag.EURName2 = dr["CariUnvan"].ToString(); ViewBag.EURBakiye2 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.EURBakiye2 = dr["Bakiye"].ToString(); } } if (i == 2) { ViewBag.EURName3 = dr["CariUnvan"].ToString(); ViewBag.EURBakiye3 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.EURBakiye3 = dr["Bakiye"].ToString(); } } if (i == 3) { ViewBag.EURName4 = dr["CariUnvan"].ToString(); ViewBag.EURBakiye4 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() == "0,000000") { ViewBag.EURBakiye4 = dr["Bakiye"].ToString(); } } if (i == 4) { ViewBag.EURName5 = dr["CariUnvan"].ToString(); ViewBag.EURBakiye5 = dr["Bakiye"].ToString().Remove(0, 1); if (dr["Bakiye"].ToString() != "0,000000") { ViewBag.EURBakiye5 = dr["Bakiye"].ToString(); } } i++; } } } con.Close(); } } catch (Exception e1) { } int FirmaID = 1; try { FirmaID = Convert.ToInt32(Session["FirmaID"].ToString()); } catch (Exception e) { FirmaID = 1; } #region Faturalar sayazilimEntities db = new sayazilimEntities(); var Carilist = db.Cari.Where(x => x.FirmaID == FirmaID).ToList(); ViewBag.CariSayisi = Carilist.Count; var AlımFaturası = db.INVOICE.Where(x => x.FirmaID == FirmaID & x.fType == "alimF").ToList(); var SatisFaturasi = db.INVOICE.Where(x => x.FirmaID == FirmaID & x.fType == "satisF").ToList(); decimal toplam = 0; string BakiyeRemove = ""; string bakiyemiktarı; int uzunluk = 0; foreach (var item in AlımFaturası) { bakiyemiktarı = item.genelToplam.ToString(); uzunluk = item.genelToplam.ToString().Length; bakiyemiktarı = bakiyemiktarı.Remove(uzunluk - 4, 4); toplam = toplam + Convert.ToDecimal(bakiyemiktarı); } ViewBag.AlimFaturası = toplam + " " + "TL"; toplam = 0; foreach (var item in SatisFaturasi) { bakiyemiktarı = item.genelToplam.ToString(); uzunluk = item.genelToplam.ToString().Length; bakiyemiktarı = bakiyemiktarı.Remove(uzunluk - 4, 4); toplam = toplam + Convert.ToDecimal(bakiyemiktarı); } ViewBag.SatisFaturasi = toplam + " " + "TL"; toplam = 0; var TahsilatToplam = db.CASH_PAY.Where(x => x.FirmaID == FirmaID & x.IslemTipi == "T").ToList(); foreach (var item in TahsilatToplam) { bakiyemiktarı = item.Tutar.ToString(); uzunluk = item.Tutar.ToString().Length; bakiyemiktarı = bakiyemiktarı.Remove(uzunluk - 4, 4); toplam = toplam + Convert.ToDecimal(bakiyemiktarı); } ViewBag.TahsilatToplam = toplam + " " + "TL"; toplam = 0; #endregion #region BankaVeKasalar int vKasaID = Convert.ToInt32(Session["vKasaID"].ToString()); int vBankaID = Convert.ToInt32(Session["vBankaID"].ToString()); Kasa kisikasa = db.Kasa.Where(x => x.ID == vKasaID).FirstOrDefault(); BALANCE_KASA blcks = db.BALANCE_KASA.Where(x => x.kasaID == kisikasa.ID && x.paraBirimi == kisikasa.ParaBirimi).FirstOrDefault(); Banka kisibanka = db.Banka.Where(x => x.ID == vBankaID).FirstOrDefault(); BALANCE_BANK blcbk = db.BALANCE_BANK.Where(x => x.bankaID == kisibanka.ID && x.paraBirimi == kisikasa.ParaBirimi).FirstOrDefault(); ViewBag.kisiBankaAdi = kisibanka.BankaAdi; string tutar = Convert.ToDecimal(blcbk.bakiye).ToString("N2"); ViewBag.kisiBankaTutar = tutar.Replace(".", "").Replace(",", "."); ViewBag.kisiKasaAdi = kisikasa.KasaAdi; tutar = Convert.ToDecimal(blcks.bakiye).ToString("N2"); ViewBag.kisiKasaTutar = tutar.Replace(".", "").Replace(",", "."); var BankaList = db.Banka.Where(x => x.FirmaID == FirmaID && x.Merkez == true).ToList(); foreach (var item in BankaList) { uzunluk = 0; BakiyeRemove = ""; bakiyemiktarı = ""; if (item.hnParaBirimi == "TL") { ViewBag.TlBankaName = item.BankaAdi; bakiyemiktarı = item.Bakiye.ToString(); uzunluk = item.Bakiye.ToString().Length; bakiyemiktarı = bakiyemiktarı.Remove(uzunluk - 4, 4); bakiyemiktarı = bakiyemiktarı.Replace(",", "."); ViewBag.TlBankaBakiye = bakiyemiktarı; } } var KasaList = db.Kasa.Where(x => x.FirmaID == FirmaID && x.Merkez == true).ToList(); foreach (var item in KasaList) { if (item.ParaBirimi == "TL") { ViewBag.TlKasaName = item.KasaAdi; bakiyemiktarı = item.Bakiye.ToString(); uzunluk = item.Bakiye.ToString().Length; bakiyemiktarı = bakiyemiktarı.Remove(uzunluk - 4, 4); bakiyemiktarı = bakiyemiktarı.Replace(",", "."); ViewBag.TlKasaBakiye = bakiyemiktarı; } //else if (item.ParaBirimi == "EUR") //{ // ViewBag.EurKasaName = item.KasaAdi; // bakiyemiktarı = item.Bakiye.ToString(); // uzunluk = item.Bakiye.ToString().Length; // bakiyemiktarı = bakiyemiktarı.Remove(uzunluk - 4, 4); // ViewBag.EurKasaBakiye = bakiyemiktarı + " " + "EUR"; //} //else if (item.ParaBirimi == "USD") //{ // ViewBag.UsdKasaName = item.KasaAdi; // bakiyemiktarı = item.Bakiye.ToString(); // uzunluk = item.Bakiye.ToString().Length; // bakiyemiktarı = bakiyemiktarı.Remove(uzunluk - 4, 4); // ViewBag.UsdKasaBakiye = bakiyemiktarı + " " + "USD"; //} } #endregion #region GelirGiderTablo List <KasaDurum> KasaDurumlist = new List <KasaDurum>(); List <BankaDurum> BankaDurumList = new List <BankaDurum>(); var ks = db.Kasa.Where(x => x.FirmaID == FirmaID && x.ParaBirimi == "TL").ToList(); foreach (var item in ks) { KasaDurum newkasa = new KasaDurum(); newkasa.KasaAdi = item.KasaAdi; newkasa.KasaBakiye = Convert.ToDecimal(item.Bakiye).ToString("N2").Replace(",", "."); KasaDurumlist.Add(newkasa); } var banka = db.Banka.Where(x => x.FirmaID == FirmaID && x.hnParaBirimi == "TL").ToList(); foreach (var item in banka) { BankaDurum bankayeni = new BankaDurum(); bankayeni.BankaAdi = item.BankaAdi; bankayeni.BankaBakiye = Convert.ToDecimal(item.Bakiye).ToString("N2").Replace(",", "."); BankaDurumList.Add(bankayeni); } gt.BankalarList = BankaDurumList; gt.KasalarList = KasaDurumlist; #endregion return(View(gt)); }
public ActionResult StokBilgi(int?id = -1, string Brk = "", string FiyatTipi = "1.Fiyat") { using (sayazilimEntities db = new sayazilimEntities()) { Stok emp = new Stok(); emp.ID = -1; bool kodbulundu = true; emp = db.Stok.Where(x => x.ID == id).FirstOrDefault <Stok>(); if (id == -1 && Brk != "") { emp = db.Stok.Where(x => x.Barkod == Brk).FirstOrDefault <Stok>(); if (emp == null) { emp = db.Stok.Where(x => x.Brkd2 == Brk).FirstOrDefault <Stok>(); try { emp.Barkod = emp.Brkd2; } catch { } if (emp == null) { emp = db.Stok.Where(x => x.Brkd3 == Brk).FirstOrDefault <Stok>(); try { emp.Barkod = emp.Brkd3; } catch { } if (emp == null) { emp = db.Stok.Where(x => x.Brkd4 == Brk).FirstOrDefault <Stok>(); try { emp.Barkod = emp.Brkd4; } catch { } if (emp == null) { emp = db.Stok.Where(x => x.Brkd5 == Brk).FirstOrDefault <Stok>(); try { emp.Barkod = emp.Brkd5; } catch { } } } } } if (emp != null) { kodbulundu = false; } else { using (SqlConnection conv = new SqlConnection(AyarMetot.strcon)) { conv.Open(); using (SqlCommand carigetir = new SqlCommand("SELECT top 1 UrunID From OTHER_BARCODES where YeniBarkod='" + Brk + "'", conv)) { using (SqlDataReader dr = carigetir.ExecuteReader()) { while (dr.Read()) { int ID = Convert.ToInt32(dr["UrunID"]); emp = db.Stok.Where(x => x.ID == ID).FirstOrDefault <Stok>(); if (emp != null) { kodbulundu = false; } } } } } } } else { } return(Json(new { success = true, data = emp, kodbulundu = kodbulundu }, 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()); } }