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