/// <summary>
/// To Get school Drop Reason
/// </summary>
/// <returns></returns>
public SchoolDropReasonList GetschoolDropReason()
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = " USP_MST_GETSCHOOLDROPREASON";
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);
SchoolDropReasonBO objUser = null;
SchoolDropReasonList ReasonList = new SchoolDropReasonList();
while (dr.Read())
{
objUser = new SchoolDropReasonBO();
if (!dr.IsDBNull(dr.GetOrdinal("SCH_DRP_REASONID")))
{
objUser.SchooldropreasonID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("SCH_DRP_REASONID")));
}
if (!dr.IsDBNull(dr.GetOrdinal("SCH_DRP_REASON")))
{
objUser.Schooldropreason = dr.GetString(dr.GetOrdinal("SCH_DRP_REASON"));
}
ReasonList.Add(objUser);
}
dr.Close();
return(ReasonList);
}
/// <summary>
/// To Get school Drop Reason by ID
/// </summary>
/// <param name="SchooldropreasonID"></param>
/// <returns></returns>
public SchoolDropReasonBO GetschoolDropReasonbyID(int SchooldropreasonID)
{
OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString);
OracleCommand cmd;
string proc = "USP_MST_GET_SCHOOLDROPBYID";
cmd = new OracleCommand(proc, cnn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("p_SCH_DRP_REASONID", SchooldropreasonID);
cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output;
cmd.Connection.Open();
OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
SchoolDropReasonBO SchoolDropReasonBOobj = null;
SchoolDropReasonList Users = new SchoolDropReasonList();
SchoolDropReasonBOobj = new SchoolDropReasonBO();
while (dr.Read())
{
if (ColumnExists(dr, "SCH_DRP_REASON") && !dr.IsDBNull(dr.GetOrdinal("SCH_DRP_REASON")))
{
SchoolDropReasonBOobj.Schooldropreason = dr.GetString(dr.GetOrdinal("SCH_DRP_REASON"));
}
if (ColumnExists(dr, "DESCRIPTION") && !dr.IsDBNull(dr.GetOrdinal("DESCRIPTION")))
{
SchoolDropReasonBOobj.Description = dr.GetString(dr.GetOrdinal("DESCRIPTION"));
}
if (ColumnExists(dr, "SCH_DRP_REASONID") && !dr.IsDBNull(dr.GetOrdinal("SCH_DRP_REASONID")))
{
SchoolDropReasonBOobj.SchooldropreasonID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("SCH_DRP_REASONID")));
}
}
dr.Close();
return(SchoolDropReasonBOobj);
}
