/// <summary> /// To GET ALL CONCERN /// </summary> /// <returns></returns> public ConcernList GETALLCONCERN() { // used in Master page OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = " USP_MST_GETALLCONCERN"; 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); ConcernBO objConcern = null; ConcernList Concern = new ConcernList(); while (dr.Read()) { objConcern = new ConcernBO(); objConcern.ConcernID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CONCERNID"))); objConcern.ConcernName = dr.GetString(dr.GetOrdinal("CONCERN")); objConcern.Isdeleted = dr.GetString(dr.GetOrdinal("IsDeleted")); Concern.Add(objConcern); } dr.Close(); return(Concern); }
/// <summary> /// get the data based on ID /// </summary> /// <param name="ConcernID"></param> /// <returns></returns> public ConcernBO GetConcernById(int ConcernID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETSELECTCONCERN"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("ConcernID_", ConcernID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ConcernBO ConcernObj = null; ConcernList Users = new ConcernList(); ConcernObj = new ConcernBO(); while (dr.Read()) { if (ColumnExists(dr, "CONCERN") && !dr.IsDBNull(dr.GetOrdinal("CONCERN"))) { ConcernObj.ConcernName = dr.GetString(dr.GetOrdinal("CONCERN")); } if (ColumnExists(dr, "CONCERNID") && !dr.IsDBNull(dr.GetOrdinal("CONCERNID"))) { ConcernObj.ConcernID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CONCERNID"))); } } dr.Close(); return(ConcernObj); }
/// <summary> /// get the Grid value into textBox /// </summary> private void GetConcernDetails(int ConcernID) { ConcernBLL ConcernBLLobj = new ConcernBLL(); //int ConcernID = 0; //if (ViewState["CONCERNID"] != null) // ConcernID = Convert.ToInt32(ViewState["CONCERNID"]); ConcernBO ConcernObj = new ConcernBO(); ConcernObj = ConcernBLLobj.GetConcernById(ConcernID); ConcernTextBox.Text = ConcernObj.ConcernName; ConcernIDTextBox.Text = ConcernObj.ConcernID.ToString(); //int ConcernID_test = Convert.ToInt32(ConcernObj.ConcernID); }
//Edit the data public string EDITCONCERN(ConcernBO objConcern) { ConcerDAL concernDAl = new ConcerDAL(); //Data pass -to Database Layer try { return(concernDAl.EDITCONCERN(objConcern)); } catch { throw; } finally { concernDAl = null; } }
/// <summary> /// To update data to database /// </summary> /// <param name="objConcern"></param> /// <returns></returns> public string EDITCONCERN(ConcernBO objConcern) { string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDATECCONCERN", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("Concern_", objConcern.ConcernName); dcmd.Parameters.Add("ConcernID_", objConcern.ConcernID); dcmd.Parameters.Add("UpdatedBY", objConcern.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); }
/// <summary> /// save data to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { // int count = 0; string AlertMessage = string.Empty; string message = string.Empty; if (ConcernIDTextBox.Text.ToString().Trim() == string.Empty) { ConcernBLL concernBLLOBJ = new ConcernBLL(); try { string uID = Session["USER_ID"].ToString(); ConcernBO objConcern = new ConcernBO(); objConcern.ConcernName = ConcernTextBox.Text.ToString().Trim();; objConcern.UserID = Convert.ToInt32(uID); ConcernBLL ConcernBLLobj = new ConcernBLL(); message = ConcernBLLobj.Insert(objConcern); 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 { concernBLLOBJ = null; } } //edit the data in the textbox exiting in the Grid else if (ConcernIDTextBox.Text.ToString().Trim() != string.Empty) { ConcernBLL concernBLLOBJ = new ConcernBLL(); try { string uID = Session["USER_ID"].ToString(); ConcernBO objConcern = new ConcernBO(); objConcern.ConcernName = ConcernTextBox.Text.ToString().Trim(); objConcern.ConcernID = Convert.ToInt32(ConcernIDTextBox.Text.ToString().Trim()); objConcern.UserID = Convert.ToInt32(uID); ConcernBLL ConcernBLLobj = new ConcernBLL(); message = ConcernBLLobj.EDITCONCERN(objConcern); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; // ClearDetails(); clear(); SetUpdateMode(false); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { concernBLLOBJ = null; } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }