public Model.Profile Single(int profileID)
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.Profiles.Single(pro => pro.ProfileID == profileID);
     }
 }

 public List<Model.Profile> AllByUserID(int userID)
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.Profiles.Where(pro => pro.UserID == userID && pro.Active == true).ToList();
     }
 }

 public List<Model.Profile> All()
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.Profiles.Where(p => p.Active == true).ToList();
     }
 }

 /// <summary>
 /// Lay tac ca ChucVu hien co
 /// </summary>
 /// <returns>List<ChucVu></returns>
 public List<WebPortal.Model.ChucVu> All()
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.ChucVus.ToList();
     }
 }

 public List<WebPortal.Model.ChucVu_GiaoVien> chucvu(int idGiaoVien)
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.ChucVu_GiaoVien.Where(app => app.IDGiaoVien == idGiaoVien).ToList();
     }
 }

 public List<Model.InRole> All()
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.InRoles.ToList();
     }
 }

 public Model.Setting Single(int settingID)
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.Settings.Single(setting => setting.SettingID == settingID);
     }
 }

 public WebPortal.Model.ToChuc Single(int idToChuc)
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.ToChucs.Single(app => app.IDToChuc == idToChuc);
     }
 }

 public List<WebPortal.Model.ToChuc_GiaoVien> All()
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.ToChuc_GiaoVien.ToList();
     }
 }

 public List<Model.User> All()
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.Users.Where(user => user.Active == true).ToList();
     }
 }

 public List<WebPortal.Model.TaiNguyen> Paging(int start, int numberRecords)
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.TaiNguyens.Skip(start).Take(numberRecords).ToList();
     }
 }

 public List<Model.Group> All()
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.Groups.Where(gr => gr.Active == true).ToList();
     }
 }

 public List<Model.Setting> Paging(int start, int numberRecords)
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.Settings.Skip(start).Take(numberRecords).ToList();
     }
 }

 public List<Model.Permission> Get_All()
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.Permissions.ToList();
     }
 }

 public List<WebPortal.Model.TaiNguyen_TinTuc> LayTaiNguyenTheoTin(int idTinTuc)
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.TaiNguyen_TinTuc.Where(app => app.IDTinTuc == idTinTuc).ToList();
     }
 }

 public List<Model.Permission> All()
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.Permissions.Where(per=>per.Active==true).ToList();
     }
 }

 public WebPortal.Model.TaiNguyen Single(int idTaiNguyen)
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.TaiNguyens.Single(app => app.IDTaiNguyen == idTaiNguyen);
     }
 }

 public List<WebPortal.Model.TinTuc> All()
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.TinTucs.ToList();
     }
 }

 public List<WebPortal.Model.TaiNguyen> All()
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.TaiNguyens.ToList();
     }
 }

 public List<WebPortal.Model.LoaiTin_Lv1> All()
 {
     using (WebPortalEntities dataEntities = new WebPortalEntities())
     {
         return dataEntities.LoaiTin_Lv1.ToList();
     }
 }