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