public static WorkoutType LoadById(Guid id) { try { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { tblWorkoutType row = dc.tblWorkoutTypes.FirstOrDefault(g => g.Id == id); if (row != null) { WorkoutType workoutType = new WorkoutType { Id = row.Id, Name = row.Name, CaloriesPerMinute = row.CaloriesPerMinute }; return(workoutType); } else { throw new Exception("Row was not found!"); } } } catch (Exception ex) { throw ex; } }
public void LoadTest() { using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; tblWorkoutType row = dc.tblWorkoutTypes.FirstOrDefault(w => w.Name == "Computer Programming"); Assert.IsTrue(row != null); 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 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 Update(WorkoutType workoutType, 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 tblWorkoutType row = dc.tblWorkoutTypes.FirstOrDefault(g => g.Id == workoutType.Id); if (row != null) { //Set properties row.Name = workoutType.Name; row.CaloriesPerMinute = workoutType.CaloriesPerMinute; 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(WorkoutType workoutType, bool rollback = false) { try { int results; using (AmbrosiaEntities dc = new AmbrosiaEntities()) { DbContextTransaction transaction = null; if (rollback) { transaction = dc.Database.BeginTransaction(); } // Make a new row tblWorkoutType row = new tblWorkoutType(); // Set the properties row.Id = Guid.NewGuid(); row.Name = workoutType.Name; row.CaloriesPerMinute = workoutType.CaloriesPerMinute; // Back fill the Id on the object (parameter) workoutType.Id = row.Id; // Insert the row dc.tblWorkoutTypes.Add(row); results = dc.SaveChanges(); if (rollback) { transaction.Rollback(); } } return(results); } catch (Exception ex) { throw ex; } }
public static int Delete(Guid id, 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 tblWorkoutType row = dc.tblWorkoutTypes.FirstOrDefault(g => g.Id == id); if (row != null) { //Delete object dc.tblWorkoutTypes.Remove(row); results = dc.SaveChanges(); if (rollback) { transaction.Rollback(); } } else { throw new Exception("Row was not found!!"); } return(results); } } catch (Exception ex) { throw ex; } }