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(); } }
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(); }
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)); } } }