public KhoaHocKiThuat CreateKhoaHocKiThuat(KhoaHocKithuatDTO khoaHocKithuatDTO)
{
using (var _db = new HoatDongTraiNghiemDB())
{
KhoaHocKiThuat khoaHocKiThuat = new KhoaHocKiThuat();
khoaHocKiThuat.DongGopHs1 = khoaHocKithuatDTO.DongGopHs1;
khoaHocKiThuat.DongGopHs2 = khoaHocKithuatDTO.DongGopHs2;
khoaHocKiThuat.HocSinh1 = khoaHocKithuatDTO.HocSinh1;
khoaHocKiThuat.HocSinh2 = khoaHocKithuatDTO.HocSinh2;
khoaHocKiThuat.IsCaNhan = khoaHocKithuatDTO.IsCaNhan;
khoaHocKiThuat.LinhVucId = khoaHocKithuatDTO.LinhVucId;
khoaHocKiThuat.LopIdHocSinh1 = khoaHocKithuatDTO.LopIdHocSinh1;
khoaHocKiThuat.LopIdhocSinh2 = khoaHocKithuatDTO.LopIdhocSinh2;
khoaHocKiThuat.TenDeTai = khoaHocKithuatDTO.TenDeTai;
khoaHocKiThuat.SchoolId = khoaHocKithuatDTO.SchoolId;
khoaHocKiThuat.CreatedAt = DateTime.Now;
khoaHocKiThuat.GVHD = khoaHocKithuatDTO.GVHD;
khoaHocKiThuat.Email = khoaHocKithuatDTO.Email;
khoaHocKiThuat.SDT = khoaHocKithuatDTO.SDT;
khoaHocKiThuat.DVCongTac = khoaHocKithuatDTO.DVCongTac;
_db.KhoaHocKiThuats.Add(khoaHocKiThuat);
_db.SaveChanges();
return(khoaHocKiThuat);
}
}
public KhoaHocKiThuat GetKhoaHocKiThuatById(int id)
{
using (var _db = new HoatDongTraiNghiemDB())
{
KhoaHocKiThuat khoaHocKiThuat = _db.KhoaHocKiThuats.Where(s => s.Id == id).SingleOrDefault();
return(khoaHocKiThuat);
}
}
public List <Province> GetProvinces()
{
using (HoatDongTraiNghiemDB _db = new HoatDongTraiNghiemDB())
{
var provinces = _db.Provinces.Where(s => s.CountryId == 237).OrderBy(s => s.Name).ToList();
return(provinces);
}
}
public List <KHKTLinhVucThamGia> GetKHKTLinhVucThamGias()
{
using (var _db = new HoatDongTraiNghiemDB())
{
List <KHKTLinhVucThamGia> kHKTLinhVucThamGias = _db.KHKTLinhVucThamGias.Where(s => s.IsActive == true).ToList();
return(kHKTLinhVucThamGias);
}
}
public Registration GetRegistrationsById(int id)
{
using (var _db = new HoatDongTraiNghiemDB())
{
var social = _db.Registrations.Include("Jobtitle").Include("Province").Where(s => s.Id == id).SingleOrDefault();
return(social);
}
}
public List <Registration> GetRegistrations(DateTime dateFrom, DateTime dateTo)
{
using (var _db = new HoatDongTraiNghiemDB())
{
var list = _db.Registrations.Include("Jobtitle").Include("Province").Where(s => s.DateRegisted >= dateFrom && s.DateRegisted <= dateTo && s.SchoolId != null).OrderBy(s => s.DateRegisted).ToList();
return(list);
}
}
public T_DM_Truong GetTruongBySchoolId(string schoolId)
{
using (var _db = new HoatDongTraiNghiemDB())
{
var school = _db.Database.SqlQuery <T_DM_Truong>($"SELECT * FROM [Server_VS].[CSDL].[dbo].[T_DM_Truong] WHERE [SchoolID] = '${schoolId}'").SingleOrDefault();
return(school);
}
}
public List <HoatDongNgoaiKhoa> GetHoatDongNgoaiKhoasBySchoolId(string schoolId)
{
using (var _db = new HoatDongTraiNghiemDB())
{
var list = _db.HoatDongNgoaiKhoas.Include("JobTitle").Include("Province").Where(s => s.SchoolId == schoolId).OrderBy(s => s.DateRegisted).ToList();
return(list);
}
}
public List <SubjectsRegisted> GetSubjectsRegistedsByRegistrationId(int id)
{
using (HoatDongTraiNghiemDB _db = new HoatDongTraiNghiemDB())
{
var subjectsRegisteds = _db.SubjectsRegisteds.Include("Subject").Where(s => s.RegistrationId == id).ToList();
return(subjectsRegisteds);
}
}
public IQueryable <SessionADay> GetSessionADays()
{
using (HoatDongTraiNghiemDB _db = new HoatDongTraiNghiemDB())
{
var sessionADays = _db.SessionADays;
return(sessionADays);
}
}
public SocialLifeSkill GetSocialLifeSkillsById(int id)
{
using (var _db = new HoatDongTraiNghiemDB())
{
var social = _db.SocialLifeSkills.Include("Jobtitle").Where(s => s.Id == id).SingleOrDefault();
return(social);
}
}
public List <Jobtitle> GetJobtitles()
{
using (HoatDongTraiNghiemDB _db = new HoatDongTraiNghiemDB())
{
var jobtitles = _db.Jobtitles.Where(s => s.IsActive == true).ToList();
return(jobtitles);
}
}
public List <Subject> GetSubjects()
{
using (HoatDongTraiNghiemDB _db = new HoatDongTraiNghiemDB())
{
var subjects = _db.Subjects.Where(s => s.IsActive == true).ToList();
return(subjects);
}
}
public List <SocialLifeSkill> GetSocialLifeSkills(DateTime dateFrom, DateTime dateTo)
{
using (var _db = new HoatDongTraiNghiemDB())
{
var list = _db.SocialLifeSkills.Include("Jobtitle").Where(s => s.DateFrom >= dateFrom && s.DateFrom <= dateTo && s.SchoolId != null).OrderBy(s => s.DateFrom).ToList();
return(list);
}
}
public List <Program> GetPrograms()
{
using (var _db = new HoatDongTraiNghiemDB())
{
var programs = _db.Programs.AsNoTracking().Where(s => s.IsActive == true).ToList();
return(programs);
}
}
public List <SocialLifeSkill> GetSocialLifeSkillsBySchoolId(string schoolId)
{
using (var _db = new HoatDongTraiNghiemDB())
{
var list = _db.SocialLifeSkills.Include("Jobtitle").Where(s => s.SchoolId == schoolId).OrderBy(s => s.DateFrom).ToList();
return(list);
}
}
public List <Program> GetProgramsAll()
{
using (var _db = new HoatDongTraiNghiemDB())
{
var programs = _db.Programs.AsNoTracking().ToList();
return(programs);
}
}
public KHKTLinhVucThamGia GetHKTLinhVucThamGiaById(int id)
{
using (var _db = new HoatDongTraiNghiemDB())
{
KHKTLinhVucThamGia kHKTLinhVucThamGia = _db.KHKTLinhVucThamGias.Where(s => s.Id == id).SingleOrDefault();
return(kHKTLinhVucThamGia);
}
}
public HoatDongNgoaiKhoa GetHoatDongNgoaiKhoaById(int id)
{
using (var _db = new HoatDongTraiNghiemDB())
{
HoatDongNgoaiKhoa hoatDongNgoaiKhoa = _db.HoatDongNgoaiKhoas.Include("JobTitle").Include("Province").Where(s => s.Id == id).SingleOrDefault();
return(hoatDongNgoaiKhoa);
}
}
public List <Registration> GetRegistrationsBySchoolId(string schoolId)
{
using (var _db = new HoatDongTraiNghiemDB())
{
var list = _db.Registrations.Include("Jobtitle").Include("Province").Where(s => s.SchoolId == schoolId).OrderBy(s => s.DateRegisted).ToList();
return(list);
}
}
public List <HoatDongNgoaiKhoa> GetHoatDongNgoaiKhoasByRange(DateTime dateFrom, DateTime dateTo)
{
using (var _db = new HoatDongTraiNghiemDB())
{
var list = _db.HoatDongNgoaiKhoas.Include("JobTitle").Include("Province").Where(s => s.DateRegisted >= dateFrom && s.DateRegisted <= dateTo).Where(s => s.SchoolId != null).OrderBy(s => s.DateRegisted).ToList();
return(list);
}
}
public List <KhoaHocKiThuat> GetKhoaHocKiThuatByDeTaiId(int id)
{
using (var _db = new HoatDongTraiNghiemDB())
{
List <KhoaHocKiThuat> khoaHocKiThuats = _db.KhoaHocKiThuats.Where(s => s.LinhVucId == id && s.CreatedAt.Value.Year == DateTime.Now.Year).ToList();
return(khoaHocKiThuats);
}
}
public SubjectsRegisted CreateSubjectRegisted(SubjectsRegisted subjectsRegisted)
{
using (HoatDongTraiNghiemDB _db = new HoatDongTraiNghiemDB())
{
var subjectRegisted = _db.SubjectsRegisteds.Add(subjectsRegisted);
_db.SaveChanges();
return(subjectsRegisted);
}
}
public SocialLifeSkill UpdateSocialLifeSkills(SocialLifeSkill socialLifeSkill)
{
using (var _db = new HoatDongTraiNghiemDB())
{
_db.Entry(socialLifeSkill).State = EntityState.Modified;
_db.SaveChanges();
return(socialLifeSkill);
}
}
public SocialLifeSkill CreateSocialLifeSkills(SocialLifeSkill socialLifeSkill)
{
using (var _db = new HoatDongTraiNghiemDB())
{
_db.SocialLifeSkills.Add(socialLifeSkill);
_db.SaveChanges();
return(socialLifeSkill);
}
}
public List <Program> GetProgramsByAccountId(int accountId)
{
using (var _db = new HoatDongTraiNghiemDB())
{
var listProgramPermission = _db.ProgramPermissions.AsNoTracking().Where(s => s.AccountId == accountId && s.Program.IsActive == true).Select(s => s.ProgramId).ToList();
var listProgarm = _db.Programs.Where(s => listProgramPermission.Contains(s.Id)).ToList();
return(listProgarm);
}
}
public HoatDongNgoaiKhoa UpdateHoatDongNgoaiKhoa(HoatDongNgoaiKhoa hoatDongNgoaiKhoa)
{
using (var _db = new HoatDongTraiNghiemDB())
{
_db.Entry(hoatDongNgoaiKhoa).State = EntityState.Modified;
_db.SaveChanges();
return(hoatDongNgoaiKhoa);
}
}
public HoatDongNgoaiKhoa CreateHoatDongNgoaiKhoa(HoatDongNgoaiKhoa hoatDongNgoaiKhoa)
{
using (var _db = new HoatDongTraiNghiemDB())
{
_db.HoatDongNgoaiKhoas.Add(hoatDongNgoaiKhoa);
_db.SaveChanges();
return(hoatDongNgoaiKhoa);
}
}
public Registration UpdateRegistration(Registration registration)
{
using (var _db = new HoatDongTraiNghiemDB())
{
_db.Entry(registration).State = EntityState.Modified;
_db.SaveChanges();
return(registration);
}
}
public RegistrationCreativeExp SaveRegistrationCreativeExp(RegistrationCreativeExp registrationCreativeExp)
{
using (var _db = new HoatDongTraiNghiemDB())
{
_db.RegistrationCreativeExps.Add(registrationCreativeExp);
_db.SaveChanges();
return(registrationCreativeExp);
}
}
