public static List<Exemption> GetExemptionsFor(ExemptionStatus status) { try { switch (status) { case ExemptionStatus.NotWorked: var notworked = AdministrativeProperties_DTO.GetAll(x=>x.Status == status); var worked = AdministrativeProperties_DTO.GetAll(x=>x.Status == ExemptionStatus.Approved); worked.AddRange(AdministrativeProperties_DTO.GetAll(x=>x.Status == ExemptionStatus.Pending)); var m = MasterExemption_DTO.GetMasterExemptionsList_Exclude(worked); return m.Select(x => new Exemption(x, notworked.FirstOrDefault(a => a.OnlineExemptionID == x.OnlineExemptionID))).ToList(); default: var apc = AdministrativeProperties_DTO.GetAll(x=>x.Status == status); var mec = MasterExemption_DTO.GetMasterExemptionsList_For(apc); return mec.Select(x => new Exemption(x, apc.FirstOrDefault(a => a.OnlineExemptionID == x.OnlineExemptionID))).ToList(); } } catch (Exception ex) { throw ex; } }
public static bool SetExemptionStatus(int quedExemptionId, ExemptionStatus exemptionStatus) { using (HomesteadViewerContext context = new HomesteadViewerContext()) { var e = context.Exemptions.FirstOrDefault(ex => ex.QuedExemptionId == quedExemptionId); //Add Exemption if (e == null) { Mapper.CreateMap<Models.QuedExemption, Models.Exemption>() .ForMember(dest => dest.QuedExemptionId, opt => opt.MapFrom(src => src.ID)); var exemption = Mapper.Map<QuedExemption, Exemption>(GetQuedExemptionById(quedExemptionId)); exemption.Status = exemptionStatus; return AddExemption(exemption); } } using (HomesteadViewerContext context = new HomesteadViewerContext()) { var e = context.Exemptions.FirstOrDefault(ex => ex.QuedExemptionId == quedExemptionId); e.Status = exemptionStatus; context.Exemptions.Attach(e); context.Entry(e).Property(x => x.Status).IsModified = true; context.SaveChanges(); } return true; }
public static int GetCountFor(ExemptionStatus status) { switch (status) { case ExemptionStatus.NotWorked: int approvePending = AdministrativeProperties_DTO.Count(x=>x.Status == ExemptionStatus.Approved) + AdministrativeProperties_DTO.Count(x=>x.Status == ExemptionStatus.Pending); int me = MasterExemption_DTO.Count(); return me - approvePending; default: return AdministrativeProperties_DTO.Count(x=>x.Status == status); } }
public static List<ChartDateStat> ChartDateStat(ExemptionStatus status, int days) { var data = new List<ChartDateStat>(); try { List<AdministrativeProperties_DTO> apList = new List<AdministrativeProperties_DTO>(); data = AdministrativeProperties_DTO.GetAll(x => x.Status == status && x.DateStatusChanged != null && x.DateStatusChanged.Value.Date > DateTime.Now.AddDays(-15)) .GroupBy(x => x.DateStatusChanged.Value.Date) .Select(x => x.First()) .Select(x => new ChartDateStat() { Id = x.DateStatusChanged.Value.Date, Total = AdministrativeProperties_DTO.Count(y => y.Status == ExemptionStatus.Pending && y.DateStatusChanged != null && y.DateStatusChanged.Value.Date == x.DateStatusChanged.Value.Date) }) .ToList(); } catch (Exception ex) { ex.Log("DashboardViewModel", "PendingByDate"); } return data; }