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;
}
}
