public static List <Contrato> searchContratosA(string pText, int pLimit) { List <Contrato> lista = new List <Contrato>(); using (MySqlConnection _con = new Conexion().Conectar()) { try { _con.Open(); MySqlCommand comando = new MySqlCommand("select * from contrato as c inner join Empleado as e on e.Id=c.IdEmpleado inner join " + " Cargo as ca on ca.Id = c.IdCargo inner join Persona as p on p.Id=e.IdPersona where (" + " upper(ca.Nombre) like '%" + pText.ToUpper() + "%' or e.Telefono like'%" + pText.ToUpper() + "%' or upper(e.correo) like '%" + pText.ToUpper() + "%' " + " or upper(p.Nombre) like '%" + pText.ToUpper() + "%' or upper(p.Dui) like '%" + pText.ToUpper() + "%' or upper(p.Nit) like '%" + pText.ToUpper() + "%') and Estado='A' order by c.Id desc limit @pLimit", _con); comando.Parameters.AddWithValue("@pLimit", pLimit); comando.Parameters.AddWithValue("@Text", pText.ToUpper()); MySqlDataReader _reader = comando.ExecuteReader(); while (_reader.Read()) { Contrato item = new Contrato( _reader.GetInt64(0), _reader.GetString(1), _reader.GetString(2), _reader.IsDBNull(3) ? null : _reader.GetString(3), _reader.GetString(4), _reader.GetInt64(5), _reader.GetInt64(6), _reader.GetInt64(7), CargoDAL.getCargoById(_reader.GetInt64(5)), EmpleadoDAL.getEmpleadoById(_reader.GetInt64(6)) ); lista.Add(item); } _reader.Close(); } catch (Exception ex) { _con.Close(); throw ex; } finally { _con.Close(); } } return(lista); }
public static List <Contrato> getContratos(int pLimit) { List <Contrato> lista = new List <Contrato>(); using (MySqlConnection _con = new Conexion().Conectar()) { try { _con.Open(); MySqlCommand comando = new MySqlCommand("select * from contrato order by Id desc limit @pLimit", _con); comando.Parameters.AddWithValue("@pLimit", pLimit); MySqlDataReader _reader = comando.ExecuteReader(); while (_reader.Read()) { Contrato item = new Contrato( _reader.GetInt64(0), _reader.GetString(1), _reader.GetString(2), _reader.IsDBNull(3) ? null : _reader.GetString(3), _reader.GetString(4), _reader.GetInt64(5), _reader.GetInt64(6), _reader.GetInt64(7), CargoDAL.getCargoById(_reader.GetInt64(5)), EmpleadoDAL.getEmpleadoById(_reader.GetInt64(6)) ); lista.Add(item); } _reader.Close(); } catch (Exception ex) { _con.Close(); throw ex; } finally { _con.Close(); } } return(lista); }
public static Contrato getContratoById(Int64 pId) { Contrato item = null; using (MySqlConnection _con = new Conexion().Conectar()) { try { _con.Open(); MySqlCommand cmdGetItemById = new MySqlCommand("select * from contrato where Id=@pId", _con); cmdGetItemById.Parameters.AddWithValue("@pId", pId); MySqlDataReader _reader = cmdGetItemById.ExecuteReader(); while (_reader.Read()) { item = new Contrato( _reader.GetInt64(0), _reader.GetString(1), _reader.GetString(2), _reader.IsDBNull(3) ? null : _reader.GetString(3), _reader.GetString(4), _reader.GetInt64(5), _reader.GetInt64(6), _reader.GetInt64(7), CargoDAL.getCargoById(_reader.GetInt64(5)), EmpleadoDAL.getEmpleadoById(_reader.GetInt64(6)) ); } _reader.Close(); } catch (Exception ex) { _con.Close(); throw ex; } finally { _con.Close(); } } return(item); }