public void UpdateTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblUser row = dc.tblUsers.FirstOrDefault(u => u.FirstName == "Phillip"); row.Username = "******"; Assert.IsTrue(dc.SaveChanges() == 1); transaction.Rollback(); } }
public void DeleteTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblWorkoutType row = dc.tblWorkoutTypes.FirstOrDefault(w => w.Name == "Computer Programming"); dc.tblWorkoutTypes.Remove(row); Assert.IsTrue(dc.SaveChanges() == 1); 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 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 void DeleteTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblUser row = dc.tblUsers.FirstOrDefault(u => u.FirstName == "Phillip"); dc.tblUsers.Remove(row); Assert.IsTrue(dc.SaveChanges() == 1); transaction.Rollback(); } }
public void UpdateTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblWorkout row = dc.tblWorkouts .FirstOrDefault(w => w.UserId == dc.tblUsers.FirstOrDefault(u => u.FirstName == "Phillip").Id); row.EndTime = DateTime.Now; Assert.IsTrue(dc.SaveChanges() == 1); transaction.Rollback(); } }
public void InsertTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblWorkoutType row = new tblWorkoutType { Id = Guid.NewGuid(), Name = "Computer Programming", CaloriesPerMinute = 0 }; dc.tblWorkoutTypes.Add(row); Assert.IsTrue(dc.SaveChanges() == 1); transaction.Rollback(); } }
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 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 int Insert(User user, bool rollback = false) { try { int results; using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; if (rollback) { transaction = dc.Database.BeginTransaction(); } // Make a new row tblUser row = new tblUser(); // Set the properties row.Id = Guid.NewGuid(); row.FirstName = user.FirstName; row.LastName = user.LastName; row.Username = user.Username; row.Password = GetHash(user.Password); // Back fill the Id on the object (parameter) user.Id = row.Id; // Insert the row dc.tblUsers.Add(row); results = dc.SaveChanges(); if (rollback) { transaction.Rollback(); } } return(results); } catch (Exception ex) { throw ex; } }
public void InsertTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblWorkout row = new tblWorkout { Id = Guid.NewGuid(), StartTime = DateTime.Now, EndTime = DateTime.Now, UserId = dc.tblUsers.FirstOrDefault(u => u.FirstName == "Phillip").Id, WorkoutTypeId = dc.tblWorkoutTypes.FirstOrDefault(w => w.Name == "Computer Programming").Id }; dc.tblWorkouts.Add(row); Assert.IsTrue(dc.SaveChanges() == 1); transaction.Rollback(); } }
public static int Insert(Workout workout, bool rollback = false) { try { int results; using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; if (rollback) { transaction = dc.Database.BeginTransaction(); } // Make a new row tblWorkout row = new tblWorkout(); // Set the properties row.Id = Guid.NewGuid(); row.WorkoutTypeId = workout.WorkoutType.Id; row.StartTime = workout.StartTime; row.EndTime = workout.EndTime; row.UserId = workout.UserId; // Back fill the Id on the object (parameter) workout.Id = row.Id; // Insert the row dc.tblWorkouts.Add(row); results = dc.SaveChanges(); if (rollback) { transaction.Rollback(); } } return(results); } catch (Exception ex) { throw ex; } }
public void InsertTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblUser row = new tblUser { Id = Guid.NewGuid(), FirstName = "Phillip", LastName = "Fry", Username = "******", Password = "******" }; dc.tblUsers.Add(row); Assert.IsTrue(dc.SaveChanges() == 1); transaction.Rollback(); } }
public static int Update(User user, 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 tblUser row = dc.tblUsers.FirstOrDefault(g => g.Id == user.Id); if (row != null) { //Set properties row.FirstName = user.FirstName; row.LastName = user.LastName; row.Username = user.Username; //removed password from the standard edit so that the password does not get repeatedly hashed if it is not changed //row.Password = user.Password; 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 Update(Workout workout, 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 tblWorkout row = dc.tblWorkouts.FirstOrDefault(g => g.Id == workout.Id); if (row != null) { //Set properties row.WorkoutTypeId = workout.WorkoutType.Id; row.StartTime = workout.StartTime; row.EndTime = workout.EndTime; row.UserId = workout.UserId; results = dc.SaveChanges(); if (rollback) { transaction.Rollback(); } } else { throw new Exception("Row was not found!!"); } return(results); } } catch (Exception ex) { throw ex; } }
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 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(Workout workout, 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 tblWorkout row = dc.tblWorkouts.FirstOrDefault(g => g.Id == workout.Id); if (row != null) { //Delete object dc.tblWorkouts.Remove(row); results = dc.SaveChanges(); if (rollback) { transaction.Rollback(); } } else { throw new Exception("Row was not found!!"); } return(results); } } catch (Exception ex) { throw ex; } }