/// <summary>
/// This function used to insert the Attendence Record in ClassAttendance List
/// </summary>
/// <param name="query">Query to retrieve the data from database</param>
public void AttendenceRecord(string query)
{
try
{
SqlCommand command = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader;
reader = command.ExecuteReader();
if (reader.HasRows)
{
ListofClasses Lt1 = new ListofClasses();
Lt1.CA1.Clear();
while (reader.Read())
{
ClassAttendence Ca = new ClassAttendence();
Ca.Id1 = Convert.ToInt32(reader[0]);
Ca.AttendenceDate1 = Convert.ToDateTime(reader[1]);
Lt1.addIntoAttendence(Ca);
}
}
}
catch (Exception ex)
{
throw (ex);
}
finally
{
conn.Close();
}
}
private void Save_Click(object sender, EventArgs e)
{
ClassAttendence CA = new ClassAttendence();
CA.Edit(globalindex, AttendenceDatepicker.Value);
AttendenceDatepicker.ResetText();
Attendence_Load(sender, e);
}
private void Attendence_Load(object sender, EventArgs e)
{
if (Save.Visible)
{
Save.Visible = false;
}
ClassAttendence CA = new ClassAttendence();
ListofClasses lt1 = new ListofClasses();
CA.ATTendenceRecord();
ClassAttendenceRecord.DataSource = null;
ClassAttendenceRecord.DataSource = lt1.CA1;
}
private void ADD_Click(object sender, EventArgs e)
{
try
{
ClassAttendence CA = new ClassAttendence();
CA.ADDAttendence(AttendenceDatepicker.Value);
MessageBox.Show("Data has been added successfully");
AttendenceDatepicker.ResetText();
Attendence_Load(sender, e);
}
catch (Exception ex)
{
MessageBox.Show("please enter valid data,Dat insert fail");
}
}
private void ClassAttendenceRecord_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
ClassAttendence CA = new ClassAttendence();
ListofClasses lt = new ListofClasses();
int index = ClassAttendenceRecord.CurrentCell.RowIndex;
DataGridViewRow r = ClassAttendenceRecord.Rows[index];
int id = Convert.ToInt32(r.Cells[0].Value);
if (ClassAttendenceRecord.Columns[e.ColumnIndex].Name == "Delete")
{
DialogResult result = MessageBox.Show("Do You Want to delete?" + id, "Delete", MessageBoxButtons.OKCancel, MessageBoxIcon.Information);
if (result.Equals(DialogResult.OK))
{
CA.Delete(id);
MessageBox.Show("Data has been deleted successfully");
Attendence_Load(sender, e);
MessageBox.Show("id of the selested row is" + id);
}
else
{
return;
}
}
if (ClassAttendenceRecord.Columns[e.ColumnIndex].Name == "Edit")
{
AttendenceDatepicker.Value = Convert.ToDateTime(r.Cells[1].Value);
globalindex = id;
if (ADD.Visible)
{
ADD.Visible = false;
}
if (Save.Visible == false)
{
Save.Visible = true;
}
}
if (ClassAttendenceRecord.Columns[e.ColumnIndex].Name == "StudentAttendence")
{
globalindex = id;
}
}
/// <summary>
/// This function used to Add tne Attendence in the ClassAttemndence
/// </summary>
/// <param name="st">Object of type ClassAttendence</param>
public void addIntoAttendence(ClassAttendence st)
{
CA.Add(st);
}
