public List <Manager> Find(ManagerColumn column, string search)
{
List <Manager> m = new List <Manager>();
using (SqlConnection connection = DBConnection.GetSqlConnection())
{
using (SqlCommand cmd = connection.CreateCommand())
{
cmd.CommandText = $"select id, name, phonenumber, email, username from managers where {column.ToString()} = @search";
cmd.Parameters.AddWithValue($"@search", search);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
int id = reader.GetInt32("id");
string name = reader.GetString("name");
string phonenumber = reader.GetString("phonenumber");
string email = reader.GetString("email");
string username = reader.GetString("username");
m.Add(new Manager(name, phonenumber, email, username, id));
}
}
}
}
if (m.Count == 0)
{
return(null);
}
return(m);
}
public List <Manager> FindManager(ManagerColumn columnName, string search)
{
return(managerDB.Find(columnName, search));
}