public static void AddNewRequisition(List <RequestedItem> item, DateTime date, string status, int empID, string DeptCode) { using (TransactionScope ts = new TransactionScope()) { StationeryEntities context = new StationeryEntities(); Requisition r = new Requisition(); List <Requisition_Item> list = new List <Requisition_Item>(); //to pass from previous form r.RequestDate = date; r.Status = status; r.RequestedBy = empID; r.DeptCode = DeptCode; context.Requisitions.Add(r); context.SaveChanges(); foreach (RequestedItem i in item) { int qty = i.Quantity; string code = i.Code; Requisition_Item ri = new Requisition_Item(); ri.RequisitionID = r.RequisitionID; ri.ItemCode = code; ri.RequestedQty = qty; list.Add(ri); } context.Requisition_Item.AddRange(list); context.SaveChanges(); ts.Complete(); } }
public static void UpdateActingDHead(string depcode, int empid, string sdate, string edate) { using (StationeryEntities smodel = new StationeryEntities()) { try { if (EFBroker_DeptEmployee.GetEmployeeListForActingDHeadSelectedCount(depcode) <= 0) { Employee emp = smodel.Employees.Where(p => p.DeptCode == depcode && p.EmpID == empid).First <Employee>(); emp.IsTempHead = "Y"; emp.StartDate = Convert.ToDateTime(sdate); emp.EndDate = Convert.ToDateTime(edate); smodel.SaveChanges(); } else { Employee orgemp = smodel.Employees.Where(q => q.DeptCode == depcode && q.IsTempHead == "Y").First <Employee>(); orgemp.IsTempHead = "N"; orgemp.StartDate = null; orgemp.EndDate = null; Employee emp = smodel.Employees.Where(p => p.DeptCode == depcode && p.EmpID == empid).First <Employee>(); emp.IsTempHead = "Y"; emp.StartDate = Convert.ToDateTime(sdate); emp.EndDate = Convert.ToDateTime(edate); smodel.SaveChanges(); } } catch (Exception e) { } } }
public static void AddPurchaseOrder(Dictionary <PurchaseOrder, List <Item_PurchaseOrder> > orderItems) { using (TransactionScope ts = new TransactionScope()) { StationeryEntities entities = new StationeryEntities(); decimal? totAmount = 0; foreach (var order in orderItems) { entities.PurchaseOrders.Add(order.Key); entities.SaveChanges(); foreach (var items in order.Value) { totAmount += items.Amount; items.PurchaseOrderID = order.Key.PurchaseOrderID; entities.Item_PurchaseOrder.Add(items); } PurchaseOrder porder = entities.PurchaseOrders.Where(x => x.PurchaseOrderID == order.Key.PurchaseOrderID).FirstOrDefault(); porder.TotalAmount = totAmount; totAmount = 0; entities.SaveChanges(); } ts.Complete(); } }
public static void ClosePurchaseOrder(PurchaseOrder pOrder) { using (TransactionScope ts = new TransactionScope()) { StationeryEntities entities = new StationeryEntities(); PurchaseOrder order = entities.PurchaseOrders.Where(x => x.PurchaseOrderID == pOrder.PurchaseOrderID).First(); order.DONumber = pOrder.DONumber; order.Status = pOrder.Status; order.ExpectedDate = DateTime.Now.Date; List <Item_PurchaseOrder> itemList = entities.Item_PurchaseOrder.Where(x => x.PurchaseOrderID == order.PurchaseOrderID).ToList(); foreach (Item_PurchaseOrder item in itemList) { //StockCard itemStockCard = (from stck in entities.StockCards.OrderBy(x => x.Balance) // where stck.ItemCode == item.ItemCode // select stck).FirstOrDefault(); StockCard itemStockCard = new StockCard(); itemStockCard.ItemCode = item.ItemCode; itemStockCard.Qty = item.OrderQty; itemStockCard.TransactionType = "Purchase"; itemStockCard.TransactionDetailID = item.PurchaseOrderID; Item itm = entities.Items.Where(x => x.ItemCode == item.ItemCode).FirstOrDefault(); itemStockCard.Balance = itm.BalanceQty + itemStockCard.Qty; itm.BalanceQty = itemStockCard.Balance; entities.StockCards.Add(itemStockCard); } entities.SaveChanges(); ts.Complete(); } return; }
//AUTHOR : KHIN MO MO ZIN public static void AddStockTransaction(StockCard stockCard) { using (StationeryEntities context = new StationeryEntities()) { context.StockCards.Add(stockCard); context.SaveChanges(); } }
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 UpdateCollectionPoint(string depcode, int?collectpoint) { using (StationeryEntities smodel = new StationeryEntities()) { Department dept = smodel.Departments.Where(p => p.DeptCode == depcode).First <Department>(); dept.CollectionLocationID = collectpoint; smodel.SaveChanges(); } }
public static void AddItemToRequisition(Requisition_Item item) { using (StationeryEntities context = new StationeryEntities()) { context.Requisition_Item.Add(item); context.SaveChanges(); } return; }
public static void AddItem(Item item) { using (StationeryEntities inventoryDB = new StationeryEntities()) { inventoryDB.Items.Add(item); inventoryDB.SaveChanges(); } return; }
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 UpdateItem(Item i) { using (StationeryEntities inventoryDB = new StationeryEntities()) { inventoryDB.Entry(i).State = System.Data.Entity.EntityState.Modified; inventoryDB.SaveChanges(); } return; }
public static void AddCategory(Category category) { using (StationeryEntities categoryDB = new StationeryEntities()) { categoryDB.Categories.Add(category); categoryDB.SaveChanges(); } return; }
public static void UpdateRetrievalStatus(int requisitionId, string status) { using (StationeryEntities context = new StationeryEntities()) { Retrieval retrieval = context.Retrievals.Where(x => x.RetrievalID == requisitionId).FirstOrDefault(); retrieval.RetrievalStatus = status; context.SaveChanges(); } }
public static void AddNewDisbursementItemList(List <Disbursement_Item> disitems) { using (StationeryEntities context = new StationeryEntities()) { context.Disbursement_Item.AddRange(disitems); context.SaveChanges(); } return; }
public static void AddNewDisbursementItem(Disbursement_Item disitem) { using (StationeryEntities context = new StationeryEntities()) { context.Disbursement_Item.Add(disitem); 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 ProcessDiscrepancy(int id, string action) { using (StationeryEntities context = new StationeryEntities()) { Discrepency d = context.Discrepencies.Where(x => x.DiscrepencyID == id).First(); d.Status = action; context.SaveChanges(); } }
public static void AddPriceListItem(PriceList obj) { using (TransactionScope ts = new TransactionScope()) { StationeryEntities dbInstance = new StationeryEntities(); dbInstance.PriceLists.Add(obj); dbInstance.SaveChanges(); ts.Complete(); } }
public static void RemoveItem(string itemCode) { using (StationeryEntities inventoryDB = new StationeryEntities()) { Item i = inventoryDB.Items.Where(x => x.ItemCode == itemCode).FirstOrDefault(); i.ActiveStatus = "N"; inventoryDB.SaveChanges(); } return; }
public static int AddNewDisbursment(Disbursement disbursment) { using (StationeryEntities context = new StationeryEntities()) { context.Disbursements.Add(disbursment); context.SaveChanges(); //saving changes get ID for disbursement return(disbursment.DisbursementID); } }
public static void UpdateRevoke() { StationeryEntities context = new StationeryEntities(); Employee emp = context.Employees.Where(em => em.IsTempHead.Equals("Y")).FirstOrDefault(); emp.IsTempHead = "N"; emp.StartDate = null; emp.EndDate = null; context.SaveChanges(); }
public static void CreateSupplier(Supplier supplier) { using (TransactionScope ts = new TransactionScope()) { StationeryEntities dbInstance = new StationeryEntities(); dbInstance.Suppliers.Add(supplier); dbInstance.SaveChanges(); ts.Complete(); } }
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 RemovePriceListObject(string firstCPK, string secondCPK, string thirdCPK) { using (TransactionScope ts = new TransactionScope()) { StationeryEntities dbInstance = new StationeryEntities(); PriceList pl = dbInstance.PriceLists.Where(x => x.SupplierCode == firstCPK).Where(y => y.ItemCode == secondCPK).Where(z => z.TenderYear == thirdCPK).First(); dbInstance.PriceLists.Remove(pl); dbInstance.SaveChanges(); ts.Complete(); } }
public static void EditRequisitionItemQty(int id, string code, int qty) { using (TransactionScope ts = new TransactionScope()) { StationeryEntities context = new StationeryEntities(); Requisition_Item ri = context.Requisition_Item.Where(i => i.RequisitionID == id).Where(i => i.ItemCode.Equals(code)).FirstOrDefault(); ri.RequestedQty += qty; context.SaveChanges(); ts.Complete(); } }
public static void removeRequisitionItem(int id, string code) { using (TransactionScope ts = new TransactionScope()) { StationeryEntities context = new StationeryEntities(); Requisition_Item ri = context.Requisition_Item.Where(r => r.RequisitionID.Equals(id)).Where(r => r.ItemCode.Equals(code)).FirstOrDefault(); context.Requisition_Item.Remove(ri); context.SaveChanges(); ts.Complete(); } }
public static void CancelRejectRequisition(int id) { using (StationeryEntities context = new StationeryEntities()) { Requisition r = context.Requisitions.Where(x => x.RequisitionID == id).FirstOrDefault(); r.Status = "Rejected"; r.Remarks = "Request cancelled"; context.SaveChanges(); } return; }
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 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 UpdatePurchaseOrder(PurchaseOrder pOrder) { using (StationeryEntities entities = new StationeryEntities()) { PurchaseOrder order = entities.PurchaseOrders.Where(x => x.PurchaseOrderID == pOrder.PurchaseOrderID).FirstOrDefault(); order.ApprovedByDate = pOrder.ApprovedByDate; order.Remarks = pOrder.Remarks; order.Status = pOrder.Status; order.ApprovedBy = pOrder.ApprovedBy; entities.SaveChanges(); } }