public Menu GetDataById(string menuId)
{
using (HRSSContext <Menu> context = new HRSSContext <Menu>())
{
return(context.DBEntities.Where(i => i.MenuId == menuId).FirstOrDefault());
}
}
public List <Menu> GetAll()
{
using (var context = new HRSSContext <Menu>())
{
return(context.Set <Menu>().ToList());
}
}
public void Update(Menu entity)
{
using (var context = new HRSSContext <Menu>())
{
Menu data = context.DBEntities.Where(i => i.MenuId == entity.MenuId).FirstOrDefault();
if (data == null)
{
throw new Exception("Data Not Exist");
}
else
{
data.MenuName = entity.MenuName;
data.ParentId = entity.ParentId;
data.Url = entity.Url;
data.Sort = entity.Sort;
data.Icon = entity.Icon;
data.SiteMap = entity.SiteMap;
data.TypeMenu = entity.TypeMenu;
data.IsPublic = entity.IsPublic;
data.EditBy = entity.EditBy;
data.EditDate = entity.EditDate;
context.SaveChanges();
}
}
}
public List <Group> GetDataByFilter(string groupId, string groupName)
{
using (HRSSContext <Group> context = new HRSSContext <Group>())
{
return(context.DBEntities.Where(i => i.GroupId.Contains(groupId) || i.GroupName.Contains(groupName)).ToList());
}
}
public Group GetDataById(string groupId)
{
using (HRSSContext <Group> context = new HRSSContext <Group>())
{
return(context.DBEntities.Where(i => i.GroupId == groupId).FirstOrDefault());
}
}
public User GetDataByUserId(string userId)
{
using (HRSSContext <User> context = new HRSSContext <User>())
{
return(context.DBEntities.Where(i => i.UserId == userId).FirstOrDefault());
}
}
public void Update(User entity)
{
using (var context = new HRSSContext <User>())
{
User data = context.DBEntities.Where(i => i.UserId == entity.UserId).FirstOrDefault();
if (data == null)
{
throw new Exception("Data Not Exist");
}
else
{
data.UserName = entity.UserName;
data.Password = entity.Password;
data.Images = entity.Images;
data.GroupMenuId = entity.GroupMenuId;
data.IsActive = entity.IsActive;
data.ThemeId = entity.ThemeId;
data.SessionID = entity.SessionID;
data.LastLoginTime = entity.LastLoginTime;
data.PasswordExpired = entity.PasswordExpired;
data.EditBy = entity.EditBy;
data.EditDate = entity.EditDate;
context.SaveChanges();
}
}
}
public Report GetDataById(string reportId)
{
using (HRSSContext <Report> context = new HRSSContext <Report>())
{
return(context.DBEntities.Where(i => i.ReportId == Convert.ToInt16(reportId)).FirstOrDefault());
}
}
public void Delete(Menu entity)
{
using (var context = new HRSSContext <Menu>())
{
Menu data = context.DBEntities.Where(x => x.MenuId == entity.MenuId).FirstOrDefault();
if (data == null)
{
throw new Exception("Data Not Exist");
}
else
{
context.DBEntities.Remove(data);
context.SaveChanges();
}
}
}
public void Add(Menu entity)
{
using (var context = new HRSSContext <Menu>())
{
Menu data = context.DBEntities.Where(x => x.MenuId == entity.MenuId).FirstOrDefault();
if (data != null)
{
throw new Exception("Data Already Exist");
}
else
{
context.DBEntities.Add(entity);
context.SaveChanges();
}
}
}
public void Update(Group entity)
{
using (var context = new HRSSContext <Group>())
{
Group data = context.DBEntities.Where(i => i.GroupId == entity.GroupId).FirstOrDefault();
if (data == null)
{
throw new Exception("Data Not Exist");
}
else
{
data.GroupName = entity.GroupName;
data.EditBy = entity.EditBy;
data.EditDate = entity.EditDate;
context.SaveChanges();
}
}
}
public List <Group> GetDataFromGridSetting(Group gridSetting)
{
using (var context = new HRSSContext <Group>())
{
var result = context.Set <Group>().ToList();
//// Filter field DataBind JqGrid
if (!string.IsNullOrEmpty(gridSetting.GroupId))
{
result = (gridSetting.GroupId != string.Empty) ? result.Where(x => x.GroupId.ToLower().Contains(gridSetting.GroupId.ToLower())).ToList() : result.ToList();
}
if (!string.IsNullOrEmpty(gridSetting.GroupName))
{
result = (gridSetting.GroupName != string.Empty) ? result.Where(x => x.GroupName.ToLower().Contains(gridSetting.GroupName.ToLower())).ToList() : result.ToList();
}
// SortOrder field DataBind JqGrid
switch (gridSetting.sortColumn)
{
case "GroupId":
result = (gridSetting.sortOrder == "desc") ? result.OrderByDescending(x => x.GroupId).ToList() : result.OrderBy(x => x.GroupId).ToList();
break;
case "GroupName":
result = (gridSetting.sortOrder == "desc") ? result.OrderByDescending(x => x.GroupName).ToList() : result.OrderBy(x => x.GroupName).ToList();
break;
default:
break;
}
// Paging total Record
gridSetting.totalRecords = result.Count();
//return result;
return(result.Skip((gridSetting.pageIndex - 1) * gridSetting.pageSize).Take(gridSetting.pageSize).ToList());
}
}
