private void btnNew_Click(object sender, RoutedEventArgs e)
{
try
{
using (var ctx = new finalContext())
{
FPaymentInfo fp = ctx.FPaymentInfo.Find(fId);
DepositedCheque dp = ctx.DepositedCheques.Find(fId);
MessageBoxResult mr = MessageBox.Show("Are you sure you want to process this transaction?", "Question", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (mr == MessageBoxResult.Yes)
{
if (status == "Full")
{
var fp2 = from f in ctx.FPaymentInfo
where f.LoanID == lID && f.PaymentStatus != "Cleared"
select f;
double tot = 0;
foreach (var itm in fp2)
{
itm.PaymentStatus = "Cleared";
ClearedCheque cc = new ClearedCheque { FPaymentInfoID = itm.FPaymentInfoID, DateCleared = DateTime.Now };
}
FPaymentInfo f2 = new FPaymentInfo { Amount = double.Parse(txtAmt.Text), ChequeDueDate = DateTime.Now.Date, ChequeInfo = txtId.Text, LoanID = lID, PaymentNumber = fp2.Count() + 1, PaymentStatus = "Cleared", PaymentDate = DateTime.Now, RemainingBalance = 0 };
ctx.FPaymentInfo.Add(f2);
var lon = ctx.Loans.Find(lID);
lon.Status = "Paid";
PaidLoan pl = new PaidLoan { DateFinished = DateTime.Now, LoanID = lID };
ctx.PaidLoans.Add(pl);
ctx.SaveChanges();
ClearedCheque cc2 = new ClearedCheque { DateCleared = DateTime.Now, FPaymentInfoID = f2.FPaymentInfoID };
MessageBox.Show("Transaction has been successfully processed", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
return;
}
if (chDaif.IsChecked == false)
{
wpfCheckout frm = new wpfCheckout();
frm.status = "Daif";
frm.fId = fId;
frm.ShowDialog();
if (cont == false)
{
System.Windows.MessageBox.Show("Please pay the DAIF fee first", "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
AuditTrail at = new AuditTrail { EmployeeID = UserID, DateAndTime = DateTime.Now, Action = "Changed Cheque " + fp.ChequeInfo + " to " + txtId.Text + "" };
ctx.AuditTrails.Add(at);
fp.PaymentStatus = "Deposited";
fp.ChequeInfo = txtId.Text;
dp.DepositDate = DateTime.Today.Date;
fp.ReturnedCheque.isPaid = true;
if (chDaif.IsChecked == true)
{
fp.Amount = fp.Amount + fp.ReturnedCheque.Fee;
}
ctx.SaveChanges();
MessageBox.Show("Transaction has been successfully processed", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
}
}
catch (Exception ex)
{
System.Windows.MessageBox.Show("Runtime Error: " + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}
private void Button_Click_4(object sender, RoutedEventArgs e)
{
try
{
MessageBoxResult mr = MessageBox.Show("Are you sure you want to clear the selected cheque(s)?","Question",MessageBoxButton.YesNo);
if (mr == MessageBoxResult.Yes)
{
using (var ctx = new finalContext())
{
var chq = from ch in ctx.TempClearings
select ch;
foreach (var item in chq)
{
var ch = ctx.FPaymentInfo.Find(item.FPaymentInfoID);
ch.PaymentStatus = "Cleared";
var ctr = ctx.FPaymentInfo.Where(x=> x.LoanID==item.FPaymentInfo.LoanID && x.PaymentStatus=="Due/Pending").Count();
if (ctr > 0)
{
var ch2 = ctx.FPaymentInfo.Where(x => x.LoanID == item.FPaymentInfo.LoanID && x.PaymentStatus == "Due/Pending").First();
ch2.PaymentStatus = "Due";
}
ClearedCheque cc = new ClearedCheque { FPaymentInfoID = item.FPaymentInfoID, DateCleared = DateTime.Today.Date };
ctx.ClearedCheques.Add(cc);
}
AuditTrail at = new AuditTrail { EmployeeID = UserID, DateAndTime = DateTime.Now, Action = "Cleared Cheques" };
ctx.AuditTrails.Add(at);
ctx.SaveChanges();
MessageBox.Show("Cheque(s) has/have been successfully cleared", "Information", MessageBoxButton.OK, MessageBoxImage.Information);
this.Close();
}
}
}
catch (Exception ex)
{
System.Windows.MessageBox.Show("Runtime Error: " + ex.Message, "Error", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
}