private void FormFilterPublishers_Load(object sender, EventArgs e)
{
Application.UseWaitCursor = false;
string publisherName = "";
lbFilteredPublishers.EndUpdate();
lbAvailablePublishers.EndUpdate();
lbFilteredPublishers.Items.Clear();
lbAvailablePublishers.Items.Clear();
// Get the list of publishers currently in the filter list
SettingsDAO lwDataAccess = new SettingsDAO();
string publisherFilter = lwDataAccess.GetPublisherFilter();
List <String> listFilterPublishers = new List <string>();
listFilterPublishers.AddRange(publisherFilter.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries));
// Recover a complete list of all publsiher names
DataTable dtAvailablePublishers = new ApplicationsDAO().GetAllPublisherNames();
// add <unidentified> publisher if not present
if (dtAvailablePublishers.Select("_PUBLISHER = '" + DataStrings.UNIDENIFIED_PUBLISHER + "'").Length == 0)
{
DataRow uidRow = dtAvailablePublishers.NewRow();
uidRow["_PUBLISHER"] = DataStrings.UNIDENIFIED_PUBLISHER;
dtAvailablePublishers.Rows.Add(uidRow);
}
// Add the publisher to the appropriate list
foreach (DataRow row in dtAvailablePublishers.Rows)
{
publisherName = row[0].ToString();
if (!listFilterPublishers.Contains(publisherName))
{
lbAvailablePublishers.Items.Add(publisherName);
}
else
{
lbFilteredPublishers.Items.Add(publisherName);
}
}
lbFilteredPublishers.EndUpdate();
lbAvailablePublishers.EndUpdate();
}
