public string getStaffTypeName(string StaffTypeID) { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = _Context.StaffTypeModels.Where(x => x.StrStaffTypeID == StaffTypeID).Select(x => x.StrStaffTypeName).SingleOrDefault(); return(Result); } }
public List <string> lstSubjectID() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = _Context.SubjectModels.Select(c => c.StrSubjectID).ToList(); return(Result); } }
private string _getByIDMaxLecturer() { using (var _Context = new DBManageProjectStudentViewModel()) { var query = _Context.StaffModels.OrderByDescending(c => c.StrStaffID).Select(c => c.StrStaffID); var Result = query.First(); return(Result); } }
public DateTime getStartYear(string ClassID) { using (var _Context = new DBManageProjectStudentViewModel()) { var query = _Context.ClassModels.SingleOrDefault(c => c.StrClassID == ClassID); var Result = _Context.CourseModels.Where(c => c.StrCourseID == query.StrCourseID).Select(c => c.DtStartYear).SingleOrDefault(); return(Result); } }
public string getByIDMaxSubject() { using (var _Context = new DBManageProjectStudentViewModel()) { var query = _Context.SubjectModels.OrderByDescending(c => c.StrSubjectID).Select(c => c.StrSubjectID); var Result = query.First(); return(Result); } }
public bool checkStudentID(string StudentID) { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = _Context.StudentModels.SingleOrDefault(c => c.StrStudentID == StudentID); if (Result != null) { return(true); } return(false); } }
public BindingList <FormModel> loadForm() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.FormModels.AsEnumerable() select new FormModel { StrFormID = x.StrFormID, StrFormName = x.StrFormName }).ToList(); return(new BindingList <FormModel>(Result)); } }
public BindingList <StaffTypeModel> loadStaffType() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.StaffTypeModels.AsEnumerable() select new StaffTypeModel { StrStaffTypeID = x.StrStaffTypeID, StrStaffTypeName = x.StrStaffTypeName }).ToList(); return(new BindingList <StaffTypeModel>(Result)); } }
public BindingList <WordModel> loadWord() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.WordModels.AsEnumerable() select new WordModel { StrWordId = x.StrWordId, StrWordName = x.StrWordName, }).ToList(); return(new BindingList <WordModel>(Result)); } }
public BindingList <ResultProjectModel> loadResultProject() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.ResultProjectModels.AsEnumerable() select new ResultProjectModel { StrStudentID = x.StrStudentID, StrProjectID = x.StrProjectID, DGrade = x.DGrade }).ToList(); return(new BindingList <ResultProjectModel>(Result)); } }
public BindingList <CourseModel> loadCourse() { using (var _Context = new DBManageProjectStudentViewModel()) { var result = (from x in _Context.CourseModels.AsEnumerable() select new CourseModel { StrCourseID = x.StrCourseID, DtStartYear = x.DtStartYear, DtEndYear = x.DtEndYear }).ToList(); return(new BindingList <CourseModel>(result)); } }
public BindingList <ExamTimesModel> loadExamTimes() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.ExamTimesModels.AsEnumerable() select new ExamTimesModel { StrExamTimesID = x.StrExamTimesID, ITimes = x.ITimes, DtExamTime = x.DtExamTime }).ToList(); return(new BindingList <ExamTimesModel>(Result)); } }
public BindingList <FacultyModel> loadFaculty() { using (var _Context = new DBManageProjectStudentViewModel()) { var result = (from x in _Context.FacultyModels.AsEnumerable() select new FacultyModel { StrFacultyID = x.StrFacultyID, StrFacultyName = x.StrFacultyName, DtFoundedYear = x.DtFoundedYear }).ToList(); return(new BindingList <FacultyModel>(result)); } }
public BindingList <ClassModel> loadClass() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.ClassModels.AsEnumerable() select new ClassModel { StrClassID = x.StrClassID, StrClassName = x.StrClassName, StrFacultyID = x.StrFacultyID, StrCourseID = x.StrCourseID }).ToList(); return(new BindingList <ClassModel>(Result)); } }
public BindingList <ClassGroupOfSubject> loadClassGroupOfSubject() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.ClassGroupOfSubjects.AsEnumerable() select new ClassGroupOfSubject { StrGroupID = x.StrGroupID, StrGroupName = x.StrGroupName, StrStaffID = x.StrStaffID, StrSubjectID = x.StrSubjectID }).ToList(); return(new BindingList <ClassGroupOfSubject>(Result)); } }
public BindingList <SubjectModel> loadSubject() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.SubjectModels.AsEnumerable() select new SubjectModel { StrSubjectID = x.StrSubjectID, StrSubjectName = x.StrSubjectName, StrFacultyID = x.StrFacultyID, DtStartDay = x.DtStartDay, DtEndDay = x.DtEndDay }).ToList(); return(new BindingList <SubjectModel>(Result)); } }
public BindingList <ProjectModel> loadProject() { using (var _Context = new DBManageProjectStudentViewModel()) { var result = (from x in _Context.ProjectModels.AsEnumerable() select new ProjectModel { StrProjectID = x.StrProjectID, StrProjectName = x.StrProjectName, DtStartDay = x.DtStartDay, DtEndDay = x.DtEndDay, StrStaffID = x.StrStaffID, StrSubjectID = x.StrSubjectID }).ToList(); return(new BindingList <ProjectModel>(result)); } }
public BindingList <LanguageModel> loadLanguage() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.LanguageModels.AsEnumerable() select new LanguageModel { StrLanguageID = x.StrLanguageID, StrLanguageName = x.StrLanguageName, StrDefault = x.StrDefault, StrStatus = x.StrStatus, IOdering = x.IOdering, ILang_Default = x.ILang_Default }).ToList(); return(new BindingList <LanguageModel>(Result)); } }
public BindingList <LanguageWordModel> loadLanguageWord() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.LanguageWordModels.AsEnumerable() select new LanguageWordModel { StrID = x.StrID, StrWordID = x.StrWordID, StrLanguageID = x.StrLanguageID, StrMean = x.StrMean, StrStatus = x.StrStatus, StrModule = x.StrModule }).ToList(); return(new BindingList <LanguageWordModel>(Result)); } }
public BindingList <ProjectTaskModel> loadProjectTask() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.ProjectTaskModels.AsEnumerable() select new ProjectTaskModel { StrProjectID = x.StrProjectID, StrTaskID = x.StrTaskID, StrTaskName = x.StrTaskName, DtStartDay = x.DtStartDay, DtEndDay = x.DtEndDay, StrFileName = x.StrFileName, StrLinkFile = x.StrLinkFile }).ToList(); return(new BindingList <ProjectTaskModel>(Result)); } }
public BindingList <DecentralizeModel> loadDecentralize() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.DecentralizeModels.AsEnumerable() select new DecentralizeModel { StrFormID = x.StrFormID, StrStaffTypeID = x.StrStaffTypeID, BFullFuncion = x.BFullFuncion, BAdd = x.BAdd, BEdit = x.BEdit, BDelete = x.BDelete, BAccess = x.BAccess }).ToList(); return(new BindingList <DecentralizeModel>(Result)); } }
public BindingList <StaffModel> loadStaff() { using (var _Context = new DBManageProjectStudentViewModel()) { var Result = (from x in _Context.StaffModels.AsEnumerable() select new StaffModel { StrStaffID = x.StrStaffID, StrStaffName = x.StrStaffName, StrEmail = x.StrEmail, StrAddress = x.StrAddress, StrPhone = x.StrPhone, StrSex = x.StrSex, StrStatus = x.StrStatus, DtBirthDay = x.DtBirthDay, StrFacultyID = x.StrFacultyID, StrStaffTypeID = x.StrStaffTypeID, StrCardID = x.StrCardID }).ToList(); return(new BindingList <StaffModel>(Result)); } }