/// <summary>
/// Gets all existing Projekte from the Database and adds them to the existingProjekteComboBox
/// </summary>
/// <param name="sender">The sender</param>
/// <param name="e">The event args</param>
public static void BindFromExistingProjekteToComboBox(object sender, EventArgs e)
{
// check sender for null
if (sender == null)
{
return;
}
List<ProjektTable> results;
// add empty element to make empty choices possible
List<string> listItems = new List<string>();
listItems.Add("");
ProjektManager loader = new ProjektManager();
// Load all existing Projekte to object result list
results = loader.Load(-1, new DateTime(1900, 1, 1), new DateTime(2100, 1, 1), null);
// if there are results, add them to string result list
if (results.Count != 0)
{
foreach (ProjektTable projekt in results)
{
string entry = projekt.ID + ": " + projekt.Projektname;
listItems.Add(entry);
}
}
// set data source
(sender as ComboBox).DataSource = listItems;
}
private void projektSuchenSearchButton_Click(object sender, EventArgs e)
{
logger.Log(Logger.Level.Info, "projekt search button pressed");
// get selected KundenID
// force searching for existing Kunden, if Kunde has not dropped down the ComboBox (would throw Exception otherwise)
if (this.projektSuchenKundeCombobox.SelectedIndex < 0)
{
GlobalActions.BindFromExistingKundenToComboBox(this.projektSuchenKundeCombobox, null);
}
this.projektSuchenMessageLabel.Hide();
string kundenID = this.projektSuchenKundeCombobox.SelectedItem.ToString();
int id = -1;
try
{
id = GlobalActions.GetIdFromCombobox(kundenID, projektSuchenMessageLabel);
logger.Log(Logger.Level.Info, "kundenid in projekt search: " + id);
}
catch(InvalidInputException)
{
logger.Log(Logger.Level.Error, "Unknown Exception while getting ID from Projekte from AngeboteTab!");
}
//logger.Log(Logger.Level.Info, "KundenID:" +id);
// get Angebot in SDS format: 6/1/2009
DateTime from = this.projektSuchenVonDatepicker.Value;
DateTime until = this.projektSuchenBisDatepicker.Value;
ProjektManager manager = new ProjektManager();
List<ProjektTable> results = new List<ProjektTable>();
try
{
results = manager.Load(id, from, until, this.projektSuchenMessageLabel);
logger.Log(Logger.Level.Info,"resultslength: "+results.Count);
}
catch (DataBaseException ex)
{
this.logger.Log(Logger.Level.Error, "A serious problem with the database has occured. Program will be exited. " + ex.Message + ex.StackTrace);
Application.Exit();
}
this.projektSearchBindingSource.DataSource = results;
}