public JsonResult DriversIndexByManager(string id) { List <DriverVehicle> data = new List <DriverVehicle>(); db.Configuration.ProxyCreationEnabled = false; List <AspNetManager_Drivers> sub = db.AspNetManager_Drivers.Where(r => r.ManagerID == id).ToList(); foreach (var item in sub) { var driverobj = db.AspNetUsers.FirstOrDefault(x => x.Id == item.DriverID); var drivervehicleobj = db.AspNetDriver_Vehicle.FirstOrDefault(s => s.DriverID == driverobj.Id); var vehicleobj = db.AspNetVehicles.FirstOrDefault(s => s.Id == drivervehicleobj.VehicleID); DriverVehicle drivervehicleObj = new DriverVehicle(); drivervehicleObj.ID = driverobj.Id; drivervehicleObj.UserName = driverobj.UserName; drivervehicleObj.PhoneNumber = driverobj.PhoneNumber; drivervehicleObj.Email = driverobj.Email; drivervehicleObj.VehicleID = vehicleobj.VehicleID; var test = data.Find(s => s.ID == driverobj.Id); if (test == null) { data.Add(drivervehicleObj); } } return(Json(data, JsonRequestBehavior.AllowGet)); }
/// <summary> /// GET: Vehicles/Create/id /// </summary> /// <param name="id"></param> /// <returns></returns> public async Task <ActionResult> Create(string id) { var vehicle = await context.DriverVehicles.FindAsync(id); if (vehicle != null) { // Vehicle found, redirect to details return(RedirectToAction("Details", new { Id = vehicle.Driver })); } var user = await context.Users.FindAsync(id); if (user != null && user.UserType.Equals("Driver")) { // Driver found DriverVehicle model = new DriverVehicle { Driver = user.Username }; ViewBag.Types = new SelectList(context.VehicleTypes, "Id", "Type"); return(View(model)); } else { // No driver found return(HttpNotFound()); } }
/// <summary> /// GET: Vehicles/Delete/id /// </summary> /// <param name="id"></param> /// <returns></returns> public async Task <ActionResult> Delete(string id) { if (id == null) { // No Id return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DriverVehicle vehicle = await context.DriverVehicles.FindAsync(id); if (vehicle == null) { // No vehicle found return(HttpNotFound()); } var reservations = context.Reservations.Where(r => r.User_Driver.Username == id); if (reservations.Count() != 0) { // On going reservation found var hasRequests = reservations.Where(r => r.Status == "Assigned" || r.Status == "Accepted"); if (hasRequests.Count() != 0) { // Assigned or Accepted reservation is found ViewBag.Message = "Please, respond to the available reservation requests, before attempting to delete this."; } } return(View(vehicle)); }
public async Task HandleAsync(CreateDriver command) { DriverVehicle driverVehicle = command.Vehicle; Vehicle vehicle = Vehicle.Create(driverVehicle.Brand, driverVehicle.Model, driverVehicle.Color, driverVehicle.SeatingCapacity); await driverService.RegisterAsync(command.UserId, vehicle); }
public ActionResult DeleteConfirmed(int id) { DriverVehicle driverVehicle = db.DriverVehicles.Find(id); db.DriverVehicles.Remove(driverVehicle); db.SaveChanges(); return(RedirectToAction("Index")); }
public async Task <Unit> Handle(Data request, CancellationToken cancellationToken) { Guid _Id = Guid.NewGuid(); var driver = new Driver { Id = _Id, DNI = request.DNI, FirstName = request.FirstName, LastName = request.LastName, TotalPoints = request.TotalPoints, LostPoints = 0, Status = true }; var findDNI = await _driverRepository.FindBy(f => f.DNI == driver.DNI); if (findDNI != null & findDNI.Count > 0) { throw new ExceptionHandler(HttpStatusCode.Conflict, new { mensaje = "DNI existing in the database" }); } _driverRepository.Add(driver); if (request.VehiclesList != null) { if (request.VehiclesList.Count > 10) { throw new ExceptionHandler(HttpStatusCode.Conflict, new { mensaje = "Driver cannot be habitual of more than 10 vehicles." }); } foreach (var id in request.VehiclesList) { var findVehicle = await _vehiclesRepository.FindBy(f => f.Id == id); if (!findVehicle.Any()) { throw new ExceptionHandler(HttpStatusCode.Conflict, new { mensaje = $"Vehicle does not exist: {id}." }); } var driverVehicle = new DriverVehicle { Id = Guid.NewGuid(), DriverId = driver.Id, VehicleId = id }; _driverVehicleRepository.Add(driverVehicle); } } var value = await _driverRepository.Commit(); if (value > 0) { return(Unit.Value); } throw new Exception("The record was not inserted"); }
public ActionResult Edit([Bind(Include = "Id,DriverId,VehicleId")] DriverVehicle driverVehicle) { if (ModelState.IsValid) { db.Entry(driverVehicle).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } ViewBag.DriverId = new SelectList(db.Drivers, "Id", "Name", driverVehicle.DriverId); ViewBag.VehicleId = new SelectList(db.Vehicles, "Id", "RegistrationNo", driverVehicle.VehicleId); return(View(driverVehicle)); }
public async Task <Unit> Handle(Data request, CancellationToken cancellationToken) { Guid _Id = Guid.NewGuid(); var vehicle = new Vehicle { Id = _Id, Enrollment = request.Enrollment, Brand = request.Brand, Model = request.Model, RegularDriver = request.RegularDriver, Status = true }; var findEnrollment = await _vehiclesRepository.FindBy(f => f.Enrollment == vehicle.Enrollment); if (findEnrollment != null & findEnrollment.Count > 0) { throw new ExceptionHandler(HttpStatusCode.Conflict, new { mensaje = "Enrollment existing in the database" }); } _vehiclesRepository.Add(vehicle); if (request.DriverList != null) { foreach (var id in request.DriverList) { var findDriver = await _driverRepository.FindBy(f => f.Id == id); if (!findDriver.Any()) { throw new ExceptionHandler(HttpStatusCode.Conflict, new { mensaje = $"Driver does not exist: {id}." }); } var driverVehicle = new DriverVehicle { Id = Guid.NewGuid(), DriverId = id, VehicleId = vehicle.Id }; _driverVehicleRepository.Add(driverVehicle); } } var value = await _vehiclesRepository.Commit(); if (value > 0) { return(Unit.Value); } throw new Exception("The record was not inserted"); }
public async Task <ActionResult> Edit([Bind(Include = "Driver,Type,Seats,Brand,VRN,LicenseNumber,InsuranceNumber,NIC")] DriverVehicle driverVehicle) { if (ModelState.IsValid) { // Update and redirect to details context.Entry(driverVehicle).State = EntityState.Modified; await context.SaveChangesAsync(); return(RedirectToAction("Details", new { Id = driverVehicle.Driver })); } ViewBag.Types = new SelectList(context.VehicleTypes, "Id", "Type", driverVehicle.Type); return(View(driverVehicle)); }
public async Task <ActionResult> Create([Bind(Include = "Driver,Type,Seats,Brand,VRN,LicenseNumber,InsuranceNumber,NIC")] DriverVehicle driverVehicle) { if (ModelState.IsValid) { // Save changes and redirect to the details page context.DriverVehicles.Add(driverVehicle); await context.SaveChangesAsync(); return(RedirectToAction("Details", new { Id = driverVehicle.Driver })); } ViewBag.Types = new SelectList(context.VehicleTypes, "Id", "Type", driverVehicle.Type); return(View(driverVehicle)); }
// GET: DriverVehicles/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DriverVehicle driverVehicle = db.DriverVehicles.Find(id); if (driverVehicle == null) { return(HttpNotFound()); } return(View(driverVehicle)); }
public async Task <Unit> Handle(Data request, CancellationToken cancellationToken) { Guid _Id = Guid.NewGuid(); var record = new DriverVehicle { Id = _Id, DriverId = request.DriverId, VehicleId = request.VehicleId }; var findDriver = await _driverRepository.FindBy(f => f.Id == record.DriverId); if (!findDriver.Any()) { throw new ExceptionHandler(HttpStatusCode.Conflict, new { mensaje = $"Driver does not exist: {record.DriverId}." }); } var findVehicle = await _vehiclesRepository.FindBy(f => f.Id == record.VehicleId); if (!findVehicle.Any()) { throw new ExceptionHandler(HttpStatusCode.Conflict, new { mensaje = $"Vehicle does not exist: {record.VehicleId}." }); } var findDuplicated = await _driverVehicleRepository.FindBy(f => f.DriverId == record.DriverId && f.VehicleId == record.VehicleId); if (findDuplicated != null & findDuplicated.Count() > 0) { throw new ExceptionHandler(HttpStatusCode.Conflict, new { mensaje = $"Record exist: {record.DriverId} - {record.VehicleId}." }); } var findCount = await _driverVehicleRepository.FindBy(f => f.DriverId == record.DriverId); if (findCount.Count > 10) { throw new ExceptionHandler(HttpStatusCode.Conflict, new { mensaje = $"Driver cannot be habitual of more than 10 vehicles. {record.DriverId}" }); } _driverVehicleRepository.Add(record); var value = await _driverVehicleRepository.Commit(); if (value > 0) { return(Unit.Value); } throw new Exception("The record was not inserted"); }
// GET: DriverVehicles/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DriverVehicle driverVehicle = db.DriverVehicles.Find(id); if (driverVehicle == null) { return(HttpNotFound()); } ViewBag.DriverId = new SelectList(db.Drivers, "Id", "Name", driverVehicle.DriverId); ViewBag.VehicleId = new SelectList(db.Vehicles, "Id", "RegistrationNo", driverVehicle.VehicleId); return(View(driverVehicle)); }
public async Task <ActionResult> DeleteConfirmed(string id) { // Delete the record and redirect to create DriverVehicle vehicle = await context.DriverVehicles.FindAsync(id); context.DriverVehicles.Remove(vehicle); DriverAvailability availability = await context.DriverAvailabilities.FindAsync(id); if (availability != null) { // Change availability status to false availability.Status = false; } await context.SaveChangesAsync(); return(RedirectToAction("Create", new { Id = vehicle.Driver })); }
/// <summary> /// GET: Vehicles/Details/id /// </summary> /// <param name="id"></param> /// <returns></returns> public async Task <ActionResult> Details(string id) { if (id == null) { // No Id return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DriverVehicle vehicle = await context.DriverVehicles.FindAsync(id); if (vehicle == null) { // No vehicle record found, redirect to create return(RedirectToAction("Create", new { Id = id })); } // Return to details return(View(vehicle)); }
/// <summary> /// GET: Vehicles/Edit/id /// </summary> /// <param name="id"></param> /// <returns></returns> public async Task <ActionResult> Edit(string id) { if (id == null) { // No Id return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } DriverVehicle vehicle = await context.DriverVehicles.FindAsync(id); if (vehicle == null) { // Vehicle not found return(HttpNotFound()); } ViewBag.Types = new SelectList(context.VehicleTypes, "Id", "Type", vehicle.Type); return(View(vehicle)); }
public DriverVehicle UpdateVehicle(DriverVehicle vehicle) { throw new NotImplementedException(); }
public bool EditDriverProfile(int driverProfileID, ProfileCardEntity profileCard, OrderFormEntity orderForm, List <DriverInterviewProfileEntity> driverInterviewProfiles, bool isSubmitted, List <DriverServiceEntity> driverServices) { bool isDriverProfileEdited = false; using (uow = new UnitOfWork.UnitOfWork()) { try { OrderForm orderFormdb = uow.OrderFormRepository.Get().Where(x => x.OrderFormID == driverProfileID).FirstOrDefault(); orderFormdb.PhysicalAddress = orderForm.PhysicalAddress; orderFormdb.BillingAddress = orderForm.BillingAddress; orderFormdb.CA = orderForm.CA; orderFormdb.ComplianceSupervisor = orderForm.ComplianceSupervisor; orderFormdb.DateTime = Helper.DateTimeJavaScript.GetCurrentTime().ToString(); orderFormdb.DBA = orderForm.DBA; orderFormdb.LegalName = orderForm.LegalName; orderFormdb.Name = orderForm.Name; orderFormdb.Email = orderForm.Email; orderFormdb.NameOnCard = orderForm.NameOnCard; orderFormdb.USDot = orderForm.USDot; orderFormdb.DriverPhone = orderForm.DriverPhone; orderFormdb.CompanyType = orderForm.CompanyType; orderFormdb.IsSubmitted = orderForm.IsSubmitted; orderFormdb.DOTPinNo = orderForm.DOTPinNo; orderFormdb.ComplianceUserID = orderForm.ComplianceUserID; orderFormdb.AdditionalPhoneNo = orderForm.AdditionalPhoneNo; orderFormdb.AdditionalPhoneType = orderForm.AdditionalPhoneType; uow.OrderFormRepository.Update(orderFormdb); uow.Save(); ProfileCard profileCarddb = uow.ProfileCardRepository.Get().Where(x => x.OrderFormID == driverProfileID).FirstOrDefault(); profileCarddb.CardType = profileCard.CardType; profileCarddb.CorDC = profileCard.CorDC; profileCarddb.CVC = profileCard.CVC; profileCarddb.OrderFormID = orderFormdb.OrderFormID; profileCarddb.Expiration = profileCard.Expiration; profileCarddb.IsSubmitted = profileCard.IsSubmitted; uow.ProfileCardRepository.Update(profileCarddb); uow.Save(); List <DriverService> usDotServiceTemp = uow.DriverServiceRepository.Get().Where(x => x.DriverInterviewProfileID == orderFormdb.OrderFormID).ToList(); foreach (DriverService service in usDotServiceTemp) { uow.DriverServiceRepository.Delete(service); uow.Save(); } if (driverServices != null) { foreach (DriverServiceEntity driverService in driverServices) { DriverService driverServicedb = new DriverService(); driverServicedb.DriverInterviewProfileID = orderFormdb.OrderFormID; driverServicedb.ServiceID = driverService.ServiceID; uow.DriverServiceRepository.Insert(driverServicedb); uow.Save(); } } List <DriverInterviewProfile> usDotDriverInterviewProfileTemp = uow.DriverInterviewProfileRepository.Get().Where(x => x.OrderFormID == driverProfileID).ToList(); foreach (DriverInterviewProfile item in usDotDriverInterviewProfileTemp) { List <DriverVehicleCargo> usDotVehicleCargoTemp = uow.DriverVehicleCargoRepository.Get().Where(x => x.DriverVehicleID == item.DriverInterviewID).ToList(); foreach (DriverVehicleCargo vehicleCargo in usDotVehicleCargoTemp) { uow.DriverVehicleCargoRepository.Delete(vehicleCargo); uow.Save(); } List <DriverVehicle> usDotVehicleTemp = uow.DriverVehicleRepository.Get().Where(x => x.OrderFormID == item.DriverInterviewID).ToList(); foreach (DriverVehicle vehicleCargo in usDotVehicleTemp) { uow.DriverVehicleRepository.Delete(vehicleCargo); uow.Save(); } uow.DriverInterviewProfileRepository.Delete(item); uow.Save(); } foreach (DriverInterviewProfileEntity driverInterviewProfile in driverInterviewProfiles) { DriverInterviewProfile driverInterviewProfiledb = new DriverInterviewProfile(); driverInterviewProfiledb.Class = driverInterviewProfile.Class; driverInterviewProfiledb.Date = driverInterviewProfile.Date; driverInterviewProfiledb.DOB = driverInterviewProfile.DOB; driverInterviewProfiledb.DriverName = driverInterviewProfile.DriverName; driverInterviewProfiledb.OrderFormID = orderFormdb.OrderFormID; driverInterviewProfiledb.EIN = driverInterviewProfile.EIN; driverInterviewProfiledb.Email = driverInterviewProfile.Email; driverInterviewProfiledb.ExpirationDate = driverInterviewProfile.ExpirationDate; driverInterviewProfiledb.LegalName = driverInterviewProfile.LegalName; driverInterviewProfiledb.LicenseNo = driverInterviewProfile.LicenseNo; driverInterviewProfiledb.Notes = driverInterviewProfile.Notes; driverInterviewProfiledb.Phone = driverInterviewProfile.Phone; driverInterviewProfiledb.SSN = driverInterviewProfile.SSN; driverInterviewProfiledb.StatusIssued = driverInterviewProfile.StatusIssued; driverInterviewProfiledb.Supervisor = driverInterviewProfile.Supervisor; driverInterviewProfiledb.USDOT = driverInterviewProfile.USDOT; driverInterviewProfiledb.CDLNonCDL = driverInterviewProfile.CDLNonCDL; driverInterviewProfiledb.IsSubmitted = driverInterviewProfile.IsSubmitted; uow.DriverInterviewProfileRepository.Insert(driverInterviewProfiledb); uow.Save(); if (driverInterviewProfile.DriverCargos != null) { foreach (DriverVehicleCargoEntity drivercargo in driverInterviewProfile.DriverCargos) { DriverVehicleCargo driverVehicleCargodb = new DriverVehicleCargo(); driverVehicleCargodb.DriverVehicleID = driverInterviewProfiledb.DriverInterviewID; driverVehicleCargodb.CargoCarriedName = drivercargo.CargoCarriedName; uow.DriverVehicleCargoRepository.Insert(driverVehicleCargodb); uow.Save(); } } DriverVehicle driverVehicledb = new DriverVehicle(); driverVehicledb.OrderFormID = driverInterviewProfiledb.DriverInterviewID; driverVehicledb.DriverVehicleInfo = driverInterviewProfile.DriverVehicle.DriverVehicleInfo; driverVehicledb.GVW = driverInterviewProfile.DriverVehicle.GVW; driverVehicledb.Make = driverInterviewProfile.DriverVehicle.Make; driverVehicledb.Model = driverInterviewProfile.DriverVehicle.Model; driverVehicledb.Year = driverInterviewProfile.DriverVehicle.Year; uow.DriverVehicleRepository.Insert(driverVehicledb); uow.Save(); } isDriverProfileEdited = true; } catch { isDriverProfileEdited = false; } } return(isDriverProfileEdited); }
public int AddDriverProfile(ProfileCardEntity profileCard, OrderFormEntity orderForm, List <DriverInterviewProfileEntity> driverInterviewProfiles, List <DriverServiceEntity> driverServices) { int driverProfileID = 0; using (uow = new UnitOfWork.UnitOfWork()) { try { OrderForm orderFormdb = new OrderForm(); orderFormdb.PhysicalAddress = orderForm.PhysicalAddress; orderFormdb.BillingAddress = orderForm.BillingAddress; orderFormdb.CA = orderForm.CA; orderFormdb.ComplianceSupervisor = orderForm.ComplianceSupervisor; orderFormdb.DateTime = Helper.DateTimeJavaScript.GetCurrentTime().ToString(); orderFormdb.DBA = orderForm.DBA; orderFormdb.LegalName = orderForm.LegalName; orderFormdb.Name = orderForm.Name; orderFormdb.Email = orderForm.Email; orderFormdb.NameOnCard = orderForm.NameOnCard; orderFormdb.OrderFormID = orderForm.OrderFormID; orderFormdb.USDot = orderForm.USDot; orderFormdb.DriverPhone = orderForm.DriverPhone; orderFormdb.CompanyType = orderForm.CompanyType; orderFormdb.IsSubmitted = orderForm.IsSubmitted; orderFormdb.ComplianceUserID = orderForm.ComplianceUserID; orderFormdb.SaleID = orderForm.SaleID; orderFormdb.DOTPinNo = orderForm.DOTPinNo; orderFormdb.AdditionalPhoneNo = orderForm.AdditionalPhoneNo; orderFormdb.AdditionalPhoneType = orderForm.AdditionalPhoneType; uow.OrderFormRepository.Insert(orderFormdb); uow.Save(); ProfileCard profileCarddb = new ProfileCard(); profileCarddb.CardType = profileCard.CardType; profileCarddb.CorDC = profileCard.CorDC; profileCarddb.CVC = profileCard.CVC; profileCarddb.OrderFormID = orderFormdb.OrderFormID; profileCarddb.Expiration = profileCard.Expiration; profileCarddb.ProfileCardInfo = profileCard.ProfileCardInfo; profileCarddb.IsSubmitted = profileCard.IsSubmitted; uow.ProfileCardRepository.Insert(profileCarddb); uow.Save(); foreach (DriverServiceEntity driverService in driverServices) { DriverService driverServicedb = new DriverService(); driverServicedb.DriverInterviewProfileID = orderFormdb.OrderFormID; driverServicedb.ServiceID = driverService.ServiceID; uow.DriverServiceRepository.Insert(driverServicedb); uow.Save(); } foreach (DriverInterviewProfileEntity driverInterviewProfile in driverInterviewProfiles) { DriverInterviewProfile driverInterviewProfiledb = new DriverInterviewProfile(); driverInterviewProfiledb.Class = driverInterviewProfile.Class; driverInterviewProfiledb.Date = driverInterviewProfile.Date; driverInterviewProfiledb.DOB = driverInterviewProfile.DOB; driverInterviewProfiledb.DriverName = driverInterviewProfile.DriverName; driverInterviewProfiledb.OrderFormID = orderFormdb.OrderFormID; driverInterviewProfiledb.EIN = driverInterviewProfile.EIN; driverInterviewProfiledb.Email = driverInterviewProfile.Email; driverInterviewProfiledb.ExpirationDate = driverInterviewProfile.ExpirationDate; driverInterviewProfiledb.LegalName = driverInterviewProfile.LegalName; driverInterviewProfiledb.LicenseNo = driverInterviewProfile.LicenseNo; driverInterviewProfiledb.Notes = driverInterviewProfile.Notes; driverInterviewProfiledb.Phone = driverInterviewProfile.Phone; driverInterviewProfiledb.SSN = driverInterviewProfile.SSN; driverInterviewProfiledb.StatusIssued = driverInterviewProfile.StatusIssued; driverInterviewProfiledb.Supervisor = driverInterviewProfile.Supervisor; driverInterviewProfiledb.USDOT = driverInterviewProfile.USDOT; driverInterviewProfiledb.CDLNonCDL = driverInterviewProfile.CDLNonCDL; driverInterviewProfiledb.IsSubmitted = driverInterviewProfile.IsSubmitted; uow.DriverInterviewProfileRepository.Insert(driverInterviewProfiledb); uow.Save(); foreach (DriverVehicleCargoEntity drivercargo in driverInterviewProfile.DriverCargos) { DriverVehicleCargo driverVehicleCargodb = new DriverVehicleCargo(); driverVehicleCargodb.DriverVehicleID = driverInterviewProfiledb.DriverInterviewID; driverVehicleCargodb.CargoCarriedName = drivercargo.CargoCarriedName; uow.DriverVehicleCargoRepository.Insert(driverVehicleCargodb); uow.Save(); } DriverVehicle driverVehicledb = new DriverVehicle(); driverVehicledb.OrderFormID = driverInterviewProfiledb.DriverInterviewID; driverVehicledb.DriverVehicleInfo = driverInterviewProfile.DriverVehicle.DriverVehicleInfo; driverVehicledb.GVW = driverInterviewProfile.DriverVehicle.GVW; driverVehicledb.Make = driverInterviewProfile.DriverVehicle.Make; driverVehicledb.Model = driverInterviewProfile.DriverVehicle.Model; driverVehicledb.Year = driverInterviewProfile.DriverVehicle.Year; uow.DriverVehicleRepository.Insert(driverVehicledb); uow.Save(); } } catch { driverProfileID = 0; } } return(driverProfileID); }