public ActionResult AddApproverDetails(ProcessFlowApproverList model)
{
try
{
int value = ProcessGuidelineBO.AddApproverDetails(model);
return(Json(new { result = value }));
}
catch
{
return(Json("Error:AddApproverDetails", JsonRequestBehavior.AllowGet));
}
}
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);
}
}
