private void btnDeletGroup_Click(object sender, RoutedEventArgs e) { try { if (IDGroup != 0) { if (MessageBox.Show("هل تريد حذف العنصر المحدد؟", "حذف", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Linq.Group group = PharmaLinq.Groups.Single(item => item.ID_Groups == IDGroup); group.Exist = false; PharmaLinq.SubmitChanges(); MessageBox.Show("تم الحذف"); USC.USC_GROUPS_MANGE frm = new USC_GROUPS_MANGE(); 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 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 btnDeletProduct_Click(object sender, RoutedEventArgs e) { try { if (IDProduct != 0) { if (MessageBox.Show("هل تريد حذف العنصر المحدد؟", "حذف", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); var temp = PharmaLinq.Products.Single(item => item.ID_Product == IDProduct); temp.Exist = false; PharmaLinq.SubmitChanges(); MessageBox.Show("تم الحذف"); UserControl_Loaded(sender, e); Initil(); IDProduct = 0; } } else { MessageBox.Show("الرجاء اختيار عنصر"); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
//selection private void txtBuyID_TextChanged(object sender, TextChangedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); btnSaveBuy.IsEnabled = true; if (txtBuyID.Text != (PharmaLinq.Buys.Where(item => item.Exist == true).Max(item => item.ID_Buy) + 1).ToString()) { Linq.Buy buy = PharmaLinq.Buys.Single(item => item.Exist == true && item.ID_Buy == Convert.ToInt32(txtBuyID.Text)); txtBarcode.IsEnabled = true; txtBarcode.Clear(); txtBuyDate.SelectedDate = buy.DateBuy; txtUser.Text = PharmaLinq.Users.Single(item => item.Exist == true && item.ID_User == IDUser).User_Name; buyCost = Convert.ToDouble(buy.BuyCost); txtbBuyCost.Text = buyCost.ToString(); DelDt.Clear(); Dt.Clear(); Dt = flag.Fill_DataGrid_join("SELECT [ID_Buy],BuysAction.ID_Product,Products.Name,Products.BarCode,[BuysAction].Cost,[Quantit_BuysAction],[BuysAction].EX_Date,[totatCost],ID_BuyAction FROM [dbo].[BuysAction] inner join Products on Products.ID_Product=BuysAction.ID_Product where BuysAction.Exist ='true' And ID_Buy = '" + txtBuyID.Text + "'"); dgBill.DataContext = Dt; dtcount = Dt.Rows.Count; } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void btnNewBuy_Click(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); isnew = true; txtBarcode.IsEnabled = true; txtBarcode.Clear(); txtBarcode.Focus(); txtBuyDate.SelectedDate = DateTime.Now; txtUser.Text = PharmaLinq.Users.Single(item => item.Exist == true && item.ID_User == IDUser).User_Name; buyCost = 0; txtbBuyCost.Text = "0"; try { txtBuyID.Text = Convert.ToString(PharmaLinq.Buys.Where(item => item.Exist == true).Max(item => item.ID_Buy) + 1); } catch (InvalidOperationException ex) { txtBuyID.Text = "1"; } Dt.Clear(); btnEditProduct.IsEnabled = false; btnDeletProduct.IsEnabled = false; } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void btnSaveGroup_Click(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Linq.Group group = new Linq.Group(); group.Exist = true; group.GroupName = txtNameGroup.Text; group.ID_User = IDUser; PharmaLinq.Groups.InsertOnSubmit(group); PharmaLinq.SubmitChanges(); MessageBox.Show("تم الحفظ"); btnNewGroup.IsEnabled = true; btnEditGroup.IsEnabled = true; btnDeletGroup.IsEnabled = true; btnSaveGroup.IsEnabled = false; USC.USC_GROUPS_MANGE frm = new USC_GROUPS_MANGE(); MainWindow.GetMainForm.GridUsc.Children.Clear(); MainWindow.GetMainForm.GridUsc.Children.Add(frm); } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
//textSalePrecentage private void txtSalePrecentage_TextChanged(object sender, TextChangedEventArgs e) { try { try { Convert.ToSingle(txtSalePrecentage.Text); } catch (FormatException ex) { MessageBox.Show("يجب ملء هذا العنصر برقم "); txtSalePrecentage.Focus(); txtSalePrecentage.Text = "0"; txtSalePrecentage.SelectAll(); goto end; } if (dgSale.SelectedIndex != -1) { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); var product = PharmaLinq.Products.Single(item => item.ID_Product == Convert.ToInt32(Dt.Rows[dgSale.SelectedIndex].ItemArray[0])); double price = 0; if (cmbUnit.Text == "قطعة") { price = product.Price; } else { price = (double)product.Unit_Price; } if (txtSalePrecentage.Text == "") { txtSalePrecentage.Text = "0"; } else if (Convert.ToSingle(txtSalePrecentage.Text) <= price * Convert.ToSingle(Dt.Rows[dgSale.SelectedIndex].ItemArray[4])) { total = Precentage(Convert.ToDouble(Dt.Rows[dgSale.SelectedIndex].ItemArray[2])); txtSalePrice.Text = salePrice.ToString(); object[] temp = { Dt.Rows[dgSale.SelectedIndex].ItemArray[0], Dt.Rows[dgSale.SelectedIndex].ItemArray[1], Dt.Rows[dgSale.SelectedIndex].ItemArray[2], Dt.Rows[dgSale.SelectedIndex].ItemArray[3], Dt.Rows[dgSale.SelectedIndex].ItemArray[4], Dt.Rows[dgSale.SelectedIndex].ItemArray[5], Convert.ToSingle(txtSalePrecentage.Text), total }; flag.Edit_Dt(Dt, dgSale.SelectedIndex, temp); } else { txtSalePrecentage.Text = (price * Convert.ToSingle(Dt.Rows[dgSale.SelectedIndex].ItemArray[4])).ToString(); salePrice = Math.Round(salePrice - Convert.ToDouble(Dt.Rows[dgSale.SelectedIndex].ItemArray[7]), 2); } } end :; } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
//textSalePrecentage //textQuantity private void txtQuantity_TextChanged(object sender, TextChangedEventArgs e) { try { if (dgSale.SelectedIndex != -1) { try { Convert.ToInt32(txtQuantity.Text); } catch (FormatException ex) { MessageBox.Show("يجب ملء هذا العنصر برقم صحيح"); txtQuantity.Focus(); txtQuantity.Text = "0"; txtQuantity.SelectAll(); goto end; } PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); var product = PharmaLinq.Products.Single(item => item.ID_Product == Convert.ToInt32(Dt.Rows[dgSale.SelectedIndex].ItemArray[0])); Quantity_Checker(product, Dt.Rows[dgSale.SelectedIndex].ItemArray[3].ToString()); total = Precentage(Convert.ToDouble(Dt.Rows[dgSale.SelectedIndex].ItemArray[2])); txtSalePrice.Text = salePrice.ToString(); object[] temp = { Dt.Rows[dgSale.SelectedIndex].ItemArray[0], Dt.Rows[dgSale.SelectedIndex].ItemArray[1], Dt.Rows[dgSale.SelectedIndex].ItemArray[2], Dt.Rows[dgSale.SelectedIndex].ItemArray[3], txtQuantity.Text, Dt.Rows[dgSale.SelectedIndex].ItemArray[5], Dt.Rows[dgSale.SelectedIndex].ItemArray[6], total }; flag.Edit_Dt(Dt, dgSale.SelectedIndex, temp); } else if (txtQuantity.Text == "0" || txtQuantity.Text == "") { txtQuantity.Text = ""; } else { MessageBox.Show("يجب تحديد منتج من القائمة"); } end :; } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void txtSearchProduct_TextChanged(object sender, TextChangedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); txtBuyID.Text = PharmaLinq.Buys.Single(item => item.Exist == true && item.ID_Buy == Convert.ToInt32(txtSearchBill.Text)).ID_Buy.ToString(); isnew = false; } catch (Exception ex) { flag.Con.Close(); } }
private void btnEditCustomer_Click(object sender, RoutedEventArgs e) { try { if (CustomerID != 0) { if (MessageBox.Show("هل تريد تعديل العنصر المحدد؟", "تعديل", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Linq.Customer customer = PharmaLinq.Customers.Single(item => item.Exist == true && item.ID_Customer == CustomerID); txtPhoneCustomer.Focus(); txtPhoneCustomer.SelectAll(); try { if (txtPhoneCustomer.Text == "") { } else { customer.CustomerPhone = Convert.ToInt32(txtPhoneCustomer.Text); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show("يجب ملء هذا العنصر برقم صحيح"); return; } customer.CustomerName = txtNameCustomer.Text; customer.Exist = true; MessageBox.Show("تم التعديل"); PharmaLinq.SubmitChanges(); flag.Fill_DataGrid(dgCustomer, PharmaLinq.Customers.Where(item => item.Exist == true)); ReInitialize(); } } else { MessageBox.Show("الرجاء اختيار عنصر"); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void txtSaleID_TextChanged(object sender, TextChangedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); btnSaveSale.IsEnabled = true; btnDeletProduct.IsEnabled = true; btnPrint.IsEnabled = true; if (txtSaleID.Text != (PharmaLinq.Sales.Where(item => item.Exist == true).Max(item => item.ID_Sale) + 1).ToString()) { Linq.Sale sale = PharmaLinq.Sales.Single(item => item.Exist == true && item.ID_Sale == Convert.ToInt32(txtSaleID.Text)); txtBarcode.IsEnabled = true; txtBarcode.Clear(); txtSaleDate.SelectedDate = sale.SaleDate; txtUser.Text = PharmaLinq.Users.Single(item => item.Exist == true && item.ID_User == IDUser).User_Name; salePrice = Math.Round(Convert.ToDouble(sale.SalePrice), 2); txtSalePrice.Text = salePrice.ToString(); Dt.Clear(); QuantityDt.Clear(); DelDt.Clear(); Dt = flag.Fill_DataGrid_join(" SELECT [SalesAction].ID_Product ,Products.Name ,SalesAction.Price ,[Unit] ,[Quantity_SaleAction],Products.EX_Date ,[SalePrecentage] ,[TotalPrice],ID_SaleAction FROM [dbo].[SalesAction] inner join Products on Products.ID_Product=SalesAction.ID_Product where SalesAction.Exist ='true' And ID_Sale = '" + txtSaleID.Text + "'"); for (int i = 0; i < Dt.Rows.Count; i++) { QuantityDt.Rows.Add(Dt.Rows[i].ItemArray[4], Dt.Rows[i].ItemArray[3]); } dgSale.DataContext = Dt; dtcount = Dt.Rows.Count; txtPaid.Text = sale.paid.ToString(); cmbCustomer.Text = PharmaLinq.Customers.SingleOrDefault(item => item.ID_Customer == sale.ID_Customer).CustomerName; for (int i = 0; i < cmbPayType.Items.Count; i++) { cmbPayType.SelectedIndex = i; if (cmbPayType.SelectedValue.ToString() == sale.PayType) { break; } } } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void txtSearchBill_TextChanged(object sender, TextChangedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); txtSaleID.Text = PharmaLinq.Sales.Single(item => item.Exist == true && item.ID_Sale == Convert.ToInt32(txtSearchBill.Text)).ID_Sale.ToString(); isnew = false; txtSalePrecentage.IsEnabled = true; txtPaid.IsEnabled = true; } catch (Exception ex) { flag.Con.Close(); } }
private void btInitializeDefective_Click(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Linq.Store store = PharmaLinq.Stores.SingleOrDefault(item => item.ID_Product == Convert.ToInt32(Dt.Rows[dgProducts.SelectedIndex].ItemArray[0])); store.Defective = 0; PharmaLinq.SubmitChanges(); UserControl_Loaded(sender, e); MessageBox.Show("تم التصفير "); } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void Grid_Loaded(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); flag.Fill_DataGrid(dgCual, PharmaLinq.Caules.Where(item => item.Exist == true)); flag.Fill_DataGrid(dgCustomer, PharmaLinq.Customers.Where(item => item.Exist == true)); flag.Focus_txt(txtNameCual, txtNameCustomer, txtPhoneCual, txtPhoneCustomer); } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void btnSaveCustomer_Click(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Linq.Customer customer = new Linq.Customer(); txtPhoneCustomer.Focus(); txtPhoneCustomer.SelectAll(); try { if (txtPhoneCustomer.Text == "") { } else { customer.CustomerPhone = Convert.ToInt32("0" + txtPhoneCustomer.Text); } } catch (Exception ex) { flag.Con.Close(); txtPhoneCustomer.Focus(); MessageBox.Show("يجب ملء هذا العنصر برقم صحيح"); return; } customer.CustomerName = txtNameCustomer.Text; customer.Exist = true; PharmaLinq.Customers.InsertOnSubmit(customer); PharmaLinq.SubmitChanges(); MessageBox.Show("تم الحفظ"); flag.Fill_DataGrid(dgCustomer, PharmaLinq.Customers.Where(item => item.Exist == true)); ReInitialize(); } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void cmbUnit_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (cmbUnit.SelectedIndex < 0) { goto skip; } PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); var product = PharmaLinq.Products.Single(item => item.ID_Product == Convert.ToInt32(Dt.Rows[dgSale.SelectedIndex].ItemArray[0])); int txt; if (isnewitem) { txt = 0; } else { txt = Convert.ToInt32(txtQuantity.Text); } Quantity_Checker(product, cmbUnit.SelectedValue.ToString()); if (cmbUnit.SelectedValue.ToString() == "قطعة") { total = Precentage(product.Price); } else { total = Precentage((double)product.Unit_Price); } txtSalePrice.Text = salePrice.ToString(); object[] temp = { Dt.Rows[dgSale.SelectedIndex].ItemArray[0], Dt.Rows[dgSale.SelectedIndex].ItemArray[1], cmbUnit.SelectedValue.ToString() == "قطعة"?product.Price:product.Unit_Price, cmbUnit.SelectedValue, Dt.Rows[dgSale.SelectedIndex].ItemArray[4], Dt.Rows[dgSale.SelectedIndex].ItemArray[5], Dt.Rows[dgSale.SelectedIndex].ItemArray[6], total }; flag.Edit_Dt(Dt, dgSale.SelectedIndex, temp); skip :; } 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 btnNewSale_Click(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); isnew = true; txtBarcode.IsEnabled = true; btnDeletProduct.IsEnabled = true; btnPrint.IsEnabled = true; txtBarcode.Clear(); txtQuantity.Text = "0"; txtSalePrecentage.Text = "0"; txtPaid.Text = "0"; txtSaleDate.SelectedDate = DateTime.Now; txttime.Text = DateTime.Now.ToString("hh:mm tt"); txtUser.Text = PharmaLinq.Users.Single(item => item.Exist == true && item.ID_User == IDUser).User_Name; txtSalePrecentage.Text = "0"; salePrice = 0; try { txtSaleID.Text = Convert.ToString(PharmaLinq.Sales.Where(item => item.Exist == true).Max(item => item.ID_Sale) + 1); } catch (InvalidOperationException ex) { txtSaleID.Text = "1"; } Dt.Clear(); // btnEditProduct.IsEnabled = false; btnSaveSale.IsEnabled = true; salePrice = 0; txtSalePrice.Text = "0"; txtBarcode.Focus(); } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
public void txtBarcode_KeyDown(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); var product = PharmaLinq.Products.Single(item => item.Exist == true && item.BarCode == txtBarcode.Text); if (EXDate_Checker(product)) { return; } total = Convert.ToSingle(product.Price) * quantity; txtPaid.IsEnabled = true; txtQuantity.IsEnabled = true; //for (int i = 0; i < Dt.Rows.Count; i++) //{ // if (product.ID_Product == Convert.ToInt32(Dt.Rows[i].ItemArray[0])) // { // txtQuantity.Text = (Convert.ToInt32(txtQuantity.Text) + 1).ToString(); // goto end; // } //} salePrice = Math.Round(salePrice + total, 2); txtSalePrice.Text = salePrice.ToString(); Dt.Rows.Add(product.ID_Product, product.Name, product.Price, "قطعة", quantity, product.EX_Date, "0", Math.Round(total, 2)); dgSale.DataContext = Dt; dgSale.SelectedIndex = dgSale.Items.Count - 1; cmbUnit.SelectedIndex = 0; txtBarcode.Focus(); } catch (Exception ex) { flag.Con.Close(); } }
private void UserControl_Loaded(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Dt = flag.Fill_DataGrid_join("SELECT * FROM [dbo].[Users] where Exist = 'true'"); dgUsers.DataContext = Dt; StackMainDetails.IsEnabled = false; StackPrmDetails.IsEnabled = false; btnSaveUser.IsEnabled = false; flag.Focus_txt(txtSearch, txtUserName, txtUserPassWard); } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Dt = flag.Fill_DataGrid_join("select User_Name from Users where Exist='True'"); for (int i = 0; i < Dt.Rows.Count; i++) { cmbName.Items.Add(Dt.Rows[i].ItemArray[0]); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show("خطاء في التصال بالقاعدة البيانات" + ex.Message); AdminUSC.Admin admin = new AdminUSC.Admin(); admin.Show(); } }
private void txtSearch_TextChanged(object sender, TextChangedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(); if (txtSearch.Text == "") { dgUsers.DataContext = flag.Fill_DataGrid_join("SELECT * FROM [dbo].[Users] where Exist = 'true'"); } else { dgUsers.DataContext = flag.Fill_DataGrid_join("SELECT * FROM [dbo].[Users] where Exist = 'true' and User_Name like '%'+ '" + txtSearch.Text + "' +'%'"); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void btnBack_Click(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); if (txtSearchBill.Text == "") { txtSearchBill.Text = Convert.ToString(PharmaLinq.Buys.Where(item => item.Exist == true).Min(item => item.ID_Buy)); } else if (txtSearchBill.Text == Convert.ToString(PharmaLinq.Buys.Where(item => item.Exist == true).Min(item => item.ID_Buy))) { } else { txtSearchBill.Text = Convert.ToString(Convert.ToInt32(txtSearchBill.Text) - 1); } } catch (Exception ex) { } }
public void txtBarcode_TextChanged(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); txtProductName.Clear(); txtCost.Clear(); txtQuantity.Clear(); txtCost.IsEnabled = false; txtQuantity.IsEnabled = false; txtExDate.IsEnabled = false; txtProductName.Text = PharmaLinq.Products.Single(item => item.Exist == true && item.BarCode == txtBarcode.Text).Name; IDproduct = PharmaLinq.Products.Single(item => item.Exist == true && item.BarCode == txtBarcode.Text).ID_Product; } catch (Exception ex) { flag.Con.Close(); } }
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 dgSale_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { if (dgSale.SelectedIndex != -1) { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); isnewitem = true; string[] Units = { "قطعة", PharmaLinq.Products.Single(item => item.ID_Product == Convert.ToInt32(Dt.Rows[dgSale.SelectedIndex].ItemArray[0])).Units }; cmbUnit.ItemsSource = Units; txtQuantity.IsEnabled = true; txtQuantity.Text = Dt.Rows[dgSale.SelectedIndex].ItemArray[4].ToString(); txtQuantity.Focus(); txtSalePrecentage.IsEnabled = true; txtSalePrecentage.Text = Dt.Rows[dgSale.SelectedIndex].ItemArray[6].ToString(); if (Convert.ToString(Dt.Rows[dgSale.SelectedIndex].ItemArray[3]) == "قطعة") { cmbUnit.SelectedIndex = 0; } else { cmbUnit.SelectedIndex = 1; } txtBarcode.Clear(); isnewitem = false; } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
public USC_SELECT_PRODUCT() { try { InitializeComponent(); PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Dt = flag.Fill_DataGrid_join("select GroupName from Groups where Exist = 'true'"); Button[] btn1 = new Button[Dt.Rows.Count]; btn1 = flag.Add_Button(Dt, wrp); for (int i = 0; i < Dt.Rows.Count; i++) { btn1[i].Click += new System.Windows.RoutedEventHandler(this.b_Click); } wrpProduct.Visibility = Visibility.Collapsed; } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void btnDeletCustomer_Click(object sender, RoutedEventArgs e) { try { if (dgCustomer.SelectedIndex == 0) { MessageBox.Show("لايمكن حذف هذا العنصر"); return; } if (CustomerID != 0) { if (MessageBox.Show("هل تريد حذف العنصر المحدد؟", "حذف", MessageBoxButton.YesNo) == MessageBoxResult.Yes) { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); Linq.Customer customer = PharmaLinq.Customers.Single(item => item.Exist == true && item.ID_Customer == CustomerID); customer.Exist = false; PharmaLinq.SubmitChanges(); MessageBox.Show("تم الحذف"); flag.Fill_DataGrid(dgCustomer, PharmaLinq.Customers.Where(item => item.Exist == true)); txtNameCustomer.Clear(); txtPhoneCustomer.Clear(); } } else { MessageBox.Show("الرجاء اختيار عنصر"); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void btnNext_Click(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); if (txtSearchBill.Text == "") { txtSearchBill.Text = Convert.ToString(PharmaLinq.Buys.Where(item => item.Exist == true).Max(item => item.ID_Buy)); } else if (txtSearchBill.Text == Convert.ToString(PharmaLinq.Buys.Where(item => item.Exist == true).Max(item => item.ID_Buy))) { } else { txtSearchBill.Text = Convert.ToString(Convert.ToInt32(txtSearchBill.Text) + 1); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }
private void btnLogin_Click(object sender, RoutedEventArgs e) { try { PharmaLinq = new Linq.PharmaLinqDataContext(flag.Con); var Temp = PharmaLinq.Users.Where(item => item.User_Name == cmbName.Text && item.User_Psw == txtPassWard.Password && item.Exist == true); if (Temp.Count() > 0) { var user = Temp.First(); MainWindow frm = new MainWindow(); frm.IDUSER_main = user.ID_User; Close(); frm.btnSaleScreen.IsEnabled = user.SalePermissions; frm.btnBuyScreen.IsEnabled = user.BuyPermissions; frm.btnProductsMange.IsEnabled = frm.btnGroupsMange.IsEnabled = frm.btnCauleMange.IsEnabled = user.ProductsPermissions; frm.btnReportsMange.IsEnabled = user.ReportsPermissions; frm.btnUsersMange.IsEnabled = user.UsersPermissions; frm.btnSettingScreen.IsEnabled = user.SettingPermissions; frm.btnStoreMange.IsEnabled = user.StoragePermissions; frm.ShowDialog(); } else { MessageBox.Show("اسم المستخدم او كلمة المرور غير صحيحة"); txtPassWard.Clear(); txtPassWard.Focus(); } } catch (Exception ex) { flag.Con.Close(); MessageBox.Show(ex.Message); } }