/**
* @fn void InsertEmployee(Employee employee);
*
* @brief inserts new employee into database
*
* @return void
*/
void InsertEmployee(Employee employee)
{
conn.Open();
SqlCommand cmd = null;
switch (employee.GetEmployeeType())
{
case "fulltime":
cmd = new SqlCommand("INSERT INTO Employee (firstName, lastName, socialInsuranceNumber, dateOfBirth, isValid, isActive)" +
"VALUES (" + employee.GetFirstName() + ", " + employee.GetLastName() + ", " + employee.GetSin() + ", " + employee.GetDateOfBirth() + "0, 0");
int employeeID = GetEmployeeID();
SqlCommand getId = new SqlCommand();
cmd = new SqlCommand("INSERT INTO FullTimeEmployee (employeeID, dateOfHire, dateOfTermination, salary)" +
"VALUES (" + employeeID + ((FulltimeEmployee)employee).GetDateOfHire() + ", " + ((FulltimeEmployee)employee).GetDateOfTermination() + ", " + ((FulltimeEmployee)employee).GetSalary() + ")");
break;
case "parttime":
break;
case "seasonal":
break;
case "contract":
break;
}
cmd.Connection = conn;
cmd.ExecuteNonQuery();
conn.Close();
}