/// <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);
}
