public JsonResult gastationFillter(string data)
        {
            JavaScriptSerializer json_serializer = new JavaScriptSerializer();
            dynamic queryData     = json_serializer.DeserializeObject(data);
            string  queryGasName  = queryData["gasName"];
            string  querygasTpye  = queryData["gasType"];
            string  queryDistrict = queryData["districtID"];
            int     queryPage     = Convert.ToInt32(queryData["selectPage"]);

            // Dung để kiểm tra xem có tồn tại gastype hay không.
            bool checkType(string qr, List <DataAccess.Models.GasStationGasType> gt)
            {
                foreach (var item in gt)
                {
                    if (qr.Contains(item.GasType))
                    {
                        return(true);
                    }
                }
                return(false);
            }

            //Fillter theo các điều kiện truyền vào
            var gasStationsN = _gasStationRepository.GetAll().Where(x =>
                                                                    (queryGasName != null ?  x.GasStationName.ToLowerInvariant().Contains(queryGasName) :true) &&
                                                                    (querygasTpye != null ? checkType(querygasTpye, x.GasStationGasType.ToList()): true) &&
                                                                    (queryDistrict != null ? x.District == (long)Convert.ToDouble(queryDistrict): true)
                                                                    );

            countPage = gasStationsN.Count();

            var gasStations = gasStationsN.Skip((queryPage - 1) * 10).Take(10).ToList();

            List <GasStationVM> result = new List <GasStationVM>();

            //Add gasstartion vào bên trong result
            foreach (var item in gasStations)
            {
                GasStationVM gasStationVM = new GasStationVM();
                gasStationVM.GasStationName = item.GasStationName;
                int count = 0;
                foreach (var type in item.GasStationGasType)
                {
                    if (count == 0)
                    {
                        gasStationVM.GasType += _mTypeRepository.getTypeText(type.GasType, 3);
                        count++;
                    }
                    gasStationVM.GasType += ", " + _mTypeRepository.getTypeText(type.GasType, 3);
                }
                gasStationVM.GasStationId = item.GasStationId;
                gasStationVM.DistrictName = _districtRepository.FindById(item.District).DistrictName;
                gasStationVM.Longitude    = item.Longitude;
                gasStationVM.Latitude     = item.Latitude;
                gasStationVM.Rating       = _mTypeRepository.getTypeText(item.Rating, 4);
                result.Add(gasStationVM);
            }

            return(Json(result));
        }
        public ActionResult Detail(long Id)
        {
            Models.FeedbackVM feedbackVM = new Models.FeedbackVM();
            if (Id.ToString() == null)
            {
                return(RedirectToAction("Error", "Error"));
            }
            DataAccess.Models.GasStation gasStation = new DataAccess.Models.GasStation();
            gasStation = _gasStationRepository.FindById(Id);
            if (gasStation == null)
            {
                return(RedirectToAction("NotFound", "Error"));
            }
            feedbackVM.GasStationName = gasStation.GasStationName;
            List <DataAccess.Models.GasStationGasType> listgasType = new List <DataAccess.Models.GasStationGasType>();

            listgasType = _gasStationGasTypeRepository.GetAll().Where(x => x.GasStationId == Id).ToList();
            foreach (var item in listgasType)
            {
                if (feedbackVM.GasType == null)
                {
                    feedbackVM.GasType += _mTpyeRepository.getTypeText(item.GasType, 3);
                }
                else
                {
                    feedbackVM.GasType += ", " + _mTpyeRepository.getTypeText(item.GasType, 3);
                }
            }
            feedbackVM.GasAddress = gasStation.Address + ", " + _districtRepository.FindById(gasStation.District).DistrictName;
            feedbackVM.OpenTime   = gasStation.OpeningTime;
            feedbackVM.Rating     = _mTpyeRepository.getTypeText(gasStation.Rating, 4);
            ViewBag.countPage     = _feedbackRepository.GetAll().Where(x => x.GasStationId == Id).Count();
            return(View(feedbackVM));
        }
Beispiel #3
0
        /// <summary>
        /// Get Address object and validate if department, province and district are valid
        /// </summary>
        /// <param name="idDepartment">Id Department</param>
        /// <param name="idDistrict">Id District</param>
        /// <param name="idProvince">Id Province</param>
        /// <returns>Address with names</returns>
        private Address GetAddressName(string idDepartment, string idDistrict, string idProvince)
        {
            var department = _departmentRepository.FindById(idDepartment);
            var district   = _districtRepository.FindById(idDistrict);
            var province   = _provinceRepository.FindById(idProvince);

            //if not found a department, then is invalid
            if (department == null)
            {
                throw new AppException("Department is not valid.");
            }
            //if not found a district, then is invalid
            if (district == null)
            {
                throw new AppException("District is not valid.");
            }
            //if not found a province, then is invalid
            if (province == null)
            {
                throw new AppException("Province is not valid.");
            }
            //Province doesn't belong department
            if (province.IdDepartment != department.Id)
            {
                throw new AppException("Province doesn't belong to selected department");
            }
            //District doesn't belong province
            if (province.Id != district.IdProvince)
            {
                throw new AppException("District doesn't belong to selected province");
            }

            return(new Address
            {
                Department = department.Name,
                District = district.Name,
                Province = province.Name
            });
        }
Beispiel #4
0
        public async Task <GasStationResul> GetAllGasStations([FromBody] Request request)
        {
            GasStationResul    gasStationResul = new GasStationResul();
            List <GasStaionMV> gasStationMVs   = new List <GasStaionMV>();
            List <GasStation>  gasStations     = await _gasStationRepository.GetAsyncAllGasStationWithQuery(request.GasName, request.District, request.GasTypes);

            gasStationResul.Count = gasStations.Count();
            List <GasStation> gasStationsResult = gasStations.Skip((request.Page - 1) * 10).Take(10).ToList();

            foreach (var gasStation in gasStationsResult)
            {
                GasStaionMV gasStationMV = new GasStaionMV();
                gasStationMV.GasStationId   = gasStation.GasStationId;
                gasStationMV.GasStationName = gasStation.GasStationName;
                gasStationMV.Address        = gasStation.Address;
                gasStationMV.District       = _districtRepository.FindById(gasStation.District);
                gasStationMV.OpeningTime    = gasStation.OpeningTime;
                gasStationMV.Longitude      = gasStation.Longitude;
                gasStationMV.Latitude       = gasStation.Latitude;
                Rating rating = new Rating();
                rating.Code         = gasStation.Rating;
                rating.Name         = _mTypeRepository.getTypeText(gasStation.Rating, 4);
                gasStationMV.Rating = rating;
                List <ModelsViews.Type> types = new List <ModelsViews.Type>();
                foreach (var gastype in gasStation.GasStationGasType)
                {
                    ModelsViews.Type type = new ModelsViews.Type();
                    type.GasTypeCode = gastype.GasType;
                    type.GasTypeName = _mTypeRepository.getTypeText(gastype.GasType, 3);
                    types.Add(type);
                }
                gasStationMV.Types = types;
                gasStationMVs.Add(gasStationMV);
            }

            gasStationResul.GasStaionMVs = gasStationMVs;

            return(gasStationResul);
        }
        public async Task <AccountResponse> SaveAsync(AccountFactory account)
        {
            try
            {
                AccountFactory accountFactory = null;
                bool           result         = account.AccountType.Equals("Musician");
                if (result == true)
                {
                    accountFactory = new MusicianFactory();
                }
                else
                {
                    accountFactory = new OrganizerFactory();
                }
                Account newAccount = accountFactory.GetAccount();
                newAccount.FirstName    = account.FirstName;
                newAccount.LastName     = account.LastName;
                newAccount.Phone        = account.Phone;
                newAccount.PersonalWeb  = account.PersonalWeb;
                newAccount.BirthDate    = account.BirthDate;
                newAccount.User         = account.User;
                newAccount.RegisterDate = DateTime.Now;
                newAccount.AccountType  = account.AccountType;
                int id = account.DistrictId;
                newAccount.District = await _districtRepository.FindById(id);

                await _accountRepository.AddAsync(newAccount);

                await _unitOfWork.CompleteAsync();

                return(new AccountResponse(newAccount));
            }
            catch (Exception ex)
            {
                return(new AccountResponse($"An error ocurred while saving the account: {ex.Message}"));
            }
        }
Beispiel #6
0
 public District GetById(int districtId)
 {
     return(_districtRepository.FindById(districtId));
 }