public static void ConfirmRecivedItems(string DI, List <DisbursementDetail> ddlist) { Staff rep = new Staff(); using (InventorySysDBEntities cntx = new InventorySysDBEntities()) { //update disbursmentdetail foreach (DisbursementDetail dd in ddlist) { updateDisbursmentDetail(cntx, dd); } //update disbursment Disbursement disbursment = cntx.Disbursements.Find(DI); rep = StaffController.getRepByDepID(disbursment.Dept_ID); disbursment.Receive_Date = DateTime.Now; disbursment.Status = "Recieved"; // update Requisition List <Requisition> reqList = getRequisitionsByDI(DI); foreach (Requisition req in reqList) { Requisition reqData = cntx.Requisitions.Find(req.Requisition_ID); reqData.Status = "Received"; } cntx.SaveChanges(); } SendNotificationController.SendNotificaition(rep, DI); }
//delegate //create new delegate public static void createDelegateHistory(string sfid, string managerId, DateTime startDate, DateTime endDate) { var t = from x in ctx.Staffs where x.Staff_ID == sfid select x; Staff sf = t.First(); sf.Role_ID = "AuthStaff"; DelegateHistory dh = new DelegateHistory(); dh.Manager_ID = managerId; dh.Staff_ID = sf.Staff_ID; dh.Start_Date = Convert.ToDateTime(startDate); dh.End_Date = Convert.ToDateTime(endDate); dh.Status = "Delegated"; ctx.DelegateHistories.Add(dh); ctx.SaveChanges(); }
//public static bool ChangeRepToStaff(string deptID) //{ // using (InventorySysDBEntities cntx = new InventorySysDBEntities()) // { // Staff stf = GetRepByDeptID(deptID); // Staff repStaff = cntx.Staffs.Find(stf.Staff_ID); // if (repStaff != null) // { // repStaff.Role_ID = "Staff"; // cntx.SaveChanges(); // return true; // } // else // return false; // } //} //public static bool ChangeStaffToRep(string staffID) //{ // using (InventorySysDBEntities cntx = new InventorySysDBEntities()) // { // var q = from x in cntx.Staffs where x.Staff_ID == staffID select x; // if (q.ToList().Count > 0) // { // q.First().Role_ID = "RepStaff"; // cntx.SaveChanges(); // return true; // } // else // return false; // } //} public static void UpdateCollectionPoint(string DeptID, string ColID) { using (InventorySysDBEntities cntx = new InventorySysDBEntities()) { var q = from x in cntx.Departments where x.Dept_ID == DeptID select x; Department d = q.First(); d.Collection_ID = ColID; cntx.SaveChanges(); } }
public static bool UpdateCollectionPoint(string DeptID, string staffID, string ColID) { using (InventorySysDBEntities cntx = new InventorySysDBEntities()) { using (var dbContextTransaction = cntx.Database.BeginTransaction()) { try { //make here the changes Staff stf = GetRepByDeptID(DeptID); Staff repStaff = cntx.Staffs.Find(stf.Staff_ID); repStaff.Role_ID = "Staff"; var changeStaffTRep = from x in cntx.Staffs where x.Staff_ID == staffID select x; changeStaffTRep.First().Role_ID = "RepStaff"; var updateCollectionPoint = from x in cntx.Departments where x.Dept_ID == DeptID select x; Department d = updateCollectionPoint.First(); d.Collection_ID = ColID; cntx.SaveChanges(); dbContextTransaction.Commit(); return(true); } catch (Exception ex) { dbContextTransaction.Rollback(); return(false); } } } }