public static void GetFilteredData(ReadContentHandler handler, string filter)
{
AddReadHandler(handler);
connection.Open();
SqlDataReader reader = SelectSubstringData("Employees", ("employee_name", filter), ("birth_date", filter));
if (reader.HasRows)
{
while (reader.Read())
{
_readContentHandler?.Invoke(reader["employee_id"], reader["employee_name"], (reader["is_male"].ToString().Contains("True")) ? "М" : "Ж", reader["birth_date"]);
}
}
connection.Close();
RemoveReadHandler(handler);
}
public static void RemoveReadHandler(ReadContentHandler handler)
{
_readContentHandler -= handler;
}
public static void RemoveLastReadHandler()
{
_readContentHandler -= (ReadContentHandler)_readContentHandler.GetInvocationList().LastOrDefault();
}
public static void AddReadHandler(ReadContentHandler handler)
{
_readContentHandler += handler;
}
