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 void SiparisKarZararKaydet(int siparisId, string karZarar, int yuzde)
{
tblSiparisler sprs = db.GetGeneric <tblSiparisler>(c => c.Id == siparisId).FirstOrDefault();
sprs.KarZarar = karZarar;
sprs.Yuzde = yuzde;
db.UpdateGeneric <tblSiparisler>(sprs);
}
public bool SiparisSil(vSiparisler silinecek)
{
List <tblSiparisAct> siparisList = db.GetGeneric <tblSiparisAct>(c => c.SiparisId == silinecek.Id);
if (db.DeleteGeneric <tblSiparisAct>(siparisList))
{
tblSiparisler tbl = db.GetGeneric <tblSiparisler>(c => c.Id == silinecek.Id).FirstOrDefault();
return(db.DeleteGeneric <tblSiparisler>(tbl));
}
return(false);
}
public bool SiparisKaydet(ref vSiparisler siparis, int kullaniciId)
{
tblSiparisler tblSip = vSiparisler.ViewToTable(siparis);
tblSip.GuncelleyenPersId = kullaniciId;
try
{
tblSip.OrderSayi = Convert.ToInt32(tblSip.OrderNo.Substring(tblSip.OrderNo.IndexOf('-') + 1));
}
catch { }
if (tblSip.KapanmaTarihi.HasValue == false && tblSip.Durum == "Tamamlandı")
{
tblSip.KapanmaTarihi = DateTime.Now;
siparis.KapanmaTarihi = DateTime.Now;
}
else if (tblSip.Durum != "Tamamlandı")
{
tblSip.KapanmaTarihi = null;
siparis.KapanmaTarihi = null;
}
if (siparis.Id == 0)
{
int bagId = siparis.BaglantiId;
tblSiparisler sipTip = db.GetGeneric <tblSiparisler>(c => c.Id == bagId).FirstOrDefault();
tblBelgeNo belgeNo = tblBelgeNo.BelgeNoGetir(sipTip == null ? "" : sipTip.BelgeTuru);
string strNumara = (belgeNo.SonBelgeNo + 1).ToString("00000");
string belgeNoStr = belgeNo.Tipi + " " + DateTime.Now.ToString("yy") + "/" + strNumara;
siparis.SozlesmeNo = belgeNoStr;
tblSip.SozlesmeNo = belgeNoStr;
belgeNo.SonBelgeNo = belgeNo.SonBelgeNo + 1;
belgeNo.Yil = DateTime.Now.Year;
tblBelgeNo.BelgeNoKaydet(belgeNo);
bool snc = db.SaveGeneric <tblSiparisler>(ref tblSip);
siparis.Id = tblSip.Id;
return(snc);
}
else
{
return(db.UpdateGeneric <tblSiparisler>(tblSip));
}
}
public bool SiparisTerminVer(vPlanSiparisleri siparis, DateTime?yeniTermin)
{
tblSiparisAct siparisAct = db.GetGeneric <tblSiparisAct>(c => c.Id == siparis.SiparisActId).FirstOrDefault();
siparisAct.TerminTarihi = yeniTermin;
tblSiparisler siparisUst = db.GetGeneric <tblSiparisler>(c => c.Id == siparisAct.SiparisId).FirstOrDefault();
if (siparisUst.TerminTarihi == null || siparisUst.TerminTarihi < yeniTermin)
{
siparisUst.TerminTarihi = yeniTermin;
if (db.UpdateGeneric <tblSiparisler>(siparisUst) == false)
{
return(false);
}
}
return(db.UpdateGeneric <tblSiparisAct>(siparisAct));
}
public bool SevkiyatEmriOlustur(vSiparisler siparis, int olusturanId)
{
tblSevk sevkBelge = new tblSevk()
{
FarkliSiparisOkut = false,
LogoAktarildiMi = false,
MusteriId = siparis.FirmaId,
SevkEdenId = olusturanId,
SiparisId = siparis.Id,
Tarih = DateTime.Today,
TipRenkKontrolDevreDisi = false
};
if (db.SaveGeneric <tblSevk>(sevkBelge))
{
tblSiparisler sipTbl = vSiparisler.ViewToTable(siparis);
sipTbl.SevkEdilebilirMi = true;
return(db.UpdateGeneric <tblSiparisler>(sipTbl));
}
return(false);
}
