Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private void Stats()
- {
- String date1 = textBox1.Text;
- String date2 = textBox2.Text;
- List<string> minutes = new List<string>();
- List<string> DayOfWeek = new List<string>();
- String temporary;
- int number = 0;
- int count;
- date1 = date1.Substring(6, 4) + "-" + date1.Substring(3, 2) + "-" + date1.Substring(0, 2);
- date2 = date2.Substring(6, 4) + "-" + date2.Substring(3, 2) + "-" + date2.Substring(0, 2);
- String query = String.Format("SELECT dayOfWeek, minutes FROM statLog WHERE (date BETWEEN '{0}' AND '{1}') ", date1, date2);
- MySqlCommand cmd = new MySqlCommand(query, dbConn);
- dbConn.Open();
- MySqlDataReader reader = cmd.ExecuteReader();
- while (reader.Read())
- {
- number = (Int32.Parse(reader["dayOfWeek"].ToString()));
- switch (number)
- {
- case 1:
- temporary = minutes.ElementAt(0);
- temporary = minutes.ElementAt(0) + reader["minutes"].ToString();
- minutes[0] = temporary;
- break;
- case 2:
- temporary = minutes.ElementAt(1);
- temporary = minutes.ElementAt(1) + reader["minutes"].ToString();
- minutes[1] = temporary;
- break;
- case 3:
- temporary = minutes.ElementAt(2);
- temporary = minutes.ElementAt(2) + reader["minutes"].ToString();
- minutes[2] = temporary;
- break;
- case 4:
- temporary = minutes.ElementAt(3);
- temporary = minutes.ElementAt(3) + reader["minutes"].ToString();
- minutes[3] = temporary;
- break;
- case 5:
- temporary = minutes.ElementAt(4);
- temporary = minutes.ElementAt(4) + reader["minutes"].ToString();
- minutes[4] = temporary;
- break;
- case 6:
- temporary = minutes.ElementAt(5);
- temporary = minutes.ElementAt(5) + reader["minutes"].ToString();
- minutes[5] = temporary;
- break;
- case 7:
- temporary = minutes.ElementAt(6);
- temporary = minutes.ElementAt(6) + reader["minutes"].ToString();
- minutes[6] = temporary;
- break;
- }
- }
- dbConn.Close();
- Dictionary<string, int> DaysOfWeek = new Dictionary<string, int>();
- DaysOfWeek.Add("Pn", Int32.Parse(minutes.ElementAt(0)));
- DaysOfWeek.Add("Wt", Int32.Parse(minutes.ElementAt(1)));
- DaysOfWeek.Add("Śr", Int32.Parse(minutes.ElementAt(2)));
- DaysOfWeek.Add("Cz", Int32.Parse(minutes.ElementAt(3)));
- DaysOfWeek.Add("Pi", Int32.Parse(minutes.ElementAt(4)));
- DaysOfWeek.Add("So", Int32.Parse(minutes.ElementAt(5)));
- DaysOfWeek.Add("Nd", Int32.Parse(minutes.ElementAt(6)));
- foreach (KeyValuePair<string, int> days in DaysOfWeek)
- chart1.Series[0].Points.AddXY(days.Key, days.Value);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement