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