public virtual void Remove(TEntity entityToDelete)
{
if (context.Entry(entityToDelete).State == EntityState.Detached)
{
dbSet.Attach(entityToDelete);
}
dbSet.Remove(entityToDelete);
}
public IHttpActionResult PutOrder(long id, Order order)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != order.OrderID)
{
return(BadRequest());
}
db.Entry(order).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!OrderExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PutItem(int id, Item item)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != item.ItemId)
{
return(BadRequest());
}
db.Entry(item).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!ItemExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IHttpActionResult PostOrder(Order order)
{
try
{
//Order table
if (order.OrderID == 0)
{
db.Orders.Add(order);
}
else
{
db.Entry(order).State = EntityState.Modified;
}
//OrderItems table
foreach (var item in order.OrderItems)
{
if (item.OrderItemID == 0)
{
db.OrderItems.Add(item);
}
else
{
db.Entry(item).State = EntityState.Modified;
}
}
//Delete for OrderItems
if (order.DeletedOrderItemIDs != null)
{
foreach (var id in order.DeletedOrderItemIDs.Split(',').Where(x => x != ""))
{
OrderItem x = db.OrderItems.Find(Convert.ToInt64(id));
db.OrderItems.Remove(x);
}
}
db.SaveChanges();
return(Ok());
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult Register(LoginModel login)
{
if (ModelState.IsValid)
{
using (RestaurantDBEntities db = new RestaurantDBEntities())
{
var repo = new HomeRepository();
var checkUser = repo.GetUserRoleAndId(login.Username, login.Password);
if (checkUser == null)
{
//you should check duplicate registration here
// dc.Roles.Add(U);
// db.Entry()
UserLogin ul = new UserLogin();
User u = new User();
ul.Username = login.Username;
ul.Password = login.Password;
ul.RoleId = 2;
u.RoleId = 2;
u.FirstName = login.FirstName;
u.LastName = login.LastName;
u.Email = login.Username;
u.UserId = login.UserID;
db.Entry(ul).State = EntityState.Added;
db.Entry(u).State = EntityState.Added;
db.SaveChanges();
ModelState.Clear();
// login = null;
ViewBag.Message = "Successfully Registration Done";
}
else
{
ViewBag.Message = "This email already exists in the system.";
}
}
}
return(RedirectToAction("Login", new { id = login.UserID }));
}
public ActionResult Edit([Bind(Include = "restid,restname")] Restaurant restaurant)
{
if (ModelState.IsValid)
{
db.Entry(restaurant).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(restaurant));
}
public ActionResult Edit([Bind(Include = "ID,Text,RestaurantID,Rating,Name")] Review review)
{
if (ModelState.IsValid)
{
db.Entry(review).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(review));
}
public ActionResult Edit([Bind(Include = "ItemId,ItemName,ItemPrice")] Item item)
{
if (ModelState.IsValid)
{
db.Entry(item).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(item));
}
public ActionResult Edit([Bind(Include = "revid,revscore,revsubject")] Review review)
{
if (ModelState.IsValid)
{
db.Entry(review).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.revsubject = new SelectList(db.Restaurants, "restid", "restname", review.revsubject);
return(View(review));
}
public ActionResult UserProfile(LoginModel login)
{
if (ModelState.IsValid)
{
using (RestaurantDBEntities db = new RestaurantDBEntities())
{
//you should check duplicate registration here
// dc.Roles.Add(U);
// db.Entry()
UserLogin ul = new UserLogin();
User u = new User();
ul.Username = login.Username;
// ul.Password = login.Password;
ul.RoleId = 2;
u.FirstName = login.FirstName;
u.LastName = login.LastName;
u.Email = login.Email;
u.Address1 = login.Address1;
u.Address2 = login.Address2;
u.City = login.City;
u.State = login.State;
u.Zip = login.Zip;
u.UserId = ul.UserId;
db.Entry(ul).State = EntityState.Modified;
db.Entry(u).State = EntityState.Modified;
db.SaveChanges();
ModelState.Clear();
// login = null;
ViewBag.Message = "Successfully Registration Done";
}
}
return(View(login));
}
public void Update(PR pR)
{
_restaurantDBEntities.Entry(pR).State = EntityState.Modified;
}
