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;
}
}
