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));
        }
Example #2
0
        /// <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());
            }
        }
Example #3
0
        /// <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));
        }
Example #4
0
 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);
 }
Example #5
0
        public ActionResult DeleteConfirmed(int id)
        {
            DriverVehicle driverVehicle = db.DriverVehicles.Find(id);

            db.DriverVehicles.Remove(driverVehicle);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
Example #6
0
            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");
            }
Example #7
0
 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));
 }
Example #8
0
            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");
            }
Example #9
0
        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));
        }
Example #10
0
        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));
        }
Example #11
0
        // 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");
            }
Example #13
0
        // 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));
        }
Example #14
0
        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 }));
        }
Example #15
0
        /// <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));
        }
Example #16
0
        /// <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);
        }