public JsonResult WorkFlowStatusbyformid(string formId)
{
WorkFlowStatusControllers workFlowStatusControllers = new WorkFlowStatusControllers();
WorkFlowList workflowlist = workFlowStatusControllers.StatusbyformId(formId);
return(Json(new { Response = workflowlist }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// method to bind data to ModuleDropDownList from database
/// </summary>
public void getModule()
{
WorkFlowBO objWorkFlow = new WorkFlowBO();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
objWorkFlowList = WorkFlowBLLobj.getAllModule();
ddlModuleDropDownList.DataSource = objWorkFlowList;//dt.Tables[0];
ddlModuleDropDownList.DataTextField = "MODULENAME";
ddlModuleDropDownList.DataValueField = "MODULEID";
ddlModuleDropDownList.DataBind();
ddlModuleDropDownList.Items.Insert(0, new ListItem("-- Select --", "0"));
ddlModuleDropDownList.SelectedIndex = 0;
}
/// <summary>
/// method to bind data to HightAuthDropDownList from database
/// </summary>
public void getAllProjectPersonUser()
{
WorkFlowBO objWorkFlow = new WorkFlowBO();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
string projectID = Session["PROJECT_ID"].ToString();
objWorkFlowList = WorkFlowBLLobj.getAllProjectPersonUser(projectID);
ListItem lstItem1 = HightAuthDropDownList.Items[0];
HightAuthDropDownList.Items.Clear();
HightAuthDropDownList.DataSource = objWorkFlowList;//dt.Tables[0];
HightAuthDropDownList.DataTextField = "UserName";
HightAuthDropDownList.DataValueField = "UserID";
HightAuthDropDownList.DataBind();
HightAuthDropDownList.Items.Insert(0, lstItem1);
}
/// <summary>
/// method to bind data to WorkflowItemDropDownList from database
/// </summary>
public void getWorkfolwitemByModuleID()
{
int ModuleID = Convert.ToInt32(ModuleDropDownList.SelectedItem.Value.ToString());
WorkFlowBO objWorkFlow = new WorkFlowBO();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
objWorkFlowList = WorkFlowBLLobj.GetWorkFlowByModuleId(ModuleID);
ListItem lstItem = WorkflowItemDropDownList.Items[0];
WorkflowItemDropDownList.Items.Clear();
WorkflowItemDropDownList.DataSource = objWorkFlowList;//dt.Tables[0];
WorkflowItemDropDownList.DataTextField = "WorkDesc";
WorkflowItemDropDownList.DataValueField = "WorkflowID";
WorkflowItemDropDownList.DataBind();
WorkflowItemDropDownList.Items.Insert(0, lstItem);
}
/// <summary>
/// method to fetch userdetails based on roleid
/// </summary>
/// <param name="roleID"></param>
public void getUserByRoleID(int roleID)
{
WorkFlowBO objWorkFlow = new WorkFlowBO();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
int projectID = Convert.ToInt32(Session["PROJECT_ID"].ToString());
//int roleID_ = roleID;
objWorkFlowList = WorkFlowBLLobj.getApprovalRoleUserID(projectID, roleID);
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.DataSource = objWorkFlowList;//dt.Tables[0];
ApproverNameDropDownList.DataTextField = "ApproverUserName";
ApproverNameDropDownList.DataValueField = "ApproverUserID";
ApproverNameDropDownList.DataBind();
ApproverNameDropDownList.Items.Insert(0, lstItem);
}
/// <summary>
/// method to bind data to ApproverRoleNameDropDownList from database
/// </summary>
public void getAllRole()
{
WorkFlowBO objWorkFlow = new WorkFlowBO();
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
string projectID = Session["PROJECT_ID"].ToString();
objWorkFlowList = WorkFlowBLLobj.getAllEmpName(projectID);
ListItem lstItem = ApproverRoleNameDropDownList.Items[0];
ApproverRoleNameDropDownList.Items.Clear();
ApproverRoleNameDropDownList.DataSource = objWorkFlowList;//dt.Tables[0];
ApproverRoleNameDropDownList.DataTextField = "RoleName";
ApproverRoleNameDropDownList.DataValueField = "RoleID";
ApproverRoleNameDropDownList.DataBind();
ApproverRoleNameDropDownList.Items.Insert(0, lstItem);
ApproverRoleNameDropDownList.SelectedIndex = 0;
//Comment add by Ramu under gudines of amalesh
//HightAuthDropDownList
}
/// <summary>
/// Set edit mode for edit comand
/// Delete data from the database for delete comand
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdApprover_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["WorkApprovalID"] = e.CommandArgument;
ADDButton.Visible = false;
UpDateButton.Visible = true;
CancelButton.Visible = true;
GetApprover();
;
}
else if (e.CommandName == "DeleteRow")
{
ViewState["WorkApprovalID"] = e.CommandArgument;
int level = 0;
int sameLavel = 0;
GridViewRow row = (GridViewRow)((ImageButton)e.CommandSource).NamingContainer;
Literal litWorkApprovallevel = (Literal)row.FindControl("litWorkApprovallevel");
WorkFlowBLL WorkFlowBLLOBJ = new WorkFlowBLL();
WorkFlowList WorkFlowList = new WorkFlowList();
string projectID = Session["PROJECT_ID"].ToString();
string WorkflowDefID = ViewState["WorkFlowDefID"].ToString();
WorkFlowList = WorkFlowBLLOBJ.GetApprover(projectID, WorkflowDefID);
for (int i = 0; i < WorkFlowList.Count; i++)
{
level = (WorkFlowList[i].LEVEL);
if (level == (Convert.ToInt32(litWorkApprovallevel.Text.ToString())))
{
sameLavel = 0;
}
else
{
sameLavel = 1;
}
}
WorkFlowList = WorkFlowBLLOBJ.GetApprover(projectID, WorkflowDefID);
if (sameLavel == 0)
{
if (Convert.ToInt32(ViewState["WorkApprovalID"]) != 0)
{
int result = 0;
result = DeleteApprover();
if (result == 0)
{
string message = "Approver Already in use";
string AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
else if (result == -1)
{
string message = "Data Deleted successfully";
string AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
BindGrid(false, true);
ADDButton.Visible = true;
UpDateButton.Visible = false;
CancelButton.Visible = false;
getAllRole();
getLevel();
}
}
else
{
string message = "Delete Higher Level Approver First";
string AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
}
}
}
/// <summary>
/// To save or edit details to the database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void ADDButton_Click(object sender, EventArgs e)
{
string message = string.Empty;
string AlertMessage = string.Empty;
WorkFlowBLL WorkFlowBLLOBJ = new WorkFlowBLL();
WorkFlowList WorkFlowList = new WorkFlowList();
int level = 0;
int count;
int sameLavel = 0;
string projectID = Session["PROJECT_ID"].ToString();
string testWorkflowDefID = ViewState["WorkFlowDefID"].ToString();
string WorkflowDefID = ViewState["WorkFlowDefID"].ToString();
WorkFlowList = WorkFlowBLLOBJ.GetApprover(projectID, WorkflowDefID);
if (WorkFlowList.Count == 0)
{
level = level + 1;
if (level == (Convert.ToInt32(ApproverLevelDropDownList.SelectedItem.Value.ToString())))
{
sameLavel = 0;
}
else
{
sameLavel = 1;
}
}
else
{
for (int i = 0; i < WorkFlowList.Count; i++)
{
if (WorkApproverIDTextBox.Text != "0")
{
level = (WorkFlowList[i].LEVEL);
if (level == (Convert.ToInt32(ApproverLevelDropDownList.SelectedItem.Value.ToString())))
{
sameLavel = 0;
}
else
{
sameLavel = 1;
break;
}
}
else
{
level = (WorkFlowList[i].LEVEL) + 1;
if (level == (Convert.ToInt32(ApproverLevelDropDownList.SelectedItem.Value.ToString())))
{
sameLavel = 0;
}
else
{
sameLavel = 1;
}
}
}
}
if (WorkApproverIDTextBox.Text != "0")
{
#region for update
if (sameLavel == 0)
{
string uID = Session["USER_ID"].ToString();
string pID = Session["PROJECT_ID"].ToString();
WorkFlowBO objWorkFlow = new WorkFlowBO();
objWorkFlow.ApprovalID = Convert.ToInt32(ApproverRoleNameDropDownList.SelectedItem.Value.ToString());
objWorkFlow.ApproverUserID = Convert.ToInt32(ApproverNameDropDownList.SelectedItem.Value.ToString());
objWorkFlow.LEVEL = Convert.ToInt32(ApproverLevelDropDownList.SelectedItem.Value.ToString());
objWorkFlow.UserID = Convert.ToInt32(uID);
objWorkFlow.ProjectID = Convert.ToInt32(pID);
objWorkFlow.WorkFlowDefID = Convert.ToInt32(WorkDefinationTextBox.Text.ToString());
objWorkFlow.WorkApprovalID = Convert.ToInt32(ViewState["WorkApprovalID"]);
count = WorkFlowBLLOBJ.EditAPPROVALADD(objWorkFlow);
if (count == 1)
{
message = "Approver or Level Already Exists";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
ADDButton.Visible = true;
UpDateButton.Visible = false;
CancelButton.Visible = false;
WorkApproverIDTextBox.Text = "0";
WorkDefinationTextBox.Text = "0";
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
ApproverLevelDropDownList.Enabled = true;
}
else if (count == -1)
{
message = "Approver updated successfully";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
ADDButton.Visible = true;
UpDateButton.Visible = false;
CancelButton.Visible = false;
WorkApproverIDTextBox.Text = "0";
WorkDefinationTextBox.Text = "0";
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
ApproverLevelDropDownList.Enabled = true;
}
}
else
{
message = "Approver or Level Already Exists";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
ADDButton.Visible = true;
UpDateButton.Visible = false;
CancelButton.Visible = false;
WorkApproverIDTextBox.Text = "0";
WorkDefinationTextBox.Text = "0";
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
ApproverLevelDropDownList.Enabled = true;
//getAllRole();
}
getAllRole();
getLevel();
#endregion
}
else
{
#region For Save
try
{
if (sameLavel == 0)
{
string uID = Session["USER_ID"].ToString();
string pID = Session["PROJECT_ID"].ToString();
WorkFlowBO objWorkFlow = new WorkFlowBO();
objWorkFlow.ApprovalID = Convert.ToInt32(ApproverRoleNameDropDownList.SelectedItem.Value.ToString());
objWorkFlow.ApproverUserID = Convert.ToInt32(ApproverNameDropDownList.SelectedItem.Value.ToString());
objWorkFlow.LEVEL = Convert.ToInt32(ApproverLevelDropDownList.SelectedItem.Value.ToString());
objWorkFlow.UserID = Convert.ToInt32(uID);
objWorkFlow.ProjectID = Convert.ToInt32(pID);
objWorkFlow.WorkFlowDefID = Convert.ToInt32(ViewState["WorkFlowDefID"]);
count = WorkFlowBLLOBJ.InsertAPPROVALADD(objWorkFlow);
if (count == 1)
{
message = "Approver or Level Already Exists";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
getAllRole();
getLevel();
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
}
else if (count == -1)
{
message = "Approver Added successfully";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
getAllRole();
getLevel();
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
}
}
else
{
message = " Approvers are Not Defined for Previous Level(s) ";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
BindGrid(true, true);
getAllRole();
getLevel();
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
WorkFlowBLLOBJ = null;
}
#endregion
}
}
/// <summary>
/// method for total count of approval
/// </summary>
/// <param name="ProjectId"></param>
/// <returns></returns>
public int totalcountapproval(int ProjectId)
{
int finalcount = 0;
int approvalcount = 0;
WorkFlowBO objProjectRoute = new WorkFlowBO();
WorkFlowBLL objProjectRouteBLL = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
WorkFlowBO objPrintApprovalWF = null;
WorkFlowList objWorkFlowList_ = null;
string ChangeRequestCode = UtilBO.WorkflowDataVerification;
objProjectRoute.WorkFlowApprover = ChangeRequestCode;
objProjectRoute.Project_Id = ProjectId;
objWorkFlowList = objProjectRouteBLL.getTotalcountapproval(objProjectRoute);
if (objWorkFlowList.Count > 0)
{
int totalapprovalCount = Convert.ToInt32(objProjectRoute.CountApproval);
for (int i = 0; i < objWorkFlowList.Count; i++)
{
//if (Session["HH_ID"] != null)
//{
// objProjectRoute.HHID = Convert.ToInt32(Session["HH_ID"].ToString());
//}
//else
//{
// objProjectRoute.HHID = 0;
//}
objProjectRoute.HHID = 0;
//objProjectRoute.HHID = householdID;
objProjectRoute.PageCode = UtilBO.WorkflowDataVerification; // objHouseHold.PageCode = "DATAV";
objProjectRoute.WorkflowCode = UtilBO.WorkflowDataVerification;
objProjectRoute.LEVEL = objWorkFlowList[i].CountApproval;
objPrintApprovalWF = objProjectRouteBLL.ApprovalStatuscheck(objProjectRoute);
//addtional list
objWorkFlowList_ = objProjectRouteBLL.ApprovalStatuschecklist(objProjectRoute);
if (objPrintApprovalWF != null)
{
if (objWorkFlowList[i].CountApproval == objPrintApprovalWF.LEVEL)
{
if (objPrintApprovalWF.ApprovalstatusID == 1)
{
finalcount = 1;
break;
}
else if (objPrintApprovalWF.ApprovalstatusID == 2)
{
finalcount = 2;
approvalcount = 0;
break;
}
else if (objPrintApprovalWF.ApprovalstatusID == 3)
{
finalcount = 3;
approvalcount = 0;
break;
}
}
else
{
//i + 1; addtionl Code
if (objWorkFlowList[i].CountApproval == objWorkFlowList_[i].LEVEL)
{
if (objWorkFlowList_[i].ApprovalstatusID == 3)
{
finalcount = 3;
break;
}
else
{
approvalcount = 0;
}
}
}
}
if (objWorkFlowList.Count == approvalcount)
{
finalcount = 1;
}
else
{
finalcount = 0;
}
}
}
return(finalcount);
}
/// <summary>
/// Che Approval Status
/// </summary>
/// <returns></returns>
public int totalcountapproval()
{
int finalcount = 0;
int approvalcount = 0;
WorkFlowBO objProjectRoute = new WorkFlowBO();
WorkFlowBLL objProjectRouteBLL = new WorkFlowBLL();
WorkFlowList objWorkFlowList = new WorkFlowList();
WorkFlowBO objPrintApprovalWF = null;
string ChangeRequestCode = UtilBO.CompensationPrintRequest;
objProjectRoute.WorkFlowApprover = ChangeRequestCode;
objProjectRoute.Project_Id = Convert.ToInt32(Session["PROJECT_ID"].ToString());
objWorkFlowList = objProjectRouteBLL.getTotalcountapproval(objProjectRoute);
if (objWorkFlowList.Count > 0)
{
int totalapprovalCount = Convert.ToInt32(objProjectRoute.CountApproval);
for (int i = 0; i < objWorkFlowList.Count; i++)
{
int householdID = Convert.ToInt32(Session["HH_ID"].ToString());
objProjectRoute.HHID = householdID;
objProjectRoute.PageCode = documentCode;
objProjectRoute.WorkflowCode = UtilBO.CompensationPrintRequest;
objProjectRoute.LEVEL = objWorkFlowList[i].CountApproval;
objPrintApprovalWF = objProjectRouteBLL.ApprovalStatuscheck(objProjectRoute);
if (objPrintApprovalWF != null)
{
if (objWorkFlowList[i].CountApproval == objPrintApprovalWF.LEVEL)
{
if (objPrintApprovalWF.ApprovalstatusID == 1)
{
finalcount = 1;
break;
}
else if (objPrintApprovalWF.ApprovalstatusID == 2)
{
finalcount = 2;
approvalcount = 0;
break;
}
else if (objPrintApprovalWF.ApprovalstatusID == 3)
{
finalcount = 3;
approvalcount = 0;
break;
}
}
else
{
approvalcount = 0;
}
}
if (objWorkFlowList.Count == approvalcount)
{
finalcount = 1;
}
else
{
finalcount = 0;
}
}
}
return(finalcount);
}
