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