public void ReportGrade(object sender, EventArgs e)
{
var partipart = db.PartiParts.SingleOrDefault(x =>
x.code == CurrentCourseCode &&
x.pnr == CurrentStudentSSN &&
x.runid == CurrentRunID &&
x.part == partList.Selection.Value);
if (partipart == null)
{
partipart = new PartiPart();
partipart.code = CurrentCourseCode;
partipart.pnr = CurrentStudentSSN;
partipart.runid = CurrentRunID;
partipart.part = partList.Selection.Value;
db.PartiParts.InsertOnSubmit(partipart);
}
partipart.result = gradeList.Selection.Value[0];
partipart.signature = User.Identity.Name;
partipart.date = DateTime.Now;
db.SubmitChanges();
ActiveForm = Form5;
}
protected void btnSave_Click(object sender, EventArgs e)
{
using (var scope = new TransactionScope())
using (var db = new DBDataContext())
{
DropDownList tbResult;
PartiPart partiPart;
string pnr;
var partiParts = from p in db.PartiParts
where
p.code == ddlCourse.SelectedValue &&
p.runid == ddlCourseRun.SelectedValue &&
p.part == ddlCoursePart.SelectedValue
select p;
foreach (GridViewRow row in gvStudentsAndGrades.Rows)
{
tbResult = (DropDownList)row.FindControl("tbResult");
if (tbResult.SelectedValue.Length < 1)
{
continue;
}
pnr = gvStudentsAndGrades.DataKeys[row.DataItemIndex][0] as string;
partiPart = partiParts.SingleOrDefault(x => x.pnr == pnr);
if (partiPart == null)
{
partiPart = new PartiPart()
{
code = ddlCourse.SelectedValue,
runid = ddlCourseRun.SelectedValue,
part = ddlCoursePart.SelectedValue,
pnr = pnr
};
db.PartiParts.InsertOnSubmit(partiPart);
}
partiPart.result = tbResult.SelectedValue[0];
partiPart.date = DateTime.Now;
partiPart.signature = User.Identity.Name;
}
db.SubmitChanges();
scope.Complete();
}
lbMessage.Text = "The reported grades has been updated";
lbMessage.Visible = true;
}
