public List <Course> getAssignedFoundationCourses(string studentId, string ctlg, string mjr) { var result = ""; List <Course> list = new List <Course>(); using (CPSCreationEntities db = new CPSCreationEntities()) { var student = db.StudentDetails.Where(o => o.studentID.ToLower().Equals(studentId)); if (student.Any()) { result = student.FirstOrDefault().AssignedFoundation; } } if (!result.Equals("None") && !result.Equals("")) { List <string> str = result.Split(',').ToList(); foreach (string c in str) { string cShrtName = c; Course crs = getCourseDetailUsingCourseShortName(c, ctlg, mjr); list.Add(crs); } } return(list); }
public void updateStudentDetails(string studentId, List <Course> assignedFoundationClasses, string facultyAd) { string cShtName; List <string> list = new List <string>(); string foundationsString = ""; if (assignedFoundationClasses != null) { foreach (Course c in assignedFoundationClasses) { cShtName = c.CourseShortName; list.Add(cShtName); } foundationsString = string.Join(",", list.ToArray()); } using (CPSCreationEntities db = new CPSCreationEntities()) { var result = db.StudentDetails.SingleOrDefault(b => b.studentID == studentId); if (result != null) { result.AssignedFoundation = foundationsString; result.AssignedFacultyAdvisor = facultyAd; db.SaveChanges(); } } }//end of updateStudentDetails
}//getCourseDetailsUsingCourseShortName public List <List <Course> > getAllCompletedCourseDetails(string studentId, string ctlg, string mjr) { List <List <Course> > list = new List <List <Course> >(); List <Course> completedCoreCourses = new List <Course>(); List <Course> completedElectiveCourses = new List <Course>(); List <Course> completedFoundationCourses = new List <Course>(); var result = ""; using (CPSCreationEntities db = new CPSCreationEntities()) { var student = db.StudentDetails.Where(o => o.studentID.ToLower().Equals(studentId)); if (student.Any()) { result = student.FirstOrDefault().completedCoursesAndGrades; } } if (result != null) { List <string> str = result.Split('|').ToList(); List <string> spStr = new List <string>(); foreach (string c in str) { spStr = c.Split(',').ToList(); string csSname = spStr[0]; string csGrade = spStr[1]; string csSem = spStr[2]; Course crs = getCourseDetailUsingCourseShortName(csSname, ctlg, mjr); string type = crs.CourseType; if (crs.CourseType.Equals("C")) { Course coreCs = new Course(csSname, crs.CourseFullName, crs.CourseSubject, crs.Courselevel, crs.CreditHrs, crs.CourseType, csSem, csGrade); completedCoreCourses.Add(coreCs); } else if (crs.CourseType.Equals("F")) { Course coreCs = new Course(csSname, crs.CourseFullName, crs.CourseSubject, crs.Courselevel, crs.CreditHrs, crs.CourseType, csSem, csGrade); completedFoundationCourses.Add(coreCs); } else if (crs.CourseType.Equals("E")) { Course coreCs = new Course(csSname, crs.CourseFullName, crs.CourseSubject, crs.Courselevel, crs.CreditHrs, crs.CourseType, csSem, csGrade); completedElectiveCourses.Add(coreCs); } } list.Add(completedFoundationCourses); list.Add(completedCoreCourses); list.Add(completedElectiveCourses); } return(list); }//get all completedCourseDetails
public List <String> getAllElectiveForSWEN() { using (CPSCreationEntities db = new CPSCreationEntities()) { var results = db.Catalog16_17.Where(p => p.SWEN.Contains("E")).Select(p => new { p.Course }).Cast <string>().ToList();; return(results); } }
public string getStudentFirstName(string id) { using (CPSCreationEntities db = new CPSCreationEntities()) { var student = db.StudentDetails.Where(o => o.studentID.ToLower().Equals(id)); if (student.Any()) { return(student.FirstOrDefault().firstName); } } return(""); }
public string getStudentMajor(string studentId) { using (CPSCreationEntities db = new CPSCreationEntities()) { var student = db.StudentDetails.Where(o => o.studentID.ToLower().Equals(studentId)); if (student.Any()) { return(student.FirstOrDefault().majorName); } else { return(String.Empty); } } }
public string GetFacultyNameByID(string id) { using (CPSCreationEntities db = new CPSCreationEntities()) { var res = db.FacultyDetails.Where(o => o.FacultyId.Equals(id)); if (res.Any()) { return(res.SingleOrDefault().First_Name + " " + res.SingleOrDefault().Last_Name); } else { return(null); } } }
public List <Course> getAllElectiveDetailsForSWEN() { using (CPSCreationEntities db = new CPSCreationEntities()) { var results = db.Catalog16_17.Where(p => p.SWEN.Contains("E")).Select(p => new Course { CourseShortName = p.Course, CourseFullName = p.LongTitle, CourseSubject = p.Subject, Courselevel = p.Catalog, CreditHrs = p.creditHrs }).ToList(); return(results); } }
}//end of istheStudentNew public bool doesStudentExist(string studentId) { bool flag = false; using (CPSCreationEntities db = new CPSCreationEntities()) { var student = db.StudentDetails.Where(o => o.studentID.ToLower().Equals(studentId)); if (student.Any()) { if (student.FirstOrDefault().studentID == studentId) { flag = true; } else { flag = false; } } } return(flag); }
public List <string> getAllFacultyAdvisorForDepartment(string major) { List <String> list = new List <string>(); String str = ""; using (CPSCreationEntities db = new CPSCreationEntities()) { var results = db.FacultyDetails.Where(p => p.AdvisorDepartment.Contains(major)).Select(p => new FacultyDetails { FirstName = p.First_Name, LastName = p.Last_Name, FacultyId = p.FacultyId, }).ToList(); foreach (FacultyDetails f in results) { str = f.FirstName + " " + f.LastName; list.Add(str); } return(list); } }
}//end of updateStudentDetails public void updateFacultyDetails(string studentId, string facultyName) { string firstNameFaculty = ""; string[] words = facultyName.Split(' '); firstNameFaculty = words[0]; string studentListStr = studentId + ","; using (CPSCreationEntities db = new CPSCreationEntities()) { Boolean flag = false; var result = db.FacultyDetails.SingleOrDefault(b => b.First_Name == firstNameFaculty); if (result != null) { var check = result.AdvisingStudentList; if (check != null) { flag = true; } if (flag) { if (result.AdvisingStudentList.Contains(studentListStr)) { result.AdvisingStudentList = result.AdvisingStudentList; } else { result.AdvisingStudentList += studentListStr; } } else { result.AdvisingStudentList = studentListStr; } db.SaveChanges(); } } }
public bool isTheStudentNew(string studentId) { bool flag = false; using (CPSCreationEntities db = new CPSCreationEntities()) { var student = db.StudentDetails.Where(o => o.studentID.ToLower().Equals(studentId)); if (student.Any()) { if (student.FirstOrDefault().currentSemester == student.FirstOrDefault().admittedSemester) { flag = true; } else { flag = false; } } } return(flag); }//end of istheStudentNew
}//end of getRegisteredCourseDetails public Course getCourseDetailUsingCourseShortName(string csname, string ctlg, string mjr) { Course crs = new Course(); if (ctlg.Equals("Catalog16_17")) { if (mjr.Equals("SWEN")) { using (CPSCreationEntities db = new CPSCreationEntities()) { var course = db.Catalog16_17.Where(o => o.Course.ToLower().Equals(csname)); if (course.Any()) { string csShortName = course.FirstOrDefault().Course; string csLongName = course.FirstOrDefault().LongTitle; string csCredits = course.FirstOrDefault().creditHrs; string csType = course.FirstOrDefault().SWEN; string csSubject = course.FirstOrDefault().Subject; string csCatalog = course.FirstOrDefault().Catalog; crs = new Course(csShortName, csLongName, csSubject, csCatalog, csCredits, csType); } } return(crs); } else if (mjr.Equals("CSCI")) { } else if (mjr.Equals("SENG")) { } } else if (ctlg.Equals("Catalog17_18")) { } return(crs); }//getCourseDetailsUsingCourseShortName
public string catalogNeedsTofollow(string studentId) { string strCatalog = ""; using (CPSCreationEntities db = new CPSCreationEntities()) { var student = db.StudentDetails.Where(o => o.studentID.ToLower().Equals(studentId)); if (student.Any()) { string admittedSem = student.FirstOrDefault().admittedSemester; if (admittedSem.Equals("Fall16") || admittedSem.Equals("Spring17") || admittedSem.Equals("Summer17")) { strCatalog = "Catalog16_17"; } else if (admittedSem.Equals("Fall17") || admittedSem.Equals("Spring18") || admittedSem.Equals("Summer18")) { strCatalog = "Catalog17_18"; } } } return(strCatalog); }