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