/// <summary> /// To Get Land Info Respondents /// </summary> /// <param name="HHID"></param> /// <returns></returns> public LandInfoRespondentsList GetLandInfoRespondents(int HHID) { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_LND_RESP_HOLDNG"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("HHID_", HHID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); LandInfoRespondentsBO objLIRBLL = null; LandInfoRespondentsList objLIRLIST = new LandInfoRespondentsList(); while (dr.Read()) { objLIRBLL = new LandInfoRespondentsBO(); //objLIRBLL.HOLDINGID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LND_HOLDINGID")))); //objLIRBLL.LND_TYPEID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LND_TYPEID")))); //objLIRBLL.Land_Type = dr.GetValue(dr.GetOrdinal("LANDTYPE")).ToString(); //objLIRBLL.LND_USEID = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("LND_USEID")))); //objLIRBLL.Land_Use = dr.GetValue(dr.GetOrdinal("LANDUSE")).ToString(); //objLIRBLL.DISTRICT = dr.GetValue(dr.GetOrdinal("DISTRICT")).ToString(); //objLIRBLL.COUNTY = dr.GetValue(dr.GetOrdinal("COUNTY")).ToString(); //objLIRBLL.SUBCOUNTY = dr.GetValue(dr.GetOrdinal("SUBCOUNTY")).ToString(); //objLIRBLL.VILLAGE = dr.GetValue(dr.GetOrdinal("VILLAGE")).ToString(); //objLIRBLL.TENURE = dr.GetValue(dr.GetOrdinal("TENURE")).ToString(); //objLIRBLL.TOTALSIZE = (Convert.ToInt32(dr.GetValue(dr.GetOrdinal("TOTALSIZE")))); //objLIRBLL.ISPRIMARYRESIDENCE = dr.GetValue(dr.GetOrdinal("ISPRIMARYRESIDENCE")).ToString(); //objLIRBLL.ISAFFECTED = dr.GetValue(dr.GetOrdinal("ISAFFECTED")).ToString(); objLIRBLL = MapData(dr); objLIRLIST.Add(objLIRBLL); } dr.Close(); return(objLIRLIST); }
/// <summary> /// To Update Land Info Respondents /// </summary> /// <param name="objLIR"></param> public void UpdateLandInfoRespondents(LandInfoRespondentsBO objLIR) { LandInfoRespondentsDAL objLIRDAL = new LandInfoRespondentsDAL(); objLIRDAL.UpdateLandInfoRespondents(objLIR); }
/// <summary> /// To Add Land Info Respondents /// </summary> /// <param name="objLIR"></param> public void AddLandInfoRespondents(LandInfoRespondentsBO objLIR) { LandInfoRespondentsDAL objLIRDAL = new LandInfoRespondentsDAL(); objLIRDAL.AddLandInfoRespondents(objLIR); }
/// <summary> /// To Update Land Info Respondents /// </summary> /// <param name="objLIRBO"></param> /// <returns></returns> public int UpdateLandInfoRespondents(LandInfoRespondentsBO objLIRBO) { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); int result = 0; { OracleCommand myCommand; myCommand = new OracleCommand("USP_TRN_UPD_LND_RESP_HOLDNG", con); myCommand.Connection = con; myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add("LND_HOLDINGID_", objLIRBO.HOLDINGID); myCommand.Parameters.Add("HHID_", objLIRBO.HID); if (objLIRBO.LND_TYPEID == 0) { myCommand.Parameters.Add("LND_TYPEID_", DBNull.Value); } else { myCommand.Parameters.Add("LND_TYPEID_", objLIRBO.LND_TYPEID); } if (objLIRBO.LND_USEID == 0) { myCommand.Parameters.Add("LND_USEID_", DBNull.Value); } else { myCommand.Parameters.Add("LND_USEID_", objLIRBO.LND_USEID); } myCommand.Parameters.Add("DISTRICT_", objLIRBO.DISTRICT); myCommand.Parameters.Add("COUNTY_", objLIRBO.COUNTY); myCommand.Parameters.Add("SUBCOUNTY_", objLIRBO.SUBCOUNTY); myCommand.Parameters.Add("VILLAGE_", objLIRBO.VILLAGE); if (objLIRBO.TenureId == 0) { myCommand.Parameters.Add("STR_TENUREID_", DBNull.Value); } else { myCommand.Parameters.Add("STR_TENUREID_", objLIRBO.TenureId); } myCommand.Parameters.Add("TENURE_", objLIRBO.TENURE); if (objLIRBO.TOTALSIZE == -1) { myCommand.Parameters.Add("TOTALSIZE_", DBNull.Value); } else { myCommand.Parameters.Add("TOTALSIZE_", objLIRBO.TOTALSIZE); } myCommand.Parameters.Add("ISPRIMARYRESIDENCE_", objLIRBO.ISPRIMARYRESIDENCE); myCommand.Parameters.Add("ISAFFECTED_", objLIRBO.ISAFFECTED); //myCommand.Parameters.Add("ISAFFECTED_", OracleDbType.Varchar2, 5).Value = "False"; myCommand.Parameters.Add("UPDATEDBYIN", objLIRBO.UpdatedBy); //myCommand.Parameters.Add("LND_HOLDINGID_", objLIRBLL.HOLDINGID); //myCommand.Parameters.Add("HHID_", objLIRBLL.HID); //myCommand.Parameters.Add("LND_TYPEID_", objLIRBLL.LND_TYPEID); //myCommand.Parameters.Add("LND_USEID_", objLIRBLL.LND_USEID); //myCommand.Parameters.Add("DISTRICT_", objLIRBLL.DISTRICT); //myCommand.Parameters.Add("COUNTY_", objLIRBLL.COUNTY); //myCommand.Parameters.Add("SUBCOUNTY_", objLIRBLL.SUBCOUNTY); //myCommand.Parameters.Add("VILLAGE_", objLIRBLL.VILLAGE); //myCommand.Parameters.Add("TENURE_", objLIRBLL.TENURE); //myCommand.Parameters.Add("TOTALSIZE_", objLIRBLL.TOTALSIZE); //myCommand.Parameters.Add("ISPRIMARYRESIDENCE_", objLIRBLL.ISPRIMARYRESIDENCE); //myCommand.Parameters.Add("ISAFFECTED_", objLIRBLL.ISAFFECTED); //myCommand.Parameters.Add("UPDATEDBY", objLIRBLL.Userid); //} con.Open(); result = myCommand.ExecuteNonQuery(); con.Close(); } return(result); }
/// <summary> /// To Map Data /// </summary> /// <param name="reader"></param> /// <returns></returns> private LandInfoRespondentsBO MapData(IDataReader reader) { // BatchBO oBatchBO = new BatchBO(); LandInfoRespondentsBO oLandInfoResBO = new LandInfoRespondentsBO(); if (ColumnExists(reader, "LND_HOLDINGID") && !reader.IsDBNull(reader.GetOrdinal("LND_HOLDINGID"))) { oLandInfoResBO.HOLDINGID = (Convert.ToInt32(reader.GetValue(reader.GetOrdinal("LND_HOLDINGID")))); } if (ColumnExists(reader, "LND_TYPEID") && !reader.IsDBNull(reader.GetOrdinal("LND_TYPEID"))) { oLandInfoResBO.LND_TYPEID = (Convert.ToInt32(reader.GetValue(reader.GetOrdinal("LND_TYPEID")))); } else if (reader.IsDBNull(reader.GetOrdinal("LND_TYPEID"))) { oLandInfoResBO.LND_TYPEID = 0; } if (ColumnExists(reader, "LANDTYPE") && !reader.IsDBNull(reader.GetOrdinal("LANDTYPE"))) { oLandInfoResBO.Land_Type = reader.GetString(reader.GetOrdinal("LANDTYPE")); } if (ColumnExists(reader, "LND_USEID") && !reader.IsDBNull(reader.GetOrdinal("LND_USEID"))) { oLandInfoResBO.LND_USEID = (Convert.ToInt32(reader.GetValue(reader.GetOrdinal("LND_USEID")))); } else if (reader.IsDBNull(reader.GetOrdinal("LND_USEID"))) { oLandInfoResBO.LND_USEID = 0; } if (ColumnExists(reader, "LANDUSE") && !reader.IsDBNull(reader.GetOrdinal("LANDUSE"))) { oLandInfoResBO.Land_Use = reader.GetString(reader.GetOrdinal("LANDUSE")); } if (ColumnExists(reader, "DISTRICT") && !reader.IsDBNull(reader.GetOrdinal("DISTRICT"))) { oLandInfoResBO.DISTRICT = reader.GetString(reader.GetOrdinal("DISTRICT")); } if (ColumnExists(reader, "COUNTY") && !reader.IsDBNull(reader.GetOrdinal("COUNTY"))) { oLandInfoResBO.COUNTY = reader.GetValue(reader.GetOrdinal("COUNTY")).ToString(); } if (ColumnExists(reader, "SUBCOUNTY") && !reader.IsDBNull(reader.GetOrdinal("SUBCOUNTY"))) { oLandInfoResBO.SUBCOUNTY = reader.GetValue(reader.GetOrdinal("SUBCOUNTY")).ToString(); } if (ColumnExists(reader, "VILLAGE") && !reader.IsDBNull(reader.GetOrdinal("VILLAGE"))) { oLandInfoResBO.VILLAGE = reader.GetValue(reader.GetOrdinal("VILLAGE")).ToString(); } if (ColumnExists(reader, "STR_TENUREID") && !reader.IsDBNull(reader.GetOrdinal("STR_TENUREID"))) { oLandInfoResBO.TenureId = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("STR_TENUREID")).ToString()); } if (ColumnExists(reader, "TENURE") && !reader.IsDBNull(reader.GetOrdinal("TENURE"))) { oLandInfoResBO.TENURE = reader.GetValue(reader.GetOrdinal("TENURE")).ToString(); } if (ColumnExists(reader, "TOTALSIZE") && !reader.IsDBNull(reader.GetOrdinal("TOTALSIZE"))) { oLandInfoResBO.TOTALSIZE = (Convert.ToInt32(reader.GetValue(reader.GetOrdinal("TOTALSIZE")))); } if (ColumnExists(reader, "ISPRIMARYRESIDENCE") && !reader.IsDBNull(reader.GetOrdinal("ISPRIMARYRESIDENCE"))) { oLandInfoResBO.ISPRIMARYRESIDENCE = reader.GetValue(reader.GetOrdinal("ISPRIMARYRESIDENCE")).ToString(); } if (ColumnExists(reader, "ISAFFECTED") && !reader.IsDBNull(reader.GetOrdinal("ISAFFECTED"))) { oLandInfoResBO.ISAFFECTED = reader.GetValue(reader.GetOrdinal("ISAFFECTED")).ToString(); } //if (ColumnExists(reader, "HHID") && !reader.IsDBNull(reader.GetOrdinal("HHID"))) // oBatchBO.HHID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("HHID"))); return(oLandInfoResBO); }
/// <summary> /// to get the Land info Respondant /// </summary> private void getLandInfoRespondant() { LandInfoRespondentsBO LIR = new LandInfoRespondentsBO(); LandInfoRespondentsBLL objLIRBLL = new LandInfoRespondentsBLL(); LIR = objLIRBLL.GetLandInfoRespondentsByID(Convert.ToInt32(ViewState["LND_HOLDINGID"])); if (LIR != null) { DrpType.ClearSelection(); if (LIR.LND_TYPEID > 0) { DrpType.SelectedValue = LIR.LND_TYPEID.ToString(); } DrpUse.ClearSelection(); if (LIR.LND_USEID > 0) { DrpUse.SelectedValue = LIR.LND_USEID.ToString(); } DrpDistrict.ClearSelection(); if (DrpDistrict.Items.FindByText(LIR.DISTRICT) != null) { DrpDistrict.Items.FindByText(LIR.DISTRICT).Selected = true; } BindCounties(DrpDistrict.SelectedItem.Value); DrpCounty.ClearSelection(); if (DrpCounty.Items.FindByText(LIR.COUNTY) != null) { DrpCounty.Items.FindByText(LIR.COUNTY).Selected = true; } BindSubCounty(DrpCounty.SelectedItem.Value); DrpSubCounty.ClearSelection(); if (DrpSubCounty.Items.FindByText(LIR.SUBCOUNTY) != null) { DrpSubCounty.Items.FindByText(LIR.SUBCOUNTY).Selected = true; } BindVillages(DrpSubCounty.SelectedItem.Value); DrpVillage.ClearSelection(); if (DrpVillage.Items.FindByText(LIR.VILLAGE) != null) { DrpVillage.Items.FindByText(LIR.VILLAGE).Selected = true; } //DrpType.SelectedItem.Value = Convert.ToString(LIR.LND_TYPEID); //DrpUse.SelectedItem.Value = Convert.ToString(LIR.LND_USEID); //DrpDistrict.SelectedItem.Value = Convert.ToString(LIR.DISTRICT); //DrpCounty.SelectedItem.Value = Convert.ToString(LIR.COUNTY); //DrpSubCounty.SelectedItem.Value = Convert.ToString(LIR.SUBCOUNTY); //DrpVillage.SelectedItem.Value = Convert.ToString(LIR.VILLAGE); ddlTenureType.ClearSelection(); if (ddlTenureType.Items.FindByValue(LIR.TenureId.ToString()) != null) { ddlTenureType.SelectedValue = LIR.TenureId.ToString(); } if (LIR.ISPRIMARYRESIDENCE.ToLower() == "Yes".ToLower()) { ChkPrimary.Checked = true; } else { ChkPrimary.Checked = false; } if (LIR.ISAFFECTED.ToLower() == "Yes".ToLower()) { ChkAffected.Checked = true; } else { ChkAffected.Checked = false; } if (LIR.TOTALSIZE != -1) { txttotal.Text = Convert.ToString(LIR.TOTALSIZE); } else { txttotal.Text = string.Empty; } if (LIR.TENURE != null) { txttenure.Text = LIR.TENURE; } else { txttenure.Text = string.Empty; } } }
/// <summary> /// To save the data to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btn_SaveRes_Click(object sender, EventArgs e) { ChangeRequestStatusLandHoldings(); LandInfoRespondentsBO objLIR = new LandInfoRespondentsBO(); objLIR.HOLDINGID = int.Parse(ViewState["LND_HOLDINGID"].ToString()); objLIR.HID = int.Parse(Session["HH_ID"].ToString()); objLIR.updatedBy = Convert.ToInt32(Session["USER_ID"].ToString()); if (DrpType.SelectedValue != "0") { objLIR.LND_TYPEID = Convert.ToInt32(DrpType.SelectedValue); } else { objLIR.LND_TYPEID = 0;//DBNull } if (DrpUse.SelectedValue != "0") { objLIR.LND_USEID = Convert.ToInt32(DrpUse.SelectedValue); } else { objLIR.LND_USEID = 0;//DBNull } if (DrpDistrict.SelectedValue != "0") { objLIR.DISTRICT = DrpDistrict.SelectedItem.Text; } else { objLIR.DISTRICT = string.Empty; } if (DrpCounty.SelectedValue != "0") { objLIR.COUNTY = DrpCounty.SelectedItem.Text; } else { objLIR.COUNTY = string.Empty; } if (DrpSubCounty.SelectedValue != "0") { objLIR.SUBCOUNTY = DrpSubCounty.SelectedItem.Text; } else { objLIR.SUBCOUNTY = string.Empty; } if (DrpVillage.SelectedValue != "0") { objLIR.VILLAGE = DrpVillage.SelectedItem.Text; } else { objLIR.VILLAGE = string.Empty; } if (ddlTenureType.SelectedValue != "0") { objLIR.TenureId = Convert.ToInt32(ddlTenureType.SelectedValue.ToString()); } else { objLIR.TenureId = 0; } if (!string.IsNullOrEmpty(txttenure.Text)) { objLIR.TENURE = txttenure.Text.Trim(); } else { objLIR.TENURE = string.Empty; } if (!string.IsNullOrEmpty(txttotal.Text)) { objLIR.TOTALSIZE = Convert.ToDecimal(txttotal.Text.Trim()); } else { objLIR.TOTALSIZE = -1; } if (ChkPrimary.Checked == true) { objLIR.ISPRIMARYRESIDENCE = "Yes"; } else if (ChkPrimary.Checked == false) { objLIR.ISPRIMARYRESIDENCE = "No"; } if (ChkAffected.Checked == true) { objLIR.ISAFFECTED = "Yes"; } else if (ChkAffected.Checked == false) { objLIR.ISAFFECTED = "No"; } LandInfoRespondentsBLL objLIRBLL = new LandInfoRespondentsBLL(); if (objLIR.HOLDINGID == 0) { objLIRBLL.AddLandInfoRespondents(objLIR); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data saved successfully');", true); } else { objLIRBLL.UpdateLandInfoRespondents(objLIR); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Updated", "alert('Data updated successfully');", true); btn_SaveRes.Text = "Save"; ViewState["LND_HOLDINGID"] = 0; } projectFrozen(); ClearLandHolding(); BindGrid(true, false); }