private void نوبتدومToolStripMenuItem_Click(object sender, EventArgs e) { try { if (dgv1.RowCount > 0 && dgv1.SelectedRows.Count == 1) { string Student_id = dgv1.CurrentRow.Cells["codeMelliDataGridViewTextBoxColumn"].Value.ToString(); int Years_id_FK = (from a in db.tbl_Years orderby a.id descending select a).FirstOrDefault().id; var N2 = (from a in db.tbl_Karnameh where a.Student_id_FK == Student_id && a.Nobat == 2 && a.Years_id_FK == Years_id_FK select a).FirstOrDefault(); var N1 = (from a in db.tbl_Karnameh where a.Student_id_FK == Student_id && a.Nobat == 1 && a.Years_id_FK == Years_id_FK select a).FirstOrDefault(); if (N2 != null) { int?TosifAmalkard = (from a in db.tbl_Classes where a.id == Classid select a).FirstOrDefault().tbl_Payeh.TosifAmalkard_id_FK; Stimulsoft.Report.StiReport Sti = new Stimulsoft.Report.StiReport(); if (TosifAmalkard != null) { Sti.Load(Application.StartupPath + "\\Reports\\rptNobat2TosifKarnameh.mrt"); Sti.Compile(); Sti["str_Student_id"] = Student_id; Sti["lng_Karnameh_id_1"] = N1.id; Sti["lng_Karnameh_id_2"] = N2.id; Sti.ShowWithRibbonGUI(); } else { Sti.Load(Application.StartupPath + "\\Reports\\rptNobat2MarkKarnameh.mrt"); Sti.Compile(); Sti["str_Student_id"] = Student_id; Sti["lng_Karnameh_id_1"] = N1.id; Sti["lng_Karnameh_id_2"] = N2.id; Sti.ShowWithRibbonGUI(); } } else { MessageBox.Show("کارنامه نوبت دوم ثبت نهایی نشده است", "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } } else { MessageBox.Show("لطفا یک سطر را انتخاب نمایید", "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void buttonX2_Click(object sender, EventArgs e) { try { Stimulsoft.Report.StiReport Sti = new Stimulsoft.Report.StiReport(); Sti.Load(Application.StartupPath + "\\Reports\\rptMoavenEjraei.mrt"); Sti.Compile(); Sti.ShowWithRibbonGUI(); } catch (Exception ex) { MessageBox.Show(ex.Message, "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void buttonX4_Click(object sender, EventArgs e) { try { Stimulsoft.Report.StiReport Sti = new Stimulsoft.Report.StiReport(); Sti.Load(Application.StartupPath + "\\Reports\\rptClasses.mrt"); Sti.Compile(); Sti["lng_School_id"] = Frm_Main.School_id; Sti.ShowWithRibbonGUI(); } catch (Exception ex) { MessageBox.Show(ex.Message, "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void buttonX2_Click(object sender, EventArgs e) { try { var Q = (from a in db.tbl_Years orderby a.id descending select a).FirstOrDefault(); int YearsId = 0; if (Q != null) { YearsId = Q.id; } Stimulsoft.Report.StiReport Sti = new Stimulsoft.Report.StiReport(); Sti.Load(Application.StartupPath + "\\Reports\\rptStudentClasses.mrt"); Sti.Compile(); Sti["int_Yearsid"] = YearsId; Sti["lng_Classid"] = Classid; Sti.ShowWithRibbonGUI(); } catch (Exception ex) { MessageBox.Show(ex.Message, "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } }