private void fd_aply_btn_Click(object sender, RoutedEventArgs e) { List <order_details> lstp = db1.order_details.ToList(); order_details_dtgrid.ItemsSource = lstp; order_details_dtgrid.Columns[0].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[4].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[5].Visibility = Visibility.Collapsed; string nm = food_cmbbx.Text; string qnty = qnty_txb.Text; order_details details_order = new order_details(); if (supplier_name_txb.Text != "") { supplier_name_lbl.Foreground = Brushes.Black; if (nm != "" && qnty_txb.Text != "") { qnty_lbl.Foreground = Brushes.Black; food_lbl.Foreground = Brushes.Black; List <products> lst_p = db1.products.ToList(); foreach (products prod in lst_p) { if (prod.name == nm) { details_order.products_id = prod.Id; details_order.products = prod; break; } } int qn = Convert.ToInt32(qnty_txb.Text); string quantity = details_order.products.pack.ToString(); if (quantity == "8 units") { qn *= 8; } else if (quantity == "crates of 30") { qn *= 30; } else if (quantity == "4 units") { qn *= 4; } else { qn *= 1; } details_order.details = notes_txb.Text; details_order.quantity = qn; db1.order_details.Add(details_order); db1.SaveChanges(); order_details_dtgrid.ItemsSource = db1.order_details.ToList(); order_details_dtgrid.Columns[0].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[4].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[5].Visibility = Visibility.Collapsed; food_cmbbx.SelectedIndex = -1; qnty_txb.Clear(); qnty_lbl.Content = "Quantity:"; qnty_lbl.Foreground = Brushes.Black; supplier_name_lbl.Foreground = Brushes.Black; qnty_lbl.Visibility = Visibility.Collapsed; qnty_txb.Visibility = Visibility.Collapsed; notes_txb.Text = ""; } else { if (nm != "") { qnty_lbl.Foreground = Brushes.Red; food_lbl.Foreground = Brushes.Black; } else { food_lbl.Foreground = Brushes.Red; } } } else { supplier_name_lbl.Foreground = Brushes.Red; if (nm == "") { food_lbl.Foreground = Brushes.Red; } else { food_lbl.Foreground = Brushes.Black; } if (qnty == "") { qnty_lbl.Foreground = Brushes.Red; } else { qnty_lbl.Foreground = Brushes.Black; } } }
private void fd_aply_btn_Click(object sender, RoutedEventArgs e) { List <products> lstp = db1.products.ToList(); order_dtgrid.ItemsSource = lstp; string nm = food_cmbbx.Text; int qn = qnty_cmbbx.SelectedIndex + 1; int prc = 0; if (nm != "") { if (nm == "Pizza") { if (dgh_type_cmbbx.Text != "" && size_cmbbx.Text != "") { string size = size_cmbbx.Text; size = nm + " " + size; List <list_product> lst_p = db1.list_product.ToList(); foreach (list_product lp in lst_p) { if (lp.name == size) { prc = lp.price; break; } } products products = new products { name = size, price = prc, quantity = qn, details = dgh_type_cmbbx.Text }; Pizza pz = new Pizza(qn, db1, order_dtgrid); db1.products.Add(products); db1.SaveChanges(); pz.ShowDialog(); order_dtgrid.ItemsSource = db1.products.ToList(); ////order_dtgrid.Columns[5].Visibility = Visibility.Collapsed; } } else { List <list_product> lst_p = db1.list_product.ToList(); foreach (list_product lp in lst_p) { if (lp.name == nm) { prc = lp.price; break; } } products p = new products { name = nm, quantity = qn, price = prc }; db1.products.Add(p); db1.SaveChanges(); order_dtgrid.ItemsSource = db1.products.ToList(); ////order_dtgrid.Columns[5].Visibility = Visibility.Collapsed; } } dgh_type_cmbbx.Visibility = Visibility.Hidden; dgh_type_cmbbx.SelectedIndex = -1; size_cmbbx.Visibility = Visibility.Hidden; size_cmbbx.SelectedIndex = -1; size_lbl.Visibility = Visibility.Hidden; dgh_type_lbl.Visibility = Visibility.Hidden; food_cmbbx.SelectedIndex = -1; qnty_cmbbx.SelectedIndex = 0; }
private void sbmt_btn_Click(object sender, RoutedEventArgs e) { if (emp != null) { if (yes_lsb.IsSelected == true) { emp.deleted = "not exist"; emp.is_working_now = "not at shift"; db1.SaveChanges(); this.Close(); } else { emp.deleted = "exist"; int slryphour; string gndr; if (num_id_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter the id"); } else if (f_name_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter your first name"); } else if (l_name_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter your last name"); } else if (phne_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter the phone"); } else if (slph_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter the salary per hour"); } else if (city_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter the city"); } else if (p_code_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter your postal code"); } else if (strt_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter the street"); } else if (house_num_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter the house number"); } else if (female_rdb.IsChecked == false && male_rdb.IsChecked == false) { msg_lsb.Items.Add("Failure Enter the gender"); } else if (emp_cmbbx.SelectedItem == null) { msg_lsb.Items.Add("Failure! Select the Type"); } else { if (male_rdb.IsChecked == true) { gndr = "male"; } else { gndr = "female"; } slryphour = Convert.ToInt32(slph_txb.Text); emp.id_number = num_id_txb.Text; emp.first_name = f_name_txb.Text; emp.last_name = l_name_txb.Text; emp.phone = phne_txb.Text; emp.gender = gndr; postal_code postal_Code = new postal_code { postal_c = Convert.ToInt32(p_code_txb.Text), city = city_txb.Text, street = strt_txb.Text, house_number = Convert.ToInt32(house_num_txb.Text) }; if (Checking_postal_code(postal_Code)) { List <postal_code> pc = db1.postal_code.ToList(); foreach (postal_code p in pc) { if (p.postal_c == postal_Code.postal_c) { emp.postal_code_postal_c = p.postal_c; emp.postal_code = p; } } } else { db1.postal_code.Add(postal_Code); emp.postal_code = postal_Code; emp.postal_code_postal_c = Convert.ToInt32(p_code_txb.Text); } if (slryphour != emp.employee_type.salary_per_hour) { employee_type emp_t = new employee_type { type = emp_cmbbx.Text, salary_per_hour = slryphour }; if (Checking_emp_t(emp_t)) { List <employee_type> l_ept = db1.employee_type.ToList(); foreach (employee_type ept in l_ept) { if (ept.salary_per_hour == emp_t.salary_per_hour && ept.type == emp_t.type) { emp.employee_type_id = ept.Id; emp.employee_type = ept; } } } else { db1.employee_type.Add(emp_t); db1.SaveChanges(); emp.employee_type_id = emp_t.Id; emp.employee_type = emp_t; db1.SaveChanges(); } } else { emp.employee_type = db1.employee_type.ToArray()[emp_cmbbx.SelectedIndex]; emp.employee_type_id = emp_cmbbx.SelectedIndex + 1; } if (emp.postal_code_postal_c != Convert.ToInt32(p_code_txb.Text)) { emp.postal_code_postal_c = Convert.ToInt32(p_code_txb.Text); } try { this.db1.SaveChanges(); this.Close(); } catch { MessageBox.Show("Failure! the number id of the worker is already existent in the system", "Error", MessageBoxButton.OK, MessageBoxImage.Warning); } } } } else { msg_lsb.Items.Add("Failure! Select the worker"); } }
private void Window_Loaded(object sender, RoutedEventArgs e) { if (flg) { int sp = 0; supplier_name_lbl.Content += ordr.company_name; notes_lbl.Content += ordr.notes; order_details_dtgrid.ItemsSource = db1.order_details.ToList(); order_details_dtgrid.Columns[0].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[4].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[5].Visibility = Visibility.Collapsed; List <order_details> lstp = db1.order_details.ToList(); foreach (order_details p in lstp) { sp += Convert.ToInt32(p.products.price / 1.5 * p.quantity); } discount = CalculatingDiscount(sp); int f_price = sp - (sp * discount) / 100; payment_name_lbl.Content += f_price.ToString() + "₪"; dscnt_lbl.Content += discount.ToString() + "%"; final_price fp = new final_price { s_price = sp, f_price = f_price }; ordr.final_price = db1.final_price.Add(fp); ordr.final_price_s_price = sp; db1.order.Add(ordr); db1.SaveChanges(); object row = new object(); for (int i = 0; i < db1.final_price.ToList().Count; i++) { row = db1.final_price.ToArray()[i]; } List <object> lstrow = new List <object> { row }; fprice_dtgrid.ItemsSource = lstrow; fprice_dtgrid.Columns[0].Visibility = Visibility.Collapsed; fprice_dtgrid.Columns[3].Visibility = Visibility.Collapsed; flg = false; List <products> lst_products = db1.products.ToList(); List <order_details> lst_order_details = db1.order_details.ToList(); List <products> lst_real_products = new List <products>(); foreach (order_details ord in lst_order_details) { foreach (products product in lst_products) { if (ord.products_id == product.Id) { lst_real_products.Add(product); break; } } } products_dtgrid.ItemsSource = lst_real_products; products_dtgrid.Columns[3].Visibility = Visibility.Collapsed; products_dtgrid.Columns[4].Visibility = Visibility.Collapsed; products_dtgrid.Columns[5].Visibility = Visibility.Collapsed; products_dtgrid.Columns[6].Visibility = Visibility.Collapsed; products_dtgrid.Columns[7].Visibility = Visibility.Collapsed; products_dtgrid.Columns[8].Visibility = Visibility.Collapsed; } }
private void fd_aply_btn_Click(object sender, RoutedEventArgs e) { List <order_details> lstp = db1.order_details.ToList(); order_details_dtgrid.ItemsSource = lstp; order_details_dtgrid.Columns[0].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[4].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[5].Visibility = Visibility.Collapsed; string nm = food_cmbbx.Text; if (nm != "" && qnty_txb.Text != "") { qnty_lbl.Foreground = Brushes.Black; food_lbl.Foreground = Brushes.Black; int qn = Convert.ToInt32(qnty_txb.Text); order_details details_order = new order_details(); if (nm.Contains("Pizza")) { if (dgh_type_cmbbx.Text != "") { List <products> lst_p = db1.products.ToList(); foreach (products prod in lst_p) { if (prod.name == nm) { details_order.products_id = prod.Id; details_order.products = prod; break; } } details_order.quantity = qn; details_order.details = dgh_type_cmbbx.Text + ", " + notes_txb.Text; db1.order_details.Add(details_order); db1.SaveChanges(); Pizza pz = new Pizza(qn, db1, order_details_dtgrid); pz.ShowDialog(); order_details_dtgrid.ItemsSource = db1.order_details.ToList(); order_details_dtgrid.Columns[0].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[4].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[5].Visibility = Visibility.Collapsed; dgh_type_cmbbx.Visibility = Visibility.Collapsed; dgh_type_cmbbx.SelectedIndex = -1; dgh_type_lbl.Visibility = Visibility.Collapsed; food_cmbbx.SelectedIndex = -1; qnty_txb.Clear(); notes_txb.Text = ""; dgh_type_lbl.Foreground = Brushes.Black; qnty_lbl.Visibility = Visibility.Collapsed; qnty_txb.Visibility = Visibility.Collapsed; } else { dgh_type_lbl.Foreground = Brushes.Red; } } else { List <products> lst_p = db1.products.ToList(); foreach (products prod in lst_p) { if (prod.name == nm) { details_order.products_id = prod.Id; details_order.products = prod; break; } } details_order.quantity = qn; details_order.details = notes_txb.Text; db1.order_details.Add(details_order); db1.SaveChanges(); order_details_dtgrid.ItemsSource = db1.order_details.ToList(); order_details_dtgrid.Columns[0].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[4].Visibility = Visibility.Collapsed; order_details_dtgrid.Columns[5].Visibility = Visibility.Collapsed; dgh_type_cmbbx.Visibility = Visibility.Collapsed; dgh_type_cmbbx.SelectedIndex = -1; dgh_type_lbl.Visibility = Visibility.Collapsed; food_cmbbx.SelectedIndex = -1; qnty_txb.Clear(); notes_txb.Text = ""; dgh_type_lbl.Foreground = Brushes.Black; qnty_lbl.Visibility = Visibility.Collapsed; qnty_txb.Visibility = Visibility.Collapsed; } } else { if (nm != "") { food_lbl.Foreground = Brushes.Black; qnty_lbl.Foreground = Brushes.Red; if (nm.Contains("Pizza")) { if (dgh_type_cmbbx.SelectedIndex == -1) { dgh_type_lbl.Foreground = Brushes.Red; } else { dgh_type_lbl.Foreground = Brushes.Black; } } } else { food_lbl.Foreground = Brushes.Red; } } }
private void sbmt_btn_Click(object sender, RoutedEventArgs e) { string p_method; if (name_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter the name of the expense"); } else if (price_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter the price of the expense"); } else if (year_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter the year of the expense"); } else if (month_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter the month of the expense"); } else if (day_txb.Text == "") { msg_lsb.Items.Add("Failure! Enter the day of the expense"); } else if (emp == null) { msg_lsb.Items.Add("Failure! Select your identity"); } else if (pay_mth_cmbbx.SelectedItem == null) { msg_lsb.Items.Add("Failure! Select the payment method"); } else { if (pay_mth_cmbbx.SelectedItem == credit) { p_method = "credit"; } else { p_method = "cash"; } //emp = (employee)emp_dtgrid.SelectedItem; date dt = new date { year = Int32.Parse(year_txb.Text), month = Int32.Parse(month_txb.Text), day = Int32.Parse(day_txb.Text) }; expense expnse = new expense { date = dt, employee = emp, name = name_txb.Text, pay_method = p_method, price = Int32.Parse(price_txb.Text), employee_name = emp.name }; db1.date.Add(dt); db1.expense.Add(expnse); db1.SaveChanges(); expense_dtgrid.Visibility = Visibility.Visible; date_dtgrid.Visibility = Visibility.Visible; date_dtgrid.ItemsSource = db1.date.ToList(); expense_dtgrid.ItemsSource = db1.expense.ToList(); ////date_dtgrid.Columns[4].Visibility = Visibility.Collapsed; ////expense_dtgrid.Columns[4].Visibility = Visibility.Collapsed; ////expense_dtgrid.Columns[5].Visibility = Visibility.Collapsed; ////expense_dtgrid.Columns[7].Visibility = Visibility.Collapsed; ////expense_dtgrid.Columns[8].Visibility = Visibility.Collapsed; } }