public static void UpdateItemSupplier(string ItemID, int p1, int p2, int p3)
{
using (StationeryStoreEntities context = new StationeryStoreEntities())
{
CatalogueInventory s = context.CatalogueInventory.
Where(p => p.ItemID == ItemID).ToList <CatalogueInventory>().First();
s.Priority1 = p1;
s.Priority2 = p2;
s.Priority3 = p3;
context.SaveChanges();
}
}
//Confirm delivery
public void ConfirmDeliveryToDep(int EmployeeID, int DepartmentID)
{
using (StationeryStoreEntities context = new StationeryStoreEntities())
{
//select today's delivery and set "Delivered"
//select today's delivery and set "Delivered"
DateTime today = DateTime.Now.Date;
List <Delivery> deliveryList = context.Deliveries.Where(x => x.DepartmentID == DepartmentID && x.DeliveryDate <= today).ToList <Delivery>();
foreach (Delivery d in deliveryList)
{
d.Status = "Delivered";
List <Disbursement> clist = context.Disbursements.Where(x => x.DeliveryID == d.DeliveryID).ToList <Disbursement>();
foreach (Disbursement dis in clist)
{
//update catalogueInventory
CatalogueInventory c = context.CatalogueInventories.Where(x => x.ItemID == dis.ItemID).FirstOrDefault <CatalogueInventory>();
c.ActualQty = c.ActualQty - dis.DisbursedQty;
//update stockCard
StockCard sc = new StockCard();
sc.ItemID = dis.ItemID;
sc.SCCatID = 18002;
sc.Description = dis.Department.Description;
sc.AdjustedQty = -dis.DisbursedQty;
sc.TransactionDate = DateTime.Now.Date;
context.StockCards.Add(sc);
}
}
List <Request> requests = context.Requests.Where(x => x.Employee.DepartmentID == DepartmentID && x.Status == "Scheduled").ToList <Request>();
foreach (Request r in requests)
{
r.Status = "Delivered";
}
List <Outstanding> outsList = context.Outstandings.Where(x => x.DepartmentID == DepartmentID).ToList <Outstanding>();
foreach (Outstanding o in outsList)
{
if (o.Status == "Processed")
{
context.Outstandings.Remove(o);
}
else if (o.Status == null)
{
o.Status = "Pending";
}
}
context.SaveChanges();
}
}
public static List <String> ValueCatalogue(string id)
{
using (StationeryStoreEntities context = new StationeryStoreEntities())
{
CatalogueInventory item = context.CatalogueInventory.Where(x => x.ItemID == id).First();
string itemId = item.ItemID;
string desc = item.Item_Description;
string cat = item.Category.Category_Description;
string uom = item.UnitOfMeasure;
List <String> list = new List <String>();
list.Add(desc);
list.Add(cat);
list.Add(uom);
list.Add(itemId);
return(list);
}
}
//ListSup(): return a supplier list List<Supplier>
public static List <Supplier> ListSup(string ItemID)
{
CatalogueInventory c = context.CatalogueInventory.Where(x => x.ItemID == ItemID).FirstOrDefault <CatalogueInventory>();
if (c != null)
{
List <Supplier> slist = new List <Supplier>();
slist.Add(c.Supplier);
slist.Add(c.Supplier1);
slist.Add(c.Supplier2);
return(slist);
}
else
{
return(null);
}
//return context.Supplier.ToList<Supplier>();
}
public static void AddItem(string ItemID, int CatID, string Item_Description,
string UnitOfMeasure, double UnitCost, int Priority1, int Priority2, int Priority3)
{
using (StationeryStoreEntities context = new StationeryStoreEntities())
{
CatalogueInventory i = new CatalogueInventory()
{
ItemID = ItemID,
CatID = CatID,
Item_Description = Item_Description,
UnitOfMeasure = UnitOfMeasure,
UnitCost = Convert.ToDecimal(UnitCost),
Priority1 = Priority1,
Priority2 = Priority2,
Priority3 = Priority3,
ActualQty = 0
};
context.CatalogueInventory.Add(i);
context.SaveChanges();
}
}
//Confirm Delivery
public static void ConfirmDeliveryFromSupplier(int EmployeeID, int POID)
{
//update PO
PO p = context.PO.Where(f => f.POID == POID).ToList().First();
p.DeliveryDate = DateTime.Now.Date;
p.Status = "Delivered";
//update Inventory
CatalogueInventory c = context.CatalogueInventory.Where(x => x.ItemID == p.ItemID).ToList <CatalogueInventory>().FirstOrDefault();
c.ActualQty += p.Qty;
//update Stockcard
StockCard sc = new StockCard();
sc.ItemID = p.ItemID;
sc.SCCatID = 18003;
sc.Description = p.Supplier.Name;
sc.AdjustedQty = p.Qty;
sc.TransactionDate = DateTime.Now.Date;
context.StockCard.Add(sc);
context.SaveChanges();
}
