/// <summary> /// To Get School Details /// </summary> /// <returns></returns> public object GetSchoolDetails() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_SUPPORT"; 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); SocialSupportBO SocialSupportBOObj = null; SocialSupportList SocialSupportListObj = new SocialSupportList(); SocialSupportBOObj = new SocialSupportBO(); while (dr.Read()) { SocialSupportBOObj = new SocialSupportBO(); SocialSupportBOObj.SUPPORTEDBYID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("SUPPORTID"))); SocialSupportBOObj.SupportedBy = dr.GetString(dr.GetOrdinal("SUPPORTEDBY")); //SocialSupportBOObj.IsDeletedBy = dr.GetString(dr.GetOrdinal("ISDELETED")); SocialSupportListObj.Add(SocialSupportBOObj); } dr.Close(); return(SocialSupportListObj); }
/// <summary> /// calls SaveDetails to save details to the database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void SaveButton_Click(object sender, EventArgs e) { SocialSupportBO SocialSupportBOObj = new SocialSupportBO(); SocialSupportBOObj.SupportedBy = txtSupportedBy.Text.ToString().Trim(); SaveDetails(SocialSupportBOObj); //ClearDetials(); }
/// <summary> /// To Edit Support Details /// </summary> /// <param name="SocialSupportBOObj"></param> /// <param name="SUPPORTEDBYID"></param> /// <returns></returns> public string EditSupportDetails(SocialSupportBO SocialSupportBOObj, int SUPPORTEDBYID) { string returnResult = string.Empty; OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); cnn.Open(); OracleCommand dcmd = new OracleCommand("USP_MST_UPDATE_SUPPORTEDBY", cnn); dcmd.CommandType = CommandType.StoredProcedure; int count = Convert.ToInt32(dcmd.CommandType); try { dcmd.Parameters.Add("B_SUPPORTID", SUPPORTEDBYID); dcmd.Parameters.Add("B_UPDATEDBY", SocialSupportBOObj.SupportedBy); dcmd.Parameters.Add("B_UPDATEDBY", SocialSupportBOObj.CreatedBy); dcmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; //return dcmd.ExecuteNonQuery(); 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 Insert Support Details /// </summary> /// <param name="SocialSupportBOObj"></param> /// <returns></returns> public string InsertSupportDetails(SocialSupportBO SocialSupportBOObj) { string returnResult = string.Empty; OracleConnection Con = new OracleConnection(ConStr); Con.Open(); OracleCommand cmd = new OracleCommand("USP_MST_INSERT_SUPPORT", Con); cmd.CommandType = CommandType.StoredProcedure; int Count = Convert.ToInt32(cmd.CommandType); try { cmd.Parameters.Add("S_SUPPORTEDBY", SocialSupportBOObj.SupportedBy); cmd.Parameters.Add("S_CREATEDBY", SocialSupportBOObj.CreatedBy); cmd.Parameters.Add("errorMessage_", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output; //return cmd.ExecuteNonQuery(); 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 from database and assign to textbox /// </summary> private void GetSupportDeatails() { SocialSupportBLL SocialSupportBLLObj = new SocialSupportBLL(); SocialSupportBO SocialSupportBOObj = new SocialSupportBO(); int SUPPORTEDBYID = 0; if (ViewState["SUPPORTEDBYID"] != null) { SUPPORTEDBYID = Convert.ToInt32(ViewState["SUPPORTEDBYID"].ToString()); } SocialSupportBOObj = new SocialSupportBO(); SchoolStatusList SchoolStatusListobj = new SchoolStatusList(); SocialSupportBOObj = SocialSupportBLLObj.GetSupportById(SUPPORTEDBYID); txtSupportedBy.Text = SocialSupportBOObj.SupportedBy; txtSupportedByID.Text = SocialSupportBOObj.SUPPORTEDBYID.ToString(); }
/// <summary> /// To Get Support By Id /// </summary> /// <param name="SUPPORTEDBYID"></param> /// <returns></returns> public SocialSupportBO GetSupportById(int SUPPORTEDBYID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_SEL_SUPPORT "; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("B_SUPPORTID", SUPPORTEDBYID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); SocialSupportBO SocialSupportBOObj = null; SocialSupportList SocialSupportListObj = new SocialSupportList(); SocialSupportBOObj = new SocialSupportBO(); while (dr.Read()) { if (ColumnExists(dr, "SUPPORTID") && !dr.IsDBNull(dr.GetOrdinal("SUPPORTID"))) { SocialSupportBOObj.SUPPORTEDBYID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("SUPPORTID"))); } if (ColumnExists(dr, "SUPPORTEDBY") && !dr.IsDBNull(dr.GetOrdinal("SUPPORTEDBY"))) { SocialSupportBOObj.SupportedBy = dr.GetString(dr.GetOrdinal("SUPPORTEDBY")); } } dr.Close(); return(SocialSupportBOObj); }
/// <summary> /// To save details to database /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void SaveDetails(SocialSupportBO SocialSupportBOObj) { string AlertMessage = string.Empty; string message = string.Empty; if (txtSupportedByID.Text.ToString().Trim() == string.Empty) { try { SocialSupportBOObj = new SocialSupportBO(); SocialSupportBLL SocialSupportBLLObj = new SocialSupportBLL(); SocialSupportBOObj.SupportedBy = txtSupportedBy.Text.ToString().Trim(); SocialSupportBOObj.SUPPORTEDBYID = Convert.ToInt32(ViewState["SUPPORTEDBYID"]); SocialSupportBOObj.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString()); message = SocialSupportBLLObj.InsertSupportDetails(SocialSupportBOObj); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data saved successfully"; ClearDetials(); BindGrid(true, true); } } catch (Exception ex) { throw ex; } } else { try { SocialSupportBOObj = new SocialSupportBO(); SocialSupportBLL SocialSupportBLLObj = new SocialSupportBLL(); SocialSupportBOObj.SupportedBy = txtSupportedBy.Text.ToString().Trim(); int SUPPORTEDBYID = Convert.ToInt32(ViewState["SUPPORTEDBYID"]); SocialSupportBOObj.CreatedBy = Convert.ToInt32(Session["USER_ID"].ToString()); message = SocialSupportBLLObj.EditSupportDetails(SocialSupportBOObj, SUPPORTEDBYID); if (string.IsNullOrEmpty(message) || message == "" || message == "null") { message = "Data updated successfully"; ClearDetials(); BindGrid(true, true); SetUpdateMode(false); } } catch (Exception ex) { throw ex; } finally { SocialSupportBOObj = null; } } AlertMessage = "alert('" + message + "');"; ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "Added", AlertMessage, true); }
/// <summary> /// To Edit Support Details /// </summary> /// <param name="SocialSupportBOObj"></param> /// <param name="SUPPORTEDBYID"></param> /// <returns></returns> public string EditSupportDetails(SocialSupportBO SocialSupportBOObj, int SUPPORTEDBYID) { SocialSupportDAL SocialSupportDALObj = new SocialSupportDAL(); return(SocialSupportDALObj.EditSupportDetails(SocialSupportBOObj, SUPPORTEDBYID)); }
/// <summary> /// To Insert Support Details /// </summary> /// <param name="SocialSupportBOObj"></param> /// <returns></returns> public string InsertSupportDetails(SocialSupportBO SocialSupportBOObj) { SocialSupportDAL SocialSupportDALObj = new SocialSupportDAL(); return(SocialSupportDALObj.InsertSupportDetails(SocialSupportBOObj)); }