public void Attendance_Insertion()
{
ATT_Marker = new Attendance_Work();
if (Combo_Loader.Text == "Primary-Students")
{
foreach (DataGridViewRow each_row in Data_View.Rows)
{
for (int i = 1; i < each_row.Cells.Count - 1; i++)
{
string Querry = "Insert into PrimaryStdAttendance([Date],[Name],[Status],[Type],[Type_ID]) values ('" + Date + "', '" + each_row.Cells[0].Value + "', '" + each_row.Cells[1].Value + "', '" + each_row.Cells[2].Value + "', '" + each_row.Cells[3].Value + "')";
ATT_Marker.ATT(Querry);
break;
}
}
}
else if (Combo_Loader.Text == "Secondary-Students")
{
foreach (DataGridViewRow each_row in Data_View.Rows)
{
for (int i = 1; i < each_row.Cells.Count - 1; i++)
{
string Querry = "Insert into SecondaryStdAttendance([Date],[Name],[Status],[Type],[Type_ID]) values ('" + Date + "', '" + each_row.Cells[0].Value + "', '" + each_row.Cells[1].Value + "', '" + each_row.Cells[2].Value + "', '" + each_row.Cells[3].Value + "')";
ATT_Marker.ATT(Querry);
break;
}
}
}
else if (Combo_Loader.Text == "Senior-Students")
{
foreach (DataGridViewRow each_row in Data_View.Rows)
{
for (int i = 1; i < each_row.Cells.Count - 1; i++)
{
string Querry = "Insert into SeniorStdAttendance([Date],[Name],[Status],[Type],[Type_ID]) values ('" + Date + "', '" + each_row.Cells[0].Value + "', '" + each_row.Cells[1].Value + "', '" + each_row.Cells[2].Value + "', '" + each_row.Cells[3].Value + "')";
ATT_Marker.ATT(Querry);
break;
}
}
}
MessageBox.Show("Attendance Data Saved!!!");
}
public void Attendance_Insertion()
{
ATT_Marker = new Attendance_Work();
foreach (DataGridViewRow each_row in Data_Shower.Rows)
{
for (int i = 1; i < each_row.Cells.Count - 1; i++)
{
string Querry = "Insert into StaffsAttendance([Date],[Name],[Status],[Type],[Type_ID]) values ('" + Date + "', '" + each_row.Cells[0].Value + "', '" + each_row.Cells[1].Value + "', '" + each_row.Cells[2].Value + "', '" + each_row.Cells[3].Value + "')";
ATT_Marker.ATT(Querry);
break;
}
}
MessageBox.Show("Attendance Data Saved!!!");
}
