/// <summary> /// To Get Consultant Type /// </summary> /// <returns></returns> public ConsultantTypeList GetConsultantType() { OracleConnection con = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_CONSULTANT"; cmd = new OracleCommand(proc, con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ConsultantTypeBO objTypeBO = null; ConsultantTypeList objConsultantTypes = new ConsultantTypeList(); while (dr.Read()) { objTypeBO = new ConsultantTypeBO(); objTypeBO.ConsultantTypeID = dr.GetInt32(dr.GetOrdinal("CONSULTANTTYPEID")); objTypeBO.ConsultantType = dr.GetString(dr.GetOrdinal("CONSULTANTTYPE")); objConsultantTypes.Add(objTypeBO); } dr.Close(); return(objConsultantTypes); }
//get the data in mst_Concern table using USP_MST_GETSELECTCONCERN-SP signal Data based on ID public ConsultantTypeBO GetConsultantTypeId(int consultantTypeID) { OracleConnection cnn = new OracleConnection(AppConfiguration.ConnectionString); OracleCommand cmd; string proc = "USP_MST_GET_CONSULTANTTYPE"; cmd = new OracleCommand(proc, cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("c_consultanttype", consultantTypeID); cmd.Parameters.Add("Sp_recordset", OracleDbType.RefCursor).Direction = ParameterDirection.Output; cmd.Connection.Open(); OracleDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection); ConsultantTypeBO objconsultantType = null; ConsultantTypeList Users = new ConsultantTypeList(); objconsultantType = new ConsultantTypeBO(); while (dr.Read()) { if (ColumnExists(dr, "CONSULTANTTYPE") && !dr.IsDBNull(dr.GetOrdinal("CONSULTANTTYPE"))) { objconsultantType.ConsultantType = dr.GetString(dr.GetOrdinal("CONSULTANTTYPE")); } if (ColumnExists(dr, "CONSULTANTTYPEID") && !dr.IsDBNull(dr.GetOrdinal("CONSULTANTTYPEID"))) { objconsultantType.ConsultantTypeID = Convert.ToInt32(dr.GetValue(dr.GetOrdinal("CONSULTANTTYPEID"))); } } dr.Close(); return(objconsultantType); }