public static User GetUser(int IdUser)
{
User user = null;
try
{
using (SqlConnection conn = new SqlConnection(conexao))
{
using (SqlCommand command = new SqlCommand("dbo.GetUser", conn)
{
CommandType = System.Data.CommandType.StoredProcedure
})
{
command.Parameters.Add("@IdUser", System.Data.SqlDbType.NVarChar).Value = IdUser;
conn.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
reader.Read();
user = new User
{
DataInclusao = Conversao.FieldToDateTime(reader["DataInclusao"]),
Name = Conversao.FieldToString(reader["Name"]),
Email = Conversao.FieldToString(reader["Email"]),
CPF = Conversao.FieldToString(reader["CPF"]),
};
}
}
return(user);
}
}
catch (Exception ex)
{
throw new Exception("Failed: the user was not found.", ex);
}
}
