private void createGraphic(object sender, RoutedEventArgs e) { if (listViewProjects.SelectedItem == null) { myMessageQueue.Enqueue(rm.GetString("selectRowToTakeAction"), rm.GetString("ok"), () => HandleOKMethod()); return; } VarsProjectsAll varsProjectsAll = (VarsProjectsAll)listViewProjects.SelectedItem; ReportsGraphic reportsGraphic = new ReportsGraphic(varsProjectsAll.id); reportsGraphic.Show(); }
private void createReport(object sender, RoutedEventArgs e) { if (listViewProjects.SelectedItem == null) { myMessageQueue.Enqueue(rm.GetString("selectRowToTakeAction"), rm.GetString("ok"), () => HandleOKMethod()); return; } int counter2 = countCheckBoxForReport2(); VarsProjectsAll varsProjectsAll = (VarsProjectsAll)listViewProjects.SelectedItem; if (localDbConnectionUnity.State == ConnectionState.Closed) { localDbConnectionUnity.Open(); } try { SqlCommand reportCommand = new SqlCommand("INSERT INTO Reports VALUES (@date)", localDbConnectionUnity); reportCommand.Parameters.AddWithValue("@date", Convert.ToDateTime(DateTime.Now.ToString("dd/MM/yyyy HH:mm:ss"))); reportCommand.ExecuteNonQuery(); SqlCommand commandProjectReport = new SqlCommand("SELECT dbo.countReports()", localDbConnectionUnity); reportDone.Content = (int)commandProjectReport.ExecuteScalar(); } catch { } localDbConnectionUnity.Close(); if (localDbConnection.State == ConnectionState.Closed) { localDbConnection.Open(); } SqlCommand command = new SqlCommand("SELECT dbo.getProjectDeviceType(@id)", localDbConnection); command.Parameters.AddWithValue("@id", varsProjectsAll.id); int type = int.Parse(command.ExecuteScalar().ToString()); localDbConnection.Close(); if (type == 1) { switch (countCheckBoxForReport1()) { case 0: myMessageQueue.Enqueue(rm.GetString("selectDataToReport"), rm.GetString("ok"), () => HandleOKMethod()); break; case 1: Report1 report1_1 = new Report1(varsProjectsAll.id, idList); report1_1.Show(); break; case 2: Report2 report1_2 = new Report2(varsProjectsAll.id, idList); report1_2.Show(); break; case 3: Report3 report1_3 = new Report3(varsProjectsAll.id, idList); report1_3.Show(); break; case 4: Report4 report1_4 = new Report4(varsProjectsAll.id, idList); report1_4.Show(); break; case 5: Report5 report1_5 = new Report5(varsProjectsAll.id, idList); report1_5.Show(); break; case 6: Report6 report1_6 = new Report6(varsProjectsAll.id, idList); report1_6.Show(); break; case 7: Report7 report1_7 = new Report7(varsProjectsAll.id, idList); report1_7.Show(); break; case 8: Report8 report1_8 = new Report8(varsProjectsAll.id, idList); report1_8.Show(); break; case 9: Report9 report1_9 = new Report9(varsProjectsAll.id, idList); report1_9.Show(); break; case 10: Report10 report1_10 = new Report10(varsProjectsAll.id, idList); report1_10.Show(); break; case 11: Report11 report1_11 = new Report11(varsProjectsAll.id, idList); report1_11.Show(); break; } } else { switch (countCheckBoxForReport2()) { case 0: myMessageQueue.Enqueue(rm.GetString("selectDataToReport"), rm.GetString("ok"), () => HandleOKMethod()); break; case 1: Report1 report1_1 = new Report1(varsProjectsAll.id, idList); report1_1.Show(); break; case 2: Report2 report1_2 = new Report2(varsProjectsAll.id, idList); report1_2.Show(); break; case 3: Report3 report1_3 = new Report3(varsProjectsAll.id, idList); report1_3.Show(); break; case 4: Report4 report1_4 = new Report4(varsProjectsAll.id, idList); report1_4.Show(); break; case 5: Report5 report1_5 = new Report5(varsProjectsAll.id, idList); report1_5.Show(); break; case 6: Report6 report1_6 = new Report6(varsProjectsAll.id, idList); report1_6.Show(); break; case 7: Report7 report1_7 = new Report7(varsProjectsAll.id, idList); report1_7.Show(); break; case 8: Report8 report1_8 = new Report8(varsProjectsAll.id, idList); report1_8.Show(); break; case 9: Report9 report1_9 = new Report9(varsProjectsAll.id, idList); report1_9.Show(); break; case 10: Report10 report1_10 = new Report10(varsProjectsAll.id, idList); report1_10.Show(); break; case 11: Report11 report1_11 = new Report11(varsProjectsAll.id, idList); report1_11.Show(); break; case 12: myMessageQueue.Enqueue(rm.GetString("maxRowToReport"), rm.GetString("ok"), () => HandleOKMethod()); break; case 13: myMessageQueue.Enqueue(rm.GetString("maxRowToReport"), rm.GetString("ok"), () => HandleOKMethod()); break; case 14: myMessageQueue.Enqueue(rm.GetString("maxRowToReport"), rm.GetString("ok"), () => HandleOKMethod()); break; case 15: myMessageQueue.Enqueue(rm.GetString("maxRowToReport"), rm.GetString("ok"), () => HandleOKMethod()); break; case 16: myMessageQueue.Enqueue(rm.GetString("maxRowToReport"), rm.GetString("ok"), () => HandleOKMethod()); break; } } }