public static Useremp getUseremp(string pLogin, string pPass)
{
Useremp item = null;
using (MySqlConnection _con = new Conexion().Conectar())
{
try
{
_con.Open();
MySqlCommand cmdGetItemById = new MySqlCommand("select * from useremp where Login=@pLogin and Pass=md5(@pPass)", _con);
cmdGetItemById.Parameters.AddWithValue("@pLogin", pLogin);
cmdGetItemById.Parameters.AddWithValue("@pPass", pPass);
MySqlDataReader _reader = cmdGetItemById.ExecuteReader();
while (_reader.Read())
{
item = new Useremp(
_reader.GetInt64(0),
_reader.GetString(1),
_reader.GetString(2),
_reader.GetString(3),
_reader.GetInt64(4),
ContratoDAL.getContratoById(_reader.GetInt64(4)),
AcsSucursalDAL.getAcsSucursalesByIdUser(_reader.GetInt64(0))
);
}
_reader.Close();
}
catch (Exception ex)
{
_con.Close();
throw ex;
}
finally
{
_con.Close();
}
}
return(item);
}
public static List <Useremp> getUsersemp()
{
List <Useremp> lista = new List <Useremp>();
using (MySqlConnection _con = new Conexion().Conectar())
{
try
{
_con.Open();
MySqlCommand comando = new MySqlCommand("select * from useremp", _con);
MySqlDataReader _reader = comando.ExecuteReader();
while (_reader.Read())
{
Useremp item = new Useremp(
_reader.GetInt64(0),
_reader.GetString(1),
_reader.GetString(2),
_reader.GetString(3),
_reader.GetInt64(4),
ContratoDAL.getContratoById(_reader.GetInt64(4)),
AcsSucursalDAL.getAcsSucursalesByIdUser(_reader.GetInt64(0))
);
lista.Add(item);
}
_reader.Close();
}
catch (Exception ex)
{
_con.Close();
throw ex;
}
finally
{
_con.Close();
}
}
return(lista);
}