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();
}
}
public void moveItems(String to)
{
if (toBeDeleted.Count == 0)
{
MessageBox.Show("Nothing selected to be moved!");
return;
}
foreach (Button n in toBeDeleted)
{
String[] names = n.Tag.ToString().Split(',');
SQLMan.deleteFromTable(names[0], names[1], names[2], names[3], names[4]);
mainGrid.Children.Remove(n);
}
GenerateList();
SQLMan.OpenTable(to);
foreach (Button n in toBeDeleted)
{
String[] names = n.Tag.ToString().Split(',');
SQLMan.insertFromForm(names[0], names[1], names[2], names[3], names[4]);
}
SQLMan.OpenTable(currGrp);
toBeDeleted.Clear();
GenerateList();
}
private void save_Click(object sender, RoutedEventArgs e)
{
SQLMan.deleteFromTable(comp, pos, dat, req, oth);
SQLMan.insertFromForm(Company.Text, Position.Text, Date_of_App.Text, Requisition_ID.Text, Addition_Info.Text);
this.Close();
}
private void save_Click(object sender, RoutedEventArgs e)
{
SQLMan.insertFromForm(Company_Name, Position_Name, Date_Text, Req_ID_Text, Additional_Text);
this.Close();
}
