/// <summary>
/// This function used to insert the CloWiseResult record in ClowiseResult List
/// </summary>
/// <param name="query">Query to retrieve the data from database</param>
public void ClowiseResultRecord(string query)
{
try
{
SqlCommand command = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader;
reader = command.ExecuteReader();
if (reader.HasRows)
{
ListofClasses Lt1 = new ListofClasses();
Lt1.CloReport1.Clear();
while (reader.Read())
{
GenerateReport st1 = new GenerateReport();
st1.RegistrationNumber1 = reader[0].ToString();
st1.CloName1 = reader[1].ToString();
st1.TotalMarks1 = Convert.ToInt32(reader[2]);
st1.ObtainMarks1 = Convert.ToInt32(reader[3]);
Lt1.addIntoCloReport(st1);
}
}
}
catch (Exception ex)
{
throw (ex);
}
finally
{
conn.Close();
}
}
private void AssessmentWiseReport_Load(object sender, EventArgs e)
{
ListofClasses lt = new ListofClasses();
GenerateReport Gr = new GenerateReport();
Gr.AssessmentWiseReport();
ASSWiseReport.DataSource = null;
ASSWiseReport.DataSource = lt.CloReport1;
}
private void CloReport_Load(object sender, EventArgs e)
{
ListofClasses lt = new ListofClasses();
GenerateReport Gr = new GenerateReport();
Gr.CLOwiseReport();
CloWiseReport.DataSource = null;
CloWiseReport.DataSource = lt.CloReport1;
}
private void GeneratePdf_Click(object sender, EventArgs e)
{
GenerateReport gr = new GenerateReport();
gr.PDF(ASSWiseReport, "AssWiseReport", "Assessment wise Report");
}
/// <summary>
/// This function used to Add the generate Report in the CloReport Class
/// </summary>
/// <param name="gr">Indicate the object of type GenerateReport</param>
public void addIntoCloReport(GenerateReport gr)
{
CloReport.Add(gr);
}
private void GeneratePdf_Click(object sender, EventArgs e)
{
GenerateReport gr = new GenerateReport();
gr.PDF(CloWiseReport, "CloReport", "Clo wise Report");
}