public frmAnaForm()
{
InitializeComponent();
_eczaciGiris = new EczacıGiris();
_girisKontrol = new GirisKontrol();
_doktorGiris = new DoktorGiris();
}
public frmDoktorEkrani()
{
InitializeComponent();
_doktor = new DoktorEntity();
_hasta = new GirisKontrol();
_randevuDAL = new RandevuDAL();
_doktorDAL = new DoktorDAL();
}
public frmMevcutRandevular(int hastaID)
{
InitializeComponent();
_randevuDAL = new RandevuDAL();
_hasta = new GirisKontrol();
randevu = new RandevuEntity();
this.hastaID = hastaID;
}
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 Remember(string Mail)
{
string KA = "";
string SF = "";
string con = ConfigurationManager.ConnectionStrings["dbconnection"].ConnectionString;
using (SqlConnection connection = new SqlConnection(con))
{
connection.Open();
using (SqlCommand sqlCommand = new SqlCommand("Select * From CARi where ePOSTA='" + Mail + "' ", connection))
{
using (SqlDataReader dr = sqlCommand.ExecuteReader())
{
while (dr.Read())
{
KA = dr["WEBKA"].ToString();
SF = GirisKontrol.unhash(dr["WEBSifre"].ToString().Trim(), true);
}
}
}
}
SendEmail(Mail, KA, SF);
ViewBag.Mesaj = "Hatırlatma mailiniz başarıyla gönderilmiştir";
Session["PersonelID"] = null;
Session["UserName"] = null;
Session["User"] = null;
Session["PersonelType"] = null;
Session["RaporGor"] = null;
Session["FirmaKodu"] = null;
Session["PersonelAdi"] = null;
Session["Grubu"] = null;
return(View());
}
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 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 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());
}
}
