private void GridStudentAttendance_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int AttendanceID = Convert.ToInt32(GridStudentAttendance.Rows[e.RowIndex].Cells[0].Value);
int StudentId = Convert.ToInt32(GridStudentAttendance.Rows[e.RowIndex].Cells[1].Value);
int AttendanceStatus = Convert.ToInt32(GridStudentAttendance.Rows[e.RowIndex].Cells[2].Value);
var element = GridStudentAttendance.Columns["Delete"].Index;
var update = GridStudentAttendance.Columns["Update"].Index;
if (e.ColumnIndex == element)
{
string cmd = String.Format("DELETE FROM StudentAttendance WHERE StudentId = @StudentId AND AttendanceId = @AttendanceId");
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@StudentId", StudentId));
command.Parameters.Add(new SqlParameter("@AttendanceId", AttendanceID));
conn.Open();
SqlDataReader reader = command.ExecuteReader();
conn.Close();
cmd = "SELECT * FROM StudentAttendance";
command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("0", 1));
conn.Open();
reader = command.ExecuteReader();
SqlDataAdapter adapter = new SqlDataAdapter(cmd, conn);
DataTable table = new DataTable();
adapter.Fill(table);
GridStudentAttendance.DataSource = table;
conn.Close();
}
else if (e.ColumnIndex == GridStudentAttendance.Columns["Update"].Index)
{
lblHide.Hide();
var item = GridStudentAttendance.Rows[e.RowIndex].Cells[0].Value;
string cmd = String.Format("SELECT * FROM StudentAttendance WHERE AttendanceId = @AttendanceId AND StudentId = @StudentId AND AttendanceStatus = @AttendanceStatus");
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@AttendanceId", AttendanceID));
command.Parameters.Add(new SqlParameter("@StudentId", StudentId));
command.Parameters.Add(new SqlParameter("@AttendanceStatus", AttendanceStatus));
conn.Open();
SqlDataReader reader = command.ExecuteReader();
Student s = new Student();
btnAddStudentAttendance.Text = "Update Student Attendance";
while (reader.Read())
{
cmbattendanceID.Text = Convert.ToString(reader[0]);
cmbStudentId.Text = Convert.ToString(reader[1]);
cmbAttendanceStatus.Text = Convert.ToString(reader[2]);
}
TabPageAddStudenAttendance.Show();
conn.Close();
}
}
private void btnAddStudentAttendance_Click(object sender, EventArgs e)
{
bool isValidAttendanceId = isDigit(cmbattendanceID.Text);
bool isvalidAttendanceStatus = isDigit(cmbAttendanceStatus.Text);
bool isvalidStudentId = isDigit(cmbStudentId.Text);
if (btnAddStudentAttendance.Text == "Add Student Attendance")
{
if (isValidAttendanceId && isvalidAttendanceStatus && isvalidStudentId)
{
conn.Open();
String cmd = String.Format("INSERT INTO StudentAttendance(AttendanceId, StudentId, AttendanceStatus) values('{0}','{1}','{2}')", Convert.ToInt32(cmbattendanceID.Text), Convert.ToInt32(cmbStudentId.Text), Convert.ToInt32(cmbAttendanceStatus.Text));
SqlCommand command = new SqlCommand(cmd, conn);
SqlDataReader reader = command.ExecuteReader();
cmbattendanceID.Text = "";
cmbAttendanceStatus.Text = "";
cmbStudentId.Text = "";
MessageBox.Show("Added Successfully");
conn.Close();
}
else
{
if (isValidAttendanceId == false)
{
MessageBox.Show("Invalid Attendance Id");
}
if (isvalidAttendanceStatus == false)
{
MessageBox.Show("Invalid Attendance Status");
}
if (isvalidStudentId == false)
{
MessageBox.Show("Invalid Student Id");
}
}
}
else
{
if (isValidAttendanceId && isvalidAttendanceStatus && isvalidStudentId)
{
//int att_id = 0;
//int lookid = 0;
//int sid = 0;
//string reg_no = null;
//string status = null;
//string att_date = null;
//int update_student = 0;
//int update_attendance = 0;
//int update_lookup = 0;
//string query1 = "SELECT Id FROM Student WHERE RegistrationNumber = '" + cmbStudentId.Text + "'";
//SqlCommand cmdDataBase1 = new SqlCommand(query1, conn);
//SqlDataReader myreader1;
//conn.Open();
//cmdDataBase1.Parameters.Add(new SqlParameter("0", 1));
//myreader1 = cmdDataBase1.ExecuteReader();
//while (myreader1.Read())
//{
// update_student = Convert.ToInt32(myreader1[0]);
//}
//string query = "SELECT LookupId FROM Lookup WHERE Name = '" + cmbAttendanceStatus.Text + "'";
//SqlCommand cmdDataBase2 = new SqlCommand(query, conn);
//SqlDataReader myreader2;
////constring.Open();
//cmdDataBase2.Parameters.Add(new SqlParameter("0", 1));
//myreader2 = cmdDataBase2.ExecuteReader();
//while (myreader2.Read())
//{
// update_lookup = Convert.ToInt32(myreader2[0]);
//}
//string d = cmbattendanceID.Text;
//DateTime d1 = Convert.ToDateTime(d);
//DateTime d2 = d1.Date;
//string query3 = "SELECT Id FROM ClassAttendance WHERE AttendanceDate = '" + d1 + "'";
//SqlCommand cmdDataBase3 = new SqlCommand(query3, conn);
//SqlDataReader myreader3;
////constring.Open();
//cmdDataBase3.Parameters.Add(new SqlParameter("0", 1));
//myreader3 = cmdDataBase3.ExecuteReader();
//while (myreader3.Read())
//{
// update_attendance = Convert.ToInt32(myreader3[0]);
//}
////constring.Open();
//string Qeury = "Update StudentAttendance Set AttendanceId ='" + update_attendance + "',StudentId ='" + update_student + "',AttendanceStatus ='" + update_lookup + "' Where AttendanceId ='" + att_id + "' AND StudentId ='" + sid + "' ";
//SqlCommand cmd = new SqlCommand(Qeury, conn);
//cmd.ExecuteNonQuery();
//MessageBox.Show("Attendance Updated");
////constring.Close();
//String query8 = "SELECT * FROM StudentAttendance";
//SqlCommand c = new SqlCommand(query8, conn);
//c.Parameters.Add(new SqlParameter("0", 1));
////constring.Open();
//SqlDataReader reader = c.ExecuteReader();
//SqlDataAdapter adapter = new SqlDataAdapter(query8, conn);
//DataTable view = new DataTable();
//adapter.Fill(view);
//GridStudentAttendance.DataSource = view;
//conn.Close();
conn.Open();
string cmd = String.Format("UPDATE StudentAttendance SET AttendanceStatus = @AttendanceStatus WHERE AttendanceId = @AttendanceId AND StudentId = @StudentId");
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@AttendanceId", Convert.ToInt32(cmbattendanceID.Text)));
command.Parameters.Add(new SqlParameter("@StudentId", Convert.ToInt32(cmbStudentId.Text)));
command.Parameters.Add(new SqlParameter("@AttendanceStatus", Convert.ToInt32(cmbAttendanceStatus.Text)));
//command.Parameters.Add(new SqlParameter("@ID", Convert.ToInt32(lblHide.Text)));
SqlDataReader reader = command.ExecuteReader();
cmbattendanceID.Text = "";
cmbAttendanceStatus.Text = "";
cmbStudentId.Text = "";
conn.Close();
btnAddStudentAttendance.Text = "Add Student Attendance";
TabPageAddStudenAttendance.Hide();
TabPageViewAttendance.Show();
cmd = "SELECT * FROM StudentAttendance";
command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("0", 1));
conn.Open();
reader = command.ExecuteReader();
SqlDataAdapter adapter = new SqlDataAdapter(cmd, conn);
DataTable table = new DataTable();
adapter.Fill(table);
GridStudentAttendance.DataSource = table;
conn.Close();
}
else
{
if (isValidAttendanceId == false)
{
MessageBox.Show("Invalid Attendance Id");
}
if (isvalidAttendanceStatus == false)
{
MessageBox.Show("Invalid Attendance Status");
}
if (isvalidStudentId == false)
{
MessageBox.Show("Invalid Student Id");
}
}
}
}
