private void btnDeletUser_Click(object sender, RoutedEventArgs e) { try { if (UserId != 0) { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); if (MessageBox.Show("هل تريد حذف العنصر المحدد؟", "حذف", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { var user = PharmaLinq.Users.Single(item => item.ID_User == UserId); user.Exist = false; PharmaLinq.SubmitChanges(); MessageBox.Show("تم الحذف"); Dt = flag.Fill_DataGrid_join("SELECT * FROM [dbo].[Users] where Exist = 'true'"); dgUsers.DataContext = Dt; USC.USC_USERS frm = new USC_USERS(); MainWindow.GetMainForm.GridUsc.Children.Clear(); MainWindow.GetMainForm.GridUsc.Children.Add(frm); } } else { MessageBox.Show("الرجاء اختيار عنصر"); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void btnEditUser_Click(object sender, RoutedEventArgs e) { try { if (UserId != 0) { if (MessageBox.Show("هل تريد تعديل العنصر المحدد؟", "تعديل", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); var user = PharmaLinq.Users.Single(item => item.ID_User == UserId); user.User_Name = txtUserName.Text; user.User_Psw = txtUserPassWard.Text; user.Exist = true; user.SalePermissions = (bool)chbSaleScreen.IsChecked; user.BuyPermissions = (bool)chbBuyScreen.IsChecked; user.ProductsPermissions = (bool)chbProductsMange.IsChecked; user.ReportsPermissions = (bool)chbReportsMange.IsChecked; user.UsersPermissions = (bool)chbUsersMange.IsChecked; user.SettingPermissions = (bool)chbSetting.IsChecked; user.StoragePermissions = (bool)chbStorage.IsChecked; PharmaLinq.SubmitChanges(); MessageBox.Show("تم التعديل"); var Dt = PharmaLinq.Users.Where(item => item.Exist == true); flag.Fill_DataGrid(dgUsers, Dt); USC.USC_USERS frm = new USC_USERS(); MainWindow.GetMainForm.GridUsc.Children.Clear(); MainWindow.GetMainForm.GridUsc.Children.Add(frm); } } else { MessageBox.Show("الرجاء اختيار عنصر"); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void btnSaveUser_Click(object sender, RoutedEventArgs e) { try { if (flag.Null_Checker(txtUserName) || flag.Null_Checker(txtUserPassWard)) { return; } PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Linq.User user = new Linq.User(); user.User_Name = txtUserName.Text; user.User_Psw = txtUserPassWard.Text; user.Exist = true; user.SalePermissions = (bool)chbSaleScreen.IsChecked; user.BuyPermissions = (bool)chbBuyScreen.IsChecked; user.ProductsPermissions = (bool)chbProductsMange.IsChecked; user.ReportsPermissions = (bool)chbReportsMange.IsChecked; user.UsersPermissions = (bool)chbUsersMange.IsChecked; user.SettingPermissions = (bool)chbSetting.IsChecked; user.StoragePermissions = (bool)chbStorage.IsChecked; PharmaLinq.Users.InsertOnSubmit(user); PharmaLinq.SubmitChanges(); MessageBox.Show("تم الحفظ"); Dt = flag.Fill_DataGrid_join("SELECT * FROM [dbo].[Users] where Exist = 'true'"); dgUsers.DataContext = Dt; USC.USC_USERS frm = new USC_USERS(); MainWindow.GetMainForm.GridUsc.Children.Clear(); MainWindow.GetMainForm.GridUsc.Children.Add(frm); } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void ListViewItem_Selected_1(object sender, RoutedEventArgs e) { USC.USC_USERS Users = new USC.USC_USERS(); GridUsc.Children.Clear(); GridUsc.Children.Add(Users); }