private void BtnChangePerson_click(object sender, RoutedEventArgs e)
{
if (lbPersonen.SelectedValue == null)
{
MessageBox.Show("Bitte zuerst eine Person auswählen!");
return;
}
int index = 0;
{
NameRolle nr = new NameRolle();
foreach (var item in cNameRolle)
{
if (item.currID == (Int32)lbPersonen.SelectedValue)
{
nr.currID = item.currID;
nr.currRolleID = item.currRolleID;
nr.name = item.name;
nr.rolle = item.rolle;
nr.currNameRolleID = item.currNameRolleID;
EditNameRolle enr = new EditNameRolle(nr);
enr.ShowDialog();
index = cNameRolle.IndexOf(item);
}
}
cNameRolle[index] = nr;
lbPersonen.ItemsSource = null;
lbPersonen.ItemsSource = cNameRolle;
}
}
private void btnView_Click(object sender, RoutedEventArgs e)
{
try
{
NameRolle nr = DGPersonen.SelectedItem as NameRolle;
int i = 0;
foreach (var item in nr_list)
{
if (item.name.StartsWith(nr.name) == true)
{
i = nr_list.IndexOf(item);
}
}
EditNameRolle enr = new EditNameRolle(nr);
enr.ShowDialog();
nr_list[i].currID = enr.cNR.currID;
nr_list[i].currRolleID = enr.cNR.currRolleID;
nr_list[i].name = enr.cNR.name;
DGPersonen.ItemsSource = null;
DGPersonen.ItemsSource = nr_list;
txtAutorSort.Text = GetAutorSort();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
public EditNameRolle(NameRolle _cNR)
{
InitializeComponent();
this.cNR = _cNR;
this.DataContext = cNR;
var ar = from a in Admin.conn.AutorRolle select new { id = a.ID, rolle = a.AutorKurz + " (" + a.AutorRolle1 + ")" };
cbRolle.ItemsSource = ar;
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{ //this.DataContext = newBook;
//Hilfstabellen laden/aktivieren
sett = new mySettings();
Admin.LoadGenre(ugridGenre);
LoadAuxTab();
btnPublNew.Visibility = Visibility.Hidden;
NameRolle nr = new NameRolle();
nr_list = new List <NameRolle>();
verl_list = new List <DnbVerlag>();
print_list = new List <DnbPrinter>();
var language = from lg in Admin.conn.Language orderby lg.Language1 select new { lng = lg.Language1, iso = lg.iso, id = lg.LanguageID };
cbLang.ItemsSource = language.ToList();
var bind = from b in Admin.conn.Bindung orderby b.SortBy select new { bnd = b.SortBy, id = b.BindingID };
cbBindung.ItemsSource = bind.ToList();
var typ = from t in Admin.conn.BuchTyp orderby t.SortBy select new { typ = t.SortBy, id = t.ID };
cbBuchTyp.ItemsSource = typ.ToList();
var sach = from s in Admin.conn.Sachgruppe orderby s.SortBy select new { sg = s.SortBy, id = s.GenreID };
cbSachgruppe.ItemsSource = sach.ToList();
var sto = from st in Admin.conn.Standort orderby st.SortBy select new { so = st.SortBy, id = st.ID };
cbStandort.ItemsSource = sto.ToList();
var kat = from k in Admin.conn.DDC_Haupt orderby k.DDC select new { kat = k.DDC_Name, id = k.ID };
cbKategorie.ItemsSource = kat.ToList();
var serie = from s in Admin.conn.Serien orderby s.SortBy select new { serie = s.SortBy, id = s.ID };
cbSerie.ItemsSource = serie.ToList();
db = DNBDataHandling.GetDataDNB(dnbID);
ShowPerson();
FindPublisher(db.dnb_verlagsname);
FindLanguage(db.dnb_sprache);
FindOrigLanguage(db.dnb_sprache_org);
imgLoad();
LoadNewData();
}
private void btnView_Click(object sender, RoutedEventArgs e)
{
try
{
NameRolle nr = DGNamen.SelectedItem as NameRolle;
if (nr.currID == -1)
{
MessageBox.Show("Form AddName aufrufen");
}
else
{
EditNameRolle enr = new EditNameRolle(nr);
enr.ShowDialog();
DGNamen.ItemsSource = nr_list;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void BtnSearch_Click(object sender, RoutedEventArgs e)
{
NameRolle nr = new NameRolle();
nr_list = new List <NameRolle>();
string input = txtInput.Text;
if (string.IsNullOrEmpty(input) == true)
{
MessageBox.Show("Zuerst Dateiname (ohne Endung) eingeben!");
return;
}
string s = s = File.ReadAllText(sampleXml + txtInput.Text.Trim() + ".mrcx");;
DataHandling.DNBBookData dnbdata = new DNBBookData(s);
//MessageBox.Show(dnbdata.dnb_nr + "/" + dnbdata.dnb_isbn_13 + "/" + dnbdata.dnb_isbn + "/" + dnbdata.dnb_titel + "/" + dnbdata.dnb_stichwort + "/" + dnbdata.dnb_index);
//cbTitel.Items.Add(dnbdata.dnb_Autor_sort + ", " + dnbdata.dnb_Rolle);
string[] name = dnbdata.dnb_Autor_sort.Split(',');
string[] ret = FindAutor(name[0]).Split('#');
nr_list.Add(new NameRolle()
{
name = dnbdata.dnb_Autor_sort, rolle = dnbdata.dnb_Rolle, nameInDB = ret[1], currID = Int32.Parse(ret[0])
});
if (dnbdata.dnb_mitautor != null)
{
dnbdata.dnb_mitautor = dnbdata.dnb_mitautor.Substring(0, dnbdata.dnb_mitautor.Length - 1);
dnbdata.dnb_mitautor_rolle = dnbdata.dnb_mitautor_rolle.Substring(0, dnbdata.dnb_mitautor_rolle.Length - 1);
List <string> mitAutor = dnbdata.dnb_mitautor.Split(';').ToList();
List <string> rolleMitAutor = dnbdata.dnb_mitautor_rolle.Split(';').ToList();
for (int i = 0; i < mitAutor.Count; i++)
{
name = mitAutor[i].Split(',');
string[] retA = FindAutor(name[0]).Split('#');
nr_list.Add(new NameRolle()
{
name = mitAutor[i], rolle = rolleMitAutor[i], nameInDB = retA[1], currID = Int32.Parse(retA[0])
});
}
}
// parts.Add(new Part() {PartName="crank arm", PartId=1234});
txtInput.Focus();
//lbTitel.Items.Clear();
foreach (var item in nr_list)
{
var rolleID = (from ri in Admin.conn.AutorRolle where ri.AutorKurz == item.rolle select ri).FirstOrDefault();
if (rolleID != null)
{
item.currRolleID = rolleID.ID;
}
}
//Datagrid vorbereiten
var autorrolle = (from ar in Admin.conn.AutorRolle select ar.AutorRolle1).ToList();
ComboBoxColumn.ItemsSource = autorrolle;
DGNamen2.ItemsSource = nr_list;
DGNamen.ItemsSource = nr_list;
//cbTitel.ItemsSource = nr_list;
var lang = from lg in Admin.conn.Language select lg;
cbTest.ItemsSource = lang.ToList();
if (dnbdata.dnb_dcc1 != null)
{
FindDDC(dnbdata.dnb_dcc1);
}
//lbTitel.Items.Add(dnbdata.dnb_Autor_sort);
//lbTitel.Items.Add(dnbdata.dnb_Rolle);
//lbTitel.Items.Add(dnbdata.dnb_mitautor);
//lbTitel.Items.Add(dnbdata.dnb_mitautor_rolle);
}
private void Btn_close(object sender, RoutedEventArgs e)
{
_nr = cNR;
DialogResult = true;
}
