public List<marks_users> getallusermarks(int k) { var Emplist = new List<marks_users>(); onlinetestingEntities4 gt = new onlinetestingEntities4(); foreach (var i in gt.marks.ToList()) { if (i.test_id == k) { marks_users m1 = new marks_users(); m1.ID = i.id; m1.Test_ID = i.test_id; m1.Name = i.Name; m1.Email = i.Email; m1.School_Colg = i.sch_colg; m1.Obtained_Marks = i.obtained_marks; Emplist.Add(m1); } } return Emplist; }
public bool insertuserandmarks(marks_users insertMarks) { onlinetestingEntities4 tests = new onlinetestingEntities4(); mark newuser = new mark(); newuser.id = insertMarks.ID; newuser.test_id = insertMarks.Test_ID; newuser.Name = insertMarks.Name; newuser.Email = insertMarks.Email; newuser.sch_colg = insertMarks.School_Colg; newuser.obtained_marks = insertMarks.Obtained_Marks; tests.marks.Add(newuser); tests.SaveChanges(); return true; }