public int SaveGrade()
{
using (var stream = new MemoryStream())
{
var request = HttpContext.Current.Request;
request.InputStream.Seek(0, SeekOrigin.Begin);
request.InputStream.CopyTo(stream);
var dataStr = Encoding.UTF8.GetString(stream.ToArray());
var data = (dynamic)JsonConvert.DeserializeObject(dataStr);
using (var db = new WebProjectEntities())
{
var d = data.data;
int studentID = Convert.ToInt32(d["studentID"]);
int assignmentID = Convert.ToInt32(d["assignmentID"]);
int grade1 = Convert.ToInt32(d["grade1"]);
//var lecturer = id == 0 ? new lecturer() : db.lecturers.Where(i => i.lecturerID == id).FirstOrDefault();
var gradeEntry = db.grades.Where(ge => ge.studentID == studentID && ge.assignmentID == assignmentID).FirstOrDefault();
gradeEntry.grade1 = grade1;
//user.Password = Convert.ToString(d["Password"]);
//user.Address = Convert.ToString(d["Address"]);
//if (assignmentID == 0) db.lecturers.Add(lecturer);
db.SaveChanges();
return(gradeEntry.index);
}
}
}
public string GetUsers()
{
using (var db = new WebProjectEntities())
{
var users = db.lecturers.ToList();
return(JsonConvert.SerializeObject(users, Formatting.Indented, new JsonSerializerSettings {
ReferenceLoopHandling = ReferenceLoopHandling.Serialize
}));
}
}
public string GetAssignmentGrade()
{
using (var db = new WebProjectEntities())
{
var selectedRow = Site1.SelectedGridRow;
var assignmentGrades = db.grades.ToList();
var assignment = assignmentGrades.Where(g => g.assignmentID == int.Parse(selectedRow.Cells[0].Text) && g.studentID == int.Parse(selectedRow.Cells[1].Text)).ToList();
var a = assignment[0].submittedAssignment;
return(JsonConvert.SerializeObject(assignment[0]));
}
}
