public async Task <IActionResult> OnPostAsync()
        {
            int        id = (int)HttpContext.Session.GetInt32("current_resturaunt");
            Resturaunt R  = await _context.Resturaunt.Include(m => m.ResturauntPage).ThenInclude(m => m.Days).FirstOrDefaultAsync(m => m.id == id);

            foreach (var i in R.ResturauntPage.Days)
            {
                _context.Entry(i)
                .Collection(s => s.Deals)
                .Load();
            }

            var file = Request.Form.Files.First();

            using (var reader = file.OpenReadStream())
            {
                TextReader tr = new StreamReader(reader);
                using (var csv = new CsvReader(tr, CultureInfo.InvariantCulture))
                {
                    csv.Configuration.HasHeaderRecord = false;
                    var deals = csv.GetRecords <CSVDeal>();

                    foreach (var d in deals)
                    {
                        Deal deal = new Deal()
                        {
                            ItemName = d.DealName, Desription = d.DealDescription, StartTime = d.StartTime, EndTime = d.EndTime
                        };
                        _context.Deal.Add(deal);
                        if (deal != null)
                        {
                            R.ResturauntPage.Days.Where(n => n.DayName.ToLower() == d.DayOfWeek.ToLower()).FirstOrDefault().Deals.Add(deal);
                        }
                    }

                    _context.Attach(R).State = EntityState.Modified;

                    try
                    {
                        await _context.SaveChangesAsync();
                    }
                    catch (DbUpdateConcurrencyException)
                    {
                    }
                }
            }



            return(Page());
        }
Пример #2
0
        public async Task OnGetAsync(int id, int day)
        {
            Tags = new List <Tags>();

            Byte[] OutVal;
            if (!HttpContext.Session.TryGetValue("current_resturaunt", out OutVal))
            {
                HttpContext.Session.SetInt32("current_resturaunt", id);
            }
            else
            {
                id = (int)HttpContext.Session.GetInt32("current_resturaunt");
            }
            Resturaunt R = await _context.Resturaunt.Include(m => m.ResturauntPage).ThenInclude(m => m.Days).FirstOrDefaultAsync(m => m.id == id);

            Tags         = _context.Tags.ToList();
            SelectedTags = new int[Tags.Count];
            switch (day)
            {
            case 1:
                Day = await _context.Day.Include(m => m.Deals).FirstOrDefaultAsync(m => m.id == R.ResturauntPage.Days.ElementAt(0).id);

                Deals       = Day.Deals;
                Day.DayName = "Monday";
                break;

            case 2:
                Day = await _context.Day.Include(m => m.Deals).FirstOrDefaultAsync(m => m.id == R.ResturauntPage.Days.ElementAt(1).id);

                Deals       = Day.Deals;
                Day.DayName = "Tuesday";
                break;

            case 3:
                Day = await _context.Day.Include(m => m.Deals).FirstOrDefaultAsync(m => m.id == R.ResturauntPage.Days.ElementAt(2).id);

                Deals       = Day.Deals;
                Day.DayName = "Wednesday";
                break;

            case 4:
                Day = await _context.Day.Include(m => m.Deals).FirstOrDefaultAsync(m => m.id == R.ResturauntPage.Days.ElementAt(3).id);

                Deals       = Day.Deals;
                Day.DayName = "Thursday";
                break;

            case 5:
                Day = await _context.Day.Include(m => m.Deals).FirstOrDefaultAsync(m => m.id == R.ResturauntPage.Days.ElementAt(4).id);

                Deals       = Day.Deals;
                Day.DayName = "Friday";
                break;

            case 6:
                Day = await _context.Day.Include(m => m.Deals).FirstOrDefaultAsync(m => m.id == R.ResturauntPage.Days.ElementAt(5).id);

                Deals       = Day.Deals;
                Day.DayName = "Saturday";
                break;

            case 7:
                Day = await _context.Day.Include(m => m.Deals).FirstOrDefaultAsync(m => m.id == R.ResturauntPage.Days.ElementAt(6).id);

                Deals       = Day.Deals;
                Day.DayName = "Sunday";
                break;
            }

            //preperation for tags
            foreach (var x in Day.Deals)
            {
                _context.Entry(x)
                .Collection(s => s.TagsInter)
                .Load();
            }
        }