public void ChangeRequestStatusLNDUsers()
{
int Count;
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "HH-LU";
objHouseHold.Workflowcode = UtilBO.WorkflowChangeRequestHH;
Count = objHouseHoldBLL.ChangeRequestStatus(objHouseHold);
}
/// <summary>
/// getApprrequtStatusCulturProperties
/// </summary>
public void getApprrequtStatusCulturProperties()
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "HVCUP";
objHouseHold.Workflowcode = UtilBO.WorkflowChangeRequestHH;
objHouseHold = objHouseHoldBLL.ApprovalChangerequestStatus(objHouseHold);
if ((objHouseHold) != null)
{
if (objHouseHold.ApproverStatus == 3)
{
lnkValuationCulturProperties.Visible = false;
btnSave.Visible = false;
btnClear.Visible = false;
grdCultureProperties.Columns[grdCultureProperties.Columns.Count - 2].Visible = false;
grdCultureProperties.Columns[grdCultureProperties.Columns.Count - 4].Visible = false;
StatusCulturProperties.Visible = true;
StatusCulturProperties.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 2)
{
lnkValuationCulturProperties.Visible = true;
btnSave.Visible = false;
btnClear.Visible = false;
grdCultureProperties.Columns[grdCultureProperties.Columns.Count - 2].Visible = false;
grdCultureProperties.Columns[grdCultureProperties.Columns.Count - 4].Visible = false;
StatusCulturProperties.Visible = false;
StatusCulturProperties.Text = string.Empty;
}
if (objHouseHold.ApproverStatus == 1)
{
lnkValuationCulturProperties.Visible = false;
btnSave.Visible = true;
btnClear.Visible = true;
grdCultureProperties.Columns[grdCultureProperties.Columns.Count - 2].Visible = true;
grdCultureProperties.Columns[grdCultureProperties.Columns.Count - 4].Visible = true;
StatusCulturProperties.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
}
}
/// <summary>
/// to get the Status of the Approvar Bank Details
/// </summary>
public void getApprrequtStatusBankDetial()
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "HHSBD";
objHouseHold.Workflowcode = UtilBO.WorkflowChangeRequestHH;
objHouseHold = objHouseHoldBLL.ApprovalChangerequestStatus(objHouseHold);
if ((objHouseHold) != null)
{
if (objHouseHold.ApproverStatus == 3)
{
lnkPAPLivehoodBNKDet.Visible = false;
btnSaveBank.Visible = false;
btnClearBank.Visible = false;
StatusPAPLivehood1.Visible = true;
StatusPAPLivehood1.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 2)
{
lnkPAPLivehoodBNKDet.Visible = true;
btnSaveBank.Visible = false;
btnClearBank.Visible = false;
StatusPAPLivehood1.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 1)
{
lnkPAPLivehoodBNKDet.Visible = false;
StatusPAPLivehood1.Visible = false;
btnSaveBank.Visible = false;
btnClearBank.Visible = false;
}
}
}
/// <summary>
/// to get the HouseHoldData from the database
/// </summary>
private void GetHouseHoldDtlData()
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = objHouseHoldBLL.GetHouseHoldData(Convert.ToInt32(Session["HH_ID"]));
if (objHouseHold != null)
{
if (objHouseHold.DateofBirth.Trim() != "")
{
hfPapDOB.Value = Convert.ToDateTime(objHouseHold.DateofBirth).ToString(UtilBO.DateFormat);
}
else
{
hfPapDOB.Value = "false";
}
}
}
/// <summary>
/// To Check Is Resident
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public bool IsResident(int householdID)
{
bool resident = false;
PAP_HouseholdBO objHouseholdBO = (new PAP_HouseholdDAL()).GetHouseHoldData(householdID);
if (objHouseholdBO != null)
{
if (objHouseholdBO.Isresident.ToUpper() == "YES")
{
resident = true;
}
}
objHouseholdBO = null;
return(resident);
}
/// <summary>
/// to get the status of the Approvar Health Disability
/// </summary>
public void getApprrequtStatusHealthDisability()
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "HH-HD";
objHouseHold.Workflowcode = UtilBO.WorkflowChangeRequestHH;
objHouseHold = objHouseHoldBLL.ApprovalChangerequestStatus(objHouseHold);
if ((objHouseHold) != null)
{
if (objHouseHold.ApproverStatus == 3)
{
lnkPAPHealthDisability.Visible = false;
btnSaveDisability.Visible = false;
btnClearDisability.Visible = false;
StatusPAPHealthDisability.Visible = true;
StatusPAPHealthDisability.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 2)
{
lnkPAPHealthDisability.Visible = true;
btnSaveDisability.Visible = false;
btnClearDisability.Visible = false;
StatusPAPHealthDisability.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 1)
{
lnkPAPHealthDisability.Visible = false;
btnSaveDisability.Visible = true;
btnClearDisability.Visible = true;
grdDisabilities.Columns[grdDisabilities.Columns.Count - 1].Visible = true;
grdDisabilities.Columns[grdDisabilities.Columns.Count - 2].Visible = true;
grdDisabilities.Columns[grdDisabilities.Columns.Count - 3].Visible = true;
StatusPAPHealthDisability.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
}
}
private void GetRelevantDetails()
{
int ProjectID = Convert.ToInt32(Request.QueryString["ProjectID"]);
int HHID = Convert.ToInt32(Request.QueryString["HHID"]);
ProjectBLL ProjectBLL = new ProjectBLL();
PAP_HouseholdBLL PAP_HouseholdBLL = new PAP_HouseholdBLL();
ProjectBO ProjectBO = new ProjectBO();
PAP_HouseholdBO PAP_HouseholdBO = new PAP_HouseholdBO();
ProjectBO = ProjectBLL.GetProjectByProjectID(ProjectID);
PAP_HouseholdBO = PAP_HouseholdBLL.GetHouseHoldData(HHID);
txtHHID.Text = PAP_HouseholdBO.HhId.ToString();
txtPapName.Text = PAP_HouseholdBO.PapName.ToString();
txtProjectName.Text = ProjectBO.ProjectName.ToString();
}
/// <summary>
/// to get the status of the Aprovar request for the neighbour
/// </summary>
public void getApprrequtStatusNeighbours()
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "HHNEH";
objHouseHold.Workflowcode = UtilBO.WorkflowChangeRequestHH;
objHouseHold = objHouseHoldBLL.ApprovalChangerequestStatus(objHouseHold);
if ((objHouseHold) != null)
{
if (objHouseHold.ApproverStatus == 3)
{
lnkNeighbours.Visible = false;
btnSave.Visible = false;
btnClear.Visible = false;
StatusNeighbours.Visible = true;
StatusNeighbours.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 2)
{
lnkNeighbours.Visible = true;
btnSave.Visible = false;
btnClear.Visible = false;
StatusNeighbours.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 1)
{
lnkNeighbours.Visible = false;
btnSave.Visible = true;
btnClear.Visible = true;
grdNeighbor.Columns[6].Visible = true;
grdNeighbor.Columns[7].Visible = true;
StatusNeighbours.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
}
}
/// <summary>
/// to get the Approvar request Sattus Land Holdings
/// </summary>
public void getApprrequtStatusLandHoldings()
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "HHLHH";
objHouseHold.Workflowcode = UtilBO.WorkflowChangeRequestHH;
objHouseHold = objHouseHoldBLL.ApprovalChangerequestStatus(objHouseHold);
if ((objHouseHold) != null)
{
if (objHouseHold.ApproverStatus == 3)
{
lnkLandHoldings.Visible = false;
btn_SaveRes.Visible = false;
btn_ClearRes.Visible = false;
StatusLandHoldings.Visible = true;
StatusLandHoldings.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 2)
{
lnkLandHoldings.Visible = true;
btn_SaveRes.Visible = false;
btn_ClearRes.Visible = false;
StatusLandHoldings.Visible = false;
StatusLandHoldings.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 1)
{
lnkLandHoldings.Visible = false;
btn_SaveRes.Visible = true;
btn_ClearRes.Visible = true;
grdLandInfoRespondents.Columns[12].Visible = true;
grdLandInfoRespondents.Columns[13].Visible = true;
StatusLandHoldings.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
}
}
public void getApprrequtStatusServes()
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "HH-SA";
objHouseHold.Workflowcode = UtilBO.WorkflowChangeRequestHH;
objHouseHold = objHouseHoldBLL.ApprovalChangerequestStatus(objHouseHold);
if ((objHouseHold) != null)
{
if (objHouseHold.ApproverStatus == 3)
{
lnkServiceAffected.Visible = false;
btnClearService.Visible = false;
btnSaveService.Visible = false;
StatusService.Visible = true;
StatusService.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 2)
{
lnkServiceAffected.Visible = true;
btnClearService.Visible = false;
btnSaveService.Visible = false;
StatusService.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 1)
{
lnkServiceAffected.Visible = false;
btnClearService.Visible = true;
btnSaveService.Visible = true;
grdAffectedLandUsers.Columns[grdAffectedLandUsers.Columns.Count - 1].Visible = true;
grdAffectedLandUsers.Columns[grdAffectedLandUsers.Columns.Count - 2].Visible = true;
StatusService.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
}
}
/// <summary>
/// Get the Pap Details For Tooltip
/// </summary>
/// <returns></returns>
public string GetPapData()
{
string sPapdata = "";
int HHID = 0;
if (Request.QueryString["HHID"] != null)
{
HHID = Convert.ToInt32(Request.QueryString["HHID"].ToString());
}
if (HHID > 0)
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHousehold = objHouseHoldBLL.GetHouseHoldData(HHID);
if (objHousehold != null)
{
ProjectBLL objProjectBLL = new ProjectBLL();
ProjectBO objProject = objProjectBLL.GetProjectByProjectID(objHousehold.ProjectedId);
sPapdata += "<b>PROJECT CODE:</b> " + objProject.ProjectCode;
sPapdata += "<br /><b>PAP UID:</b> " + objHousehold.Pap_UId;
sPapdata += "<br /><b>HHID:</b> " + objHousehold.HhId;
if (objHousehold.PapName == null)
{
sPapdata += "<br /><b>PAP Name:</b> " + objHousehold.Surname + objHousehold.Firstname;
}
else
{
sPapdata += "<br /><b>PAP Name:</b> " + objHousehold.PapName;
}
sPapdata += "<br /><b>Plot Reference:</b> " + objHousehold.PlotReference;
sPapdata += "<br /><b>Designation:</b> " + objHousehold.Designation;
sPapdata += "<br /><b>District:</b> " + objHousehold.District;
sPapdata += "<br /><b>County:</b> " + objHousehold.County;
sPapdata += "<br /><b>SubCounty:</b> " + objHousehold.SubCounty;
sPapdata += "<br /><b>Village:</b> " + objHousehold.Village;
sPapdata += "<br /><b>Parish:</b> " + objHousehold.Parish;
sPapdata += "<br /><b>Rightofway (Acres):</b> " + objHousehold.Rightofway;
sPapdata += "<br /><b>Wayleaves (Acres):</b> " + objHousehold.Wayleaves;
}
}
return(sPapdata);
}
/// <summary>
/// to Check Change Request Status
/// </summary>
public void getApprrequtStatusITML()
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "IT-ML";
objHouseHold.Workflowcode = UtilBO.WorkflowChangeRequestHH;
objHouseHold = objHouseHoldBLL.ApprovalChangerequestStatus(objHouseHold);
if ((objHouseHold) != null)
{
if (objHouseHold.ApproverStatus == 3)
{
lnkITML.Visible = false;
btn_SavePrivate.Visible = false;
btn_Clear.Visible = false;
StatuslnkITML.Visible = true;
StatuslnkITML.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 2)
{
lnkITML.Visible = true;
btn_SavePrivate.Visible = false;
btn_Clear.Visible = false;
StatuslnkITML.Visible = false;
StatuslnkITML.Text = string.Empty;
}
if (objHouseHold.ApproverStatus == 1)
{
lnkITML.Visible = false;
btn_SavePrivate.Visible = true;
btn_Clear.Visible = true;
StatuslnkITML.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
}
}
public void getApprrequtStatusGroupMemberShip()
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "HHGMS";
objHouseHold.Workflowcode = UtilBO.WorkflowChangeRequestHH;
objHouseHold = objHouseHoldBLL.ApprovalChangerequestStatus(objHouseHold);
if ((objHouseHold) != null)
{
if (objHouseHold.ApproverStatus == 3)
{
lnkGroupMenber.Visible = false;
btnSavemember.Visible = false;
btnClearMember.Visible = false;
StatusGroupMenber.Visible = true;
StatusGroupMenber.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 2)
{
lnkGroupMenber.Visible = true;
btnSavemember.Visible = false;
btnClearMember.Visible = false;
StatusGroupMenber.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
if (objHouseHold.ApproverStatus == 1)
{
lnkGroupMenber.Visible = false;
btnSavemember.Visible = true;
btnClearMember.Visible = true;
StatusGroupMenber.Visible = false;
//StatusLabel.Text = "Pending Approval";
}
}
}
public System.IO.MemoryStream ShowPAPImage(int householdID)
{
try
{
PAP_HouseholdBO objPAP = (new PAP_HouseholdBLL()).GetPAPPhoto(householdID);
if (objPAP != null)
{
return(new System.IO.MemoryStream(objPAP.Photo));
}
else
{
return(null);
}
}
catch (Exception ex)
{
//throw ex;
return(null);
}
}
/// <summary>
/// get Approval Request Status Pakage Payment
/// </summary>
public void getPackageReviewStatus()
{
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "CPREV";
objHouseHold.Workflowcode = UtilBO.WorkflowPackageReview;
objHouseHold = objHouseHoldBLL.ApprovalChangerequestStatus(objHouseHold);
if ((objHouseHold) != null)
{
if (objHouseHold.ApproverStatus == 3 || objHouseHold.ApproverStatus == 2)
{
//PENDING
pnlPaymentReqInfo.Visible = false;
itemCompPackageStatus.Style.Remove("display");
lblCompPackageStatus.Text = "Pending Package Review";
DisableAllCheckBox();
}
else if (objHouseHold.ApproverStatus == 1)
{
//APPROVED
pnlPaymentReqInfo.Visible = true;
lblCompPackageStatus.Text = string.Empty;
}
}
else
{
pnlPaymentReqInfo.Visible = false;
itemCompPackageStatus.Style.Remove("display");
lblCompPackageStatus.Text = "Pending Package Review";
DisableAllCheckBox();
}
}
/// <summary>
/// get ApprrequtStatusDataVerification
/// </summary>
/// <param name="ProjectId"></param>
/// <returns></returns>
public int getApprrequtStatusDataVerification(int ProjectId)
{
int ApprovalStatus = 0;
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = ProjectId;
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "DATAV";
objHouseHold.Workflowcode = UtilBO.WorkflowDataVerification;
objHouseHold = objHouseHoldBLL.ApprovalChangerequestStatus(objHouseHold);
if ((objHouseHold) != null)
{
if (objHouseHold.ApproverStatus == 3)
{
ApprovalStatus = 3;
}
if (objHouseHold.ApproverStatus == 2)
{
ApprovalStatus = 2;
}
if (objHouseHold.ApproverStatus == 1)
{
ApprovalStatus = 1;
}
}
else
{
ApprovalStatus = 0;
}
return(ApprovalStatus);
}
/// <summary>
/// TO update PAP data to database
/// </summary>
/// <param name="objHouseholdPAP"></param>
/// <returns></returns>
public string UpdatePAP(PAP_HouseholdBO objHouseholdPAP)
{
return((new AddPAPDAL()).UpdatePAP(objHouseholdPAP));
}
/// <summary>
/// To Change Request Status
/// </summary>
/// <param name="objHouseHold"></param>
/// <returns></returns>
public int ChangeRequestStatus(PAP_HouseholdBO objHouseHold)
{
PAP_HouseholdDAL objHouseHOldDAL = new PAP_HouseholdDAL();
return(objHouseHOldDAL.ChangeRequestStatus(objHouseHold));
}
public int GetHousaeHold(PAP_HouseholdBO objPAPhh, string landStatus)
{
PAP_HouseholdDAL objHouseHOldDAL = new PAP_HouseholdDAL();
return(objHouseHOldDAL.GetHousaeHold(objPAPhh, landStatus));
}
/// <summary>
/// to get the Instruction Data from the database
/// </summary>
private void GetInstContactData()
{
int HHID = Convert.ToInt32(Session["HH_ID"]);
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = objHouseHoldBLL.GetHouseHoldData(HHID);
if (objHouseHold != null)
{
txtHouseHoldID.Text = Convert.ToString(objHouseHold.HhId);
txtName.Text = Convert.ToString(objHouseHold.InstitutionName);
txtPlots.Text = Convert.ToString(objHouseHold.Noofplots);
txtPlotReference.Text = Convert.ToString(objHouseHold.PlotReference);
txtSurname.Text = Convert.ToString(objHouseHold.Surname);
txtfirstname.Text = Convert.ToString(objHouseHold.Firstname);
txtOthername.Text = Convert.ToString(objHouseHold.Othername);
//Ediwn: 27SEP2016
txtFullname.Text = txtSurname.Text + " " + txtfirstname.Text + " " + txtOthername.Text;
txtPapUid.Text = Convert.ToString(objHouseHold.Papuid);
if (objHouseHold.CapturedDate.Trim() != "")
{
dpCapturedDate.Text = Convert.ToDateTime(objHouseHold.CapturedDate).ToString(UtilBO.DateFormat);
}
txtCapturedBy.Text = Convert.ToString(objHouseHold.CapturedBy);
ddlGouAllowance.ClearSelection();
if (ddlGouAllowance.Items.FindByValue(objHouseHold.GouStatus.ToString()) != null)
{
ddlGouAllowance.Items.FindByValue(objHouseHold.GouStatus.ToString()).Selected = true;
}
ddlUnderTakingPeriod.ClearSelection();
if (ddlUnderTakingPeriod.Items.FindByValue(objHouseHold.UnderTakingPeriod.ToString()) != null)
{
ddlUnderTakingPeriod.Items.FindByValue(objHouseHold.UnderTakingPeriod.ToString()).Selected = true;
}
rdlResident.ClearSelection();
if (objHouseHold.Isresident == "No")
{
rdlResident.Items[1].Selected = true;
}
else
{
rdlResident.Items[0].Selected = true;
}
ddloptionGroup.SelectedValue = Convert.ToString(objHouseHold.OptiongroupId);
ddlGender.ClearSelection();
if (ddlGender.Items.FindByValue(objHouseHold.Sex) != null)
{
ddlGender.Items.FindByValue(objHouseHold.Sex).Selected = true;
}
if (objHouseHold.DateofBirth.Trim() != "")
{
dpDateofBirth.Text = Convert.ToDateTime(objHouseHold.DateofBirth).ToString(UtilBO.DateFormat);
}
ddlDistrict.ClearSelection();
if (ddlDistrict.Items.FindByText(Convert.ToString(objHouseHold.District).ToUpper()) != null)
{
ddlDistrict.Items.FindByText(Convert.ToString(objHouseHold.District).ToUpper()).Selected = true;
}
if (ddlDistrict.SelectedIndex > 0)
{
BindCounties(ddlDistrict.SelectedItem.Value, ddlCounty);
if (Convert.ToString(objHouseHold.County) != "")
{
ddlCounty.ClearSelection();
if (ddlCounty.Items.FindByText(Convert.ToString(objHouseHold.County).ToUpper()) != null)
{
ddlCounty.Items.FindByText(Convert.ToString(objHouseHold.County).ToUpper()).Selected = true;
}
}
}
if (ddlCounty.SelectedIndex > 0)
{
BindSubCounties(ddlCounty.SelectedItem.Value, ddlSubCounty);
if (Convert.ToString(objHouseHold.SubCounty) != "")
{
ddlSubCounty.ClearSelection();
if (ddlSubCounty.Items.FindByText(Convert.ToString(objHouseHold.SubCounty).ToUpper()) != null)
{
ddlSubCounty.Items.FindByText(Convert.ToString(objHouseHold.SubCounty).ToUpper()).Selected = true;
}
}
}
if (ddlSubCounty.SelectedIndex > 0)
{
BindVillages(ddlSubCounty.SelectedItem.Value, ddlVillage);
if (Convert.ToString(objHouseHold.Village) != "")
{
ddlVillage.ClearSelection();
if (ddlVillage.Items.FindByText(Convert.ToString(objHouseHold.Village).ToUpper()) != null)
{
ddlVillage.Items.FindByText(Convert.ToString(objHouseHold.Village).ToUpper()).Selected = true;
}
}
BindParish(ddlSubCounty.SelectedItem.Value, ddlParish);
if (Convert.ToString(objHouseHold.Village) != "")
{
ddlParish.ClearSelection();
if (ddlParish.Items.FindByText(Convert.ToString(objHouseHold.Parish).ToUpper()) != null)
{
ddlParish.Items.FindByText(Convert.ToString(objHouseHold.Parish).ToUpper()).Selected = true;
}
}
}
PAP_InstitutionBLL objInstitutionBLL = new PAP_InstitutionBLL();
PAP_InstitutionList objPAP_InstitutionList = objInstitutionBLL.GetInstContactByHHID(HHID);
if (objPAP_InstitutionList.Count > 0)
{
ddlPosition.ClearSelection();
ddlPosition.SelectedValue = (Convert.ToString(objPAP_InstitutionList[0].POSITIONID));
ddlCPDistrict.ClearSelection();
if (ddlCPDistrict.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_DISTRICT).ToUpper()) != null)
{
ddlCPDistrict.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_DISTRICT).ToUpper()).Selected = true;
}
if (ddlCPDistrict.SelectedIndex > 0)
{
BindCounties(ddlCPDistrict.SelectedItem.Value, ddlCPCounty);
if (Convert.ToString(objHouseHold.County) != "")
{
ddlCPCounty.ClearSelection();
if (ddlCPCounty.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_COUNTY).ToUpper()) != null)
{
ddlCPCounty.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_COUNTY).ToUpper()).Selected = true;
}
}
}
if (ddlCPCounty.SelectedIndex > 0)
{
BindSubCounties(ddlCPCounty.SelectedItem.Value, ddlCPSubCounty);
uplCPSubCounty.Update();
if (Convert.ToString(objHouseHold.SubCounty) != "")
{
ddlCPSubCounty.ClearSelection();
if (ddlCPSubCounty.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_SUBCOUNTY).ToUpper()) != null)
{
ddlCPSubCounty.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_SUBCOUNTY).ToUpper()).Selected = true;
}
}
}
if (ddlCPSubCounty.SelectedIndex > 0)
{
BindVillages(ddlCPSubCounty.SelectedItem.Value, ddlCPVillage);
uplCPVillage.Update();
if (Convert.ToString(objHouseHold.Village) != "")
{
ddlCPVillage.ClearSelection();
if (ddlCPVillage.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_VILLAGE).ToUpper()) != null)
{
ddlCPVillage.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_VILLAGE).ToUpper()).Selected = true;
}
}
BindParish(ddlCPSubCounty.SelectedItem.Value, ddlCPParish);
uplCPParish.Update();
if (Convert.ToString(objHouseHold.Village) != "")
{
ddlCPParish.ClearSelection();
if (ddlCPParish.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_PARISH).ToUpper()) != null)
{
ddlCPParish.Items.FindByText(Convert.ToString(objPAP_InstitutionList[0].CONT_PARISH).ToUpper()).Selected = true;
}
}
}
txtTelephoneNo1.Text = Convert.ToString(objPAP_InstitutionList[0].CONTACTPHONE1);
txtTelephoneNo2.Text = Convert.ToString(objPAP_InstitutionList[0].CONTACTPHONE2);
}
getImage(HHID);
//imgPAPPhoto.ImageUrl = "~/ShowImage.ashx?photoModule=PAP&perStuID=0&id=" + HHID.ToString();
}
}
/// <summary>
/// To Update HouseHold Details
/// </summary>
/// <param name="objHousehold"></param>
/// <returns></returns>
public string UpdateHouseHoldDetails(PAP_HouseholdBO objHousehold)
{
PAP_HouseholdDAL objHouseHoldDAL = new PAP_HouseholdDAL();
return(objHouseHoldDAL.UpdateHouseHoldDetails(objHousehold));
}
/// <summary>
/// Set Attributes to Link buttons
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void rptDOCitem_ItemDataBound(object sender, RepeaterItemEventArgs e)
{
if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem)
{
string Mode = string.Empty;
string PageCode = string.Empty;
documentCode = Convert.ToString(DataBinder.Eval(e.Item.DataItem, "PKGDocumentCode"));
System.Web.UI.HtmlControls.HtmlAnchor lnkViewPkgItem = (System.Web.UI.HtmlControls.HtmlAnchor)e.Item.FindControl("lnkViewPkgItem");
if (Request.QueryString["Mode"] != null)
{
Mode = Request.QueryString["Mode"].ToString();
}
if (Request.QueryString["PageCode"] != null)
{
PageCode = Request.QueryString["PageCode"].ToString();
}
if (Mode == "Readonly")
{
int ApprovalLevel = 0;
ApprovalLevel = Convert.ToInt32(Request.QueryString["ApprovalLevel"].ToString());
lnkViewPkgItem.Attributes.Add("onclick", string.Format("OpenApprovalReport('{0}',{1},'{2}',{3},'{4}');", documentCode, Convert.ToInt32(Session["HH_ID"].ToString()), "Approval", ApprovalLevel, PageCode));
}
else
{
lnkViewPkgItem.Attributes.Add("onclick", string.Format("OpenReport('{0}',{1});", documentCode, Convert.ToInt32(Session["HH_ID"].ToString())));
}
System.Web.UI.HtmlControls.HtmlAnchor LnkprintApproved = (System.Web.UI.HtmlControls.HtmlAnchor)e.Item.FindControl("LnkprintApproved");
LnkprintApproved.Attributes.Add("onclick", string.Format("OpenPrintReport('{0}',{1});", documentCode, Convert.ToInt32(Session["HH_ID"].ToString())));
LnkprintApproved.Visible = false;
#region for Approval Task
System.Web.UI.HtmlControls.HtmlAnchor lnkApprovalTAsk = (System.Web.UI.HtmlControls.HtmlAnchor)e.Item.FindControl("lnkApprovalTAsk");
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = new PAP_HouseholdBO();
objHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int householdID = Convert.ToInt32(Session["HH_ID"]);
objHouseHold.HhId = householdID;
objHouseHold.PageCode = "CPREV";
objHouseHold.Workflowcode = UtilBO.WorkflowPackageReview;
objHouseHold = objHouseHoldBLL.ApprovalChangerequestStatus(objHouseHold);
//int countResult = totalcountapproval();
if (objHouseHold != null)
{
if (objHouseHold.ApproverStatus == 3) //(objHouseHold.ApproverStatus == 3)
{ //PENDING
lnkApprovalTAsk.Visible = false;
LnkprintApproved.Visible = false;
}
if (objHouseHold.ApproverStatus == 2)// (objHouseHold.ApproverStatus == 2)
{
//DECLINED
lnkApprovalTAsk.Visible = false;
LnkprintApproved.Visible = false;
}
if (objHouseHold.ApproverStatus == 1)// (objHouseHold.ApproverStatus == 1)
{
//APPROVED
lnkApprovalTAsk.Visible = false;
LnkprintApproved.Visible = true;
}
//if (countResult == 0 || countResult == 3)
//{
// try
// {
// WorkFlowBO objWorkFlowBO = new WorkFlowBO();
// WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
// string ChangeRequestCode = UtilBO.CompensationPrintRequest;
// 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 = documentCode;
// if (objWorkFlowBO != null)
// {
// string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, pageCode);
// lnkApprovalTAsk.Attributes.Add("onclick", paramChangeRequest);
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
}
else
{
//try
//{
// WorkFlowBO objWorkFlowBO = new WorkFlowBO();
// WorkFlowBLL objWorkFlowBLL = new WorkFlowBLL();
// string ChangeRequestCode = UtilBO.CompensationPrintRequest;
// 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 = documentCode;
// if (objWorkFlowBO != null)
// {
// string paramChangeRequest = string.Format("OpenChangeRequest('{0}',{1},{2},{3},'{4}')", ChangeRequestCode, ProjectID, userID, HHID, pageCode);
// lnkApprovalTAsk.Attributes.Add("onclick", paramChangeRequest);
// lnkApprovalTAsk.Visible = true;
// }
// else
// {
// lnkApprovalTAsk.Visible = false;
// }
//}
//catch (Exception ex)
//{
// throw ex;
//}
}
#endregion
#region For PageLevel Approver: Package Review
if (ViewState["ApproveExists"] != null)
{
System.Web.UI.HtmlControls.HtmlTableCell tdPrintButton = (System.Web.UI.HtmlControls.HtmlTableCell)e.Item.FindControl("tdPrintButton");
System.Web.UI.HtmlControls.HtmlTableCell tdApproverButton = (System.Web.UI.HtmlControls.HtmlTableCell)e.Item.FindControl("tdApproverButton");
if (ViewState["ApproveExists"] != null && ViewState["ApproveExists"].ToString() == "Yes")
{
PAP_HouseholdBLL oHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO oHouseHold = new PAP_HouseholdBO();
oHouseHold.ProjectedId = Convert.ToInt32(Session["PROJECT_ID"]);
int HHID = Convert.ToInt32(Session["HH_ID"]);
oHouseHold.HhId = householdID;
oHouseHold.PageCode = "CPREV";
oHouseHold.Workflowcode = UtilBO.WorkflowPackageReview;
oHouseHold = oHouseHoldBLL.ApprovalChangerequestStatus(oHouseHold);
if (oHouseHold != null)
{
if (oHouseHold.ApproverStatus == 3)
{
//PENDING
thPrint.Visible = false;
thApprover.Visible = false;
tdPrintButton.Visible = false;
tdApproverButton.Visible = false;
}
else if (oHouseHold.ApproverStatus == 2)
{
//DECLINED
thPrint.Visible = true;
thApprover.Visible = false;
tdPrintButton.Visible = true;
tdApproverButton.Visible = false;
}
else if (oHouseHold.ApproverStatus == 1)
{
//APPROVED
thPrint.Visible = true;
thApprover.Visible = false;
tdPrintButton.Visible = true;
tdApproverButton.Visible = false;
}
}
else
{
thPrint.Visible = true;
thApprover.Visible = false;
tdPrintButton.Visible = true;
tdApproverButton.Visible = false;
}
}
}
#endregion For PageLevel Approver: Package Review
}
}
/// <summary>
/// to get the houseHold details of the data
/// </summary>
private void GetHouseHoldDtlData()
{
int householdID = Convert.ToInt32(Session["HH_ID"]);
PAP_HouseholdBLL objHouseHoldBLL = new PAP_HouseholdBLL();
PAP_HouseholdBO objHouseHold = objHouseHoldBLL.GetHouseHoldData(householdID);
if (objHouseHold != null)
{
txtHouseHoldID.Text = Convert.ToString(objHouseHold.HhId);
txtPlotReference.Text = Convert.ToString(objHouseHold.PlotReference);
txtTelephoneNo1.Text = Convert.ToString(objHouseHold.Contactphone1);
txtTelephoneNo2.Text = Convert.ToString(objHouseHold.Contactphone2);
txtSurname.Text = Convert.ToString(objHouseHold.Surname);
txtfirstname.Text = Convert.ToString(objHouseHold.Firstname);
txtOthername.Text = Convert.ToString(objHouseHold.Othername);
//Edwin: 27SEP2016
txtFullname.Text = txtSurname.Text + " " + txtfirstname.Text + " " + txtOthername.Text;
txtPapUid.Text = Convert.ToString(objHouseHold.Papuid);
rdlResident.ClearSelection();
if (objHouseHold.Isresident == "No")
{
rdlResident.Items[1].Selected = true;
}
else
{
rdlResident.Items[0].Selected = true;
}
ddloptionGroup.ClearSelection();
ddloptionGroup.SelectedValue = Convert.ToString(objHouseHold.OptiongroupId);
ddlGender.ClearSelection();
if (ddlGender.Items.FindByValue(objHouseHold.Sex) != null)
{
ddlGender.Items.FindByValue(objHouseHold.Sex).Selected = true;
}
ddlPosition.ClearSelection();
if (ddlPosition.Items.FindByValue(Convert.ToString(objHouseHold.PositionId)) != null)
{
ddlPosition.Items.FindByValue(Convert.ToString(objHouseHold.PositionId)).Selected = true;
}
if (objHouseHold.DateofBirth.Trim() != "")
{
dpDateofBirth.Text = Convert.ToDateTime(objHouseHold.DateofBirth).ToString(UtilBO.DateFormat);
}
ddlDistrict.ClearSelection();
if (ddlDistrict.Items.FindByText(Convert.ToString(objHouseHold.District).ToUpper()) != null)
{
ddlDistrict.Items.FindByText(Convert.ToString(objHouseHold.District).ToUpper()).Selected = true;
}
if (ddlDistrict.SelectedIndex > 0)
{
BindCounties(ddlDistrict.SelectedItem.Value);
if (Convert.ToString(objHouseHold.County) != "")
{
ddlCounty.ClearSelection();
if (ddlCounty.Items.FindByText(Convert.ToString(objHouseHold.County).ToUpper()) != null)
{
ddlCounty.Items.FindByText(Convert.ToString(objHouseHold.County).ToUpper()).Selected = true;
}
}
}
if (ddlCounty.SelectedIndex > 0)
{
BindSubCounties(ddlCounty.SelectedItem.Value);
if (Convert.ToString(objHouseHold.SubCounty) != "")
{
ddlSubCounty.ClearSelection();
if (ddlSubCounty.Items.FindByText(Convert.ToString(objHouseHold.SubCounty).ToUpper()) != null)
{
ddlSubCounty.Items.FindByText(Convert.ToString(objHouseHold.SubCounty).ToUpper()).Selected = true;
}
}
}
if (ddlSubCounty.SelectedIndex > 0)
{
BindVillages(ddlSubCounty.SelectedItem.Value);
if (Convert.ToString(objHouseHold.Village) != "")
{
ddlVillage.ClearSelection();
if (ddlVillage.Items.FindByText(Convert.ToString(objHouseHold.Village).ToUpper()) != null)
{
ddlVillage.Items.FindByText(Convert.ToString(objHouseHold.Village).ToUpper()).Selected = true;
}
}
}
if (ddlSubCounty.SelectedIndex > 0)
{
BindParish(ddlSubCounty.SelectedItem.Value);
if (Convert.ToString(objHouseHold.Parish) != "")
{
ddlParish.ClearSelection();
if (ddlParish.Items.FindByText(Convert.ToString(objHouseHold.Parish).ToUpper()) != null)
{
ddlParish.Items.FindByText(Convert.ToString(objHouseHold.Parish).ToUpper()).Selected = true;
}
}
}
if (objHouseHold.CapturedDate.Trim() != "")
{
dpCapturedDate.Text = Convert.ToDateTime(objHouseHold.CapturedDate).ToString(UtilBO.DateFormat);
}
txtCapturedBy.Text = Convert.ToString(objHouseHold.CapturedBy);
ddlGouAllowance.ClearSelection();
if (ddlGouAllowance.Items.FindByValue(objHouseHold.GouStatus.ToString()) != null)
{
ddlGouAllowance.Items.FindByValue(objHouseHold.GouStatus.ToString()).Selected = true;
}
ddlUnderTakingPeriod.ClearSelection();
if (ddlUnderTakingPeriod.Items.FindByValue(objHouseHold.UnderTakingPeriod.ToString()) != null)
{
ddlUnderTakingPeriod.Items.FindByValue(objHouseHold.UnderTakingPeriod.ToString()).Selected = true;
}
getImage(householdID);
//imgPAPPhoto.ImageUrl = "~/ShowImage.ashx?photoModule=PAP&perStuID=0&id=" + householdID.ToString();
}
}
/// <summary>
/// Check User permitions
/// Set Page Header,set attributes to link buttons.
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
#region for Read only add by anjan
// For Read only format
string Mode = string.Empty;
if (Request.QueryString["ProjectID"] != null)
{
Session["PROJECT_ID"] = Convert.ToInt32(Request.QueryString["ProjectID"]);
if (Request.QueryString["HHID"] != null)
{
Session["HH_ID"] = Convert.ToInt32(Request.QueryString["HHID"]);
PAP_HouseholdBLL objHouseholdLogic = new PAP_HouseholdBLL();
PAP_HouseholdBO objHousehold = objHouseholdLogic.GetHouseHoldData(Convert.ToInt32(Request.QueryString["HHID"]));
if (objHousehold != null)
{
Session["HH_IDForDisplay"] = objHousehold.HhId;
}
}
else
{
Session["HH_ID"] = null;
Session["HH_IDForDisplay"] = null;
}
Session["PROJECT_CODE"] = Request.QueryString["ProjectCode"].ToString();
Mode = Request.QueryString["Mode"].ToString();
}
// end
#endregion
if (!IsPostBack)
{
Master.PageHeader = " Upload Documents";
btnShowUpload.Attributes.Add("onclick", "SetVisible(0);");
btnShowSearch.Attributes.Add("onclick", "SetVisible(1);");
//if (Session["PROJECT_CODE"] != null)
//{
// Master.PageHeader = Session["PROJECT_CODE"].ToString() + " - Upload Document";
// ProjectCodeTextBox.Text = Session["PROJECT_CODE"].ToString();
//}
//else
//{
// Response.Redirect("~/UI/Project/ViewProjects.aspx");
//}
BindProjects();
if (Session["PROJECT_ID"] != null)
{
drpProject.ClearSelection();
if (drpProject.Items.FindByValue(Session["PROJECT_ID"].ToString()) != null)
{
drpProject.Items.FindByValue(Session["PROJECT_ID"].ToString()).Selected = true;
}
drpProjectsearch.ClearSelection();
if (drpProjectsearch.Items.FindByValue(Session["PROJECT_ID"].ToString()) != null)
{
drpProjectsearch.Items.FindByValue(Session["PROJECT_ID"].ToString()).Selected = true;
}
if (drpProject.SelectedIndex > 0)
{
imgSearch.Enabled = true;
}
if (drpProjectsearch.SelectedIndex > 0)
{
imgSearchHHID.Enabled = true;
}
if (Session["HH_ID"] == null)
{
HHIDTextBox.Text = "0";
txtHHID.Text = "0";
HHIDTextBoxDISP.Text = "0";
txtHHIDDISP.Text = "0";
}
else
{
HHIDTextBox.Text = Session["HH_ID"].ToString();
txtHHID.Text = Session["HH_ID"].ToString();
}
if (Session["HH_IDForDisplay"] == null)
{
HHIDTextBoxDISP.Text = "0";
txtHHIDDISP.Text = "0";
}
else
{
HHIDTextBoxDISP.Text = Session["HH_IDForDisplay"].ToString();
txtHHIDDISP.Text = Session["HH_IDForDisplay"].ToString();
}
}
if (Session["ModePos"] != null)
{
if (Session["ModePos"].ToString() == "Search")
{
this.contentPanel1.Attributes["src"] = null;
pnlUploadDocuments.Visible = false;
pnlSearchDocument.Visible = true;
}
else
{
this.contentPanel1.Attributes["src"] = null;
pnlUploadDocuments.Visible = true;
pnlSearchDocument.Visible = false;
}
}
BindGrid();
screenIntilation();
this.contentPanel1.Attributes["src"] = null;
if (CheckAuthorization.HasUpdatePrivilege(UtilBO.PrivilegeCode.UPLOAD_DOCUMENT) == false)
{
btnShowUpload.Visible = false;
btnShowSearch.Visible = false;
pnlSearchDocument.Visible = true;
pnlUploadDocuments.Visible = false;
grdUploadDocument.Columns[grdUploadDocument.Columns.Count - 1].Visible = false;
}
}
this.contentPanel1.Attributes["src"] = null;
#region For Read only format Added By Mr. Anaja
// For Read only format
if (Mode == "Readonly")
{
Master.PageHeader = " Supporting Documents";
Label userNameLabel = (Label)Master.FindControl("userNameLabel");
userNameLabel.Visible = false;
LinkButton lnkLogout = (LinkButton)Master.FindControl("lnkLogout");
lnkLogout.Visible = false;
Menu NavigationMenu = (Menu)Master.FindControl("NavigationMenu");
NavigationMenu.Visible = false;
btnShowUpload.Visible = false;
btnShowSearch.Visible = false;
pnlSearchDocument.Visible = false;
pnlUploadDocuments.Visible = false;
grdUploadDocument.Columns[grdUploadDocument.Columns.Count - 1].Visible = false;
}
//End
if (!Page.ClientScript.IsClientScriptBlockRegistered(this.GetType(), "MasterJS"))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "MasterJS",
CreateStartupScript());
}
#endregion
}
public void CachePAPData(string householdID)
{
string papUID = String.Empty;
string papName = String.Empty;
string plotReference = String.Empty;
string papDesignation = "";
string lati = "";
string longi = "";
Session["HH_ID_Disp"] = householdID;
PAP_HouseholdBLL objHouseholdLogic = new PAP_HouseholdBLL();
PAP_HouseholdBO objHousehold = objHouseholdLogic.GetHouseHoldData(Convert.ToInt32(householdID));
if (objHousehold != null)
{
CacheHouseholdID(objHousehold.HhId.ToString());
if (objHousehold.Paptype.ToUpper() == "INS")
{
papName = objHousehold.InstitutionName;
}
else
{
papName = objHousehold.PapName;
}
Cache.Insert(BuildCacheKey("PAPNAME"), papName, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromHours(12));
papUID = objHousehold.Pap_UId;
Cache.Insert(BuildCacheKey("UID"), papUID, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromHours(12));
plotReference = objHousehold.PlotReference;
Cache.Insert(BuildCacheKey("PLOTREFERENCE"), plotReference, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromHours(12));
if (objHousehold.Designation != null)
{
papDesignation = objHousehold.Designation;
Cache.Insert(BuildCacheKey("PAPDESIGNATION"), papDesignation, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromHours(12));
}
if (objHousehold.Plotlatitude != null)
{
lati = objHousehold.Plotlatitude;
Cache.Insert(BuildCacheKey("Plotlatitude"), lati, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromHours(12));
}
if (objHousehold.Plotlongitude != null)
{
longi = objHousehold.Plotlongitude;
Cache.Insert(BuildCacheKey("Plotlongitude"), longi, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromHours(12));
}
//if (objHousehold.PapstatusId > 0)
//{
// PstatusBLL objPstatusBLL = new PstatusBLL();
// PstatusBO objPstatus = objPstatusBLL.GetPstatusById(objHousehold.PapstatusId);
// if (objPstatus != null)
// papDesignation = objPstatus.PAPDESIGNATION1;
//}
//Cache.Insert(BuildCacheKey("PAPDESIGNATION"), papDesignation, null, System.Web.Caching.Cache.NoAbsoluteExpiration, TimeSpan.FromHours(12));
}
objHousehold = null;
objHouseholdLogic = null;
}
/// <summary>
/// TO Select Pap
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected virtual void grdPAPs_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "SetPAP")
{
GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
Session["HH_ID"] = e.CommandArgument;
Label lblProjectCode = (Label)gvr.FindControl("lblProjectCode");
Label lblProjectedId = (Label)gvr.FindControl("lblProjectedId");
Label lblviewstatus = (Label)gvr.FindControl("lblviewstatus");
if (lblviewstatus.Text == "0")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Alertmes", "alert('Cannot Access. You are not included in " + lblProjectCode.Text + " Project.');", true);
return;
}
Session["PROJECT_ID"] = lblProjectedId.Text.Trim();
Session["FROZEN"] = null;
getFrozen();
Session["PROJECT_CODE"] = lblProjectCode.Text;
PAP_HouseholdBLL objHouseholdLogic = new PAP_HouseholdBLL();
PAP_HouseholdBO objHousehold = objHouseholdLogic.GetHouseHoldData(Convert.ToInt32(e.CommandArgument));
if (objHousehold != null)
{
Session["HH_IDForDisplay"] = objHousehold.HhId;
}
if (Request.QueryString["ProjectID"] != null)
{
GridViewRow row = (GridViewRow)((LinkButton)e.CommandSource).NamingContainer;
LinkButton lnkpap = (LinkButton)row.FindControl("lnkPAPName");
Label lblPlotreference = (Label)row.FindControl("lblPlotreference");
Session["SelPAPName"] = lnkpap.Text;
Session["SelPlotreference"] = lblPlotreference.Text;
}
Label l1 = (Label)gvr.FindControl("lblPaptype");
string Paptype = l1.Text;
if (Paptype.ToUpper() == "INS")
{
Response.Redirect(ResolveUrl("~/UI/Compensation/SocioEconomic/Institution.aspx"));
}
else if (Paptype.ToUpper() == "GRP")
{
Response.Redirect(ResolveUrl("~/UI/Compensation/SocioEconomic/Groupownership.aspx"));
}
else
{
Response.Redirect(ResolveUrl("~/UI/Compensation/SocioEconomic/Household.aspx"));
}
}
else if (e.CommandName == "ViewMap")
{
GridViewRow gvr = (GridViewRow)(((LinkButton)e.CommandSource).NamingContainer);
Session["HH_ID"] = e.CommandArgument;
Label lblProjectCode = (Label)gvr.FindControl("lblProjectCode");
Label lblProjectedId = (Label)gvr.FindControl("lblProjectedId");
Session["PROJECT_ID"] = lblProjectedId.Text.Trim();
Session["PROJECT_CODE"] = lblProjectedId.Text;
ScriptManager.RegisterStartupScript(this, this.GetType(), "ViewMap", "ViewMap(" + e.CommandArgument.ToString() + ")", true);
}
}
/// <summary>
/// To Approval Change request Status
/// </summary>
/// <param name="objHouseHold"></param>
/// <returns></returns>
public PAP_HouseholdBO ApprovalChangerequestStatus(PAP_HouseholdBO objHouseHold)
{
PAP_HouseholdDAL objHouseHOldDAL = new PAP_HouseholdDAL();
return(objHouseHOldDAL.ApprovalChangerequestStatus(objHouseHold));
}
/// <summary>
/// Check User permitions
/// Set Page Header
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
Page.Response.Cache.SetNoStore();
if (!IsPostBack)
{
Master.PageHeader = "Upload Document";
btnShowUpload.Attributes.Add("onclick", "SetVisible(0);");
btnShowSearch.Attributes.Add("onclick", "SetVisible(1);");
int DocserviceID = 0;
int ProjectID = 0;
int userID = 0;
if (Session["Project_ID"] != null)
{
ProjectID = Convert.ToInt32(Request.QueryString["ProjectID"]);
}
if (Session["USER_ID"] != null)
{
userID = Convert.ToInt32(Request.QueryString["userID"]);
}
int HHID = Convert.ToInt32(Request.QueryString["HHID"]);
string ProjectCode = Request.QueryString["ProjectCode"].ToString();
string DocumentCode = Request.QueryString["DOCUMENT_CODE"].ToString();
ViewState["PAPDOCUMENTID"] = 0;
if (Request.QueryString["DOCSERVICEID"] != null)
{
DocserviceID = Convert.ToInt32(Request.QueryString["DOCSERVICEID"]);
}
else
{
DocserviceID = 0;
}
if (userID == 0)
{
Response.Redirect("~/Login.aspx");
}
else
{
userIDTextBox.Text = userID.ToString();
}
if (ProjectID == 0)
{
ProjectID = 0;
upProjectIDTextBox.Text = "0";
ProjectCodeTextBox.Text = ProjectCode;
upProjectIDTextBox.Visible = false;
}
else
{
upHHIDTextBox.Text = HHID.ToString();
PAP_HouseholdBLL objHouseholdLogic = new PAP_HouseholdBLL();
PAP_HouseholdBO objHousehold = objHouseholdLogic.GetHouseHoldData(HHID);
if (objHousehold != null)
{
upHHIDTextBoxDisp.Text = objHousehold.HhId.ToString();
}
ProjectCodeTextBox.Text = ProjectCode;
}
if (HHID == 0)
{
HHID = 0;
upProjectIDTextBox.Text = ProjectID.ToString();
ProjectCodeTextBox.Text = ProjectCode;
//DocTypeDropDownList.Visible = false;
upProjectIDTextBox.Visible = false;
upHHIDTextBox.Visible = false;
upHHIDTextBoxDisp.Visible = false;
}
else
{
upProjectIDTextBox.Text = ProjectID.ToString();
ProjectCodeTextBox.Text = ProjectCode;
upProjectIDTextBox.Visible = false;
}
if (DocserviceID > 0)
{
txtDocserviceID.Text = DocserviceID.ToString();
}
BindGrid(false, false);
screenIntilation();
if (CheckAuthorization.HasUpdatePrivilege(UtilBO.PrivilegeCode.PRIV_PACKAGE_CLOSING_INFO) == false)
{
SaveButton.Visible = false;
ClearButton.Visible = false;
}
}
this.contentPanel1.Attributes["src"] = null;
if (!Page.ClientScript.IsClientScriptBlockRegistered(this.GetType(), "MasterJS"))
{
Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "MasterJS",
CreateStartupScript());
}
// Response.Write(ProjectID);
}
