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