private void buttonX4_Click(object sender, EventArgs e) { try { bool IsEmpty = false; int g; for (int i = 0; i < dgv.RowCount; i++) { if (Mark.Visible) { if (!int.TryParse(dgv.Rows[i].Cells["Mark"].Value.ToString(), out g)) { IsEmpty = true; } else { ; } } else if (TosifAmalkard.Visible) { if (!int.TryParse(dgv.Rows[i].Cells["TosifAmalkard"].Value.ToString(), out g)) { IsEmpty = true; } } } if (!IsEmpty) { for (int i = 0; i < dgv.RowCount; i++) { string CodeMelli = dgv.Rows[i].Cells["StudentCode"].Value.ToString(); int? Marks = null; int? TosifAmalkards = null; if (Mark.Visible) { Marks = int.Parse(dgv.Rows[i].Cells["Mark"].Value.ToString()); } else { TosifAmalkards = int.Parse(dgv.Rows[i].Cells["TosifAmalkard"].Value.ToString()); } Models.tbl_Marks Tbl = new Models.tbl_Marks() { Lesson_id_FK = int.Parse(comboBox1.SelectedValue.ToString()), Mark = Marks.Value, TosifAmalkard_id_FK = TosifAmalkards, Payeh_id_FK = Payeh_id_FK, Student_id_FK = CodeMelli, Years_id_FK = Years_id_FK, Nobat = Frm_ShowClasses.Nobat }; db.tbl_Marks.Add(Tbl); db.SaveChanges(); } MessageBox.Show("نمرات دانش آموزان این کلاس ثبت شد", "اطلاعات", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("لطفا نمرات را برا تمام دانش آموزان ثبت نمایید", "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e) { try { if (!IsAval) { bool IsEmpty = false; double g; int h; for (int i = 0; i < dgv.RowCount; i++) { if (Mark.Visible) { if (!double.TryParse(dgv.Rows[i].Cells["Mark"].Value.ToString(), out g)) { IsEmpty = true; } else { ; } } else if (TosifAmalkard.Visible) { if (!int.TryParse(dgv.Rows[i].Cells["TosifAmalkard"].Value.ToString(), out h)) { IsEmpty = true; } } } if (!IsEmpty) { if (KarnamehList != null) { for (int i = 0; i < dgv.RowCount; i++) { int Mark_id = int.Parse(dgv.Rows[i].Cells["MarkId"].Value.ToString()); var Q6 = (from a in db.tbl_Marks where a.id == Mark_id select a).FirstOrDefault(); if (Mark.Visible) { Q6.Mark = double.Parse(dgv.Rows[i].Cells["Mark"].Value.ToString()); } else if (TosifAmalkard.Visible) { Q6.TosifAmalkard_id_FK = int.Parse(dgv.Rows[i].Cells["TosifAmalkard"].Value.ToString()); } db.Entry(Q6).State = EntityState.Modified; db.SaveChanges(); } } else { for (int i = 0; i < dgv.RowCount; i++) { string CodeMelli = dgv.Rows[i].Cells["StudentCode"].Value.ToString(); double?Marks = null; int? TosifAmalkards = null; if (Mark.Visible) { Marks = double.Parse(dgv.Rows[i].Cells["Mark"].Value.ToString()); } else { TosifAmalkards = int.Parse(dgv.Rows[i].Cells["TosifAmalkard"].Value.ToString()); } Models.tbl_Marks Tbl = new Models.tbl_Marks(); Tbl.Lesson_id_FK = int.Parse(comboBox1.SelectedValue.ToString()); Tbl.Mark = Marks; Tbl.TosifAmalkard_id_FK = TosifAmalkards; Tbl.Payeh_id_FK = Payeh_id_FK; Tbl.Student_id_FK = CodeMelli; Tbl.Years_id_FK = Years_id_FK; var Q = (from a in db.tbl_Karnameh where a.Years_id_FK == Years_id_FK && a.Student_id_FK == CodeMelli select a).FirstOrDefault(); Tbl.Karnameh_id_FK = Q.id; Tbl.Nobat = Frm_ShowClasses.Nobat; db.tbl_Marks.Add(Tbl); db.SaveChanges(); } } MessageBox.Show("نمرات یک درس دانش آموزان این کلاس ثبت شد", "اطلاعات", MessageBoxButtons.OK, MessageBoxIcon.Information); int k = dgv.RowCount; for (int i = 0; i <= k - i; i++) { dgv.Rows[0].Selected = true; dgv.Rows.Remove(dgv.CurrentRow); } } else { MessageBox.Show("لطفا نمرات را برا تمام دانش آموزان ثبت نمایید", "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } } ////////////////////////////////// FillDGV Student if (KarnamehList != null) { int l = 1; int Lesson_id = int.Parse(comboBox1.SelectedValue.ToString()); bool Flag = false; foreach (var item in KarnamehList) { var Q5 = (from a in db.tbl_Marks where a.Lesson_id_FK == Lesson_id && a.Karnameh_id_FK == item.id select a).FirstOrDefault(); if (Q5 != null && Q5.Mark != null) { dgv.Rows.Add(l, item.tbl_Students.CodeMelli, item.tbl_Students.Name + " " + item.tbl_Students.Lname, Q5.Mark, null, Q5.id); } else if (Q5 != null && Q5.TosifAmalkard_id_FK != null) { dgv.Rows.Add(l, item.tbl_Students.CodeMelli, item.tbl_Students.Name + " " + item.tbl_Students.Lname, "", Q5.tbl_TosifAmalkard.id, Q5.id); } else { Flag = true; } l++; } if (Flag) { var Q2 = (from a in db.tbl_StudentClasses where a.Class_id_FK == Class_id select a); int j = 1; foreach (var item1 in Q2.ToList()) { Years_id_FK = (from a in db.tbl_Years orderby a.id descending select a).FirstOrDefault().id; var Q0 = (from a in db.tbl_Karnameh where a.Student_id_FK == item1.Student_id_FK && a.Nobat == Frm_ShowClasses.Nobat && a.Years_id_FK == Years_id_FK select a).FirstOrDefault(); Models.tbl_Marks Tbl = new Models.tbl_Marks() { Student_id_FK = item1.Student_id_FK, Karnameh_id_FK = Q0.id, Years_id_FK = Years_id_FK, Lesson_id_FK = Lesson_id, Nobat = Frm_ShowClasses.Nobat }; db.tbl_Marks.Add(Tbl); db.SaveChanges(); var Q = (from a in db.tbl_Marks where a.Lesson_id_FK == Lesson_id && a.Karnameh_id_FK == Q0.id && a.Student_id_FK == item1.Student_id_FK select a).FirstOrDefault(); dgv.Rows.Add(j, item1.tbl_Students.CodeMelli, item1.tbl_Students.Name + " " + item1.tbl_Students.Lname, "", null, Q.id); j++; } if (Q2.FirstOrDefault() != null) { Years_id_FK = Q2.FirstOrDefault().tbl_Years.id; } } } else { //////////////////////// var Q2 = (from a in db.tbl_StudentClasses where a.Class_id_FK == Class_id select a); int j = 1; foreach (var item in Q2.ToList()) { dgv.Rows.Add(j, item.tbl_Students.CodeMelli, item.tbl_Students.Name + " " + item.tbl_Students.Lname); j++; } if (Q2.FirstOrDefault() != null) { Years_id_FK = Q2.FirstOrDefault().tbl_Years.id; } } IsAval = false; } catch (Exception ex) { MessageBox.Show(ex.Message, "اخطار", MessageBoxButtons.OK, MessageBoxIcon.Error); } }