public ResultStatus Add(GEMA_TM_SUB_CATEGORY subCategory) { try { _ctx.GEMA_TM_SUB_CATEGORY.Add(subCategory); _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_SUB_CATEGORY subCategory = _ctx.GEMA_TM_SUB_CATEGORY.Find(id); subCategory.LAST_MODIFIED_TIME = modifiedTime; subCategory.LAST_MODIFIED_BY = modifiedBy; subCategory.ROW_STATUS = eStat.fg.NotActive; _ctx.Entry(subCategory).State = EntityState.Modified; _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }
public ResultStatus Edit(GEMA_TM_SUB_CATEGORY subCategory) { try { GEMA_TM_SUB_CATEGORY subCategoryNew = _ctx.GEMA_TM_SUB_CATEGORY.Find(subCategory.ID); subCategoryNew.CATEGORY_ID = subCategory.CATEGORY_ID; subCategoryNew.SUB_CATEGORY_NAME = subCategory.SUB_CATEGORY_NAME; subCategoryNew.DESCRIPTION = subCategory.DESCRIPTION; subCategoryNew.IMAGE_PATH = subCategory.IMAGE_PATH; subCategoryNew.LAST_MODIFIED_TIME = subCategory.LAST_MODIFIED_TIME; subCategoryNew.LAST_MODIFIED_BY = subCategory.LAST_MODIFIED_BY; _ctx.Entry(subCategoryNew).State = System.Data.Entity.EntityState.Modified; _ctx.SaveChanges(); rs.SetSuccessStatus(); } catch (Exception ex) { rs.SetErrorStatus(ex.Message); } return(rs); }