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