public static int CreateEmployee(int employeeId, string firstName, string lastName, string email)
{
Employee data = new Employee
{
EmployeeId = employeeId,
FirstName = firstName,
LastName = lastName,
EmailAdress = email
};
string sqlQuery = @"INSERT INTO Employees(EmployeeId, FirstName, LastName, EmailAdress) VALUES
(@EmployeeId, @FirstName, @LastName, @EmailAdress)";
return(SQLDataAcess.SaveData(sqlQuery, data));
}
public static List <Employee> LoadEmployees()
{
string SQL = @"SELECT Id, EmployeeId, FirstName, LastName, EmailAdress FROM Employees";
return(SQLDataAcess.LoadData <Employee>(SQL));
}
