/// <summary>
/// To Update Work flow
/// </summary>
/// <param name="objWorkFlow"></param>
/// <returns></returns>
public int UpdateWorkflow(WorkFlowBO objWorkFlow)
{
WorkflowDAL WorkflowDAL = new WorkflowDAL(); //Data pass -to Database Layer
try
{
return(WorkflowDAL.UpdateWorkflow(objWorkFlow));
}
catch
{
throw;
}
finally
{
WorkflowDAL = null;
}
}
/// <summary>
/// To Edit Approver
/// </summary>
/// <param name="objWorkFlow"></param>
/// <returns></returns>
public int EditAPPROVALADD(WorkFlowBO objWorkFlow)
{
WorkflowDAL WorkflowDAL = new WorkflowDAL(); //Data pass -to Database Layer
try
{
return(WorkflowDAL.EDITAPPROVER(objWorkFlow));
}
catch
{
throw;
}
finally
{
WorkflowDAL = null;
}
}
// To format email for Approval Requests
/// <summary>
/// To Send Email
/// </summary>
/// <param name="projectID"></param>
/// <param name="workFlowCode"></param>
public void SendEmail(int projectID, string workFlowCode)
{
WorkFlowBO objWorkFlow = (new WorkFlowBLL()).getWOrkFlowApprovalID(projectID, workFlowCode);
if (objWorkFlow != null)
{
NotificationBO objNotification = new NotificationBO();
StringBuilder sb = new StringBuilder();
string emailSubject = "";
string emailBody = "";
string approverName = objWorkFlow.ApproverUserName;
emailBody = objWorkFlow.EmailBody;
// Set Email Subject and Body based on Workflow Code
switch (workFlowCode)
{
case "RTA":
emailSubject = string.Format("{0} {1}", objWorkFlow.EmailSubject, objWorkFlow.ProjectName);
emailBody = emailBody.Replace("@@PROJECTNAME", objWorkFlow.ProjectName);
break;
default:
emailSubject = objWorkFlow.EmailSubject;
break;
}
sb.Append("Dear " + approverName + ",");
sb.Append("<br/><br/>");
sb.Append(emailBody);
sb.Append("<br/><br/>");
sb.Append("Thanks and Regards,");
sb.Append("<br/>");
sb.Append("WIS - UETCL Team");
objNotification.EmailID = objWorkFlow.EmailID;
objNotification.EmailSubject = emailSubject;
objNotification.EmailBody = sb.ToString();
objNotification.ProjectCode = objWorkFlow.ProjectCode;
objNotification.ProjectName = objWorkFlow.ProjectName;
(new NotificationDAL()).SendEmail(objNotification);
}
}
/// <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 values from grid and assign to textbox
/// </summary>
private void GetApprover()
{
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
int WORKAPPROVALID = 0;
if (ViewState["WorkApprovalID"] != null)
{
WORKAPPROVALID = Convert.ToInt32(ViewState["WorkApprovalID"]);
}
if (WORKAPPROVALID != 0)
{
WorkFlowBO WorkFlowObj = new WorkFlowBO();
WorkFlowObj = WorkFlowBLLobj.GetWorkFlowById(WORKAPPROVALID);
ApproverRoleNameDropDownList.ClearSelection();
if (ApproverRoleNameDropDownList.Items.FindByValue(WorkFlowObj.RoleID.ToString()) != null)
{
ApproverRoleNameDropDownList.Items.FindByValue(WorkFlowObj.RoleID.ToString()).Selected = true;
}
int RoleID = WorkFlowObj.RoleID;
getUserByRoleID(RoleID);
ApproverNameDropDownList.ClearSelection();
if (ApproverNameDropDownList.Items.FindByValue(WorkFlowObj.UserID.ToString()) != null)
{
ApproverNameDropDownList.Items.FindByValue(WorkFlowObj.UserID.ToString()).Selected = true;
}
ApproverLevelDropDownList.ClearSelection();
if (ApproverLevelDropDownList.Items.FindByValue(WorkFlowObj.LEVEL.ToString()) != null)
{
ApproverLevelDropDownList.Items.FindByValue(WorkFlowObj.LEVEL.ToString()).Selected = true;
}
ApproverLevelDropDownList.Enabled = false;
WorkApproverIDTextBox.Text = WorkFlowObj.WorkApprovalID.ToString();
WorkDefinationTextBox.Text = WorkFlowObj.WorkFlowDefID.ToString();
}
}
/// <summary>
/// to check the status of the approvar exist or not
/// </summary>
public void checkApprovalExitOrNot()
{
#region Enable ChangeRequest Button
StatusPAPLivehood.Text = "";
StatusPAPLivehood1.Text = "";
StatusPAPLivehood.Visible = false;
StatusPAPLivehood1.Visible = false;
// used to display the Status if you send Request for change data
// getApprovalChangerequestStatus(); //To make Visible Save and Cancle Button by checking Approve status
//for checking Change Request Approver Exit or not
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowChangeRequestHH;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
int HHID = Convert.ToInt32(Session["HH_ID"]);
//string pageCode = "HH-LU";
if (objWorkFlowBO != null)
{
string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, "HHSEL");
lnkPAPLiveHood.Attributes.Add("onclick", paramChangeRequest);
lnkPAPLiveHood.Visible = true;
string param = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, "HHSBD");
lnkPAPLivehoodBNKDet.Attributes.Add("onclick", param);
lnkPAPLivehoodBNKDet.Visible = true;
}
else
{
lnkPAPLiveHood.Visible = false;
lnkPAPLivehoodBNKDet.Visible = false;
}
#endregion
getApprrequtStatusPAPLivehood();
getApprrequtStatusBankDetial();
}
/// <summary>
/// To open Email Pop up Window
/// </summary>
public void openEmailPopupWindow()
{
int HHIDIN_ = 0;
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowCdapBudget;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
int HHID = HHIDIN_; //Convert.ToInt32(Session["HH_ID"]);
string pageCode = "CDAPB";
if (objWorkFlowBO != null)
{
string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, pageCode);
ClientScript.RegisterStartupScript(this.GetType(), "CDAPBREQ", paramChangeRequest, true);
}
}
/// <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
}
public void checkApprovalExitOrNot()
{
#region Enable ChangeRequest Button
StatusGroupOwner.Text = "";
StatusGroupOwner.Visible = false; // used to display the Status if you send Request for change data
StatusGroupMenber.Text = "";
StatusGroupMenber.Visible = false;
// getApprovalChangerequestStatus(); //To make Visible Save and Cancle Button by checking Approve status
//for checking Change Request Approver Exit or not
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowChangeRequestHH;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
int HHID = Convert.ToInt32(Session["HH_ID"]);
if (objWorkFlowBO != null)
{
string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, "HHGOS");
lnkGroupOwner.Attributes.Add("onclick", paramChangeRequest);
string paramChangeRequest1 = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, "HHGMS");
lnkGroupMenber.Attributes.Add("onclick", paramChangeRequest1);
lnkGroupOwner.Visible = true;
lnkGroupMenber.Visible = true;
}
else
{
lnkGroupOwner.Visible = false;
lnkGroupMenber.Visible = false;
}
#endregion
getApprrequtStatusGroupOwnerShip();
getApprrequtStatusGroupMemberShip();
}
/// <summary>
/// to check the Approval Exit or Not
/// </summary>
public void checkApprovalExitOrNot()
{
#region Enable ChangeRequest Button
StatusLandHoldings.Text = "";
StatusLandHoldings.Visible = false;
StatusMCE.Text = "";
StatusMCE.Visible = false;
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowChangeRequestHH;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
int HHID = Convert.ToInt32(Session["HH_ID"]);
if (objWorkFlowBO != null)
{
string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, "HHLHH");
lnkLandHoldings.Attributes.Add("onclick", paramChangeRequest);
string paramChangeRequest1 = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, "HHMCE");
lnkMCE.Attributes.Add("onclick", paramChangeRequest1);
lnkLandHoldings.Visible = true;
lnkMCE.Visible = true;
}
else
{
lnkLandHoldings.Visible = false;
lnkMCE.Visible = false;
}
#endregion
getApprrequtStatusLandHoldings();
getApprrequtStatusMCE();
}
/// <summary>
/// Check Approvar Exist or not
/// </summary>
public void checkApprovalExitOrNot()
{
#region Enable ChangeRequest Button
lblCompensationPackageStatus.Text = string.Empty;
lblCompensationPackageStatus.Visible = false;
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowPackageReview;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(Session["PROJECT_ID"]);
int HHID = Convert.ToInt32(Session["HH_ID"]);
string pageCode = "CPREV";
if (objWorkFlowBO != null)
{
string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, pageCode);
lnkValuationPCI.Attributes.Add("onclick", paramChangeRequest);
lnkValuationPCI.Visible = true;
ViewState["ApproveExists"] = "Yes";
}
else
{
lnkValuationPCI.Visible = false;
ViewState["ApproveExists"] = "No";
lblCompensationPackageStatus.Visible = true;
lblCompensationPackageStatus.ForeColor = System.Drawing.Color.Red;
lblCompensationPackageStatus.Text = "Package Review Approver Not Defined";
}
#endregion
getAppoverReqStatusPakClos();
}
/// <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 grdProjects_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditProject")
{
Session["PROJECT_ID"] = e.CommandArgument;
Session["FROZEN"] = null;
getFrozen();
Session["PROJECT_CODE"] = ((LinkButton)e.CommandSource).Text;
Session["HH_ID"] = null;
if (Request.QueryString["mode"] == "redir")
{
Response.Redirect(ResolveUrl("~/UI/Compensation/PAPList.aspx"));
}
else if (Request.QueryString["mode"] == "redirCDAP")
{
Response.Redirect(ResolveUrl("~/UI/Compensation/CDAPImplementation.aspx"));
}
else
{
if (CheckAuthorization.HasUpdatePrivilege(UtilBO.PrivilegeCode.CREATE_PROJECT) == false &&
CheckAuthorization.HasViewPrivilege(UtilBO.PrivilegeCode.CREATE_PROJECT) == false)
{
Response.Redirect(ResolveUrl("~/UI/Compensation/PAPList.aspx"));
}
else
{
Response.Redirect("ProjectDetails.aspx");
}
}
}
else if (e.CommandName == "FreezeProject")
{
ProjectBLL ObjProjectBLL = new ProjectBLL();
ObjProjectBLL.FreezeProject(Convert.ToInt32(e.CommandArgument), Convert.ToInt32(Session["USER_ID"]));
Session["FROZEN"] = null;
getFrozen();
BindProjects(false);
}
else if (e.CommandName == "DataVerificationProject")
{
string message = string.Empty;
// Session["PROJECT_ID"] = e.CommandArgument;
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowDataVerification;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(e.CommandArgument), ChangeRequestCode);
string pageCode = "DATAV";
if (objWorkFlowBO != null)
{
int userID = Convert.ToInt32(Session["USER_ID"]);
int ProjectID = Convert.ToInt32(e.CommandArgument);
int HHID = Convert.ToInt32(Session["HH_ID"]);
string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, pageCode);
ClientScript.RegisterStartupScript(this.GetType(), "DATAVERIFICATIONPROJECT", paramChangeRequest, true);
}
else
{
message = "Data Verification Approval is not defined";
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
}
}
else if (e.CommandName == "Unfreeze")
{
//Call the Popwindow here
int ProjectId = 0;
string ProjectCode = string.Empty;
string CommandArguments = e.CommandArgument.ToString();
string[] strArguments = e.CommandArgument.ToString().Split(new char[] { ',' });
if (strArguments.Length > 1)
{
ProjectId = Convert.ToInt32(strArguments[0]);
ProjectCode = strArguments[1];
}
string callUnfreezeWindow = string.Format("UnfreezeWindow({0},'{1}',{2})", ProjectId, ProjectCode, Convert.ToInt32(Session["USER_ID"]));
ClientScript.RegisterStartupScript(this.GetType(), "callUnfreezeWindow", callUnfreezeWindow, true);
BindProjects(false);
}
}
/// <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>
/// To CloseBatch details
/// </summary>
/// <param name="HHID"></param>
/// <param name="UserId"></param>
/// <param name="BatchNo"></param>
/// <returns></returns>
public string CloseBatch(int HHID, int UserId, int BatchNo, WorkFlowBO objWorkFlow)
{
oBatchDAL = new BatchDAL();
return(oBatchDAL.CloseBatch(HHID, UserId, BatchNo, objWorkFlow));
}
/// <summary>
/// To save details to database
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void SaveButton_Click(object sender, EventArgs e)
{
int count;
WorkFlowBLL WorkFlowBLLOBJ = new WorkFlowBLL();
if (WORKFLOWDEFINITIONIDTextBox.Text != "0")
{
string message = string.Empty;
string AlertMessage = string.Empty;
string uID = Session["USER_ID"].ToString();
string pID = Session["PROJECT_ID"].ToString();
WorkFlowBO objWorkFlow = new WorkFlowBO();
objWorkFlow.WorkFlowDefID = Convert.ToInt32(WORKFLOWDEFINITIONIDTextBox.Text.ToString());
objWorkFlow.ModuleID = Convert.ToInt32(ModuleDropDownList.SelectedItem.Value.ToString().Trim());
objWorkFlow.WorkflowID = Convert.ToInt32(WorkflowItemDropDownList.SelectedItem.Value.ToString());
objWorkFlow.HigherAuthorityID = Convert.ToInt32(HightAuthDropDownList.SelectedItem.Value.ToString());
objWorkFlow.Trigger = TriggerDropDownList.SelectedItem.Value.ToString();
objWorkFlow.AfterDays = Convert.ToInt32(AfterDropDownList.SelectedItem.Value.ToString());
objWorkFlow.UserID = Convert.ToInt32(uID);
objWorkFlow.ProjectID = Convert.ToInt32(pID);
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
count = WorkFlowBLLobj.EditWorkFlowDef(objWorkFlow);
if (count == -1)
{
BindGridWorkFlowDefinition();
WORKFLOWDEFINITIONIDTextBox.Text = "0";
message = "Data updated successfully.";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
clear();
SetUpdateMode(false);
}
if (count == 1)
{
BindGridWorkFlowDefinition();
WORKFLOWDEFINITIONIDTextBox.Text = "0";
message = "Workflow Item Already Exist";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
clear();
SetUpdateMode(false);
}
}
else
{
try
{
string message = string.Empty;
string AlertMessage = string.Empty;
string uID = Session["USER_ID"].ToString();
string pID = Session["PROJECT_ID"].ToString();
WorkFlowBO objWorkFlow = new WorkFlowBO();
objWorkFlow.ModuleID = Convert.ToInt32(ModuleDropDownList.SelectedItem.Value.ToString().Trim());
objWorkFlow.WorkflowID = Convert.ToInt32(WorkflowItemDropDownList.SelectedItem.Value.ToString());
objWorkFlow.HigherAuthorityID = Convert.ToInt32(HightAuthDropDownList.SelectedItem.Value.ToString());
objWorkFlow.Trigger = TriggerDropDownList.SelectedItem.Value.ToString();
objWorkFlow.AfterDays = Convert.ToInt32(AfterDropDownList.SelectedItem.Value.ToString());
objWorkFlow.UserID = Convert.ToInt32(uID);
objWorkFlow.ProjectID = Convert.ToInt32(pID);
WorkFlowBLL WorkFlowBLLobj = new WorkFlowBLL();
count = WorkFlowBLLobj.InsertWorkFlow(objWorkFlow);
if (count == -1)
{
BindGridWorkFlowDefinition();
message = "Data saved successfully.";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
clear();
}
if (count == 1)
{
BindGridWorkFlowDefinition();
message = "Workflow Item Already Exist";
AlertMessage = "alert('" + message + "');";
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true);
clear();
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
WorkFlowBLLOBJ = null;
}
}
}
/// <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 grdWorkflowItem_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditRow")
{
ViewState["WorkFlowDefID"] = e.CommandArgument;
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
objWorkFlowBO = objWorkFlowBLL.GetWorkFlowDefByID(Convert.ToInt32(ViewState["WorkFlowDefID"]));
//Editing set the value to the respective dropDown box and textbox
if (objWorkFlowBO != null)
{
ModuleDropDownList.ClearSelection();
if (ModuleDropDownList.Items.FindByValue(objWorkFlowBO.ModuleID.ToString()) != null)
{
ModuleDropDownList.Items.FindByValue(objWorkFlowBO.ModuleID.ToString()).Selected = true;
}
getWorkfolwitemByModuleID();
WorkflowItemDropDownList.ClearSelection();
if (WorkflowItemDropDownList.Items.FindByValue(objWorkFlowBO.WorkflowID.ToString()) != null)
{
WorkflowItemDropDownList.Items.FindByValue(objWorkFlowBO.WorkflowID.ToString()).Selected = true;
}
getAllRole();
HightAuthDropDownList.ClearSelection();
if (HightAuthDropDownList.Items.FindByValue(objWorkFlowBO.HigherAuthorityID.ToString()) != null)
{
HightAuthDropDownList.Items.FindByValue(objWorkFlowBO.HigherAuthorityID.ToString()).Selected = true;
}
getLevel();
ApproverLevelDropDownList.ClearSelection();
if (ApproverLevelDropDownList.Items.FindByValue(objWorkFlowBO.ApprovalID.ToString()) != null)
{
ApproverLevelDropDownList.Items.FindByValue(objWorkFlowBO.ApprovalID.ToString()).Selected = true;
}
getLevel();
TriggerDropDownList.ClearSelection();
if (TriggerDropDownList.Items.FindByValue(objWorkFlowBO.Trigger.ToString()) != null)
{
TriggerDropDownList.Items.FindByValue(objWorkFlowBO.Trigger.ToString()).Selected = true;
}
AfterDropDownList.ClearSelection();
if (AfterDropDownList.Items.FindByValue(objWorkFlowBO.AfterDays.ToString()) != null)
{
AfterDropDownList.Items.FindByValue(objWorkFlowBO.AfterDays.ToString()).Selected = true;
}
if (HightAuthDropDownList.SelectedIndex > 0)
{
TriggerDropDownList.Enabled = true;
AfterDropDownList.Enabled = true;
}
else
{
TriggerDropDownList.Enabled = false;
AfterDropDownList.Enabled = false;
}
WORKFLOWDEFINITIONIDTextBox.Text = objWorkFlowBO.WorkFlowDefID.ToString();
SaveButton.Text = "Update";
ClearButton.Text = "Cancel";
}
SetUpdateMode(true);
}
else if (e.CommandName == "DeleteRow")
{
//Delete the record using WorkflowDefID
string message = string.Empty;
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
message = objWorkFlowBLL.DeleteWorkFlowDef(Convert.ToInt32(e.CommandArgument));
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data Deleted successfully";
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
BindGridWorkFlowDefinition();
clear();
SetUpdateMode(false);
}
else if (e.CommandName == "ClickAddApproved")
{
// ViewState["WorkFlowDefID"] = e.CommandArgument;
GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
Literal WorkflowApproverID = (Literal)row.FindControl("litWorkFlowDefID"); //Literal value avaiable in the grid
Literal LitModuleName = (Literal)row.FindControl("LitModuleName");
Literal LitWorkflowName = (Literal)row.FindControl("LitWorkflowName");
// WorkFlowDefIDTextBox.Text = WorkflowApproverID.Text;
ViewState["WorkFlowDefID"] = WorkflowApproverID.Text; //view state value assigned by the help of Literal
WorkFlowDefID(WorkflowApproverID.Text);
ApprovalTable.Visible = true; //Approver Screen Visable
ApproverTab.InnerText = "Approvers For " + LitModuleName.Text + "-" + LitWorkflowName.Text;
#region For load data to Dropen down approval
BindGrid(true, true);
if (ViewState["StatusMode"].ToString() != "ReadOnly")
{
ADDButton.Visible = true;
UpDateButton.Visible = false;
CancelButton.Visible = false;
}
WorkApproverIDTextBox.Text = "0";
WorkDefinationTextBox.Text = "0";
getAllRole();
getLevel();
ListItem lstItem = ApproverNameDropDownList.Items[0];
ApproverNameDropDownList.Items.Clear();
ApproverNameDropDownList.Items.Insert(0, lstItem);
ApproverLevelDropDownList.Enabled = true;
#endregion
BindGrid(true, true); // Calling Approval Bind Grid Data
}
}
/// <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>
/// To close batch
/// </summary>
/// <param name="HHID"></param>
/// <param name="UserId"></param>
/// <param name="BatchNo"></param>
/// <returns></returns>
public string CloseBatch(int HHID, int UserId, int BatchNo, WorkFlowBO objWorkFlow)
{
string returnResult = string.Empty;
cnn = new OracleConnection(con);
proc = "USP_TRN_CMP_CLOSE_PAYREQ_BATCH";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection.Open();
//cmd.Parameters.Add("HHID_", HHID);
cmd.Parameters.Add("CMP_BATCHNO_", BatchNo);
cmd.Parameters.Add("UPDATEDBY_", UserId);
cmd.Parameters.Add("ERRORMESSAGE_", OracleDbType.Varchar2, 100).Direction = ParameterDirection.Output;
try
{
cmd.ExecuteNonQuery();
if (cmd.Parameters["ERRORMESSAGE_"].Value != null)
{
returnResult = cmd.Parameters["ERRORMESSAGE_"].Value.ToString();
}
else
{
returnResult = string.Empty;
}
}
catch (Exception ex)
{
returnResult = string.Empty;
throw ex;
}
#region Notify Higher Authority of Batch Completion:
if (objWorkFlow != null)
{
NotificationBO objNotification = new NotificationBO();
StringBuilder sb = new StringBuilder();
if (objWorkFlow.HigherAuthorityEmailID != null)
{
string HigherAuthorityName = objWorkFlow.HigherAuthorityName;
string ProjectName = objWorkFlow.ProjectName;
string ProjectCode = objWorkFlow.ProjectCode;
sb.Append("Dear " + HigherAuthorityName + ",");
sb.Append("<br/><br/>");
sb.Append("Approval completed on " + "Batch: <a href='wisapp.uetcl.com' style='text-decoration:none'><b>" + BatchNo + "</b></a>");
sb.Append("<br/>");
sb.Append("You can now prepare the MEMO for payment processing.");
sb.Append("<br/>");
sb.Append("Follow the link to WIS for Batch Details report, and approver Comments");
sb.Append("<br/><br/>");
sb.Append("<br/><br/>");
sb.Append("<br/><br/>");
sb.Append("<br/><br/>");
sb.Append("<br/><br/>");
sb.Append("<br/><br/>");
sb.Append("___________________________________");
sb.Append("<br/><br/>");
sb.Append("Wayleaves Information System (WIS)");
objNotification.EmailID = objWorkFlow.HigherAuthorityEmailID;
objNotification.EmailSubject = "Batch: " + BatchNo + " (" + ProjectCode + " Project) - Ready for payment";
objNotification.EmailBody = sb.ToString();
(new NotificationDAL()).SendEmail(objNotification);
}
}
#endregion
return(returnResult);
}
/// <summary>
/// To Load Scrren
/// </summary>
public void ScreenLoading()
{
string CR_PreText = "Change Request For ";
string ResultValue = string.Empty;
string FormName = string.Empty;
string PAGECODE = string.Empty;
string NegotiatedAmount = string.Empty;
string emailSubject = "";
string changeRequestCode = Request.QueryString["ChangeRequestCode"];
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Request.QueryString["ProjectID"]), changeRequestCode);
if (objWorkFlowBO != null)
{
if (Request.QueryString["pageCode"] != null)
{
PageCodeTextBox.Text = Request.QueryString["pageCode"].ToString();
}
HHIDTextBox.Text = Request.QueryString["HHID"];
if (changeRequestCode == "CR-HH")
{
switch (PageCodeTextBox.Text)
{
case "HH":
FormName = CR_PreText + "Household Details of HHID " + HHIDTextBox.Text;
break;
//case "":
// FormName = CR_PreText + ""; break;
case "HH-AV":
FormName = CR_PreText + "Acreage Valution"; break;
case "HH-GOS":
FormName = CR_PreText + "Group Ownership"; break;
case "HHGMS":
FormName = CR_PreText + "Group Member"; break;
case "HHTRD":
FormName = CR_PreText + "Holder Type Details"; break;
case "HH-SA":
FormName = CR_PreText + "Services on Affected Plot"; break;
case "HH-LU":
FormName = CR_PreText + "Affected Land Users"; break;
case "HHINS":
FormName = CR_PreText + "House Hold Institute"; break;
case "HHLHH":
FormName = CR_PreText + "House Hold Land Holding"; break;
case "HHMCE":
FormName = CR_PreText + ""; break;
case "HLIOF":
FormName = CR_PreText + ""; break;
case "HLION":
FormName = CR_PreText + "Land Info Resident On"; break;
case "HH-MS":
FormName = CR_PreText + "Major Shocks"; break;
case "HHNEH":
FormName = CR_PreText + "Neighbours"; break;
case "HH-HD":
FormName = CR_PreText + "Health Disability"; break;
case "HHHIF":
FormName = CR_PreText + "Health Info"; break;
case "HH-SE":
FormName = CR_PreText + "Socio Economy"; break;
case "HHSEL":
FormName = CR_PreText + "PAP Livelihood"; break;
case "HHSBD":
FormName = CR_PreText + "Status Bank"; break;
case "HH-SC":
FormName = CR_PreText + "Social Concern"; break;
case "GRIEV":
FormName = CR_PreText + "Grievances"; break;
case "HV-CO":
FormName = CR_PreText + "Valuation Crops"; break;
case "HVCUP":
FormName = CR_PreText + "Cultural Properties"; break;
case "HVDAC":
FormName = CR_PreText + "Damaged Crops"; break;
case "HVFEN":
FormName = CR_PreText + "Fence"; break;
case "HFVAL":
FormName = CR_PreText + ""; break;
case "HV-GR":
FormName = CR_PreText + "Grave"; break;
//case "HVNPS":
// FormName = CR_PreText + ""; break; //Not Used
case "HVOFX":
FormName = CR_PreText + "Other Fixtures"; break;
case "HVPBU":
FormName = CR_PreText + "Permanent Bulding"; break;
//case "PKREV":
// FormName = CR_PreText + "Payment"; break;
//case "CDAPB":
// FormName = CR_PreText + "Email Popup"; break;
//case "CPREV":
// FormName = CR_PreText + "Compensation Package Review"; break;
//case "CRFND":
// FormName = CR_PreText + "Payment Request"; break;
//case "CREND":
// FormName = CR_PreText + "Payment Verification"; break;
//case "RTA":
// FormName = CR_PreText + "Root Approval"; break;
//case "DATAV":
// FormName = CR_PreText + "Data Verification"; break;
//case "":
// FormName = CR_PreText + ""; break;
default:
FormName = CR_PreText + "HouseHolD";
break;
}
}
else if (changeRequestCode == "NEG")
{
FormName = "Change Request for Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGC")
{
FormName = "Change Request for Crops Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGL")
{
FormName = "Change Request for Land Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGF")
{
FormName = "Change Request for Fixtures Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGR")
{
FormName = "Change Request for Replacement Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGD")
{
FormName = "Change Request for Damaged crop Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (changeRequestCode == "NEGCU")
{
FormName = "Change Request for Cultural Property Negotiated Amount for HHID " + HHIDTextBox.Text;
NegotiatedAmount = Request.QueryString["NegotiatedAmount"].ToString();
}
else if (Request.QueryString["ChangeRequestCode"] == "RFPRI")
{
FormName = "Request for Printing the Package Document for HHID " + HHIDTextBox.Text;
}
else
{
FormName = objWorkFlowBO.EmailSubject;
}
if (Request.QueryString["ChangeRequestCode"] == "PAYRQ")
{
if (Request.QueryString["BatchNo"] != null)
{
ViewState["BatchNo"] = Request.QueryString["BatchNo"];
}
}
else if (Request.QueryString["ChangeRequestCode"] == UtilBO.WorkflowGrievances)
{
if (Request.QueryString["GrievanceID"] != null)
{
ViewState["GrievanceID"] = Request.QueryString["GrievanceID"];
}
else
{
ViewState["GrievanceID"] = "0";
}
}
emailSubject = FormName;
Master.PageHeader = FormName;
EmailToTextBox.Text = objWorkFlowBO.EmailID;
EmailSubjectTextBox.Text = emailSubject;
WorkFlowApproverIDTextBox.Text = objWorkFlowBO.WorkFlowApproverID.ToString();
StatusIDTextBox.Text = "3";
ApproverUserIdTextBox.Text = objWorkFlowBO.ApproverUserID.ToString();
WorkFlowDefinitionIDTextBox.Text = objWorkFlowBO.WorkFlowDefinitionID.ToString();
ProjectCodeTextBox.Text = objWorkFlowBO.ProjectCode.ToString();
ProjectNameTextBox.Text = objWorkFlowBO.ProjectName.ToString();
//For DIsplaying in TextBox
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("Dear Sir / Madam,");
sb.Append(System.Environment.NewLine);
sb.Append(objWorkFlowBO.EmailBody);
sb.Append(System.Environment.NewLine);
if (Request.QueryString["pageCode"] == "NEG")
{
sb.Append(FormName); sb.Append(" Negotiated Amount : ");
sb.Append(NegotiatedAmount);
}
else if (Request.QueryString["pageCode"].ToString().Length >= 3 && Request.QueryString["pageCode"].Substring(0, 3) == "NEG")
{
sb.Append(FormName); sb.Append(" Negotiated Amount : ");
sb.Append(NegotiatedAmount);
}
sb.Append(System.Environment.NewLine);
sb.Append("Project Code : " + objWorkFlowBO.ProjectCode);
sb.Append(System.Environment.NewLine);
sb.Append("Project Name : " + objWorkFlowBO.ProjectName);
sb.Append(System.Environment.NewLine);
sb.Append(" Thanks and Regards");
sb.Append(System.Environment.NewLine);
sb.Append("WIS - UETCL Team");
string InputEmail = sb.ToString();
string mailContent = InputEmail;
mailContent = mailContent.Replace("\\n", "<br>");
EmailBodyTextBox.Text = mailContent;
}
else
{
if (Request.QueryString["ChangeRequestCode"] == "NEG")
{
ClientScript.RegisterStartupScript(this.GetType(), "EMAILPOPUP", "AfterNogAmount();", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "Aftersend", "Aftersend();", true);
}
}
}
/// <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);
}
/// <summary>
/// To load controls in the grid
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void grdProjects_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
int ApprovalStatus = 0;
DateTime projStartDate = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "ProjectStartDate"));
if (projStartDate != DateTime.MinValue)
{
((Literal)e.Row.FindControl("litProjectStartDate")).Text = projStartDate.ToString(UtilBO.DateFormat);
}
DateTime projEndDate = Convert.ToDateTime(DataBinder.Eval(e.Row.DataItem, "ProjectEndDate"));
if (projEndDate != DateTime.MinValue)
{
((Literal)e.Row.FindControl("litProjectEndDate")).Text = projEndDate.ToString(UtilBO.DateFormat);
}
LinkButton lnkDataVerification = (LinkButton)e.Row.FindControl("lnkDataVerification");
LinkButton lnkFreeze = (LinkButton)e.Row.FindControl("lnkFreeze");
lnkFreeze.Visible = false;
Literal litProjectID = ((Literal)e.Row.FindControl("litProjectID"));
Literal litDataVerification = ((Literal)e.Row.FindControl("litDataVerification"));
if (litProjectID != null)
{
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
string ChangeRequestCode = UtilBO.WorkflowDataVerification;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(litProjectID.Text), ChangeRequestCode);
if (objWorkFlowBO == null)
{
lnkFreeze.Visible = false;
lnkDataVerification.Visible = false;
litDataVerification.Visible = true;
litDataVerification.Text = "Define Approver";
}
else
{
//ApprovalStatus = getApprrequtStatusDataVerification(Convert.ToInt32(litProjectID.Text));
ApprovalStatus = totalcountapproval(Convert.ToInt32(litProjectID.Text));
if (ApprovalStatus == 1)
{
lnkFreeze.Visible = true;
lnkDataVerification.Visible = false;
litDataVerification.Visible = false;
litDataVerification.Text = string.Empty;
//lnkFreeze.Visible = true;
//lnkDataVerification.Visible = false;
//litDataVerification.Visible = false;
}
else if (ApprovalStatus == 2)
{
lnkFreeze.Visible = false;
lnkDataVerification.Visible = true;
litDataVerification.Visible = false;
//litDataVerification.Text = "Approval Pending";
}
else if (ApprovalStatus == 3)
{
lnkFreeze.Visible = false;
lnkDataVerification.Visible = false;
litDataVerification.Visible = false;
}
}
}
//lnkFreeze.Visible = false;
string frozen = DataBinder.Eval(e.Row.DataItem, "Frozen").ToString();
if (frozen == "Y")
{
((LinkButton)e.Row.FindControl("lnkFreeze")).Visible = false;
//((Literal)e.Row.FindControl("litFrozen")).Visible = true;//Under Testing
lnkDataVerification.Visible = false;
litDataVerification.Text = string.Empty;
litDataVerification.Visible = false;
((LinkButton)e.Row.FindControl("lnkFrozen")).Visible = true; //Under Testing
((Panel)e.Row.FindControl("pnlUnfreeze")).Visible = true; //Under Testing
}
else
{
((Panel)e.Row.FindControl("pnlUnfreeze")).Visible = false; //Under Testing
}
int routeCount = Convert.ToInt32(DataBinder.Eval(e.Row.DataItem, "RouteCount"));
if (routeCount == 0)
{
((System.Web.UI.HtmlControls.HtmlAnchor)e.Row.FindControl("lnkRouteMap")).Visible = false;
}
else
{
((System.Web.UI.HtmlControls.HtmlAnchor)e.Row.FindControl("lnkRouteMap")).Attributes.Add("onclick", string.Format("OpenRouteMap({0});", DataBinder.Eval(e.Row.DataItem, "ProjectID").ToString()));
}
}
}
/// <summary>
/// Approval Status Checklist
/// </summary>
/// <param name="objProjectRoute"></param>
/// <returns></returns>
public WorkFlowList ApprovalStatuschecklist(WorkFlowBO objProjectRoute)
{
WorkflowDAL ProjectRouteDALObj = new WorkflowDAL();
return(ProjectRouteDALObj.ApprovalStatuschecklist(objProjectRoute));
}
/// <summary>
/// To Get Total Count Approval
/// </summary>
/// <param name="objProjectRoute"></param>
/// <returns></returns>
public WorkFlowList getTotalcountapproval(WorkFlowBO objProjectRoute)
{
WorkflowDAL ProjectRouteDALObj = new WorkflowDAL();
return(ProjectRouteDALObj.getTotalcountapproval(objProjectRoute));
}
