public static void UpdateDisbursementItem(Disbursement_Item disItem)
{
using (StationeryEntities context = new StationeryEntities())
{
context.Entry(disItem).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
public static void UpdateRequisitionList(List <Requisition> requisitions)
{
using (StationeryEntities context = new StationeryEntities())
{
requisitions.ForEach(requisition => context.Entry(requisition).State = System.Data.Entity.EntityState.Modified);
context.SaveChanges();
}
return;
}
public static void UpdateRequisition(Requisition requisition)
{
using (StationeryEntities context = new StationeryEntities())
{
context.Entry(requisition).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
return;
}
public static void UpdateItem(Item i)
{
using (StationeryEntities inventoryDB = new StationeryEntities())
{
inventoryDB.Entry(i).State = System.Data.Entity.EntityState.Modified;
inventoryDB.SaveChanges();
}
return;
}
public static void UpdateSupplier(Supplier supplier)
{
using (TransactionScope ts = new TransactionScope())
{
StationeryEntities dbInstance = new StationeryEntities();
dbInstance.Entry(supplier).State = System.Data.Entity.EntityState.Modified;
dbInstance.SaveChanges();
ts.Complete();
}
}
public static void DeleteSupplier(string supplierCode)
{
using (TransactionScope ts = new TransactionScope())
{
StationeryEntities dbInstance = new StationeryEntities();
Supplier s = dbInstance.Suppliers.Where(x => x.SupplierCode == supplierCode).First();
s.ActiveStatus = "N";
dbInstance.Entry(s).State = System.Data.Entity.EntityState.Modified;
dbInstance.SaveChanges();
ts.Complete();
}
}
public static void UpdateRequisitionItem(int id, string code, int qty)
{
using (TransactionScope ts = new TransactionScope())
{
StationeryEntities context = new StationeryEntities();
Requisition_Item ri = context.Requisition_Item.Where(r => r.RequisitionID == id && r.ItemCode.Equals(code)).FirstOrDefault();
ri.RequestedQty = qty;
context.Entry(ri).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
ts.Complete();
}
}
public static void UpdatePriceListObject(string newPrice, string firstCPK, string secondCPK, string thirdCPK)
{
using (TransactionScope ts = new TransactionScope())
{
StationeryEntities S = new StationeryEntities();
decimal price = Decimal.Parse(newPrice);
PriceList pl = S.PriceLists.Where(x => x.SupplierCode == firstCPK).Where(y => y.ItemCode == secondCPK).Where(z => z.TenderYear == thirdCPK).First();
pl.Price = price;
S.Entry(pl).State = System.Data.Entity.EntityState.Modified;
S.SaveChanges();
ts.Complete();
}
}
public static void ApproveRequisition(int id, string reason, int?empID)
{
using (StationeryEntities context = new StationeryEntities())
{
Requisition r = context.Requisitions.Where(x => x.RequisitionID == id).First();
r.Remarks = reason;
r.RequisitionID = id;
r.Status = "Approved";
r.ApprovedBy = empID;
context.Entry(r).State = System.Data.Entity.EntityState.Modified;
context.SaveChanges();
}
}
