public TransactionResult create(DemoraVo demora_vo, User user_log)
{
Demora demora = DemoraAdapter.voToObject(demora_vo);
demora.user = user_log;
return(demora_repository.create(demora));
}
public HttpResponseMessage detail(int id)
{
Demora demora = demora_service.detail(id);
if (demora != null)
{
IDictionary <string, Demora> data = new Dictionary <string, Demora>();
data.Add("data", demora);
return(Request.CreateResponse(HttpStatusCode.OK, data));
}
else
{
IDictionary <string, string> data = new Dictionary <string, string>();
data.Add("message", "Object not found.");
return(Request.CreateResponse(HttpStatusCode.BadRequest, data));
}
}
public TransactionResult update(Demora demora)
{
SqlConnection connection = null;
using (connection = new SqlConnection(ConfigurationManager.ConnectionStrings["Coz_Operaciones_DB"].ConnectionString))
{
try
{
connection.Open();
SqlCommand command = new SqlCommand("sp_updateDemora", connection);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("nombre", Validations.defaultString(demora.nombre)));
command.Parameters.Add(new SqlParameter("status", demora.status));
command.Parameters.Add(new SqlParameter("id", demora.id));
command.ExecuteNonQuery();
return(TransactionResult.OK);
}
catch (SqlException ex)
{
if (connection != null)
{
connection.Close();
}
if (ex.Number == 2627)
{
return(TransactionResult.EXISTS);
}
return(TransactionResult.NOT_PERMITTED);
}
catch
{
if (connection != null)
{
connection.Close();
}
return(TransactionResult.ERROR);
}
}
}
public static DemoraVo objectToVo(Demora obj)
{
return(new DemoraVo
{
});
}
