public override TVmOpenApiStreet TranslateEntityToVm(AddressStreet entity)
{
if (entity == null)
{
return(null);
}
return(CreateBaseDefinitions(entity)
.GetFinal());
}
private bool CheckFields()
{
if (AddressStreet.Equals(string.Empty) || AddressCity.Equals(string.Empty) || AddressHouseNo.Equals(string.Empty))
{
throw new Exception("Please fill in the fields");
}
if (!FieldValidation.ValidateInt(AddressZip))
{
throw new Exception("Invalid Zip Code");
}
return(true);
}
public override TVmOpenApiStreetWithCoordinates TranslateEntityToVm(AddressStreet entity)
{
if (entity == null)
{
return(null);
}
var definition = CreateBaseDefinitions(entity);
// Select user defined coordinates or default to service provided ones.
var preferredCoordinate = entity.Address.Coordinates.FirstOrDefault(c => typesCache.GetByValue <CoordinateType>(c.TypeId) == CoordinateTypeEnum.User.ToString())
?? entity.Address.Coordinates.FirstOrDefault(c => typesCache.GetByValue <CoordinateType>(c.TypeId) == CoordinateTypeEnum.Main.ToString());
if (preferredCoordinate != null)
{
definition.AddNavigation(i => preferredCoordinate.Latitude.ToString(CultureInfo.InvariantCulture), o => o.Latitude);
definition.AddNavigation(i => preferredCoordinate.Longitude.ToString(CultureInfo.InvariantCulture), o => o.Longitude);
definition.AddNavigation(i => preferredCoordinate.CoordinateState, o => o.CoordinateState);
}
return(definition.GetFinal());
}
public ListingComm(string mls)
{
MLS = mls;
//try {
using (SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["ApplicationServices"].ConnectionString)) {
string SQL = "SELECT [Access24Hour],[AddFeeFrequency],[AdditionalFeeDes]," +
"[AdditionalFeesAmt],[Adult55Community],[AirConditioning]," +
"[AlternateMLSNumber],[Amenities],[AtticDescription]," +
"[BasementDescription],[BathsFull],[BathsHalf]," +
"[BathsTotal],[BedsTotal],[City]," +
"[CloseDate],[ComplexName],[ConstructionDescription]," +
"[ContractDate],[CountyOrParish],[CurrentPrice]," +
"[ElementarySchool],[Fireplacesnumberof],[FloorNumber]," +
"[Garbage],[GasAvailableYN],[Hamlet]," +
"[HeatingFuel],[HeatingType],[HeatingZonesNumof]," +
"[HighSchool],[HoaFeeIncludes],[Hotwater]," +
"[Included],[Junior_MiddleHighSchool],[LastLeasePrice]," +
"[LeasePrice],[LeaseTerm],[ListAgentDirectWorkPhone]," +
"[ListAgentEmail],[ListAgentFullName],[ListAgentMLSID]," +
"[LotDescription],[LotSizeArea],[LotSizeAreaSQFT]," +
"[MarketingRemarks],[Matrix_Unique_ID],l1.[MLSNumber]," +
"[MonthlyHOAFee],[NumOfLevels],[OpenHouseUpcoming]," +
"[OriginalLeasePrice],[Parking],[PhotoCount]," +
"[PostalCode],[PostalCodePlus4],[PropertySubType]," +
"[PropertyType],[PublicTransportation],[REO_BankOwned]," +
"[RoomCount],[SchoolDistrict],[SewerDescription]," +
"[SidingDescription],[SprinklerSystemYN],[SqFtSource]," +
"[SqFtTotal],[StateOrProvince],[Status]," +
"[StreetDirPrefix],[StreetDirSuffix],[StreetName]," +
"[StreetNumber],[StreetNumberModifier],[StreetSuffix]," +
"[StreetType],[Style],[TaxAmount]," +
"[TaxSource],[TaxYear],[TotalRoomsFinished]," +
"[TransactionType],[TypeofDwelling],[TypeofUnit]," +
"[UnitCount],[UnitNumber],[Village]," +
"[VirtualTourLink],[WaterAccessYN],[WaterDescription]," +
"[YearBuilt],[YearBuiltException],[YearRenovated],[Zoning], " +
"ISNULL(l2.[Lat], 0), ISNULL(l2.[Long], 0) " +
"FROM [dbo].[listings-commercial-3] l1 LEFT JOIN [listings-geo] l2 ON l1.[MLSNumber] = l2.[MLSNumber] " +
"WHERE l1.[MLSNumber] = @MLS";
using (SqlCommand cmd = new SqlCommand(SQL, cn)) {
cmd.CommandType = CommandType.Text;
cmd.Parameters.Add("MLS", SqlDbType.Float).Value = Convert.ToDouble(MLS);
cmd.Connection.Open();
SqlDataReader dr = cmd.ExecuteReader();
if (dr.HasRows)
{
dr.Read();
Access24Hour = dr.GetBoolean(0);
if (dr[3].ToString() != "-1")
{
AdditionalFees = string.Format("{0:$#,###}", dr[3]) + " ";
}
AdditionalFees += (" " + dr[1].ToString() + " " + dr[2].ToString()).Trim();
Adult55Community = dr.GetBoolean(4);
AirConditioning = dr[5].ToString();
FeaturesAmenities = dr[7].ToString();
Attic = dr[8].ToString();
Basement = dr[9].ToString();
FullBaths = dr[10].ToString();
HalfBaths = dr[11].ToString();
if (dr[13].ToString() != "-1")
{
Bedrooms = dr[13].ToString();
}
City = dr[14].ToString();
ComplexName = dr[16].ToString();
Construction = dr[17].ToString();
County = dr[19].ToString();
float aa = 0;
float.TryParse(dr[20].ToString(), out aa);
AskingAmt = aa;
AskingPrice = string.Format("{0:$#,###}", dr[20]);
if (dr[22].ToString() != "-1" && dr[22].ToString() != "0")
{
Fireplace = dr[22].ToString();
}
if (dr[23].ToString() != "-1")
{
FloorNumber = dr.GetInt32(23);
}
Garbage = dr[24].ToString();
GasAvailableYN = dr.GetBoolean(25);
Fuel = dr[27].ToString();
Heating = dr[28].ToString();
if (dr[29].ToString() != "-1")
{
HeatingZones = dr[29].ToString();
}
HOAFeeIncludes = dr[31].ToString();
WaterHeater = dr[32].ToString();
Included = dr[33].ToString();
AgentPhone = dr[38].ToString();
AgentName = dr[40].ToString();
AgentID = dr[41].ToString();
if (dr[35].ToString() != "-1")
{
LastLeasePrice = string.Format("{0:$#,###}", dr[35]);
}
if (dr[36].ToString() != "-1")
{
LeasePrice = string.Format("{0:$#,###}", dr[36]);
}
if (dr[51].ToString() != "-1")
{
OriginalLeasePrice = string.Format("{0:$#,###}", dr[51]);
}
LeaseTerm = dr[37].ToString();
LotDescription = dr[42].ToString();
if (dr[43].ToString() != "-1")
{
Acres = dr[43].ToString();
}
if (dr[44].ToString() != "-1")
{
LotSquareFeet = dr[44].ToString();
}
Remarks = dr[45].ToString();
MatrixUnique = dr[46].ToString();
MLS = dr[47].ToString();
if (dr[48].ToString() != "-1")
{
HomeownersFees = string.Format("{0:$#,###}", dr[48]);
}
if (dr[49].ToString() != "-1")
{
Levels = dr[49].ToString();
}
Parking = dr[52].ToString();
PhotoCount = dr.GetInt32(53);
Zip = dr[54].ToString();
if (dr[55].ToString().Length > 0)
{
Zip += "-" + dr[55].ToString();
}
SubType = dr[56].ToString();
Type = dr[57].ToString();
REO = dr.GetBoolean(59);
if (dr.GetInt32(60) > -1)
{
Rooms = dr[60].ToString();
}
SchoolDistrict = dr[61].ToString();
Sewer = dr[62].ToString();
Exterior = dr[63].ToString();
SprinklerSystemYN = dr.GetBoolean(64);
if (dr[66].ToString() != "-1")
{
TotalSquareFeet = string.Format("{0:#,###}", dr[66]);
}
State = dr[67].ToString();
Status = dr[68].ToString();
if (dr[72].ToString() != "")
{
AddressStreet = dr[72].ToString() + " ";
}
if (dr[73].ToString() != "")
{
AddressStreet = AddressStreet.Trim() + dr[73].ToString() + " ";
}
if (dr[69].ToString() != "")
{
AddressStreet += dr[69].ToString() + " ";
}
if (dr[71].ToString() != "")
{
AddressStreet += dr[71].ToString() + " ";
}
if (dr[70].ToString() != "")
{
AddressStreet += dr[70].ToString() + " ";
}
if (dr[74].ToString() != "")
{
AddressStreet += dr[74].ToString();
}
AddressStreet = (AddressStreet ?? "").Trim();
Road = dr[75].ToString();
Style = dr[76].ToString();
if (dr[77].ToString() != "-1")
{
TotalTaxes = string.Format("{0:$#,###}", dr[77]);
}
if (dr[79].ToString() != "-1")
{
TaxYear = dr[79].ToString();
}
if (dr[80].ToString() != "-1")
{
RoomsFinished = dr[80].ToString();
}
TransactionType = dr[81].ToString();
UnitNumber = dr[85].ToString();
VirtualTour = dr[87].ToString();
WaterAccess = dr.GetBoolean(88);
Water = dr[89].ToString();
if (dr[90].ToString() != "-1")
{
YearBuilt = dr[90].ToString();
}
Zoning = dr[93].ToString();
Lat = (float)dr.GetDouble(94);
Long = (float)dr.GetDouble(95);
}
else
{
MLS = null;
}
cmd.Connection.Close();
}
}
//} catch { }
}
public override VmOpenApiAddressStreetWithCoordinates TranslateEntityToVm(AddressStreet entity)
{
return(base.TranslateEntityToVm(entity));
}
protected ITranslationDefinitions <AddressStreet, TVmOpenApiStreet> CreateBaseDefinitions(AddressStreet entity)
{
if (entity == null)
{
return(null);
}
var postalCode = entity.PostalCode;
bool codeExists = postalCode != null && postalCode.Code.ToLower() != "undefined";
return(CreateEntityViewModelDefinition(entity)
.AddCollection(i => i.StreetNames, o => o.Street)
.AddNavigation(i => i.StreetNumber, o => o.StreetNumber)
.AddNavigation(i => codeExists ? postalCode.Code : null, o => o.PostalCode)
.AddCollection(i => codeExists ? postalCode.PostalCodeNames : null, o => o.PostOffice)
.AddNavigation(i => i.Municipality, o => o.Municipality)
.AddCollection(i => i.Address.AddressAdditionalInformations, o => o.AdditionalInformation));
}
