/// <summary>
///
/// </summary>
/// <param name="items"></param>
/// <response code="201">Equipment created</response>
public virtual IActionResult EquipmentBulkPostAsync(Equipment[] items)
{
if (items == null)
{
return(new BadRequestResult());
}
foreach (Equipment item in items)
{
AdjustRecord(item);
// determine if this is an insert or an update
bool exists = _context.Equipments.Any(a => a.Id == item.Id);
if (exists)
{
_context.Update(item);
}
else
{
_context.Add(item);
}
}
// Save the changes
_context.SaveChanges();
return(new NoContentResult());
}
/// <summary>
/// Create bulk note records
/// </summary>
/// <param name="items"></param>
/// <response code="201">Note created</response>
public virtual IActionResult NotesBulkPostAsync(Note[] items)
{
if (items == null)
{
return(new BadRequestResult());
}
foreach (Note item in items)
{
// determine if this is an insert or an update
bool exists = _context.Notes.Any(a => a.Id == item.Id);
if (exists)
{
_context.Update(item);
}
else
{
_context.Add(item);
}
}
// save the changes
_context.SaveChanges();
return(new NoContentResult());
}
/// <summary>
/// Create bulk area rottion list records
/// </summary>
/// <param name="items"></param>
/// <response code="201">DumpTruck created</response>
public virtual IActionResult LocalarearotationlistsBulkPostAsync(LocalAreaRotationList[] items)
{
if (items == null)
{
return(new BadRequestResult());
}
foreach (LocalAreaRotationList item in items)
{
// determine if this is an insert or an update
bool exists = _context.LocalAreaRotationLists.Any(a => a.Id == item.Id);
if (exists)
{
_context.Update(item);
}
else
{
_context.Add(item);
}
}
// Save the changes
_context.SaveChanges();
return(new NoContentResult());
}
/// <summary>
///
/// </summary>
/// <remarks>Replaces an Project's Contacts</remarks>
/// <param name="id">id of Project to replace Contacts for</param>
/// <param name="items">Replacement Project contacts.</param>
/// <response code="200">OK</response>
public virtual IActionResult ProjectsIdContactsPutAsync(int id, Contact[] items)
{
var exists = _context.Projects.Any(a => a.Id == id);
if (exists && items != null)
{
Project project = _context.Projects
.Include(x => x.District.Region)
.Include(x => x.Notes)
.Include(x => x.Attachments)
.Include(x => x.History)
.Include(x => x.Contacts)
.First(x => x.Id == id);
// adjust the incoming list.
for (int i = 0; i < items.Count(); i++)
{
Contact item = items[i];
if (item != null)
{
bool contact_exists = _context.Contacts.Any(x => x.Id == item.Id);
if (contact_exists)
{
items[i] = _context.Contacts
.First(x => x.Id == item.Id);
}
else
{
_context.Add(item);
items[i] = item;
}
}
}
// remove contacts that are no longer attached.
foreach (Contact contact in project.Contacts)
{
if (contact != null && !items.Any(x => x.Id == contact.Id))
{
_context.Remove(contact);
}
}
// replace Contacts.
project.Contacts = items.ToList();
_context.Update(project);
_context.SaveChanges();
return(new ObjectResult(items));
}
else
{
// record not found
return(new StatusCodeResult(404));
}
}
/// <summary>
/// Update contacts associated with a project
/// </summary>
/// <remarks>Replaces an Project's Contacts</remarks>
/// <param name="id">id of Project to replace Contacts for</param>
/// <param name="items">Replacement Project contacts.</param>
/// <response code="200">OK</response>
public virtual IActionResult ProjectsIdContactsPutAsync(int id, Contact[] items)
{
bool exists = _context.Projects.Any(a => a.Id == id);
if (exists && items != null)
{
Project project = _context.Projects
.Include(x => x.District.Region)
.Include(x => x.Notes)
.Include(x => x.Attachments)
.Include(x => x.History)
.Include(x => x.Contacts)
.First(x => x.Id == id);
// adjust the incoming list
for (int i = 0; i < items.Count(); i++)
{
Contact item = items[i];
if (item != null)
{
bool contactExists = _context.Contacts.Any(x => x.Id == item.Id);
if (contactExists)
{
items[i] = _context.Contacts
.First(x => x.Id == item.Id);
}
else
{
_context.Add(item);
items[i] = item;
}
}
}
// remove contacts that are no longer attached
foreach (Contact contact in project.Contacts)
{
if (contact != null && items.All(x => x.Id != contact.Id))
{
_context.Remove(contact);
}
}
// replace contacts
project.Contacts = items.ToList();
_context.Update(project);
_context.SaveChanges();
return(new ObjectResult(new HetsResponse(items)));
}
// record not found
return(new ObjectResult(new HetsResponse("HETS-01", ErrorViewModel.GetDescription("HETS-01", _configuration))));
}
/// <summary>
///
/// </summary>
/// <remarks>Updates the active set of groups for a user</remarks>
/// <param name="id">id of User to update</param>
/// <param name="items"></param>
/// <response code="200">OK</response>
/// <response code="404">User not found</response>
public virtual IActionResult UsersIdGroupsPutAsync(int id, GroupMembershipViewModel[] items)
{
bool exists = _context.Users.Any(x => x.Id == id);
if (exists)
{
User user = _context.Users
.Include(x => x.District)
.Include(x => x.GroupMemberships)
.ThenInclude(y => y.Group)
.Include(x => x.UserRoles)
.ThenInclude(y => y.Role)
.ThenInclude(z => z.RolePermissions)
.ThenInclude(z => z.Permission)
.First(x => x.Id == id);
if (user.GroupMemberships == null)
{
user.GroupMemberships = new List <GroupMembership>();
}
else
{
// existing data, clear it.
foreach (var groupMembership in user.GroupMemberships)
{
if (_context.GroupMemberships.Any(x => x.Id == groupMembership.Id))
{
GroupMembership delete = _context.GroupMemberships.First(x => x.Id == groupMembership.Id);
_context.Remove(delete);
}
}
user.GroupMemberships.Clear();
}
foreach (var item in items)
{
if (item != null)
{
// check the role id
bool group_exists = _context.Groups.Any(x => x.Id == item.GroupId);
if (group_exists)
{
// create a new UserRole based on the view model.
GroupMembership groupMembership = new GroupMembership();
Group group = _context.Groups.First(x => x.Id == item.GroupId);
groupMembership.Group = group;
groupMembership.User = user;
_context.Add(groupMembership);
if (!user.GroupMemberships.Contains(groupMembership))
{
user.GroupMemberships.Add(groupMembership);
}
}
}
}
_context.Update(user);
_context.SaveChanges();
return(new StatusCodeResult(201));
}
else
{
return(new StatusCodeResult(400));
}
}
public virtual IActionResult GetCCW([FromQuery] string regi, [FromQuery] string plate, [FromQuery] string vin)
{
// check we have the right headers.
if (string.IsNullOrEmpty(userId) || string.IsNullOrEmpty(guid) || string.IsNullOrEmpty(directory))
{
return(new UnauthorizedResult());
}
// Check for the following data:
// 1. registration
// 2. plate
// 3. decal
VehicleDescription vehicle = null;
if (regi != null)
{
// format the regi.
try
{
int registration = int.Parse(regi);
// zero padded, 8 digits
regi = registration.ToString("D8");
}
catch (Exception e)
{
_logger.LogInformation("Exception occured parsing registration number " + regi);
}
try
{
vehicle = _service.GetBCVehicleForRegistrationNumber(regi, userId, guid, directory);
}
catch (Exception e)
{
vehicle = null;
}
}
if (vehicle == null && plate != null) // check the plate.
{
try
{
vehicle = _service.GetBCVehicleForLicensePlateNumber(plate, userId, guid, directory);
}
catch (Exception e)
{
vehicle = null;
}
}
if (vehicle == null && vin != null) // check the vin.
{
try
{
vehicle = _service.GetBCVehicleForSerialNumber(vin, userId, guid, directory);
}
catch (Exception e)
{
vehicle = null;
}
}
if (vehicle == null)
{
return(new StatusCodeResult(404)); // Can't find the vehicle.
}
else
{
string icbcRegistrationNumber = vehicle.registrationNumber;
CCWData ccwdata = null;
bool existing = false;
if (_context.CCWDatas.Any(x => x.ICBCRegistrationNumber == icbcRegistrationNumber))
{
ccwdata = _context.CCWDatas.First(x => x.ICBCRegistrationNumber == icbcRegistrationNumber);
existing = true;
_logger.LogInformation("Found record for Registration # " + ccwdata.ICBCRegistrationNumber);
}
else
{
_logger.LogInformation("Creating new record");
ccwdata = new CCWData();
}
// update the ccw record.
ccwdata.ICBCBody = vehicle.bodyCode;
ccwdata.ICBCColour = vehicle.colour;
ccwdata.ICBCCVIPDecal = vehicle.inspectionDecalNumber;
ccwdata.ICBCCVIPExpiry = vehicle.inspectionExpiryDate;
ccwdata.ICBCFleetUnitNo = SanitizeInt(vehicle.fleetUnitNumber);
ccwdata.ICBCFuel = vehicle.fuelTypeDescription;
ccwdata.ICBCGrossVehicleWeight = SanitizeInt(vehicle.grossVehicleWeight);
ccwdata.ICBCMake = vehicle.make;
ccwdata.ICBCModel = vehicle.model;
ccwdata.ICBCGrossVehicleWeight = SanitizeInt(vehicle.grossVehicleWeight);
ccwdata.ICBCModelYear = SanitizeInt(vehicle.modelYear);
ccwdata.ICBCNetWt = SanitizeInt(vehicle.netWeight);
ccwdata.ICBCNotesAndOrders = vehicle.cvipDataFromLastInspection;
ccwdata.ICBCOrderedOn = vehicle.firstOpenOrderDate;
ccwdata.ICBCRateClass = vehicle.rateClass;
ccwdata.ICBCRebuiltStatus = vehicle.statusCode;
ccwdata.ICBCRegistrationNumber = vehicle.registrationNumber;
ccwdata.ICBCRegOwnerAddr1 = vehicle.owner.mailingAddress1;
ccwdata.ICBCRegOwnerAddr2 = vehicle.owner.mailingAddress2;
ccwdata.ICBCRegOwnerCity = vehicle.owner.mailingAddress3;
ccwdata.ICBCRegOwnerName = vehicle.owner.name1;
ccwdata.ICBCRegOwnerPODL = vehicle.principalOperatorDlNum;
ccwdata.ICBCRegOwnerPostalCode = vehicle.owner.postalCode;
ccwdata.ICBCRegOwnerProv = vehicle.owner.mailingAddress4;
ccwdata.ICBCRegOwnerRODL = vehicle.owner.driverLicenseNumber;
ccwdata.ICBCSeatingCapacity = SanitizeInt(vehicle.seatingCapacity);
ccwdata.ICBCVehicleType = vehicle.vehicleType + " - " + vehicle.vehicleTypeDescription;
ccwdata.ICBCVehicleIdentificationNumber = vehicle.serialNumber;
ccwdata.NSCPlateDecal = vehicle.decalNumber;
ccwdata.NSCPolicyEffectiveDate = vehicle.policyStartDate;
ccwdata.NSCPolicyExpiryDate = vehicle.policyExpiryDate;
ccwdata.NSCPolicyStatus = vehicle.policyStatus + " - " + vehicle.policyStatusDescription;
// policyAquiredCurrentStatusDate is the preferred field, however it is often null.
if (vehicle.policyAcquiredCurrentStatusDate != null)
{
ccwdata.NSCPolicyStatusDate = vehicle.policyAcquiredCurrentStatusDate;
}
else if (vehicle.policyTerminationDate != null)
{
ccwdata.NSCPolicyStatusDate = vehicle.policyTerminationDate;
}
else if (vehicle.policyReplacedOnDate != null)
{
ccwdata.NSCPolicyStatusDate = vehicle.policyReplacedOnDate;
}
else if (vehicle.policyStartDate != null)
{
ccwdata.NSCPolicyStatusDate = vehicle.policyStartDate;
}
if (vehicle.owner != null)
{
ccwdata.ICBCRegOwnerRODL = vehicle.owner.driverLicenseNumber;
}
ccwdata.ICBCLicencePlateNumber = vehicle.policyNumber;
// these fields are the same.
ccwdata.NSCPolicyNumber = vehicle.policyNumber;
ccwdata.NSCClientNum = vehicle.nscNumber;
ccwdata.DateFetched = DateTime.UtcNow;
// get the nsc client organization data.
bool foundNSCData = false;
if (!string.IsNullOrEmpty(ccwdata.NSCPolicyNumber))
{
string organizationNameCode = "LE";
try
{
ClientOrganization clientOrganization = _service.GetCurrentClientOrganization(ccwdata.NSCClientNum, organizationNameCode, userId, guid, directory);
foundNSCData = true;
ccwdata.NSCCarrierConditions = clientOrganization.nscInformation.carrierStatus;
ccwdata.NSCCarrierName = clientOrganization.displayName;
ccwdata.NSCCarrierSafetyRating = clientOrganization.nscInformation.safetyRating;
}
catch (AggregateException ae)
{
_logger.LogInformation("Aggregate Exception occured during GetCurrentClientOrganization");
ae.Handle((x) =>
{
if (x is FaultException <CVSECommonException> ) // From the web service.
{
_logger.LogDebug("CVSECommonException:");
FaultException <CVSECommonException> fault = (FaultException <CVSECommonException>)x;
_logger.LogDebug("errorId: {0}", fault.Detail.errorId);
_logger.LogDebug("errorMessage: {0}", fault.Detail.errorMessage);
_logger.LogDebug("systemError: {0}", fault.Detail.systemError);
return(true);
}
return(true); // ignore other exceptions
});
}
catch (Exception e)
{
_logger.LogInformation("Unknown Error retrieving NSC data.");
}
// now try the individual service if there was no match.
if (foundNSCData == false)
{
try
{
ClientIndividual clientIndividual = _service.GetCurrentClientIndividual(ccwdata.NSCClientNum, organizationNameCode, userId, guid, directory);
foundNSCData = true;
ccwdata.NSCCarrierConditions = clientIndividual.nscInformation.carrierStatus;
ccwdata.NSCCarrierName = clientIndividual.displayName;
ccwdata.NSCCarrierSafetyRating = clientIndividual.nscInformation.safetyRating;
}
catch (AggregateException ae)
{
_logger.LogInformation("Aggregate Exception occured during GetCurrentClientIndividual");
ae.Handle((x) =>
{
if (x is FaultException <CVSECommonException> ) // From the web service.
{
_logger.LogDebug("CVSECommonException:");
FaultException <CVSECommonException> fault = (FaultException <CVSECommonException>)x;
_logger.LogDebug("errorId: {0}", fault.Detail.errorId);
_logger.LogDebug("errorMessage: {0}", fault.Detail.errorMessage);
_logger.LogDebug("systemError: {0}", fault.Detail.systemError);
return(true);
}
return(true); // ignore other exceptions
});
}
catch (Exception e)
{
_logger.LogInformation("Unknown Error retrieving Individual NSC data.");
}
}
}
if (ccwdata.Id > 0)
{
_context.Update(ccwdata);
}
else
{
_context.Add(ccwdata);
}
_context.SaveChanges();
return(new ObjectResult(ccwdata));
}
}
/// <summary>
/// Update all roles associated with a user
/// </summary>
/// <remarks>Updates the roles for a user</remarks>
/// <param name="id">id of User to update</param>
/// <param name="items"></param>
/// <response code="200">OK</response>
public virtual IActionResult UsersIdRolesPutAsync(int id, UserRoleViewModel[] items)
{
bool exists = _context.Users.Any(x => x.Id == id);
// not found
if (!exists || items == null)
{
return(new StatusCodeResult(400));
}
User user = _context.Users
.Include(x => x.District)
.Include(x => x.UserRoles)
.ThenInclude(y => y.Role)
.ThenInclude(z => z.RolePermissions)
.ThenInclude(z => z.Permission)
.First(x => x.Id == id);
if (user.UserRoles == null)
{
user.UserRoles = new List <UserRole>();
}
else
{
// existing data, clear it
foreach (UserRole userRole in user.UserRoles)
{
if (_context.UserRoles.Any(x => x.Id == userRole.Id))
{
UserRole delete = _context.UserRoles.First(x => x.Id == userRole.Id);
_context.Remove(delete);
}
}
user.UserRoles.Clear();
}
foreach (UserRoleViewModel item in items)
{
// check the role id
bool roleExists = _context.Roles.Any(x => x.Id == item.RoleId);
if (roleExists)
{
// create a new UserRole based on the view model.
UserRole userRole = new UserRole();
Role role = _context.Roles.First(x => x.Id == item.RoleId);
userRole.Role = role;
userRole.EffectiveDate = item.EffectiveDate;
userRole.ExpiryDate = item.ExpiryDate;
_context.Add(userRole);
if (!user.UserRoles.Contains(userRole))
{
user.UserRoles.Add(userRole);
}
}
}
_context.Update(user);
_context.SaveChanges();
return(new StatusCodeResult(200));
}
public CCWData GetCCW(string regi, string plate, string vin, string userId, string guid, string directory)
{
// check we have the right headers.
if (string.IsNullOrEmpty(userId) || string.IsNullOrEmpty(guid) || string.IsNullOrEmpty(directory))
{
return(null);
}
var batchUser = _configuration.GetValue <string>("CCW_USER_ID");
var logPrefix = batchUser == userId ? "[Hangfire]" : "";
// Check for the following data:
// 1. registration
// 2. plate
// 3. decal
VehicleDescription vehicle = null;
if (regi != null)
{
// format the regi.
try
{
int registration = int.Parse(regi);
// zero padded, 8 digits
regi = registration.ToString("D8");
}
catch (Exception)
{
_logger.LogInformation($"{logPrefix} Exception occured parsing registration number {regi}.");
}
vehicle = _ccwService.GetBCVehicleForRegistrationNumber(regi, userId, guid, directory);
}
if (vehicle == null && plate != null) // check the plate.
{
vehicle = _ccwService.GetBCVehicleForLicensePlateNumber(plate, userId, guid, directory);
}
if (vehicle == null && vin != null) // check the vin.
{
vehicle = _ccwService.GetBCVehicleForSerialNumber(vin, userId, guid, directory);
}
if (vehicle == null)
{
return(null);
}
string icbcRegistrationNumber = vehicle.registrationNumber;
CCWData ccwdata = null;
if (_context.CCWDatas.Any(x => x.ICBCRegistrationNumber == icbcRegistrationNumber))
{
ccwdata = _context.CCWDatas.First(x => x.ICBCRegistrationNumber == icbcRegistrationNumber);
_logger.LogInformation($"{logPrefix} Found CCW record for Registration # " + ccwdata.ICBCRegistrationNumber);
}
else
{
_logger.LogInformation($"{logPrefix} Creating new CCW record");
ccwdata = new CCWData();
}
// update the ccw record.
ccwdata.ICBCBody = vehicle.bodyCode;
ccwdata.ICBCColour = vehicle.colour;
ccwdata.ICBCCVIPDecal = vehicle.inspectionDecalNumber;
ccwdata.ICBCCVIPExpiry = vehicle.inspectionExpiryDate;
ccwdata.ICBCFleetUnitNo = SanitizeInt(vehicle.fleetUnitNumber);
ccwdata.ICBCFuel = vehicle.fuelTypeDescription;
ccwdata.ICBCGrossVehicleWeight = SanitizeInt(vehicle.grossVehicleWeight);
ccwdata.ICBCMake = vehicle.make;
ccwdata.ICBCModel = vehicle.model;
ccwdata.ICBCGrossVehicleWeight = SanitizeInt(vehicle.grossVehicleWeight);
ccwdata.ICBCModelYear = SanitizeInt(vehicle.modelYear);
ccwdata.ICBCNetWt = SanitizeInt(vehicle.netWeight);
ccwdata.ICBCNotesAndOrders = vehicle.cvipDataFromLastInspection;
ccwdata.ICBCOrderedOn = vehicle.firstOpenOrderDate;
ccwdata.ICBCRateClass = vehicle.rateClass;
ccwdata.ICBCRebuiltStatus = vehicle.statusCode;
ccwdata.ICBCRegistrationNumber = vehicle.registrationNumber;
ccwdata.ICBCRegOwnerAddr1 = vehicle.owner.mailingAddress1;
ccwdata.ICBCRegOwnerAddr2 = vehicle.owner.mailingAddress2;
ccwdata.ICBCRegOwnerCity = vehicle.owner.mailingAddress3;
ccwdata.ICBCRegOwnerName = vehicle.owner.name1;
ccwdata.ICBCRegOwnerPODL = vehicle.principalOperatorDlNum;
ccwdata.ICBCRegOwnerPostalCode = vehicle.owner.postalCode;
ccwdata.ICBCRegOwnerProv = vehicle.owner.mailingAddress4;
ccwdata.ICBCRegOwnerRODL = vehicle.owner.driverLicenseNumber;
ccwdata.ICBCSeatingCapacity = SanitizeInt(vehicle.seatingCapacity);
ccwdata.ICBCVehicleType = vehicle.vehicleType + " - " + vehicle.vehicleTypeDescription;
ccwdata.ICBCVehicleIdentificationNumber = vehicle.serialNumber;
ccwdata.NSCPlateDecal = vehicle.decalNumber;
ccwdata.NSCPolicyEffectiveDate = vehicle.policyStartDate;
ccwdata.NSCPolicyExpiryDate = vehicle.policyExpiryDate;
ccwdata.NSCPolicyStatus = vehicle.policyStatus + " - " + vehicle.policyStatusDescription;
// policyAquiredCurrentStatusDate is the preferred field, however it is often null.
if (vehicle.policyAcquiredCurrentStatusDate != null)
{
ccwdata.NSCPolicyStatusDate = vehicle.policyAcquiredCurrentStatusDate;
}
else if (vehicle.policyTerminationDate != null)
{
ccwdata.NSCPolicyStatusDate = vehicle.policyTerminationDate;
}
else if (vehicle.policyReplacedOnDate != null)
{
ccwdata.NSCPolicyStatusDate = vehicle.policyReplacedOnDate;
}
else if (vehicle.policyStartDate != null)
{
ccwdata.NSCPolicyStatusDate = vehicle.policyStartDate;
}
if (vehicle.owner != null)
{
ccwdata.ICBCRegOwnerRODL = vehicle.owner.driverLicenseNumber;
}
ccwdata.ICBCLicencePlateNumber = vehicle.policyNumber;
// these fields are the same.
ccwdata.NSCPolicyNumber = vehicle.policyNumber;
ccwdata.NSCClientNum = vehicle.nscNumber;
ccwdata.DateFetched = DateTime.UtcNow;
// get the nsc client organization data.
bool foundNSCData = false;
if (!string.IsNullOrEmpty(ccwdata.NSCPolicyNumber))
{
string organizationNameCode = "LE";
ClientOrganization clientOrganization = _ccwService.GetCurrentClientOrganization(ccwdata.NSCClientNum, organizationNameCode, userId, guid, directory);
if (clientOrganization != null)
{
foundNSCData = true;
ccwdata.NSCCarrierConditions = clientOrganization.nscInformation.carrierStatus;
ccwdata.NSCCarrierName = clientOrganization.displayName;
ccwdata.NSCCarrierSafetyRating = clientOrganization.nscInformation.safetyRating;
}
// now try the individual service if there was no match.
if (foundNSCData == false)
{
ClientIndividual clientIndividual = _ccwService.GetCurrentClientIndividual(ccwdata.NSCClientNum, organizationNameCode, userId, guid, directory);
if (clientIndividual != null)
{
foundNSCData = true;
ccwdata.NSCCarrierConditions = clientIndividual.nscInformation.carrierStatus;
ccwdata.NSCCarrierName = clientIndividual.displayName;
ccwdata.NSCCarrierSafetyRating = clientIndividual.nscInformation.safetyRating;
}
}
}
if (ccwdata.Id > 0)
{
var bus = _context.SchoolBuss.FirstOrDefault(x => x.CCWDataId == ccwdata.Id);
var changes = _context.GetChanges(ccwdata, "DateFetched");
if (bus != null && changes.Count > 0)
{
var ccwNotification = (new CCWNotification
{
HasBeenViewed = false,
});
bus.CCWNotifications.Add(ccwNotification);
foreach (var change in changes)
{
ccwNotification.CCWNotificationDetails.Add(new CCWNotificationDetail
{
ColName = change.ColName,
ColDescription = change.ColDescription,
ValueFrom = change.ValueFrom,
ValueTo = change.ValueTo
});
}
}
}
else
{
_context.Add(ccwdata);
}
_logger.LogInformation($"{logPrefix} CCW data has been added/updated.");
_context.SaveChanges();
return(ccwdata);
}
