/// <summary>
/// Set Page header,Call BindGrid() method
/// Check User Permitions
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
if (Session["PROJECT_CODE"] != null)
{
Master.PageHeader = Session["PROJECT_CODE"].ToString() + " - Comparison Report";
}
else
{
Master.PageHeader = "Comparision Report";
}
LandInfoBLL objLandInfoBLL = new LandInfoBLL();
PublicLandInfoBO objLandInfo = objLandInfoBLL.GetLandInfo(Convert.ToInt32(Session["HH_ID"]));
string LandType = "";
if (objLandInfo != null)
{
LandType = "CMPLNDINFOPUB";
}
else
{
LandType = "CMPLNDINFOPRIV";
}
ddlReportType.Items.FindByValue("CMPLNDINFO").Value = LandType;
}
}
/// <summary>
/// get Data and set data to Labels
/// </summary>
private void BindLandType()
{
LandInfoBLL objLandInfoBLL = new LandInfoBLL();
PublicLandInfoBO objLandInfo = objLandInfoBLL.GetLandInfo(Convert.ToInt32(Session["HH_ID"]));
if (objLandInfo != null)
{
objMasterBLL = new MasterBLL();
TenureLandList TenureLands = objMasterBLL.LoadTenureLand();
foreach (TenureLandBO objTenureLand in TenureLands)
{
if (objTenureLand.Lnd_TenureId == objLandInfo.LND_TENUREID)
{
lblLandType.Text = objTenureLand.Lnd_Tenure;
break;
}
}
}
else
{
LandInfoPrivateBLL objLFPrivateBLL = new LandInfoPrivateBLL();
PrivateLandInfoBO objLandInfoPriv = objLFPrivateBLL.GetLandInfoPriv(Convert.ToInt32(Session["HH_ID"]));
if (objLandInfoPriv != null)
{
objMasterBLL = new MasterBLL();
TenureLandList TenureLands = objMasterBLL.LoadTenureLand();
foreach (TenureLandBO objTenureLand in TenureLands)
{
if (objTenureLand.Lnd_TenureId == objLandInfoPriv.Lnd_TENUREIDPriv)
{
lblLandType.Text = objTenureLand.Lnd_Tenure;
break;
}
}
}
}
}
/// <summary>
/// To Update Land Info
/// </summary>
/// <param name="objLF"></param>
/// <returns></returns>
public int UpdateLandInfo(PublicLandInfoBO objLF)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
int result = 0;
{
OracleCommand myCommand;
myCommand = new OracleCommand("USP_TRN_UPD_PAP_LND_PUBLIC", con);
myCommand.Connection = con;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("HOUSEHOLDID_", objLF.HID);
myCommand.Parameters.Add("LND_TENUREID_", objLF.LND_TENUREID);
myCommand.Parameters.Add("HASTITLEDETAILS_", objLF.HASTITLEDETAILS);
myCommand.Parameters.Add("YEAROFACQUISITION_", objLF.YEAROFACQUISITION);
myCommand.Parameters.Add("FROMWHOM_", objLF.FROMWHOM);
myCommand.Parameters.Add("COMMENTS_", objLF.COMMENTS);
myCommand.Parameters.Add("WHOCLAIMSLAND_", objLF.WHOCLAIMSLAND);
myCommand.Parameters.Add("LIVEDSINCEBIRTH_", objLF.LIVEDSINCEBIRTH);
myCommand.Parameters.Add("MOVEDYEAR_", objLF.MOVEDYEAR);
myCommand.Parameters.Add("WHERELIVEDBEFORE_", objLF.WHERELIVEDBEFORE);
myCommand.Parameters.Add("ISMORTGAGED_", objLF.ISMORTGAGED);
myCommand.Parameters.Add("MORTGAGEDETAILS_", objLF.MORTGAGEDETAILS);
if (objLF.LandRecivedfromid > 0)
{
myCommand.Parameters.Add("LANDRECDFROMID_", objLF.LandRecivedfromid);
}
else
{
myCommand.Parameters.Add("LANDRECDFROMID_", DBNull.Value);
}
myCommand.Parameters.Add("CREATEDBY_", objLF.Userid);
con.Open();
result = myCommand.ExecuteNonQuery();
con.Close();
}
return(result);
}
/// <summary>
/// To Get Land Info
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public PublicLandInfoBO GetLandInfo(int householdID)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_PAP_LND_PUBLIC";
cmd = new OracleCommand(proc, con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", householdID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
PublicLandInfoBO objLF = null;
while (dr.Read())
{
objLF = new PublicLandInfoBO();
if (!dr.IsDBNull(dr.GetOrdinal("HHID")))
{
objLF.HID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("HHID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("LND_TENUREID")))
{
objLF.LND_TENUREID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LND_TENUREID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("HASTITLEDETAILS")))
{
objLF.HASTITLEDETAILS = dr.GetValue(dr.GetOrdinal("HASTITLEDETAILS")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("YEAROFACQUISITION")))
{
objLF.YEAROFACQUISITION = dr.GetValue(dr.GetOrdinal("YEAROFACQUISITION")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("FROMWHOM")))
{
objLF.FROMWHOM = dr.GetValue(dr.GetOrdinal("FROMWHOM")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("COMMENTS")))
{
objLF.COMMENTS = dr.GetValue(dr.GetOrdinal("COMMENTS")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("WHOCLAIMSLAND")))
{
objLF.WHOCLAIMSLAND = dr.GetValue(dr.GetOrdinal("WHOCLAIMSLAND")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("LIVEDSINCEBIRTH")))
{
objLF.LIVEDSINCEBIRTH = dr.GetValue(dr.GetOrdinal("LIVEDSINCEBIRTH")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("MOVEDYEAR")))
{
objLF.MOVEDYEAR = dr.GetValue(dr.GetOrdinal("MOVEDYEAR")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("WHERELIVEDBEFORE")))
{
objLF.WHERELIVEDBEFORE = dr.GetValue(dr.GetOrdinal("WHERELIVEDBEFORE")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("ISMORTGAGED")))
{
objLF.ISMORTGAGED = dr.GetValue(dr.GetOrdinal("ISMORTGAGED")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("MORTGAGEDETAILS")))
{
objLF.MORTGAGEDETAILS = dr.GetValue(dr.GetOrdinal("MORTGAGEDETAILS")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("LANDRECDFROMID")))
{
objLF.LandRecivedfromid = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LANDRECDFROMID")).ToString());
}
}
dr.Close();
return(objLF);
}
/// <summary>
/// To Update Land Info
/// </summary>
/// <param name="objLF"></param>
public void UpdateLandInfo(PublicLandInfoBO objLF)
{
LandInfoDAL objLandInfoDAL = new LandInfoDAL();
objLandInfoDAL.UpdateLandInfo(objLF);
}
/// <summary>
/// To Add Land Info
/// </summary>
/// <param name="objLF"></param>
public void AddLandInfo(PublicLandInfoBO objLF)
{
LandInfoDAL objLandInfoDAL = new LandInfoDAL();
objLandInfoDAL.AddLandInfo(objLF);
}
/// <summary>
/// To Sava and Update Public land Data info in to data base
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btn_SavePublic(object sender, EventArgs e)
{
PublicLandInfoBO objPublicLF = new PublicLandInfoBO();
objPublicLF.HID = Convert.ToInt32(Session["HH_ID"]);
objPublicLF.LND_TENUREID = Convert.ToInt32(ddlLandTenure.SelectedItem.Value);
objPublicLF.LandRecivedfromid = Convert.ToInt32(ddlReceivedFromWhom.SelectedItem.Value);
objPublicLF.YEAROFACQUISITION = txtyear.Text.Trim();
objPublicLF.FROMWHOM = txtfromwhom.Text.Trim();
string strMax = txtcoments.Text.ToString().Trim();
if (strMax.Trim().Length >= 999)
{
strMax = txtcoments.Text.ToString().Trim().Substring(0, 999);
}
objPublicLF.COMMENTS = strMax;
objPublicLF.WHOCLAIMSLAND = txtland.Text.Trim();
if (Chkhasitdetails.Checked == true)
{
objPublicLF.HASTITLEDETAILS = "Yes";
}
else if (Chkhasitdetails.Checked == false)
{
objPublicLF.HASTITLEDETAILS = "No";
}
if (chkLivedSinceBirth.Checked == true)
{
objPublicLF.LIVEDSINCEBIRTH = "Yes";
}
else
{
objPublicLF.LIVEDSINCEBIRTH = "No";
}
if (ChkMortagelies.Checked == true)
{
objPublicLF.ISMORTGAGED = "Yes";
}
else if (ChkMortagelies.Checked == false)
{
objPublicLF.ISMORTGAGED = "No";
}
objPublicLF.MOVEDYEAR = txtyearmoved.Text.Trim();
objPublicLF.WHERELIVEDBEFORE = txtwherebefore.Text.Trim();
string strgMax = txtmortagedetails.Text.Trim();
if (strgMax.Trim().Length >= 200)
{
strgMax = txtmortagedetails.Text.Trim().Substring(0, 200);
}
objPublicLF.MORTGAGEDETAILS = strgMax;
objPublicLF.Userid = Convert.ToInt32(Session["USER_ID"]);
LandInfoBLL objLFBLL = new LandInfoBLL();
//objPublicLF. = txtwherebefore.Text.Trim();
//if (objPublicLF.HID != 0)
//{
// objLFBLL.AddLandInfo(objPublicLF);
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Public Land Info added successfully');", true);
//}
//else
//{
ChangeRequestStatusILOP();
objLFBLL.UpdateLandInfo(objPublicLF);
projectFrozen();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "alert('Data saved successfully');", true);
//ClearDetailspublic();
//}
}
/// <summary>
/// Get Land Info Details for Selected PAP
/// </summary>
private void GetLandInfo()
{
LandInfoBLL objLandInfoBLL = new LandInfoBLL();
PublicLandInfoBO objLandInfo = objLandInfoBLL.GetLandInfo(Convert.ToInt32(Session["HH_ID"]));
if (objLandInfo != null)
{
ddlLandTenure.ClearSelection();
if (ddlLandTenure.Items.FindByValue(objLandInfo.LND_TENUREID.ToString()) != null)
{
ddlLandTenure.Items.FindByValue(objLandInfo.LND_TENUREID.ToString()).Selected = true;
}
ddlReceivedFromWhom.ClearSelection();
if (ddlReceivedFromWhom.Items.FindByValue(objLandInfo.LandRecivedfromid.ToString()) != null)
{
ddlReceivedFromWhom.Items.FindByValue(objLandInfo.LandRecivedfromid.ToString()).Selected = true;
}
if (ddlReceivedFromWhom.SelectedItem.Text == "Other" || ddlReceivedFromWhom.SelectedItem.Text == "Individual")
{
txtfromwhom.Enabled = true;
}
else
{
txtfromwhom.Enabled = false;
}
txtyear.Text = objLandInfo.YEAROFACQUISITION;
txtfromwhom.Text = objLandInfo.FROMWHOM;
txtcoments.Text = objLandInfo.COMMENTS;
txtland.Text = objLandInfo.WHOCLAIMSLAND;
if (objLandInfo.HASTITLEDETAILS.ToUpper() == "YES")
{
Chkhasitdetails.Checked = true;
}
if (objLandInfo.LIVEDSINCEBIRTH.ToUpper() == "YES")
{
chkLivedSinceBirth.Checked = true;
}
if (objLandInfo.ISMORTGAGED.ToUpper() == "YES")
{
ChkMortagelies.Checked = true;
}
txtyearmoved.Text = objLandInfo.MOVEDYEAR;
txtwherebefore.Text = objLandInfo.WHERELIVEDBEFORE;
txtmortagedetails.Text = objLandInfo.MORTGAGEDETAILS;
pnlPublic.Visible = true;
//ddlLandTenure.Enabled = false;
}
else
{
LandInfoPrivateBLL objLandInfoPrivBLL = new LandInfoPrivateBLL();
PrivateLandInfoBO objPrivLandInfo = objLandInfoPrivBLL.GetLandInfoPriv(Convert.ToInt32(Session["HH_ID"]));
if (objPrivLandInfo != null)
{
ddlLandTenure.ClearSelection();
if (ddlLandTenure.Items.FindByValue(objPrivLandInfo.Lnd_TENUREIDPriv.ToString()) != null)
{
ddlLandTenure.Items.FindByValue(objPrivLandInfo.Lnd_TENUREIDPriv.ToString()).Selected = true;
}
txtlandlord.Text = objPrivLandInfo.LANDLORDNAME;
txtwhoclaims.Text = objPrivLandInfo.CLAIMANTNAME;
txtwhenbeginfarm.Text = objPrivLandInfo.WHENFARMINGBEGAN;
txtwheredidfarm.Text = objPrivLandInfo.WHEREFARMEDBEFORE;
if (objPrivLandInfo.DOSPOUSESFARM.ToUpper() == "YES")
{
Chkspouse.Checked = true;
PAP_RelationBLL objPAPRBLL = new PAP_RelationBLL();
PAPRelationList objPAPRelationList = new PAPRelationList();
objPAPRelationList = objPAPRBLL.GetRelations(Convert.ToInt32(Session["HH_ID"]), 1);
if (objPAPRelationList.Count > 0)
{
Chkspouselist.DataSource = objPAPRelationList;
Chkspouselist.DataTextField = "HOLDERNAME";
Chkspouselist.DataValueField = "RelationID";
Chkspouselist.DataBind();
}
else
{
chkmsg1.Text = "Spouses Not Available";
}
if (Chkspouselist.Items.Count > 0)
{
PAPRelationList RelationsSpose = objLandInfoPrivBLL.GetLandInfoPrivSpose(Convert.ToInt32(objPrivLandInfo.PRIVATELANDID));
if (RelationsSpose != null)
{
for (int i = 0; i < RelationsSpose.Count; i++)
{
Chkspouselist.Items.FindByValue(RelationsSpose[i].RelationID.ToString()).Selected = true;
}
}
}
}
if (objPrivLandInfo.DOCHILDRENFARM.ToUpper() == "YES")
{
ChkChildren.Checked = true;
BindChild(Convert.ToInt32(Session["HH_ID"]));
if (Chkchildrenlist.Items.Count > 0)
{
PAPRelationList RelationsSpose = objLandInfoPrivBLL.GetLandInfoPrivChild(Convert.ToInt32(objPrivLandInfo.PRIVATELANDID));
if (RelationsSpose != null)
{
for (int i = 0; i < RelationsSpose.Count; i++)
{
Chkchildrenlist.Items.FindByValue(RelationsSpose[i].RelationID.ToString()).Selected = true;
}
}
}
}
txtagrrement.Text = objPrivLandInfo.AGREEMENTTYPE;
txtprodutive.Text = objPrivLandInfo.PRODASSETOPPORTUNITIES;
pnlMailo.Visible = true;
//ddlLandTenure.Enabled = false;
}
}
}
