public string OrderNoGetir(tblFirmalar musteri, int siparisId = 0)
{
if (musteri == null)
{
return("");
}
string strSayi = "", orderNo = "";
if (siparisId == 0)
{
strSayi = db.GetGenericWithSQLQuery <string>("select top 1 cast(OrderSayi as varchar) Sonuc from tblSiparisler where FirmaId = " + musteri.Id.ToString() + " order by OrderSayi desc", new string[0]).FirstOrDefault();
if (musteri.Adi != "")
{
orderNo = musteri.Adi.Substring(0, 3) + "-" + (Convert.ToInt32(strSayi) + 1).ToString();
}
}
else
{
tblSiparisler tmp = db.GetGeneric <tblSiparisler>(c => c.FirmaId == musteri.Id && c.Id == siparisId).FirstOrDefault(); //db.GetGenericWithSQLQuery<string>("select OrderNo from tblSiparisler FirmaId = " + musteri.Id.ToString() + " where Id = " + siparisId.ToString(), new string[0]).FirstOrDefault();
if (tmp == null || tmp.OrderNo == null)
{
strSayi = db.GetGenericWithSQLQuery <string>("select top 1 cast(OrderSayi as varchar) Sonuc from tblSiparisler where FirmaId = " + musteri.Id.ToString() + " order by OrderSayi desc", new string[0]).FirstOrDefault();
orderNo = musteri.Adi.Substring(0, 3) + "-" + (Convert.ToInt32(strSayi) + 1).ToString();
}
else
{
orderNo = tmp.OrderNo;
}
}
return(orderNo);
}
public string SevkAdresiGetir(tblFirmalar firma)
{
if (firma == null)
{
return("");
}
string sevkAdresi = db.GetGenericWithSQLQuery <string>("select top 1 SevkYeri from tblSiparisler where FirmaId = " + firma.Id.ToString() + " order by Tarih desc", new string[0]).FirstOrDefault();
if (sevkAdresi == null)
{
sevkAdresi = firma.Adres == null ? "" : firma.Adres;
}
return(sevkAdresi);
}
public int FirmalariEntegreEt()
{
try
{
List <tblFirmalar> listToSave = new List <tblFirmalar>();
List <tblFirmalar> listToUpdate = new List <tblFirmalar>();
List <vLogoFirmalar> listLogo = LogoFirmalariGetir();
foreach (vLogoFirmalar logoFirma in listLogo)
{
tblFirmalar firma = new tblFirmalar()
{
Id = logoFirma.Id,
Adi = logoFirma.Adi,
AktifMi = logoFirma.AktifMi == 0 ? true : false,
BaglantiId = logoFirma.Tip.Value,
Kodu = logoFirma.Kod,
EntId = logoFirma.LogoId
};
if (logoFirma.Id == 0)
{
listToSave.Add(firma);
}
else
{
listToUpdate.Add(firma);
}
}
bool sonuc = true;
if (listToSave.Count > 0)
{
if (db.SaveGeneric <tblFirmalar>(listToSave) == false)
{
sonuc = false;
}
}
if (listToUpdate.Count > 0 && sonuc)
{
if (db.UpdateGeneric <tblFirmalar>(listToUpdate) == false)
{
sonuc = false;
}
}
if (sonuc)
{
return(listToSave.Count + listToUpdate.Count);
}
else
{
return(-1);
}
}
catch (Exception e)
{
DBEvents.LogException(e, "FirmalariEntegreEt", 0);
return(-1);
}
}
