private void buttonAdd_Click(object sender, EventArgs e)
{
FormName formName = new FormName();
formName.Text = StringTable.AddNewMedium;
formName.NameValue = "";
formName.AllowEmpty = false;
formName.ValidateName += delegate(object sender1, ValidateNameEventArgs e1)
{
if (dataBase.AllMediums.Names.Contains(e1.Name) && e1.Name != e1.OriginalName)
{
MessageBox.Show(string.Format(StringTable.MediumAlreadyExists, e1.Name), Application.ProductName, MessageBoxButtons.OK, MessageBoxIcon.Information);
e1.Cancel = true;
}
};
if (formName.ShowDialog(this) == DialogResult.OK)
{
MediumTableAdapter cta = new MediumTableAdapter(dataBase);
MediumDataSet.MediumDataTable cdt = cta.GetData();
cdt.AddMediumRow(formName.NameValue, listBoxMedium.Items.Count + 1);
cta.Update(cdt);
FillList();
}
UpdateWindowState();
}
private void buttonImport_Click(object sender, EventArgs e)
{
OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = StringTable.FilterHitbase;
if (openFileDialog.ShowDialog(this) == DialogResult.OK)
{
DataBase dbImport = new DataBase();
dbImport.Open(openFileDialog.FileName);
MediumTableAdapter cta = new MediumTableAdapter(dataBase);
MediumDataSet.MediumDataTable cdt = cta.GetData();
int count = listBoxMedium.Items.Count + 1;
foreach (Medium Medium in dbImport.AllMediums)
{
if (dataBase.GetIdByMedium(Medium.Name) < 0)
{
cdt.AddMediumRow(Medium.Name, count++);
}
}
cta.Update(cdt);
dbImport.Close();
FillList();
UpdateWindowState();
}
}
private void buttonEdit_Click(object sender, EventArgs e)
{
if (listBoxMedium.SelectedItem == null)
{
return;
}
ListBoxItem item = (ListBoxItem)listBoxMedium.SelectedItem;
FormName formName = new FormName();
formName.Text = StringTable.EditMedium;
formName.NameValue = item.Medium.Name;
if (formName.ShowDialog(this) == DialogResult.OK)
{
MediumTableAdapter mta = new MediumTableAdapter(dataBase);
MediumDataSet.MediumDataTable mdt = mta.GetDataById(item.Medium.MediumID);
mdt[0].Name = formName.NameValue;
mta.Update(mdt);
listBoxMedium.Items[listBoxMedium.SelectedIndex] = new ListBoxItem(mdt[0]);
}
UpdateWindowState();
}
public void AddNew(string medium)
{
// Nicht vorhanden, also neues Medium anlegen
MediumTableAdapter mta = new MediumTableAdapter(dataBase);
MediumDataSet.MediumDataTable mdt = mta.GetData();
mdt.AddMediumRow(medium, GetNextOrder());
mta.Update(mdt);
dataBase.UpdateMediums();
}
/// <summary>
/// Aktualisiert die Order aus der Liste in die Datenbank.
/// </summary>
private void SetOrderByList()
{
int index = 1;
foreach (ListBoxItem item in listBoxMedium.Items)
{
MediumTableAdapter mta = new MediumTableAdapter(dataBase);
MediumDataSet.MediumDataTable dt = mta.GetDataByName(item.Medium.Name);
dt[0].Order = index;
mta.Update(dt);
index++;
}
}
private void FillList()
{
listBoxMedium.Items.Clear();
MediumTableAdapter mta = new MediumTableAdapter(dataBase);
MediumDataSet.MediumDataTable mdt = mta.GetData();
if (Settings.Current.AutoSortMediums)
{
foreach (MediumDataSet.MediumRow medium in mdt.OrderBy(x => x.Name))
{
listBoxMedium.Items.Add(new ListBoxItem(medium));
}
}
else
{
foreach (MediumDataSet.MediumRow medium in mdt.OrderBy(x => x.Order))
{
listBoxMedium.Items.Add(new ListBoxItem(medium));
}
}
}