public HttpResponseMessage PostVisitor(VisitorAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = _openHouseService.InsertVisitor(model); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public int InsertVisitor(VisitorAddRequest model) { int Id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.OpenHouseVisitors_Insert" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@openHouseId", model.OpenHouseId); paramCollection.AddWithValue("@firstName", model.FirstName); paramCollection.AddWithValue("@lastName", model.LastName); paramCollection.AddWithValue("@email", model.Email); paramCollection.AddWithValue("@phoneNumber", model.PhoneNumber); paramCollection.AddWithValue("@lookingForAgent", model.LookingForAgent); paramCollection.AddWithValue("@wantsUpdates", model.WantsUpdates); paramCollection.AddWithValue("@sendSimilar", model.SendSimilar); SqlParameter p = new SqlParameter("@id", System.Data.SqlDbType.Int); p.Direction = System.Data.ParameterDirection.Output; paramCollection.Add(p); }, returnParameters : delegate(SqlParameterCollection paramCollection) { int.TryParse(paramCollection["@id"].Value.ToString(), out Id); }); return(Id); }
public async Task <VisitorAddResponse> UpdateVisitor(VisitorAddRequest model) { return(await _visitorService.UpdateVisitor(model)); }