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