public static bool isValidUser(string username, string password)
{
UBOnlineWebApiTest2Context db = new UBOnlineWebApiTest2Context();
IQueryable<Student> stuOut =
from s in db.Students
where s.stuName == username && s.password == password
orderby s.stuName
select s;
if (stuOut.Count<Student>() == 0)
return false;
else
return true;
}
public static void Insert(UBOnlineWebApiTest2Context db)
{
int counter = 0;
//Course course1 = new Course();
//Course course2 = new Course();
//Course course3 = new Course();
//Course course4 = new Course();
//Course course5 = new Course();
//Course course6 = new Course();
//Course course7 = new Course();
//Assignment asm1 = new Assignment(); // relationship between student and assignment
//Assignment asm2 = new Assignment();
//Assignment asm3 = new Assignment();
//Assignment asm4 = new Assignment();
//File file1 = new File();
//File file2 = new File();
//File file3 = new File();
//File file4 = new File();
//File file5 = new File();
//File file6 = new File();
//File file7 = new File();
//File file8 = new File();
//File file9 = new File();
//File file10 = new File();
//File file11 = new File();
//File file12 = new File();
//File file13 = new File();
//Register grade1 = new Register();
//Register grade2 = new Register();
//Register grade3 = new Register();
//Register grade4 = new Register();
//Register grade5 = new Register();
//Student student1 = new Student();
//Student student2 = new Student();
//Announcement anno1 = new Announcement();
//Announcement anno2 = new Announcement();
//Announcement anno3 = new Announcement();
//Announcement anno4 = new Announcement();
//Announcement anno5 = new Announcement();
//Announcement anno6 = new Announcement();
//Announcement anno7 = new Announcement();
//Announcement anno8 = new Announcement();
//Announcement anno9 = new Announcement();
//Professor pro1 = new Professor();
//Professor pro2 = new Professor();
//Read read1 = new Read();
//Read read2 = new Read();
//Read read3 = new Read();
//Read read4 = new Read();
//Read read5 = new Read();
//Read read6 = new Read();
//Read read7 = new Read();
//Read read8 = new Read();
//Read read9 = new Read();
//Read read10 = new Read();
//Read read11 = new Read();
//Read read12 = new Read();
//Read read13 = new Read();
//Read read14 = new Read();
//Read read15 = new Read();
//Read read16 = new Read();
//Read read17 = new Read();
//Read read18 = new Read();
//course1.courseId = "cs440";
//course1.courseName = "windows programming";
//course1.location = "M308";
//course1.proName = "AM";
//course1.time = "11-00";
//course2.courseId = "cs555";
//course2.courseName = "web development";
//course2.location = "M305";
//course2.proName = "AM";
//course2.time = "12-00";
//course3.courseId = "cs551";
//course3.courseName = "Advanced database";
//course3.location = "M208";
//course3.proName = "Lee";
//course3.time = "06-30";
//student1.stuName = "user1";
//student1.password = "******";
//student2.stuName = "user2";
//student2.password = "******";
//pro1.proName = "AM";
//pro1.proEmail = "*****@*****.**";
//pro1.proOffice = "tech220";
//pro1.proPhone = "2034567894";
//pro2.proName = "Lee";
//pro2.proEmail = "*****@*****.**";
//pro2.proOffice = "tech120";
//pro2.proPhone = "2034567893";
//asm1.asmId = "asm" + uniqueIdTime(ref counter);
//asm1.courseId = "cs440";
//asm1.fileId = "cs440assignment1";
//asm1.grade = "20/20";
//asm1.stuName = "user1";
//asm1.submitted = "true";
//asm2.asmId = "asm" + uniqueIdTime(ref counter);
//asm2.courseId = "cs555";
//asm2.fileId = "cs555assignment1";
//asm2.grade = "none";
//asm2.stuName = "user1";
//asm2.submitted = "true";
//asm3.asmId = "asm" + uniqueIdTime(ref counter);
//asm3.courseId = "cs440";
//asm3.fileId = "cs440assignment1";
//asm3.grade = "none";
//asm3.stuName = "user2";
//asm3.submitted = "false";
//asm4.asmId = "asm" + uniqueIdTime(ref counter);
//asm4.courseId = "cs551";
//asm4.fileId = "cs551assignment1";
//asm4.grade = "18/20";
//asm4.stuName = "user2";
//asm4.submitted = "true";
//file1.fileId = "cs440video1";
//file1.courseId = "cs440";
//file1.fileLink = "http://file.video/video1.3gp";
//file1.fileName = "video1";
//file1.fileType = "video";
//file2.fileId = "cs440handout1";
//file2.courseId = "cs440";
//file2.fileLink = "http://file.handout/file.doc";
//file2.fileName = "handout1";
//file2.fileType = "handout";
//file3.fileId = "cs440assignment1";
//file3.courseId = "cs440";
//file3.fileLink = "http://file.assignment/hw1.doc";
//file3.fileName = "assignment1";
//file3.fileType = "assignment";
//file4.fileId = "cs555video1";
//file4.courseId = "cs555";
//file4.fileLink = "http://file.video/video1.3gp";
//file4.fileName = "video1";
//file4.fileType = "video";
//file5.fileId = "cs555handout1";
//file5.courseId = "cs555";
//file5.fileLink = "http://file.handout/file.doc";
//file5.fileName = "handout1";
//file5.fileType = "handout";
//file6.fileId = "cs555assignment1";
//file6.courseId = "cs555";
//file6.fileLink = "http://file.assignment/hw1.doc";
//file6.fileName = "assignment1";
//file6.fileType = "assignment";
//file7.fileId = "cs551video1";
//file7.courseId = "cs551";
//file7.fileLink = "http://file.video/video1.3gp";
//file7.fileName = "video1";
//file7.fileType = "video";
//file8.fileId = "cs551handout1";
//file8.courseId = "cs551";
//file8.fileLink = "http://file.handout/file.doc";
//file8.fileName = "handout1";
//file8.fileType = "handout";
//file9.fileId = "cs551assignment1";
//file9.courseId = "cs551";
//file9.fileLink = "http://file.assignment/hw1.doc";
//file9.fileName = "assignment1";
//file9.fileType = "assignment";
//file10.fileId = "cs440video2";
//file10.courseId = "cs440";
//file10.fileLink = "http://download.wavetlan.com/SVV/Media/HTTP/3GP/Media-Convert/Media-Convert_test1_3GPv4_H263_xbit_352x288_AR1.22_15fps_KFx_374kbps_AMRNB_Mono_8000Hz_12.2kbps.3gp";
//file10.fileName = "video2";
//file10.fileType = "video";
//grade1.regId = "reg" + uniqueIdTime(ref counter);
//grade1.courseId = "cs440";
//grade1.finalGrade = "A";
//grade1.stuName = "user1";
//grade1.taken = "true";
//grade2.regId = "reg" + uniqueIdTime(ref counter);
//grade2.courseId = "cs555";
//grade2.finalGrade = "none";
//grade2.stuName = "user1";
//grade2.taken = "true";
//grade3.regId = "reg" + uniqueIdTime(ref counter);
//grade3.courseId = "cs440";
//grade3.finalGrade = "none";
//grade3.stuName = "user2";
//grade3.taken = "true";
//grade4.regId = "reg" + uniqueIdTime(ref counter);
//grade4.courseId = "cs551";
//grade4.finalGrade = "B";
//grade4.stuName = "user2";
//grade4.taken = "true";
//grade5.regId = "reg" + uniqueIdTime(ref counter);
//grade5.courseId = "cs555";
//grade5.finalGrade = "none";
//grade5.stuName = "user2";
//grade5.taken = "false";
//anno1.annId = "cs440assignment1";
//anno1.annType = "assignment";
//anno1.content = "assignment 1 has been posted";
//anno1.courseId = "cs440";
//anno2.annId = "cs555assignment1";
//anno2.annType = "assignment";
//anno2.content = "assignment 1 has been posted";
//anno2.courseId = "cs555";
//anno3.annId = "cs551assignment1";
//anno3.annType = "assignment";
//anno3.content = "assignment 1 has been posted";
//anno3.courseId = "cs551";
//anno4.annId = "cs440handout1";
//anno4.annType = "handout";
//anno4.content = "handout 1 has been posted";
//anno4.courseId = "cs440";
//anno5.annId = "cs555handout1";
//anno5.annType = "handout";
//anno5.content = "handout 1 has been posted";
//anno5.courseId = "cs555";
//anno6.annId = "cs551handout1";
//anno6.annType = "handout";
//anno6.content = "handout 1 has been posted";
//anno6.courseId = "cs551";
//anno7.annId = "cs440video1";
//anno7.annType = "video";
//anno7.content = "video 1 has been posted";
//anno7.courseId = "cs440";
//anno8.annId = "cs555video1";
//anno8.annType = "video";
//anno8.content = "video 1 has been posted";
//anno8.courseId = "cs555";
//anno9.annId = "cs551video1";
//anno9.annType = "video";
//anno9.content = "video 1 has been posted";
//anno9.courseId = "cs551";
//read1.readId = "read" + uniqueIdTime(ref counter);
//read1.annId = "cs440assignment1";
//read1.read = "false";
//read1.stuName = "user1";
//read2.readId = "read" + uniqueIdTime(ref counter);
//read2.annId = "cs555assignment1";
//read2.read = "false";
//read2.stuName = "user1";
//read3.readId = "read" + uniqueIdTime(ref counter);
//read3.annId = "cs551assignment1";
//read3.read = "false";
//read3.stuName = "user1";
//read4.readId = "read" + uniqueIdTime(ref counter);
//read4.annId = "cs440handout1";
//read4.read = "false";
//read4.stuName = "user1";
//read5.readId = "read" + uniqueIdTime(ref counter);
//read5.annId = "cs555handout1";
//read5.read = "false";
//read5.stuName = "user1";
//read6.readId = "read" + uniqueIdTime(ref counter);
//read6.annId = "cs551handout1";
//read6.read = "false";
//read6.stuName = "user1";
//read7.readId = "read" + uniqueIdTime(ref counter);
//read7.annId = "cs440video1";
//read7.read = "false";
//read7.stuName = "user1";
//read8.readId = "read" + uniqueIdTime(ref counter);
//read8.annId = "cs555video1";
//read8.read = "false";
//read8.stuName = "user1";
//read9.readId = "read" + uniqueIdTime(ref counter);
//read9.annId = "cs551video1";
//read9.read = "false";
//read9.stuName = "user1";
//read10.readId = "read" + uniqueIdTime(ref counter);
//read10.annId = "cs440assignment1";
//read10.read = "false";
//read10.stuName = "user2";
//read11.readId = "read" + uniqueIdTime(ref counter);
//read11.annId = "cs555assignment1";
//read11.read = "false";
//read11.stuName = "user2";
//read12.readId = "read" + uniqueIdTime(ref counter);
//read12.annId = "cs551assignment1";
//read12.read = "false";
//read12.stuName = "user2";
//read13.readId = "read" + uniqueIdTime(ref counter);
//read13.annId = "cs440handout1";
//read13.read = "false";
//read13.stuName = "user2";
//read14.readId = "read" + uniqueIdTime(ref counter);
//read14.annId = "cs555handout1";
//read14.read = "false";
//read14.stuName = "user2";
//read15.readId = "read" + uniqueIdTime(ref counter);
//read15.annId = "cs551handout1";
//read15.read = "false";
//read15.stuName = "user2";
//read16.readId = "read" + uniqueIdTime(ref counter);
//read16.annId = "cs440video1";
//read16.read = "false";
//read16.stuName = "user2";
//read17.readId = "read" + uniqueIdTime(ref counter);
//read17.annId = "cs555video1";
//read17.read = "false";
//read17.stuName = "user2";
//read18.readId = "read" + uniqueIdTime(ref counter);
//read18.annId = "cs551video1";
//read18.read = "false";
//read18.stuName = "user2";
if (false)
{
//db.Courses.Remove(course1);
//db.Courses.Remove(course2);
//db.Courses.Remove(course3);
//db.Assignments.Remove(asm1);
//db.Assignments.Remove(asm2);
//db.Assignments.Remove(asm3);
//db.Assignments.Remove(asm4);
//db.Files.Remove(file1);
//db.Files.Remove(file2);
//db.Files.Remove(file3);
//db.Files.Remove(file4);
//db.Files.Remove(file5);
//db.Files.Remove(file6);
//db.Files.Remove(file7);
//db.Files.Remove(file8);
//db.Files.Remove(file9);
//db.Registers.Remove(grade1);
//db.Registers.Remove(grade2);
//db.Registers.Remove(grade3);
//db.Registers.Remove(grade4);
//db.Registers.Remove(grade5);
//db.Students.Remove(student1);
//db.Students.Remove(student2);
//db.Announcements.Remove(anno1);
//db.Announcements.Remove(anno2);
//db.Announcements.Remove(anno3);
//db.Announcements.Remove(anno4);
//db.Announcements.Remove(anno5);
//db.Announcements.Remove(anno6);
//db.Announcements.Remove(anno7);
//db.Announcements.Remove(anno8);
//db.Announcements.Remove(anno9);
//db.Professors.Remove(pro1);
//db.Professors.Remove(pro2);
//db.Reads.Remove(read1);
//db.Reads.Remove(read2);
//db.Reads.Remove(read3);
//db.Reads.Remove(read4);
//db.Reads.Remove(read5);
//db.Reads.Remove(read6);
//db.Reads.Remove(read7);
//db.Reads.Remove(read8);
//db.Reads.Remove(read9);
//db.Reads.Remove(read10);
//db.Reads.Remove(read11);
//db.Reads.Remove(read12);
//db.Reads.Remove(read13);
//db.Reads.Remove(read14);
//db.Reads.Remove(read15);
//db.Reads.Remove(read16);
//db.Reads.Remove(read17);
//db.Reads.Remove(read18);
}
//db.Courses.Add(course1);
//db.Courses.Add(course2);
//db.Courses.Add(course3);
//db.Assignments.Add(asm1);
//db.Assignments.Add(asm2);
//db.Assignments.Add(asm3);
//db.Assignments.Add(asm4);
//db.Files.Add(file1);
//db.Files.Add(file2);
//db.Files.Add(file3);
//db.Files.Add(file4);
//db.Files.Add(file5);
//db.Files.Add(file6);
//db.Files.Add(file7);
//db.Files.Add(file8);
//db.Files.Add(file9);
//db.Files.Add(file10);
//db.Registers.Add(grade1);
//db.Registers.Add(grade2);
//db.Registers.Add(grade3);
//db.Registers.Add(grade4);
//db.Registers.Add(grade5);
//db.Students.Add(student1);
//db.Students.Add(student2);
//db.Announcements.Add(anno1);
//db.Announcements.Add(anno2);
//db.Announcements.Add(anno3);
//db.Announcements.Add(anno4);
//db.Announcements.Add(anno5);
//db.Announcements.Add(anno6);
//db.Announcements.Add(anno7);
//db.Announcements.Add(anno8);
//db.Announcements.Add(anno9);
//db.Professors.Add(pro1);
//db.Professors.Add(pro2);
//db.Reads.Add(read1);
//db.Reads.Add(read2);
//db.Reads.Add(read3);
//db.Reads.Add(read4);
//db.Reads.Add(read5);
//db.Reads.Add(read6);
//db.Reads.Add(read7);
//db.Reads.Add(read8);
//db.Reads.Add(read9);
//db.Reads.Add(read10);
//db.Reads.Add(read11);
//db.Reads.Add(read12);
//db.Reads.Add(read13);
//db.Reads.Add(read14);
//db.Reads.Add(read15);
//db.Reads.Add(read16);
//db.Reads.Add(read17);
//db.Reads.Add(read18);
//db.SaveChanges();
}
// POST api/Auth
public HttpResponseMessage PostStudent(Student student)
{
UBOnlineWebApiTest2Context db = new UBOnlineWebApiTest2Context();
if (ModelState.IsValid)
{
//db.Students.Add(student);
//db.SaveChanges();
IQueryable<Student> stuOut =
from s in db.Students
where (s.stuName == student.stuName && s.password == student.password)
orderby s.stuName
select s;
if (stuOut.Count<Student>()!=0)
{
//HttpContext.Current.Session["USERNAME"] = stuOut.ToList<Student>().ElementAt<Student>(0).stuName;
//SessionFacade.USERNAME = stuOut.ToList<Student>().ElementAt<Student>(0).stuName;
//Console.WriteLine(SessionFacade.USERNAME);
//Application["USERNAME"] = stuOut.ToList<Student>().ElementAt<Student>(0).stuName;
Global.USERSIN.Add(stuOut.ToList<Student>().ElementAt<Student>(0).stuName);
}
if (stuOut != null && stuOut.Count<Student>() != 0)
{
HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, student.stuName);
response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = student.stuName }));
return response;
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}
else
{
return Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState);
}
}