public static List<MasterExemption_DTO> GetMasterExemption_For(AdministrativeProperties_DTO administrativProperties) { try { using (var context = new MasterHSContext()) { return context.MasterExemptions.Where(qe=>qe.OnlineExemptionID == administrativProperties.OnlineExemptionID).ToList(); } } catch (Exception ex) { throw ex; } }
public static List<MasterExemption_DTO> GetMasterExemptionsList_For(List<AdministrativeProperties_DTO> administraiveProperties_collcetion) { try { using (var context = new MasterHSContext()) { var mes = new List<MasterExemption_DTO>(); foreach (var ap in administraiveProperties_collcetion) { var me = context.MasterExemptions.FirstOrDefault(m => m.OnlineExemptionID == ap.OnlineExemptionID); if(me != null && me.QuickrefID == ap.QuickrefID) mes.Add(me); else { var ex = new Exception("An Orphaned Item exists in the database.") .Log("ID = " + ap.ID + "\n OnlineExemptionId = " + ap.OnlineExemptionID); } } return mes; } } catch (Exception e) { throw e; } }
public static MasterExemption_DTO GetMasterExemption_For(int onlinePropertyId) { try { using (var context = new MasterHSContext()) { return context.MasterExemptions.FirstOrDefault(qe=>qe.OnlineExemptionID == onlinePropertyId); } } catch (Exception ex) { throw ex; } }
public static List<MasterExemption_DTO> GetMasterExemptionsList_For(string quickRefId) { try { using (var context = new MasterHSContext()) { return context.MasterExemptions.Where(qe => qe.QuickrefID == quickRefId).ToList(); } } catch (Exception ex) { throw ex; } }
public static List<MasterExemption_DTO> GetMasterExemptionsList_For(DateTime createdDate) { try { using (var context = new MasterHSContext()) { return context.MasterExemptions.Where(qe => qe.Created.Date == createdDate.Date).ToList(); } } catch (Exception ex) { throw ex; } }
public static List<MasterExemption_DTO> GetAll(Func<MasterExemption_DTO, bool> func = null) { try { using (var context = new MasterHSContext()) { if(func != null) return context.MasterExemptions.Where(func).ToList(); return context.MasterExemptions.ToList(); } } catch (Exception ex) { throw ex; } }
public static List<MasterExemption_DTO> GetMasterExemptionsList_Exclude(List<AdministrativeProperties_DTO> administraiveProperties_collcetion) { try { using (var context = new MasterHSContext()) { var mes = context.MasterExemptions.ToList(); foreach (var ap in administraiveProperties_collcetion) mes.RemoveAll(me => me.OnlineExemptionID == ap.OnlineExemptionID); return mes; } } catch (Exception ex) { throw ex; } }
public static bool Exists(Func<MasterExemption_DTO, bool> func) { using (var context = new MasterHSContext()) { return context.MasterExemptions.Any(func); } }
public static bool Exists(int onlineExemptionId) { using (var context = new MasterHSContext()) { return context.MasterExemptions.Any(me => me.OnlineExemptionID == onlineExemptionId); } }
public static int Count(DateTime createdDate) { try { using (var context = new MasterHSContext()) { return context.MasterExemptions.Count(me=> DbFunctions.TruncateTime(me.Created) == createdDate.Date); } } catch (Exception ex) { return 0; } }
public static int Count(Func<MasterExemption_DTO, bool> func) { try { using (var context = new MasterHSContext()) { return context.MasterExemptions.Count(func); } } catch (Exception ex) { return 0; } }
public static int Count() { try { using (var context = new MasterHSContext()) { return context.MasterExemptions.Count(); } } catch (Exception ex) { return 0; } }