public void UpdateOrInsert(Employee employee)
{
string query = $@"IF EXISTS (SELECT TOP 1 *
FROM Employees
WHERE EmployeeID = {employee.ID})
BEGIN
UPDATE Employees
SET FirstName = '{employee.FirstName}'
SET LastName = '{employee.LastName}'
SET Email = '{employee.Email}'
SET [Date of Birth] = '{employee.BirthDate.ToString(@"yyyy-MM-dd")}'
SET ManagerID = {employee.ManagerID}
SET DepartmentID = {employee.DepartmentID}
WHERE EmployeeID = {employee.ID}
END
ELSE
BEGIN
SET IDENTITY_INSERT Employees ON
INSERT INTO Employees
VALUES ({employee.ID}, '{employee.FirstName}', '{employee.LastName}', '{employee.Email}', '{employee.BirthDate.ToString(@"yyyy-MM-dd")}', {employee.ManagerID}, {employee.DepartmentID})
SET IDENTITY_INSERT Employees OFF
END";
ExecuteNonQuery(query);
}
public void UpdateOrInsert(Employee emp)
{
string query = $@"IF EXISTS (SELECT TOP 1 *
FROM Employees
WHERE EmployeeID = {emp.Id})
BEGIN
UPDATE Employees
SET FirstName = '{emp.FirstName}'
SET LastName = '{emp.LastName}'
SET Email = '{emp.Email}'
SET BirthDate = '{emp.BirthDate.ToString(@"yyyy-MM-dd")}'
SET Manager = {emp.ManagerId}
SET Department = {emp.ManagerId}
WHERE EmployeeID = {emp.Id}
END
ELSE
BEGIN
SET IDENTITY_INSERT Employees ON
INSERT INTO Employees
VALUES ({emp.Id}, '{emp.FirstName}', '{emp.LastName}', '{emp.Email}', '{emp.BirthDate.ToString(@"dd-MM-yyyy")}', {emp.ManagerId}, {emp.DepartmentId});
SET IDENTITY_INSERT Employees OFF
END";
ExecuteNonQuery(query);
}