public bool ListTransactionByCustomerID_PL()
{
Console.Clear();
Console.Write("Enter Customer ID");
string customerID = Console.ReadLine();
if (BusinessLogicUtil.validate(customerID) == false)
{
Console.WriteLine("Not a valid customer ID\nPress Any Key -> Try Again");
Console.ReadKey();
return(false);
}
TransactionsBL transBL = new TransactionsBL();
List <TransactionEntities> transactions = transBL.GetAllTransactionBL();
bool transactionsFound = false;
foreach (var transaction in transactions)
{
if (transaction.CustomerID == customerID)
{
BusinessLogicUtil.ShowTransactionDetails(transaction);
transactionsFound = true;
}
}
if (transactionsFound == false)
{
Console.WriteLine($"No Transactions founds in records of {customerID}");
}
Console.WriteLine("Press Any Key -> Previous Menu");
return(true);
}
public bool ListTransactionByTransactionID_PL()
{
Console.Clear();
Console.WriteLine("------ Transaction Details ------");
Console.Write("Enter Transaction ID:");
string transactionID = Console.ReadLine();
try
{
TransactionsBL transBL = new TransactionsBL();
TransactionEntities transaction = transBL.DisplayTransactionByTransactionID_BL(transactionID);
if (transaction == null)
{
Console.WriteLine($"No Records found for {transactionID}");
return(false);
}
else
{
BusinessLogicUtil.ShowTransactionDetails(transaction);
Console.WriteLine("Press Any Key -> Previous Menu");
return(true);
}
}
catch (TransactionDetailsException e)
{
Console.WriteLine(e.Message);
Console.WriteLine("Press Any Key -> Try Again");
return(false);
}
}
private void computeBacklogBfwd()
{
if (this.formTypeCodeComboBox.SelectedValue != null)
{
this.formsBfwdTextBox.Text = TransactionsBL.getBacklogBfwd(this.transactionDateDateTimePicker.Value, UserInfo.CurrentUserName, this.formTypeCodeComboBox.SelectedValue.ToString()).ToString();
}
}
public bool CreditTransactionByDepositSlipPL()
{
Console.Clear();
long accountNo;
double amount;
try
{
Console.WriteLine("--------- Credit Transaction By Deposit Slip ---------");
Console.Write("Enter Account No:");
accountNo = long.Parse(Console.ReadLine());
Console.WriteLine("Maximum Allowed Amount is Rs.50000");
Console.Write("Enter Amount (Rs.):");
amount = Convert.ToDouble(Console.ReadLine());
TransactionsBL transBL = new TransactionsBL();
return(transBL.CreditTransactionByDepositSlipBL(accountNo, amount));
}
catch (CreditSlipException e)
{
Console.WriteLine(e.Message);
return(false);
}
}
public bool DebitTransactionByChequePL()
{
long accountNo;
double amount;
string chequeNo;
try
{
Console.Clear();
Console.WriteLine("------- Debit Transaction By Cheque -------");
Console.Write("Enter Account No:");
accountNo = long.Parse(Console.ReadLine());
Console.WriteLine("Maximum Allowed Amount Rs.50000");
Console.Write("Enter Amount (Rs.):");
amount = Convert.ToDouble(Console.ReadLine());
Console.Write("Enter Cheque No:");
chequeNo = Console.ReadLine();
TransactionsBL transBL = new TransactionsBL();
return(transBL.DebitTransactionByChequeBL(accountNo, amount, chequeNo));
}
catch (DebitChequeException e)
{
Console.WriteLine(e.Message + "\nPress Any Key -> Try Again");
Console.ReadKey();
return(false);
}
catch (InsufficientBalanceException e)
{
Console.WriteLine(e.Message + "\nPress Any Key -> Try Again");
Console.ReadKey();
return(false);
}
}
private void LoadCombos()
{
TransactionsBL.getFormTypes(formTypeCodeComboBox);
TransactionsBL.getDataClerks(dataClerkComboBox);
TransactionsBL.getDataClerks(SearchDataClerkComboBox);
//this.SearchDataClerkComboBox.SelectedIndex = -1;
this.SearchDataClerkComboBox.SelectedValue = UserInfo.CurrentUserName;
}
public bool ListTransactionsByDateRangeOfAccountNo_PL()
{
Console.Clear();
Console.Write("Enter Account No");
string accountNo = Console.ReadLine();
if (BusinessLogicUtil.validateAccountNo(accountNo) == false)
{
Console.WriteLine("Not a valid Account No.\nPress Any Key -> Try Again");
Console.ReadKey();
return(false);
}
string FromDateStr, ToDateStr;
Console.WriteLine("All dates must be in mm-dd-yyyy format");
Console.Write("Enter Start Date:");
FromDateStr = Console.ReadLine();
DateTime FromDate = BusinessLogicUtil.validateDate("dd-MM-yyyy", FromDateStr);
Console.Write("Enter End Date:");
ToDateStr = Console.ReadLine();
DateTime ToDate = BusinessLogicUtil.validateDate("dd-MM-yyyy", ToDateStr);
// validateDate returns default(DateTime) if date is not in valid format because DateTime is non nullable
if (FromDate == default(DateTime) || ToDate == default(DateTime))
{
Console.WriteLine("One or more dates are not in specified format\nSpecified Format mm-dd-yyyy");
Console.WriteLine("Press Any Key -> Try Again");
Console.ReadKey();
return(false);
}
// required transactions will be filered out in foreach loop from all transactions
TransactionsBL transBL = new TransactionsBL();
List <TransactionEntities> transactions = transBL.GetAllTransactionBL();
bool transactionsFound = false;
foreach (var transaction in transactions)
{
if (transaction.AccountNo == long.Parse(accountNo) && DateTime.Compare(FromDate.Date, transaction.DateOfTransaction.Date) < 0 && DateTime.Compare(transaction.DateOfTransaction.Date, ToDate.Date) < 0)
{
BusinessLogicUtil.ShowTransactionDetails(transaction);
transactionsFound = true;
}
}
if (transactionsFound == false)
{
Console.WriteLine($"No Transactions found between {FromDate.Date} and {ToDate.Date} of account:{accountNo}");
}
Console.WriteLine("Press Any Key -> Previous Menu");
Console.ReadKey();
return(true);
}
public ActionResult Details(int?id)
{
if (id == null || !TransactionsBL.Exists(id.Value))
{
return(RedirectToAction("Index"));
}
return(View(TransactionsBL.Details(id.Value)));
}
private void SaveToolStripButton_Click(object sender, EventArgs e)
{
TransactionsBL TransactionsMain = new TransactionsBL();
if (FormIsValid())
{
if (string.IsNullOrEmpty(this.iDTextBox.Text.Trim().ToString()))
{
TransactionsBL.ID = 0;
}
else
{
TransactionsBL.ID = Convert.ToInt64(this.iDTextBox.Text.ToString());
}
if (XCurrentAction == (Int16)CurrentAction.Add)
{
TransactionsBL.TransactionDate = this.transactionDateDateTimePicker.Value.Date;
}
TransactionsBL.FormTypeCode = this.formTypeCodeComboBox.SelectedValue.ToString();
TransactionsBL.FormTypeDescription = this.formTypeCodeComboBox.Text;
TransactionsBL.FormsBfwd = Convert.ToInt64(this.formsBfwdTextBox.Text);
TransactionsBL.FormsReceived = Convert.ToInt64(this.formsReceivedTextBox.Text);
TransactionsBL.FormsSorted = Convert.ToInt64(this.formsSortedTextBox.Text);
TransactionsBL.FormsScanned = Convert.ToInt64(this.formsScannedTextBox.Text);
TransactionsBL.FormsVerified = Convert.ToInt64(this.formsVerifiedTextBox.Text);
TransactionsBL.BackLog = TransactionsBL.FormsBfwd + TransactionsBL.FormsReceived - TransactionsBL.FormsVerified;
TransactionsBL.DataClerk = this.dataClerkComboBox.Text;
TransactionsBL.DateCreated = Convert.ToDateTime((DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")));
TransactionsBL.CreatedBy = UserInfo.CurrentUserName;
TransactionsBL.DateModified = Convert.ToDateTime((DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss")));
TransactionsBL.ModifiedBy = UserInfo.CurrentUserName;
//this.backLogTextBox.Text = TransactionsBL.BackLog.ToString ();
if (XCurrentAction == (Int16)CurrentAction.Add)
{
if (TransactionsBL.AddTransaction() > 0)
{
this.ResetControls();
loadInitialData();
}
}
else if (XCurrentAction == (Int16)CurrentAction.Edit)
{
if (TransactionsBL.UpdateTransaction() > 0)
{
this.ResetControls();
loadInitialData();
}
}
}
else
{
MessageBox.Show(err, "Validation", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
}
public bool ListTransactionsOfSpecificDateOfAccountNo_PL()
{
Console.Clear();
Console.Write("Enter Account No");
string accountNo = Console.ReadLine();
if (BusinessLogicUtil.validateAccountNo(accountNo) == false)
{
Console.WriteLine("Not a valid account No.\nPress Any Key -> Try Again");
Console.ReadKey();
return(false);
}
Console.Write("Enter Date (in dd-MM-yyyy format only):");
string inputDateStr = Console.ReadLine();
DateTime inputDate = BusinessLogicUtil.validateDate("dd-MM-yyyy", inputDateStr);
// validateDate returns default(DateTime) if date is not in valid format because DateTime is non nullable
if (inputDate == default(DateTime))
{
Console.WriteLine("Wrong Date Format\nInput date needs to be in dd-MM-yyyy format");
Console.WriteLine("Press any key -> Try Again");
Console.ReadKey();
return(false);
}
// required transaction will be filtered in foreach loop from all transaction
TransactionsBL transBL = new TransactionsBL();
List <TransactionEntities> transactions = transBL.GetAllTransactionBL();
bool transactionsFound = false;
Console.WriteLine($"------ All Debit Transactions of {inputDate.Date} ------");
foreach (var transaction in transactions)
{
if (transaction.AccountNo == long.Parse(accountNo) && DateTime.Compare(inputDate.Date, transaction.DateOfTransaction.Date) == 0)
{
BusinessLogicUtil.ShowTransactionDetails(transaction);
transactionsFound = true;
}
}
if (transactionsFound == false)
{
Console.WriteLine($"No Transactions found on {inputDate.Date} for account {accountNo}");
}
Console.WriteLine("Press Any Key -> Previous Menu");
Console.ReadKey();
return(true);
}
public bool GetAllTransactionsPL()
{
Console.Clear();
Console.WriteLine("------ All Transactions ------");
TransactionsBL transBL = new TransactionsBL();
List <TransactionEntities> transactions = transBL.GetAllTransactionBL();
foreach (var transaction in transactions)
{
BusinessLogicUtil.ShowTransactionDetails(transaction);
}
Console.WriteLine("Press Any Key -> Previous Menu");
return(true);
}
public bool ListCreditTransactionsByDateRangePL()
{
Console.Clear();
Console.WriteLine("------. All Credit Transaction ------");
string FromDateStr, ToDateStr;
Console.WriteLine("All dates must be in mm-dd-yyyy format");
Console.Write("Enter Start Date:");
FromDateStr = Console.ReadLine();
DateTime FromDate = BusinessLogicUtil.validateDate("dd-MM-yyyy", FromDateStr);
Console.Write("Enter End Date:");
ToDateStr = Console.ReadLine();
DateTime ToDate = BusinessLogicUtil.validateDate("dd-MM-yyyy", ToDateStr);
// validateDate returns default(DateTime) if date is not in valid format because DateTime is non nullable
if (FromDate == default(DateTime) || ToDate == default(DateTime))
{
Console.WriteLine("One or more dates are not in specified format\nSpecified Format mm-dd-yyyy");
Console.WriteLine("Press Any Key -> Try Again");
return(false);
}
TransactionsBL transBL = new TransactionsBL();
List <TransactionEntities> transactions = transBL.GetAllTransactionBL();
bool transactionsFound = false;
foreach (var transaction in transactions)
{
// Enum for Credit is 0
if (transaction.Type == (TypeOfTranscation)0 && DateTime.Compare(FromDate.Date, transaction.DateOfTransaction.Date) < 0 && DateTime.Compare(transaction.DateOfTransaction.Date, ToDate.Date) < 0)
{
BusinessLogicUtil.ShowTransactionDetails(transaction);
transactionsFound = true;
}
}
if (transactionsFound == false)
{
Console.WriteLine($"No Credit Transactions found between {FromDate.Date} and {ToDate.Date}");
}
Console.WriteLine("Press Any Key -> Previous Menu");
return(true);
}
public async Task <ActionResult> Create(Transaction transaction)
{
try
{
transaction.RootAccount = transaction.RootAccount.Trim();
transaction.Addressee = transaction.Addressee.Trim();
transaction.Description = transaction.Description.Trim();
transaction.Date = DateTime.Now.ToString("yyyy/MM/dd");
await TransactionsBL.Create(transaction);
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
ModelState.AddModelError("", ex.Message);
return(View(transaction));
}
}
public bool ListAllCreditTransactionsPL()
{
Console.Clear();
Console.WriteLine("------ All Credit Transactions ------");
TransactionsBL transBL = new TransactionsBL();
List <TransactionEntities> transactions = transBL.GetAllTransactionBL();
foreach (var transaction in transactions)
{
// Enum for Credit is 0
if (transaction.Type == (TypeOfTranscation)0)
{
BusinessLogicUtil.ShowTransactionDetails(transaction);
}
}
Console.WriteLine("Press Any Key -> Previous Menu");
return(true);
}
public bool ListCreditTransactionsOfSpecificDatePL()
{
Console.Clear();
Console.WriteLine("------ Credit Transactions ------");
Console.Write("Enter Date (in dd-MM-yyyy format only):");
string inputDateStr = Console.ReadLine();
DateTime inputDate = BusinessLogicUtil.validateDate("dd-MM-yyyy", inputDateStr);
// validateDate returns default(DateTime) if date is not in valid format because DateTime is non nullable
if (inputDate == default(DateTime))
{
Console.WriteLine("Wrong Date Format\nInput date needs to be in dd-MM-yyyy format");
Console.WriteLine("Press any key -> Try Again");
return(false);
}
TransactionsBL transBL = new TransactionsBL();
List <TransactionEntities> transactions = transBL.GetAllTransactionBL();
bool transactionsFound = false;
Console.WriteLine($"------ All Credit Transactions of {inputDate.Date} ------");
foreach (var transaction in transactions)
{
// Enum for Credit is 0
if (transaction.Type == (TypeOfTranscation)0 && DateTime.Compare(inputDate.Date, transaction.DateOfTransaction.Date) == 0)
{
BusinessLogicUtil.ShowTransactionDetails(transaction);
transactionsFound = true;
}
}
if (transactionsFound == false)
{
Console.WriteLine($"No Credit Transactions found on {inputDate.Date}");
}
Console.WriteLine("Press Any Key -> Previous Menu");
return(true);
}
public bool ListAllCreditTransactionsOfAccountNo_PL()
{
Console.Clear();
Console.Write("Enter Account No:");
string accountNo = Console.ReadLine();
if (BusinessLogicUtil.validateAccountNo(accountNo) == false)
{
Console.WriteLine("Not a valid customer ID\nPress Any Key -> Try Again");
Console.ReadKey();
return(false);
}
TransactionsBL transBL = new TransactionsBL();
List <TransactionEntities> transactions = transBL.GetAllTransactionBL();
bool transactionsFound = false;
foreach (var transaction in transactions)
{
// Enum for Credit is 0
if (transaction.Type == (TypeOfTranscation)0 && transaction.AccountNo == long.Parse(accountNo))
{
BusinessLogicUtil.ShowTransactionDetails(transaction);
transactionsFound = true;
}
}
if (transactionsFound == false)
{
Console.WriteLine($"No Credit transactions founds in account No {accountNo}");
}
Console.WriteLine("Press Any Key -> Previous Menu");
Console.ReadKey();
return(true);
}
public bool DebitTransactionByWithdrawalSlipPL()
{
Console.Clear();
long accountNo;
double amount;
try
{
Console.WriteLine("--------- Debit Transaction By Withdrawal Slip ---------");
Console.Write("Enter Account No:");
accountNo = long.Parse(Console.ReadLine());
Console.WriteLine("Maximum Allowed Amount is Rs.50000");
Console.Write("Enter Amount (Rs.):");
amount = Convert.ToDouble(Console.ReadLine());
TransactionsBL transBL = new TransactionsBL();
return(transBL.DebitTransactionByWithdrawalSlipBL(accountNo, amount));
}
catch (CreditSlipException e)
{
Console.WriteLine(e.Message + "\nPress Any Key -> Try Again");
Console.ReadKey();
return(false);
}
catch (InsufficientBalanceException e)
{
Console.WriteLine(e.Message + "\nPress Any Key -> Try Again");
Console.ReadKey();
return(false);
}
catch (DebitSlipException e)
{
Console.WriteLine(e.Message + "\nPress Any Key -> Try Again");
Console.ReadKey();
return(false);
}
}
private bool FormIsValid()
{
Proceed = true;
sb = new StringBuilder("Please resolve the following to proceed:\n");
foreach (Control a in MainTableLayoutPanel.Controls)
{
#region ComboBox
if ((a is ComboBox) && (a.CausesValidation))
{
ComboBox cntrl = (ComboBox)a;
if (cntrl.Text.Length.Equals(0))
{
ePX.SetError(cntrl, cntrl.AccessibleDescription);
sb.Append("* " + ePX.GetError(cntrl) + " \n");
Proceed = false;
}
else
{
ePX.SetError(cntrl, "");
}
}
#endregion
#region Dates
if ((a is DateTimePicker) && (a.CausesValidation))
{
DateTimePicker cntrl = (DateTimePicker)a;
if (!cntrl.Checked)
{
ePX.SetError(cntrl, cntrl.AccessibleDescription);
sb.Append("* " + ePX.GetError(cntrl) + " \n");
Proceed = false;
}
else
{
ePX.SetError(cntrl, "");
}
}
#endregion
#region TextBox
if ((a is TextBox) && (a.CausesValidation))
{
TextBox cntrl = (TextBox)a;
if (cntrl.Text.Length.Equals(0))
{
ePX.SetError(cntrl, cntrl.AccessibleDescription);
sb.Append("* " + ePX.GetError(cntrl) + " \n");
Proceed = false;
}
else
{
ePX.SetError(cntrl, "");
}
}
#endregion
#region Numericupdown
if ((a is NumericUpDown) && (a.CausesValidation))
{
NumericUpDown cntrl = (NumericUpDown)a;
if (Convert.ToDouble(cntrl.Value) == 0)
{
ePX.SetError(cntrl, cntrl.AccessibleDescription);
sb.Append("* " + ePX.GetError(cntrl) + " \n");
Proceed = false;
}
else
{
ePX.SetError(cntrl, "");
}
}
#endregion
#region Panel.RadioButtons
if ((a.HasChildren) && (a.CausesValidation))
{
bool radioOK = false;
bool rbExists = false;
foreach (Control d in a.Controls)
{
#region Radiobuttons
if ((d is RadioButton) && (d.CausesValidation))
{
rbExists = true;
RadioButton cntrl = (RadioButton)d;
if (cntrl.Checked)
{
radioOK = true;
}
}
#endregion
#region TextBox
if ((d is TextBox) && (d.CausesValidation))
{
TextBox cntrl = (TextBox)d;
if (cntrl.Text.Length.Equals(0))
{
ePX.SetError(cntrl, cntrl.AccessibleDescription);
sb.Append("* " + ePX.GetError(cntrl) + " \n");
Proceed = false;
Console.Write(d.Name);
}
else
{
ePX.SetError(cntrl, "");
}
}
#region Dates
if ((d is DateTimePicker) && (d.CausesValidation))
{
DateTimePicker cntrl = (DateTimePicker)d;
if (!cntrl.Checked)
{
ePX.SetError(cntrl, cntrl.AccessibleDescription);
sb.Append("* " + ePX.GetError(cntrl) + " \n");
Proceed = false;
}
else
{
ePX.SetError(cntrl, "");
}
}
#endregion
#endregion
}
#region Checkradiobuttons
if ((!radioOK) && (rbExists))
{
ePX.SetError(a, a.AccessibleDescription);
sb.Append("* " + ePX.GetError(a) + " \n");
Proceed = false;
}
else
{
ePX.SetError(a, "");
}
#endregion
}
#endregion
}
#region CustomValidation
if (Convert.ToInt32(this.formsSortedTextBox.Text) > (Convert.ToInt32(formsReceivedTextBox.Text) + Convert.ToInt32(formsBfwdTextBox.Text)))
{
ePX.SetError(formsSortedTextBox, "Forms Sorted Cannot be greater than the forms received");
sb.Append("* " + "Forms Sorted Cannot be greater than the forms received" + " \n");
Proceed = false;
}
else
{
ePX.SetError(this.formsSortedTextBox, "");
}
if (Convert.ToInt32(this.formsScannedTextBox.Text) > (Convert.ToInt32(formsReceivedTextBox.Text) + Convert.ToInt32(formsBfwdTextBox.Text)))
{
ePX.SetError(formsScannedTextBox, "Forms Scanned Cannot be greater than the forms received");
sb.Append("* " + "Forms Scanned Cannot be greater than the forms received" + " \n");
Proceed = false;
}
else
{
ePX.SetError(this.formsScannedTextBox, "");
}
if (Convert.ToInt32(this.formsVerifiedTextBox.Text) > (Convert.ToInt32(formsReceivedTextBox.Text) + Convert.ToInt32(formsBfwdTextBox.Text)))
{
ePX.SetError(formsVerifiedTextBox, "Forms Verified Cannot be greater than the forms received");
sb.Append("* " + "Forms Verified Cannot be greater than the forms received" + " \n");
Proceed = false;
}
else
{
ePX.SetError(this.formsVerifiedTextBox, "");
}
if (XCurrentAction == (Int16)CurrentAction.Add)
{
if (TransactionsBL.TransactionExists(this.transactionDateDateTimePicker.Value, this.formTypeCodeComboBox.SelectedValue.ToString(), UserInfo.CurrentUserName))
{
ePX.SetError(transactionDateDateTimePicker, "This transaction Already Exists. You cannot Proceed On");
sb.Append("* " + "This transaction Already Exists. You cannot Proceed On" + " \n");
Proceed = false;
}
else
{
ePX.SetError(this.transactionDateDateTimePicker, "");
}
}
#endregion
err = sb.ToString();
return(Proceed);
}
// GET: Transactions
public ActionResult Index()
{
return(View(TransactionsBL.TransactionsList()));
}
