//to add a category public void AddCategory(workout_category item) { try { db.workout_category.Add(item); db.SaveChanges(); } catch (Exception ex) { throw ex; } }
//to edit the categories public void EditCategory(workout_category item) { try { var ObjCategory = (from obj in db.workout_category where obj.category_id == item.category_id select obj).First(); ObjCategory.category_name = item.category_name; db.SaveChanges(); } catch (Exception ex) { throw ex; } }
//to search categories by name public workout_category SearchCategoryById(int id) { workout_category objWork = null; Console.WriteLine("enter name of category"); int Id = Convert.ToInt32(Console.ReadLine()); try { objWork = (from obj in db.workout_category where obj.category_id == Id select obj).First(); } catch (Exception ex) { throw ex; } return(objWork); }