internal void UpdateOrderTicket(OrderTicketModel orderTicket)
{
using (var db = new DBContext()){
UpdateOrder(db, orderTicket.Id, orderTicket.OrderId, orderTicket.FirstName, orderTicket.LastName);
UpdateTicket(db, orderTicket.Id, orderTicket.TicketNumber, orderTicket.EventDate, orderTicket.TicketId);
}
}
internal void SaveOrderTicket(OrderTicketModel orderTicket)
{
using (var db = new DBContext()){
int orderId = SaveOrder(db, orderTicket.OrderId, orderTicket.FirstName, orderTicket.LastName);
SaveTicket(db, orderId, orderTicket.TicketNumber, orderTicket.EventDate);
}
}
public IActionResult OrderTicket(OrderTicketModel model)
{
try
{
_orderRepository.OrderTicket(model);
return(Json(new { success = true, message = "Заявка була успішно відправлена" }));
}
catch (Exception ex)
{
return(Json(new { success = false, message = ex.Message }));
}
}
public void OrderTicket(OrderTicketModel orderTicketModel)
{
using (SqlConnection con = new SqlConnection(_connectionString))
{
string sqlQuery = @"DECLARE @Price MONEY = (SELECT TOP 1 Price FROM TicketVariation tv WHERE tv.Id = @TicketVariationId)
INSERT INTO Request (UserId, TicketVariationId, RequestStateId, PaymentMethodId, Month, Price)
VALUES (@UserId, @TicketVariationId, 1, @PaymentMethodId, @Month, @Price);";
con.Execute(sqlQuery, new
{
UserId = orderTicketModel.UserId,
TicketVariationId = orderTicketModel.TicketVariationId,
PaymentMethodId = orderTicketModel.PaymentMethodId,
Month = orderTicketModel.Month
});
}
}
public IActionResult Post([FromBody] OrderTicketModel orderTicket)
{
try{
if (!ModelState.IsValid)
{
return(BadRequest());
}
if (orderTicket.Id == 0)
{
ordenTicketMan.SaveOrderTicket(orderTicket);
}
else
{
ordenTicketMan.UpdateOrderTicket(orderTicket);
}
return(Ok(ordenTicketMan.GetAllOrderTickets()));
}catch (Exception ex) {
return(StatusCode((int)HttpStatusCode.InternalServerError, ex.Message));
}
}