private void button8_Click(object sender, EventArgs e) { S_Attendance_GV h = new S_Attendance_GV(); this.Hide(); h.Show(); }
private void button3_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Data Source=DESKTOP-OQV6IBM;Initial Catalog=ProjectB;Integrated Security=True"); conn.Open(); string query = "Insert into ClassAttendance (AttendanceDate) OUTPUT INSERTED.Id values('" + DateTime.Now + "')"; SqlCommand command = new SqlCommand(query, conn); int attendence_id = (int)command.ExecuteScalar(); if (comboBox1.Text != "" && comboBox2.Text != "") { if (button3.Text == "AddAttendance") { int status = 1; if (comboBox2.Text == "Absent") { status = 2; } else if (comboBox2.Text == "Late") { status = 4; } else if (comboBox2.Text == "Leave") { status = 3; } string STDID = (comboBox1.SelectedItem as ComboboxItem).Value.ToString(); string Query = "insert into StudentAttendance(StudentId, AttendanceStatus, AttendanceId) values('" + STDID + "','" + status + "','" + attendence_id + "')"; SqlCommand cmd = new SqlCommand(Query, conn); cmd.ExecuteNonQuery(); MessageBox.Show("Attendance Successfully Added"); S_Attendance_GV f = new S_Attendance_GV(); f.Show(); this.Hide(); } } else { MessageBox.Show("Please fill all the fields "); } }