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