string HasLaundry()
{
if (!Amenities.Any(a => a.Contains("laundry", StringComparison.OrdinalIgnoreCase) || a.Contains("washer", StringComparison.OrdinalIgnoreCase) || a.Contains("dryer", StringComparison.OrdinalIgnoreCase)))
{
return("");
}
return(Amenities.Any(a => a.Contains("hook", StringComparison.OrdinalIgnoreCase)) ? "H" : "X");
}
public void UpdateNameIfAccessible()
{
if (Amenities != null && Amenities.Count > 0 && !Name.ToLower().Contains("accessible"))
{
if (Amenities.Any(a => a.Name.ToLower().Contains("wheelchair") || a.Name.ToLower().Contains("accessible")))
{
Name += ", Accessible";
}
}
}
public void SaveToSpreadsheet(WorkSheet worksheet, int rowIndex)
{
worksheet.SetCell(rowIndex, "Address", Address);
worksheet.SetCell(rowIndex, "Neighborhood", Neighboorhood);
worksheet.SetCell(rowIndex, "SqFeet", SquareFootageAsInt);
worksheet.SetCell(rowIndex, "Rooms", BedroomsAsInt);
worksheet.SetCell(rowIndex, "Price", RentAsDouble);
worksheet.SetCell(rowIndex, "Structure", UnitDetails);
worksheet.SetCell(rowIndex, "Comments", Comments);
worksheet.SetCell(rowIndex, "V", Visited);
worksheet.SetCell(rowIndex, "C", Called);
if (Rating != "")
{
worksheet.SetCell(rowIndex, "R", RatingAsInt);
}
worksheet.SetCellFormula(rowIndex, "Link", $"={SpreadsheetHyperlink}");
worksheet.SetCellFormula(rowIndex, "Map", $"=HYPERLINK(\"http://maps.google.com/?q={Address}\",\"Map\")");
worksheet.SetCellFormula(rowIndex, "Redfin", $"=HYPERLINK(\"https://www.google.com/search?q={Address} Redfin\",\"Redfin\")");
worksheet.SetCell(rowIndex, "Contact", Contact);
worksheet.SetCell(rowIndex, "D", Amenities.Any(a => a.Contains("dishwasher", StringComparison.OrdinalIgnoreCase)) ? "X" : "");
worksheet.SetCell(rowIndex, "L", HasLaundry());
}