public void AddCollection(workout_collection item)
{
try
{
WorkoutspaEntities1 db = new WorkoutspaEntities1();
db.workout_collection.Add(item);
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}
public workout_collection Find(int id)
{
workout_collection objWork = null;
try
{
WorkoutspaEntities1 db = new WorkoutspaEntities1();
objWork = (from obj in db.workout_collection
where obj.workout_id == id
select obj).First();
}
catch (Exception ex)
{
throw ex;
}
return(objWork);
}
public void EditCollection(workout_collection item)
{
try
{
WorkoutspaEntities1 db = new WorkoutspaEntities1();
var ObjCollection = (from obj in db.workout_collection
where obj.workout_id == item.workout_id
select obj).First();
ObjCollection.workout_title = item.workout_title;
ObjCollection.workout_note = item.workout_note;
ObjCollection.calories_burn_per_min = item.calories_burn_per_min;
ObjCollection.category_id = item.category_id;
db.SaveChanges();
}
catch (Exception ex)
{
throw ex;
}
}