public List <OpenHouseAgentDetail> GetAgentOpenHousesByDateRange(OpenHouseDatesByAgentDetailRequest model) { List <OpenHouseAgentDetail> openHouseList = null; DataProvider.ExecuteCmd(GetConnection, "dbo.OpenHouses_SelectByAgentAndDates" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@AgentPersonId", model.AgentPersonId); paramCollection.AddWithValue("@StartDate", model.StartDate); if (model.EndDate.HasValue && (model.EndDate > model.StartDate)) { paramCollection.AddWithValue("@EndDate", model.EndDate); } }, map : delegate(IDataReader reader, short set) { OpenHouseAgentDetail agentOpenHouse = MapOpenHouseAgentDetailReader(reader); if (openHouseList == null) { openHouseList = new List <OpenHouseAgentDetail>(); } openHouseList.Add(agentOpenHouse); } ); return(openHouseList); }
public OpenHouseAgentDetail GetOpenHouseWithAgentDetail(int id) { OpenHouseAgentDetail openHouse = new OpenHouseAgentDetail(); DataProvider.ExecuteCmd(GetConnection, "dbo.OpenHouses_SelectByIdWithAppAgentDetail" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Id", id); }, map : delegate(IDataReader reader, short set) { openHouse = MapOpenHouseAgentDetailReader(reader); } ); return(openHouse); }
public HttpResponseMessage UpdateEmail(Hashtable model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } var v = model["visitor"].ToString(); var a = model["agent"].ToString(); var e = model["email"].ToString(); Visitor visitor = JsonConvert.DeserializeObject <Visitor>(v); OpenHouseAgentDetail agent = JsonConvert.DeserializeObject <OpenHouseAgentDetail>(a); Email email = JsonConvert.DeserializeObject <Email>(e); EmailPropertyUpdateRequest requestModel = new EmailPropertyUpdateRequest(visitor, agent, email); ItemResponse <Task <bool> > response = new ItemResponse <Task <bool> >(); response.Item = MessagingService.UpdateEmail(requestModel); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
private static OpenHouseAgentDetail MapOpenHouseAgentDetailReader(IDataReader reader) { OpenHouseAgentDetail agentOpenHouse = new OpenHouseAgentDetail(); int ordinalIndex = 0; agentOpenHouse.AgentPersonId = reader.GetSafeInt32(ordinalIndex++); agentOpenHouse.AgentFirstName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentLastName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentPhoneWork = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentEmailPublic = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentCompanyName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentAddress1 = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentAddress2 = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentCity = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentStateProvice = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentZipCode = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentWebSite = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentMlsId = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentLowResKeyName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.AgentHighResKeyName = reader.GetSafeString(ordinalIndex++); //from openhouse base agentOpenHouse.Id = reader.GetSafeInt32(ordinalIndex++); agentOpenHouse.ListingId = reader.GetSafeInt32(ordinalIndex++); agentOpenHouse.MlsListingId = reader.GetSafeString(ordinalIndex++); agentOpenHouse.ListPrice = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.StandardStatusName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.PropertySubTypeName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.YearBuilt = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.StreetName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.StreetSuffix = reader.GetSafeString(ordinalIndex++); agentOpenHouse.StreetAddress = reader.GetSafeString(ordinalIndex++); agentOpenHouse.UnitNumber = reader.GetSafeString(ordinalIndex++); agentOpenHouse.CityName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.StateOrProvince = reader.GetSafeString(ordinalIndex++); agentOpenHouse.PostalCode = reader.GetSafeString(ordinalIndex++); agentOpenHouse.LivingArea = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.LotSizeUnits = reader.GetSafeString(ordinalIndex++); agentOpenHouse.LotSizeSquareFeet = reader.GetSafeDecimalNullable(ordinalIndex++); agentOpenHouse.BedroomsTotal = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.BathroomsTotalInteger = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.BathroomsFull = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.BathroomsThreeQuarter = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.BathroomsHalf = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.BathroomsOneQuarter = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.ListAgentKeyNumeric = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.ListAgentMlsId = reader.GetSafeString(ordinalIndex++); agentOpenHouse.ListAgentStateLicense = reader.GetSafeString(ordinalIndex++); agentOpenHouse.ListAgentFirstName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.ListAgentLastName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.ListOfficeKeyNumeric = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.ListOfficeMlsId = reader.GetSafeString(ordinalIndex++); agentOpenHouse.ListOfficeName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.DefaultMediaURL = reader.GetSafeString(ordinalIndex++); agentOpenHouse.ListingKeyNumeric = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.OpenHouseKeyNumeric = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.OpenHouseDate = reader.GetSafeDateTime(ordinalIndex++); agentOpenHouse.OpenHouseStartTimeNumeric = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.OpenHouseEndTimeNumeric = reader.GetSafeInt32Nullable(ordinalIndex++); agentOpenHouse.OpenHouseStartTime = reader[ordinalIndex++] as TimeSpan?; agentOpenHouse.OpenHouseEndTime = reader[ordinalIndex++] as TimeSpan?; agentOpenHouse.OpenHouseStatus = reader.GetSafeString(ordinalIndex++); agentOpenHouse.OpenHouseStatusName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.OpenHouseType = reader.GetSafeString(ordinalIndex++); agentOpenHouse.OpenHouseTypeName = reader.GetSafeString(ordinalIndex++); agentOpenHouse.OpenHouseDirections = reader.GetSafeString(ordinalIndex++); agentOpenHouse.OpenHouseRemarks = reader.GetSafeString(ordinalIndex++); agentOpenHouse.OpenHouseAttendedBy = reader.GetSafeString(ordinalIndex++); agentOpenHouse.Refreshments = reader.GetSafeString(ordinalIndex++); agentOpenHouse.DrawingYN = reader.GetSafeBool(ordinalIndex++); agentOpenHouse.DeletedYN = reader.GetSafeBool(ordinalIndex++); agentOpenHouse.VisitorCount = reader.GetSafeInt32(ordinalIndex++); return(agentOpenHouse); }