public static DOBComplaintsSummary GetDOBComplaintsSummary(string propertyBBL)
{
using (NYCDOBEntities nycdobE = new NYCDOBEntities())
{
return(Mapper.Map <DOBComplaintsSummary>(nycdobE.vwComplaintsSummaries.Where(i => i.BBL == propertyBBL).FirstOrDefault()));
}
}
public static List <CertificateOfOccupancy> GetCertificateOfOccupany(string propertybbl)
{
using (NYCDOBEntities dobE = new NYCDOBEntities())
{
return(dobE.CertificateOfOccupancies.Where(x => x.BBL == propertybbl).ToList());
}
}
public static List <Complaint> GetDOBCompliants(string propertyBBL, string active)
{
using (NYCDOBEntities nycdobE = new NYCDOBEntities())
{
if (active.ToUpper() == "IGNORE")
{
return(nycdobE.Complaints
.Where(i => i.BBL == propertyBBL)
.OrderByDescending(m => m.DateEntered).ToList());
}
else
{
return(nycdobE.Complaints
.Where(i => i.BBL == propertyBBL && i.Status == (active == "Y" ? "ACTIVE" : "CLOSED"))
.OrderByDescending(m => m.DateEntered).ToList());
}
}
}
public static List <Violation> GetDOBViolations(string propertyBBL, string active)
{
using (NYCDOBEntities nycdobE = new NYCDOBEntities())
{
if (active.ToUpper() == "IGNORE")
{
return(nycdobE.Violations
.Where(i => i.BBL == propertyBBL)
.OrderByDescending(m => m.IssueDate).ToList());
}
else
{
return(nycdobE.Violations
.Where(i => i.BBL == propertyBBL && i.IsClosed == (active.ToUpper() == "Y"?false:true))
.OrderByDescending(m => m.IssueDate).ToList());
}
}
}
