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