public static int Insert(tblUserGroupPermission userGroupPermission)
{
var db = new dbTrainEntities(ConnectionController.GetConnection());
db.AddTotblUserGroupPermissions(userGroupPermission);
int re = db.SaveChanges();
db.Connection.Close();
return(re);
}
private void btnUpdatePermission_Click(object sender, EventArgs e)
{
var confirm = MessageBox.Show(ConstantInfo.CONFIRM_UPDATE, "Confirm", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (confirm != DialogResult.Yes)
{
return;
}
//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 (DataGridViewRow dr in grvPermission.Rows)
{
if (dr.Cells[0].Value + "" == "True")
{
int permissionID = (int)dr.Cells[1].Value;
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);
}
private void btnUpdatePermission_Click(object sender, EventArgs e)
{
//check is group exist
tblGroup group = GroupFactory.getGroupByID(_groupID);
if (group == null)
{
MessageBox.Show("Nhóm 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.DeleteUserGroupPermissionByGroupID(_groupID);
//add new permissions
try
{
List <tblUserGroupPermission> listUserGroupPermission = new List <tblUserGroupPermission>();
foreach (DataGridViewRow dr in grvPermission.Rows)
{
if (dr.Cells[0].Value + "" == "True")
{
int permissionID = (int)dr.Cells[1].Value;
tblUserGroupPermission userGroupPermission = new tblUserGroupPermission();
userGroupPermission.GroupID = _groupID;
userGroupPermission.PermissionID = permissionID;
userGroupPermission.PermissionType = UserGroupPermissionFactory.PERMISSION_TYPE_GROUP;
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);
}
public static tblUserGroupPermission CreatetblUserGroupPermission(int id, string branchId)
{
tblUserGroupPermission tblUserGroupPermission = new tblUserGroupPermission();
tblUserGroupPermission.ID = id;
tblUserGroupPermission.BranchId = branchId;
return tblUserGroupPermission;
}
public void AddTotblUserGroupPermissions(tblUserGroupPermission tblUserGroupPermission)
{
AddObject("tblUserGroupPermissions", tblUserGroupPermission);
}
