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