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;
}
}
