/// <summary>
/// Добавление пользователю группы по USER_ID пользователя
/// и по ACCESSGROUP_ID группы
/// </summary>
/// <param name="user_id"></param>
/// <param name="accessgroup_id"></param>
/// <returns></returns>
public void AddUserInAccessGroup(Int64 user_id, Int64 accessgroup_id)
{
using (SecurityDBEntities db = new SecurityDBEntities())
{
UsersInAccessGroups userinaccessgroup = new UsersInAccessGroups();
userinaccessgroup.USER_ID = user_id;
userinaccessgroup.ACCESSGROUP_ID = accessgroup_id;
db.AddToUsersInAccessGroups(userinaccessgroup);
db.SaveChanges();
}
}
/// <summary>
/// Добавление пользователю группы по логину пользователя
/// и по ACCESSGROUP_ID группы
/// </summary>
/// <param name="user_login"></param>
/// <param name="accessgroup_id"></param>
/// <returns></returns>
public void AddUserInAccessGroup(String user_login, Int64 accessgroup_id)
{
using (SecurityDBEntities db = new SecurityDBEntities())
{
long user_id = (from u in db.Users where (u.LOGIN == user_login) select u.USER_ID).First();
UsersInAccessGroups userinaccessgroup = new UsersInAccessGroups();
userinaccessgroup.USER_ID = user_id;
userinaccessgroup.ACCESSGROUP_ID = accessgroup_id;
db.AddToUsersInAccessGroups(userinaccessgroup);
db.SaveChanges();
}
}
protected void AddAccessGroupButton_Click(object sender, EventArgs e)
{
using (SecurityDBEntities db = new SecurityDBEntities())
{
AccessGroups newAccessGroup = new AccessGroups();
newAccessGroup.NAME = AccessGroupNameTextBox.Text;
newAccessGroup.LABEL = AccessGroupLabelTextBox.Text;
newAccessGroup.DESCRIPTION = AccessGroupDescriptionTextBox.Text;
db.AddToAccessGroups(newAccessGroup);
db.SaveChanges();
}
AccessGroupsGridView.DataBind();
}
/// <summary>
/// Удаление у пользователю группы.
/// </summary>
/// <param name="uiag_id"></param>
/// <returns></returns>
public bool RemoveUserInAccessGroup(Int64 uiag_id)
{
try
{
using (SecurityDBEntities db = new SecurityDBEntities())
{
UsersInAccessGroups deluaig = (from a in db.UsersInAccessGroups where (a.UIAG_ID == uiag_id) select a).First();
db.UsersInAccessGroups.DeleteObject(deluaig);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false); // Ошибка пои удалении
}
}
/// <summary>
/// Удаление пользователя по USER_ID
/// </summary>
/// <param name="user_id"></param>
/// <returns></returns>
public bool DeleteUser(Int64 user_id)
{
try
{
using (SecurityDBEntities db = new SecurityDBEntities())
{
Users del_user = (from a in db.Users where (a.USER_ID == user_id) select a).First();
db.Users.DeleteObject(del_user);
db.SaveChanges();
return(true);
}
}
catch (Exception ex)
{
return(false); // Ошибка при удалении
}
}
public MembershipUser CreateUser(string first_name, string last_name, string username, string password, string email)
{
using (SecurityDBEntities db = new SecurityDBEntities())
{
Users user = new Users();
user.LOGIN = username;
user.FIRST_NAME = first_name;
user.LAST_NAME = last_name;
user.EMAIL = email;
user.PASSWORD_SALT = CreateSalt();
user.PASSWORD = CreatePasswordHash(password, user.PASSWORD_SALT);
user.CREATE_DATE = DateTime.Now;
user.IS_ACTIVATED = false;
user.IS_LOCKED_OUT = false;
user.LAST_LOCKED_OUT_DATE = DateTime.Now;
user.LAST_LOGIN_DATE = DateTime.Now;
db.AddToUsers(user);
db.SaveChanges();
return(GetUser(username));
}
}
public void Create(T objRecord)
{
entities.Add(objRecord);
context.SaveChanges();
}
