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);
}
}
