Advertisement
Guest User

Untitled

a guest
Jan 21st, 2018
59
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.51 KB | None | 0 0
  1. private void Stats()
  2. {
  3. String date1 = textBox1.Text;
  4. String date2 = textBox2.Text;
  5. List<string> minutes = new List<string>();
  6. List<string> DayOfWeek = new List<string>();
  7. String temporary;
  8. int number = 0;
  9.  
  10. int count;
  11. date1 = date1.Substring(6, 4) + "-" + date1.Substring(3, 2) + "-" + date1.Substring(0, 2);
  12. date2 = date2.Substring(6, 4) + "-" + date2.Substring(3, 2) + "-" + date2.Substring(0, 2);
  13. String query = String.Format("SELECT dayOfWeek, minutes FROM statLog WHERE (date BETWEEN '{0}' AND '{1}') ", date1, date2);
  14.  
  15. MySqlCommand cmd = new MySqlCommand(query, dbConn);
  16. dbConn.Open();
  17. MySqlDataReader reader = cmd.ExecuteReader();
  18. while (reader.Read())
  19. {
  20. number = (Int32.Parse(reader["dayOfWeek"].ToString()));
  21. switch (number)
  22. {
  23. case 1:
  24. temporary = minutes.ElementAt(0);
  25. temporary = minutes.ElementAt(0) + reader["minutes"].ToString();
  26. minutes[0] = temporary;
  27. break;
  28. case 2:
  29. temporary = minutes.ElementAt(1);
  30. temporary = minutes.ElementAt(1) + reader["minutes"].ToString();
  31. minutes[1] = temporary;
  32. break;
  33. case 3:
  34. temporary = minutes.ElementAt(2);
  35. temporary = minutes.ElementAt(2) + reader["minutes"].ToString();
  36. minutes[2] = temporary;
  37. break;
  38. case 4:
  39. temporary = minutes.ElementAt(3);
  40. temporary = minutes.ElementAt(3) + reader["minutes"].ToString();
  41. minutes[3] = temporary;
  42. break;
  43. case 5:
  44. temporary = minutes.ElementAt(4);
  45. temporary = minutes.ElementAt(4) + reader["minutes"].ToString();
  46. minutes[4] = temporary;
  47. break;
  48. case 6:
  49. temporary = minutes.ElementAt(5);
  50. temporary = minutes.ElementAt(5) + reader["minutes"].ToString();
  51. minutes[5] = temporary;
  52. break;
  53. case 7:
  54. temporary = minutes.ElementAt(6);
  55. temporary = minutes.ElementAt(6) + reader["minutes"].ToString();
  56. minutes[6] = temporary;
  57. break;
  58. }
  59.  
  60. }
  61. dbConn.Close();
  62.  
  63. Dictionary<string, int> DaysOfWeek = new Dictionary<string, int>();
  64.  
  65. DaysOfWeek.Add("Pn", Int32.Parse(minutes.ElementAt(0)));
  66. DaysOfWeek.Add("Wt", Int32.Parse(minutes.ElementAt(1)));
  67. DaysOfWeek.Add("Śr", Int32.Parse(minutes.ElementAt(2)));
  68. DaysOfWeek.Add("Cz", Int32.Parse(minutes.ElementAt(3)));
  69. DaysOfWeek.Add("Pi", Int32.Parse(minutes.ElementAt(4)));
  70. DaysOfWeek.Add("So", Int32.Parse(minutes.ElementAt(5)));
  71. DaysOfWeek.Add("Nd", Int32.Parse(minutes.ElementAt(6)));
  72.  
  73. foreach (KeyValuePair<string, int> days in DaysOfWeek)
  74. chart1.Series[0].Points.AddXY(days.Key, days.Value);
  75. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement