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