public async Task <MessageReport> Create(API_QRCodeResponseModel model, string evenid, string timein, string timeout, string plate)
{
var query = new StringBuilder();
query.AppendLine("INSERT INTO tblEventPayment (EventId, DateCreated, TimeIn, TimeOut, Plate, Money, OrderId, PaymentStatus, isSuccessQRCode, isSuccessPay, ResponseContentQRCode, ResponseContentPay) VALUES (");
query.AppendLine(string.Format("'{0}'", evenid));
query.AppendLine(", GETDATE()");
query.AppendLine(string.Format(", '{0}'", timein));
query.AppendLine(string.Format(", '{0}'", timeout));
query.AppendLine(string.Format(", '{0}'", plate));
query.AppendLine(string.Format(", {0}", model.qrCodeData.AMOUNT));
query.AppendLine(string.Format(", '{0}'", model.qrCodeData.ORDER_ID));
query.AppendLine(", 0");
query.AppendLine(", 1");
query.AppendLine(", 0");
query.AppendLine(string.Format(", '{0}'", JsonConvert.SerializeObject(model.qrCodeData)));
query.AppendLine(", ''");
query.AppendLine(")");
var result = new MessageReport(false, "error");
try
{
Kztek.Data.Event.SqlHelper.ExcuteSQLEvent.Execute(query.ToString());
result = new MessageReport(true, "success");
}
catch (Exception ex)
{
result = new MessageReport(false, ex.Message);
}
return(await Task.FromResult(result));
}
private async Task <MessageReport> Log_Payment(API_QRCodeResponseModel model, string eventid, string plate, string timein, string timeout)
{
return(await _tblEventPaymentService.Create(model, eventid, timein, timeout, plate));
}
