public void AddWorkout(workoutcollection objcollection)
{
try
{
using (var objcontext = new WorkoutSPAEntities())
{
objcontext.workoutcollections.Add(objcollection);
objcontext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void AddCategory(workoutcategory objcategory)
{
try
{
using (var objcontext = new WorkoutSPAEntities())
{
objcontext.workoutcategories.Add(objcategory);
objcontext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void SearchCategory(string name)
{
try
{
using (var objcontext = new WorkoutSPAEntities())
{
var query = (from obj in objcontext.workoutcategories
where obj.categoryname == name
select obj).FirstOrDefault();
}
}
catch (Exception ex)
{
throw ex;
}
}
public void EditCategory(workoutcategory item)
{
try
{
using (WorkoutSPAEntities objContext = new WorkoutSPAEntities())
{
var objcategory = (from obj in objContext.workoutcategories
where obj.categoryid == item.categoryid
select obj).First();
objcategory.categoryname = item.categoryname;
objContext.SaveChanges();
}
}
catch (Exception ex)
{
throw ex;
}
}
public CategoryRepository()
{
objcontext = new WorkoutSPAEntities();
}
