//to add a workout public void AddWorkout(workout_collection item) { try { db.workout_collection.Add(item); db.SaveChanges(); } catch (Exception ex) { throw ex; } }
//to edit the workout public void EditWorkout(workout_collection item) { try { var ObjCategory = (from obj in db.workout_collection where obj.workout_id == item.workout_id select obj).First(); ObjCategory.workout_note = item.workout_note; ObjCategory.workout_title = item.workout_title; ObjCategory.calories_burn_per_min = item.calories_burn_per_min; db.SaveChanges(); } catch (Exception ex) { throw ex; } }
//workout by id public workout_collection SearchWorkoutById(int id) { workout_collection objWork = null; Console.WriteLine("enter name of category"); int Id = Convert.ToInt32(Console.ReadLine()); try { objWork = (from obj in db.workout_collection where obj.workout_id == Id select obj).First(); } catch (Exception ex) { throw ex; } return(objWork); }