public IEnumerable<HeaderNavigationDTO> GetHeaderNavigationDTOs() { using (var context = new Data.QUERYEntities()) { return (from header in context.Headers join menu in context.Menus on header.MenuID equals menu.MenuID where header.IsVisible select new HeaderNavigationDTO() { MenuTitle = header.MenuItem, HeaderID = header.HeaderID, PermissionID = header.PermissionID.Value, ParentMenuName = menu.Name }).ToList(); } }
public IList<ColumnDTO> GetColumnDTOsByHeaderID(int headerID) { using(var context = new Data.QUERYEntities()) { return context.Columns.Where(c => c.COHEID == headerID).Select(c => new ColumnDTO() { Field = c.COField, IsHideable = c.COIsHideable, IsIdentifier = c.COIsID, IsSummable = c.COCanSum, Sum = c.COSum, Title = c.COTitle, ViewOrder = c.COOrder, Width = c.COWidth }).ToList(); } }
public BaseHeaderDTO GetBaseHeaderDTO(int headerID) { using(var context = new Data.QUERYEntities()) { var header = context.Headers.First(h => h.HeaderID == headerID); return new BaseHeaderDTO() { Database = header.Database, Subtitle = header.Subtitle, Title = header.MainTitle, QueryEndString = header.QueryEndString, QueryStartString = header.QueryStartString, Type = header.HEType, StoredProcedureName = header.StoredProcedure }; } }
public IList<FilterDTO> GetFilterDTOsByHeaderID(int headerID) { using (var context = new Data.QUERYEntities()) { return (from filter in context.Filters join header in context.Headers on filter.HeaderID equals header.HeaderID where filter.HeaderID == headerID select new FilterDTO() { CName = filter.CName, CTitle = filter.CTitle, CSelect = filter.CSelect, GroupIndex = filter.Group, FullName = filter.Field, Name = filter.Name, Title = filter.Title, Type = filter.Type, ViewOrder = filter.Order, Operator = filter.Relation, PreFilter = filter.CPreFilter, PostFilter = filter.CPostFilter }).ToList(); } }
public ActionResult CreateUser(FormCollection form) { var userDetailsModel = new UserDetailsModel() { UserId = form["UserId"], BU = form["BU"], GPN = form["GPN"], LocationId = form["LocationId"], Mail = form["Mail"], SMU = form["SMU"], UserName = form["UserName"] }; var permissionLocation = new List<PermissionLocationModel>(); foreach (var key in form.Keys) { if (key.ToString().StartsWith("permissionLocation")) { var values = form[key.ToString()].Split(';'); var locationId = values[0]; var permissionId = int.Parse(values[1]); permissionLocation.Add(new PermissionLocationModel() { LocationId = locationId, PermissionId = permissionId }); } } userDetailsModel.Permissions = permissionLocation; using (var context = new Data.QUERYEntities()) { var user = new User() { BU = userDetailsModel.BU, GPN = userDetailsModel.GPN, LocationID = userDetailsModel.LocationId, Mail = userDetailsModel.Mail, Name = userDetailsModel.UserName, SMU = userDetailsModel.SMU, PermissionType = "GPN", Date = DateTime.Now, UserID = userDetailsModel.UserId }; foreach (var up in userDetailsModel.Permissions) { user.UserPermissions.Add(new UserPermission() { PermissionID = up.PermissionId, LocalID = up.LocationId }); } context.Users.Add(user); try { context.SaveChanges(); } catch (DbEntityValidationException ex) { var q = ex; throw; } } return RedirectToAction("EditUser", new { userId = userDetailsModel.UserId}); }
public ActionResult EditUser(FormCollection form) { var userDetailsModel = new UserDetailsModel() { BU = form["UserDetails.BU"], GPN = form["UserDetails.GPN"], LocationId = form["UserDetails.LocationId"], Mail = form["UserDetails.Mail"], SMU = form["UserDetails.SMU"], UserId = form["UserDetails.UserId"], UserName = form["UserDetails.UserName"] }; var permissionLocation = new List<PermissionLocationModel>(); foreach (var key in form.Keys) { if (key.ToString().StartsWith("permissionLocation")) { var values = form[key.ToString()].Split(';'); var locationId = values[0]; var permissionId = int.Parse(values[1]); permissionLocation.Add(new PermissionLocationModel() { LocationId = locationId, PermissionId = permissionId }); } } userDetailsModel.Permissions = permissionLocation; using (var context = new Data.QUERYEntities()) { var user = context.Users.Single(u => u.UserID == userDetailsModel.UserId); user.BU = userDetailsModel.BU; user.GPN = userDetailsModel.GPN; user.LocationID = userDetailsModel.LocationId; user.Mail = userDetailsModel.Mail; user.Name = userDetailsModel.UserName; user.SMU = userDetailsModel.SMU; foreach (var up in context.UserPermissions.Where(up => up.UserID == userDetailsModel.UserId)) { context.UserPermissions.Remove(up); } foreach (var up in userDetailsModel.Permissions) { context.UserPermissions.Add(new UserPermission() { UserID = userDetailsModel.UserId, PermissionID = up.PermissionId, LocalID = up.LocationId }); } context.SaveChanges(); } return EditUser(userDetailsModel.UserId); }