public void UiOrderingManager(OrderQuery order, string tableName, string pkName = "Id")
{
string query = null;
if (order.ToPosition > order.FromPosition)
{
query = @"Update " + tableName + " set [Order] = [Order]-1 where [Order] between " + order.FromPosition + "+1 and " + order.ToPosition + "";
}
if (order.ToPosition < order.FromPosition)
{
query = @"Update " + tableName + " set [Order] = [Order]+1 where [Order] between " + order.ToPosition + " and " + order.FromPosition + "-1";
}
using (var db = new MvcDemoContext())
{
if (query != null)
{
db.Database.ExecuteSqlCommand(query);
query = @"UPDATE " + tableName + " SET [Order]=" + order.ToPosition + " WHERE " + pkName + " = " +
order.Id + "";
db.Database.ExecuteSqlCommand(query);
}
db.SaveChanges();
}
}
private List <ModulesViewModel> BuildTree()
{
var vm = new List <ModulesViewModel>();
using (var db = new MvcDemoContext())
{
var modulos = db.Modules.OrderBy(x => x.Order).ToList();
var usuario = CarregarUsuario(db);
var usuarioGrupoPermissao = db.UserGroupPermissions
.FirstOrDefault(x => x.UserId == usuario.UserId);
var permissaoFuncionalidade = db.FunctionalityPermissions.Where(x => x.PermissionGroupId == usuarioGrupoPermissao.PermissionGroupId && x.Read == true);
var functionalities = new List <Functionality>();
foreach (var item in permissaoFuncionalidade)
{
functionalities.Add(item.Functionality);
}
foreach (var modulo in modulos)
{
var model = new ModulesViewModel
{
Nome = modulo.Name,
ModuloId = (int)modulo.ModuleId,
Icone = modulo.Icon,
Ordem = modulo.Order,
Functionalities = functionalities.Where(x => x.ModuleId == modulo.ModuleId).OrderBy(x => x.Order).ToList()
};
vm.Add(model);
}
}
return(vm);
}
private User CarregarUsuario(MvcDemoContext db)
{
var userPerfil = this.LoadUserProfileLoggedIn();
var user = this.GetLoggedUser();
var usuario = db.Users.Find(user);
return(usuario);
}
static void Main(string[] args)
{
using (var db = new MvcDemoContext())
{
/*
* // Display all Blogs from the database
* var queryClients = from b in db.Portals
* orderby b.PortalName
* select b;
*
* Console.WriteLine("All clients(portals) in the database:");
* foreach (var item in queryClients)
* {
* Console.WriteLine(string.Format("PortalId: {0} - {1}", item.Id, item.PortalName));
* }
*
* Console.WriteLine("Press any key to exit...");
* Console.ReadKey();
*
*
* //Portals can have multiple Courses.
* var queryCourses = from b in db.CoursePortals
* where b.PortalId == 449
* orderby b.CoursePortalName
* select b;
*
* Console.WriteLine("All courses for client 449 in the database:");
* foreach (var item in queryCourses)
* {
* Console.WriteLine(string.Format("CoursePortalId: {0} - {1}", item.Id, item.CoursePortalName));
* }
*
* Console.WriteLine("Press any key to exit...");
* Console.ReadKey();
*
*/
var results = from r in db.Registrations
join u in db.Users on r.UserId equals u.Id
where (r.CoursePortalId == 100003)
select new UserModel
{
Id = u.Id,
FirstName = u.FirstName,
LastName = u.LastName,
RegistrationTime = r.RegistrationTime
};
foreach (var item in results)
{
Console.WriteLine(string.Format("UserId: {0} - {1} - {2} - {3}", item.Id, item.FirstName, item.LastName, item.RegistrationTime));
}
Console.WriteLine("Press any key to exit...");
Console.ReadKey();
}
}
public CarsController(MvcDemoContext ctx)
{
_ctx = ctx;
if (_ctx.Cars.Count() == 0)
{
_ctx.Cars.Add(
new Car
{
BrandName = "DMC",
ModelName = "Delorian",
YearOfConstruction = 1985
});
_ctx.SaveChanges();
}
}
protected override void OnActionExecuting(ActionExecutingContext filterContext)
{
var actionDescriptor = filterContext.ActionDescriptor;
ActionName = actionDescriptor.ActionName;
ControllerName = actionDescriptor.ControllerDescriptor.ControllerName;
var permissionsCore = (filterContext.HttpContext.Session?["permissions"] as List <ModulesViewModel>);
if (permissionsCore != null)
{
var funcionalidades = permissionsCore.SingleOrDefault(x => x.Functionalities.Any(m => m.Url == ControllerName));
var funcExistente = funcionalidades?.Functionalities.FirstOrDefault(x => x.Url == ControllerName);
if (funcExistente != null)
{
using (var db = new MvcDemoContext())
{
var userId = Convert.ToInt64(System.Web.HttpContext.Current.User.Identity.Name);
var userPerfil = this.LoadUserProfileLoggedIn();
var permiss = db.FunctionalityPermissions.FirstOrDefault(x => x.FunctionalityId == funcExistente.FunctionalityId && x.PermissionGroup.ProfileTypeId == userPerfil);
if (permiss != null)
{
var grupo = db.UserGroupPermissions.FirstOrDefault(x => x.UserId == userId && x.PermissionGroupId == permiss.PermissionGroupId);
if (grupo != null)
{
filterContext.HttpContext.Session["permissionsCore"] = permiss;
}
}
}
}
}
filterContext.Controller.TempData.Keep();
base.OnActionExecuting(filterContext);
}
public MoviesController(MvcDemoContext context)
{
_context = context;
}
