/// <summary> /// to save the data to the database /// call ClearDetails() to clear the Details Fields /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnSave_Click(object sender, EventArgs e) { objSurveyLandLivingOff = new LandLivingOffBO(); objSurveyBLL = new SurveyBLL(); try { objSurveyLandLivingOff.LivingOffID = Convert.ToInt32(ViewState["LIVINGOFFID"]); objSurveyLandLivingOff.HouseholdID = Convert.ToInt32(Session["HH_ID"]); objSurveyLandLivingOff.DwellingID = Convert.ToInt32(ddlDwelling.SelectedValue); objSurveyLandLivingOff.NoofRooms = txtNoRooms.Text.Trim(); objSurveyLandLivingOff.Str_TenureID = Convert.ToInt32(ddlTenureType.SelectedValue); objSurveyLandLivingOff.RoofID = Convert.ToInt32(ddlRoof.SelectedValue); objSurveyLandLivingOff.WallID = Convert.ToInt32(ddlWalls.SelectedValue); objSurveyLandLivingOff.FloorID = Convert.ToInt32(ddlFloor.SelectedValue); objSurveyLandLivingOff.UpdatedBy = Convert.ToInt32(Session["USER_ID"]); if (!string.IsNullOrEmpty(txttenure.Text)) { objSurveyLandLivingOff.Tenure = Convert.ToInt32(txttenure.Text); } else { objSurveyLandLivingOff.Tenure = 0; } int i = objSurveyBLL.AddLandLivingOFF(objSurveyLandLivingOff); if (btnSave.Text == "Save") { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('Data saved successfully');", true); } else { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "", "alert('Data updated successfully');", true); } ChangeRequestStatusLandInfoResOFF(); ClearDetails(); BindGrid(true, false); SetUpdateMode(false); projectFrozen(); } catch (Exception ex) { ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "AlertError", "alert('Error: " + ex.Message + "');", true); } }
/// <summary> /// For Edit and delete command /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void grdLandInfoRespondentsOff_RowCommand(object sender, GridViewCommandEventArgs e) { if (e.CommandName == "EditRow") { ViewState["LIVINGOFFID"] = e.CommandArgument; objSurveyBLL = new SurveyBLL(); objSurveyLandLivingOff = objSurveyBLL.GetLivingOFFByID(Convert.ToInt32(ViewState["LIVINGOFFID"])); //bindDDLDwelling(); //bindDDLTenure(); //bindDDLRoofs(); //bindDDLWall(); //bindDDLFloor(); ddlDwelling.ClearSelection(); if (ddlDwelling.Items.FindByValue(objSurveyLandLivingOff.DwellingID.ToString()) != null) { ddlDwelling.Items.FindByValue(objSurveyLandLivingOff.DwellingID.ToString()).Selected = true; } ddlTenureType.ClearSelection(); if (ddlTenureType.Items.FindByValue(objSurveyLandLivingOff.Str_TenureID.ToString()) != null) { ddlTenureType.Items.FindByValue(objSurveyLandLivingOff.Str_TenureID.ToString()).Selected = true; } ddlRoof.ClearSelection(); if (ddlRoof.Items.FindByValue(objSurveyLandLivingOff.RoofID.ToString()) != null) { ddlRoof.Items.FindByValue(objSurveyLandLivingOff.RoofID.ToString()).Selected = true; } ddlWalls.ClearSelection(); if (ddlWalls.Items.FindByValue(objSurveyLandLivingOff.WallID.ToString()) != null) { ddlWalls.Items.FindByValue(objSurveyLandLivingOff.WallID.ToString()).Selected = true; } ddlFloor.ClearSelection(); if (ddlFloor.Items.FindByValue(objSurveyLandLivingOff.FloorID.ToString()) != null) { ddlFloor.Items.FindByValue(objSurveyLandLivingOff.FloorID.ToString()).Selected = true; } txtNoRooms.Text = objSurveyLandLivingOff.NoofRooms; //ddlTenureType.ClearSelection(); //if (ddlTenureType.Items.FindByValue(objSurveyLandLivingOff.Str_Tenure.ToString()) != null) // ddlTenureType.Items.FindByValue(objSurveyLandLivingOff.Str_Tenure.ToString()).Selected = true; if (objSurveyLandLivingOff.Tenure > 0) { txttenure.Text = objSurveyLandLivingOff.Tenure.ToString(); } SetUpdateMode(true); } else if (e.CommandName == "DeleteRow") { int livingoffID = Convert.ToInt32(e.CommandArgument); objSurveyBLL = new SurveyBLL(); objSurveyBLL.DeleteLivingOFF(livingoffID); ClearDetails(); BindGrid(false, true); SetUpdateMode(false); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('Data deleted successfully');", true); } }
/// <summary> /// To Add Land Living OFF /// </summary> /// <param name="objSurveyLandLivingOff"></param> /// <returns></returns> public int AddLandLivingOFF(LandLivingOffBO objSurveyLandLivingOff) { int result = 0; OracleConnection myConnection; OracleCommand myCommand; myConnection = new OracleConnection(AppConfiguration.ConnectionString); myCommand = new OracleCommand("USP_TRN_UPD_LANDLIVINGOFF", myConnection); myCommand.Connection = myConnection; myCommand.CommandType = CommandType.StoredProcedure; myCommand.Parameters.Add("LIVINGOFFID_", objSurveyLandLivingOff.LivingOffID); myCommand.Parameters.Add("HHID_", objSurveyLandLivingOff.HouseholdID); myCommand.Parameters.Add("DWELLINGID_", objSurveyLandLivingOff.DwellingID); myCommand.Parameters.Add("NOOFROOMS_", objSurveyLandLivingOff.NoofRooms); if (objSurveyLandLivingOff.Str_TenureID > 0) { myCommand.Parameters.Add("STR_TENUREID_", objSurveyLandLivingOff.Str_TenureID); } else { myCommand.Parameters.Add("STR_TENUREID_", DBNull.Value); } if (objSurveyLandLivingOff.Tenure > 0) { myCommand.Parameters.Add("TENURE_", objSurveyLandLivingOff.Tenure); } else { myCommand.Parameters.Add("TENURE_", DBNull.Value); } if (objSurveyLandLivingOff.RoofID > 0) { myCommand.Parameters.Add("ROOFID_", objSurveyLandLivingOff.RoofID); } else { myCommand.Parameters.Add("ROOFID_", DBNull.Value); } if (objSurveyLandLivingOff.WallID > 0) { myCommand.Parameters.Add("WALLID_", objSurveyLandLivingOff.WallID); } else { myCommand.Parameters.Add("WALLID_", DBNull.Value); } if (objSurveyLandLivingOff.FloorID > 0) { myCommand.Parameters.Add("FLOORID_", objSurveyLandLivingOff.FloorID); } else { myCommand.Parameters.Add("FLOORID_", DBNull.Value); } myCommand.Parameters.Add("UPDATEDBY_", objSurveyLandLivingOff.UpdatedBy); myConnection.Open(); result = myCommand.ExecuteNonQuery(); myConnection.Close(); return(result); }
/// <summary> /// To Get Living OFF By ID /// </summary> /// <param name="LivingOffID"></param> /// <returns></returns> public LandLivingOffBO GetLivingOFFByID(int LivingOffID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_TRN_GET_LANDLIVINGONBYID"; LandLivingOffBO objLivingOff = null; //SurveyList.LandLivingOffList LandLivingOffLst = new SurveyList.LandLivingOffList(); cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("LIVINGOFFID_", LivingOffID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; try { cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); while (dr.Read()) { objLivingOff = new LandLivingOffBO(); if (!dr.IsDBNull(dr.GetOrdinal("LIVINGOFFID"))) { objLivingOff.LivingOffID = dr.GetInt32(dr.GetOrdinal("LIVINGOFFID")); } if (!dr.IsDBNull(dr.GetOrdinal("dwellingid"))) { objLivingOff.DwellingID = dr.GetInt32(dr.GetOrdinal("dwellingid")); } if (!dr.IsDBNull(dr.GetOrdinal("noofrooms"))) { objLivingOff.NoofRooms = dr.GetString(dr.GetOrdinal("noofrooms")); } if (!dr.IsDBNull(dr.GetOrdinal("str_tenureid"))) { objLivingOff.Str_TenureID = dr.GetInt32(dr.GetOrdinal("str_tenureid")); } // if (!dr.IsDBNull(dr.GetOrdinal("str_tenure"))) objLivingOff.Str_Tenure = dr.GetString(dr.GetOrdinal("str_tenure")); if (!dr.IsDBNull(dr.GetOrdinal("TENURE"))) { objLivingOff.Tenure = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("TENURE"))); } if (!dr.IsDBNull(dr.GetOrdinal("roofid"))) { objLivingOff.RoofID = dr.GetInt32(dr.GetOrdinal("roofid")); } if (!dr.IsDBNull(dr.GetOrdinal("wallid"))) { objLivingOff.WallID = dr.GetInt32(dr.GetOrdinal("wallid")); } if (!dr.IsDBNull(dr.GetOrdinal("floorid"))) { objLivingOff.FloorID = dr.GetInt32(dr.GetOrdinal("floorid")); } } dr.Close(); } catch (Exception ex) { throw ex; } return(objLivingOff); }
/// <summary> /// To Add Land Living OFF /// </summary> /// <param name="objSurveyLandLivingOff"></param> /// <returns></returns> public int AddLandLivingOFF(LandLivingOffBO objSurveyLandLivingOff) { SurveyDAL objAddLandLivingOFFDAL = new SurveyDAL(); return(objAddLandLivingOFFDAL.AddLandLivingOFF(objSurveyLandLivingOff)); }