internal static DepOrder GetOrderByDepAndItem(int dId, int itemId) { DepOrder depo = new DepOrder(); using (var db = new ADDbContext()) { if (db.DepOrder.Where(x => x.dep.Id == dId && x.item.Id == itemId).Any()) { depo = db.DepOrder.Include("dep").Include("item").Where(x => x.dep.Id == dId && x.item.Id == itemId).FirstOrDefault(); } } return(depo); }
internal static void SetReceived(int dId, int itemId, int v) { DepOrder deporder = new DepOrder(); using (var db = new ADDbContext()) { if (db.DepOrder.Where(x => x.dep.Id == dId && x.item.Id == itemId && x.status.Equals("collected")).Any()) { deporder = db.DepOrder.Where(x => x.dep.Id == dId && x.item.Id == itemId && x.status.Equals("collected")).FirstOrDefault(); } deporder.deliveredquant = v; deporder.status = "delivered"; deporder.signindate = DateTime.Today; db.SaveChanges(); } }
internal static void SetCollected(int depId, int itemId, int v) { DepOrder deporder = new DepOrder(); using (var db = new ADDbContext()) { if (db.DepOrder.Where(x => x.item.Id == itemId && x.dep.Id == depId && x.status.Equals("acknowledged")).Any()) { deporder = db.DepOrder.Where(x => x.item.Id == itemId && x.dep.Id == depId && x.status.Equals("acknowledged")).FirstOrDefault(); } deporder.collectedquant = v; deporder.status = "collected"; db.SaveChanges(); } }
public static void CreateDepOrder(int depId, int itemId, int quant, double price) { DepOrder dorder = new DepOrder(); using (var db = new ADDbContext()) { Department d = db.Department.Where(x => x.Id == depId).FirstOrDefault(); Item i = db.Item.Where(x => x.Id == itemId).FirstOrDefault();; dorder.dep = d; dorder.item = i; dorder.quant = quant; dorder.uprice = price; db.DepOrder.Add(dorder); db.SaveChanges(); } }