//depatments id
public static Int64 DepartmentsIdCheck(string number)
{
if (ValidationClass.IsDigit(number))
{
if (Convert.ToInt64(number) >= 0)
{
Int64 In_Id = Convert.ToInt64(number);
// bool b = dataClasses1DataContext.Compnays.Contains(In_Id).ToString()
var checkNo =
from id in dataClasses1DataContext.Department1s where id.Departments_Id == In_Id select id.Departments_Id;
if (checkNo.Count() == 0)
{
return(In_Id);
}
else
{
throw new Exception("No already present");
}
//return Convert.ToInt64(number);
}
else
{
throw new Exception(" please enter positive number");
}
}
else
{
throw new Exception("Not a number");
}
}
public static Int64 EmployeesIdCheckInEmp(string number)
{
if (ValidationClass.IsDigit(number))
{
if (Convert.ToInt64(number) >= 0)
{
Int64 In_Id = Convert.ToInt64(number);
// bool b = dataClasses1DataContext.Compnays.Contains(In_Id).ToString()
var checkNo =
from id in dataClasses1DataContext.Employee1s where id.Employees_Id == In_Id select id.Employees_Id;
if (checkNo.Count() == 1)
{
return(In_Id);
}
else
{
throw new Exception("please check emplyeees Id");
}
//return Convert.ToInt64(number);
}
else
{
throw new Exception(" please enter positive number");
}
}
else
{
throw new Exception("Not a number");
}
}
public static Int64 SalaryInEmp(string number)
{
if (ValidationClass.IsDigit(number))
{
Int64 sal = Convert.ToInt64(number);
if (sal >= 0)
{
return(sal);
}
else
{
throw new Exception("Salary cannot be negative");
}
}
else
{
throw new Exception("Not valid no");
}
}
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);
}
}