示例#1
0
        //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();
        }