/// <summary> /// To Fetch Tribe List /// </summary> /// <returns></returns> public TribeList FetchTribeList() { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETTRIBEDETAILS"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", Oracle.DataAccess.Client.OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); TribeBO objTribeBO = null; TribeList TribeListObj = new TribeList(); while (dr.Read()) { objTribeBO = new TribeBO(); objTribeBO.TribeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("TRIBEID"))); objTribeBO.TribeName = dr.GetString(dr.GetOrdinal("TRIBENAME")); TribeListObj.Add(objTribeBO); } dr.Close(); return(TribeListObj); }
/// <summary> /// To Get Tribe By Id /// </summary> /// <param name="TribeID"></param> /// <returns></returns> public TribeBO GetTribeById(int TribeID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GETTRIBEDETAILSBYID"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("TrbID", TribeID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); TribeBO TribeBOObj = null; TribeList TribeListObj = new TribeList(); TribeBOObj = new TribeBO(); while (dr.Read()) { //if (ColumnExists(dr, "TRIBEID") && !dr.IsDBNull(dr.GetOrdinal("TRIBEID"))) // TribeBOObj.TribeID = Convert.ToInt32(dr.GetString(dr.GetOrdinal("TRIBEID"))); if (ColumnExists(dr, "TRIBENAME") && !dr.IsDBNull(dr.GetOrdinal("TRIBENAME"))) { TribeBOObj.TribeName = Convert.ToString(dr.GetValue(dr.GetOrdinal("TRIBENAME"))); } } dr.Close(); return(TribeBOObj); }