/// <summary>
/// To Add Land Info Priv
/// </summary>
/// <param name="objLF"></param>
public void AddLandInfoPriv(PrivateLandInfoBO objLF)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
int result = 0;
{
OracleCommand myCommand;
myCommand = new OracleCommand("USP_TRN_UPD_PAP_LND_PRIVATE", con);
myCommand.Connection = con;
myCommand.CommandType = CommandType.StoredProcedure;
myCommand.Parameters.Add("HOUSEHOLDID_", objLF.HIDPriv);
myCommand.Parameters.Add("LND_TENUREID_", objLF.Lnd_TENUREIDPriv);
myCommand.Parameters.Add("LANDLORDNAME_", objLF.LANDLORDNAME);
myCommand.Parameters.Add("CLAIMANTNAME_", objLF.CLAIMANTNAME);
myCommand.Parameters.Add("WHENFARMINGBEGAN_", objLF.WHENFARMINGBEGAN);
myCommand.Parameters.Add("WHEREFARMEDBEFORE_", objLF.WHEREFARMEDBEFORE);
myCommand.Parameters.Add("DOSPOUSESFARM_", objLF.DOSPOUSESFARM);
myCommand.Parameters.Add("DOCHILDRENFARM_", objLF.DOCHILDRENFARM);
myCommand.Parameters.Add("AGREEMENTTYPE_", objLF.AGREEMENTTYPE);
myCommand.Parameters.Add("PRODASSETOPPORTUNITIES_", objLF.PRODASSETOPPORTUNITIES);
myCommand.Parameters.Add("CREATEDBY", objLF.Createby);
con.Open();
result = myCommand.ExecuteNonQuery();
con.Close();
}
OracleCommand myCommand1;
myCommand1 = new OracleCommand("USP_TRN_DEL_LND_CHILD", con);
myCommand1.Connection = con;
myCommand1.CommandType = CommandType.StoredProcedure;
myCommand1.Parameters.Add("HHID_", objLF.HIDPriv);
con.Open();
result = myCommand1.ExecuteNonQuery();
con.Close();
}
/// <summary>
/// To Update Land Info Priv
/// </summary>
/// <param name="objLF"></param>
/// <returns></returns>
public int UpdateLandInfoPriv(PrivateLandInfoBO objLF)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
int result = 0;
{
OracleCommand myCommand;
myCommand = new OracleCommand("USP_TRN_UPD_PAP_LND_PRIVATE", con);
myCommand.Connection = con;
myCommand.CommandType = CommandType.StoredProcedure;
//if (string.IsNullOrEmpty(objLF.LANDLORDNAME) == true)
//{
// myCommand.Parameters.Add("LND_TENUREID_", objLF.Lnd_TENUREIDPriv).Value = "";
// myCommand.Parameters.Add("LANDLORDNAME_", objLF.LANDLORDNAME).Value="";
// myCommand.Parameters.Add("CLAIMANTNAME_", objLF.CLAIMANTNAME).Value="";
// myCommand.Parameters.Add("WHENFARMINGBEGAN_", objLF.WHENFARMINGBEGAN).Value="";
// myCommand.Parameters.Add("WHEREFARMEDBEFORE_", objLF.WHEREFARMEDBEFORE).Value="";
// myCommand.Parameters.Add("DOSPOUSESFARM_", objLF.DOSPOUSESFARM).Value="";
// myCommand.Parameters.Add("DOCHILDRENFARM_", objLF.DOCHILDRENFARM).Value="";
// myCommand.Parameters.Add("AGREEMENTTYPE_", objLF.AGREEMENTTYPE).Value="";
// myCommand.Parameters.Add("PRODASSETOPPORTUNITIES_", objLF.PRODASSETOPPORTUNITIES).Value="";
//}
//else
//{
myCommand.Parameters.Add("HHID", objLF.HIDPriv);
myCommand.Parameters.Add("LND_TENUREID_", objLF.Lnd_TENUREIDPriv);
myCommand.Parameters.Add("LANDLORDNAME_", objLF.LANDLORDNAME);
myCommand.Parameters.Add("CLAIMANTNAME_", objLF.CLAIMANTNAME);
myCommand.Parameters.Add("WHENFARMINGBEGAN_", objLF.WHENFARMINGBEGAN);
myCommand.Parameters.Add("WHEREFARMEDBEFORE_", objLF.WHEREFARMEDBEFORE);
myCommand.Parameters.Add("DOSPOUSESFARM_", objLF.DOSPOUSESFARM);
myCommand.Parameters.Add("DOCHILDRENFARM_", objLF.DOCHILDRENFARM);
myCommand.Parameters.Add("AGREEMENTTYPE_", objLF.AGREEMENTTYPE);
myCommand.Parameters.Add("PRODASSETOPPORTUNITIES_", objLF.PRODASSETOPPORTUNITIES);
myCommand.Parameters.Add("CREATEDBY", objLF.Useridpriv);
//}
//myCommand.Parameters.Add("CREATEDBY", OracleDbType.Int64, 5).Value = 1;
con.Open();
result = myCommand.ExecuteNonQuery();
con.Close();
}
OracleCommand myCommand1;
myCommand1 = new OracleCommand("USP_TRN_DEL_LND_CHILD", con);
myCommand1.Connection = con;
myCommand1.CommandType = CommandType.StoredProcedure;
myCommand1.Parameters.Add("HHID_", objLF.HIDPriv);
con.Open();
result = myCommand1.ExecuteNonQuery();
con.Close();
return(result);
}
/// <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 Get Land Info Priv
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public PrivateLandInfoBO GetLandInfoPriv(int householdID)
{
OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_PAP_LND_PRIVATE";
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);
PrivateLandInfoBO objPrivateLF = null;
while (dr.Read())
{
objPrivateLF = new PrivateLandInfoBO();
if (!dr.IsDBNull(dr.GetOrdinal("HHID")))
{
objPrivateLF.HIDPriv = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("HHID"))));
}
if (!dr.IsDBNull(dr.GetOrdinal("PRIVATELANDID")))
{
objPrivateLF.PRIVATELANDID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PRIVATELANDID"))));
}
if (!dr.IsDBNull(dr.GetOrdinal("LND_TENUREID")))
{
objPrivateLF.Lnd_TENUREIDPriv = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LND_TENUREID"))));
}
if (!dr.IsDBNull(dr.GetOrdinal("LANDLORDNAME")))
{
objPrivateLF.LANDLORDNAME = dr.GetValue(dr.GetOrdinal("LANDLORDNAME")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("CLAIMANTNAME")))
{
objPrivateLF.CLAIMANTNAME = dr.GetValue(dr.GetOrdinal("CLAIMANTNAME")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("WHENFARMINGBEGAN")))
{
objPrivateLF.WHENFARMINGBEGAN = dr.GetValue(dr.GetOrdinal("WHENFARMINGBEGAN")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("WHEREFARMEDBEFORE")))
{
objPrivateLF.WHEREFARMEDBEFORE = dr.GetValue(dr.GetOrdinal("WHEREFARMEDBEFORE")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("DOSPOUSESFARM")))
{
objPrivateLF.DOSPOUSESFARM = dr.GetValue(dr.GetOrdinal("DOSPOUSESFARM")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("DOCHILDRENFARM")))
{
objPrivateLF.DOCHILDRENFARM = dr.GetValue(dr.GetOrdinal("DOCHILDRENFARM")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("AGREEMENTTYPE")))
{
objPrivateLF.AGREEMENTTYPE = dr.GetValue(dr.GetOrdinal("AGREEMENTTYPE")).ToString();
}
if (!dr.IsDBNull(dr.GetOrdinal("PRODASSETOPPORTUNITIES")))
{
objPrivateLF.PRODASSETOPPORTUNITIES = dr.GetValue(dr.GetOrdinal("PRODASSETOPPORTUNITIES")).ToString();
}
}
dr.Close();
return(objPrivateLF);
}
/// <summary>
/// To Update Land Info Private
/// </summary>
/// <param name="objPubLF"></param>
public void UpdateLandInfoPrivate(PrivateLandInfoBO objPubLF)
{
LandInfoPrivateDAL objLandInfoResDAL = new LandInfoPrivateDAL();
objLandInfoResDAL.UpdateLandInfoPriv(objPubLF);
}
/// <summary>
/// To Sava and Update Private land Data info in to data base
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
PrivateLandInfoBO objPrivateLF = new PrivateLandInfoBO();
objPrivateLF.HIDPriv = Convert.ToInt32(Session["HH_ID"]);
objPrivateLF.Lnd_TENUREIDPriv = Convert.ToInt32(ddlLandTenure.SelectedItem.Value);
objPrivateLF.LANDLORDNAME = txtlandlord.Text;
objPrivateLF.CLAIMANTNAME = txtwhoclaims.Text.Trim();
objPrivateLF.WHENFARMINGBEGAN = txtwhenbeginfarm.Text.Trim();
objPrivateLF.WHEREFARMEDBEFORE = txtwheredidfarm.Text.Trim();
//objPrivateLF.DOSPOUSESFARM = Chkspouse.Text;
if (Chkspouse.Checked == true)
{
objPrivateLF.DOSPOUSESFARM = "Yes";
//BO.PAP_Relation objPAPR = new BO.PAP_Relation();
//BO.PAP_RelationBLL objPAPRBLL = new BO.PAP_RelationBLL();
//Chkspouselist.DataSource = objPAPRBLL.GetRelations(2,3);
}
else if (Chkspouse.Checked == false)
{
objPrivateLF.DOSPOUSESFARM = "No";
}
if (ChkChildren.Checked == true)
{
objPrivateLF.DOCHILDRENFARM = "Yes";
}
else if (ChkChildren.Checked == false)
{
objPrivateLF.DOCHILDRENFARM = "No";
}
string sagr = txtagrrement.Text.Trim();
string sPro = txtprodutive.Text.Trim();
if (sagr.Length > 999)
{
sagr = sagr.Substring(0, 999);
}
if (sPro.Length > 999)
{
sPro = sPro.Substring(0, 999);
}
objPrivateLF.AGREEMENTTYPE = sagr;
objPrivateLF.PRODASSETOPPORTUNITIES = sPro;
objPrivateLF.Useridpriv = Convert.ToInt32(Session["USER_ID"]);
LandInfoPrivateBLL objLFPrivateBLL = new LandInfoPrivateBLL();
//if (objPrivateLF.HIDPriv != 0)
//{
// objLFPrivateBLL.AddLandInfoPrivate(objPrivateLF);
// ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Private Land Info added successfully');", true);
//}
//else
//{
objLFPrivateBLL.UpdateLandInfoPrivate(objPrivateLF);
PAPRelationList RelationsSpose = new PAPRelationList();
if (Chkspouse.Checked == true)
{
PAP_RelationBO objRelation = null;
for (int i = 0; i < Chkspouselist.Items.Count; i++)
{
if (Chkspouselist.Items[i].Selected)
{
objRelation = new PAP_RelationBO();
objRelation.RelationID = Convert.ToInt32(Chkspouselist.Items[i].Value);
objRelation.HouseholdID = Convert.ToInt32(Session["HH_ID"]);
objRelation.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
RelationsSpose.Add(objRelation);
}
}
}
objLFPrivateBLL.InsertUpdateRelationsSpose(RelationsSpose);
PAPRelationList RelationsChild = new PAPRelationList();
if (ChkChildren.Checked == true)
{
PAP_RelationBO objRelation = null;
for (int i = 0; i < Chkchildrenlist.Items.Count; i++)
{
if (Chkchildrenlist.Items[i].Selected)
{
objRelation = new PAP_RelationBO();
objRelation.RelationID = Convert.ToInt32(Chkchildrenlist.Items[i].Value);
objRelation.HouseholdID = Convert.ToInt32(Session["HH_ID"]);
objRelation.CreatedBy = Convert.ToInt32(Session["USER_ID"]);
RelationsChild.Add(objRelation);
}
}
}
objLFPrivateBLL.InsertUpdateRelationsChild(RelationsChild);
ChangeRequestStatusITML();
projectFrozen();
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "alert('Data updated successfully');", true);
btn_SavePrivate.Text = "Save";
//ClearDetailspriv();
//}
}
/// <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;
}
}
}
