private void BtnSTsave_Click(object sender, EventArgs e)
{
int affectedRows = 0;
using (Modelss.AKADEMIYAEntities2 db = new Modelss.AKADEMIYAEntities2())
{
groupp.Id = db.Groups.Where(g => g.Name == cbgroups.Text).FirstOrDefault().Id;
//db.Tasks.Where(t => t.GroupId == groupp.Id).FirstOrDefault();
Modelss.Task grpTask = new Modelss.Task();
grpTask.Name = txtTask.Text;
grpTask.Deadline = Convert.ToDateTime(tdedline.Text);
grpTask.GroupId = groupp.Id;
grpTask.Status = true;
db.Tasks.Add(grpTask);
affectedRows = db.SaveChanges();
txtTask.Text = tdedline.Text = cbgroups.Text = "";
}
if (affectedRows > 0)
{
MessageBox.Show("Submitted");
return;
}
else
{
MessageBox.Show("Not Submitted !!");
return;
}
}
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);
}
}
}