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