private void ShowOrdersByEmployee(DataGrid dataGrid_Order, TextBox SearchOrderBox)
{
using (var db = new DesignStudioEntities())
{
var orders = from order in db.Order
join customer in db.Customer on order.Customer_Ref equals customer.Customer_ID
join employee in db.Employee on order.Employee_Ref equals employee.Employee_ID
join position in db.Position on employee.Position_Ref equals position.Position_ID
where employee.Name.Contains(SearchOrderBox.Text)
select new
{
order.Description,
Start = order.Start_date,
End = order.End_date,
Price = order.Total_price,
Customer = customer.Name,
Employee = employee.Name,
Position = position.Position_name
};
dataGrid_Order.ItemsSource = orders.ToList();
}
}
public void fillEmployeeFields()
{
using (var db = new DesignStudioEntities())
{
var chosenEmployee = (from employee in db.Employee
where employee.Employee_ID == employee_index
select new
{
employee.Name,
Birthdate = employee.Birth_date,
Adress = employee.Residence_place,
employee.Phone,
Passport = employee.Passport_number,
Position = employee.Position_Ref
}).FirstOrDefault();
name.Text = chosenEmployee.Name;
birthdate.SelectedDate = chosenEmployee.Birthdate;
adress.Text = chosenEmployee.Adress;
phone.Text = chosenEmployee.Phone;
passport.Text = chosenEmployee.Passport;
position.SelectedIndex = (int)chosenEmployee.Position - 1;
}
}
public void fillOrderFields()
{
using (var db = new DesignStudioEntities())
{
var chosenOrder = (from order in db.Order
where order.Order_ID == order_index
select new
{
Descriptiona = order.Description,
Start = order.Start_date,
End = order.End_date,
Price = order.Total_price,
Customer = order.Customer_Ref,
Employee = order.Employee_Ref,
}).FirstOrDefault();
description.Text = chosenOrder.Descriptiona;
start_date.SelectedDate = chosenOrder.Start;
end_date.SelectedDate = chosenOrder.End;
price.Text = Math.Truncate((decimal)chosenOrder.Price).ToString();
customercombo.SelectedIndex = (int)chosenOrder.Customer - 1;
employeecombo.SelectedIndex = (int)chosenOrder.Employee - 1;
}
}
public void ShowNotOpenedProjects(DataGrid datagrid_Project)
{
using (var db = new DesignStudioEntities())
{
var subselect = (from project in db.Design_Project select project.Order_Ref).ToList();
var result = from order in db.Order
join customer in db.Customer on order.Customer_Ref equals customer.Customer_ID
join employee in db.Employee on order.Employee_Ref equals employee.Employee_ID
join position in db.Position on employee.Position_Ref equals position.Position_ID
where !subselect.Contains(order.Order_ID)
select
new
{
order.Description,
Start = order.Start_date,
End = order.End_date,
Price = order.Total_price,
Customer = customer.Name,
Employee = employee.Name,
Position = position.Position_name
};
datagrid_Project.ItemsSource = result.ToList();
}
}
