public void ReqNo(int eid1) { var genReqNo = (from grn1 in ad.Requests where grn1.RequestStatus == "NEW" && grn1.RequestByEmployeeID == eid1 select grn1).ToList(); if (genReqNo.Count > 0) { int reqno = genReqNo[0].RequestID; using (var ctxt = new ADProjectSA40Team4Entities()) { lk: var x = (from y in ctxt.RequestDetails where y.RequestID == reqno select y).FirstOrDefault(); if (x != null) { ctxt.RequestDetails.Remove(x); ctxt.SaveChanges(); goto lk; } var x1 = (from y1 in ctxt.Requests where y1.RequestID == reqno select y1).FirstOrDefault(); ctxt.Requests.Remove(x1); ctxt.SaveChanges(); } } }
public void UpdReqStat(int tran) { Request trt = ad.Requests.Single(tid => tid.RequestID == tran); trt.RequestStatus = "EDIT"; ad.SaveChanges(); }
public bool DeleteItem(string IID, int RTID) { using (var ctx = new ADProjectSA40Team4Entities()) { var x = (from y in ctx.RequestDetails where y.RequestedItem == IID && y.RequestID == RTID select y).FirstOrDefault(); ctx.RequestDetails.Remove(x); ctx.SaveChanges(); var xe = (from y in ctx.RequestDetails where y.RequestID == RTID select y).ToList(); if (xe.Count < 1) { var x1 = (from y1 in ctx.Requests where y1.RequestID == RTID select y1).FirstOrDefault(); ctx.Requests.Remove(x1); ctx.SaveChanges(); return(true); } else { return(false); } } }
public int updateDisburse(string deptid, string empid1) { int empid = Convert.ToInt32(empid1); var ddptg = (from odr in ad.Requests where odr.RequestStatus == "Alloted" && odr.RequestByDepartmentID == deptid select odr).ToList(); foreach (var qin in ddptg) { var outstand = (from ot in ad.RequestDetails where ot.RequestID == qin.RequestID && ot.RequestedQty != ot.ReceivedQty select ot).ToList(); if (outstand.Count > 0) { Request reqout = new Request { RequestStatus = "NEW", RequestByDepartmentID = qin.RequestByDepartmentID, RequestByEmployeeID = empid }; ad.Requests.Add(reqout); try { ad.SaveChanges(); } catch (Exception tye) { Console.WriteLine(tye); } var genReqNo = (from grn1 in ad.Requests where grn1.RequestStatus == "NEW" && grn1.RequestByEmployeeID == empid && grn1.RequestByDepartmentID == qin.RequestByDepartmentID select grn1).ToList(); int reqnoutstand = genReqNo[0].RequestID; EmpNewRequest outstandnewreq = new EmpNewRequest(); foreach (var outstandvar in outstand) { int qtyoutstand = (int)(outstandvar.RequestedQty - outstandvar.ReceivedQty); outstandnewreq.AddItem(reqnoutstand, outstandvar.RequestedItem, qtyoutstand); } outstandnewreq.AddOutStandingReqNo(reqnoutstand); } var all12 = from a12 in ad.Requests where a12.RequestID == qin.RequestID select a12; Request req = all12.First(); req.RequestStatus = "Disbursed"; req.ReceivedDate = System.DateTime.Now.Date; try { ad.SaveChanges(); } catch (Exception tye) { Console.WriteLine(tye); return(0); } } return(1); }
public dynamic GetReqNo(string dptid1, int eid1) { var genReqNo = (from grn1 in ad.Requests where grn1.RequestStatus == "NEW" && grn1.RequestByEmployeeID == eid1 select grn1).ToList(); if (genReqNo.Count > 0) { return(genReqNo); } else { Request req = new Request { RequestStatus = "NEW", RequestByDepartmentID = dptid1, RequestByEmployeeID = eid1 }; ad.Requests.Add(req); try { ad.SaveChanges(); } catch (Exception tye) { Console.WriteLine(tye); } var genReqNo1 = (from grn1 in ad.Requests where grn1.RequestStatus == "NEW" && grn1.RequestByEmployeeID == eid1 select grn1).ToList(); return(genReqNo1); } }
public void UpdateCollectionPt(string dep, int trancptid) { using (TransactionScope ts = new TransactionScope()) { Department dcpt = (from ftg in ad.Departments where ftg.DepartmentID == dep select ftg).SingleOrDefault(); dcpt.CollectionPointID = trancptid; ad.SaveChanges(); ts.Complete(); } }
public void DeleteReqNo(int tran) { using (var ctxt = new ADProjectSA40Team4Entities()) { lk: var x = (from y in ctxt.RequestDetails where y.RequestID == tran select y).FirstOrDefault(); if (x != null) { ctxt.RequestDetails.Remove(x); ctxt.SaveChanges(); goto lk; } var x1 = (from y1 in ctxt.Requests where y1.RequestID == tran select y1).FirstOrDefault(); ctxt.Requests.Remove(x1); ctxt.SaveChanges(); } }
public int NewRaiseAdj(int eid1) { int req = 0; var genAdjNo = (from gadrn1 in ad.Adjustments where gadrn1.AdjustmentStatus == "NEW" && gadrn1.AdjustedByEmployeeID == eid1 select gadrn1).ToList(); if (genAdjNo.Count > 0) { req = genAdjNo[0].AdjustmentID; } else { Adjustment areq = new Adjustment { AdjustmentStatus = "NEW", AdjustedByEmployeeID = eid1 }; ad.Adjustments.Add(areq); try { ad.SaveChanges(); } catch (Exception tye) { Console.WriteLine(tye); } var raisead = (from graise1 in ad.Adjustments where graise1.AdjustmentStatus == "NEW" && graise1.AdjustedByEmployeeID == eid1 select graise1).ToList(); req = raisead[0].AdjustmentID; } return(req); }
public void RaisePurchaseControlOrder(DataTable dt2, int employeid, DateTime date) { int req = 0; DataTable dt = new DataTable(); dt = dt2; int supid = Convert.ToInt32(dt.Rows[0]["supplierid"]); PurchaseOrder poentry = new PurchaseOrder { PurchaseStatus = "NEW", SupplierID = supid, EmployeeID = employeid }; ad.PurchaseOrders.Add(poentry); ad.SaveChanges(); for (int f = 0; f < dt.Rows.Count; f++) { like: var genReqNo = (from grn1 in ad.PurchaseOrders where grn1.PurchaseStatus == "NEW" && grn1.SupplierID == supid && grn1.EmployeeID == employeid select grn1).ToList(); if (genReqNo.Count > 0) { req = genReqNo[0].PurchaseOrderID; if (Convert.ToInt32(dt.Rows[f]["supplierid"]) == supid) { PurchaseOrderDetail reqd = new PurchaseOrderDetail { PurchaseOrderID = req, ItemID = Convert.ToString(dt.Rows[f]["itemid"]), OrderQty = Convert.ToInt32(dt.Rows[f]["suggestedqty"]), ReceivedQty = 0 }; ad.PurchaseOrderDetails.Add(reqd); try { ad.SaveChanges(); } catch (Exception tye) { Console.WriteLine(tye); } if ((f + 1) < dt.Rows.Count) { supid = Convert.ToInt32(dt.Rows[f + 1]["supplierid"]); } } } else { PurchaseOrder poentry2 = new PurchaseOrder { PurchaseStatus = "NEW", SupplierID = supid, EmployeeID = employeid }; ad.PurchaseOrders.Add(poentry2); ad.SaveChanges(); goto like; } } like2: var genReqNo2 = (from grn1 in ad.PurchaseOrders where grn1.PurchaseStatus == "NEW" && grn1.EmployeeID == employeid select grn1).ToList(); if (genReqNo2.Count > 0) { int reqtid = genReqNo2[0].PurchaseOrderID; PurchaseOrder addreq = (from c in ad.PurchaseOrders where c.PurchaseOrderID == reqtid select c).SingleOrDefault(); //ad.Requests.Single(rid => rid.RequestID == reqtid); addreq.PurchaseStatus = "Pending"; addreq.OrderDate = System.DateTime.Now.Date; addreq.ExpectedDeliveryDate = date; try { ad.SaveChanges(); //sendmail(reqtid); } catch (Exception tye) { Console.WriteLine(tye); } goto like2; } }