public long SaveEmployee(EmployeeDto employee)
{
string sqlString =
"INSERT INTO Employee (FirstName, LastName, BirthPlace, CurrentPlace, Gender, Department, OIB) " +
"VALUES (@FirstName, @LastName, @BirthPlace, @CurrentPlace, @Gender, @Department, @OIB)";
MySqlCommand cmd = new MySqlCommand(sqlString, conn);
Employee e = (Employee)employee.ToDataObject();
cmd.Parameters.AddWithValue("@FirstName", e.FirstName);
cmd.Parameters.AddWithValue("@LastName", e.LastName);
cmd.Parameters.AddWithValue("@BirthPlace", e.BirthPlace);
cmd.Parameters.AddWithValue("@CurrentPlace", e.CurrentPlace);
cmd.Parameters.AddWithValue("@Gender", e.Gender);
cmd.Parameters.AddWithValue("@Department", e.Department.GetStringValue());
cmd.Parameters.AddWithValue("@OIB", e.OIB);
cmd.ExecuteNonQuery();
return(cmd.LastInsertedId);
}
