public async Task <Response> FindById(int id)
{
WorkSubAreas result = await _workSubAreaRepository.FindById(id);
if (result.Id > 0)
{
return(new Response
{
IsSuccess = true,
Message = "Se consulto exitosamente",
Result = result
});
}
else
{
return(new Response
{
IsSuccess = false,
Message = "Error"
});
}
}
public async Task <WorkSubAreas> FindById(int id)
{
using (SqlConnection sql = new SqlConnection(_connectionString))
{
using (SqlCommand cmd = new SqlCommand("usp_WorkSubArea_FindById", sql))
{
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add(new SqlParameter("@Id", id));
WorkSubAreas response = null;
await sql.OpenAsync();
using (var reader = await cmd.ExecuteReaderAsync())
{
if (reader != null)
{
response = reader.Translate <WorkSubAreas>().FirstOrDefault();
}
}
return(response);
}
}
}
