public JsonResult GetLots()
{
using (var db = new MapleContext())
{
return(Json(db.Lots.ToList()));
}
}
private void UIElement_OnPreviewMouseRightButtonDown(object sender, MouseEventArgs e)
{
var dataContext = (MainWindowViewModel)DataContext;
if (dataContext != null)
{
dataContext.Config.ContextItems = MapleContext.CreateMenu();
}
}
//Lot Specific pages
public IActionResult ViewLot(int ID)
{
Lot ret;
using (var db = new MapleContext())
{
ret = db.Lots.FirstOrDefault(l => l.ID == ID);
}
return(View(ret));
}
//Displays generates list of Lots for the View to Display
public IActionResult LocSearch(string Loc, int?UserID)
{
ViewData["Search"] = Loc;
ViewData["UserId"] = UserID ?? -1;
using (var db = new MapleContext())
{
if (Loc == "!!" || Loc == "")
{
return(View(db.Lots.ToList()));
}
return(View(db.Lots.Where(l => l.Location.Contains(Loc)).ToList()));
}
}
//Allows when in the Lot listing, this allows the user
// to add a favorite, using LOTID and UserID
public IActionResult AddFavorite(int LotID, int UserID)
{
if (UserID == -1)
{
return(RedirectToAction("ViewLot", new{ ID = LotID }));
}
using (var db = new MapleContext())
{
var flot = db.Lots.FirstOrDefault(l => l.ID == LotID);
flot.Users.Add(new FavourLots {
UserID = UserID, LotID = LotID, Lot = flot
});
db.SaveChanges();
}
return(RedirectToAction("ViewLot", new{ ID = LotID }));
}
//Test Page for city station
public IActionResult CityStat()
{
var rand = new Random();
int Current;
int Capacity = rand.Next(100);
using (var db = new MapleContext())
{
Capacity = db.Lots.FirstOrDefault().Maxsize;
Current = db.Lots.FirstOrDefault().CurrentCount;
}
ViewData["Capacity"] = Capacity;
ViewData["Current"] = Current;
//Console.WriteLine(ViewData["Lot"]);
return(View());
}
//Check Username/Password input
//Return User to Login if no match exists
//Otherwise, show list of favorites
public IActionResult LoginResult(string Username, string Password)
{
using (var db = new MapleContext())
{
var use = db.Users.
FirstOrDefault(u =>
u.Username == Username && u.Password == Password);
if (use == null)
{
ViewData["Message"] = "Login Failed, please try again";
return(View("LoginPage"));
}
use = db.Users
.Include(e => e.Favorites)
.ThenInclude(e => e.Lot)
.Where(z => z.ID == use.ID).FirstOrDefault();
var retList = use.Favorites.Select(e => e.Lot).ToList();
ViewData["UserId"] = use.ID;
return(View("LocSearch", retList));
}
}
