/// <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); }
//To get Helped most from the table MST_SUPPORT public void Gethelpedmost() { string SUPPORTID = string.Empty; if (helpedDropDownList.SelectedValue.ToString() == "") { SUPPORTID = "0"; //msgSaveLabel.Text = null; // if value is select then error msg will display } else { // SHOCKID = typeofshockDropDownList.SelectedValue.ToString(); // get UI screen Value DataSet Ds = new DataSet(); // MajorshockBLL help_BLL = new MajorshockBLL(); // Function or object creation for next layer SocialSupportBLL help_BLL = new SocialSupportBLL(); objSocialSupportList = new SocialSupportList(); // Ds = help_BLL.Gethelp(SUPPORTID); // data pass through object SHOCKID objSocialSupportList = (SocialSupportList)help_BLL.GetSchoolDetails(); try { // if (Ds.Tables[0].Rows.Count > 0) // Data from BLL if (objSocialSupportList.Count > 0) { helpedDropDownList.DataSource = objSocialSupportList; // helpedDropDownList.DataTextField = Ds.Tables[0].Columns[1].ToString(); //helpedDropDownList.DataValueField = Ds.Tables[0].Columns[0].ToString(); helpedDropDownList.DataTextField = "SupportedBy"; helpedDropDownList.DataValueField = "SUPPORTEDBYID"; helpedDropDownList.DataBind(); // helpedDropDownList.Items.Insert(0, "--Select--"); } } catch (Exception ee) { throw ee; } finally // set the finally class nothing but Empty the object { help_BLL = null; } } }
/// <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); }