public async Task <ActionResult> KnetResponse()
{
string transData = HttpContext.Request.Form["trandata"];
PaymentResponseModel objResponse = await new PaymentUtility().AuthenticatePayment(transData);
if (objResponse is PaymentResponseModel && !string.IsNullOrEmpty(objResponse.Result) && objResponse.Result.ToUpper() == "CAPTURED")
{
PaymentHistoryModel oIncomingPay = new PaymentHistoryModel();
string CardCode = objResponse.UDF1.Split('_')[0];
string CardName = objResponse.UDF1.Split('_')[0];
string[] DocEntryNos = objResponse.UDF2.Split('_');
string[] DocNumbers = objResponse.UDF3.Split('_');
string[] TransferSums = objResponse.UDF4.Split('_');
string[] BranchIDs = objResponse.UDF5.Split('_');
for (int invCnt = 0; invCnt < DocEntryNos.Length; invCnt++)
{
oIncomingPay.IncomingPaymentData.Add(new IncomingPayment
{
CardCode = CardCode,
CardName = CardName,
DocEntryNo = DocEntryNos[invCnt],
DocNumber = DocNumbers[invCnt],
Remarks = "KNET Payment",
TransferSum = double.Parse(TransferSums[invCnt]),
BranchID = int.Parse(BranchIDs[invCnt]),
TransferRefrence = objResponse.PayReference
});
}
RentPayResponseModel paySaveRsp = await Connector.PayRentDue(oIncomingPay) as RentPayResponseModel;
}
return(View(@"~\Views\Rent\PayReciept.cshtml", objResponse));
}
public async Task CreateAsync(PaymentHistoryModel transaction)
{
var sql = $@"insert into payment_history (id, category_id, amount, date, created_by, notes)
values(@Id, @CategoryId, @Amount, @Date, @CreatedBy, @Notes);";
using var connection = await _connectionPool.OpenConnectionAsync();
await connection.ExecuteAsync(sql, transaction);
}
public async Task UpdateAsync(PaymentHistoryModel transaction)
{
var sql = $@"update payment_history
set amount = @Amount, category_id = @CategoryId, created_by = @CreatedBy, date = @Date, updated_at = now(), notes = @Notes
where id = @Id;";
using var connection = await _connectionPool.OpenConnectionAsync();
await connection.ExecuteAsync(sql, transaction);
}
public async Task <IActionResult> Post(CreatePaymentHistory paymentHistory)
{
var newPaymentHistory = new PaymentHistoryModel
{
Amount = paymentHistory.Amount,
CategoryId = paymentHistory.CategoryId,
CreatedBy = paymentHistory.CreatedBy,
Date = paymentHistory.Date,
Notes = paymentHistory.Notes
};
await _paymentHistoryService.CreateAsync(newPaymentHistory);
return(Ok());
}
private List <PaymentHistoryModel> getEmployeePaymentHistory()
{
conDB = new ConnectionDB();
List <PaymentHistoryModel> lstPayments = new List <PaymentHistoryModel>();
PaymentHistoryModel payment = new PaymentHistoryModel();
string queryString = "SELECT ID, amountpaid, date, notes FROM dbpackage.tblpaymenthistory WHERE isDeleted = 0 AND clientID = ? AND orderID = ?";
List <string> parameters = new List <string>();
parameters.Add(employeesModel.ID);
parameters.Add(orderHistory.ID);
MySqlDataReader reader = conDB.getSelectConnection(queryString, parameters);
while (reader.Read())
{
payment.ID = reader["ID"].ToString();
payment.AmountPaid = reader["amountpaid"].ToString();
double amtPaid = Convert.ToDouble(payment.AmountPaid);
dblTotalPaid = dblTotalPaid + amtPaid;
payment.Date = Convert.ToDateTime(reader["date"].ToString()).ToShortDateString();
if (string.IsNullOrEmpty(reader["notes"].ToString()))
{
payment.Notes = "";
}
else
{
payment.Notes = reader["notes"].ToString();
}
lstPayments.Add(payment);
payment = new PaymentHistoryModel();
}
conDB.closeConnection();
return(lstPayments);
}
private async void btnDelete_Click(object sender, RoutedEventArgs e)
{
PaymentHistoryModel payment = dgvPaymentHistory.SelectedItem as PaymentHistoryModel;
if (payment != null && homeStockModel != null)
{
MessageDialogResult result = await this.ShowMessageAsync("Delete Record", "Are you sure you want to delete record?", MessageDialogStyle.AffirmativeAndNegative);
if (result.Equals(MessageDialogResult.Affirmative))
{
deletePaymentRecord(payment.ID);
dgvPaymentHistory.ItemsSource = getHomeStockistPaymentHistory();
dgvPaymentHistory.Items.Refresh();
lblTotalPaid.Content = (Convert.ToDouble(dblTotalPaid) - Convert.ToDouble(payment.AmountPaid)).ToString();
double dblLblBalance = Convert.ToDouble(orderWin.lblBalance.Content);
dblLblBalance = dblLblBalance + Convert.ToDouble(payment.AmountPaid);
orderWin.lblBalance.Content = dblLblBalance.ToString("N0");
await this.ShowMessageAsync("Delete Record", "Record deleted successfully!");
}
}
else if (payment != null && megaStockModel != null)
{
MessageDialogResult result = await this.ShowMessageAsync("Delete Record", "Are you sure you want to delete record?", MessageDialogStyle.AffirmativeAndNegative);
if (result.Equals(MessageDialogResult.Affirmative))
{
deletePaymentRecord(payment.ID);
dgvPaymentHistory.ItemsSource = getMegaStockistPaymentHistory();
dgvPaymentHistory.Items.Refresh();
lblTotalPaid.Content = (Convert.ToDouble(dblTotalPaid) - Convert.ToDouble(payment.AmountPaid)).ToString();
double dblLblBalance = Convert.ToDouble(orderWin.lblBalance.Content);
dblLblBalance = dblLblBalance + Convert.ToDouble(payment.AmountPaid);
orderWin.lblBalance.Content = dblLblBalance.ToString("N0");
await this.ShowMessageAsync("Delete Record", "Record deleted successfully!");
}
}
else if (payment != null && depotStockModel != null)
{
MessageDialogResult result = await this.ShowMessageAsync("Delete Record", "Are you sure you want to delete record?", MessageDialogStyle.AffirmativeAndNegative);
if (result.Equals(MessageDialogResult.Affirmative))
{
deletePaymentRecord(payment.ID);
dgvPaymentHistory.ItemsSource = getDepotStockistPaymentHistory();
dgvPaymentHistory.Items.Refresh();
lblTotalPaid.Content = (Convert.ToDouble(dblTotalPaid) - Convert.ToDouble(payment.AmountPaid)).ToString();
double dblLblBalance = Convert.ToDouble(orderWin.lblBalance.Content);
dblLblBalance = dblLblBalance + Convert.ToDouble(payment.AmountPaid);
orderWin.lblBalance.Content = dblLblBalance.ToString("N0");
await this.ShowMessageAsync("Delete Record", "Record deleted successfully!");
}
}
else if (payment != null && employeesModel != null)
{
MessageDialogResult result = await this.ShowMessageAsync("Delete Record", "Are you sure you want to delete record?", MessageDialogStyle.AffirmativeAndNegative);
if (result.Equals(MessageDialogResult.Affirmative))
{
deletePaymentRecord(payment.ID);
dgvPaymentHistory.ItemsSource = getEmployeePaymentHistory();
dgvPaymentHistory.Items.Refresh();
lblTotalPaid.Content = (Convert.ToDouble(dblTotalPaid) - Convert.ToDouble(payment.AmountPaid)).ToString();
double dblLblBalance = Convert.ToDouble(orderWin.lblBalance.Content);
dblLblBalance = dblLblBalance + Convert.ToDouble(payment.AmountPaid);
orderWin.lblBalance.Content = dblLblBalance.ToString("N0");
await this.ShowMessageAsync("Delete Record", "Record deleted successfully!");
}
}
else if (payment != null && membersModel != null)
{
MessageDialogResult result = await this.ShowMessageAsync("Delete Record", "Are you sure you want to delete record?", MessageDialogStyle.AffirmativeAndNegative);
if (result.Equals(MessageDialogResult.Affirmative))
{
deletePaymentRecord(payment.ID);
dgvPaymentHistory.ItemsSource = getMembersPaymentHistory();
dgvPaymentHistory.Items.Refresh();
lblTotalPaid.Content = (Convert.ToDouble(dblTotalPaid) - Convert.ToDouble(payment.AmountPaid)).ToString();
double dblLblBalance = Convert.ToDouble(orderWin.lblBalance.Content);
dblLblBalance = dblLblBalance + Convert.ToDouble(payment.AmountPaid);
orderWin.lblBalance.Content = dblLblBalance.ToString("N0");
await this.ShowMessageAsync("Delete Record", "Record deleted successfully!");
}
}
}
public async Task <IActionResult> Put(PaymentHistoryModel transaction)
{
await _paymentHistoryService.UpdateAsync(transaction);
return(Ok());
}
public static async Task <RentPayResponseModel> PayRentDue(PaymentHistoryModel Invoices)
{
RentPayResponseModel objRentRsp = HttpClientRQHandler.SendRQ <RentPayResponseModel, PaymentHistoryModel>(Invoices, "/IncomingPayments");
return(await Task.FromResult(objRentRsp));
}
