Exemplo n.º 1
0
 /// <summary>
 /// Обновить статус предварительной оплаты
 /// </summary>
 public override bool UpdatePayResultPre(string orderId, string[] arr)
 {
     using (var sqlExecutor = new SqlQueryPerformer())
     {
         var sqlQuery = string.Format(
             "update webfon.uniteller_requests set \"Status\" = '{1}'," +
             "\"ApprovalCode\" = '{2}', \"BillNumber\" = '{3}' where " +
             " id = '{0}'",
             orderId, arr[0], arr[1], arr[2]);
         sqlExecutor.PerformSql(sqlQuery);
     }
     return(true);
 }
Exemplo n.º 2
0
 /// <summary>
 /// Добавление предварительной оплаты
 /// </summary>
 public override bool SavePayResultPre(UniPay pay)
 {
     using (var sqlExecutor = new SqlQueryPerformer())
     {
         var sqlQuery = "insert into webfon.uniteller_requests (id,date_create, " +
                        "\"Customer_IDP\",\"LastName\",\"FirstName\",\"MiddleName\"," +
                        "\"Inn\",\"Address\",\"Email\",\"Comment\",\"Subtotal_P\"," +
                        "\"Shop_IDP\",\"LifeTime\",\"Signature\") " + $" values('{pay.OrderIdp}',now()," +
                        $"'{pay.CustomerIdp}','{pay.LastName}','{pay.FirstName}','{pay.MiddleName}'," +
                        $"'{pay.Inn}','{pay.Address}','{pay.Email}','{pay.Comment}','{pay.SubtotalP}'," +
                        $"'{pay.ShopIdp}','{pay.LifeTime}','{pay.Signature}')";
         sqlExecutor.PerformSql(sqlQuery);
     }
     return(true);
 }