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();