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