private void btnReport_Click(object sender, EventArgs e) { try { var report = new repMonthly(); var attend = 0; var idStudent = Convert.ToInt32(gridView3.GetFocusedRowCellValue(colم)); var date = Convert.ToDateTime(dateEdit1.EditValue); var cd = db.CenterDatas.Find(1); report.CenterName.Value = cd.Name; report.address.Value = cd.Address; report.Phone1.Value = cd.Phone1; report.Phone2.Value = cd.Phone2; report.subject.Value = cd.Subject; byte[] img = cd.Logo; MemoryStream ms = new MemoryStream(img); Image _img = Image.FromStream(ms); report.xrPictureBox1.Image = _img; DateTime month = Convert.ToDateTime(dateEdit1.EditValue); report.month.Value = month.ToString("MMMM، yyyy", new CultureInfo("ar-EG")); var dt = absence.repMonthly(idStudent, date); report.paramDegree.Value = dt.Rows[0]["exam"].ToString(); report.paramMaxDegree.Value = Properties.Settings.Default.maxDegree; report.paramName.Value = gridView3.GetFocusedRowCellValue(colالطالب).ToString(); if (Convert.ToBoolean(dt.Rows[0]["paid"])) { report.paramPaid.Value = "تم الدفع"; } else { report.paramPaid.Value = "لم يتم الدفع"; } for (var i = 2; i < 16; i++) { if (Convert.ToBoolean(dt.Rows[0][i])) { attend++; } } report.paramAttend.Value = attend; report.paramTotal.Value = Properties.Settings.Default.totalAttendance; report.ShowPreview(); } catch { return; } }
private void btnRepGroup_Click(object sender, EventArgs e) { try { var report = new repMonthly(); var date = Convert.ToDateTime(dateEdit1.EditValue); var cd = db.CenterDatas.Find(1); report.Name = cd.Name; report.address.Value = cd.Address; report.Phone1.Value = cd.Phone1; report.Phone2.Value = cd.Phone2; report.subject.Value = cd.Subject; DateTime month = Convert.ToDateTime(dateEdit1.EditValue); report.month.Value = month.ToString("MMMM، yyyy", new CultureInfo("ar-EG")); for (int i = 0; i < gridView3.RowCount; i++) { var attend = 0; var idStudent = Convert.ToInt32(gridView3.GetRowCellValue(i, colم)); var dt = absence.repMonthly(idStudent, date); report.paramDegree.Value = dt.Rows[0]["exam"].ToString(); report.paramMaxDegree.Value = Properties.Settings.Default.maxDegree; report.paramName.Value = gridView3.GetRowCellValue(i, colالطالب).ToString(); if (Convert.ToBoolean(dt.Rows[0]["paid"])) { report.paramPaid.Value = "تم الدفع"; } else { report.paramPaid.Value = "لم يتم الدفع"; } for (var x = 2; x < 16; x++) { if (Convert.ToBoolean(dt.Rows[0][x])) { attend++; } } report.paramAttend.Value = attend; report.paramTotal.Value = Properties.Settings.Default.totalAttendance; report.CreateDocument(); report.Print(Properties.Settings.Default.Printer); } } catch { return; } }