private void Button_Click(object sender, RoutedEventArgs e)
{
EmployeeTable selected_employee = (EmployeeTable)CustomerSelectionComboBox.SelectedItem;
EmployeesBL.UpdateBL(selected_employee, firstname_txb.Text, lastName_txb.Text, address_txb.Text, phone_txb.Text, mail_txb.Text, Int32.Parse(status_txb.Text), Int32.Parse(salary_txb.Text), notes_txb.Text);
this.Close();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
orderFromSupplierTable selectedOrder = (orderFromSupplierTable)purchasingUpdateComboBox.SelectedItem;
EmployeeTable selectedEmployee = (EmployeeTable)EmployeeSelectionComboBox.SelectedItem;
PurchasingFromSupplierBL.UpdateBL(selectedOrder, shippingNumber_txb.Text, receptoionNumber_txb.Text, selectedEmployee, Convert.ToDateTime(order_datepicker.Text), Convert.ToDateTime(supplying_datepicker.Text), notes_txb.Text, Convert.ToInt32(activity_txb.Text));
this.Close();
}
private void Button_Click(object sender, RoutedEventArgs e)
{
EmployeeTable selectedEmployee = new EmployeeTable();
selectedEmployee = (EmployeeTable)employeeSlelctionComboBox.SelectedItem;
Expends.UpdateVariableExpend((variableExpendsTable)selectionVarialeExpendComboBox.SelectedItem, selectedEmployee, notes_txb.Text, name_txb.Text, Convert.ToInt32(cost_txb.Text), Convert.ToDateTime(date_picker.Text), Convert.ToInt32(active_txb.Text));
this.Close();
}
private void EmployeeSelectionComboBox_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
EmployeeTable selectedEmployee = (EmployeeTable)EmployeeSelectionComboBox.SelectedItem;
if (selectedEmployee.full_Name != employee_txb.Text)
{
employee_txb.Text = selectedEmployee.full_Name;
}
}
private void Button_Click(object sender, RoutedEventArgs e)
{
EmployeeTable selectedEmployee = (EmployeeTable)EmployeeSelectionComboBox.SelectedItem;
PurchasingCotumer.AddPurchaseCostumer(shippingNumber_txb.Text, receptoionNumber_txb.Text, selectedEmployee,
Convert.ToDateTime(order_datePicker.Text), Convert.ToDateTime(supplying_datePicker.Text), notes_txb.Text, this.Idlist,
shippingAddress_txb.Text);
coc.Close();
this.Close();
}
public static void UpdateEmployeeDL(EmployeeTable et, string firstName, string lastName, string address,
string phone, string mail, int active, int salary, string notes)
{
EmployeeTable selected_employee = et;
selected_employee.first_Name = firstName;
selected_employee.last_Name = lastName;
selected_employee.address = address;
selected_employee.phoneNumber = phone;
selected_employee.E_mail = mail;
selected_employee.active = active;
selected_employee.salary = salary;
selected_employee.notes = notes;
db.SaveChanges();
}
public static void AddCurrentExpend(EmployeeTable selectedEmployee, string notes, string name, int cost,
DateTime date)
{
db.CurrentExpendsTable.Add(new CurrentExpendsTable()
{
EmployeeTable = selectedEmployee,
employee_id = selectedEmployee.Id,
notes = notes,
active = 0,
name = name,
cost = cost,
date = date
});
db.SaveChanges();
}
public static void UpdatePurchaseFromSupplier(orderFromSupplierTable selectedOrder, string shippingNumber, string receptionNumber,
EmployeeTable selectedEmployee, DateTime orderDate, DateTime supplyingDate, string notes, int active)
{
selectedOrder.shippingNumber = shippingNumber;
selectedOrder.receptionNumber = receptionNumber;
selectedOrder.orderDate = orderDate;
selectedOrder.supplyingDate = supplyingDate;
if (selectedEmployee != null)
{
selectedOrder.employee_id = selectedEmployee.Id;
selectedOrder.EmployeeTable = selectedEmployee;
}
selectedOrder.notes = notes;
selectedOrder.active = active;
db.SaveChanges();
}
public static void UpdateCurrentExpend(CurrentExpendsTable selectedCurrentExp, EmployeeTable selectedEmployee,
string notes, string name, int cost,
DateTime date, int active)
{
if (selectedEmployee != null)
{
selectedCurrentExp.EmployeeTable = selectedEmployee;
selectedCurrentExp.employee_id = selectedEmployee.Id;
}
selectedCurrentExp.notes = notes;
selectedCurrentExp.name = name;
selectedCurrentExp.cost = cost;
selectedCurrentExp.date = date;
selectedCurrentExp.active = active;
db.SaveChanges();
}
public static void AddPurchaseCostumer(string shippingNumber, string receptionNumber, EmployeeTable employee,
DateTime orderDste, DateTime supplyingDate, string notes, string shippingAddress,
List <orderDetailsTable> Idlist)
{
OrdersTable ot = db.OrdersTable.Add(new OrdersTable()
{
shipping_number = shippingNumber,
reception_number = receptionNumber,
employee_id = employee.Id,
EmployeeTable = employee,
orderDate = orderDste,
supplyingDate = supplyingDate,
notes = notes,
active = 0,
shippingAddress = shippingAddress
});
db.SaveChanges();
foreach (orderDetailsTable element in Idlist)
{
element.orders_id = ot.Id;
}
db.SaveChanges();
}
public static void UpdateBL(orderFromSupplierTable selectedOrder, string shippingNumber, string receptionNumber,
EmployeeTable selectedEmployee, DateTime orderDate, DateTime supplyingDate, string notes, int active)
{
DataLayer.UpdatePurchaseFromSupplier(selectedOrder, shippingNumber, receptionNumber, selectedEmployee, orderDate, supplyingDate, notes, active);
}
public static void UpdatePurchaseCostumerBL(OrdersTable selectedOrder, string shippingNumber,
string receptionNumber, EmployeeTable selectedEmployee, DateTime orderDate, DateTime supplyingDate,
string notes, int active, string shippingAddress)
{
DataLayer.UpdatePurchaseCostumer(selectedOrder, shippingNumber, receptionNumber, selectedEmployee, orderDate, supplyingDate, notes, active, shippingAddress);
}
public static void AddPurchaseCostumer(string shippingNumber, string receptionNumber, EmployeeTable employee,
DateTime orderDate, DateTime supplyingDate, string notes, List <orderDetailsTable> Idlist, string shippingAddress)
{
DataLayer.AddPurchaseCostumer(shippingNumber, receptionNumber, employee, orderDate, supplyingDate, notes, shippingAddress, Idlist);
}
public static void UpdateCurrentExpend(CurrentExpendsTable selectedCurrentExp, EmployeeTable selectedEmployee,
string notes, string name, int cost,
DateTime date, int active)
{
DataLayer.UpdateCurrentExpend(selectedCurrentExp, selectedEmployee, notes, name, cost, date, active);
}
public static void AddCurrentExpend(EmployeeTable selectedEmployee, string notes, string name, int cost,
DateTime date)
{
DataLayer.AddCurrentExpend(selectedEmployee, notes, name, cost, date);
}
public static void UpdateBL(EmployeeTable et, string firstName, string lastName, string address, string phone,
string mail, int active, int salary, string notes)
{
DataLayer.UpdateEmployeeDL(et, firstName, lastName, address, phone, mail, active, salary, notes);
}
public static void AddPurchaseFromSupplier(string shippingNumber, string receptionNumber, EmployeeTable employee,
DateTime orderDate, DateTime supplyingDate, string notes, List <orderFromSupplierDetailTable> Idlist)
{
orderFromSupplierTable ofst = db.orderFromSupplierTable.Add(new orderFromSupplierTable()
{
shippingNumber = shippingNumber,
receptionNumber = receptionNumber,
employee_id = employee.Id,
EmployeeTable = employee,
orderDate = orderDate,
supplyingDate = supplyingDate,
notes = notes,
active = 0
});
db.SaveChanges();
foreach (orderFromSupplierDetailTable element in Idlist)
{
element.orderFromSupplier_id = ofst.Id;
}
db.SaveChanges();
}
public static void AddPurchaseFromSupplier(string shippingNumber, string receptionNumber, EmployeeTable employee,
DateTime orderDate, DateTime supplyingDate, string notes, List <orderFromSupplierDetailTable> Idlist)
{
DataLayer.AddPurchaseFromSupplier(shippingNumber, receptionNumber, employee, orderDate, supplyingDate, notes, Idlist);
}