public JsonResult Get()
{
TransporteModel transporteQuery = new TransporteModel(new Transporte());
ResponseMenssage response = new ResponseMenssage("success", transporteQuery.GetTransportes());
return(new JsonResult(response));
}
private void Editar(DTOTransporte transporte)
{
var transporteModel = TransporteModel.Transform(transporte);
var sql = ActiveRecord.Update(transporteModel);
using (var contexto = new Contexto())
{
contexto.ExecutaComando(sql);
}
}
public void Excluir(int id)
{
var transporteModel = new TransporteModel {
Id = id.ToString()
};
var sql = ActiveRecord.Delete(transporteModel);
using (var contexto = new Contexto())
{
contexto.ExecutaComando(sql);
}
}
private void Incluir(DTOTransporte transporte)
{
var transporteModel = TransporteModel.Transform(transporte);
var sql = transporteModel.QueryInsert();
using (var contexto = new Contexto())
{
var result = contexto.ExecutaComandoComRetorno(sql);
result.Read();
transporte.Id = Convert.ToInt32(result["LASTID"]);
}
}
public JsonResult Delete(int id)
{
TransporteModel transporteQuery = new TransporteModel(new Transporte());
transporteQuery.Transporte.Rut = id;
if (transporteQuery.Delete())
{
ResponseMenssage response = new ResponseMenssage("success", transporteQuery.Transporte);
return(new JsonResult(response));
}
else
{
ResponseMenssage response = new ResponseMenssage("error", "error al eliminar");
return(new JsonResult(response));
}
}
public JsonResult Put(int id, [FromBody] Transporte transporte)
{
TransporteModel transporteQuery = new TransporteModel(transporte);
transporteQuery.Transporte.Rut = id;
if (transporteQuery.Update())
{
ResponseMenssage response = new ResponseMenssage("success", transporteQuery.Transporte);
return(new JsonResult(response));
}
else
{
ResponseMenssage response = new ResponseMenssage("error", "error al modificar");
return(new JsonResult(response));
}
}
public JsonResult Get(int id)
{
Transporte transporte = new Transporte
{
Rut = id
};
TransporteModel transporteQuery = new TransporteModel(transporte);
if (transporteQuery.ReadById())
{
ResponseMenssage response = new ResponseMenssage("success", transporteQuery.Transporte);
return(new JsonResult(response));
}
else
{
ResponseMenssage response = new ResponseMenssage("error", "transporte no encontrada");
return(new JsonResult(response));
}
}
/// <summary>
/// Ejecuta la acción del command
/// </summary>
/// <param name="catalogItemStatusViewModel"></param>
public InsertTransporteViewModel(CatalogTransporteViewModel catalogTransporteViewModel)
{
this._addTransporte = new TransporteModel(new TransporteDataMapper());
this._catalogTransporteViewModel = catalogTransporteViewModel;
this._catalogTipoEmpresaModel = new CatalogTipoEmpresaModel(new TipoEmpresaDataMapper());
}
