public static Food LoadById(int fdcid) { try { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { tblFoodItem row = dc.tblFoodItems.FirstOrDefault(g => g.FDCId == fdcid); if (row != null) { FoodItem foodItem = new FoodItem { Id = row.Id, FDCId = row.FDCId, MealId = row.MealId, Quantity = row.Quantity }; return(fdcFoodManager.Search(foodItem)); } else { throw new Exception("Row was not found!"); } } } catch (Exception ex) { throw ex; } }
public void LoadTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblFoodItem row = dc.tblFoodItems.FirstOrDefault(fi => fi.FDCId == 1); Assert.IsTrue(row != null); transaction.Rollback(); } }
public void DeleteTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblFoodItem row = dc.tblFoodItems.FirstOrDefault(fi => fi.FDCId == 1); dc.tblFoodItems.Remove(row); Assert.IsTrue(dc.SaveChanges() == 1); transaction.Rollback(); } }
public void InsertTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblFoodItem row = new tblFoodItem { Id = Guid.NewGuid(), FDCId = 1, MealId = dc.tblMeals.FirstOrDefault(m => m.Description == "Ate 4 eggs").Id, Quantity = 1 }; dc.tblFoodItems.Add(row); Assert.IsTrue(dc.SaveChanges() == 1); transaction.Rollback(); } }
public static void InsertList(List <Food> foodItems, Guid mealid, bool rollback = false) { try { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; if (rollback) { transaction = dc.Database.BeginTransaction(); } // Make a new row foreach (Food foodItem in foodItems) { tblFoodItem row = new tblFoodItem(); // Set the properties row.Id = Guid.NewGuid(); row.FDCId = foodItem.FDCId; row.Quantity = foodItem.Quantity; row.MealId = mealid; // Back fill the Id on the object (parameter) foodItem.Id = row.Id; // Insert the row dc.tblFoodItems.Add(row); if (rollback) { transaction.Rollback(); } } dc.SaveChanges(); } } catch (Exception ex) { throw ex; } }
public static int Update(FoodItem foodItem, 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 tblFoodItem row = dc.tblFoodItems.FirstOrDefault(g => g.Id == foodItem.Id); if (row != null) { //Set properties row.FDCId = foodItem.FDCId; row.MealId = foodItem.MealId; row.Quantity = foodItem.Quantity; results = dc.SaveChanges(); if (rollback) { transaction.Rollback(); } } else { throw new Exception("Row was not found!!"); } return(results); } } catch (Exception ex) { throw ex; } }
public static int Insert(FoodItem foodItem, bool rollback = false) { try { int results; using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; if (rollback) { transaction = dc.Database.BeginTransaction(); } // Make a new row tblFoodItem row = new tblFoodItem(); // Set the properties row.Id = Guid.NewGuid(); row.FDCId = foodItem.FDCId; row.Quantity = foodItem.Quantity; row.MealId = foodItem.MealId; // Back fill the Id on the object (parameter) foodItem.Id = row.Id; // Insert the row dc.tblFoodItems.Add(row); results = dc.SaveChanges(); if (rollback) { transaction.Rollback(); } } return(results); } catch (Exception ex) { throw ex; } }
public static int Delete(FoodItem foodItem, 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 tblFoodItem row = dc.tblFoodItems.FirstOrDefault(g => g.Id == foodItem.Id); if (row != null) { //Delete object dc.tblFoodItems.Remove(row); results = dc.SaveChanges(); if (rollback) { transaction.Rollback(); } } else { throw new Exception("Row was not found!!"); } return(results); } } catch (Exception ex) { throw ex; } }