public Operacion EliminarVehiculo(VehiculoArgumento vehiculoArgumento)
{
try
{
DbParameter[] parameters =
{
new OAParameter
{
ParameterName = "@VEHICLE_CODE",
Value = vehiculoArgumento.Vehiculo.VEHICLE_CODE
}
};
var op =
BaseDeDatosServicio.ExecuteQuery <Operacion>(BaseDeDatosServicio.Esquema + ".OP_WMS_SP_DELETE_VEHICLE",
CommandType.StoredProcedure, false, parameters)[0];
if (op.Resultado == ResultadoOperacionTipo.Exito)
{
BaseDeDatosServicio.Commit();
}
else
{
BaseDeDatosServicio.Rollback();
}
return(op);
}
catch (DbException e)
{
BaseDeDatosServicio.Rollback();
return(new Operacion
{
Codigo = e.ErrorCode,
Mensaje = e.Message,
Resultado = ResultadoOperacionTipo.Error
});
}
catch (Exception ex)
{
BaseDeDatosServicio.Rollback();
return(new Operacion
{
Codigo = -1,
Mensaje = ex.Message,
Resultado = ResultadoOperacionTipo.Error
});
}
}
private void DesasociarTodosLosUsuarioVehiculos(string pCodeVehicle, object sender)
{
try
{
var arg = new VehiculoArgumento
{
Vehiculo = new Vehiculo {
CODE_VEHICLE = pCodeVehicle
}
};
UsuarioDeseaDesasociarTodosLosVendedoresAVehiculo?.Invoke(sender, arg);
}
catch (Exception ex)
{
EstablecerError(ex.Message, sender);
}
}
private void AsociarUsuariosAVehiculo(string pCodeVehicle, object sender)
{
var lst = UiUsuariosNOAsociados.GridView.GetSelectedFieldValues("LOGIN");
var arg = new VehiculoArgumento
{
Vehiculo = new Vehiculo {
CODE_VEHICLE = pCodeVehicle
},
ListaVendedores = new List <Usuario>(),
};
foreach (var item in lst)
{
arg.ListaVendedores.Add(new Usuario {
LOGIN = item.ToString()
});
}
UsuarioDeseaAsociarVendedorAVehiculo?.Invoke(sender, arg);
}
public Vehiculo ObtenerVehiculo(VehiculoArgumento vehiculoArgumento)
{
return
(BaseDeDatosServicio.ExecuteQuery <Vehiculo>(BaseDeDatosServicio.Esquema + ".OP_WMS_SP_GET_VEHICLE",
CommandType.StoredProcedure, null)[0]);
}
public Operacion CrearVehiculo(VehiculoArgumento vehiculoArgumento)
{
try
{
DbParameter[] parameters =
{
new OAParameter
{
ParameterName = "@BRAND",
Value = vehiculoArgumento.Vehiculo.BRAND
},
new OAParameter
{
ParameterName = "@LINE",
Value = vehiculoArgumento.Vehiculo.LINE
},
new OAParameter
{
ParameterName = "@MODEL",
Value = vehiculoArgumento.Vehiculo.MODEL
},
new OAParameter
{
ParameterName = "@COLOR",
Value = vehiculoArgumento.Vehiculo.COLOR
},
new OAParameter
{
ParameterName = "@CHASSIS_NUMBER",
Value = vehiculoArgumento.Vehiculo.CHASSIS_NUMBER
},
new OAParameter
{
ParameterName = "@ENGINE_NUMBER",
Value = vehiculoArgumento.Vehiculo.ENGINE_NUMBER
},
new OAParameter
{
ParameterName = "@VIN_NUMBER",
Value = vehiculoArgumento.Vehiculo.VIN_NUMBER
},
new OAParameter
{
ParameterName = "@PLATE_NUMBER",
Value = vehiculoArgumento.Vehiculo.PLATE_NUMBER
},
new OAParameter
{
ParameterName = "@TRANSPORT_COMPANY_CODE",
Value = vehiculoArgumento.Vehiculo.TRANSPORT_COMPANY_CODE
},
new OAParameter
{
ParameterName = "@WEIGHT",
Value = vehiculoArgumento.Vehiculo.WEIGHT
},
new OAParameter
{
ParameterName = "@HIGH",
Value = vehiculoArgumento.Vehiculo.HIGH
}
,
new OAParameter
{
ParameterName = "@WIDTH",
Value = vehiculoArgumento.Vehiculo.WIDTH
}
,
new OAParameter
{
ParameterName = "@DEPTH",
Value = vehiculoArgumento.Vehiculo.DEPTH
}
,
new OAParameter
{
ParameterName = "@VOLUME_FACTOR",
Value = vehiculoArgumento.Vehiculo.VOLUME_FACTOR
}
,
new OAParameter
{
ParameterName = "@LAST_UPDATE_BY",
Value = vehiculoArgumento.Vehiculo.LAST_UPDATE_BY
}
,
new OAParameter
{
ParameterName = "@PILOT_CODE",
Value = vehiculoArgumento.Vehiculo.PILOT_CODE
}
,
new OAParameter
{
ParameterName = "@RATING",
Value = vehiculoArgumento.Vehiculo.RATING
}
,
new OAParameter
{
ParameterName = "@IS_ACTIVE",
Value = vehiculoArgumento.Vehiculo.IS_ACTIVE
}
,
new OAParameter
{
ParameterName = "@STATUS",
Value = vehiculoArgumento.Vehiculo.STATUS
}
,
new OAParameter
{
ParameterName = "@FILL_RATE",
Value = vehiculoArgumento.Vehiculo.FILL_RATE
}
,
new OAParameter
{
ParameterName = "@VEHICLE_AXLES",
Value = vehiculoArgumento.Vehiculo.VEHICLE_AXLES
}
,
new OAParameter
{
ParameterName = "@INSURANCE_DOC_ID",
Value = vehiculoArgumento.Vehiculo.INSURANCE_DOC_ID
}
, new OAParameter
{
ParameterName = "@AVERAGE_COST_PER_KILOMETER",
Value = vehiculoArgumento.Vehiculo.AVERAGE_COST_PER_KILOMETER
}
};
var op =
BaseDeDatosServicio.ExecuteQuery <Operacion>(BaseDeDatosServicio.Esquema + ".OP_WMS_SP_ADD_VEHICLE",
CommandType.StoredProcedure, false, parameters)[0];
if (op.Resultado == ResultadoOperacionTipo.Exito)
{
BaseDeDatosServicio.Commit();
}
else
{
BaseDeDatosServicio.Rollback();
}
return(op);
}
catch (DbException e)
{
BaseDeDatosServicio.Rollback();
return(new Operacion
{
Codigo = e.ErrorCode,
Mensaje = e.Message,
Resultado = ResultadoOperacionTipo.Error
});
}
catch (Exception ex)
{
BaseDeDatosServicio.Rollback();
return(new Operacion
{
Codigo = -1,
Mensaje = ex.Message,
Resultado = ResultadoOperacionTipo.Error
});
}
}
