/// <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; } } }