private VehicleContract CreateVehicleContract(Vehicle vehicle)
{
VehicleContract vehicleContract = new VehicleContract();
vehicleContract.VehicleID = vehicle.VehicleID;
Contract contract = db.Contracts.Where(c => c.ContractorID == vehicle.ContractorID).ToList().First();
vehicleContract.ContractID = contract.ContractID;
return(vehicleContract);
}
public async Task <VehicleContract> GetVehicleContract(int vehicleID, int contractID)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
VehicleContract vehicleContract = db.VehiclesContracts.Where(c => c.VehicleID == vehicleID && c.ContractID == contractID).ToList().First();
timespan.Stop();
log.TraceApi("SQL Database", "VehicleRepository.GetVehicleContract", timespan.Elapsed, "vehicleID={0}, contractID={1}", vehicleID, contractID);
return(await Task.Run(() => { return vehicleContract; }));
}
catch (Exception e)
{
log.Error(e, "Error in VehicleRepository.GetVehicleContract(vehicleID={0}, contractID={1})", vehicleID, contractID);
throw;
}
}
public async Task DeleteContract(int vehicleID, int contractID)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
VehicleContract vehicleContract = db.VehiclesContracts.Where(c => c.VehicleID == vehicleID && c.ContractID == contractID).ToList().First();
db.VehiclesContracts.Remove(vehicleContract);
await db.SaveChangesAsync();
timespan.Stop();
log.TraceApi("SQL Database", "VehicleRepository.DeleteContract", timespan.Elapsed, "vehicleID={0}, contractID={1}", vehicleID, contractID);
}
catch (Exception e)
{
log.Error(e, "Error in VehicleRepository.DeleteContract(vehicleID={0}, contractID={1})", vehicleID, contractID);
throw;
}
}
public async Task DeleteAsync(int vehicleID)
{
Vehicle vehicle = null;
VehicleContract vehicleContract = null;
Stopwatch timespan = Stopwatch.StartNew();
SiccoAppConfiguration.SuspendExecutionStrategy = true;
DbContextTransaction tran = db.Database.BeginTransaction();
try
{
vehicle = await db.Vehicles.FindAsync(vehicleID);
db.Vehicles.Remove(vehicle);
vehicleContract = await db.VehiclesContracts.FindAsync(GetVehicleContractID(vehicleID));
if (vehicleContract != null)
{
db.VehiclesContracts.Remove(vehicleContract);
}
db.SaveChanges();
tran.Commit();
timespan.Stop();
log.TraceApi("SQL Database", "VehicleRepository.DeleteAsync", timespan.Elapsed, "vehicleID={0}", vehicleID);
}
catch (Exception e)
{
tran.Rollback();
log.Error(e, "Error in VehicleRepository.DeleteAsync(vehicleID={0})", vehicleID);
throw;
}
SiccoAppConfiguration.SuspendExecutionStrategy = false;
}
public async Task CreateContractAsync(VehicleContract vehicleContract)
{
Stopwatch timespan = Stopwatch.StartNew();
try
{
db.VehiclesContracts.Add(vehicleContract);
await db.SaveChangesAsync();
var contract = db.Contracts.Where(c => c.ContractID == vehicleContract.ContractID).SingleOrDefault <Contract>();
await GenerateContractorVehicleRequirements(contract.ContractorID, vehicleContract.ContractID, vehicleContract.VehicleID);
timespan.Stop();
log.TraceApi("SQL Database", "VehicleRepository.CreateContractAsync", timespan.Elapsed, "vehicleContract={0}", vehicleContract);
}
catch (Exception e)
{
log.Error(e, "Error in VehicleRepository.CreateContractAsync(vehicleContract={0})", vehicleContract);
throw;
}
}
private int?GetVehicleContractID(int vehicleID)
{
VehicleContract vehicleContract = db.VehiclesContracts.Where(c => c.VehicleID == vehicleID).ToList().FirstOrDefault();
return(vehicleContract?.VehicleContractID);
}