public static int UnmapProcessflowUser(List <ProcessFlowUser> selectedUser) { try { tblProcessGuidelineUser pglUser; int rowsAffected = 0; using (var context = new IOASDBEntities()) { if (selectedUser.Count > 0) { foreach (var user in selectedUser) { pglUser = context.tblProcessGuidelineUser.Where(s => s.UserId == user.UserId && s.ProcessGuidelineDetailId == user.ProcessGuidelineDetailId).FirstOrDefault(); context.Entry(pglUser).State = System.Data.Entity.EntityState.Deleted; rowsAffected = rowsAffected + context.SaveChanges(); } } } return(rowsAffected); } catch { return(-1); } }
public static int DeletePGLWorkflow(int processguidlineworkflowId) { try { tblProcessGuidelineWorkFlow pglWF; int rowsAffected = 0; using (var context = new IOASDBEntities()) { pglWF = context.tblProcessGuidelineWorkFlow.Where(s => s.ProcessGuidelineWorkFlowId == processguidlineworkflowId).FirstOrDefault(); context.Entry(pglWF).State = System.Data.Entity.EntityState.Deleted; rowsAffected = context.SaveChanges(); } return(rowsAffected); } catch { return(-1); } }
public static int UpdateProcessFlow(ProcessFlowModel model) { tblProcessGuidelineDetail pgd; using (var context = new IOASDBEntities()) { pgd = context.tblProcessGuidelineDetail.Where(s => s.ProcessGuidelineDetailId == model.ProcessGuidelineDetailId).FirstOrDefault(); } if (pgd != null) { pgd.FlowTitle = model.FlowTitle; } using (var dbCtx = new IOASDBEntities()) { dbCtx.Entry(pgd).State = System.Data.Entity.EntityState.Modified; dbCtx.SaveChanges(); } return(model.ProcessGuidelineDetailId); }
public static int InsertProcessGuideline(ProcessGuideline model) { using (var context = new IOASDBEntities()) { tblProcessGuidelineHeader objIU = new tblProcessGuidelineHeader(); objIU.ProcessGuidelineId = model.ProcessGuidelineId; objIU.FunctionId = model.FunctionId; objIU.ProcessGuidelineTitle = model.ProcessName; if (model.ProcessGuidelineId == 0) { context.tblProcessGuidelineHeader.Add(objIU); } else { context.Entry(objIU).State = System.Data.Entity.EntityState.Modified; } context.SaveChanges(); context.Dispose(); return(objIU.ProcessGuidelineId); } }
public static int AddApproverDetails(ProcessFlowApproverList model) { try { using (var context = new IOASDBEntities()) { int rowsAffected = 0, pglWorkflowId = 0; if (model.ProcessguidlineworkflowId == 0) { tblProcessGuidelineWorkFlow objIU = new tblProcessGuidelineWorkFlow(); objIU.ProcessGuidelineId = model.processguidlineId; objIU.ProcessGuidelineDetailId = model.ProcessGuidelineDetailId; objIU.StatusId = model.StatusId; objIU.ApproverId = model.UserId; objIU.ApproverLevel = model.ApproverLevel; objIU.Approve_f = model.ApproveFlag; objIU.Reject_f = model.RejectFlag; objIU.Clarify_f = model.ClarifyFlag; objIU.Mark_f = model.MarkFlag; context.tblProcessGuidelineWorkFlow.Add(objIU); rowsAffected = context.SaveChanges(); pglWorkflowId = objIU.ProcessGuidelineWorkFlowId; } else { tblProcessGuidelineWorkFlow objupdate = new tblProcessGuidelineWorkFlow(); objupdate = context.tblProcessGuidelineWorkFlow.Where(M => M.ProcessGuidelineWorkFlowId == model.ProcessguidlineworkflowId).FirstOrDefault(); if (objupdate != null) { objupdate.ProcessGuidelineId = model.processguidlineId; objupdate.ProcessGuidelineDetailId = model.ProcessGuidelineDetailId; objupdate.StatusId = model.StatusId; objupdate.ApproverId = model.UserId; objupdate.ApproverLevel = model.ApproverLevel; objupdate.Approve_f = model.ApproveFlag; objupdate.Reject_f = model.RejectFlag; objupdate.Clarify_f = model.ClarifyFlag; objupdate.Mark_f = model.MarkFlag; rowsAffected = context.SaveChanges(); pglWorkflowId = objupdate.ProcessGuidelineWorkFlowId; } } //Document insertion if ((model.ProcessguidlineworkflowId == 0 && rowsAffected > 0) || model.ProcessguidlineworkflowId > 0) { //Remove existing document tblProcessGuidelineDocument objDocDelete; objDocDelete = context.tblProcessGuidelineDocument.Where(s => s.WorkflowId == pglWorkflowId).FirstOrDefault(); if (objDocDelete != null) { context.Entry(objDocDelete).State = System.Data.Entity.EntityState.Deleted; context.SaveChanges(); } //Insert new document tblProcessGuidelineDocument objDoc = new tblProcessGuidelineDocument(); objDoc.DocumentId = model.DocumentId; objDoc.WorkflowId = pglWorkflowId; context.tblProcessGuidelineDocument.Add(objDoc); context.SaveChanges(); } return(pglWorkflowId); } } catch (Exception ex) { return(-1); } }