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"));
}
}
