public static int Insert(tblUserGroupPermission userGroupPermission)
{
var db = new dbEcustomEntities(Common.Decrypt(ConfigurationManager.ConnectionStrings["dbEcustomEntities"].ConnectionString, true));
db.AddTotblUserGroupPermissions(userGroupPermission);
int re = db.SaveChanges();
db.Connection.Close();
return re;
}
private void btnUpdatePermission_Click_1(object sender, EventArgs e)
{
//check is user exist
tblUser user = UserFactory.GetByID(_userID);
if (user == null)
{
MessageBox.Show("Người dùng này không còn tại tại trong hệ thống nữa, xin kiểm tra lại");
return;
}
//delete all old permissions
UserGroupPermissionFactory.DeleteUserGroupPermissionByUserID(_userID);
//add new permissions
try
{
List<tblUserGroupPermission> listUserGroupPermission = new List<tblUserGroupPermission>();
foreach (int permissionID in listCheckPermission)
{
tblUserGroupPermission userGroupPermission = new tblUserGroupPermission();
userGroupPermission.UserID = _userID;
userGroupPermission.PermissionID = permissionID;
userGroupPermission.PermissionType = UserGroupPermissionFactory.PERMISSION_TYPE_USER;
userGroupPermission.CreatedBy = _userInfo.UserID;
userGroupPermission.ModifiedBy = _userInfo.UserID;
userGroupPermission.CreatedDate = CommonFactory.GetCurrentDate();
userGroupPermission.ModifiedDate = CommonFactory.GetCurrentDate();
//add to listUserGroupPermission
listUserGroupPermission.Add(userGroupPermission);
}
//save listUserGroupPermission to database
UserGroupPermissionFactory.Insert(listUserGroupPermission);
}
catch (Exception)
{
MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_FAIL);
return;
}
MessageBox.Show(ConstantInfo.MESSAGE_ADD_USER_IN_GROUP_SUCESSFULLY);
}
