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());
}
}
