public static int UpdateGroupRole(int RoleId, GroupRolesModel groupRole)
=> Update(GroupRolesTable.TableName, new ParamtersMap
{
[GroupRolesTable.GrolrGIdFk] = groupRole.GrolrGIdFk,
[GroupRolesTable.GrolrRoleIdFk] = groupRole.GrolrRoleIdFk,
[GroupRolesTable.GroleAdd] = groupRole.GroleAdd,
[GroupRolesTable.GroleEdit] = groupRole.GroleEdit,
[GroupRolesTable.GroleDelete] = groupRole.GroleDelete,
[GroupRolesTable.GrolePrint] = groupRole.GrolePrint,
[GroupRolesTable.GroleView] = groupRole.GroleView,
[GroupRolesTable.GroleExport] = groupRole.GroleExport
}, $"{GroupRolesTable.GrolrRoleIdFk}={RoleId}");
public static RolesModel FillRoles(this RolesModel role, GroupRolesModel groupRoles)
=> new RolesModel()
{
RoleId = role.RoleId,
Description = role.Description,
RoleName = role.RoleName,
GroleAdd = groupRoles.GroleAdd,
GroleEdit = groupRoles.GroleEdit,
GroleDelete = groupRoles.GroleDelete,
GroleView = groupRoles.GroleView,
GrolePrint = groupRoles.GrolePrint,
GroleExport = groupRoles.GroleExport
};
public static int InsertGroupeRole(out long insertId, GroupRolesModel groupRole)
{
var changedCount = Insert(out insertId, GroupRolesTable.TableName, new ParamtersMap
{
[GroupRolesTable.GrolrGIdFk] = groupRole.GrolrGIdFk,
[GroupRolesTable.GrolrRoleIdFk] = groupRole.GrolrRoleIdFk,
[GroupRolesTable.GroleAdd] = groupRole.GroleAdd,
[GroupRolesTable.GroleEdit] = groupRole.GroleEdit,
[GroupRolesTable.GroleDelete] = groupRole.GroleDelete,
[GroupRolesTable.GrolePrint] = groupRole.GrolePrint,
[GroupRolesTable.GroleView] = groupRole.GroleView,
[GroupRolesTable.GroleExport] = groupRole.GroleExport
});
return(changedCount);
}
public void Add(Window window)
{
IsInProgress = true;
new Thread(() =>
{
if (GroupName == null)
{
MessageBox.Show("Group Name Cant be Empty !!", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
return;
}
if (GroupDescription == null)
{
GroupDescription = "";
}
AddedGroup = new GroupsModel()
{
GName = GroupName,
GDescription = GroupDescription
};
var groupChangeValue = 0;
var groupInsertId = default(long);
try
{
groupChangeValue = DataAccess.InsertGroup(out groupInsertId, AddedGroup);
AddedGroup.GId = (int)groupInsertId;
}
catch { MessageBox.Show("could not open connection with server!\nCheck your internet connection or server is connected", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); }
if (groupChangeValue == 1)
{
foreach (var item in DataGridSource)
{
if (item.RoleSelected())
{
var groupRole = new GroupRolesModel()
{
GrolrRoleIdFk = item.RoleId,
GrolrGIdFk = (int)groupInsertId,
GroleAdd = item.GroleAdd,
GroleEdit = item.GroleEdit,
GroleDelete = item.GroleDelete,
GroleView = item.GroleView,
GrolePrint = item.GrolePrint,
GroleExport = item.GroleExport
};
try { DataAccess.InsertGroupeRole(out var id, groupRole); }
catch { MessageBox.Show($"some thing went wrong!\nFild to add {{{item.RoleName}}} to {{{AddedGroup.GName}}}", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning); }
AddedGroupRoles.Add(groupRole);
}
}
IsInProgress = true;
App.Current.Dispatcher.Invoke((Action) delegate
{
window.DialogResult = true;
window.Close();
});
}
else
{
MessageBox.Show("Field to add Group !!", "Warning", MessageBoxButton.OK, MessageBoxImage.Warning);
}
})
{
IsBackground = true
}.Start();
