//TMP
/* public List<employee> GetEmployees()
* {
* return model.GetEmployees();
* }
*
* }*/
public Database1Entities1 InsertWorker(string type, int salary, string city, string street, string house_number, string gender, string idNumber, string name, string phone, string deleted, Database1Entities1 db1)
{
employee_type et = db1.employee_type.Add(new employee_type {
type = type, salary = salary
});
Postal_Code_Worker pc = db1.Postal_Code_Worker.Add(new Postal_Code_Worker {
city = city, street = street, house_number = house_number
});
Workers_Gender wg = db1.Workers_Gender.Add(new Workers_Gender {
Gender = gender
});
db1.employee.Add(new employee {
id_number = idNumber, name = name, phone = phone, deleted = deleted, employee_type = et, Postal_Code_Worker = pc, Workers_Gender = wg
});
return(db1);
}
private void Button_Click(object sender, RoutedEventArgs e)
{
employee_type et = db1.employee_type.Add(new employee_type {
type = tType.Text, salary = tSalary.Text
});
Postal_Code_Worker pc = db1.Postal_Code_Worker.Add(new Postal_Code_Worker {
city = tCity.Text, street = tStreet.Text, house_number = tNumberHouse.Text
});
Workers_Gender wg = db1.Workers_Gender.Add(new Workers_Gender {
Gender = tGender.Text
});
db1.employee.Add(new employee {
deleted = "", id_number = tNumberID.Text, name = tName_Copy.Text, phone = tPhone.Text, employee_type = et, Postal_Code_Worker = pc
});
var results = from table1 in db1.employee.AsEnumerable()
// join table2 in db1.employee_type.AsEnumerable() on (int)table1.employee_type_id equals (int)table2.Id_Employee_Type
// join table3 in db1.Postal_Code_Worker.AsEnumerable() on (int)table1.postal_code_id equals (int)table3.Id_Postal_Code_Worker
select new
{
Employee_Id = (int)table1.Id_Employee,
Id_Number = (string)table1.id_number,
Name = (string)table1.name,
Phone = (string)table1.phone,
//Gender = (string)table1.gender,
Deleted = (string)table1.deleted,
/* employee_type_id = (int)table2.Id_Employee_Type,
* type = (string)table2.type,
* salary = (string)table2.salary,
* postal_code_id = (int)table3.Id_Postal_Code_Worker,
* city = (string)table3.city,
* street = (string)table3.street,
* house_number = (string)table3.house_number*/
};
this.db1.SaveChanges();
employeeDataGrid.ItemsSource = results.ToList();
this.Close();
}