public IActionResult Reset() { var uploadDataBaseLogic = new UploadDataBaseLogic(_context); uploadDataBaseLogic.Reset(); return(Redirect("/Home")); }
public IActionResult UploadCSV() { var uploadDataBaseLogic = new UploadDataBaseLogic(_context); uploadDataBaseLogic.UpdateDataBase(); return(Redirect("/Home")); }
public IActionResult CheckIn(int barcode) { var date = DateTime.Now; var dateTime = new DateTime(date.Year, date.Month, date.Day, date.Hour, date.Minute, 0).AddHours(-5); var uploadDataBaseLogic = new UploadDataBaseLogic(_context); List <BarcodeUser> users = _context.BarcodeUsers.Where(i => i.CheckedIn == true).ToList(); BarcodeUser newUser = _context.BarcodeUsers.Where(i => i.Barcode == barcode).FirstOrDefault(); List <CheckInTimes> times = _context.CheckInTimes.OrderByDescending(i => i.Barcode).ToList(); IEnumerable <BarcodeUser> userNames = _context.BarcodeUsers.OrderBy(c => c.Name).ToList(); ViewBag.Error = ""; if (newUser == null) { ViewBag.Error = "Barcode not found"; return(View(new CheckInViewModel(userNames))); } if (newUser != null) { CheckInViewModel checkInViewModel = new CheckInViewModel(userNames) { Users = users, NewUser = newUser, UserCheckInTimes = times, }; uploadDataBaseLogic.CheckIn(barcode, dateTime); return(View(checkInViewModel)); } return(View()); }