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