private void CheckAttendance_Load(object sender, EventArgs e)
{
string query = "select * from attendance where ID = '" + idee + "' ";
model.FeeCheck fd = new model.FeeCheck();
dataGridView1.DataSource = fd.datagrid(query);
}
private void ResultsStd_Load(object sender, EventArgs e)
{
string query = "select * from Result where ID = '" + identity + "' ";
model.FeeCheck fc = new model.FeeCheck();
dataGridView1.DataSource = fc.datagrid(query);
}
private void Attendance_Load(object sender, EventArgs e)
{
model.FeeCheck fc = new model.FeeCheck();
string query = "select * from attendance";
dataGridView1.DataSource = fc.datagrid(query);
}
private void StudentDetails_Load(object sender, EventArgs e)
{
model.FeeCheck fc = new model.FeeCheck();
string query = "select * from info where Role = '" + "Student" + "' ";
dataGridView1.DataSource = fc.datagrid(query);
}
private void FeesRecord_Load(object sender, EventArgs e)
{
model.FeeCheck fc = new model.FeeCheck();
string admin = "Admin";
string query = "select info.Name , fees.Jan , fees.Feb , fees.Mar , fees.Apr , fees.May , fees.Jun , fees.Jul , fees.Aug , fees.Sep , fees.Oct , fees.Nov , fees.Dec from info inner join fees on info.ID = fees.ID where fees.Role = '" + admin + "' ";
dataGridView1.DataSource = fc.datagrid(query);
}
public void Submit(FeeCheck s)
{
con.GetConnection();
con.ExecuteQuery("UPDATE fees set [Year]='" + s.year + "',[Role]='" + s.role + "',[Jan]='" + s.Jan + "',[Feb]='" + s.feb + "',[Mar]='" + s.mar + "',[Apr]='" + s.apr + "',[May]='" + s.may + "',[Jun]='" + s.jun + "',[Jul]='" + s.jul + "',[Aug]='" + s.aug + "',[Sep]='" + s.sep + "',[Oct]='" + s.oct + "',[Nov]='" + s.nov + "' and [Dec]='" + s.dec + "' where ID = '" + s.ID + "'");
}