public void InsertInitialFormItems(ICollection <FormItems> formItemList, int msrId) { using (var context = new MSR_MaxEntities()) { foreach (Domain.FormItems item in formItemList) { var tempFormItem = new FormItem { ItemCode = item.ItemCode, ItemDesc = item.ItemDesc, Quantity = Double.Parse(item.Quantity), Unit = item.Unit, UnitPrice = String.IsNullOrEmpty(item.UnitPrice) ? (double?)null : Convert.ToDouble(item.UnitPrice), Currency = item.Currency, ROS_Date = item.ROSDate, Comments = item.Comments, MSRId = msrId, AC_No = item.ACNo }; context.FormItems.Add(tempFormItem); } context.SaveChanges(); } }
internal void UpdateMSRNeedReview(int msrId, String stateFlag) { using (var context = new MSR_MaxEntities()) { var msr_db = context.MSRs.Find(msrId); if (msr_db != null) { msr_db.StateFlag = stateFlag; context.SaveChanges(); } } }
public void UpdateMSRWaitForApproval(int msrId, String path, String commentFromPath, DateTime approvalDate, String stateFlag) { if (path.Equals("Approve")) { using (var context = new MSR_MaxEntities()) { var msr_db = context.MSRs.Find(msrId); if (msr_db != null) { msr_db.Appr_Date = approvalDate; msr_db.StateFlag = stateFlag; context.SaveChanges(); } } } else if (path.Equals("Send for Review")) { using (var context = new MSR_MaxEntities()) { var msr_db = context.MSRs.Find(msrId); if (msr_db != null) { msr_db.Review_Comment = commentFromPath; msr_db.StateFlag = stateFlag; context.SaveChanges(); } } } else if (path.Equals("Decline")) { using (var context = new MSR_MaxEntities()) { var msr_db = context.MSRs.Find(msrId); if (msr_db != null) { msr_db.Decline_Comment = commentFromPath; msr_db.StateFlag = stateFlag; context.SaveChanges(); } } } else { } }
public void DeleteFormItemsByMSRId(String msrId) { using (var context = new MSR_MaxEntities()) { //Log DB commands to console context.Database.Log = Console.WriteLine; var msr_db = context.MSRs .Include("FormItems") .Where(x => x.MSRId.ToString().Equals(msrId)) .First(); var formItemsToDelete = msr_db.FormItems; context.FormItems.RemoveRange(formItemsToDelete); context.SaveChanges(); } }
public void InsertIntialMSR(Domain.ApproverInfo approverInfo, String project, String vwl, String comments, String budgetYear, String bpNo, String afe, String sugVendor, String contactVendor, DateTime reqDate) { using (var context = new MSR_MaxEntities()) { //Log DB commands to console context.Database.Log = Console.WriteLine; //First obtain referenced users var usr_RO = context.Usrs.Find(BusinessAPI.BusinessSingleton.Instance.userInfo_EF.UserId); var usr_CA = context.Usrs.Find(Int32.Parse(approverInfo.UserId)); //Initialize new MSR var tempMSR = new MSR { Project = project, WVL = vwl, Comments = comments, BudgetYear = Int32.Parse(budgetYear), BP_No = bpNo, AFE = afe, SugVendor = sugVendor, ContactVendor = contactVendor, Usr_RO = usr_RO, Usr_CA = usr_CA, Req_Date = reqDate, PUR_Comment = "", Decline_Comment = "", Review_Comment = "", StateFlag = Domain.WorkFlowTrace.WAIT_FOR_APPROVAL }; //Adds the newly created MSR context.MSRs.Add(tempMSR); context.SaveChanges(); //Gets the just inserted MSR int MSRId = tempMSR.MSRId; //Attaches the FormItems to that MSR just created InsertInitialFormItems(BusinessAPI.BusinessSingleton.Instance.formItemListCreateMSR, MSRId); } }