/// <summary> /// To GET ALL CONCERN /// </summary> /// <returns></returns> public OptionAvailableList GetAllOptionAvail() { // used in Master page OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = " USP_MST_GETALLOPTIONAVAIL"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); OptionAvailableBO objOptionAvailableBO = null; OptionAvailableList lstooptionavail = new OptionAvailableList(); while (dr.Read()) { objOptionAvailableBO = new OptionAvailableBO(); objOptionAvailableBO.ID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ID"))); objOptionAvailableBO.OptionAvailable = dr.GetString(dr.GetOrdinal("OPTIONAVAILABLE")); objOptionAvailableBO.Isdeleted = dr.GetString(dr.GetOrdinal("isdeleted")); lstooptionavail.Add(objOptionAvailableBO); } dr.Close(); return(lstooptionavail); }
/// <summary> /// get the data based on ID /// </summary> /// <param name="ConcernID"></param> /// <returns></returns> public OptionAvailableBO GetAllOptionById(int optionID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETOPTNBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("ID_", optionID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); OptionAvailableBO objoptionavail = null; OptionAvailableList Users = new OptionAvailableList(); objoptionavail = new OptionAvailableBO(); while (dr.Read()) { if (ColumnExists(dr, "OPTIONAVAILABLE") && !dr.IsDBNull(dr.GetOrdinal("OPTIONAVAILABLE"))) { objoptionavail.OptionAvailable = dr.GetString(dr.GetOrdinal("OPTIONAVAILABLE")); } if (ColumnExists(dr, "ID") && !dr.IsDBNull(dr.GetOrdinal("ID"))) { objoptionavail.ID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("ID"))); } } dr.Close(); return(objoptionavail); }
private void GetConcernDetails(int ConcernID) { OptionAvailableBLL optionavailobj = new OptionAvailableBLL(); OptionAvailableBO optionavailbo = new OptionAvailableBO(); optionavailbo = optionavailobj.GetAllOptionById(ConcernID); OptionAvailableTextBox.Text = optionavailbo.OptionAvailable; OptionAvailableIDTextBox.Text = optionavailbo.ID.ToString(); }
//Edit the data public string editoptionavail(OptionAvailableBO objoptionbo) { OptionAvailableDAL Objoptionavail = new OptionAvailableDAL(); //Data pass -to Database Layer try { return(Objoptionavail.editoptionavail(objoptionbo)); } catch { throw; } finally { Objoptionavail = null; } }
/// <summary> /// To update data to database /// </summary> /// <param name="objConcern"></param> /// <returns></returns> public string editoptionavail(OptionAvailableBO objoptionavail) { string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDATEALLOPTIONAVAIL", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("OPTIONAVAILABLE_", objoptionavail.OptionAvailable); dcmd.Parameters.Add("ID_", objoptionavail.ID); dcmd.Parameters.Add("UpdatedBY", objoptionavail.UserID); //return dcmd.ExecuteNonQuery(); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; dcmd.ExecuteNonQuery(); if (dcmd.Parameters["errorMessage_"].Value != null) { returnResult = dcmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } } catch { throw; } finally { dcmd.Dispose(); cnn.Close(); cnn.Dispose(); } return(returnResult); }
protected void SaveButton_Click(object sender, EventArgs e) { string AlertMessage = string.Empty; string message = string.Empty; if (OptionAvailableIDTextBox.Text.ToString().Trim() == string.Empty) { OptionAvailableBLL optionavailsal = new OptionAvailableBLL(); try { string uID = Session["USER_ID"].ToString(); OptionAvailableBO objOptionAvailable = new OptionAvailableBO(); objOptionAvailable.OptionAvailable = OptionAvailableTextBox.Text.ToString().Trim();; objOptionAvailable.UserID = Convert.ToInt32(uID); optionavailsal = new OptionAvailableBLL(); message = optionavailsal.Insert(objOptionAvailable); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; clear(); // ClearDetails(); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { optionavailsal = null; } } //edit the data in the textbox exiting in the Grid else if (OptionAvailableIDTextBox.Text.ToString().Trim() != string.Empty) { OptionAvailableBLL optionavailsal = new OptionAvailableBLL(); try { string uID = Session["USER_ID"].ToString(); OptionAvailableBO objoptionavail = new OptionAvailableBO(); objoptionavail.OptionAvailable = OptionAvailableTextBox.Text.ToString().Trim(); objoptionavail.ID = Convert.ToInt32(OptionAvailableIDTextBox.Text.ToString().Trim()); objoptionavail.UserID = Convert.ToInt32(uID); optionavailsal = new OptionAvailableBLL(); message = optionavailsal.editoptionavail(objoptionavail); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; // ClearDetails(); clear(); SetUpdateMode(false); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { optionavailsal = null; } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }