private void Window_Loaded(object sender, RoutedEventArgs e) { pa = new ProjectsAccess(); researchProjectViewSource = ((CollectionViewSource)(FindResource("researchProjectViewSource"))); //load data UpdateContext(); }
private void confirmButton_Click(object sender, RoutedEventArgs e) { TextBox userPass = (TextBox)FindName("passwordText"); if (userPass.Text == pass) { ProjectsAccess pa = new ProjectsAccess(); pa.RemoveAllProjects(); pa.CloseStorage(); } else { //display window saying pw incorrect IncorrectPassWindow pw = new IncorrectPassWindow(); pw.Show(); } this.Close(); }
internal void CreateReport(bool leaveOpen) { ProjectsAccess pa = new ProjectsAccess(); List <ResearchProject> Projects = pa.GetProjectsList(); Word._Application _app = new Word.Application(); if (leaveOpen) { _app.Visible = true; } object missing = Type.Missing; Word.Document doc = _app.Documents.Add(ref missing, ref missing, ref missing, ref missing); Word.Paragraph currentParagraph = doc.Paragraphs.Add(ref missing); currentParagraph.Range.Text = "Independent Investigator Profiles"; object styleHeading = "Heading 1"; currentParagraph.set_Style(ref styleHeading); currentParagraph.Range.InsertParagraphAfter(); foreach (ResearchProject proj in Projects) { currentParagraph.SpaceBefore = 0f; currentParagraph.SpaceAfter = 0f; currentParagraph.Range.Text = String.Format(projectFormatString, proj.Investigators, proj.CoInvestigators, proj.ProjectTitle, proj.Objectives, proj.Methods, proj.Results, proj.Conclusions, proj.FutureStudies); currentParagraph.Range.InsertParagraphAfter(); } if (!leaveOpen) { object file_name = AppDomain.CurrentDomain.BaseDirectory + "test.docx"; object file_type = Word.WdSaveFormat.wdFormatDocumentDefault; doc.SaveAs(ref file_name, ref file_type, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing); object save_changes = false; doc.Close(ref save_changes, ref missing, ref missing); _app.Quit(ref save_changes, ref missing, ref missing); } pa.CloseStorage(); }
private void GetAccess(object sender, EventArgs e) { pa = new ProjectsAccess(); }