public SelectList GetCategoryList() { List <GEMA_TM_CATEGORY> categories = _ctx.GEMA_TM_CATEGORY.Where(x => x.ROW_STATUS == (int)EnumList.RowStatus.Active).ToList(); GEMA_TM_CATEGORY category = new GEMA_TM_CATEGORY { ID = 0, CATEGORY_NAME = "Select Category :" }; categories.Add(category); var categoryList = categories.OrderBy(x => x.ID); SelectList selectList = new SelectList(categoryList, "ID", "CATEGORY_NAME"); return(selectList); }
public ResultStatus Add(GEMA_TM_CATEGORY category) { try { _ctx.GEMA_TM_CATEGORY.Add(category); _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Delete(int id, string modifiedBy, DateTime modifiedTime) { try { GEMA_TM_CATEGORY category = _ctx.GEMA_TM_CATEGORY.Find(id); category.LAST_MODIFIED_TIME = modifiedTime; category.LAST_MODIFIED_BY = modifiedBy; category.ROW_STATUS = eStat.fg.NotActive; _ctx.Entry(category).State = EntityState.Modified; _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Edit(GEMA_TM_CATEGORY category) { try { GEMA_TM_CATEGORY categoryNew = _ctx.GEMA_TM_CATEGORY.Find(category.ID); categoryNew.CATEGORY_NAME = category.CATEGORY_NAME; categoryNew.DESCRIPTION = category.DESCRIPTION; categoryNew.URL = category.URL; categoryNew.CLASS = category.CLASS; categoryNew.IMAGE_PATH = category.IMAGE_PATH; categoryNew.LAST_MODIFIED_TIME = category.LAST_MODIFIED_TIME; categoryNew.LAST_MODIFIED_BY = category.LAST_MODIFIED_BY; _ctx.Entry(categoryNew).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }