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!!!"); }