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 List<testsinfo> getspecifictestinfo(int k) { var Emplist = new List<testsinfo>(); onlinetestingEntities4 gettest = new onlinetestingEntities4(); foreach (var i in gettest.testDatas.ToList()) { if (i.user_id == k) { testsinfo t1 = new testsinfo(); t1.test_ID = i.test_id; t1.user_ID = i.user_id; t1.test_name = i.testName; t1.test_Sub = i.testSubject; t1.test_max = i.testMaxMarks; t1.test_time = i.testTime; t1.test_details = i.testDetails; Emplist.Add(t1); } } return Emplist; }
public List<tests> getspecifictest(int k) { var Emplist = new List<tests>(); onlinetestingEntities4 newt = new onlinetestingEntities4(); foreach (var i in newt.tests.ToList()) { if (i.test_id == k) { tests t1 = new tests(); t1.test_id = i.test_id; t1.Id = i.id; t1.Ques = i.question; t1.option1 = i.option1; t1.option2 = i.option2; t1.option3 = i.option3; t1.option4 = i.option4; t1.Right_ans = i.right_ans; Emplist.Add(t1); } } return Emplist; }
public bool insertuserformobile(int id,string f, string l, string e, string p, string a) { onlinetestingEntities4 userData = new onlinetestingEntities4(); userdata newuser = new userdata(); newuser.user_id = id; newuser.firstName = f; newuser.lastName = l; newuser.email = e; newuser.passwor = p; newuser.about = a; //string str = string.Empty; //int k = 0; //onlinetestingEntities getUser = new onlinetestingEntities(); //foreach (var i in getUser.userdatas.ToList()) //{ // if (newuser.email == i.email) // { // str = "This email is already registered"; // } // else // { // k++; // } //} userData.userdatas.Add(newuser); userData.SaveChanges(); return true; }
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; }
public bool insertuser(users userInsert) { onlinetestingEntities4 userData = new onlinetestingEntities4(); userdata newuser = new userdata(); newuser.user_id = userInsert.userId; newuser.firstName = userInsert.first_name; newuser.lastName = userInsert.last_name; newuser.email = userInsert.Email; newuser.passwor = userInsert.Password; newuser.about = userInsert.About; //string str = string.Empty; //int k = 0; //onlinetestingEntities getUser = new onlinetestingEntities(); //foreach (var i in getUser.userdatas.ToList()) //{ // if (newuser.email == i.email) // { // str = "This email is already registered"; // } // else // { // k++; // } //} userData.userdatas.Add(newuser); userData.SaveChanges(); return true; }
public bool inserttestDetails(testsinfo testInsert) { onlinetestingEntities4 tests = new onlinetestingEntities4(); testData newtest = new testData(); newtest.test_id = testInsert.test_ID; newtest.user_id = testInsert.user_ID; newtest.testName = testInsert.test_name; newtest.testSubject = testInsert.test_Sub; newtest.testTime = testInsert.test_time; newtest.testMaxMarks = testInsert.test_max; newtest.testDetails = testInsert.test_details; tests.testDatas.Add(newtest); tests.SaveChanges(); return true; }
public bool insertTest(tests testInsert) { onlinetestingEntities4 t1 = new onlinetestingEntities4(); test newt = new test(); newt.id = testInsert.Id; newt.test_id = testInsert.test_id; newt.question = testInsert.Ques; newt.option1 = testInsert.option1; newt.option2 = testInsert.option2; newt.option3 = testInsert.option3; newt.option4 = testInsert.option4; newt.right_ans = testInsert.Right_ans; t1.tests.Add(newt); t1.SaveChanges(); return true; }
public List<users> getUsers() { var EmpList = new List<users>(); onlinetestingEntities4 getuser = new onlinetestingEntities4(); foreach ( var i in getuser.userdatas.ToList()) { users user1 = new users(); user1.userId = i.user_id; user1.first_name = i.firstName; user1.last_name = i.lastName; user1.Email = i.email; user1.Password = i.passwor; user1.About = i.about; EmpList.Add(user1); } return EmpList; }
public List<tests> gettest() { var Emplist = new List<tests>(); onlinetestingEntities4 t1 = new onlinetestingEntities4(); foreach( var i in t1.tests.ToList()) { tests obj1 = new tests(); obj1.Id = i.id; obj1.test_id = i.test_id; obj1.Ques = i.question; obj1.option1 = i.option1; obj1.option2 = i.option2; obj1.option3 = i.option3; obj1.option4 = i.option4; Emplist.Add(obj1); } return Emplist; }