private void btnSearch_Click(object sender, EventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
Student s = new Student();
if (!txtSN.Text.Trim().Equals(""))
{
dgvStudent.DataSource = s.SearchStudentsById(txtSN.Text.Trim());
}
else if (!txtLastName.Text.Trim().Equals(""))
{
dgvStudent.DataSource = s.SearchStudentsByLastName(txtLastName.Text.Trim());
}
dgvStudent.Columns[0].Width = 120;
dgvStudent.Columns[1].Width = 120;
dgvStudent.Columns[2].Width = 120;
dgvStudent.Columns[3].Width = 120;
dgvStudent.Columns[4].Width = 75;
dgvStudent.Columns[5].Width = 50;
Cursor.Current = Cursors.Default;
if (dgvStudent.Rows.Count == 0)
{
throw new Exception("Student not found.");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
try
{
Cursor.Current = Cursors.WaitCursor;
txtBal.Text = 0.ToString("N2");
dgvBalance.DataSource = null;
dgvBalance.Rows.Clear();
Student s = new Student();
if (!txtSN.Text.Trim().Equals(""))
{
dgvStudent.DataSource = s.SearchStudentsById(txtSN.Text.Trim());
}
else if (!txtName.Text.Trim().Equals(""))
{
dgvStudent.DataSource = s.SearchStudentsByLastName(txtName.Text.Trim());
}
dgvStudent.Columns[0].Width = 100;
dgvStudent.Columns[1].Width = 200;
dgvStudent.Columns[2].Width = 200;
dgvStudent.Columns[3].Width = 200;
dgvStudent.Columns[4].Width = 110;
Cursor.Current = Cursors.Default;
if (dgvStudent.Rows.Count > 0)
{
scMain.Panel1Collapsed = false;
}
else
{
throw new Exception("No record(s) found");
}
}
catch (MySqlException ex)
{
if (ex.Number == 1042)
{
MessageBox.Show("Database server is offline. Contact administrator.", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
MessageBox.Show(ex.Number + ": " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public AssessmentReport(ReportViewer rv, string report, string sn, string sem, string sy)
{
RViewer = rv;
EmbeddedResource = report;
RViewer.LocalReport.DataSources.Clear();
RViewer.LocalReport.ReportEmbeddedResource = report;
//Assessment assess = new Assessment();
//assess.GetAssessment(sn, sem, sy);
Stud = new Student();
Stud.SearchStudentsById(sn);
AssessmentFees = new List <Fee>();
//AssessmentFees = assess.GetStudentAssessmentDetailsSimple(assess.Id);
List <Student> student = new List <Student>();
student.Add(Stud);
//List<Assessment> Assess = new List<Assessment>();
//Assess.Add(assess);
ReportDataSource dsAssess = new ReportDataSource();
dsAssess.Name = "dsAssess";
//dsAssess.Value = Assess;
RViewer.LocalReport.DataSources.Add(dsAssess);
ReportDataSource dsStud = new ReportDataSource();
dsStud.Name = "dsStud";
dsStud.Value = student;
RViewer.LocalReport.DataSources.Add(dsStud);
ReportDataSource dsFees = new ReportDataSource();
dsFees.Name = "dsFees";
dsFees.Value = AssessmentFees;
RViewer.LocalReport.DataSources.Add(dsFees);
}