public static List <Curso> searchCursos(Int64 pIdSucursal, string pText, Year pYear) { List <Curso> lista = new List <Curso>(); using (MySqlConnection _con = new Conexion().Conectar()) { try { _con.Open(); MySqlCommand comando = new MySqlCommand("select * from curso where IdSucursal=@pIdSucursal " + (pYear == null ? "" : " and IdYear=" + pYear.Id) + " and Upper(Nombre) like'%" + pText.ToUpper() + "%' and Estado ='A' order by Id desc", _con); comando.Parameters.AddWithValue("@pIdSucursal", pIdSucursal); MySqlDataReader _reader = comando.ExecuteReader(); while (_reader.Read()) { Curso item = new Curso( _reader.GetInt64(0), _reader.GetString(1), _reader.GetString(2), _reader.GetString(3), _reader.GetString(4), _reader.GetString(5), _reader.GetString(6), _reader.GetString(7), _reader.GetInt64(8), _reader.GetInt64(9), _reader.GetInt64(10), ContratoDAL.getContratoById(_reader.GetInt64(8)), YearDAL.getYearById(_reader.GetInt64(10)), DiasDAL.getDiasByIdCurso(_reader.GetInt64(0)), DetCursoDAL.getDetscursoByIdCurso(_reader.GetInt64(0)) ); lista.Add(item); } _reader.Close(); } catch (Exception ex) { _con.Close(); throw ex; } finally { _con.Close(); } } return(lista); }
public static Curso getCursoById(Int64 pId) { Curso item = null; using (MySqlConnection _con = new Conexion().Conectar()) { try { _con.Open(); MySqlCommand cmdGetItemById = new MySqlCommand("select * from curso where Id=@pId", _con); cmdGetItemById.Parameters.AddWithValue("@pId", pId); MySqlDataReader _reader = cmdGetItemById.ExecuteReader(); while (_reader.Read()) { item = new Curso( _reader.GetInt64(0), _reader.GetString(1), _reader.GetString(2), _reader.GetString(3), _reader.GetString(4), _reader.GetString(5), _reader.GetString(6), _reader.GetString(7), _reader.GetInt64(8), _reader.GetInt64(9), _reader.GetInt64(10), ContratoDAL.getContratoById(_reader.GetInt64(8)), YearDAL.getYearById(_reader.GetInt64(10)), DiasDAL.getDiasByIdCurso(_reader.GetInt64(0)), DetCursoDAL.getDetscursoByIdCurso(_reader.GetInt64(0)) ); } _reader.Close(); } catch (Exception ex) { _con.Close(); throw ex; } finally { _con.Close(); } } return(item); }