public static Meal LoadById(Guid id) { try { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { tblMeal row = dc.tblMeals.FirstOrDefault(g => g.Id == id); if (row != null) { Meal meal = new Meal { Id = row.Id, UserId = row.UserId, Description = row.Description, Time = row.Time, FoodItems = FoodItemManager.Load(row.Id) }; return(meal); } else { throw new Exception("Row was not found!"); } } } catch (Exception ex) { throw ex; } }
internal NewGuestViewModel(NewGuestView view, string ordererPersonalNo) { this.view = view; Meals = LoadMeals(); selectedMeal = new tblMeal(); Meal = new tblMeal(); newOrder = new tblOrder(); orderedMeals = new List <tblMealOrder>(); this.ordererPersonalNo = ordererPersonalNo; }
public void LoadTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblMeal row = dc.tblMeals.FirstOrDefault(m => m.Description == "Ate 4 eggs"); Assert.IsTrue(row != null); transaction.Rollback(); } }
public void DeleteTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblMeal row = dc.tblMeals.FirstOrDefault(m => m.Description == "Ate 4 eggs"); dc.tblMeals.Remove(row); Assert.IsTrue(dc.SaveChanges() == 1); transaction.Rollback(); } }
public ActionResult SubmitMeal(List <UserCheckedDAO> us, FormCollection f) { Thread.Sleep(2000); int sl = us.Count(i => i.IsChecked == true); float money = float.Parse(f.Get("money").ToString()); string des = f.Get("description"); string res = ""; tblUser actor = (tblUser)Session["User"]; if (money % 1000 != 0 || money < 1000) { return(Content("Erro! Nhập tiền sai! ")); } tblMeal meal = new tblMeal(); meal.Datetime = DateTime.Now; meal.Totalmoney = money; meal.Description = des; meal.IDActor = actor.ID; meal.Status = false; db.tblMeals.Add(meal); db.SaveChanges(); foreach (UserCheckedDAO it in us) { if (it.IsChecked) { var tempu = db.tblUsers.FirstOrDefault(i => i.ID == it.UserChecked.ID); tblUser_Meal um = new tblUser_Meal(); um.IDMeal = meal.ID; um.IDUser = it.UserChecked.ID; um.Status = false; db.tblUser_Meal.Add(um); db.SaveChanges(); res += " " + tempu.Fullname; } } res += "trung bình: " + money / sl; return(Content("Gửi yêu cầu tính tiền cho: " + res)); }
public static int Insert(Meal meal, bool rollback = false) { try { int results; using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; if (rollback) { transaction = dc.Database.BeginTransaction(); } // Make a new row tblMeal row = new tblMeal(); // Set the properties row.Id = Guid.NewGuid(); row.UserId = meal.UserId; row.Description = meal.Description; row.Time = meal.Time; // Back fill the Id on the object (parameter) meal.Id = row.Id; // Insert the row dc.tblMeals.Add(row); results = dc.SaveChanges(); //insert the food items FoodItemManager.InsertList(meal.FoodItems, meal.Id); if (rollback) { transaction.Rollback(); } } return(results); } catch (Exception ex) { throw ex; } }
public void InsertTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblMeal row = new tblMeal { Id = Guid.NewGuid(), Description = "Ate 4 eggs", Time = DateTime.Now, UserId = dc.tblUsers.FirstOrDefault(m => m.FirstName == "Phillip").Id }; dc.tblMeals.Add(row); Assert.IsTrue(dc.SaveChanges() == 1); transaction.Rollback(); } }
public static int Update(Meal meal, bool rollback = false) { //Update Row try { int results; using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; if (rollback) { transaction = dc.Database.BeginTransaction(); } //New Table Object for row tblMeal row = dc.tblMeals.FirstOrDefault(g => g.Id == meal.Id); if (row != null) { //Set properties row.UserId = meal.UserId; row.Description = meal.Description; row.Time = meal.Time; results = dc.SaveChanges(); meal.FoodItems.ForEach(f => FoodItemManager.Update(f)); if (rollback) { transaction.Rollback(); } } else { throw new Exception("Row was not found!!"); } return(results); } } catch (Exception ex) { throw ex; } }
public static int Delete(Meal meal, bool rollback = false) { try { int results; using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; if (rollback) { transaction = dc.Database.BeginTransaction(); } //New Table Object for row tblMeal row = dc.tblMeals.FirstOrDefault(g => g.Id == meal.Id); if (row != null) { //Delete object dc.tblMeals.Remove(row); results = dc.SaveChanges(); if (rollback) { transaction.Rollback(); } } else { throw new Exception("Row was not found!!"); } return(results); } } catch (Exception ex) { throw ex; } }