public static List <ECBViolationsSummaryByAgency> GetECBViolationsSummaryByAgency(string propertyBBL)
{
using (NYCVNLEntities nycvnlE = new NYCVNLEntities())
{
return(nycvnlE.ECBViolationsSummaryByAgencies.Where(m => m.BBL == propertyBBL).ToList());
}
}
public static List <ECBViolationDetail> GetECBViolations(string propertyBBL, string active)
{
using (NYCVNLEntities nycvnlE = new NYCVNLEntities())
{
if (active.ToUpper() == "IGNORE")
{
return(Mapper.Map <List <MultiAgencyViolation>, List <ECBViolationDetail> >(nycvnlE.MultiAgencyViolations
.Where(i => i.BBL == propertyBBL)
.OrderByDescending(m => m.ViolationDate).ToList()));
}
else
{
if (active == "Y")
{
return(Mapper.Map <List <MultiAgencyViolation>, List <ECBViolationDetail> >(nycvnlE.MultiAgencyViolations
.Where(i => i.BBL == propertyBBL &&
i.HearingStatus != "WRITTEN OFF" &&
i.HearingStatus != "PAID IN FULL")
.OrderByDescending(m => m.ViolationDate).ToList()));
}
else
{
return(Mapper.Map <List <MultiAgencyViolation>, List <ECBViolationDetail> >(nycvnlE.MultiAgencyViolations
.Where(i => i.BBL == propertyBBL &&
(i.HearingStatus == "WRITTEN OFF" ||
i.HearingStatus == "PAID IN FULL"))
.OrderByDescending(m => m.ViolationDate).ToList()));
}
}
}
}
public static ECBViolationsSummary GetECBViolationsSummary(string propertyBBL)
{
using (NYCVNLEntities nycvnlE = new NYCVNLEntities())
{
return(nycvnlE.ECBViolationsSummaries.Find(propertyBBL));
}
}