protected override bool AuthorizeCore(HttpContextBase httpContext) { bool authorize = false; var userName = Convert.ToString(httpContext.Session["UserName"]); if (!string.IsNullOrEmpty(userName)) { using (var context = new HrmsEntities()) { var userRole = (from u in context.tblUsers join r in context.tblRoles on u.RoleId equals r.Id join a in context.tblAdminchecks on u.AdminId equals a.AdminId where u.UserName == userName select new { r.RoleName, a.desc }).FirstOrDefault(); foreach (var role in allowedroles) { if (role == userRole.RoleName || role == userRole.desc) { return(true); } } } } return(authorize); }
public JsonResult GetPositiontoremove(int?Id) { HrmsEntities db = new HrmsEntities(); db.Configuration.ProxyCreationEnabled = false; return(Json(db.tblPositions.Where(p => p.DepartmentId != Id).Select(x => new { x.Id, x.Position }), JsonRequestBehavior.AllowGet)); }
public ActionResult GetslcanList() { HrmsEntities entities = new HrmsEntities(); IRepository repo = new ApplicantRepository(); var date = DateTime.Today.GetDateTimeFormats(); var today = DateTime.Now; var tommorrow = DateTime.Now.AddDays(1).Date; var Data = entities.tblApplicants.Where(x => x.Status == "Called for Interview" && DbFunctions.TruncateTime(x.InterviewDate) == DbFunctions.TruncateTime(today) || DbFunctions.TruncateTime(x.InterviewDate) == DbFunctions.TruncateTime(tommorrow)) .AsEnumerable() .Select(x => new { x.ApplicantName, x.Phone, x.Email, x.Appliedfor, x.Status, x.ApplicationId, x.InterviewDate }).ToList(); return(Json(new { data = Data }, JsonRequestBehavior.AllowGet)); }
public UserRepository(HrmsEntities context) { context = this.context; }
public UserRepository() { context = new HrmsEntities(); }
public Procure(HrmsEntities context) { context = this.context; }
public DepartmentRepository(HrmsEntities context) { context = this.context; }
public ApplicantRepository() { context = new HrmsEntities(); }
public MembershipRepository() { _dbContext = new HrmsEntities(); }
public EmployeeRepository() { context = new HrmsEntities(); }
public StructuredetailRepository(HrmsEntities context) { context = this.context; }
public StructuredetailRepository() { context = new HrmsEntities(); }
public NationalityRepository() { _dbContext = new HrmsEntities(); }
public CostCenterRepository() { _dbContext = new HrmsEntities(); }
public SkillRepository() { _dbContext = new HrmsEntities(); }
public CountryRepository() { _dbContext = new HrmsEntities(); }
public LanguageRepository() { _dbContext = new HrmsEntities(); }
public EmployeeRepository(HrmsEntities context) { context = this.context; }
public LocationRepository() { _dbContext = new HrmsEntities(); }
public LicenseRepository() { _dbContext = new HrmsEntities(); }
public TimeZoneRepository() { _dbContext = new HrmsEntities(); }
public Procure() { context = new HrmsEntities(); }
public ApplicantRepository(HrmsEntities context) { context = this.context; }
public DepartmentRepository() { context = new HrmsEntities(); }