Beispiel #1
0
        public static void Main(string[] args)
        {
            DataClasses1DataContext dataClass1DataContext = new DataClasses1DataContext();
            //dat
            DataSet ds = new DataSet();
            ds.ReadXml(@"D:\HotelMgmtSystem\XMLAssignment\xmlDoc\Employee-Company.xml");
            DataTable companyXML = ds.Tables["Company"];
            DataTable departmentXML = ds.Tables["Department"];
            DataTable departmentsXML = ds.Tables["Departments"];
            DataTable employeeXML = ds.Tables["Employee"];
            DataTable employeesXML = ds.Tables["Employees"];
            try
            {
                foreach (DataRow cr in companyXML.Rows)
                {
                    Company company = new Company
                    {
                        Company_Id = ValidationClass.CompanyIdCheck(cr["Company_Id"].ToString()),
                        CompanyName = ValidationClass.StringCheck(cr["CompanyName"].ToString())
                    };
                    dataClass1DataContext.Companies.InsertOnSubmit(company);
                }
                dataClass1DataContext.SubmitChanges();

                foreach (DataRow deptsrow in departmentsXML.Rows)
                {
                    Department1 depts = new Department1
                    {
                        Departments_Id = ValidationClass.DepartmentsIdCheck(deptsrow["Departments_Id"].ToString()),
                        Company_Id = ValidationClass.CompanyIdCheckIndepts(deptsrow["Company_Id"].ToString())
                    };
                    dataClass1DataContext.Department1s.InsertOnSubmit(depts);
                }
                dataClass1DataContext.SubmitChanges();
                foreach (DataRow deptrow in departmentXML.Rows)
                {
                    Department dept = new Department
                    {
                        ID = ValidationClass.DepartmentIdCheck(deptrow["ID"].ToString()),
                        DepartmentName = ValidationClass.DepartmentNameCheck(deptrow["DepartmentName"].ToString()),
                        Departments_Id = ValidationClass.DepartmentsIdCheckIndept(deptrow["Departments_Id"].ToString())
                    };
                    dataClass1DataContext.Departments.InsertOnSubmit(dept);
                }
                dataClass1DataContext.SubmitChanges();
                foreach (DataRow empsrow in employeesXML.Rows)
                {
                    Employee1 emps = new Employee1
                    {
                        Employees_Id = ValidationClass.EmployeesIdCheck(empsrow["Employees_Id"].ToString()),
                        Company_Id = ValidationClass.CompanyIdCheckIndepts(empsrow["Company_Id"].ToString())
                    };
                    dataClass1DataContext.Employee1s.InsertOnSubmit(emps);
                }
                dataClass1DataContext.SubmitChanges();
                foreach (DataRow emprow in employeeXML.Rows)
                {
                    Employee emp = new Employee
                    {
                        ID =ValidationClass.EmployeeIdCheck(emprow["ID"].ToString()),
                        DepartmentID = ValidationClass.DepartmentIdCheckInEmp(emprow["DepartmentId"].ToString()),
                        FirstName = ValidationClass.StringCheck(emprow["FirstName"].ToString()),
                        LastName = ValidationClass.StringCheck(emprow["LastName"].ToString()),
                        Salary = ValidationClass.SalaryInEmp(emprow["Salary"].ToString()),
                        Employees_Id = ValidationClass.EmployeesIdCheckInEmp(emprow["Employees_Id"].ToString())
                    };
                    dataClass1DataContext.Employees.InsertOnSubmit(emp);
                }
                dataClass1DataContext.SubmitChanges();
            }catch(Exception e)
            {
                Console.WriteLine(e.Message);
            }
        }
Beispiel #2
0
 partial void DeleteDepartment1(Department1 instance);
Beispiel #3
0
 partial void InsertDepartment1(Department1 instance);
Beispiel #4
0
 partial void UpdateDepartment1(Department1 instance);
Beispiel #5
0
 private void detach_Department1s(Department1 entity)
 {
     this.SendPropertyChanging();
     entity.Company = null;
 }