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