/// <summary>
/// To Get Neighbour By Id
/// </summary>
/// <param name="Pap_NeighbrID"></param>
/// <returns></returns>
public NeighbourBO GetNeighbrById(int Pap_NeighbrID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_GET_NEIGHBR";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("P_PAP_NEIGHBOURID", Pap_NeighbrID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
NeighbourBO Neighbourobj = null;
NeighbourList NeighbourListobj = new NeighbourList();
Neighbourobj = new NeighbourBO();
while (dr.Read())
{
if (ColumnExists(dr, "neighbourname") && !dr.IsDBNull(dr.GetOrdinal("neighbourname")))
{
Neighbourobj.TRN_PAP_NEIGHBOURNAme1 = dr.GetString(dr.GetOrdinal("neighbourname"));
}
if (ColumnExists(dr, "pap_neighbourid") && !dr.IsDBNull(dr.GetOrdinal("pap_neighbourid")))
{
Neighbourobj.PAP_NEIGHBOURID1 = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("pap_neighbourid")));
}
if (ColumnExists(dr, "direction") && !dr.IsDBNull(dr.GetOrdinal("direction")))
{
Neighbourobj.DIRECTION1 = dr.GetString(dr.GetOrdinal("direction"));
}
if (ColumnExists(dr, "boundariesconfirmed") && !dr.IsDBNull(dr.GetOrdinal("boundariesconfirmed")))
{
Neighbourobj.BOUNDARIESCONFIRMED1 = dr.GetString(dr.GetOrdinal("boundariesconfirmed"));
}
if (ColumnExists(dr, "boundary_dispute") && !dr.IsDBNull(dr.GetOrdinal("boundary_dispute")))
{
Neighbourobj.BOUNDARY_DISPUTE = dr.GetString(dr.GetOrdinal("boundary_dispute"));
}
if (ColumnExists(dr, "dispute_details") && !dr.IsDBNull(dr.GetOrdinal("dispute_details")))
{
Neighbourobj.DISPUTE_DETAILS = dr.GetString(dr.GetOrdinal("dispute_details"));
}
}
dr.Close();
return(Neighbourobj);
}
/// <summary>
/// to get the NeighBour Data
/// </summary>
private void GetNeighbor()
{
neighbourBLL neighbourBLLobj = new neighbourBLL();
int Pap_NeighbrID = 0;
if (ViewState["PAP_NEIGHBOURID"] != null)
{
Pap_NeighbrID = Convert.ToInt32(ViewState["PAP_NEIGHBOURID"]);
}
NeighbourBO Neighbourobj = new NeighbourBO();
Neighbourobj = neighbourBLLobj.GetNeighbrById(Pap_NeighbrID);
txtNeighbrID.Text = Neighbourobj.PAP_NEIGHBOURID1.ToString();
txtNeibrName.Text = Neighbourobj.TRN_PAP_NEIGHBOURNAme1.ToString();
ddldirectionDropDownList.ClearSelection();
if (ddldirectionDropDownList.Items.FindByValue(Neighbourobj.DIRECTION1.ToString()) != null)
{
ddldirectionDropDownList.Items.FindByValue(Neighbourobj.DIRECTION1.ToString()).Selected = true;
}
string RadioButtn = Neighbourobj.BOUNDARIESCONFIRMED1.ToString();
RadioButton1.Checked = false;
RadioButton2.Checked = false;
if (RadioButtn == "Yes")
{
RadioButton1.Checked = true;
}
else if (RadioButtn == "No")
{
RadioButton2.Checked = true;
}
rdoBoundaryDisputesYes.Checked = false;
rdoBoundaryDisputesNo.Checked = false;
if (Neighbourobj.BOUNDARY_DISPUTE.ToString().ToUpper() == "YES")
{
rdoBoundaryDisputesYes.Checked = true;
txtBoundaryDisputes.Text = Neighbourobj.DISPUTE_DETAILS.ToString();
ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowHideBoundaryDisputes", "ShowHideBoundaryDisputes(1);", true);
}
else if (Neighbourobj.BOUNDARY_DISPUTE.ToString().ToUpper() == "NO")
{
rdoBoundaryDisputesNo.Checked = true;
txtBoundaryDisputes.Text = Neighbourobj.DISPUTE_DETAILS.ToString();
ScriptManager.RegisterStartupScript(this, this.GetType(), "ShowHideBoundaryDisputes", "ShowHideBoundaryDisputes(0);", true);
}
}
/// <summary>
/// To Edit Neighbour
/// </summary>
/// <param name="Neighbourobj"></param>
/// <returns></returns>
public string EditNeighbr(NeighbourBO Neighbourobj)
{
NeighbourDAL NeighbourDALobj = new NeighbourDAL(); //Data pass -to Database Layer
try
{
return(NeighbourDALobj.EditNeighbr(Neighbourobj));
}
catch
{
throw;
}
finally
{
NeighbourDALobj = null;
}
}
/// <summary>
/// To Edit Neighbour
/// </summary>
/// <param name="Neighbourobj"></param>
/// <returns></returns>
public string EditNeighbr(NeighbourBO Neighbourobj)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
cnn.Open();
OracleCommand dcmd = new OracleCommand("USP_TRN_UPD_NEIGHBOUR", cnn);
dcmd.CommandType = CommandType.StoredProcedure;
string result = string.Empty;
try
{
dcmd.Parameters.Add("N_PAP_NEIGHBOURID", Neighbourobj.PAP_NEIGHBOURID1);
dcmd.Parameters.Add("N_NEIGHBOURNAME", Neighbourobj.TRN_PAP_NEIGHBOURNAme1);
dcmd.Parameters.Add("N_DIRECTION", Neighbourobj.DIRECTION1);
dcmd.Parameters.Add("N_BOUNDARIESCONFIRMED", Neighbourobj.BOUNDARIESCONFIRMED1);
dcmd.Parameters.Add("N_BOUNDARY_DISPUTE", Neighbourobj.BOUNDARY_DISPUTE);
dcmd.Parameters.Add("N_DISPUTE_DETAILS", Neighbourobj.DISPUTE_DETAILS);
dcmd.Parameters.Add("N_UPDATEDBY", Neighbourobj.CREATEDBY1);
dcmd.Parameters.Add("ERRORMESSAGE_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
dcmd.ExecuteNonQuery();
if (dcmd.Parameters["errorMessage_"].Value != null)
{
result = dcmd.Parameters["ERRORMESSAGE_"].Value.ToString();
}
}
catch
{
throw;
}
finally
{
dcmd.Dispose();
cnn.Close();
cnn.Dispose();
}
return(result);
}
/// <summary>
/// To Get Neighbour Details
/// </summary>
/// <param name="householdID"></param>
/// <returns></returns>
public NeighbourList GetneigbrDetails(int householdID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_TRN_SEL_NEIGHBOUR";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("HHID_", householdID);
cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
NeighbourBO Neighbourobj = null;
NeighbourList NeighbourListobj = new NeighbourList();
while (dr.Read())
{
Neighbourobj = new NeighbourBO();
Neighbourobj.PAP_NEIGHBOURID1 = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("PAP_NEIGHBOURID")));
Neighbourobj.TRN_PAP_NEIGHBOURNAme1 = dr.GetString(dr.GetOrdinal("NEIGHBOURNAME"));
Neighbourobj.ISDELETED1 = dr.GetString(dr.GetOrdinal("ISDELETED"));
Neighbourobj.DIRECTION1 = dr.GetString(dr.GetOrdinal("DIRECTION"));
Neighbourobj.BOUNDARIESCONFIRMED1 = dr.GetString(dr.GetOrdinal("BOUNDARIESCONFIRMED"));
Neighbourobj.BOUNDARY_DISPUTE = dr.GetString(dr.GetOrdinal("boundary_dispute"));
if (ColumnExists(dr, "dispute_details") && !dr.IsDBNull(dr.GetOrdinal("dispute_details")))
{
Neighbourobj.DISPUTE_DETAILS = dr.GetString(dr.GetOrdinal("dispute_details"));
}
NeighbourListobj.Add(Neighbourobj);
}
dr.Close();
return(NeighbourListobj);
}
/// <summary>
/// to save the data to the database and clear the data fields by calling clearfields() methods
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnSave_Click(object sender, EventArgs e)
{
string message = "";
bool dataUpdated = false;
ChangeRequestStatusNeighbours();
if (txtNeighbrID.Text.ToString().Trim() == string.Empty)
{
neighbourBLL neighbourBLLobj = new neighbourBLL();
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
NeighbourBO Neighbourobj = new NeighbourBO();
Neighbourobj.TRN_PAP_NEIGHBOURNAme1 = txtNeibrName.Text.ToString().Trim();
Neighbourobj.DIRECTION1 = ddldirectionDropDownList.SelectedItem.ToString().Trim();
if (RadioButton1.Checked == true)
{
Neighbourobj.BOUNDARIESCONFIRMED1 = RadioButton1.Text.ToString();
//RadioButton2.Checked = false;
}
else
{
Neighbourobj.BOUNDARIESCONFIRMED1 = RadioButton2.Text.ToString();
//RadioButton1.Checked = false;
}
if (rdoBoundaryDisputesYes.Checked == true)
{
Neighbourobj.BOUNDARY_DISPUTE = RadioButton1.Text.ToUpper();
if (txtBoundaryDisputes.Text.Length > 800)
{
Neighbourobj.DISPUTE_DETAILS = txtBoundaryDisputes.Text.Substring(0, 800);
}
else
{
Neighbourobj.DISPUTE_DETAILS = txtBoundaryDisputes.Text;
}
}
else
{
Neighbourobj.BOUNDARY_DISPUTE = RadioButton2.Text.ToUpper();
Neighbourobj.DISPUTE_DETAILS = "";
}
Neighbourobj.CREATEDBY1 = Convert.ToInt32(uID);
Neighbourobj.HHID1 = Convert.ToInt32(hhid);
neighbourBLL BLLobj = new neighbourBLL();
message = BLLobj.Insert(Neighbourobj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data saved successfully";
dataUpdated = true;
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
if (dataUpdated)
{
projectFrozen();
getApprrequtStatusNeighbours();
}
BindGrid();
clearfields();
}
catch (Exception ex)
{
throw ex;
}
finally
{
neighbourBLLobj = null;
}
}
else if (txtNeighbrID.Text.ToString().Trim() != string.Empty)
{
neighbourBLL neighbourBLLobj = new neighbourBLL();
try
{
string uID = Session["USER_ID"].ToString();
string hhid = Session["HH_ID"].ToString();
NeighbourBO Neighbourobj = new NeighbourBO();
Neighbourobj.TRN_PAP_NEIGHBOURNAme1 = txtNeibrName.Text.ToString().Trim();
Neighbourobj.PAP_NEIGHBOURID1 = Convert.ToInt32(txtNeighbrID.Text.ToString().Trim());
Neighbourobj.DIRECTION1 = ddldirectionDropDownList.SelectedItem.ToString();
if (RadioButton1.Checked == true)
{
Neighbourobj.BOUNDARIESCONFIRMED1 = RadioButton1.Text.ToString();
//RadioButton2.Checked = false;
}
else
{
Neighbourobj.BOUNDARIESCONFIRMED1 = RadioButton2.Text.ToString();
//RadioButton1.Checked = false;
}
string radbtn = Neighbourobj.BOUNDARIESCONFIRMED1.ToString();
if (rdoBoundaryDisputesYes.Checked == true)
{
Neighbourobj.BOUNDARY_DISPUTE = RadioButton1.Text.ToUpper();
Neighbourobj.DISPUTE_DETAILS = txtBoundaryDisputes.Text;
}
else
{
Neighbourobj.BOUNDARY_DISPUTE = RadioButton2.Text.ToUpper();
Neighbourobj.DISPUTE_DETAILS = "";
}
Neighbourobj.BOUNDARIESCONFIRMED1 = radbtn.ToString();
Neighbourobj.CREATEDBY1 = Convert.ToInt32(uID);
Neighbourobj.HHID1 = Convert.ToInt32(hhid);
neighbourBLL BLLobj = new neighbourBLL();
message = BLLobj.EditNeighbr(Neighbourobj);
if (string.IsNullOrEmpty(message) || message == "" || message == "null")
{
message = "Data updated successfully";
dataUpdated = true;
}
if (message != "")
{
ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true);
}
if (dataUpdated)
{
projectFrozen();
getApprrequtStatusNeighbours();
}
SetUpdateMode(false);
BindGrid();
clearfields();
}
catch (Exception ex)
{
throw ex;
}
finally
{
neighbourBLLobj = null;
}
}
}
