public void ConfirmReservTables(int restId, int schemaId, List <int> tablesIds, DateTime date, ApplicationUser user, string name, string phone)
{
using (GoodTasteContext context = new GoodTasteContext())
{
ApplicationUser u = null;
if (user != null)
{
u = context.Users.Find(user.Id);
}
foreach (var tableId in tablesIds)
{
Table table = context.Tables.Find(tableId);
TableReservation reserv = new TableReservation();
reserv.Table = table;
reserv.User = u;
reserv.ReservedAndConfirmed = true;
reserv.ConfirmedByAdministration = true;
reserv.Reserved = false;
reserv.Date = date;
reserv.ContactInfoName = name.Trim();
reserv.ContactInfoPhone = phone.Trim();
context.TableReservations.Add(reserv);
}
context.SaveChanges();
}
}
public void SignUp(ApplicationUser user)
{
try
{
string message;
using (GoodTasteContext context = new GoodTasteContext())
{
if (IsUserExist(context, user))
{
message = "Such user is already exist!";
throw new Exception(message);
}
if (!IsInputDataCorrect(user))
{
message = "User data isn't correct!";
throw new Exception(message);
}
else
{
context.Users.Add(user);
context.SaveChanges();
}
}
}
catch (Exception)
{
}
}
public void RemoveReserv(int?reservId)
{
using (GoodTasteContext context = new GoodTasteContext())
{
context.TableReservations.Remove(context.TableReservations.Find(reservId));
context.SaveChanges();
}
}
public void RemoveReserv(List <TableReservation> reservs)
{
using (GoodTasteContext context = new GoodTasteContext())
{
foreach (var item in reservs)
{
TableReservation remove = context.TableReservations.Find(item.Id);
context.TableReservations.Remove(remove);
}
context.SaveChanges();
}
}
public void ConfirmReservByAdministration(int reservId)
{
using (GoodTasteContext context = new GoodTasteContext())
{
var reserv = context.TableReservations.Find(reservId);
if (reserv == null)
{
throw new ArgumentNullException();
}
reserv.ConfirmedByAdministration = true;
reserv.ReservedAndConfirmed = true;
reserv.Reserved = false;
context.SaveChanges();
}
}
public void ReservTables(List <TableReservation> reservs)
{
using (GoodTasteContext context = new GoodTasteContext())
{
foreach (var item in reservs)
{
Table t = context.Tables.Where(x => x.Id == item.Table.Id).FirstOrDefault();
ApplicationUser u = context.Users.Find(item.User.Id);
TableReservation r = new TableReservation {
Date = DateTime.Now, Reserved = true, ReservedAndConfirmed = false, User = u, Table = t
};
t.TableReservation.Add(r);
context.TableReservations.Add(r);
}
context.SaveChanges();
}
}
public void MakeReview(string userId, int restId, string text, int foodRank, int ambienceRank, int serviceRank)
{
using (GoodTasteContext context = new GoodTasteContext())
{
ApplicationUser currentUser = context.Users.FirstOrDefault();
Restaurant rest = context.Restaurants.Find(restId);
int s = 0;
if (foodRank > 0)
{
s++;
}
if (ambienceRank > 0)
{
s++;
}
if (serviceRank > 0)
{
s++;
}
double rank = 0;
if (s != 0)
{
rank = (foodRank + ambienceRank + serviceRank) / s;
}
RestaurantReview review = new RestaurantReview
{
Text = text.Trim(),
User = currentUser,
Restaurant = rest,
Date = DateTime.Now,
FoodRank = foodRank,
AmbienceRank = ambienceRank,
ServiceRank = serviceRank,
Rank = s
};
context.RestaurantReviews.Add(review);
context.SaveChanges();
}
}
public void ConfirmReservTables(int restId, int schemaId, string userId, List <int> tablesIds, DateTime date, string contactName, string contactPhone)
{
using (GoodTasteContext context = new GoodTasteContext())
{
ApplicationUser currentUser = context.Users.FirstOrDefault();
var reservs = from x in currentUser.TableReservation
where tablesIds.Contains(x.Table.Id)
where x.Reserved == true
where x.ReservedAndConfirmed == false
select x;
foreach (var reserv in reservs)
{
reserv.ReservedAndConfirmed = true;
reserv.Reserved = false;
reserv.Date = date;
reserv.ContactInfoName = contactName.Trim();
reserv.ContactInfoPhone = contactPhone.Trim();
}
context.SaveChanges();
}
}
