public async Task <string> CreateAsync(
decimal value,
PaymentTypes type,
User user,
Dictionary <string, string> metadata,
Currency currency = null)
{
currency ??= user.Currency;
metadata[Payment.TypeMetadataName] = type.ToString();
if (currency.Key != Currency.RUB.Key)
{
using var client = new HttpClient();
const string url = "https://www.cbr-xml-daily.ru/daily_json.js";
var result = await client.GetAsync(url);
var rate = JsonConvert.DeserializeObject <CurrenciesRate>(await result.Content.ReadAsStringAsync());
if (Equals(currency, Currency.EUR))
{
value *= Convert.ToDecimal(rate.Valute.EUR.Value);
}
else if (Equals(currency, Currency.USD))
{
value *= Convert.ToDecimal(rate.Valute.USD.Value);
}
}
var newPayment = new NewPayment
{
Amount = new Amount {
Value = value, Currency = "RUB"
},
Metadata = metadata,
Confirmation = new Confirmation
{
Type = ConfirmationType.Redirect,
ReturnUrl = "localhost",
Locale = user.Culture.Key == Culture.Russian.Key ? "ru_RU" : "en_US"
},
};
var payment = await _client.CreatePaymentAsync(newPayment);
await SaveAsync(payment, user, currency, type);
return(payment.Confirmation.ConfirmationUrl);
}
public object ToCreateOrderRequest(
IDeliveryOrder order,
PaymentTypes payType,
decimal resultSum
)
{
var result = new TawseelahCreateOrderRequest
{
user_id = _userId,
sender_name = _restaurantName,
sender_contact = _restaurantContact,
pickup_address = _restaurantAddress,
item_description = order.Comment,
vehicle_type = "empty",
payment_type = payType.ToString(),
receiver_name = order.Client.Name,
receiver_contact = order.Client.Phones.Count() > 0 ? order.Client.Phones.First().Value : "Phone number is null",
amount = resultSum,
delivery_datetime = $"{order.ExpectedDeliverTime.Year}/{order.ExpectedDeliverTime.Month}/{order.ExpectedDeliverTime.Day} " +
$"{order.ExpectedDeliverTime.Hour}:{order.ExpectedDeliverTime.Minute}",
remarks = order.Comment,
delivery_type = TawseelahDeliveryTypes.NORMAL.ToString()
};
var chosenAddress = order.Address;
StringBuilder address = new StringBuilder();
if (chosenAddress.Region != null)
{
address.Append("Region: " + chosenAddress.Region.Name + ", ");
}
if (chosenAddress.Street != null)
{
address.Append("Street: " + chosenAddress.Street.Name + ", ");
}
address.Append("Index: " + chosenAddress.Index + ", ");
address.Append("House: " + chosenAddress.House + ", ");
address.Append("Building: " + chosenAddress.Building + ", ");
address.Append("Flat: " + chosenAddress.Flat);
result.receiver_address = address.ToString();
if (order.Latitude != null && order.Longitude != null)
{
result.pickup_lat = order.Latitude.Value;
result.pickup_lng = order.Longitude.Value;
}
return(result);
}
public void Refund(TransactionStatus RefundTransactionStatus, Int64 TransactionID, string ORNo, decimal ItemSold, decimal QuantitySold, decimal GrossSales, decimal SubTotal, decimal NetSales, decimal ItemsDiscount, decimal SNRItemsDiscount, decimal PWDItemsDiscount, decimal OtherItemsDiscount, decimal Discount, decimal SNRDiscount, decimal PWDDiscount, decimal OtherDiscount, decimal TransDiscount, DiscountTypes TransDiscountType, decimal VAT, decimal VATableAmount, decimal ZeroRatedSales, decimal NonVATableAmount, decimal VATExempt, decimal EVAT, decimal EVATableAmount, decimal NonEVATableAmount, decimal LocalTax, decimal AmountPaid, decimal CashPayment, decimal ChequePayment, decimal CreditCardPayment, decimal CreditPayment, decimal DebitPayment, decimal RewardPointsPayment, decimal RewardConvertedPayment, decimal BalanceAmount, decimal ChangeAmount, PaymentTypes PaymentType, string DiscountCode, string DiscountRemarks, decimal Charge, decimal ChargeAmount, string ChargeCode, string ChargeRemarks, Int64 CashierID, string CashierName)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "UPDATE tblTransactions SET " +
"ORNo = @ORNo, " +
"TransactionStatus = @TransactionStatus, " +
"ItemSold = @ItemSold, " +
"QuantitySold = @QuantitySold, " +
"GrossSales = @GrossSales, " +
"SubTotal = @SubTotal, " +
"NetSales = @NetSales, " +
"ItemsDiscount = @ItemsDiscount, " +
"SNRItemsDiscount = @SNRItemsDiscount, " +
"PWDItemsDiscount = @PWDItemsDiscount, " +
"OtherItemsDiscount = @OtherItemsDiscount, " +
"Discount = @Discount, " +
"SNRDiscount = @SNRDiscount, " +
"PWDDiscount = @PWDDiscount, " +
"OtherDiscount = @OtherDiscount, " +
"TransDiscount = @TransDiscount, " +
"TransDiscountType = @TransDiscType, " +
"VAT = @VAT, " +
"VATableAmount = @VATableAmount, " +
"ZeroRatedSales = @ZeroRatedSales, " +
"NonVATableAmount = @NonVATableAmount, " +
"VATExempt = @VATExempt, " +
"EVAT = @EVAT, " +
"EVATableAmount = @EVATableAmount, " +
"NonEVATableAmount = @NonEVATableAmount, " +
"LocalTax = @LocalTax, " +
"AmountPaid = @AmountPaid, " +
"CashPayment = @CashPayment, " +
"ChequePayment = @ChequePayment, " +
"CreditCardPayment = @CreditCardPayment, " +
"CreditPayment = @CreditPayment, " +
"DebitPayment = @DebitPayment, " +
"RewardPointsPayment = @RewardPointsPayment, " +
"RewardConvertedPayment = @RewardConvertedPayment, " +
"BalanceAmount = @BalanceAmount, " +
"ChangeAmount = @ChangeAmount, " +
"DateClosed = NOW(), " +
"PaymentType = @PaymentType, " +
"DiscountCode = @DiscCode, " +
"DiscountRemarks = @DiscRemarks, " +
"Charge = @Charge, " +
"ChargeAmount = @ChargeAmount, " +
"ChargeCode = @ChargeCode, " +
"ChargeRemarks = @ChargeRemarks, " +
"CashierID = @CashierID, " +
"CashierName = @CashierName, " +
"LastModified = NOW() " +
"WHERE TransactionID = @TransactionID;";
cmd.Parameters.AddWithValue("ORNo", ORNo);
cmd.Parameters.AddWithValue("TransactionStatus", RefundTransactionStatus.ToString("d"));
cmd.Parameters.AddWithValue("ItemSold", ItemSold);
cmd.Parameters.AddWithValue("QuantitySold", QuantitySold);
cmd.Parameters.AddWithValue("GrossSales", GrossSales);
cmd.Parameters.AddWithValue("SubTotal", SubTotal);
cmd.Parameters.AddWithValue("NetSales", NetSales);
cmd.Parameters.AddWithValue("ItemsDiscount", ItemsDiscount);
cmd.Parameters.AddWithValue("SNRItemsDiscount", SNRItemsDiscount);
cmd.Parameters.AddWithValue("PWDItemsDiscount", PWDItemsDiscount);
cmd.Parameters.AddWithValue("OtherItemsDiscount", OtherItemsDiscount);
cmd.Parameters.AddWithValue("Discount", Discount);
cmd.Parameters.AddWithValue("SNRDiscount", SNRDiscount);
cmd.Parameters.AddWithValue("PWDDiscount", PWDDiscount);
cmd.Parameters.AddWithValue("OtherDiscount", OtherDiscount);
cmd.Parameters.AddWithValue("TransDiscount", TransDiscount);
cmd.Parameters.AddWithValue("TransDiscType", TransDiscountType.ToString("d"));
cmd.Parameters.AddWithValue("VAT", VAT);
cmd.Parameters.AddWithValue("VATableAmount", VATableAmount);
cmd.Parameters.AddWithValue("ZeroRatedSales", ZeroRatedSales);
cmd.Parameters.AddWithValue("NonVATableAmount", NonVATableAmount);
cmd.Parameters.AddWithValue("VATExempt", VATExempt);
cmd.Parameters.AddWithValue("EVAT", EVAT);
cmd.Parameters.AddWithValue("EVATableAmount", EVATableAmount);
cmd.Parameters.AddWithValue("NonEVATableAmount", NonEVATableAmount);
cmd.Parameters.AddWithValue("LocalTax", LocalTax);
cmd.Parameters.AddWithValue("AmountPaid", AmountPaid);
cmd.Parameters.AddWithValue("CashPayment", CashPayment);
cmd.Parameters.AddWithValue("ChequePayment", ChequePayment);
cmd.Parameters.AddWithValue("CreditCardPayment", CreditCardPayment);
cmd.Parameters.AddWithValue("CreditPayment", CreditPayment);
cmd.Parameters.AddWithValue("DebitPayment", DebitPayment);
cmd.Parameters.AddWithValue("RewardPointsPayment", RewardPointsPayment);
cmd.Parameters.AddWithValue("RewardConvertedPayment", RewardConvertedPayment);
cmd.Parameters.AddWithValue("BalanceAmount", BalanceAmount);
cmd.Parameters.AddWithValue("ChangeAmount", ChangeAmount);
cmd.Parameters.AddWithValue("PaymentType", PaymentType.ToString("d"));
cmd.Parameters.AddWithValue("DiscCode", string.IsNullOrEmpty(DiscountCode) ? "" : DiscountCode);
cmd.Parameters.AddWithValue("DiscRemarks", DiscountRemarks);
cmd.Parameters.AddWithValue("Charge", Charge);
cmd.Parameters.AddWithValue("ChargeAmount", ChargeAmount);
cmd.Parameters.AddWithValue("ChargeCode", ChargeCode);
cmd.Parameters.AddWithValue("ChargeRemarks", string.IsNullOrEmpty(ChargeRemarks) ? "" : ChargeRemarks);
cmd.Parameters.AddWithValue("CashierID", CashierID);
cmd.Parameters.AddWithValue("CashierName", CashierName);
cmd.Parameters.AddWithValue("TransactionID", TransactionID);
cmd.CommandText = SQL;
base.ExecuteNonQuery(cmd);
SalesTransactionItems clsSalesTransactionItems = new SalesTransactionItems(base.Connection, base.Transaction);
clsSalesTransactionItems.RefundByTransaction(TransactionID);
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
public System.Data.DataTable ListAsDataTable(Int32 BranchID, string TerminalNo = "", Int64 TransactionID = 0, string TransactionNo = "", DateTime? TransactionDateFrom = null, DateTime? TransactionDateTo = null,
TransactionStatus TransactionStatus = TransactionStatus.NotYetApplied, PaymentTypes PaymentType = PaymentTypes.NotYetAssigned, bool isConsignment = false, bool isPacked = false,
string CustomerName = "", string CustomerGroupName = "", Int64 CashierID = 0, string CashierName = "", string AgentName = "",
bool WithTF = false, bool ShowSuspendedOnly = false, string SortField = "", SortOption SortOption = SortOption.Ascending, Int32 limit = 0)
{
try
{
MySqlCommand cmd = new MySqlCommand();
cmd.CommandType = System.Data.CommandType.Text;
string SQL = "CALL procTransactionsSelect(@BranchID, @TerminalNo, @TransactionID, @TransactionNo, @TransactionDateFrom, " +
"@TransactionDateTo, @TransactionStatus, @PaymentType, @isConsignment, @isPacked, @CustomerName, " +
"@CustomerGroupName, @CashierID, @CashierName, @AgentName, @WithTF, @ShowSuspended, " +
"@SortField, @SortOption, @Limit);";
cmd.Parameters.AddWithValue("BranchID", BranchID);
cmd.Parameters.AddWithValue("TerminalNo", TerminalNo);
cmd.Parameters.AddWithValue("TransactionID", TransactionID);
cmd.Parameters.AddWithValue("TransactionNo", TransactionNo);
cmd.Parameters.AddWithValue("TransactionDateFrom", TransactionDateFrom.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : TransactionDateFrom);
cmd.Parameters.AddWithValue("TransactionDateTo", TransactionDateTo.GetValueOrDefault() == DateTime.MinValue ? Constants.C_DATE_MIN_VALUE : TransactionDateTo);
cmd.Parameters.AddWithValue("TransactionStatus", TransactionStatus.ToString("d"));
cmd.Parameters.AddWithValue("PaymentType", PaymentType.ToString("d"));
cmd.Parameters.AddWithValue("isConsignment", isConsignment);
cmd.Parameters.AddWithValue("isPacked", isPacked);
cmd.Parameters.AddWithValue("CustomerName", CustomerName);
cmd.Parameters.AddWithValue("CustomerGroupName", CustomerGroupName);
cmd.Parameters.AddWithValue("CashierID", CashierID);
cmd.Parameters.AddWithValue("CashierName", CashierName);
cmd.Parameters.AddWithValue("AgentName", AgentName);
cmd.Parameters.AddWithValue("WithTF", WithTF);
cmd.Parameters.AddWithValue("ShowSuspended", ShowSuspendedOnly);
cmd.Parameters.AddWithValue("SortField", SortField);
cmd.Parameters.AddWithValue("SortOption", SortOption==SortOption.Ascending ? "ASC" : "DESC");
cmd.Parameters.AddWithValue("Limit", limit);
cmd.CommandText = SQL;
string strDataTableName = "tbl" + this.GetType().FullName.Split(new Char[] { '.' })[this.GetType().FullName.Split(new Char[] { '.' }).Length - 1]; System.Data.DataTable dt = new System.Data.DataTable(strDataTableName);
base.MySqlDataAdapterFill(cmd, dt);
return dt;
}
catch (Exception ex)
{
throw base.ThrowException(ex);
}
}
