// delete rows from clos
private void gvClo_KeyDown(object sender, KeyEventArgs e)
{
if (e.KeyCode == Keys.Delete)
{
if (AskYesNo() == false)
{
return;
}
int selectedrowindex = gvClo.SelectedCells[0].RowIndex;
DataGridViewRow selectedRow = gvClo.Rows[selectedrowindex];
string _id = Convert.ToString(selectedRow.Cells["id"].Value);
AJ_DataClass ajdbClass = new AJ_DataClass();
string s = ajdbClass.DeleteFromDatabase("delete from clo where id='" + _id + "'");
ajdbClass.popGrid(gvClo, "select id,name from clo");
ajdbClass.popCmb(cmbClo, "select * from clo", "id", "name");
lblrubricLevels.Text = "Rubrics Level - Settings Clo:" + cmbClo.Text;
}
}
private void AttandanceReport_Load(object sender, EventArgs e)
{
ajdbClass.popGrid(gvClo, "SELECT dbo.Student.Id, dbo.Student.FirstName, dbo.ClassAttendance.AttendanceDate, dbo.Lookup.Name FROM dbo.StudentAttendance INNER JOIN dbo.Student ON dbo.StudentAttendance.StudentId = dbo.Student.Id INNER JOIN dbo.ClassAttendance ON dbo.StudentAttendance.AttendanceId = dbo.ClassAttendance.Id INNER JOIN dbo.Lookup ON dbo.StudentAttendance.AttendanceStatus = dbo.Lookup.LookupId order by AttendanceId asc"); // ajdbClass.popGrid(gvClo, "select id,name from clo");
Document doc = new Document(PageSize.A4, 7f, 5f, 5f, 0f);
iTextSharp.text.Font mainFont = FontFactory.GetFont("Segoe UI", 22, new iTextSharp.text.BaseColor(System.Drawing.ColorTranslator.FromHtml("#999")));
Phrase mainPharse = new Phrase();
//Creating iTextSharp Table from the DataTable data
PdfPTable pdfTable = new PdfPTable(gvClo.ColumnCount);
pdfTable.DefaultCell.Padding = 5;
pdfTable.WidthPercentage = 90;
int[] firstTablecellwidth = { 20, 25, 32, 25 };
pdfTable.SetWidths(firstTablecellwidth);
pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
pdfTable.DefaultCell.BorderWidth = 1;
//Adding Header row
foreach (DataGridViewColumn column in gvClo.Columns)
{
PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText));
pdfTable.AddCell(cell);
}
int row = gvClo.Rows.Count;
int cell2 = gvClo.Rows[1].Cells.Count;
for (int i = 0; i < row - 1; i++)
{
for (int j = 0; j < cell2; j++)
{
if (gvClo.Rows[i].Cells[j].Value == null)
{
//return directly
//return;
//or set a value for the empty data
gvClo.Rows[i].Cells[j].Value = "null";
}
pdfTable.AddCell(gvClo.Rows[i].Cells[j].Value.ToString());
}
}
//Exporting to PDF
string folderPath = @"e:\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
using (FileStream stream = new FileStream(folderPath + "AttandanceReport.pdf", FileMode.Create))
{
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
pdfDoc.Add(new Phrase("\t\t\t Attandance Report\n"));
pdfDoc.Add(pdfTable);
pdfDoc.Close();
stream.Close();
}
}
private void StudentReport_Load(object sender, EventArgs e)
{
string qry = "SELECT Student.Id, Student.FirstName AS StudentName, Student.Contact, Student.Email, Student.RegistrationNumber as RegNo, Lookup.Name as Status " +
" FROM Student INNER JOIN " + " Lookup ON Student.Status = Lookup.LookupId ";
ajdbClass.popGrid(gvStudRep, qry);
PdfPTable pdfTable = new PdfPTable(gvStudRep.ColumnCount);
pdfTable.DefaultCell.Padding = 5;
pdfTable.WidthPercentage = 60;
pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
pdfTable.DefaultCell.BorderWidth = 1;
//set overall width
pdfTable.WidthPercentage = 90f;
//set column widths
int[] firstTablecellwidth = { 20, 25, 25, 32, 25, 25 };
pdfTable.SetWidths(firstTablecellwidth);
//Adding Header row
foreach (DataGridViewColumn column in gvStudRep.Columns)
{
PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText));
pdfTable.AddCell(cell);
}
int row = gvStudRep.Rows.Count;
int cell2 = gvStudRep.Rows[1].Cells.Count;
for (int i = 0; i < row - 1; i++)
{
for (int j = 0; j < cell2; j++)
{
if (gvStudRep.Rows[i].Cells[j].Value == null)
{
gvStudRep.Rows[i].Cells[j].Value = "null";
}
pdfTable.AddCell(gvStudRep.Rows[i].Cells[j].Value.ToString());
this.gvStudRep.Columns[1].Width = 100;
}
}
//Exporting to PDF
string folderPath = @"e:\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
using (FileStream stream = new FileStream(folderPath + "StudentReport1.pdf", FileMode.Create))
{
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
pdfDoc.Add(new Phrase("\t\t\t STUDENT REPORT\n"));
pdfDoc.Add(pdfTable);
pdfDoc.Close();
stream.Close();
}
}
private void CloReport_Load(object sender, EventArgs e)
{
string qry = "SELECT Student.FirstName, Clo.Name, Rubric.Details AS Rubric, RubricLevel.Details AS [Level] FROM Student INNER JOIN StudentResult ON Student.Id = StudentResult.StudentId INNER JOIN" +
" RubricLevel ON StudentResult.RubricMeasurementId = RubricLevel.Id INNER JOIN" +
" Rubric ON RubricLevel.RubricId = Rubric.Id INNER JOIN" +
" Clo ON Rubric.CloId = Clo.Id";
ajdbClass.popGrid(gvClo, qry);
//Document doc = new Document(PageSize.A4, 7f, 5f, 5f, 0f);
//iTextSharp.text.Font mainFont = FontFactory.GetFont("Segoe UI", 22, new iTextSharp.text.BaseColor(System.Drawing.ColorTranslator.FromHtml("#999")));
//Phrase mainPharse = new Phrase();
//Creating iTextSharp Table from the DataTable data
PdfPTable pdfTable = new PdfPTable(gvClo.ColumnCount);
pdfTable.DefaultCell.Padding = 5;
pdfTable.WidthPercentage = 90;
int[] firstTablecellwidth = { 30, 25, 32, 25 };
pdfTable.SetWidths(firstTablecellwidth);
pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
pdfTable.DefaultCell.BorderWidth = 1;
//Adding Header row
foreach (DataGridViewColumn column in gvClo.Columns)
{
PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText));
pdfTable.AddCell(cell);
}
//Adding DataRow
//foreach (DataGridViewRow row in gvClo.Rows)
//{
// foreach (DataGridViewCell cell in row.Cells)
// {
// pdfTable.AddCell(cell.Value.ToString());
// }
//}
int row = gvClo.Rows.Count;
int cell2 = gvClo.Rows[1].Cells.Count;
for (int i = 0; i < row - 1; i++)
{
for (int j = 0; j < cell2; j++)
{
if (gvClo.Rows[i].Cells[j].Value == null)
{
//return directly
//return;
//or set a value for the empty data
gvClo.Rows[i].Cells[j].Value = "null";
}
pdfTable.AddCell(gvClo.Rows[i].Cells[j].Value.ToString());
}
}
//Exporting to PDF
try
{
string folderPath = @"e:\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
using (FileStream stream = new FileStream(folderPath + "CloReport.pdf", FileMode.Create))
{
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
pdfDoc.Add(new Phrase("\t\t\t CLO Report\n"));
pdfDoc.Add(pdfTable);
pdfDoc.Close();
stream.Close();
}
}
catch
{
}
}
/// <summary>
/// Load event
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form1_Load(object sender, EventArgs e)
{
// fill combos
ajdbClass.popCmb(cmbClo, "select * from clo", "id", "name");
ajdbClass.popCmb(cmbRubrics, "select * from Rubric where CloId='" + cmbClo.SelectedValue + "'", "id", "Details");
ajdbClass.popCmb(cmbStatus, "select * from Lookup where category='STUDENT_STATUS'", "Lookupid", "Name");
ajdbClass.popCmb(cmbRubAsses, "select * from Rubric ", "id", "details");
ajdbClass.popCmb(cmbStudent, "SELECT * FROM STUDENT", "id", "FirstName");
ajdbClass.popCmb(cmbAseesRE, "SELECT * FROM Assessment ", " Assessment.Id", "Title");
ajdbClass.popCmb(cmbAssesR, "SELECT * FROM AssessmentComponent where AssessmentId='" + cmbAseesRE.SelectedValue + "'", " AssessmentComponent.Id", "Name");
ajdbClass.popCmb(cmbRubRes, "select * from RubricLevel", "Id", "Details");
ajdbClass.popCmb(cmbAssesment, "SELECT * FROM Assessment ", " Assessment.Id", "Title");
// fill data grid view
ajdbClass.popGrid(gvClo, "select id,name from clo");
ajdbClass.popGrid(gvRub, "select id,details from Rubric where cloid='" + cmbClo.SelectedValue + "'");
ajdbClass.popGrid(gvRubSettings, "select id,details,MeasurementLevel from RubricLevel where RubricId='" + cmbRubrics.SelectedValue + "'");
string qry = "SELECT Student.Id, Student.FirstName, Student.LastName, Student.Contact, Student.Email, Student.RegistrationNumber, Lookup.Name, Lookup.LookupId " +
" FROM Student INNER JOIN " + " Lookup ON Student.Status = Lookup.LookupId ";
ajdbClass.popGrid(gvStudents, qry); txtRubricSetDetails.Text = ""; txtRubricSetLevel.Text = "";
ajdbClass.popGrid(gvAssesment, "SELECT Assessment.Id, Title, DateCreated, TotalMarks, TotalWeightage FROM Assessment");
gvAttandance.DataSource = GetAttendanceRecord();
ajdbClass.popGrid(gvAssesComp, "select AssessmentComponent.Id, Name, Assessment.Title,Rubric.details as Rubric ,AssessmentComponent.TotalMarks from AssessmentComponent inner join Rubric on AssessmentComponent.RubricId=Rubric.Id INNER JOIN Assessment ON AssessmentComponent.AssessmentId = Assessment.Id ");
ajdbClass.popGrid(gvResult, "select FirstName,Assessment.Title,AssessmentComponent.Name,EvaluationDate,RubricLevel.details as Rubric from Student INNER JOIN StudentResult ON Student.Id = StudentResult.StudentId INNER JOIN RubricLevel ON StudentResult.RubricMeasurementId = RubricLevel.Id INNER JOIN AssessmentComponent ON StudentResult.AssessmentComponentId = AssessmentComponent.Id INNER JOIN Assessment ON AssessmentComponent.AssessmentId = Assessment.Id");
}
private void AssesmentReport_Load(object sender, EventArgs e)
{
try {
ajdbClass.popGrid(gvAssesRep, "select FirstName,Assessment.Title,AssessmentComponent.Name,EvaluationDate,RubricLevel.details as Rubric from Student INNER JOIN StudentResult ON Student.Id = StudentResult.StudentId INNER JOIN RubricLevel ON StudentResult.RubricMeasurementId = RubricLevel.Id INNER JOIN AssessmentComponent ON StudentResult.AssessmentComponentId = AssessmentComponent.Id INNER JOIN Assessment ON AssessmentComponent.AssessmentId = Assessment.Id");
// ajdbClass.popGrid(gvAssesRep, qry);
PdfPTable pdfTable = new PdfPTable(gvAssesRep.ColumnCount);
//set overall width
pdfTable.DefaultCell.Padding = 5;
pdfTable.WidthPercentage = 60;
pdfTable.HorizontalAlignment = Element.ALIGN_LEFT;
pdfTable.DefaultCell.BorderWidth = 1;
pdfTable.WidthPercentage = 90f;
//set column widths
// int[] firstTablecellwidth = { 20, 25, 25,25};
// pdfTable.SetWidths(firstTablecellwidth);
//Adding Header row
foreach (DataGridViewColumn column in gvAssesRep.Columns)
{
PdfPCell cell = new PdfPCell(new Phrase(column.HeaderText));
pdfTable.AddCell(cell);
}
int row = gvAssesRep.Rows.Count;
int cell2 = gvAssesRep.Rows[0].Cells.Count;
for (int i = 0; i < row - 1; i++)
{
for (int j = 0; j < cell2; j++)
{
if (gvAssesRep.Rows[i].Cells[j].Value == null)
{
gvAssesRep.Rows[i].Cells[j].Value = "null";
}
pdfTable.AddCell(gvAssesRep.Rows[i].Cells[j].Value.ToString());
this.gvAssesRep.Columns[0].Width = 100;
}
}
//Exporting to PDF
string folderPath = @"e:\";
if (!Directory.Exists(folderPath))
{
Directory.CreateDirectory(folderPath);
}
using (FileStream stream = new FileStream(folderPath + "AssesmentReport.pdf", FileMode.Create))
{
Document pdfDoc = new Document(PageSize.A4, 10f, 10f, 10f, 0f);
PdfWriter.GetInstance(pdfDoc, stream);
pdfDoc.Open();
pdfDoc.Add(new Phrase("\t\t\t Assesment Report\n"));
pdfDoc.Add(pdfTable);
pdfDoc.Close();
stream.Close();
}
}
catch (Exception ex)
{
// MessageBox.Show("error");
}
}
