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