/// <summary> /// To Get Occupation /// </summary> /// <returns></returns> public OccupationList GetOccupation() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SELECTOCCUPATION"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); OccupationBO objOccupation = null; OccupationList OccupationList = new OccupationList(); while (dr.Read()) { objOccupation = new OccupationBO(); objOccupation.OCCUPATIONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("OCCUPATIONID"))); objOccupation.OCCUPATIONNAME = dr.GetString(dr.GetOrdinal("OCCUPATIONNAME")); // objOccupation.OCCUPATIONIsDeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); OccupationList.Add(objOccupation); } dr.Close(); return(OccupationList); }
/// <summary> /// To Get Occupation Id /// </summary> /// <param name="OCCUPATIONID"></param> /// <returns></returns> public OccupationBO GetOccupationId(int OCCUPATIONID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETOCCUPATIONBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("OCCUPATIONID_", OCCUPATIONID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); OccupationBO OccupationObj = null; OccupationList OccupationList = new OccupationList(); OccupationObj = new OccupationBO(); while (dr.Read()) { if (ColumnExists(dr, "OCCUPATIONNAME") && !dr.IsDBNull(dr.GetOrdinal("OCCUPATIONNAME"))) { OccupationObj.OCCUPATIONNAME = dr.GetString(dr.GetOrdinal("OCCUPATIONNAME")); } if (ColumnExists(dr, "OCCUPATIONID") && !dr.IsDBNull(dr.GetOrdinal("OCCUPATIONID"))) { OccupationObj.OCCUPATIONID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("OCCUPATIONID"))); } } dr.Close(); return(OccupationObj); }
/// <summary> /// To EDIT Occupation /// </summary> /// <param name="objOccupation"></param> /// <returns></returns> public string EDITOccupation(OccupationBO objOccupation) { OccupationDAL OccupationDAL = new OccupationDAL(); //Data pass -to Database Layer try { return(OccupationDAL.EDITOccupation(objOccupation)); } catch { throw; } finally { OccupationDAL = null; } }
/// <summary> /// get the Grid value into textBox /// </summary> private void GetOCCUPATIONDetails() { OccupationBLL OccupationBLLobj = new OccupationBLL(); int OCCUPATIONID = 0; if (ViewState["OCCUPATIONID"] != null) { OCCUPATIONID = Convert.ToInt32(ViewState["OCCUPATIONID"]); } OccupationBO OccupationObj = new OccupationBO(); OccupationObj = OccupationBLLobj.GetOccupationId(OCCUPATIONID); MainOccupationTextBox.Text = OccupationObj.OCCUPATIONNAME; MainOccupationIDTextBox.Text = OccupationObj.OCCUPATIONID.ToString(); //int ConcernID_test = Convert.ToInt32(ConcernObj.ConcernID); }
/// <summary> /// To EDIT Occupation /// </summary> /// <param name="objOccupation"></param> /// <returns></returns> public string EDITOccupation(OccupationBO objOccupation) { string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDATEOCCUPATION", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("OCCUPATIONNAME_", objOccupation.OCCUPATIONNAME); dcmd.Parameters.Add("OCCUPATIONID_", objOccupation.OCCUPATIONID); dcmd.Parameters.Add("UpdatedBY", objOccupation.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> /// To save details 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 (MainOccupationTextBox.Text.ToString().Trim() == string.Empty) { //errMsgMainOccupationLabel.Text = "Enter the Concern"; } else if (MainOccupationIDTextBox.Text.ToString().Trim() == string.Empty) { OccupationBLL OccupationBLLOBJ = new OccupationBLL(); try { string uID = Session["USER_ID"].ToString(); OccupationBO objOccupation = new OccupationBO(); objOccupation.OCCUPATIONNAME = MainOccupationTextBox.Text.ToString().Trim(); objOccupation.UserID = Convert.ToInt32(uID); OccupationBLL OccupationBLLobj = new OccupationBLL(); message = OccupationBLLobj.Insert(objOccupation); //if (count == -1) //{ // msgSaveLabel.Text = "Data saved successfully"; //messageSaveLable // BindGrid(true, true); //} //else //{ // msgSaveLabel.Text = "Data not saved successfully"; //} if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; AllClear(); // ClearDetails(); BindGrid(true, true); } } catch (Exception ex) { throw ex; } finally { OccupationBLLOBJ = null; } } //edit the data in the textbox exiting in the Grid else if (MainOccupationIDTextBox.Text.ToString().Trim() != string.Empty) { ConcernBLL concernBLLOBJ = new ConcernBLL(); try { string uID = Session["USER_ID"].ToString(); OccupationBO objOccupation = new OccupationBO(); objOccupation.OCCUPATIONNAME = MainOccupationTextBox.Text.ToString().Trim(); objOccupation.OCCUPATIONID = Convert.ToInt32(MainOccupationIDTextBox.Text.ToString().Trim()); objOccupation.UserID = Convert.ToInt32(uID); OccupationBLL OccupationBLLobj = new OccupationBLL(); message = OccupationBLLobj.EDITOccupation(objOccupation); //if (count == -1) //{ // msgSaveLabel.Text = "Data saved successfully"; //messageSaveLable // BindGrid(true, true); //} //else //{ // msgSaveLabel.Text = "Data not saved successfully"; //} if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; // ClearDetails(); AllClear(); BindGrid(true, true); SetUpdateMode(false); } } catch (Exception ex) { throw ex; } finally { concernBLLOBJ = null; } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }