private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
int ID = Convert.ToInt32(GridAttendance.Rows[e.RowIndex].Cells[0].Value);
var element = GridAttendance.Columns["Delete"].Index;
var update = GridAttendance.Columns["Update"].Index;
if (e.ColumnIndex == element)
{
string cmd = String.Format("DELETE FROM StudentAttendance WHERE AttendanceId = @id");
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@id", ID));
conn.Open();
SqlDataReader reader = command.ExecuteReader();
conn.Close();
conn.Open();
cmd = String.Format("DELETE FROM ClassAttendance WHERE Id = @id1");
command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@id1", ID));
reader = command.ExecuteReader();
conn.Close();
cmd = "SELECT * FROM ClassAttendance";
command = new SqlCommand(cmd, conn);
conn.Open();
reader = command.ExecuteReader();
SqlDataAdapter adapter = new SqlDataAdapter(cmd, conn);
DataTable table = new DataTable();
adapter.Fill(table);
GridAttendance.DataSource = table;
conn.Close();
}
else if (e.ColumnIndex == GridAttendance.Columns["Update"].Index)
{
lblHide.Hide();
var item = GridAttendance.Rows[e.RowIndex].Cells[0].Value;
string cmd = String.Format("SELECT * FROM ClassAttendance WHERE Id = @item");
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@item", item));
conn.Open();
SqlDataReader reader = command.ExecuteReader();
Student s = new Student();
btnAddAttendance.Text = "Update Attendance";
while (reader.Read())
{
lblHide.Text = Convert.ToString(reader[0]);
string d = Convert.ToString(reader[1]);
DateTime date = Convert.ToDateTime(d);
AttendanceMarking.SetDate(date);
}
TabPageAddClassAttendance.Show();
conn.Close();
}
}
private void btnAddAttendance_Click(object sender, EventArgs e)
{
if (btnAddAttendance.Text == "Add Attendance")
{
conn.Open();
String cmd = String.Format("INSERT INTO ClassAttendance(AttendanceDate) values('{0}')", this.AttendanceMarking.SelectionEnd.Date);
SqlCommand command = new SqlCommand(cmd, conn);
SqlDataReader reader = command.ExecuteReader();
MessageBox.Show("Added Successfully");
conn.Close();
}
else
{
//Update ClassAttendance Set AttendanceDate = '" + Attendencepick.SelectionEnd.Date + "' where Id = '" + id + "' ";
string cmd = String.Format("UPDATE ClassAttendance SET AttendanceDate = @date WHERE Id = @ID");
SqlCommand command = new SqlCommand(cmd, conn);
command.Parameters.Add(new SqlParameter("@date", AttendanceMarking.SelectionEnd.Date));
command.Parameters.Add(new SqlParameter("@ID", Convert.ToInt32(lblHide.Text)));
conn.Open();
SqlDataReader reader = command.ExecuteReader();
conn.Close();
btnAddAttendance.Text = "Add Attendance";
TabPageAddClassAttendance.Hide();
TabPageViewClassAttendance.Show();
cmd = "SELECT * FROM ClassAttendance";
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);
GridAttendance.DataSource = table;
conn.Close();
}
}
