コード例 #1
0
        public async Task <IActionResult> ShowWeatherArchives(
            Months month,
            int?year,
            int page = 1)
        {
            int pageSize = 10;

            var source = _dbConnection.Weather.Select(x => x);

            if (month == 0 && year != null)
            {
                source =
                    source.Where(
                        obj =>
                        obj.Date.Year.Equals(
                            year));
            }
            if (month > 0 && year != null)
            {
                source =
                    source.Where(obj =>
                                 obj.Date.Year.Equals(year) &&
                                 obj.Date.Month.Equals((int)month));
            }

            return
                (View(
                     await PageViewModel.CreateAsync(
                         source.AsNoTracking(),
                         page,
                         pageSize,
                         month,
                         year)));
        }
コード例 #2
0
        // GET: Devices
        public async Task <IActionResult> Index(string sortOrder, string currentFilter, string searchString, int?pageNumber)
        {
            ViewData["CurrentSort"]  = sortOrder;
            ViewData["NameSortParm"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";

            if (searchString != null)
            {
                pageNumber = 1;
            }
            else
            {
                searchString = currentFilter;
            }

            ViewData["CurrentFilter"] = searchString;
            var devices = from s in _context.Devices.Include(d => d.Tire).Include(d => d.TypeFuel).Include(d => d.WinterTime)
                          select s;

            switch (sortOrder)
            {
            case "name_desc":
                devices = devices.OrderByDescending(s => s.Namedevice);
                break;

            default:
                devices = devices.OrderBy(s => s.Namedevice);
                break;
            }

            int pageSize = 8;

            return(View(await PageViewModel <Device> .CreateAsync(devices.AsNoTracking(), pageNumber ?? 1, pageSize)));
            //var transportWorkshopCoreContext = _context.Devices.Include(d => d.Tire).Include(d => d.TypeFuel).Include(d => d.WinterTime);
            //return View(await transportWorkshopCoreContext.ToListAsync());
        }
コード例 #3
0
        // GET: AutoCars
        public async Task <IActionResult> Index(string sortOrder, string currentFilter, string currentFilter2, string searchString2, string currentFilter3, string searchString3, string searchString, int?pageNumber)
        {
            ViewData["CurrentSort"]     = sortOrder;
            ViewData["NameSortParm"]    = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
            ViewData["MileageSortParm"] = sortOrder == "Mileage" ? "mileage_desc" : "Mileage";

            if (searchString != null || searchString2 != null || searchString3 != null)
            {
                pageNumber = 1;
            }
            else
            {
                searchString  = currentFilter;
                searchString2 = currentFilter2;
                searchString3 = currentFilter3;
            }
            ViewData["CurrentFilter"] = searchString;
            var autocars = from s in _context.AutoCars.Include(a => a.Driver).Include(a => a.NormaFuel).Include(a => a.Tire).Include(a => a.Trailer).Include(a => a.TypeAuto).Include(a => a.TypeFuel)
                           select s;

            if (!String.IsNullOrEmpty(searchString))
            {
                autocars = autocars.Where(s => s.Driver.FirsLastMidName.Contains(searchString));
            }
            ViewData["CurrentFilter2"] = searchString2;
            if (!String.IsNullOrEmpty(searchString2))
            {
                autocars = autocars.Where(s => s.TypeFuel.Fuel.Contains(searchString2));
            }
            ViewData["CurrentFilter3"] = searchString3;
            if (!String.IsNullOrEmpty(searchString3))
            {
                autocars = autocars.Where(s => s.NameAuto.Contains(searchString3));
            }
            switch (sortOrder)
            {
            case "name_desc":
                autocars = autocars.OrderByDescending(s => s.NameAuto);
                break;

            case "Mileage":
                autocars = autocars.OrderBy(s => s.Mileage);
                break;

            case "mileage_desc":
                autocars = autocars.OrderByDescending(s => s.Mileage);
                break;

            default:
                autocars = autocars.OrderBy(s => s.NameAuto);
                break;
            }

            int pageSize = 5;

            return(View(await PageViewModel <AutoCar> .CreateAsync(autocars.AsNoTracking(), pageNumber ?? 1, pageSize)));
            //var transportWorkshopCoreContext = _context.AutoCars.Include(a => a.Driver).Include(a => a.NormaFuel).Include(a => a.Tire).Include(a => a.Trailer).Include(a => a.TypeAuto).Include(a => a.TypeFuel);
            //return View(await transportWorkshopCoreContext.ToListAsync());
        }
コード例 #4
0
        // GET: Services
        public async Task <IActionResult> Index(string sortOrder, string currentFilter, string currentFilter2,
                                                string searchString, string searchString2, int?pageNumber)
        {
            ViewData["CurrentSort"]  = sortOrder;
            ViewData["DateSortParm"] = sortOrder == "Date" ? "date_desc" : "Date";
            ViewData["CostSortParm"] = sortOrder == "Cost" ? "cost_desc" : "Cost";

            if (searchString != null || searchString2 != null)
            {
                pageNumber = 1;
            }
            else
            {
                searchString  = currentFilter;
                searchString2 = currentFilter2;
            }

            ViewData["CurrentFilter"] = searchString;
            var services = from s in _context.Services.Include(s => s.Clients).Include(s => s.Employee)
                           select s;

            if (!String.IsNullOrEmpty(searchString))
            {
                services = services.Where(c => c.Cost < Convert.ToInt32(searchString));
            }

            ViewData["CurrentFilter2"] = searchString2;
            if (!String.IsNullOrEmpty(searchString2))
            {
                services = services.Where(c => c.Cost > Convert.ToInt32(searchString2));
            }

            switch (sortOrder)
            {
            case "Date":
                services = services.OrderBy(s => s.Date);
                break;

            case "date_desc":
                services = services.OrderByDescending(s => s.Date);
                break;

            case "Cost":
                services = services.OrderBy(s => s.Cost);
                break;

            case "cost_desc":
                services = services.OrderByDescending(s => s.Cost);
                break;
            }

            int pageSize = 10;

            return(View(await PageViewModel <Service> .CreateAsync(services.AsNoTracking(), pageNumber ?? 1, pageSize)));
        }
コード例 #5
0
        // GET: NormaFuels
        public async Task <IActionResult> Index(string sortOrder, string currentFilter, string searchString, int?pageNumber)
        {
            ViewData["CurrentSort"]    = sortOrder;
            ViewData["LinearSortParm"] = String.IsNullOrEmpty(sortOrder) ? "linear_desc" : "";
            ViewData["SummerSortParm"] = sortOrder == "Summer" ? "summer_desc" : "Summer";
            ViewData["WinterSortParm"] = sortOrder == "Winter" ? "winter_desc" : "Winter";

            if (searchString != null)
            {
                pageNumber = 1;
            }
            else
            {
                searchString = currentFilter;
            }

            ViewData["CurrentFilter"] = searchString;
            var normafuels = from s in _context.NormaFuels
                             select s;

            switch (sortOrder)
            {
            case "linear_desc":
                normafuels = normafuels.OrderByDescending(s => s.Linear);
                break;

            case "Summer":
                normafuels = normafuels.OrderBy(s => s.Summer);
                break;

            case "summer_desc":
                normafuels = normafuels.OrderByDescending(s => s.Summer);
                break;

            case "Winter":
                normafuels = normafuels.OrderBy(s => s.Winter);
                break;

            case "winter_desc":
                normafuels = normafuels.OrderByDescending(s => s.Winter);
                break;

            default:
                normafuels = normafuels.OrderBy(s => s.Linear);
                break;
            }

            int pageSize = 8;

            return(View(await PageViewModel <NormaFuel> .CreateAsync(normafuels.AsNoTracking(), pageNumber ?? 1, pageSize)));
            //return View(await _context.NormaFuels.ToListAsync());
        }
コード例 #6
0
        // GET: Balances
        public async Task <IActionResult> Index(string sortOrder, string currentFilter, string searchString, int?pageNumber)
        {
            ViewData["CurrentSort"]      = sortOrder;
            ViewData["DateSortParm"]     = String.IsNullOrEmpty(sortOrder) ? "date_desc" : "";
            ViewData["LeftoverSortParm"] = sortOrder == "Leftover" ? "leftover_desc" : "Leftover";

            if (searchString != null)
            {
                pageNumber = 1;
            }
            else
            {
                searchString = currentFilter;
            }

            ViewData["CurrentFilter"] = searchString;
            var balances = from s in _context.Balances.Include(b => b.AutoCar)
                           select s;

            if (!String.IsNullOrEmpty(searchString))
            {
                balances = balances.Where(s => s.AutoCar.NameAuto.Contains(searchString));
            }
            switch (sortOrder)
            {
            case "date_desc":
                balances = balances.OrderByDescending(s => s.Date);
                break;

            case "Leftover":
                balances = balances.OrderBy(s => s.Leftovers);
                break;

            case "leftover_desc":
                balances = balances.OrderByDescending(s => s.Leftovers);
                break;

            default:
                balances = balances.OrderBy(s => s.Date);
                break;
            }

            int pageSize = 5;

            return(View(await PageViewModel <Balance> .CreateAsync(balances.AsNoTracking(), pageNumber ?? 1, pageSize)));
            //var transportWorkshopCoreContext = _context.Balances.Include(b => b.AutoCar);
            //return View(await transportWorkshopCoreContext.ToListAsync());
        }
コード例 #7
0
        // GET: Drivers
        public async Task <IActionResult> Index(string sortOrder, string currentFilter, string searchString, int?pageNumber)
        {
            ViewData["CurrentSort"]      = sortOrder;
            ViewData["NameSortParm"]     = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
            ViewData["CategorySortParm"] = sortOrder == "Category" ? "category_desc" : "Category";

            if (searchString != null)
            {
                pageNumber = 1;
            }
            else
            {
                searchString = currentFilter;
            }

            ViewData["CurrentFilter"] = searchString;
            var drivers = from s in _context.Drivers//доделать
                          select s;

            if (!String.IsNullOrEmpty(searchString))
            {
                drivers = drivers.Where(s => s.FirsLastMidName.Contains(searchString));
            }
            switch (sortOrder)
            {
            case "name_desc":
                drivers = drivers.OrderByDescending(s => s.FirsLastMidName);
                break;

            case "Category":
                drivers = drivers.OrderBy(s => s.Category);
                break;

            case "category_desc":
                drivers = drivers.OrderByDescending(s => s.Category);
                break;

            default:
                drivers = drivers.OrderBy(s => s.FirsLastMidName);
                break;
            }

            int pageSize = 8;

            return(View(await PageViewModel <Driver> .CreateAsync(drivers.AsNoTracking(), pageNumber ?? 1, pageSize)));
            //return View(await _context.Drivers.ToListAsync());
        }
コード例 #8
0
        // GET: Clients
        public async Task <IActionResult> Index(string sortOrder, string currentFilter, string searchString, int?pageNumber)
        {
            ViewData["CurrentSort"]  = sortOrder;
            ViewData["NameSortParm"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";
            ViewData["DateSortParm"] = sortOrder == "Date" ? "date_desc" : "Date";

            if (searchString != null)
            {
                pageNumber = 1;
            }
            else
            {
                searchString = currentFilter;
            }

            ViewData["CurrentFilter"] = searchString;
            var clients = from s in _context.Clients.Include(c => c.Nationalitie).Include(c => c.Relation).Include(c => c.ZodiacSign)
                          select s;

            if (!String.IsNullOrEmpty(searchString))
            {
                clients = clients.Where(s => s.ZodiacSign.Name.Contains(searchString));
            }
            switch (sortOrder)
            {
            case "name_desc":
                clients = clients.OrderByDescending(s => s.FirsLastMidName);
                break;

            case "Date":
                clients = clients.OrderBy(s => s.DateofBirth);
                break;

            case "date_desc":
                clients = clients.OrderByDescending(s => s.DateofBirth);
                break;

            default:
                clients = clients.OrderBy(s => s.FirsLastMidName);
                break;
            }

            int pageSize = 5;

            return(View(await PageViewModel <Client> .CreateAsync(clients.AsNoTracking(), pageNumber ?? 1, pageSize)));
        }
コード例 #9
0
        // GET: Tires
        public async Task <IActionResult> Index(string sortOrder, string currentFilter, string searchString, int?pageNumber)
        {
            ViewData["CurrentSort"]  = sortOrder;
            ViewData["DateSortParm"] = String.IsNullOrEmpty(sortOrder) ? "date_desc" : "";
            ViewData["RunSortParm"]  = sortOrder == "Run" ? "run_desc" : "Run";

            if (searchString != null)
            {
                pageNumber = 1;
            }
            else
            {
                searchString = currentFilter;
            }

            ViewData["CurrentFilter"] = searchString;
            var tires = from s in _context.Tires
                        select s;

            switch (sortOrder)
            {
            case "date_desc":
                tires = tires.OrderByDescending(s => s.Date);
                break;

            case "Run":
                tires = tires.OrderBy(s => s.RunStart);
                break;

            case "run_desc":
                tires = tires.OrderByDescending(s => s.RunStart);
                break;

            default:
                tires = tires.OrderBy(s => s.Date);
                break;
            }

            int pageSize = 8;

            return(View(await PageViewModel <Tire> .CreateAsync(tires.AsNoTracking(), pageNumber ?? 1, pageSize)));
            //return View(await _context.Tires.ToListAsync());
        }
コード例 #10
0
        // GET: Employees
        public async Task <IActionResult> Index(string sortOrder, string currentFilter, string searchString, int?pageNumber)
        {
            ViewData["CurrentSort"]  = sortOrder;
            ViewData["NameSortParm"] = String.IsNullOrEmpty(sortOrder) ? "name_desc" : "";

            if (searchString != null)
            {
                pageNumber = 1;
            }
            else
            {
                searchString = currentFilter;
            }

            ViewData["CurrentFilter"] = searchString;
            var employees = from s in _context.Employees.Include(e => e.Position)
                            select s;

            if (!String.IsNullOrEmpty(searchString))
            {
                employees = employees.Where(s => s.Position.NamePosition.Contains(searchString));
            }
            switch (sortOrder)
            {
            case "name_desc":
                employees = employees.OrderByDescending(s => s.FirsLastMidName);
                break;

            default:
                employees = employees.OrderBy(s => s.FirsLastMidName);
                break;
            }

            int pageSize = 5;

            return(View(await PageViewModel <Employee> .CreateAsync(employees.AsNoTracking(), pageNumber ?? 1, pageSize)));
        }
コード例 #11
0
        // GET: Movies
        public async Task <IActionResult> Index(int?pageNumber)
        {
            IQueryable <MovieModel> movies = _context.Movies.Include(m => m.Author);

            return(View(await PageViewModel <MovieModel> .CreateAsync(movies, pageNumber ?? 1, pageSize)));
        }