public void ImportFileClick() { Microsoft.Win32.OpenFileDialog dlg = new Microsoft.Win32.OpenFileDialog(); dlg.Filter = "CSV Files (.csv)|*.csv"; Nullable <bool> result = dlg.ShowDialog(); if (result == true) { string filename = dlg.FileName; if (filename.Contains(".csv")) { foreach (QueryData n in (importReadFile(filename))) { SQLMan.insertFromForm(n.company, n.position, n.date, n.reqid, n.other); } } else { MessageBox.Show("Invalid file format! Try Again."); return; } GroupListScreen newGroup = new GroupListScreen(SQLMan, importfilename); newGroup.ShowDialog(); mainW.refreshList(); } }
private void mgForm_Closed(object sender, EventArgs e) { if (!mD.isSave) { return; } String mFrom = mD.MergeFrom.Text; String mTo = mD.MergeTo.Text; try { SQLMan.moveItems(mFrom, mTo); } catch (System.Data.SQLite.SQLiteException) { MessageBox.Show("One or more invalid groups!"); return; } foreach (QueryData n in (SQLMan.getData())) { Console.WriteLine(n.company); } SQLMan.deleteTable(mFrom); GroupListScreen newGroup = new GroupListScreen(SQLMan, mTo); newGroup.ShowDialog(); mainW.refreshList(); }
private void openGroupClick(object sender, RoutedEventArgs e) { if (GroupListScreen.IsOpen) { return; } MenuItem mItem = sender as MenuItem; GroupListScreen gLS = new GroupListScreen(SQLMan, mItem.Header.ToString()); gLS.ShowDialog(); }
private void ngForm_Closed(object sender, EventArgs e) { if (!nD.isSave) { return; } String name = nD.ResponseBlock.Text; if (name == "") { MessageBox.Show("Name box empty!"); return; } SQLMan.CreateTable(name); GroupListScreen newGroup = new GroupListScreen(SQLMan, name); newGroup.ShowDialog(); mainW.refreshList(); }
public GroupItemManagement(SQLiteManager SQLman, GroupListScreen window) { SQLMan = SQLman; }
public MenuBar(SQLiteManager SQLman, GroupListScreen GLSMain) { SQLMan = SQLman; glsmain = GLSMain; }