public static int ConvertToSeconds(DateTimeMy dateTime)
{
int seconds = 0;
seconds += dateTime.seconds + dateTime.minutes * 60 + dateTime.hours * 3600 + dateTime.days * 86400 + dateTime.months * 2592000 + dateTime.years * 31104000;
return(seconds);
}
public static DateTimeMy Add2DateTimes(DateTimeMy dateTime1, DateTimeMy dateTime2)
{
int finalSeconds = 0;
int finalMinutes = 0;
int finalHours = 0;
int finalDays = 0;
int finalMonths = 0;
int finalYears = 0;
finalSeconds = dateTime1.seconds + dateTime2.seconds;
if (finalSeconds >= 60)
{
finalSeconds -= 60;
finalMinutes++;
}
finalMinutes += dateTime1.minutes + dateTime2.minutes;
if (finalMinutes >= 60)
{
finalMinutes -= 60;
finalHours++;
}
finalHours += dateTime1.hours + dateTime2.hours;
if (finalHours >= 24)
{
finalHours -= 24;
finalDays++;
}
finalDays += dateTime1.days + dateTime2.days;
if (finalDays >= 30)
{
finalDays -= 30;
finalMonths++;
}
finalMonths += dateTime1.months + dateTime2.months;
if (finalMonths >= 12)
{
finalMonths -= 12;
finalYears++;
}
finalYears += dateTime1.years + dateTime2.years;
return new DateTimeMy(finalSeconds, finalMinutes, finalHours, finalDays, finalMonths, finalYears, PMorAM.NULL);
}
public static DateTimeMy Add2DateTimes(DateTimeMy dateTime1, DateTimeMy dateTime2)
{
int finalSeconds = 0;
int finalMinutes = 0;
int finalHours = 0;
int finalDays = 0;
int finalMonths = 0;
int finalYears = 0;
finalSeconds = dateTime1.seconds + dateTime2.seconds;
if (finalSeconds >= 60)
{
finalSeconds -= 60;
finalMinutes++;
}
finalMinutes += dateTime1.minutes + dateTime2.minutes;
if (finalMinutes >= 60)
{
finalMinutes -= 60;
finalHours++;
}
finalHours += dateTime1.hours + dateTime2.hours;
if (finalHours >= 24)
{
finalHours -= 24;
finalDays++;
}
finalDays += dateTime1.days + dateTime2.days;
if (finalDays >= 30)
{
finalDays -= 30;
finalMonths++;
}
finalMonths += dateTime1.months + dateTime2.months;
if (finalMonths >= 12)
{
finalMonths -= 12;
finalYears++;
}
finalYears += dateTime1.years + dateTime2.years;
return(new DateTimeMy(finalSeconds, finalMinutes, finalHours, finalDays, finalMonths, finalYears, PMorAM.NULL));
}
public static int ConvertToSeconds(DateTimeMy dateTime)
{
int seconds = 0;
seconds += dateTime.seconds + dateTime.minutes * 60 + dateTime.hours * 3600 + dateTime.days * 86400 + dateTime.months * 2592000 + dateTime.years * 31104000;
return seconds;
}
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);
}
}
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);
}
}
