public HttpResponseMessage Post(ProposalAddRequest model) { if (!ModelState.IsValid) { return(Request.CreateResponse(HttpStatusCode.BadRequest, ModelState)); } ItemResponse <int> response = new ItemResponse <int>(); response.Item = ProposalService.Post(model); ProposalSendRequest sendRequest = new ProposalSendRequest(); sendRequest.FirstName = model.FirstName; sendRequest.LastName = model.LastName; sendRequest.Email = model.Email; sendRequest.PhoneNumber = model.PhoneNumber; sendRequest.Deadline = model.Deadline; sendRequest.Budget = model.Budget; sendRequest.Company = model.Company; sendRequest.ProjectType = model.ProjectType; sendRequest.Description = model.Description; _emailService.SendProposalAdmin(sendRequest); ProposalSendRequest userRequest = new ProposalSendRequest(); userRequest.FirstName = model.FirstName; userRequest.LastName = model.LastName; userRequest.Email = model.Email; _emailService.SendProposalUser(userRequest); return(Request.CreateResponse(HttpStatusCode.OK, response)); }
public static int Post(ProposalAddRequest model) { int id = 0; DataProvider.ExecuteNonQuery(GetConnection, "dbo.Proposal_Insert" , inputParamMapper : delegate(SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Description", model.Description); paramCollection.AddWithValue("@Budget", model.Budget); paramCollection.AddWithValue("@Deadline", model.Deadline); paramCollection.AddWithValue("@ProjectType", model.ProjectType); paramCollection.AddWithValue("@FirstName", model.FirstName); paramCollection.AddWithValue("@LastName", model.LastName); paramCollection.AddWithValue("@Company", model.Company); paramCollection.AddWithValue("@PhoneNumber", model.PhoneNumber); paramCollection.AddWithValue("@Email", model.Email); paramCollection.AddWithValue("@Notes", model.Notes); paramCollection.AddWithValue("@Status", model.StatusId); SqlParameter p = new SqlParameter("@Id", id); p.Direction = ParameterDirection.Output; paramCollection.Add(p); }, returnParameters : delegate(SqlParameterCollection param) { Int32.TryParse(param["@Id"].Value.ToString(), out id); }); return(id); }
private static void MapCommonParameters(ProposalAddRequest model, SqlParameterCollection paramCollection) { paramCollection.AddWithValue("@Description", model.Description); paramCollection.AddWithValue("@Budget", model.Budget); paramCollection.AddWithValue("@Deadline", model.Deadline); paramCollection.AddWithValue("@ProjectType", model.ProjectType); paramCollection.AddWithValue("@FirstName", model.FirstName); paramCollection.AddWithValue("@LastName", model.LastName); paramCollection.AddWithValue("@Company", model.Company); paramCollection.AddWithValue("@PhoneNumber", model.PhoneNumber); paramCollection.AddWithValue("@Email", model.Email); paramCollection.AddWithValue("@Notes", model.Notes); paramCollection.AddWithValue("@Status", model.StatusId); }