public int Insert(PostedTicketAddRequest model)
{
int id = 0;
SqlParameter outParam = new SqlParameter("@Id", 0);
outParam.Direction = System.Data.ParameterDirection.Output;
Adapter.ExecuteNonQuery("dbo.PostedTickets_Insert",
new[]
{
new SqlParameter("@UserbaseId", model.UserbaseId),
new SqlParameter("@SellPrice", model.SellPrice),
new SqlParameter("@IsSold", model.IsSold),
new SqlParameter("@OnHold", model.OnHold),
new SqlParameter("@NumTickets", model.NumTickets),
new SqlParameter("@TicketImgUrl", model.TicketImgUrl),
new SqlParameter("@TicketConfirmUrl", model.TicketConfirmUrl),
new SqlParameter("@TicketOrderNum", model.TicketOrderNum),
new SqlParameter("@Section", model.Section),
new SqlParameter("@Row", model.Row),
new SqlParameter("@EventId", model.EventId),
outParam
},
(parameters) =>
{
id = parameters.GetParamValue <int>("@Id");
}
);
return(id);
}
public IHttpActionResult PostTicket(PostedTicketAddRequest model)
{
try
{
//if (!ModelState.IsValid) return BadRequest(new Exception().Message);
ItemResponse <int> response = new ItemResponse <int>
{
Item = _postedTicketService.Insert(model)
};
return(Ok(response));
}
catch (Exception ex)
{
return(BadRequest(ex.Message));
}
}