public IActionResult Login(string Email, string Password) { try{ UserSys signinUser = _context.UserSys.Where <UserSys>(user => user.Email == Email && user.Password == Password).SingleOrDefault(); if (!Object.Equals(signinUser, null)) { HttpContext.Session.SetInt32("isLogged", 1); UserSysView userView = new UserSysView(signinUser.Id, signinUser.Login, signinUser.Email, signinUser.UserRole); HttpContext.Session.SetString("authUser", JsonSerializer.Serialize <UserSysView>(userView)); return(RedirectToAction("Index", "Customer")); } else { HttpContext.Session.SetInt32("isLogged", 0); HttpContext.Session.SetString("authUser", ""); TempData["error"] = true; TempData["errorMsg"] = "User not found"; return(RedirectToAction("Index", "Admin")); } }catch (Exception ex) { TempData["error"] = true; HttpContext.Session.SetString("authUser", ""); TempData["errorMsg"] = "Connection Timed Out! Try again!"; return(RedirectToAction("Index", "Admin")); } }
private void DropDownUserSys() { IList <UserSysView> seller = new List <UserSysView>(); //Only get sellers seller = new UserSysView().UserSysViewList((from g in _context.UserSys where !g.UserRole.isAdmin select g).ToList()); seller.Insert(0, new UserSysView(0, "-- Select ---", "", new UserRole())); ViewBag.seller = seller; }
// GET: Customer public async Task <IActionResult> Index(string startdate = null, string enddate = null, string SearchName = "", int SearchGender = 0, int SearchCity = 0, int SearchRegion = 0, int SearchClassification = 0, int SearchSeller = 0) { DateTime start = new DateTime(1900, 01, 01); DateTime end = new DateTime(9999, 12, 31); if (startdate != null && enddate != null) { start = DateManager.GetDate(startdate) ?? DateTime.Now; end = DateManager.GetDate(enddate) ?? DateTime.Now; } #region FILL DROPDOWN LISTS DropDownGender(); DropDownCity(); DropDownRegion(); DropDownClassification(); DropDownUserSys(); #endregion UserSysView LoggedUser = verifyLoggedUser(); SearchName = SearchName == null ? "" : SearchName; ViewData["CurrentFilter"] = SearchName; ViewData["CurrentStartDate"] = startdate; ViewData["CurrentEndDate"] = enddate; #region VERIFY LOGGED USER if (object.Equals(LoggedUser, null)) { return(RedirectToAction("Index", "Admin")); } ViewBag.authUser = LoggedUser; #endregion IList <Customer> customer = new List <Customer>(); try{ if (LoggedUser.UserRole.isAdmin) { customer = await _context.Customer .Where(x => (x.Name.ToLower().Contains(SearchName.ToLower()) || SearchName == "") && (x.Gender.Id == SearchGender || SearchGender == 0) && (x.City.Id == SearchCity || SearchCity == 0) && (x.Region.Id == SearchRegion || SearchRegion == 0) && (x.Classification.Id == SearchClassification || SearchClassification == 0) && (x.User.Id == SearchSeller || SearchSeller == 0) && (x.LastPurchase >= start && x.LastPurchase <= end) ) .ToListAsync(); } else { customer = await _context.Customer .Where(x => x.User.Id == LoggedUser.Id && (x.Name.ToLower().Contains(SearchName.ToLower()) || SearchName == "") && (x.Gender.Id == SearchGender || SearchGender == 0) && (x.Region.Id == SearchRegion || SearchRegion == 0) && (x.Classification.Id == SearchClassification || SearchClassification == 0) && (x.User.Id == SearchSeller || SearchSeller == 0) && (x.LastPurchase >= start && x.LastPurchase <= end) ) .ToListAsync(); } ViewBag.LoggedUser = LoggedUser; return(View(customer)); }catch (Exception) { TempData["error"] = true; TempData["errorMsg"] = "Occured an error while loading customers! Please, try again!"; return(RedirectToAction("Index", "Admin")); } }