public static void CreateUser(RegWindow regWindow)
{
var user = new User();
AuthorizationEntities.GetEntities().Users.Add(user);
AuthorizationEntities.GetEntities().SaveChanges();
}
public UserRolePermission Authorize(string UserID, string Url)
{
if (string.IsNullOrEmpty(UserID) || string.IsNullOrEmpty(Url))
{
throw new ArgumentException("User Or Url is Null or Empty!");
}
AuthorizationEntities context = AuthorizationEntities.CreateContext();
UserRolePermission result = (from rp in context.RolePermissions
join r in context.Roles on rp.RoleID equals r.RoleID
join p in context.Permissions on rp.PermissionID equals p.PermissionID
join u in context.UserRoles on r.RoleID equals u.RoleID
where u.UserID == UserID &&
p.URL == Url
select new UserRolePermission
{
UserID = u.UserID,
RoleID = r.RoleID,
RoleName = r.RoleName,
PermissionID = p.PermissionID,
PermissionName = p.PermissionName,
URL = p.URL
}).FirstOrDefault();
return(result);
}
public void AddRoles(Roles role)
{
Contract.NotNull(role, "role");
using (var context = AuthorizationEntities.CreateContext())
{
context.Roles.Add(role);
context.SaveChanges();
}
}
public void UpdateRoles(Roles role)
{
Contract.NotNull(role, "role");
using (var context = AuthorizationEntities.CreateContext())
{
context.Roles.Attach(role);
context.Entry(role).State = EntityState.Modified;
context.SaveChanges();
}
}
public static void CheckData(AutoWindow autoWindow)
{
var check = AuthorizationEntities.GetEntities().Users.FirstOrDefault(x => x.Login == autoWindow.loginTextBox.Text &&
x.Password == autoWindow.passwordTextBox.Password);
if (check == null)
{
MessageBox.Show("Неверно введен логин или пароль");
}
else
{
UsersWindow usersWindow = new UsersWindow(check);
usersWindow.Show();
autoWindow.Close();
}
}
public List <UserRolePermission> GetRoles()
{
using (var context = AuthorizationEntities.CreateContext())
{
List <UserRolePermission> result = (from rp in context.RolePermissions
join r in context.Roles on rp.RoleID equals r.RoleID
join p in context.Permissions on rp.PermissionID equals p.PermissionID
select new UserRolePermission
{
UserID = null,
RoleID = r.RoleID,
RoleName = r.RoleName,
PermissionID = p.PermissionID,
PermissionName = p.PermissionName,
URL = p.URL
}).ToList <UserRolePermission>();
return(result);
}
}
public RegWindow(AuthorizationEntities authorizationEntities, User user)
{
InitializeComponent();
this.authorizationEntities = authorizationEntities;
this.DataContext = user;
}
