public bool CheckDatabaseConnection()
{
if (File.Exists(databasePath) && Path.GetExtension(databasePath) == ".s3db")
{
try
{
toolStripStatusLabel1.Text = "Database OK";
comboBox1.Items.Clear();
comboBox2.Items.Clear();
foreach (string item in General.GetActivities(databasePath))
{
comboBox1.Items.Add(item);
}
foreach (string item in General.GetMentors(databasePath))
{
comboBox2.Items.Add(item);
}
General.GetAttendaceSummaryReports(databasePath);
return(true);
}
catch
{
toolStripStatusLabel1.Text = "ERROR, database cannot be loaded, try again";
return(false);
}
}
else
{
toolStripStatusLabel1.Text = "ERROR, database cannot be loaded, try again";
}
return(false);
}
private void listView1_DoubleClick(object sender, EventArgs e)
{
foreach (AttendanceReport attendanceReport in General.GetAttendaceSummaryReports(databasePath))
{
if (General.GetProfileByID(attendanceReport.ID, databasePath).name == listView1.SelectedItems[0].Text)
{
StudentInfoForm studentInfoForm = new StudentInfoForm(databasePath, attendanceReport);
studentInfoForm.Show();
return;
}
}
}
public void UpdateListview()
{
listView1.Items.Clear();
foreach (AttendanceReport attendanceReport in General.GetAttendaceSummaryReports(databasePath))
{
string[] arr = new string[7];
ListViewItem itm;
arr[0] = General.GetProfileByID(attendanceReport.ID, databasePath).name;
arr[1] = attendanceReport.dateTimeIN;
arr[2] = attendanceReport.deltaDateTime;
arr[3] = attendanceReport.dateTimeOUT;
arr[4] = attendanceReport.activity;
arr[5] = attendanceReport.mentor;
arr[6] = attendanceReport.index.ToString();
itm = new ListViewItem(arr);
listView1.Items.Add(itm);
}
}
private void StudentInfoForm_Load(object sender, EventArgs e)
{
label5.Text = General.GetProfileByID(attendanceReport.ID, databasePath).name;
label6.Text = attendanceReport.ID.ToString();
////////////////////////////////////////////////////// chart1
List <StringInt> activitys = new List <StringInt>();
DateTimeMy finalDateTime = new DateTimeMy(0, 0, 0, 0, 0, 0, DateTimeMy.PMorAM.NULL);
foreach (AttendanceReport temp_attendanceReport in General.GetAttendaceSummaryReports(databasePath))
{
if (attendanceReport.ID == temp_attendanceReport.ID)
{
finalDateTime = DateTimeMy.Add2DateTimes(finalDateTime, DateTimeMy.GetDateTimeFromString(temp_attendanceReport.deltaDateTime));
activitys.Add(new StringInt(temp_attendanceReport.activity, DateTimeMy.ConvertToSeconds(DateTimeMy.GetDateTimeFromString(temp_attendanceReport.deltaDateTime))));
}
}
label7.Text = finalDateTime.hours + "h " + finalDateTime.minutes + "m " + finalDateTime.seconds + "s";
List <StringInt> activitysAdded = new List <StringInt>();
foreach (StringInt activity in activitys)
{
if (!StringInt.Contains(activitysAdded, activity.string1))
{
activitysAdded.Add(new StringInt(activity.string1, 0));
}
}
for (int i = 0; i < activitysAdded.Count; i++)
{
foreach (StringInt activity in activitys)
{
if (activitysAdded[i].string1 == activity.string1)
{
activitysAdded[i] = new StringInt(activitysAdded[i].string1, activitysAdded[i].int1 + activity.int1);
}
}
}
foreach (StringInt activityAdded in activitysAdded)
{
System.Windows.Forms.DataVisualization.Charting.DataPoint dataPoint = new System.Windows.Forms.DataVisualization.Charting.DataPoint();
DateTimeMy dateTime = DateTimeMy.ConvertSeconds2DateTimeMy(activityAdded.int1);
dataPoint.LegendText = activityAdded.string1 + ": " + (int)((dateTime.days + dateTime.months * 30 + dateTime.years * 360) * 24) + "h " +
dateTime.minutes + "m " + dateTime.seconds + "s";
dataPoint.YValues = new double[] { Convert.ToDouble(activityAdded.int1) };
chart1.Series[0].Points.Add(dataPoint);
}
////////////////////////////////////////////////////// chart2
List <StringInt> mentors = new List <StringInt>();
DateTimeMy finalDateTimeMentor = new DateTimeMy(0, 0, 0, 0, 0, 0, DateTimeMy.PMorAM.NULL);
foreach (AttendanceReport temp_attendanceReport in General.GetAttendaceSummaryReports(databasePath))
{
if (attendanceReport.ID == temp_attendanceReport.ID)
{
finalDateTimeMentor = DateTimeMy.Add2DateTimes(finalDateTimeMentor, DateTimeMy.GetDateTimeFromString(temp_attendanceReport.deltaDateTime));
mentors.Add(new StringInt(temp_attendanceReport.mentor, DateTimeMy.ConvertToSeconds(DateTimeMy.GetDateTimeFromString(temp_attendanceReport.deltaDateTime))));
}
}
List <StringInt> mentorsAdded = new List <StringInt>();
foreach (StringInt mentor in mentors)
{
if (!StringInt.Contains(mentorsAdded, mentor.string1))
{
mentorsAdded.Add(new StringInt(mentor.string1, 0));
}
}
for (int i = 0; i < mentorsAdded.Count; i++)
{
foreach (StringInt mentor in mentors)
{
if (mentorsAdded[i].string1 == mentor.string1)
{
mentorsAdded[i] = new StringInt(mentorsAdded[i].string1, mentorsAdded[i].int1 + mentor.int1);
}
}
}
foreach (StringInt mentorAdded in mentorsAdded)
{
System.Windows.Forms.DataVisualization.Charting.DataPoint dataPoint = new System.Windows.Forms.DataVisualization.Charting.DataPoint();
DateTimeMy dateTime = DateTimeMy.ConvertSeconds2DateTimeMy(mentorAdded.int1);
dataPoint.LegendText = mentorAdded.string1 + ": " + (int)((dateTime.days + dateTime.months * 30 + dateTime.years * 360) * 24) + "h " +
dateTime.minutes + "m " + dateTime.seconds + "s";
dataPoint.YValues = new double[] { Convert.ToDouble(mentorAdded.int1) };
chart2.Series[0].Points.Add(dataPoint);
}
}
