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); }