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));
}
}
