public void checkApprovalExitOrNot()
{
#region Enable ChangeRequest Button
StatusInstitution.Text = "";
StatusInstitution.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, "HHINS");
lnkHHInstitution.Attributes.Add("onclick", paramChangeRequest);
lnkHHInstitution.Visible = true;
}
else
{
lnkHHInstitution.Visible = false;
}
#endregion
getApprrequtStatusInstitution();
}
/// <summary>
/// checkApprovalExitOrNot
/// </summary>
public void checkApprovalExitOrNot()
{
#region Enable ChangeRequest Button
StatusFence.Text = "";
StatusFence.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, "HVFEN");
lnkFence.Attributes.Add("onclick", paramChangeRequest);
lnkFence.Visible = true;
}
else
{
lnkFence.Visible = false;
}
#endregion
getApprrequtStatusDamageCrops();
}
/// <summary>
/// Check Approval Exit Or Not
/// </summary>
public void checkApprovalExitOrNot()
{
#region Enable ChangeRequest Button
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 = Convert.ToInt32(Session["HH_ID"]);
if (objWorkFlowBO != null)
{
btnApproval.Visible = true;
}
else
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Approver is not Defined');", true);
btnApproval.Visible = false;
}
#endregion
}
/// <summary>
/// check For Approver Exists or Not
/// </summary>
/// <returns></returns>
public bool checkForApprover()
{
string NegotiatedAmount = string.Empty;
//for checking Change Request Approver Exit or not
WorkFlowBO objWorkFlowBO = new WorkFlowBO();
WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
bool approverExists = false;
string ChangeRequestCode = UtilBO.WorkflowPaymentRequest;
objWorkFlowBO = objWorkFlowBLL.getWOrkFlowApprovalID(Convert.ToInt32(Session["PROJECT_ID"]), ChangeRequestCode);
if (objWorkFlowBO != null)
{
approverExists = true;
//EnableSubmitButton(true);
//if (hdnPendingRequestCount.Value != null)
//{
// int CountPendingRecords = Convert.ToInt32(hdnPendingRequestCount.Value);
// if (CountPendingRecords == 0)
// EnableSubmitButton(false);
// else
// EnableSubmitButton(true);
//}
}
else
{
EnableSubmitButton(false);
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Approver is not defined')", true);
}
return(approverExists);
}
/// <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>
/// 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>
/// 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>
/// 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 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);
}
}
}
