/// <summary> /// calls method save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { CurrentSchoolStatusBO CurrentSchoolStatusBOObj = new CurrentSchoolStatusBO(); CurrentSchoolStatusBOObj.CurrentSchoolStatus = txtCurrSchlStatus.Text.ToString().Trim(); CurrentSchoolStatusBOObj.Description = txtDescription.Text.ToString().Trim(); SaveDetails(CurrentSchoolStatusBOObj); BindGrid(); }
/// <summary> /// To fetch currentschool status and asssign to textbox /// </summary> private void GetCurSchlStatusDetails() { CurrentSchoolStatusBLL CurrentSchoolStatusBLLObj = new CurrentSchoolStatusBLL(); int CurrentSchoolStatusID = 0; if (ViewState["CurrentSchoolStatusID"] != null) { CurrentSchoolStatusID = Convert.ToInt32(ViewState["CurrentSchoolStatusID"].ToString()); } CurrentSchoolStatusBO CurrentSchoolStatusBOObj = CurrentSchoolStatusBLLObj.GetCurSchlStatusById(CurrentSchoolStatusID); txtCurrSchlStatus.Text = CurrentSchoolStatusBOObj.CurrentSchoolStatus; txtDescription.Text = CurrentSchoolStatusBOObj.Description; txtCurrSchlStatusID.Text = CurrentSchoolStatusBOObj.CurrentSchoolStatusID.ToString(); }
/// <summary> /// To fetch all details from database /// </summary> /// <returns></returns> public SchoolStatusList GetAllSchoolDetails() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETSCHOOLSTATUSALL"; 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); CurrentSchoolStatusBO CurSchStatusObj = null; SchoolStatusList CurSchStatusListObj = new SchoolStatusList(); CurSchStatusObj = new CurrentSchoolStatusBO(); while (dr.Read()) { CurSchStatusObj = new CurrentSchoolStatusBO(); if (!dr.IsDBNull(dr.GetOrdinal("CUR_SCH_STATUSID"))) { CurSchStatusObj.CurrentSchoolStatusID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CUR_SCH_STATUSID"))); } if (!dr.IsDBNull(dr.GetOrdinal("CUR_SCH_STATUS"))) { CurSchStatusObj.CurrentSchoolStatus = dr.GetString(dr.GetOrdinal("CUR_SCH_STATUS")); } if (!dr.IsDBNull(dr.GetOrdinal("DESCRIPTION"))) { CurSchStatusObj.Description = dr.GetString(dr.GetOrdinal("DESCRIPTION")); } if (!dr.IsDBNull(dr.GetOrdinal("ISDELETED"))) { CurSchStatusObj.Isdeleted = dr.GetString(dr.GetOrdinal("ISDELETED")); } CurSchStatusListObj.Add(CurSchStatusObj); } dr.Close(); return(CurSchStatusListObj); }
/// <summary> /// To update details to database /// </summary> /// <param name="CurrentSchoolStatusBOObj"></param> /// <param name="EditCurSchStatusID"></param> /// <returns></returns> public string EditCurSchStatus(CurrentSchoolStatusBO CurrentSchoolStatusBOObj, int EditCurSchStatusID) { string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDATESCHOOLSTATUS", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("S_CUR_SCH_STATUSID", EditCurSchStatusID); dcmd.Parameters.Add("S_CUR_SCH_STATUS", CurrentSchoolStatusBOObj.CurrentSchoolStatus); dcmd.Parameters.Add("S_DESCRIPTION", CurrentSchoolStatusBOObj.Description); dcmd.Parameters.Add("S_UPDATEDBY", CurrentSchoolStatusBOObj.Createdby); 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 data to database /// </summary> /// <param name="CurrentSchoolStatusBOObj"></param> /// <returns></returns> public string InsertSchoolStatusDetails(CurrentSchoolStatusBO CurrentSchoolStatusBOObj) { string returnResult = string.Empty; OracleConnection Con = new OracleConnection(AppConfiguration.ConnectionString); Con.Open(); OracleCommand cmd = new OracleCommand("USP_MST_INSERTSCHOOLSTATUS", Con); cmd.CommandType = CommandType.StoredProcedure; int Count = Convert.ToInt32(cmd.CommandType); try { cmd.Parameters.Add("S_CUR_SCH_STATUS", CurrentSchoolStatusBOObj.CurrentSchoolStatus); cmd.Parameters.Add("S_DESCRIPTION", CurrentSchoolStatusBOObj.Description); cmd.Parameters.Add("S_CREATEDBY", CurrentSchoolStatusBOObj.Createdby); cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; cmd.ExecuteNonQuery(); if (cmd.Parameters["errorMessage_"].Value != null) { returnResult = cmd.Parameters["errorMessage_"].Value.ToString(); } else { returnResult = string.Empty; } } catch { throw; } finally { cmd.Dispose(); Con.Close(); Con.Dispose(); } return(returnResult); }
/// <summary> /// To fetch details based on ID /// </summary> /// <param name="CurrentSchoolStatusID"></param> /// <returns></returns> public CurrentSchoolStatusBO GetCurSchlStatusById(int CurrentSchoolStatusID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SELECTCURSCHSTATUS"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("S_CUR_SCH_STATUSID", CurrentSchoolStatusID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); CurrentSchoolStatusBO CurSchStatusObj = null; SchoolStatusList CurSchStatusListObj = new SchoolStatusList(); CurSchStatusObj = new CurrentSchoolStatusBO(); while (dr.Read()) { if (ColumnExists(dr, "CUR_SCH_STATUSID") && !dr.IsDBNull(dr.GetOrdinal("CUR_SCH_STATUSID"))) { CurSchStatusObj.CurrentSchoolStatusID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CUR_SCH_STATUSID"))); } if (ColumnExists(dr, "CUR_SCH_STATUS") && !dr.IsDBNull(dr.GetOrdinal("CUR_SCH_STATUS"))) { CurSchStatusObj.CurrentSchoolStatus = dr.GetString(dr.GetOrdinal("CUR_SCH_STATUS")); } if (ColumnExists(dr, "DESCRIPTION") && !dr.IsDBNull(dr.GetOrdinal("DESCRIPTION"))) { CurSchStatusObj.Description = dr.GetString(dr.GetOrdinal("DESCRIPTION")); } } dr.Close(); return(CurSchStatusObj); }
/// <summary> /// To save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SaveDetails(CurrentSchoolStatusBO CurrentSchoolStatusBOObj) { //int count = 0; string AlertMessage = string.Empty; string message = string.Empty; try { if (txtCurrSchlStatusID.Text.ToString().Trim() == string.Empty) { try { CurrentSchoolStatusBLL CurrentSchoolStatusBLLObj = new CurrentSchoolStatusBLL(); CurrentSchoolStatusBOObj = new CurrentSchoolStatusBO(); CurrentSchoolStatusBOObj.CurrentSchoolStatus = txtCurrSchlStatus.Text.ToString().Trim(); string sDes = ""; if (txtDescription.Text.ToString().Trim().Length > 100) { sDes = txtDescription.Text.ToString().Trim().Substring(0, 100); } else { sDes = txtDescription.Text.ToString().Trim(); } CurrentSchoolStatusBOObj.Description = sDes; CurrentSchoolStatusBOObj.CurrentSchoolStatusID = Convert.ToInt32(ViewState["CurrentSchoolStatusID"]); CurrentSchoolStatusBOObj.Createdby = Convert.ToInt32(Session["USER_ID"]); message = CurrentSchoolStatusBLLObj.InsertSchoolStatusDetails(CurrentSchoolStatusBOObj); AlertMessage = "alert('" + message + "');"; if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; BindGrid(); ClearDetails(); } } catch (Exception ex) { throw ex; } } else //if (Convert.ToInt32(ViewState["CurrentSchoolStatusID"]) != 0) { CurrentSchoolStatusBLL CurrentSchoolStatusBLLObj = new CurrentSchoolStatusBLL(); CurrentSchoolStatusBOObj = new CurrentSchoolStatusBO(); int EditCurSchStatusID = Convert.ToInt32(ViewState["CurrentSchoolStatusID"]); CurrentSchoolStatusBOObj.CurrentSchoolStatus = txtCurrSchlStatus.Text.ToString().Trim(); string sDes = ""; if (txtDescription.Text.ToString().Trim().Length > 100) { sDes = txtDescription.Text.ToString().Trim().Substring(0, 100); } else { sDes = txtDescription.Text.ToString().Trim(); } CurrentSchoolStatusBOObj.Description = sDes; CurrentSchoolStatusBOObj.CurrentSchoolStatusID = Convert.ToInt32(ViewState["CurrentSchoolStatusID"]); CurrentSchoolStatusBOObj.Createdby = Convert.ToInt32(Session["USER_ID"]); message = CurrentSchoolStatusBLLObj.EditCurSchStatus(CurrentSchoolStatusBOObj, EditCurSchStatusID); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; BindGrid(); ClearDetails(); SetUpdateMode(false); } } } catch (Exception ex) { throw ex; } finally { CurrentSchoolStatusBOObj = null; } ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", "alert('" + message + "');", true); }
/// <summary> /// To Edit Current School Status /// </summary> /// <param name="CurrentSchoolStatusBOObj"></param> /// <param name="EditCurSchStatusID"></param> /// <returns></returns> public string EditCurSchStatus(CurrentSchoolStatusBO CurrentSchoolStatusBOObj, int EditCurSchStatusID) { CurrentSchoolStatusDAL CurrentSchoolStatusDALObj = new CurrentSchoolStatusDAL(); return(CurrentSchoolStatusDALObj.EditCurSchStatus(CurrentSchoolStatusBOObj, EditCurSchStatusID)); }
/// <summary> /// To Insert School Status Details /// </summary> /// <param name="CurrentSchoolStatusBOObj"></param> /// <returns></returns> public string InsertSchoolStatusDetails(CurrentSchoolStatusBO CurrentSchoolStatusBOObj) { CurrentSchoolStatusDAL CurrentSchoolStatusDALObj = new CurrentSchoolStatusDAL(); return(CurrentSchoolStatusDALObj.InsertSchoolStatusDetails(CurrentSchoolStatusBOObj)); }