예제 #1
0
        private static OpenHouseBase MapOpenHouseReader(IDataReader reader)
        {
            OpenHouseBase openHouse = new OpenHouseBase();

            int ordinalIndex = 0;

            openHouse.Id                        = reader.GetSafeInt32(ordinalIndex++);
            openHouse.ListingId                 = reader.GetSafeInt32(ordinalIndex++);
            openHouse.MlsListingId              = reader.GetSafeString(ordinalIndex++);
            openHouse.ListPrice                 = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.StandardStatusName        = reader.GetSafeString(ordinalIndex++);
            openHouse.PropertySubTypeName       = reader.GetSafeString(ordinalIndex++);
            openHouse.YearBuilt                 = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.StreetName                = reader.GetSafeString(ordinalIndex++);
            openHouse.StreetSuffix              = reader.GetSafeString(ordinalIndex++);
            openHouse.StreetAddress             = reader.GetSafeString(ordinalIndex++);
            openHouse.UnitNumber                = reader.GetSafeString(ordinalIndex++);
            openHouse.CityName                  = reader.GetSafeString(ordinalIndex++);
            openHouse.StateOrProvince           = reader.GetSafeString(ordinalIndex++);
            openHouse.PostalCode                = reader.GetSafeString(ordinalIndex++);
            openHouse.LivingArea                = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.LotSizeUnits              = reader.GetSafeString(ordinalIndex++);
            openHouse.LotSizeSquareFeet         = reader.GetSafeDecimalNullable(ordinalIndex++);
            openHouse.BedroomsTotal             = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.BathroomsTotalInteger     = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.BathroomsFull             = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.BathroomsThreeQuarter     = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.BathroomsHalf             = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.BathroomsOneQuarter       = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.ListAgentKeyNumeric       = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.ListAgentMlsId            = reader.GetSafeString(ordinalIndex++);
            openHouse.ListAgentStateLicense     = reader.GetSafeString(ordinalIndex++);
            openHouse.ListAgentFirstName        = reader.GetSafeString(ordinalIndex++);
            openHouse.ListAgentLastName         = reader.GetSafeString(ordinalIndex++);
            openHouse.ListOfficeKeyNumeric      = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.ListOfficeMlsId           = reader.GetSafeString(ordinalIndex++);
            openHouse.ListOfficeName            = reader.GetSafeString(ordinalIndex++);
            openHouse.DefaultMediaURL           = reader.GetSafeString(ordinalIndex++);
            openHouse.ListingKeyNumeric         = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.OpenHouseKeyNumeric       = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.OpenHouseDate             = reader.GetSafeDateTime(ordinalIndex++);
            openHouse.OpenHouseStartTimeNumeric = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.OpenHouseEndTimeNumeric   = reader.GetSafeInt32Nullable(ordinalIndex++);
            openHouse.OpenHouseStartTime        = reader[ordinalIndex++] as TimeSpan?;
            openHouse.OpenHouseEndTime          = reader[ordinalIndex++] as TimeSpan?;
            openHouse.OpenHouseStatus           = reader.GetSafeString(ordinalIndex++);
            openHouse.OpenHouseStatusName       = reader.GetSafeString(ordinalIndex++);
            openHouse.OpenHouseType             = reader.GetSafeString(ordinalIndex++);
            openHouse.OpenHouseTypeName         = reader.GetSafeString(ordinalIndex++);
            openHouse.OpenHouseDirections       = reader.GetSafeString(ordinalIndex++);
            openHouse.OpenHouseRemarks          = reader.GetSafeString(ordinalIndex++);
            openHouse.OpenHouseAttendedBy       = reader.GetSafeString(ordinalIndex++);
            openHouse.Refreshments              = reader.GetSafeString(ordinalIndex++);
            openHouse.DrawingYN                 = reader.GetSafeBool(ordinalIndex++);
            openHouse.DeletedYN                 = reader.GetSafeBool(ordinalIndex++);
            openHouse.VisitorCount              = reader.GetSafeInt32(ordinalIndex++);

            return(openHouse);
        }
예제 #2
0
        public OpenHouseBase Get(int id)
        {
            OpenHouseBase openHouse = new OpenHouseBase();

            DataProvider.ExecuteCmd(GetConnection, "dbo.OpenHouses_SelectById"
                                    , inputParamMapper : delegate(SqlParameterCollection paramCollection)
            {
                paramCollection.AddWithValue("@Id", id);
            }, map : delegate(IDataReader reader, short set)
            {
                openHouse = MapOpenHouseReader(reader);
            }
                                    );

            return(openHouse);
        }
예제 #3
0
        public List <OpenHouseBase> GetActiveOpenHousesBySearch(OpenHouseDatesSearchRequest model)
        {
            List <OpenHouseBase> openHouseList = null;

            DataProvider.ExecuteCmd(GetConnection, "dbo.OpenHouses_SelectAllActiveBySearch"
                                    , inputParamMapper : delegate(SqlParameterCollection paramCollection)
            {
                paramCollection.AddWithValue("@StartDate", model.StartDate);
                if (model.EndDate.HasValue && (model.EndDate > model.StartDate))
                {
                    paramCollection.AddWithValue("@EndDate", model.EndDate);
                }
                else
                {
                    paramCollection.AddWithValue("@EndDate", null);
                }
                paramCollection.AddWithValue("@ListingKeyNumeric", model.ListingKeyNumeric);
                paramCollection.AddWithValue("@MlsListingId", model.MlsListingId);
                paramCollection.AddWithValue("@PostalCode", model.PostalCode);
                paramCollection.AddWithValue("@CityName", model.CityName);
                paramCollection.AddWithValue("@MaxRows", model.MaxRows);
            }, map : delegate(IDataReader reader, short set)
            {
                OpenHouseBase openHouse = MapOpenHouseReader(reader);

                if (openHouseList == null)
                {
                    openHouseList = new List <OpenHouseBase>();
                }

                openHouseList.Add(openHouse);
            }
                                    );

            return(openHouseList);
        }