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