public StorySubCategoryModel GetStorySubCategoryModelByID(decimal SEQ_NO) { StorySubCategoryModel model = new StorySubCategoryModel(); using (LBCData context = new LBCData(ConnectionHelper.getConnectionString())) { var lst = from ev in context.LBC_STORY_SUBCATEGORY where ev.SEQ_NO == SEQ_NO select new StorySubCategoryModel { SEQ_NO = ev.SEQ_NO, SUB_CAT_NAME = ev.SUB_CAT_NAME, }; model = lst.SingleOrDefault(); } return(model); }
public StorySubCategoryListProvider(string defaultText = null) { if (!string.IsNullOrEmpty(defaultText)) { Add(string.Empty, defaultText); } StorySubCategoryBL _storesubcategory = new StorySubCategoryBL(); List <StorySubCategoryModel> lst = _storesubcategory.GetAll(); for (int i = 0; i < lst.Count; i++) { StorySubCategoryModel item = new StorySubCategoryModel() { SEQ_NO = lst.ElementAt(i).SEQ_NO, SUB_CAT_NAME = lst.ElementAt(i).SUB_CAT_NAME }; Add(item.SEQ_NO.ToString(), item.SUB_CAT_NAME); } }
/// <summary> /// Update the event count to check the max; /// </summary> /// <param name="model"></param> public void UpdateEventCount(StorySubCategoryModel model) { // LBC_STORY_SubCategory _event = new LBC_STORY_SubCategory(); // bool flag = false; try { using (LBCData context = new LBCData(ConnectionHelper.getConnectionString())) { var _event = (from p in context.LBC_STORY_SUBCATEGORY where p.SEQ_NO == model.SEQ_NO select p).FirstOrDefault(); _event.SUB_CAT_NAME = model.SUB_CAT_NAME; context.SaveChanges(); } } catch (Exception ex) { throw ex; } }