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