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)); }