예제 #1
0
        public ResultDto Update([FromBody] TruckTypeDto model)
        {
            if (!ModelState.IsValid)
            {
                return new ResultDto
                       {
                           Success = false,
                           Message = "Não foi possível alterar os dados do caminhão."
                       }
            }
            ;


            var update = new TruckType(model.TruckTypeId, model.Name);

            _repository.Update(update);

            var resultTruckTypeDto = new ResultTruckTypeDto(update.TruckTypeId, update.Name);

            return(new ResultDto
            {
                Success = true,
                Message = "Dados atualizados com sucesso.",
                Data = resultTruckTypeDto
            });
        }
    }
예제 #2
0
        public TruckType GetTruckTypeRecord(string recordID, string UserSNo)
        {
            TruckType     TruckType = new TruckType();
            SqlDataReader dr        = null;

            try
            {
                SqlParameter[] Parameters = { new SqlParameter("@SNo", recordID), new SqlParameter("@UserID", Convert.ToInt32(UserSNo)) };
                dr = SqlHelper.ExecuteReader(DMLConnectionString.WebConfigConnectionString, CommandType.StoredProcedure, "GetRecordTruckType", Parameters);
                if (dr.Read())
                {
                    TruckType.SNo      = Convert.ToInt32(recordID);
                    TruckType.IsActive = Convert.ToBoolean(dr["IsActive"]);
                    if (!String.IsNullOrEmpty(dr["IsActive"].ToString()))
                    {
                        TruckType.IsActive = Convert.ToBoolean(dr["IsActive"]);
                        TruckType.Active   = dr["Active"].ToString().ToUpper();
                    }
                    TruckType.Name      = Convert.ToString(dr["Name"]).ToUpper();
                    TruckType.UpdatedBy = dr["UpdatedUser"].ToString();
                    TruckType.CreatedBy = dr["CreatedUser"].ToString();
                }
            }
            catch (Exception ex)//
            {
                dr.Close();
                throw ex;
            }
            return(TruckType);
        }
예제 #3
0
        private async void bookBtn_Click(object sender, EventArgs e)
        {
            TruckType type = await db.GetTruckTypeById((int)slctTruckBox.SelectedValue);

            //List<Truck> trucks = await db.GetAvailiableTrucks(type);
            try
            {
                Truck truck = await db.GetNextAvailableTruck(type);

                List <User> users = await db.GetAvailibleDrivers();//[0];

                User  user  = users[0];
                Route route = await db.GetRouteByID((int)destinationBox.SelectedValue);

                TripStatus status = await db.GetTripStatusByID(0);

                Customer customer = await db.GetCustomerByID((int)cmbCustomers.SelectedValue);

                Trip trip = new Trip(truck, customer, (DateTime)dateTimePicker.Value, (DateTime)dateTimePicker.Value.AddDays(3), user, route, status);

                trip = await db.BookTrip(trip);

                MessageBox.Show($"Trip booked for {trip.Start} with Truck {trip.Truck.ID}");
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.Message);
                MessageBox.Show("Next availible date: " + await db.NextAvailibleDate(type));
                return;
            }



            this.Close();
        }
        /// <summary cref="IEncodeable.IsEqual(IEncodeable)" />
        public override bool IsEqual(IEncodeable encodeable)
        {
            if (Object.ReferenceEquals(this, encodeable))
            {
                return(true);
            }

            TruckType value = encodeable as TruckType;

            if (value == null)
            {
                return(false);
            }

            if (!base.IsEqual(encodeable))
            {
                return(false);
            }
            if (!Utils.IsEqual(m_cargoCapacity, value.m_cargoCapacity))
            {
                return(false);
            }

            return(true);
        }
예제 #5
0
        public void Update_BadTruckType_Throws(TruckType truckType)
        {
            var model = new Truck
            {
                Id              = Guid.NewGuid(),
                TruckType       = TruckType.FH,
                ModelYear       = DateTime.Now.Year,
                FabricationYear = DateTime.Now.Year,
                Name            = "Truck",
                Plate           = "AAA0000"
            };

            using var context = this.BuildContext();
            context.Trucks.Add(model);
            context.SaveChanges();

            var subject = this.BuildService(context);

            Assert.Throws <ValidationException>(() => subject.Update(model.Id.ToString(), new UpdateTruckInput
            {
                TruckType       = truckType,
                ModelYear       = DateTime.Now.Year,
                FabricationYear = DateTime.Now.Year,
                Name            = "Truck",
                Plate           = "AAA0000"
            }));
        }
 private void SaveTruckType()
 {
     try
     {
         if (truckTypeId == 0)
         {
             var truckType = new TruckType
             {
                 TruckTypeId   = truckTypeId,
                 TruckTypeDesc = txtTruckTypeName.Text.Trim(),
                 Active        = chkActive.Checked,
                 CreateBy      = "system",
             };
             TruckTypeController.Insert(truckType);
         }
         else
         {
             var truckType = new TruckType
             {
                 TruckTypeId   = this.truckTypeId,
                 TruckTypeDesc = txtTruckTypeName.Text.Trim(),
                 Active        = chkActive.Checked,
                 ModifiedBy    = "system",
             };
             truckType.TruckTypeId = Convert.ToInt32(txtTruckTypeId.Text);
             TruckTypeController.Update(truckType);
         }
     }
     catch (Exception)
     {
         throw;
     }
 }
예제 #7
0
 public Trucks(TruckType typeOfTruck, int year, string color, Towing towing)
 {
     TypeOfTruck = typeOfTruck;//I don't understand this naming
     Year        = year;
     Color       = color;
     Towing      = towing;
 }
예제 #8
0
        public ResultDto Add([FromBody] TruckTypeDto model)
        {
            if (!ModelState.IsValid)
            {
                return new ResultDto
                       {
                           Success = false,
                           Message = "Não foi possível cadastrar caminhão."
                       }
            }
            ;

            var truckType = new TruckType(model.TruckTypeId, model.Name);

            _repository.Add(truckType);

            var resultTruckTypeDto = new ResultTruckTypeDto(truckType.TruckTypeId, truckType.Name);

            return(new ResultDto
            {
                Success = true,
                Message = "Caminhão cadastrado com sucesso.",
                Data = resultTruckTypeDto
            });
        }
        public async Task <List <FreightDTO> > GetFreightListAsync()
        {
            try
            {
                List <Freight> data = await _repFreight.GetAllAsQueryable().ToListAsync();

                List <FreightDTO> datas = new List <FreightDTO>();

                foreach (var item in data)
                {
                    FreightDTO freightDTO = new FreightDTO();
                    freightDTO.ID            = item.ID;
                    freightDTO.BaseTruckRent = item.BaseTruckRent;
                    freightDTO.SourceCityId  = item.SourceCityId;

                    City city = _repCity.GetAllAsQueryable().Where(c => c.Code == item.SourceCityId).FirstOrDefault();

                    freightDTO.SourceCityName    = city.CityName;
                    freightDTO.DestinationCityId = item.DestinationCityId;

                    City cityDes = _repCity.GetAllAsQueryable().Where(c => c.Code == item.DestinationCityId).FirstOrDefault();

                    freightDTO.DestinationCityName = cityDes.CityName;
                    freightDTO.CreateDate          = item.CreateDate;
                    freightDTO.LoadDate            = item.LoadDate;
                    freightDTO.LoadTime            = item.LoadTime;
                    freightDTO.ExpireDate          = item.ExpireDate;
                    freightDTO.ExpireTime          = item.ExpireTime;
                    freightDTO.PackageType         = item.PackageType;
                    freightDTO.GoodName            = item.GoodName;

                    PackageType packageType = _repPackageType.GetAllAsQueryable().Where(c => c.ID == item.PackageType).FirstOrDefault();

                    freightDTO.PackageName = packageType.Name;
                    freightDTO.TruckType   = item.TruckType;

                    TruckType truckType = _repTruckType.GetAllAsQueryable().Where(c => c.ID == item.TruckType).FirstOrDefault();

                    freightDTO.TruckName  = truckType.Name;
                    freightDTO.LoaderType = item.LoaderType;

                    Loader loader = _repLoader.GetAllAsQueryable().Where(c => c.ID == item.LoaderType).FirstOrDefault();

                    freightDTO.loaderName    = loader.Name;
                    freightDTO.Weight        = item.Weight;
                    freightDTO.Description   = item.Description;
                    freightDTO.Tell          = item.Tell;
                    freightDTO.BaseTruckRent = item.BaseTruckRent;
                    freightDTO.BaseTruckRent = item.BaseTruckRent;
                    datas.Add(freightDTO);
                }

                return(datas);
            }
            catch (Exception e)
            {
                throw new ServiceExeption(e.Message, e);
            }
        }
예제 #10
0
 /// <summary>
 /// Spawn a new truck on the center of the AR board
 /// </summary>
 /// <param name="truck"></param>
 private void SpawnTruck(TruckType truck)
 {
     DespawnTruck(mainTruck);
     MessageBroker.Default.Publish(new SpawnTruckMessage()
     {
         Type = truck, Truck = OnTruckReceived
     });
 }
        /// <summary cref="Object.MemberwiseClone" />
        public new object MemberwiseClone()
        {
            TruckType clone = (TruckType)base.MemberwiseClone();

            clone.m_cargoCapacity = (uint)Utils.Clone(this.m_cargoCapacity);

            return(clone);
        }
예제 #12
0
        public ActionResult DeleteConfirmed(int id)
        {
            TruckType truckType = db.TruckTypes.Find(id);

            db.TruckTypes.Remove(truckType);
            db.SaveChanges();
            return(RedirectToAction("Index"));
        }
예제 #13
0
 public ActionResult Edit([Bind(Include = "Id,TruckTypeName")] TruckType truckType)
 {
     if (ModelState.IsValid)
     {
         db.Entry(truckType).State = EntityState.Modified;
         db.SaveChanges();
         return(RedirectToAction("Index"));
     }
     return(View(truckType));
 }
예제 #14
0
        private async void AddTruckBtn_Click(object sender, EventArgs e)
        {
            string    Vin  = vinTxtBox.Text;
            string    Reg  = regTxtBox.Text;
            int       Kms  = Convert.ToInt32(mileageBox.Text);
            TruckType type = await db.GetTruckTypeById((int)typeComboBox.SelectedValue);

            Truck truck = new Truck(Vin, Reg, Kms, true, type);

            db.AddTruck(truck);
        }
예제 #15
0
        public ActionResult Create([Bind(Include = "Id,TruckTypeName")] TruckType truckType)
        {
            if (ModelState.IsValid)
            {
                db.TruckTypes.Add(truckType);
                db.SaveChanges();
                return(RedirectToAction("Index"));
            }

            return(View(truckType));
        }
예제 #16
0
 public Truck(TruckType NewTruckType)
 {
     TypeOfTruck = NewTruckType;
     Guid Id = Guid.NewGuid();
     List<IVehicleTire> Tires = new List<IVehicleTire>();
     for(int i=0;i==3;i++)
     {
         //Create 4 tires
         TruckTire currentTire = new TruckTire(this, i);
         _tires.Add(currentTire);
     }
 }
예제 #17
0
        public Truck(TruckType NewTruckType)
        {
            TypeOfTruck = NewTruckType;
            Guid Id = Guid.NewGuid();
            List <IVehicleTire> Tires = new List <IVehicleTire>();

            for (int i = 0; i == 3; i++)
            {
                //Create 4 tires
                TruckTire currentTire = new TruckTire(this, i);
                _tires.Add(currentTire);
            }
        }
예제 #18
0
        // GET: TruckType/Delete/5
        public ActionResult Delete(int?id)
        {
            if (id == null)
            {
                return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
            }
            TruckType truckType = db.TruckTypes.Find(id);

            if (truckType == null)
            {
                return(HttpNotFound());
            }
            return(View(truckType));
        }
        /// <summary>
        /// Truck routing only, specifies the vehicle type.Defaults to truck.
        /// </summary>
        /// <param name="tpParams"></param>
        /// <param name="valeur">Enum [truck | tractorTruck]</param>
        public static void AddTruckType(this RouteTruckOptions tpParams, TruckType valeur)
        {
            if (tpParams == null)
            {
                throw new ArgumentNullException(nameof(tpParams));
            }
            string nom   = "truckType";
            var    param = new ParamsEnum <TruckType>(nom, valeur);

            if (!tpParams.Parametres.TryAdd(nom, param))
            {
                tpParams.Parametres.Remove(nom);
                tpParams.Parametres.Add(nom, param);
            }
        }
 private void LoadData()
 {
     try
     {
         if (this.truckTypeId > 0)
         {
             TruckType truckType = TruckTypeController.GetTruckType(this.truckTypeId);
             txtTruckTypeId.Text   = this.truckTypeId.ToString();;
             txtTruckTypeName.Text = truckType.TruckTypeDesc;
             chkActive.Checked     = truckType.Active;
             BtnSaveAndNew.Visible = false;
             //txtTruckNo.Enabled = false;
         }
     }
     catch (Exception)
     {
     }
 }
예제 #21
0
        public async Task GetTruckTypeByNameAsync_WithNullTypeName_ShouldRetyrnArgumentNullException()
        {
            var context    = SteuDbContextInMemoryFactory.InitializeContext();
            var service    = this.IntializeTruckTypesService(context);
            var repository = new EfRepository <TruckType>(context);

            var truckType = new TruckType()
            {
                Name = "Normal",
            };

            await repository.AddAsync(truckType);

            await repository.SaveChangesAsync();

            await Assert.ThrowsAsync <ArgumentNullException>(()
                                                             => service.GetTruckTypeByNameAsync(null));
        }
예제 #22
0
        // Setup the vehicle based on the type of truck it is. Every truck is
        // required to have a name.
        public Vehicle(TruckType truckType, string truckName)
        {
            this.truckName = truckName;
            this.truckType = truckType;

            txFreq_medic   = 40;
            rxFreq_medic   = 40;
            txFreq_command = 45;
            rxFreq_command = 45;
            txFreq_sat     = 300000;
            rxFreq_sat     = 350000;
            txFreq_special = 50;
            rxFreq_special = 50;
            txFreq_ops     = 55;
            rxFreq_ops     = 55;

            RadiosInTruckByType();
        }
예제 #23
0
 public ActionResult GridViewUpdate([ModelBinder(typeof(XpoModelBinder))] TruckType item)
 {
     using (UnitOfWork uow = new UnitOfWork())
     {
         var model = uow.Query <TruckType>();
         if (ModelState.IsValid)
         {
             if (item.IsChanged)
             {
                 item.Save();
             }
         }
         else
         {
             ViewData["EditError"] = "Please, correct all errors.";
         }
         return(PartialView("_GridViewPartial", model.ToList()));
     }
 }
예제 #24
0
        public async Task GetAllTruckTypesAsyncTest_WithData_RreturnListOfTruckTypes()
        {
            var context    = SteuDbContextInMemoryFactory.InitializeContext();
            var service    = this.IntializeTruckTypesService(context);
            var repository = new EfRepository <TruckType>(context);

            var truckType = new TruckType()
            {
                Name = "Normal",
            };

            await repository.AddAsync(truckType);

            await repository.SaveChangesAsync();

            var actualResult = await service.GetAllTruckTypesAsync <AllTruckTypesTruckEditViewModel>();

            Assert.Single(actualResult);
        }
예제 #25
0
        public async Task GetTruckTypeByNameAsync_WithValidTruckTypeName_RreturnTruckType()
        {
            var context    = SteuDbContextInMemoryFactory.InitializeContext();
            var service    = this.IntializeTruckTypesService(context);
            var repository = new EfRepository <TruckType>(context);

            var truckType = new TruckType()
            {
                Name = "Normal",
            };

            await repository.AddAsync(truckType);

            await repository.SaveChangesAsync();

            var actualResult = await service.GetTruckTypeByNameAsync("Normal");

            Assert.Equal("Normal", actualResult.Name);
        }
예제 #26
0
 public ActionResult GridViewAddNew([ModelBinder(typeof(XpoModelBinder))] TruckType item)
 {
     using (UnitOfWork uow = new UnitOfWork())
     {
         var model = uow.Query <TruckType>();
         if (ModelState.IsValid)
         {
             var truckType = new TruckType(uow)
             {
                 Type = item.Type
             };
             uow.CommitChanges();
         }
         else
         {
             ViewData["EditError"] = "Please, correct all errors.";
         }
         return(PartialView("_GridViewPartial", model.ToList()));
     }
 }
예제 #27
0
        private List <Truck> GenerateTrucks(TruckType type)
        {
            var trucks = new List <Truck>();

            for (var i = 0; i < 5; i++)
            {
                var truck = new Truck {
                    Places = new List <Place>()
                };

                for (var j = 0; j < 50; j++)
                {
                    truck.Places.Add(new Place
                    {
                        Id       = j,
                        Reserved = _random.Next(0, 2) == 1
                    });
                }
                trucks.Add(truck);
            }
            return(trucks);
        }
예제 #28
0
        public void Create_BadTruckType_Throws(TruckType truckType)
        {
            var model = new Truck
            {
                Id              = Guid.NewGuid(),
                TruckType       = TruckType.FH,
                ModelYear       = DateTime.Now.Year,
                FabricationYear = DateTime.Now.Year,
                Name            = "Truck",
                Plate           = "AAA0000"
            };

            using var context = this.BuildContext();
            var subject = this.BuildService(context);

            Assert.Throws <ValidationException>(() => subject.Create(new CreateTruckInput
            {
                TruckType       = truckType,
                ModelYear       = DateTime.Now.Year,
                FabricationYear = DateTime.Now.Year,
                Name            = "Truck",
                Plate           = "AAA0000"
            }));
        }
        public static void Initialize(TrnspMngmntContext context)
        {
            context.Database.EnsureCreated();

            // Look for any students.
            if (context.Cargoes.Any())
            {
                return;   // DB has been seeded
            }

            var trucktypes = new TruckType[]
            {
                new TruckType {
                    TruckTypeID = 10, TypeName = "Tilt"
                },
                new TruckType {
                    TruckTypeID = 11, TypeName = "Refrigirator"
                },
                new TruckType {
                    TruckTypeID = 12, TypeName = "Metal Trailer"
                },
                new TruckType {
                    TruckTypeID = 13, TypeName = "Insulated Truck"
                },
                new TruckType {
                    TruckTypeID = 14, TypeName = "Car transporter"
                }
            };

            foreach (TruckType c in trucktypes)
            {
                context.TruckTypes.Add(c);
            }
            context.SaveChanges();

            //var companies = new Company[]
            //{
            //    new Company{Name="WhatisloveCorp",Email="*****@*****.**",Phone="+380963083105"},
            //    new Company{Name="VicitalCorp",Email="*****@*****.**",Phone="+380502052146"},
            //    new Company{Name="ViktoriaCorp",Email="*****@*****.**",Phone="+380963073808"}
            //};
            //foreach (Company c in companies)
            //{
            //    context.Companies.Add(c);
            //}
            //context.SaveChanges();

            //var cargos = new Cargo[]
            //{
            //new Cargo{StartOfShipping=DateTime.Parse("2019-05-02"),EndOfShipping=DateTime.Parse("2019-06-02"),Departure="Vinnitsia",
            //    Destination ="Kyiv",Info="Details",Weight=10000,Volume=123,
            //    CompanyID =companies.Single(i=>i.Name=="WhatisloveCorp").Id,TruckTypeID=10},
            //new Cargo{StartOfShipping=DateTime.Parse("2019-05-03"),EndOfShipping=DateTime.Parse("2019-06-03"),Departure="Zaporizzia",
            //    Destination ="Kyiv",Info="Milk",Weight=1000,Volume=100,
            //    CompanyID =companies.Single(i=>i.Name=="WhatisloveCorp").Id,TruckTypeID=11},
            //new Cargo{StartOfShipping=DateTime.Parse("2019-05-04"),EndOfShipping=DateTime.Parse("2019-06-04"),Departure="Vinnitsia",
            //    Destination ="Lviv",Info="Choklate",Weight=15000,Volume=90,
            //    CompanyID =companies.Single(i=>i.Name=="ViktoriaCorp").Id,TruckTypeID=11},
            //new Cargo{StartOfShipping=DateTime.Parse("2019-07-02"),EndOfShipping=DateTime.Parse("2019-08-02"),Departure="Kherson",
            //    Destination ="Odessa",Info="Souseges",Weight=9000,Volume=20,
            //    CompanyID =companies.Single(i=>i.Name=="VicitalCorp").Id,
            //    TruckTypeID =12},
            //new Cargo{StartOfShipping=DateTime.Parse("2019-08-02"),EndOfShipping=DateTime.Parse("2019-08-02"),Departure="Zhytomyr",
            //    Destination ="Simpheropol",Info="Armor",Weight=70000,Volume=50,
            //    CompanyID =companies.Single(i=>i.Name=="ViktoriaCorp").Id,TruckTypeID=14}
            //};
            //foreach (Cargo s in cargos)
            //{
            //    context.Cargoes.Add(s);
            //}
            //context.SaveChanges();

            //var transports = new Transport[]
            //{
            //new Transport{StartOfShipping=DateTime.Parse("2019-05-02"),EndOfShipping=DateTime.Parse("2019-06-02"),Departure="Zaporizzia",Destination="Vinnitsia",MaxWeight=10000,MaxVolume=123,CompanyID=companies.Single(i=>i.Name=="ViktoriaCorp").Id,TruckTypeID=10,Type=Models.Type.Truck},
            //new Transport{StartOfShipping=DateTime.Parse("2019-05-03"),EndOfShipping=DateTime.Parse("2019-06-03"),Departure="Zaporizzia",Destination="Kyiv",MaxWeight=1000,MaxVolume=100,CompanyID=companies.Single(i=>i.Name=="WhatisloveCorp").Id,TruckTypeID=11,Type=Models.Type.Semitrailer},
            //new Transport{StartOfShipping=DateTime.Parse("2019-05-04"),EndOfShipping=DateTime.Parse("2019-05-07"),Departure="Vinnitsia",Destination="Lviv",MaxWeight=15000,MaxVolume=90,CompanyID=companies.Single(i=>i.Name=="VicitalCorp").Id,TruckTypeID=11,Type=Models.Type.Truck},
            //new Transport{StartOfShipping=DateTime.Parse("2019-07-05"),EndOfShipping=DateTime.Parse("2019-07-06"),Departure="Mykolaiv",Destination="Odessa",MaxWeight=9000,MaxVolume=20,CompanyID=companies.Single(i=>i.Name=="VicitalCorp").Id,TruckTypeID=12,Type=Models.Type.DoubleRoadTrain},
            //new Transport{StartOfShipping=DateTime.Parse("2019-08-04"),EndOfShipping=DateTime.Parse("2019-09-05"),Departure="Zhytomyr",Destination="Simpheropol",MaxWeight=70000,MaxVolume=50,CompanyID=companies.Single(i=>i.Name=="ViktoriaCorp").Id,TruckTypeID=14,Type=Models.Type.DoubleRoadTrain}
            //};
            //foreach (Transport s in transports)
            //{
            //    context.Transports.Add(s);
            //}
            //context.SaveChanges();
        }
        public async Task <List <FreightDTO> > GetFreightListAsync(FilterFreightDTO filter)
        {
            try
            {
                var query = _repFreight.GetAllAsQueryable();
                if (filter.DestinationCityId > 0)
                {
                    int IntegerDestination = (filter.DestinationCityId) / 1000000;
                    query = query.Where(c => (c.DestinationCityId) / 1000000 == IntegerDestination);
                }

                if (filter.SourceCityId > 0)
                {
                    int IntegerSource = (filter.SourceCityId) / 1000000;
                    query = query.Where(c => (c.SourceCityId) / 1000000 == IntegerSource);
                }

                if (filter.Weight >= 3)
                {
                    query = query.Where(c => c.Weight >= 3);
                }
                else if (filter.Weight < 3 && filter.Weight > 1)
                {
                    query = query.Where(c => c.Weight < 3);
                }

                if (filter.LoadDate != null)
                {
                    query = query.Where(c => string.Compare(c.LoadDate, filter.LoadDate) >= 0);
                }

                if (filter.ExpireDate != null)
                {
                    query = query.Where(c => string.Compare(c.ExpireDate, filter.ExpireDate) <= 0);
                }

                List <Freight> data = await query.ToListAsync();

                List <FreightDTO> datas = new List <FreightDTO>();

                foreach (var item in data)
                {
                    FreightDTO freightDTO = new FreightDTO();
                    freightDTO.ID            = item.ID;
                    freightDTO.BaseTruckRent = item.BaseTruckRent;
                    freightDTO.SourceCityId  = item.SourceCityId;

                    City city = _repCity.GetAllAsQueryable().Where(c => c.Code == item.SourceCityId).FirstOrDefault();

                    freightDTO.SourceCityName    = city.CityName;
                    freightDTO.DestinationCityId = item.DestinationCityId;

                    City cityDes = _repCity.GetAllAsQueryable().Where(c => c.Code == item.DestinationCityId).FirstOrDefault();

                    freightDTO.DestinationCityName = cityDes.CityName;
                    freightDTO.CreateDate          = item.CreateDate;
                    freightDTO.LoadDate            = item.LoadDate;
                    freightDTO.LoadTime            = item.LoadTime;
                    freightDTO.ExpireDate          = item.ExpireDate;
                    freightDTO.ExpireTime          = item.ExpireTime;
                    freightDTO.PackageType         = item.PackageType;
                    freightDTO.GoodName            = item.GoodName;

                    PackageType packageType = _repPackageType.GetAllAsQueryable().Where(c => c.ID == item.PackageType).FirstOrDefault();

                    freightDTO.PackageName = packageType.Name;
                    freightDTO.TruckType   = item.TruckType;

                    TruckType truckType = _repTruckType.GetAllAsQueryable().Where(c => c.ID == item.TruckType).FirstOrDefault();

                    freightDTO.TruckName  = truckType.Name;
                    freightDTO.LoaderType = item.LoaderType;

                    Loader loader = _repLoader.GetAllAsQueryable().Where(c => c.ID == item.LoaderType).FirstOrDefault();

                    freightDTO.loaderName    = loader.Name;
                    freightDTO.Weight        = item.Weight;
                    freightDTO.Description   = item.Description;
                    freightDTO.Tell          = item.Tell;
                    freightDTO.BaseTruckRent = item.BaseTruckRent;
                    freightDTO.BaseTruckRent = item.BaseTruckRent;
                    datas.Add(freightDTO);
                }

                return(datas);
            }
            catch (Exception e)
            {
                throw new ServiceExeption(e.Message, e);
            }
        }
예제 #31
0
        protected override void Seed(CoffeeSoft.Models.CoffeeSoftDbContext context)
        {
            //  This method will be called after migrating to the latest version.

            //  You can use the DbSet<T>.AddOrUpdate() helper extension method
            //  to avoid creating duplicate seed data. E.g.
            //
            //    context.People.AddOrUpdate(
            //      p => p.FullName,
            //      new Person { FullName = "Andrew Peters" },
            //      new Person { FullName = "Brice Lambson" },
            //      new Person { FullName = "Rowan Miller" }
            //    );
            //

            var trucktype1 = new TruckType
            {
                TruckTypeName = "Samochód osobowy",
                Trucks        = new List <Truck>()
            };

            context.TruckTypes.AddOrUpdate(i => i.TruckTypeName,
                                           trucktype1,
                                           new TruckType
            {
                TruckTypeName = "Ciężarówka",
                Trucks        = new List <Truck>()
            },
                                           new TruckType
            {
                TruckTypeName = "TIR",
                Trucks        = new List <Truck>()
            });

            context.StatusTypes.AddOrUpdate(i => i.StatusName,
                                            new StatusType
            {
                StatusName = "Do akceptacji",
                Orders     = new List <Order>()
            },
                                            new StatusType
            {
                StatusName = "Zaakceptowane",
                Orders     = new List <Order>()
            },
                                            new StatusType
            {
                StatusName = "Zrealizowane",
                Orders     = new List <Order>()
            });

            context.ItemTypes.AddOrUpdate(i => i.ItemsName,
                                          new ItemType
            {
                ItemsName = "Kawa ziarnista",
                Items     = new List <Item>()
            },
                                          new ItemType
            {
                ItemsName = "Kawa zmielona",
                Items     = new List <Item>()
            },
                                          new ItemType
            {
                ItemsName = "Kubki ceramiczne",
                Items     = new List <Item>()
            },
                                          new ItemType
            {
                ItemsName = "Kubki termiczne",
                Items     = new List <Item>()
            },
                                          new ItemType
            {
                ItemsName = "Herbata liściasta",
                Items     = new List <Item>()
            });

            context.PaymentTypes.AddOrUpdate(i => i.PaymentName,
                                             new PaymentType
            {
                PaymentName = "Płatność przy odbiorze",
                Orders      = new List <Order>()
            },
                                             new PaymentType
            {
                PaymentName = "Przedpłata",
                Orders      = new List <Order>()
            });

            var type1 = new WarehouseType()
            {
                WarehouseTypeName = "Magazyn otwarty",
                Warehouses        = new List <Warehouse>()
            };

            context.WarehouseTypes.AddOrUpdate(i => i.WarehouseTypeName,
                                               type1,
                                               new WarehouseType
            {
                WarehouseTypeName = "Magazyn zamknięty",
                Warehouses        = new List <Warehouse>()
            },
                                               new WarehouseType
            {
                WarehouseTypeName = "Magazyn półotwarty",
                Warehouses        = new List <Warehouse>()
            });
            context.SaveChanges();

            if (!context.Warehouses.Any())
            {
                context.Warehouses.AddOrUpdate(i => i.WarehouseName,
                                               new Warehouse
                {
                    WarehouseName  = "Koluszki",
                    WarehouseType  = type1,
                    OrderList      = new List <Order>(),
                    InvoiceList    = new List <Invoice>(),
                    CoffeeShopList = new List <CoffeeShop>()
                });
            }
            if (!context.Trucks.Any())
            {
                context.Trucks.AddOrUpdate(i => i.TruckName,
                                           new Truck
                {
                    TruckName      = "Yaris",
                    TruckType      = trucktype1,
                    Orders         = new List <Order>(),
                    Brand          = "Toyota",
                    RegistrationNo = "SWA 1234",
                });
            }
            context.SaveChanges();
        }