public void SaveEmployee(Employee employee)
{
try
{
using (var connection = new SqlConnection(_connectionString))
{
using (var command = connection.CreateCommand())
{
command.Parameters.AddWithValue("@employeeID", employee.EmployeeID);
command.Parameters.AddWithValue("@firstname", employee.FirstName);
command.Parameters.AddWithValue("@lastname", employee.LastName);
command.Parameters.AddWithValue("@title", employee.Title);
command.Parameters.AddWithValue("@country", employee.Country);
command.CommandText =
"UPDATE Employees SET FirstName = @firstname, LastName = @lastname, Title = @title, Country = @country WHERE EmployeeID = @employeeId";
connection.Open();
command.ExecuteNonQuery();
connection.Close();
}
}
}
catch (FaultException<SqlException> exception)
{
throw new FaultException<SqlException>(exception.Detail, "Something went wrong");
}
catch (Exception exception)
{
throw new FaultException<Exception>(exception);
}
}
public Employee GetEmployeeById(int id)
{
try
{
var queryString =
"SELECT EmployeeID, FirstName, LastName, Title, Country FROM Employees WHERE EmployeeID =" + id;
var employee = new Employee();
using (var connection = new SqlConnection(_connectionString))
{
var command = new SqlCommand(queryString, connection);
connection.Open();
var reader = command.ExecuteReader();
while (reader.Read())
{
employee.EmployeeID = (int) reader["EmployeeID"];
employee.FirstName = (string) reader["FirstName"];
employee.LastName = (string) reader["LastName"];
employee.Title = (string) reader["Title"];
employee.Country = (string) reader["Country"];
}
connection.Close();
}
return employee;
}
catch (FaultException<SqlException> exception)
{
throw new FaultException<SqlException>(exception.Detail, "Something went wrong");
}
catch (Exception exception)
{
throw new FaultException<Exception>(exception);
}
}