public int Create(review_order_item roi) { if(roi.rating == null) { roi.rating = 1; } db.review_order_item.Add(roi); return db.SaveChanges(); }
/// <summary> /// for each order item in the order, create a place holder in the review order items /// </summary> /// <param name="order"></param> private void createReviewOrderItemList(order order) { foreach (order_item oi in order.order_item) { if (oi.review_order_item.Count == 0) { review_order_item roi = new review_order_item(); roi.order_item = oi; roi.order_item_id = oi.id; review_order_items.Add(roi); } } }
public ActionResult Create(review_order_item review_order_item) { if (ModelState.IsValid) { try { db.review_order_item.Add(review_order_item); db.SaveChanges(); return RedirectToAction("Index"); } catch (Exception) { } } ViewBag.Error = Global.ServerError; ViewBag.order_item_id = new SelectList(db.order_item, "id", "note", review_order_item.order_item_id); ViewBag.review_id = new SelectList(db.reviews, "id", "id", review_order_item.review_id); return View(review_order_item); }
public void MyTestInitialize() { //Add test data (order specific) db = new touch_for_foodEntities(); menuItem1 = testDatabase.AddMenuItem(item1, menuCategory1); orderItem1 = testDatabase.AddOrderItem(order1, menuItem1); reviewOrderItem1 = testDatabase.AddReviewOrderItem(review1, orderItem1, "testing1", 2); reviewOrderItem2 = testDatabase.AddReviewOrderItem(review1, orderItem1, "testing2", 3); //set parameters for menuItem2 menuItem2 = new menu_item(); menuItem2.item_id = item1.id; menuItem2.menu_category_id = menuCategory1.id; menuItem2.price = new decimal(10.99); menuItem2.is_active = false; menuItem2.is_deleted = false; }
public ActionResult Edit(review_order_item review_order_item) { if (ModelState.IsValid) { db.Entry(review_order_item).State = EntityState.Modified; db.SaveChanges(); return RedirectToAction("Index"); } ViewBag.order_item_id = new SelectList(db.order_item, "id", "note", review_order_item.order_item_id); ViewBag.review_id = new SelectList(db.reviews, "id", "id", review_order_item.review_id); return View(review_order_item); }
public void MyTestInitialize() { review1 = testDatabase.AddReview(restaurant1, order1, user1); reviewItem1 = testDatabase.AddReviewOrderItem(review1, orderItem1, "rexiewTest", 1); }
public void RemoveReviewOrderItem(review_order_item reviewEntityOI) { db = new touch_for_foodEntities(); if (db.review_order_item.Find(reviewEntityOI.id) != null) { db.review_order_item.Remove(db.review_order_item.Find(reviewEntityOI.id)); db.SaveChanges(); } db.Dispose(); }
public review_order_item AddReviewOrderItem(review r, order_item oi, string text, int rating) { //Initialise db = new touch_for_foodEntities(); review_order_item testReviewOI = new review_order_item(); //Set attributes testReviewOI.rating = rating; testReviewOI.order_item_id = oi.id; testReviewOI.review_id = r.id; testReviewOI.submitted_on = System.DateTime.Now; testReviewOI.rating = 0; //Save db.review_order_item.Add(testReviewOI); db.SaveChanges(); db.Dispose(); return testReviewOI; }