public static ConsolidatedRequisitionList getOpenListForDept(string deptCode) { UniversityStoreEntities context = new UniversityStoreEntities(); var query = from x in context.ConsolidatedRequisitionLists where x.DepartmentCode == deptCode && x.Status == STATUS_OPEN select x; List <ConsolidatedRequisitionList> list = query.ToList <ConsolidatedRequisitionList>(); ConsolidatedRequisitionList cl = query.First <ConsolidatedRequisitionList>(); return(cl); }
public static void deleteAdjustmentVoucher(int voucher) { UniversityStoreEntities CONTEXT = new UniversityStoreEntities(); var b = from x in CONTEXT.AdjustmentVouchers where x.VoucherNumber == voucher select x; AdjustmentVoucher q = b.First <AdjustmentVoucher>(); CONTEXT.DeleteObject(q); CONTEXT.SaveChanges(); }
public static List <RequisitionDetail> getDetialsOfListW(string reqListNumber) //// for web { UniversityStoreEntities context = new UniversityStoreEntities(); System.Int32 rNum = Convert.ToInt32(reqListNumber); var query = from x in context.RequisitionDetails from y in context.Products where x.RequisitionListNumber == rNum && y.ItemNumber == x.ItemNmber select x; return(query.ToList <RequisitionDetail>()); }
public static void addRequestedQtyForItem(int consolidatedListId, string itemCode, int qty) { UniversityStoreEntities context = new UniversityStoreEntities(); var query = from x in context.ConsolidatedRequisitionListDetails where x.ConsolidatedListID == consolidatedListId && x.ItemNumber == itemCode select x; ConsolidatedRequisitionListDetail detailItem = query.First(); int k = Convert.ToInt32(detailItem.QuantityRequested); detailItem.QuantityRequested = qty + k; context.SaveChanges(); }
public static void changeToAcknowledge(int pn) { UniversityStoreEntities context = new UniversityStoreEntities(); var q = from x in context.PurchaseOrderDetails where x.PONumber == pn && x.PurchaseOrder.Status == STATUS_PENDING select x; PurchaseOrderDetail a = q.First <PurchaseOrderDetail>(); a.PurchaseOrder.Status = STATUS_ACKNOWLEGED; context.SaveChanges(); }
public static List <Object> selectAllByGroupByCategory() { UniversityStoreEntities us = new UniversityStoreEntities(); var q = from x in us.Products group x by x.Category into g select new { Category = g.Key }; return(q.ToList <Object>()); }
//public static DateTime getDate(int VoucherNo) //{ // var q2 = from x in CONTEXT.AdjustmentVouchers // where x.VoucherNumber == VoucherNo // select x; // DateTime av =(DateTime) q2.First<AdjustmentVoucher>().DateCreated; // return av; public static void deleteAdjustmentVoucherDetail(int voucherNo) { UniversityStoreEntities CONTEXT = new UniversityStoreEntities(); var a = from x in CONTEXT.AdjustmentVoucherDetails where x.VoucherNumber == voucherNo select x; AdjustmentVoucherDetail d = a.First <AdjustmentVoucherDetail>(); CONTEXT.DeleteObject(d); CONTEXT.SaveChanges(); }
public static List <Product> getProductFromListOfID(String[] id) { UniversityStoreEntities us = new UniversityStoreEntities(); List <Product> pa = new List <Product>(); foreach (String g in id) { Product c = us.Products.First <Product>(x => x.ItemNumber == g); pa.Add(c); } return(pa); }
public static List <Object> getAllDepInvolved() { UniversityStoreEntities context = new UniversityStoreEntities(); var q = from x in context.RequisitionLists where x.Status == STATUS_APPROVED group x by x.DepartmentCode into g select new { depCode = g.Key }; return(q.ToList <Object>()); }
public static void changeReqListStatusClosed(string rlistNumber) { UniversityStoreEntities context = new UniversityStoreEntities(); System.Int32 rln = Convert.ToInt32(rlistNumber); var query = from x in context.RequisitionLists where x.RequisitionListNumber == rln select x; RequisitionList rl = query.First <RequisitionList>(); rl.Status = STATUS_CLOSED; context.SaveChanges(); }
public static Department getListForConsolidatedItem(ConsolidatedRequisitionListDetail item) { UniversityStoreEntities context = new UniversityStoreEntities(); var query = from x in context.ConsolidatedRequisitionLists from y in context.ConsolidatedRequisitionListDetails where x.ConsolidatedListID == y.ConsolidatedListID select x; ConsolidatedRequisitionList list = query.First(); Department dept = list.Department; return(dept); }
/////*********Wu************///// public static List <Object> getPendingAdjustmentVoucher() { UniversityStoreEntities CONTEXT = new UniversityStoreEntities(); var query = from x in CONTEXT.AdjustmentVoucherDetails where x.Status == APPROVAL_STATUS_PENDING select new { x.VoucherNumber, x.AdjustmentVoucher.DateCreated }; return(query.ToList <Object>()); }
public static void addToCart(string itemNumber, int qty, string empNumber) { UniversityStoreEntities context = new UniversityStoreEntities(); RequestStationaryCart c = new RequestStationaryCart(); c.EmployeeNumber = empNumber; c.ItemCode = itemNumber; c.Quantity = Convert.ToInt32(qty); context.AddToRequestStationaryCarts(c); context.SaveChanges(); }
public static void RemoveDelegate(String empno) { UniversityStoreEntities EN = new UniversityStoreEntities(); var q1 = from x in EN.Employees where x.EmployeeNumber == empno select x; Employee e = q1.First <Employee>(); e.Role = ROLE_EMPLOYEE; EN.SaveChanges(); }
public static Employee getDepartmentRepDetails(string deptCode) { UniversityStoreEntities context = new UniversityStoreEntities(); var query = from x in context.Departments where x.DepartmentCode == deptCode select x; Department dept = query.First(); //need to double check employee1 refers to deptrep again Employee deptRep = dept.Employee1; return(deptRep); }
public static List <PurchaseOrderDetail> AcceptSupply(int PONumber) { UniversityStoreEntities context = new UniversityStoreEntities(); List <PurchaseOrderDetail> purchaseorderdetail = new List <PurchaseOrderDetail>(); var z = from x in context.PurchaseOrderDetails where x.PONumber == PONumber select x; List <PurchaseOrderDetail> pli = new List <PurchaseOrderDetail>(); pli = z.ToList <PurchaseOrderDetail>(); return(pli); }
/** end by wu * */ public static int generatePO(string sCode) { UniversityStoreEntities context = new UniversityStoreEntities(); PurchaseOrder po = new PurchaseOrder(); po.SupplierCode = sCode; po.Status = "Pending"; po.DateCreated = DateTime.Now; context.AddToPurchaseOrders(po); context.SaveChanges(); return(po.PONumber); }
public static void createDelegate(String empno) { UniversityStoreEntities EN = new UniversityStoreEntities(); var q = from x in EN.Employees where x.EmployeeNumber == empno select x; Employee e = q.First <Employee>(); e.Role = ROLE_DELEGATE_HEAD; EN.SaveChanges(); }
/********** * added New method by Nitin * *********/ public static void finisheCollection() { UniversityStoreEntities context = new UniversityStoreEntities(); var q = from x in context.ConsolidatedRequisitionLists where x.Status == STATUS_OPEN select x; List <ConsolidatedRequisitionList> conlist = q.ToList <ConsolidatedRequisitionList>(); foreach (ConsolidatedRequisitionList c in conlist) { c.Status = STATUS_WAITING; context.SaveChanges(); } }
public static List <Object> populateAllProduct() { UniversityStoreEntities us = new UniversityStoreEntities(); var data = from x in us.Products select new { x.ItemNumber, x.Description, x.UnitOfMeasure, x.Category }; return(data.ToList <Object>()); }
public static void addDetailToList(int listID, string itemCode, int qtyReq, DateTime dateCreated, int actualQty) { UniversityStoreEntities context = new UniversityStoreEntities(); ConsolidatedRequisitionListDetail c2 = new ConsolidatedRequisitionListDetail(); c2.ConsolidatedListID = listID; c2.ItemNumber = itemCode; c2.QuantityRequested = qtyReq; c2.DateRequest = dateCreated; c2.ActualQuantity = 0; context.AddToConsolidatedRequisitionListDetails(c2); context.SaveChanges(); }
//added a function -ashwin public static void approvestatusadjustmentvoucher(int voucherno) { UniversityStoreEntities CONTEXT = new UniversityStoreEntities(); var q = from x in CONTEXT.AdjustmentVoucherDetails where x.ApprovalStatus == APPROVAL_STATUS_PENDING && x.VoucherNumber == voucherno select x; List <AdjustmentVoucherDetail> list = q.ToList <AdjustmentVoucherDetail>(); foreach (AdjustmentVoucherDetail ad in list) { ad.ApprovalStatus = APPROVAL_STATUS_APPROVED; CONTEXT.SaveChanges(); } }
public static List <Object> getAdjustmentVoucherDetail(int vocherNo) { UniversityStoreEntities CONTEXT = new UniversityStoreEntities(); var q = from x in CONTEXT.AdjustmentVoucherDetails where x.VoucherNumber == vocherNo select new { x.ItemNumber, x.Quantity, x.Comment }; return(q.ToList <Object>()); }
public static List <Object> getAllEmployeesOfThisHead(String depH) { UniversityStoreEntities context = new UniversityStoreEntities(); var query = from x in context.Employees where x.EmployeeNumber == depH select x; string e = query.First <Employee>().DepartmentCode; var query2 = from x in context.Employees where x.DepartmentCode == e select new { x.EmployeeNumber, x.Name }; return(query2.ToList <Object>()); }
public static List <Object> getAllOrder(int pn) { //if (pn != null) // { UniversityStoreEntities context = new UniversityStoreEntities(); var q = from x in context.PurchaseOrderDetails where x.PurchaseOrder.PONumber == pn select new { x.ItemNumber, x.Description, x.Price, x.Quantity }; return(q.ToList <Object>()); //} }
public static void CreatePurchaseOrder(PurchaseOrder purchaseorder, List <PurchaseOrderDetail> purchaselist) { UniversityStoreEntities context = new UniversityStoreEntities(); EntityCollection <PurchaseOrderDetail> purchaseorderdetailcoll = new EntityCollection <PurchaseOrderDetail>(); foreach (PurchaseOrderDetail p in purchaselist) { purchaseorderdetailcoll.Add(p); } purchaseorder.PurchaseOrderDetails = purchaseorderdetailcoll; context.AddToPurchaseOrders(purchaseorder); context.SaveChanges(); }
public static void generateDetails(int poNumber, string price, string itemNum, int qty, string desc) { UniversityStoreEntities context = new UniversityStoreEntities(); PurchaseOrderDetail pdetail = new PurchaseOrderDetail(); pdetail.PONumber = poNumber; pdetail.Price = Convert.ToDouble(price); pdetail.ItemNumber = itemNum; pdetail.Description = desc; pdetail.Quantity = Convert.ToInt32(qty); context.AddToPurchaseOrderDetails(pdetail); context.SaveChanges(); }
public static Department getdepartmentfromempid(string empid) { UniversityStoreEntities context = new UniversityStoreEntities(); var q = from x in context.Employees where x.EmployeeNumber == empid select x; Employee emp = q.First <Employee>(); var z = from y in context.Departments where y.DepartmentCode == emp.DepartmentCode select y; Department dep = z.First <Department>(); return(dep); }
//////////////*************Ashwin***************////////////// public static void UpdateStockfromadjustment(String PID, String stat, int qnt) { UniversityStoreEntities us = new UniversityStoreEntities(); Stock s = us.Stocks.First <Stock>(x => x.ItemNumber == PID); if (stat == PRODUCT_ADJUSTMENT_STATUS_REDUCE) { s.TotalInventoryBalance -= qnt; } else if (stat == PRODUCT_ADJUSTMENT_STATUS_INCREASE) { s.TotalInventoryBalance += qnt; } us.SaveChanges(); }
public static List <Object> pupulateInvoice(string supName) { UniversityStoreEntities context = new UniversityStoreEntities(); var b = from x in context.PurchaseOrders where x.Supplier.Name == supName && x.Status == "Pending" select new { x.SupplierCode, x.DateCreated, x.Supplier.Name, x.Status, x.PONumber }; return(b.ToList <Object>()); }