public static Workout LoadById(Guid id)
{
try
{
using (AmbrosiaEntities dc = new AmbrosiaEntities())
{
tblWorkout row = dc.tblWorkouts.FirstOrDefault(g => g.Id == id);
if (row != null)
{
Workout workout = new Workout
{
Id = row.Id,
WorkoutType = WorkoutTypeManager.LoadById(row.WorkoutTypeId),
StartTime = row.StartTime,
EndTime = row.EndTime,
UserId = row.UserId
};
return(workout);
}
else
{
throw new Exception("Row was not found!");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void LoadTest()
{
using (AmbrosiaEntities dc = new AmbrosiaEntities())
{
DbContextTransaction transaction = null;
tblWorkout row = dc.tblWorkouts.FirstOrDefault();
Assert.IsTrue(row != null);
transaction.Rollback();
}
}
public void DeleteTest()
{
using (AmbrosiaEntities dc = new AmbrosiaEntities())
{
DbContextTransaction transaction = null;
tblWorkout row = dc.tblWorkouts.FirstOrDefault();
dc.tblWorkouts.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 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;
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 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 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;
}
}
public ActionResult Add(int MemberId, string SunDesc, string MonDesc, string TueDesc, string WedDesc, string ThuDesc, string FriDesc)
{
if (ModelState.IsValid)
{
int?memberid = MemberId;
tblWorkout tb = new tblWorkout();
tb.MemberId = memberid;
tb.WorkoutDays = "Sunday";
tb.Description = SunDesc;
_db.tblWorkouts.Add(tb);
_db.SaveChanges();
tb.WorkoutDays = "Monday";
tb.Description = MonDesc;
_db.tblWorkouts.Add(tb);
_db.SaveChanges();
tb.WorkoutDays = "Tuesday";
tb.Description = TueDesc;
_db.tblWorkouts.Add(tb);
_db.SaveChanges();
tb.WorkoutDays = "Wednesday";
tb.Description = WedDesc;
_db.tblWorkouts.Add(tb);
_db.SaveChanges();
tb.WorkoutDays = "Thursday";
tb.Description = ThuDesc;
_db.tblWorkouts.Add(tb);
_db.SaveChanges();
tb.WorkoutDays = "Friday";
tb.Description = FriDesc;
_db.tblWorkouts.Add(tb);
_db.SaveChanges();
}
List <MemberViewModel> lstmemvm = new List <MemberViewModel>();
var users = _db.tblUsers.ToList();
foreach (var item in users)
{
tblMembership tbm = _db.tblMemberships.Where(m => m.UserId == item.UserId).FirstOrDefault();
if (tbm != null)
{
lstmemvm.Add(new MemberViewModel()
{
MemberId = tbm.MembershipId, Fullname = item.Fullname
});
}
}
ViewBag.Fullname = lstmemvm;
ViewBag.Message = "Work out Added Successfully";
return(View());
}
