public static Sexo Get(int id)
{
Sexo sexo = null;
try
{
sexo = SexoDal.Get(id);
}
catch (SqlException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
return(sexo);
}
/// <summary>
/// Obtine la informacion de un usuario
/// </summary>
/// <param name="id">identificador del usuario</param>
/// <returns></returns>
public static Usuario Get(int id)
{
Usuario res = new Usuario();
SqlCommand cmd = null;
SqlDataReader dr = null;
string query = "Select * From Usuario where PacienteId = @id";
try
{
cmd = Methods.CreateBasicCommand(query);
cmd.Parameters.AddWithValue("@id", id);
dr = Methods.ExecuteDataReaderCommand(cmd);
while (dr.Read())
{
res = new Usuario()
{
UsuarioId = dr.GetInt32(0),
Nombre = dr.GetString(1),
Apellido = dr.GetString(2),
SexoId = SexoDal.Get(dr.GetByte(3)),
FechaNacimiento = dr.GetDateTime(4),
Eliminado = dr.GetByte(5)
};
}
}
catch (Exception ex)
{
Methods.GenerateLogsRelease("UsuarioDal", "Obteber", string.Format("{0} {1} Error: {2}", DateTime.Now.ToShortDateString(), DateTime.Now.ToShortTimeString(), ex.Message));
throw ex;
}
finally
{
cmd.Connection.Close();
}
return(res);
}