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