private void GenerateTasks() { using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { dvgsmark2.Rows.Clear(); List <Modelss.Student> students = db.Students.Where(s => s.GroupId == _groupID).ToList(); foreach (var item in students) { List <Modelss.StudentsMark> studentsMark = db.StudentsMarks.Where(sm => sm.StudentId == item.Id && sm.TaskId == _taskID).ToList(); Modelss.Task task = item.Group.Tasks.FirstOrDefault(t => t.Id == _taskID); string taskName = ""; int taskMark = 0; if (task != null) { taskName = task.Name; Modelss.StudentsMark smark = task.StudentsMarks.FirstOrDefault(sm => sm.StudentId == item.Id); if (smark != null) { taskMark = smark.Mark; } } dvgsmark2.Rows.Add(item.Id, task.Id, item.Name, item.Surname, taskName, taskMark); } } }
private void Btnwrite_Click(object sender, EventArgs e) { if (btnwrite.Text == "Update") { if (!UpdateMark()) { MessageBox.Show("Not Submitted"); cbg.Text = txtMark.Text = ""; return; } MessageBox.Show("Submitted"); FilldvgMarks(); FilldvgAverage(); btnwrite.Text = "Submit"; cbg.Text = txtMark.Text = ""; return; } string sname = dvgstudent2.CurrentRow.Cells[1].Value.ToString(); string ssurname = dvgstudent2.CurrentRow.Cells[2].Value.ToString(); int id = Convert.ToInt32(dvgstudent2.CurrentRow.Cells[0].Value); using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { Modelss.StudentsMark sm = new Modelss.StudentsMark(); int taskid = Convert.ToInt32(db.Tasks.Where(t => t.Name == cbg.Text).FirstOrDefault().Id); sm.Mark = Convert.ToInt32(txtMark.Text); sm.StudentId = id; sm.TaskId = taskid; db.StudentsMarks.Add(sm); db.SaveChanges(); } FilldvgMarks(); FilldvgAverage(); txtMark.Text = cbg.Text = " "; }
private void Btnmark2_Click(object sender, EventArgs e) { int affectedRows = 0; using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { smm.Id = (int)dvgsmark2.CurrentRow.Cells[0].Value; Modelss.StudentsMark SM = db.StudentsMarks.Where(s => s.StudentId == smm.Id).FirstOrDefault(); //validation only numbers String patternnum = "^[0-9]+(,[0-9]+)*$"; Regex mark = new Regex(patternnum); Match numMatch = mark.Match(txtmark.Text); if (!numMatch.Success) { MessageBox.Show("Yalniz ededler daxil edin"); txtmark.Text = ""; return; } SM.Mark = Convert.ToInt32(txtmark.Text); SM.StudentId = (int)dvgsmark2.CurrentRow.Cells[0].Value; SM.TaskId = (int)dvgsmark2.CurrentRow.Cells[1].Value; affectedRows = db.SaveChanges(); //dvgsmark2.CurrentRow.Cells[5].Value = txtmark.Text; btnmark2.Enabled = false; txtmark.Text = ""; GenerateTasks(); } if (affectedRows > 0) { MessageBox.Show("success"); return; } else { MessageBox.Show("error"); return; } }
private bool UpdateMark() { int affectedRows = 0; using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2()) { studentMark.StudentId = Convert.ToInt32(dvgMarks.CurrentRow.Cells[1].Value); Modelss.StudentsMark studenmarks = db.StudentsMarks.Where(m => m.StudentId == studentMark.StudentId).FirstOrDefault(); int taskid = Convert.ToInt32(db.Tasks.Where(t => t.Name == cbg.Text).FirstOrDefault().Id); studenmarks.Mark = Convert.ToInt32(txtMark.Text); studenmarks.TaskId = taskid; studenmarks.StudentId = Convert.ToInt32(dvgMarks.CurrentRow.Cells[1].Value); affectedRows = db.SaveChanges(); } if (affectedRows > 0) { return(true); } else { return(false); } }