public static void HamBarkoduEkle(string barkod, int ambarUstId) { vHamKumaslar kumas = new DBEvents().GetGeneric <vHamKumaslar>(c => c.Barkod == barkod).FirstOrDefault(); if (kumas == null) { throw new Exception("Barkod hatalı.!"); } if (kumas.DepoId != 402) { throw new Exception("Bu barkod transfer edilmemiş!"); } tblAmbarAct ambarX = new DBEvents().GetGeneric <tblAmbarAct>().Where(c => c.AmbarUstId == ambarUstId && c.HamBarkodId == kumas.Id && c.DepoId == 402).FirstOrDefault(); if (ambarX == null) { throw new Exception("Bu barkod için transfer işlemi yapılmamış!"); } tblHamKumaslar tblKumas = kumas.ViewToTbl(); tblKumas.DepoId = 400; if (new DBEvents().UpdateGeneric <tblHamKumaslar>(tblKumas)) { tblAmbarAct ambarAct = new tblAmbarAct(); ambarAct.AmbarUstId = ambarUstId; ambarAct.DepoId = 400; ambarAct.HamBarkodId = tblKumas.Id; ambarAct.Tarih = DateTime.Now; bool snc = new DBEvents().SaveGeneric <tblAmbarAct>(ambarAct); } }
public static bool TransferEt(List <vHamKumaslarOrmeStok> secilenler, int ambarUstId) { bool snc = true; List <tblAmbarAct> transferKumaslar = new List <tblAmbarAct>(); foreach (vHamKumaslarOrmeStok item in secilenler) { tblHamKumaslar ham = new DBEvents().GetGeneric <tblHamKumaslar>(c => c.Id == item.Id).FirstOrDefault(); ham.DepoId = 402; bool snc3 = new DBEvents().UpdateGeneric <tblHamKumaslar>(ham); tblAmbarAct ambarAct = new tblAmbarAct(); ambarAct.AmbarUstId = ambarUstId; ambarAct.HamBarkodId = ham.Id; ambarAct.Tarih = DateTime.Now; ambarAct.DepoId = 402; transferKumaslar.Add(ambarAct); } if (new DBEvents().SaveGeneric <tblAmbarAct>(transferKumaslar) == false) { snc = false; throw new Exception("Transfer edilemedi!"); } return(snc); }