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