public ActionResult EditResaurant(long id)
{
RestaurantModel model = null;
try
{
using (isadbEntities context = new isadbEntities())
{
Restaurant restaurant = context.Restaurants.Find(id);
model = new RestaurantModel
{
Id = restaurant.Id,
Latitude = restaurant.Location != null ? restaurant.Location.Latitude : null,
Longitude = restaurant.Location != null ? restaurant.Location.Longitude : null,
Name = restaurant.Name,
ManagerId = restaurant.ManagerId
};
List <SelectListItem> users = context.Users.Where(x => x.AspNetUser.AspNetRoles.Any(z => z.Name.Equals("manager"))).Select(x => new SelectListItem
{
Text = x.FirstName + " " + x.LastName,
Value = x.Id.ToString()
}).ToList();
model.Managers = users;
}
}
catch (Exception)
{
model = new RestaurantModel();
model.Managers = new List <SelectListItem>();
}
return(View(model));
}
public ActionResult AddMenu(MenuModel model)
{
try
{
using (isadbEntities context = new isadbEntities())
{
if (ModelState.IsValid)
{
FoodManu menu = new FoodManu
{
Description = model.Descriptiom,
Name = model.Name,
Price = model.Price,
RestaurantId = model.RestaurantId
};
context.FoodManus.Add(menu);
context.SaveChanges();
return(RedirectToAction("Menu", new { id = model.RestaurantId }));
}
else
{
return(View(model));
}
}
}
catch (Exception)
{
}
return(View(model));
}
public ActionResult RestaurantDetail(long id)
{
try
{
string aspUserId = User.Identity.GetUserId();
using (isadbEntities context = new isadbEntities())
{
Restaurant res = context.Restaurants.Find(id);
RestaurantModel model = new RestaurantModel
{
Id = res.Id,
Latitude = res.Location.Latitude,
Longitude = res.Location.Longitude,
ManagareName = res.User.FirstName + " " + res.User.LastName,
Name = res.Name,
Tables = res.Tables.Select(x => new TableModel
{
Id = x.Id,
IsEnabled = !x.Reservations.Any(z => z.Date_to > DateTime.Now && z.Date_from < DateTime.Now),
Position = x.local_number
}).ToList(),
IsAdmin = User.IsInRole("admin"),
IsManager = context.Users.FirstOrDefault(x => x.AspUserId.Equals(aspUserId)).Restaurants.Any(x => x.Id == id)
};
return(View(model));
}
}
catch (Exception)
{
return(RedirectToAction("Index"));
}
}
public ActionResult Reservation(ReservationModel model)
{
try
{
if (ModelState.IsValid)
{
using (isadbEntities context = new isadbEntities())
{
Table table = context.Tables.Find(model.Id);
bool isEnableReservation = !table.Reservations.Any() || !table.Reservations.Any(x => !(x.Date_from > model.DateTo || x.Date_to < model.DateFrom));
//Any(x => x.Date_to < model.DateTo && x.Date_from > model.DateFrom);
if (isEnableReservation)
{
string aspUserId = User.Identity.GetUserId();
User user = context.Users.FirstOrDefault(x => x.AspUserId == aspUserId);
Reservation reservation = new Reservation
{
Table_id = model.Id,
Date_from = model.DateFrom,
Date_to = model.DateTo,
User_id = user.Id
};
context.Reservations.Add(reservation);
context.SaveChanges();
return(RedirectToAction("RestaurantDetail", new { id = context.Tables.Find(model.Id).restaurant_id }));
}
else
{
List <string> reservations = new List <string>();
reservations = context.Tables.Find(model.Id).Reservations.Where(x => x.Date_to > DateTime.Now).Select(x => x.Date_from.ToString() + " - " + x.Date_to.ToString()).ToList();
model.Reservations = reservations;
ModelState.AddModelError("NotEnable", "Table is not enabled for selected period");
return(View(model));
}
}
}
else
{
return(View(model));
}
}
catch (Exception)
{
List <string> reservations = new List <string>();
using (isadbEntities context = new isadbEntities())
{
reservations = context.Tables.Find(model.Id).Reservations.Where(x => x.Date_to > DateTime.Now).Select(x => x.Date_from.ToString() + " - " + x.Date_to.ToString()).ToList();
}
model.Reservations = reservations;
return(View(model));
}
}
public ActionResult AddResaurant(RestaurantModel model)
{
try
{
using (isadbEntities context = new isadbEntities())
{
if (ModelState.IsValid)
{
Restaurant restaurant = new Restaurant
{
Location = CreatePoint(model.Latitude, model.Longitude),
ManagerId = model.ManagerId,
Name = model.Name
};
context.Restaurants.Add(restaurant);
context.SaveChanges();
for (int i = 0; i < 5; i++)
{
Table t = new Table
{
local_number = i + 1,
restaurant_id = restaurant.Id
};
context.Tables.Add(t);
}
context.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
List <SelectListItem> users = context.Users.Where(x => x.AspNetUser.AspNetRoles.Any(z => z.Name.Equals("manager"))).Select(x => new SelectListItem
{
Text = x.FirstName + " " + x.LastName,
Value = x.Id.ToString()
}).ToList();
model = new RestaurantModel();
model.Managers = users;
return(View(model));
}
}
}
catch (Exception)
{
model = new RestaurantModel();
model.Managers = new List <SelectListItem>();
}
return(View(model));
}
public ActionResult RestaurantDelete(long id)
{
try
{
using (isadbEntities context = new isadbEntities())
{
Restaurant r = context.Restaurants.Find(id);
context.Restaurants.Remove(r);
context.SaveChanges();
}
}
catch (Exception e)
{
}
return(RedirectToAction("Index"));
}
public async Task <ActionResult> RegisterManager(RegisterViewModel model)
{
if (ModelState.IsValid)
{
var user = new ApplicationUser {
UserName = model.Email, Email = model.Email
};
var result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
await SignInManager.SignInAsync(user, isPersistent : false, rememberBrowser : false);
// For more information on how to enable account confirmation and password reset please visit http://go.microsoft.com/fwlink/?LinkID=320771
// Send an email with this link
// string code = await UserManager.GenerateEmailConfirmationTokenAsync(user.Id);
// var callbackUrl = Url.Action("ConfirmEmail", "Account", new { userId = user.Id, code = code }, protocol: Request.Url.Scheme);
// await UserManager.SendEmailAsync(user.Id, "Confirm your account", "Please confirm your account by clicking <a href=\"" + callbackUrl + "\">here</a>");
using (isadbEntities context = new isadbEntities())
{
User newUser = new User
{
FirstName = model.FirstName,
LastName = model.LastName,
Address = model.Address,
AspUserId = user.Id
};
var aspUser = context.AspNetUsers.Find(user.Id);
var role = context.AspNetRoles.Find("47b9de90-d193-482d-90ad-08efee65a47c");
aspUser.AspNetRoles.Add(role);
context.Users.Add(newUser);
context.SaveChanges();
}
return(RedirectToAction("Index", "Manager"));
}
AddErrors(result);
}
// If we got this far, something failed, redisplay form
return(View(model));
}
public ActionResult Reservation(long id)
{
List <string> reservations = new List <string>();
using (isadbEntities context = new isadbEntities())
{
reservations = context.Tables.Find(id).Reservations.Where(x => x.Date_to > DateTime.Now).Select(x => x.Date_from.ToString() + " - " + x.Date_to.ToString()).ToList();
}
ReservationModel model = new ReservationModel
{
DateFrom = DateTime.Now,
DateTo = DateTime.Now.AddHours(1),
Id = id,
Reservations = reservations
};
return(View(model));
}
public ActionResult EditResaurant(RestaurantModel model)
{
try
{
using (isadbEntities context = new isadbEntities())
{
if (ModelState.IsValid)
{
Restaurant restaurant = context.Restaurants.Find(model.Id);
restaurant.Location = CreatePoint(model.Latitude, model.Longitude);
restaurant.ManagerId = model.ManagerId;
restaurant.Name = model.Name;
context.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
List <SelectListItem> users = context.Users.Where(x => x.AspNetUser.AspNetRoles.Any(z => z.Name.Equals("manager"))).Select(x => new SelectListItem
{
Text = x.FirstName + " " + x.LastName,
Value = x.Id.ToString()
}).ToList();
model = new RestaurantModel();
model.Managers = users;
return(View(model));
}
}
}
catch (Exception)
{
model = new RestaurantModel();
model.Managers = new List <SelectListItem>();
}
return(View(model));
}
// GET: Manager
public ActionResult Index()
{
List <ManagerModel> managers = null;
try
{
using (isadbEntities context = new isadbEntities())
{
managers = context.Users.Where(x => x.AspNetUser.AspNetRoles.Any(z => z.Name.Equals("manager"))).Select(x => new ManagerModel
{
Id = x.Id,
Email = x.AspNetUser.Email,
FirstName = x.FirstName,
LastName = x.LastName
}).ToList();
}
}
catch (Exception)
{
managers = new List <ManagerModel>();
}
return(View(managers));
}
public ActionResult AddResaurant()
{
RestaurantModel model = null;
try
{
using (isadbEntities context = new isadbEntities())
{
List <SelectListItem> users = context.Users.Where(x => x.AspNetUser.AspNetRoles.Any(z => z.Name.Equals("manager"))).Select(x => new SelectListItem
{
Text = x.FirstName + " " + x.LastName,
Value = x.Id.ToString()
}).ToList();
model = new RestaurantModel();
model.Managers = users;
}
}
catch (Exception)
{
model = new RestaurantModel();
model.Managers = new List <SelectListItem>();
}
return(View(model));
}
//id - restaurantId
public ActionResult Menu(long id)
{
ViewBag.RestaurantId = id;
List <MenuModel> menus = null;
try
{
using (isadbEntities context = new isadbEntities())
{
menus = context.Restaurants.Find(id).FoodManus.Select(x => new MenuModel
{
Id = x.Id,
Name = x.Name,
Descriptiom = x.Description,
Price = x.Price,
}).ToList();
}
}
catch (Exception)
{
menus = new List <MenuModel>();
}
return(View(menus));
}
public ActionResult Index()
{
List <RestaurantModel> restaurants = null;
try
{
using (isadbEntities context = new isadbEntities())
{
restaurants = context.Restaurants.Select(x => new RestaurantModel
{
Id = x.Id,
Latitude = x.Location != null ? x.Location.Latitude : null,
Longitude = x.Location != null ? x.Location.Longitude : null,
ManagareName = x.User.FirstName + " " + x.User.LastName,
Name = x.Name
}).ToList();
}
}
catch (Exception)
{
restaurants = new List <RestaurantModel>();
}
return(View(restaurants));
}
// GET: User
public ActionResult Index()
{
List <UserViewModel> users = null;
try
{
using (isadbEntities context = new isadbEntities())
{
users = context.Users.Select(x => new UserViewModel
{
Id = x.Id,
Name = x.FirstName,
Surname = x.LastName,
Mail = x.AspNetUser.Email
}).ToList();
}
}
catch (Exception)
{
users = new List <UserViewModel>();
}
return(View(users));
}
