private void Window_Activated(object sender, EventArgs e) { if (flg) { int sum_qnty = 0; int sp = 0; supplier_name_lbl.Content += ordr.name; notes_lbl.Content += ordr.notes; product_dtgrid.ItemsSource = db1.products.ToList(); ////product_dtgrid.Columns[0].Visibility = Visibility.Collapsed; ////product_dtgrid.Columns[4].Visibility = Visibility.Collapsed; ////product_dtgrid.Columns[5].Visibility = Visibility.Collapsed; List <products> lstp = db1.products.ToList(); foreach (products p in lstp) { sp += (p.price * p.quantity); sum_qnty += p.quantity; } int f_price = CalculatingDiscount(sp, sum_qnty); discount = 100 - ((100 * f_price) / sp); if (discount > 20) { discount = 20; f_price = sp - (sp * discount) / 100; } payment_name_lbl.Content += f_price.ToString() + "₪"; final_price fp = new final_price { s_price = sp, discount = discount, f_price = f_price }; ordr.final_price = db1.final_price.Add(fp); db1.order.Add(ordr); db1.SaveChanges(); fprice_dtgrid.ItemsSource = db1.final_price.ToList(); object row = new object(); for (int i = 0; i < fprice_dtgrid.Items.Count - 1; i++) { row = fprice_dtgrid.ItemContainerGenerator.Items[i]; } List <object> lstrow = new List <object> { row }; fprice_dtgrid1.ItemsSource = lstrow; ////fprice_dtgrid1.Columns[0].Visibility = Visibility.Collapsed; ////fprice_dtgrid1.Columns[3].Visibility = Visibility.Collapsed; ////fprice_dtgrid1.Columns[5].Visibility = Visibility.Collapsed; ////fprice_dtgrid1.Columns[6].Visibility = Visibility.Collapsed; fprice_dtgrid.Visibility = Visibility.Collapsed; flg = false; } }
private void Window_Activated(object sender, EventArgs e) { if (flg) { if (discount > 100) { discount = 100; } int sp = 0; client_name_lbl.Content += ordr.name; worker_name_lbl.Content += emp.name; notes_lbl.Content += ordr.notes; product_dtgrid.ItemsSource = db1.products.ToList(); product_dtgrid.Columns[0].Visibility = Visibility.Collapsed; product_dtgrid.Columns[5].Visibility = Visibility.Collapsed; List <products> lstp = db1.products.ToList(); foreach (products p in lstp) { sp += (p.price * p.quantity); } int f_price = sp - (sp * discount) / 100; payment_name_lbl.Content += f_price.ToString() + "₪"; final_price fp = new final_price { s_price = sp, discount = discount, f_price = f_price }; ordr.final_price = db1.final_price.Add(fp); db1.order.Add(ordr); db1.SaveChanges(); fprice_dtgrid.ItemsSource = db1.final_price.ToList(); object row = new object(); for (int i = 0; i < fprice_dtgrid.Items.Count - 1; i++) { row = fprice_dtgrid.ItemContainerGenerator.Items[i]; } List <object> lstrow = new List <object>(); lstrow.Add(row); fprice_dtgrid1.ItemsSource = lstrow; fprice_dtgrid1.Columns[0].Visibility = Visibility.Collapsed; fprice_dtgrid1.Columns[3].Visibility = Visibility.Collapsed; fprice_dtgrid1.Columns[5].Visibility = Visibility.Collapsed; fprice_dtgrid1.Columns[6].Visibility = Visibility.Collapsed; fprice_dtgrid.Visibility = Visibility.Collapsed; flg = false; } }
private void Window_Loaded(object sender, RoutedEventArgs e) { if (flg) { if (discount > 100) { discount = 100; } double sp = 0; client_name_lbl.Content += ordr.client_details.first_name + " " + ordr.client_details.last_name; worker_name_lbl.Content += ordr.employee.first_name + " " + ordr.employee.last_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 += (p.products.price * p.quantity); } if (delivery) { dlvr_lbl.Visibility = Visibility.Visible; sp *= 1.2; } int f_price = Convert.ToInt32(sp - (sp * discount) / 100); payment_name_lbl.Content += f_price.ToString() + "₪"; dscnt_lbl.Content += discount.ToString() + "%"; final_price fp = new final_price { s_price = Convert.ToInt32(sp), f_price = f_price }; ordr.final_price = db1.final_price.Add(fp); ordr.final_price_s_price = Convert.ToInt32(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 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; } }