public ActionResult CartList(string name)
{
cartEntities1 context = new cartEntities1();
string userID = User.Identity.GetUserId();
Table_Cart Item = new Table_Cart {
SERVICE_NAME = name, USER_ID = userID
};
context.Table_Cart.Add(Item);
try
{
context.SaveChanges();
}
catch (System.Data.Entity.Validation.DbEntityValidationException dbEx)
{
Exception raise = dbEx;
foreach (var validationErrors in dbEx.EntityValidationErrors)
{
foreach (var validationError in validationErrors.ValidationErrors)
{
string message = string.Format("{0}:{1}",
validationErrors.Entry.Entity.ToString(),
validationError.ErrorMessage);
raise = new InvalidOperationException(message, raise);
}
}
throw raise;
}
return(Content("Successfully Added"));
}
public ActionResult Slot()
{
cartEntities1 cartEntities1 = new cartEntities1();
string uid = User.Identity.GetUserId();
List <Table_Cart> table_Carts = cartEntities1.Table_Cart.Where(entity => entity.USER_ID == uid).ToList();
if (table_Carts == null)
{
//string DoNotProceedIfTheresNoData = Request.UrlReferrer.ToString();
return(Content("There is no data"));
}
return(View());
}
public ActionResult Slot(Table_Slot table_Slot)
{
slotFixing obj = new slotFixing();
List <Table_Slot> result = obj.Table_Slot.Where(x => x.LOCATION == table_Slot.LOCATION && x.DAY == table_Slot.DAY).ToList();
int count = 0;
foreach (var item in result)
{
if (item.SLOT == table_Slot.SLOT)
{
count++;
}
}
if (count > 5)
{
return(RedirectToAction("Slot"));
}
else
{
obj.Table_Slot.Add(table_Slot);
obj.SaveChanges();
string uid = User.Identity.GetUserId();
cartEntities1 cartEntities = new cartEntities1();
List <Table_Cart> table_Carts = cartEntities.Table_Cart.Where(x => x.USER_ID == uid).ToList();
string ListOfServicesOpted = "";
foreach (var item in table_Carts)
{
ListOfServicesOpted = ListOfServicesOpted + item.SERVICE_NAME + " ; ";
}
foreach (var item in table_Carts)
{
cartEntities.Table_Cart.Remove(item);
}
cartEntities.SaveChanges();
return(Content("Thank you for booking! Your Appointment has been booked successfully under the service \n" + ListOfServicesOpted));
}
}
