//Get One Category Info public categoryInfo ViewCategory(int CategoryID) { crazyTattoosEntities data = new crazyTattoosEntities(); categoryInfo bt = new categoryInfo(); bt = data.categoryInfoes.Single(c => c.CategoryId == CategoryID); // lamda expression return(bt); }
// Add new Category public int AddCategory(CategoryInfoData Nidata) { crazyTattoosEntities apData = new crazyTattoosEntities(); categoryInfo data = new categoryInfo(); data.CategoryName = Nidata.CategoryName; apData.categoryInfoes.Add(data); int ans = apData.SaveChanges(); return(ans); }
//Update Category info public int UpdateCategory(CategoryInfoData data) { crazyTattoosEntities nidata = new crazyTattoosEntities(); categoryInfo ni = new categoryInfo(); var nsd = from p in nidata.categoryInfoes where p.CategoryId == data.CategoryId select p; foreach (categoryInfo nifo in nsd) { nifo.CategoryId = data.CategoryId; nifo.CategoryName = data.CategoryName; } int ans = nidata.SaveChanges(); return(ans); }