public ActionResult Business(CollectionViewModel model)
{
DB db = new DB();
BusinessRecord record = db.BusinessRecords.Find(model.Id);
OfficialReceipt or = new OfficialReceipt();
or.BusinessRecord = record;
or.ORDate = model.orDate;
or.ORNumber = model.orNumber;
or.changeAmount = model.changeAmount;
or.totalAmount = model.payableAmount;
or.tenderedAmount = model.tenderedAmount;
List <Fee> fees = new List <Fee>();
if (model.isNew)
{
fees = db.Fees.Include(x => x.Status).Where(x => x.StatusId != 2).ToList();
}
else
{
fees = db.Fees.Include(x => x.Status).Where(x => x.StatusId != 1).ToList();
}
or.FeesPaid = fees;
db.OfficialReceipts.Add(or);
DateTime paidDate = DateTime.Now;
record.BusinessDetail.lastPayDate = paidDate;
record.isCollected = model.quarter;
if (record.isCollected >= 4)
{
record.BusinessDetail.isNew = false;
}
db.SaveChanges();
return(Redirect("/Issuance/Business/" + record.UniqueId));
}
private void btnCancelled_Click(object sender, RoutedEventArgs e)
{
if (!CanModify)
{
MessageWindow.AlertRecordIsLocked();
return;
}
if (MessageWindow.ConfirmCancelVoucher() != MessageBoxResult.Yes)
{
return;
}
OfficialReceipt.DeleteAll(_voucherNo);
var cancelledOfficialReceipt = new OfficialReceipt();
cancelledOfficialReceipt.MemberCode = "CANCEL";
cancelledOfficialReceipt.MemberName = "CANCELLED";
cancelledOfficialReceipt.AccountCode = "CANCEL";
cancelledOfficialReceipt.AccountTitle = "CANCELLED";
cancelledOfficialReceipt.Debit = 0m;
cancelledOfficialReceipt.Credit = 0m;
cancelledOfficialReceipt.VoucherDate = _voucherDate;
cancelledOfficialReceipt.VoucherNo = _voucherNo;
cancelledOfficialReceipt.VoucherType = _voucherType;
cancelledOfficialReceipt.Collector = MainController.LoggedUser.CollectorName;
cancelledOfficialReceipt.Create();
Find(_voucherNo);
}
private void Find(int docNum)
{
try
{
CancelledLabel.Visibility = Visibility.Collapsed;
_currentItems = OfficialReceipt.WhereDocumentNumberIs(docNum);
_currentItems.CollectionChanged += CurrentItemsCollectionChanged;
foreach (OfficialReceipt currentItem in _currentItems)
{
currentItem.PropertyChanged += CurrentItemOnPropertyChanged;
}
_voucherNumber = docNum;
RefreshDisplay();
DataContext = _currentItems;
_hasModified = false;
}
catch (Exception exception)
{
MessageWindow.ShowAlertMessage(exception.Message);
}
}
public int UpdateOfficialReceipt(OfficialReceipt OfficialReceiptModel, string isFinalize)
{
string sql = "usp_UpdateOfficialReceipt";
object[] parms =
{
"@ORNumber", OfficialReceiptModel.ORNumber,
"@isFinalize", isFinalize,
"@UserID", OfficialReceiptModel.UserID,
"@GLID", Guid.NewGuid().ToString(),
"@GLAccountID20", Guid.NewGuid().ToString(),
"@GLAccountID24", Guid.NewGuid().ToString(),
"@GLAccountID03", Guid.NewGuid().ToString(),
"@GLAccountID25", Guid.NewGuid().ToString(),
"@GLAccountID21", Guid.NewGuid().ToString(),
"@GLAccountID22", Guid.NewGuid().ToString(),
"@GLAccountID23", Guid.NewGuid().ToString(),
"@GLReviewerID", Guid.NewGuid().ToString(),
"@DCCRID", Guid.NewGuid().ToString(),
"@LedgerLine1", Guid.NewGuid().ToString(),
"@LedgerLine2", Guid.NewGuid().ToString(),
"@LedgerLine3", Guid.NewGuid().ToString(),
"@EffectiveYieldID", Guid.NewGuid().ToString()
};
return(db.Scalar(sql, 1, parms).AsInt());
}
public PostTimeDepositView(Nfmb member, TimeDepositViewModel viewModel) : this()
{
_officialReceipt = new OfficialReceipt();
_member = member;
_viewModel = viewModel;
_officialReceipt.VoucherNo = Voucher.LastDocumentNo(VoucherTypes.OR) + 1;
DataContext = _officialReceipt;
}
public int SubmitSundry(OfficialReceipt OfficialReceiptModel, IEnumerable <Sundry> SundryAccount)
{
string OfficialReceiptID = Guid.NewGuid().ToString();
int ret = 0;
string sql = "[usp_SubmitOfficialReceipt]";
object[] parms =
{
"OfficialReceiptID", OfficialReceiptID,
"ORNumber", OfficialReceiptModel.ORNumber,
"PreparedByID", OfficialReceiptModel.UserID,
"RequestedByID", OfficialReceiptModel.UserID,
"OrganizationID", OfficialReceiptModel.OrganizationID,
"DirectLoanReceiptNumber", OfficialReceiptModel.DirectLoanReceiptNo,
"OfficialReceiptType", "2",
"AmountReceived", OfficialReceiptModel.AmountReceived.Replace(",",""),
"PaymentModeID", OfficialReceiptModel.PaymentModeID,
"BankName", OfficialReceiptModel.BankID,
"CheckNo", OfficialReceiptModel.CheckNo,
"ARAcceleratedDiscount", "0.00",
"ARInterestWaived", "0.00",
"ARPPD", "0.00",
"ARTotalDiscount", "0.00",
"ARRFC", "0.00",
"ARTOTALRFC", "0.00",
"ARGIBCO", "0.00",
"ARPIP", "0.00",
"SundryTotal", "0.00",
"BillingPIP", "0.00",
"BillingGIBCO", "0.00",
"BillingRFC", "0.00",
"BillingPPD", "0.00",
"DateDue", OfficialReceiptModel.DateDue,
"OfficialReviewerID", Guid.NewGuid().ToString(),
"CustomerName", OfficialReceiptModel.CustomerName,
"Notes", OfficialReceiptModel.Notes
};
ret = db.Scalar(sql, 1, parms).AsInt();
if (ret != 0)
{
return(ret);
}
foreach (Sundry md in SundryAccount)
{
sql = "INSERT INTO Final_Testing.dbo.official_receipt_account (id,official_receipt_id,account_type_id,amount) " +
"VALUES ('" + md.ID + "','" + OfficialReceiptID + "','" + md.CMDMAccountTypeID + "'," + md.SundryAmount + ");Select 0 as Message ";
object[] parmsSundry = { };
ret = db.Scalar(sql, 0, parmsSundry).AsInt();
if (ret != 0)
{
break;
}
}
return(ret);
}
public string SelectOfficialReceiptDetail(long official_receipt_id)
{
List <OfficialReceipt> officialReciept = new List <OfficialReceipt>();
var orList = Database._InvoicePaymentSelect(official_receipt_id, 0);
foreach (var o in orList)
{
OfficialReceipt or = new OfficialReceipt();
or.ID = o.ID;
or.CustomerID = o.CustomerID.Value;
or.CustomerName = o.CustomerName;
or.RefNo = o.RefNo;
or.RefNoSerial = o.ID.ToString();// o.RefSerial;
try { or.Cash = Database._InvoicePaymentCashes.Where(x => x.OfficialReceiptID == official_receipt_id).ToList <_InvoicePaymentCash>(); } catch { }
try { or.Checks = Database._InvoicePaymentChecks.Where(x => x.OfficialReceiptID == official_receipt_id).ToList <_InvoicePaymentCheck>(); } catch { }
try { or.CrediCard = Database._InvoicePaymentCards.Where(x => x.OfficialReceiptID == official_receipt_id).ToList <_InvoicePaymentCard>(); } catch { }
//or.Payments
List <InvoicePayment> payment = new List <InvoicePayment>();
var invoice_payment = Database._InvoicePaymentSelectCustomer(0, official_receipt_id, 0, 0);
foreach (var p in invoice_payment)
{
InvoicePayment _p = new InvoicePayment();
_p.ID = p.ID;
_p.OfficialReceiptID = official_receipt_id;
_p.InvoiceID = p.InvoiceID.Value;
_p.Description = "Sales";
_p.RefNo = Database._Invoices.SingleOrDefault(x => x.ID == p.InvoiceID.Value).RefNo + Database._Invoices.SingleOrDefault(x => x.ID == p.InvoiceID.Value).RefNoSerial;
var salesman_id = Database._Invoices.SingleOrDefault(x => x.ID == p.InvoiceID.Value).SalesmanID;
_p.Salesman = Database._Employees.SingleOrDefault(x => x.ID == salesman_id).EmployeeName;
_p.TotalAmount = Database._Invoices.SingleOrDefault(x => x.ID == p.InvoiceID.Value).TotalAmount.Value;
_p.CreatedDate = Database._Invoices.SingleOrDefault(x => x.ID == p.InvoiceID.Value).CreatedDate.Value;
_p.TotalPayment = p.Amount.Value;
payment.Add(_p);
}
or.Payments = payment;
officialReciept.Add(or);
}
return(JsonConvert.SerializeObject(officialReciept, Newtonsoft.Json.Formatting.None));
}
public PostSavingsDepositView(Nfmb member, Account savingsAccount) : this()
{
_officialReceipt = new OfficialReceipt();
_officialReceipt.VoucherNo = Voucher.LastDocumentNo(VoucherTypes.OR) + 1;
_officialReceipt.MemberCode = member.MemberCode;
_officialReceipt.MemberName = member.MemberName;
_officialReceipt.AccountCode = savingsAccount.AccountCode;
_officialReceipt.AccountTitle = savingsAccount.AccountTitle;
_officialReceipt.VoucherDate = MainController.LoggedUser.TransactionDate;
DataContext = _officialReceipt;
}
private void btnDelete_Click(object sender, RoutedEventArgs e)
{
if (!CanModify)
{
MessageWindow.AlertRecordIsLocked();
return;
}
if (MessageWindow.ConfirmDeleteVoucher() != MessageBoxResult.Yes)
{
return;
}
OfficialReceipt.DeleteAll(_voucherNo);
Find(_voucherNo);
}
private void RefreshDisplay()
{
OfficialReceipt firstItem = _currentItems.FirstOrDefault();
if (firstItem != null)
{
_voucherDate = firstItem.VoucherDate;
lblCollectorName.Content = firstItem.Collector;
CancelledLabel.Visibility = firstItem.MemberCode.ToUpper().Contains("CANCEL")
? Visibility.Visible
: Visibility.Collapsed;
}
else
{
_voucherDate = _transactionDateUser;
lblCollectorName.Content = MainController.LoggedUser.CollectorName;
}
bool allowEdit = CanModify;
dgTransactionDetails.ItemsSource = _currentItems;
dgTransactionDetails.CanUserAddRows = allowEdit;
dgTransactionDetails.IsReadOnly = !allowEdit;
txtDocNum.Text = Convert.ToString(_voucherNumber);
txtTransactionDate.Text = _voucherDate.ToString("MM/dd/yyyy");
UpdateTotalDebitAndTotalCredit();
lblRecordCount.Content = string.Format("Record Count: {0}", _currentItems.Count);
btnSave.IsEnabled = allowEdit;
btnDelete.IsEnabled = allowEdit;
btnCancelled.IsEnabled = allowEdit;
btnPrint.IsEnabled = allowEdit;
if (allowEdit)
{
imgLocked.Visibility = Visibility.Collapsed;
imgUnlocked.Visibility = Visibility.Visible;
}
else
{
imgLocked.Visibility = Visibility.Visible;
imgUnlocked.Visibility = Visibility.Collapsed;
}
}
private void VoucherFormOnKeyDown(object sender, KeyEventArgs e)
{
if (!CanModify)
{
return;
}
if (e.Key == Key.I && (Keyboard.Modifiers & ModifierKeys.Control) == ModifierKeys.Control)
{
var newItem = new OfficialReceipt();
_currentItems.Add(newItem);
}
if (e.Key == Key.D && (Keyboard.Modifiers & ModifierKeys.Control) == ModifierKeys.Control)
{
var currentItem = (OfficialReceipt)dgTransactionDetails.SelectedItem;
_currentItems.Remove(currentItem);
}
}
public int SubmitOfficialReceipt(OfficialReceipt OfficialReceiptModel)
{
string sql = "usp_SubmitOfficialReceipt";
object[] parms =
{
"OfficialReceiptID", Guid.NewGuid().ToString(),
"ORNumber", OfficialReceiptModel.ORNumber,
"PreparedByID", OfficialReceiptModel.UserID,
"RequestedByID", OfficialReceiptModel.UserID,
"OrganizationID", OfficialReceiptModel.OrganizationID,
"DirectLoanReceiptNumber", OfficialReceiptModel.DirectLoanReceiptNo,
"OfficialReceiptType", "1",
"AmountReceived", OfficialReceiptModel.AmountReceived.Replace(",", ""),
"PaymentModeID", OfficialReceiptModel.PaymentModeID,
"BankName", OfficialReceiptModel.BankID,
"CheckNo", OfficialReceiptModel.CheckNo,
"ARAcceleratedDiscount", OfficialReceiptModel.AccelerationDiscount.Replace(",", ""),
"ARInterestWaived", OfficialReceiptModel.PenaltyWaived.Replace(",", ""),
"ARPPD", OfficialReceiptModel.PromptPaymentDiscount.Replace(",",""),
"ARTotalDiscount", OfficialReceiptModel.TotalDiscount.Replace(",", ""),
"ARRFC", OfficialReceiptModel.RFC.Replace(",", ""),
"ARTOTALRFC", OfficialReceiptModel.TotalRFC.Replace(",", ""),
"ARGIBCO", OfficialReceiptModel.GIBCO.Replace(",", ""),
"ARPIP", OfficialReceiptModel.PIP.Replace(",", ""),
"SundryTotal", "0.00",
"BillingPIP", OfficialReceiptModel.PIPDue.Replace(",", ""),
"BillingGIBCO", OfficialReceiptModel.GIBCODue.Replace(",", ""),
"BillingRFC", OfficialReceiptModel.RFCDue.Replace(",", ""),
"BillingPPD", OfficialReceiptModel.PPD.Replace(",", ""),
"DateDue", OfficialReceiptModel.DateDue,
"OfficialReviewerID", Guid.NewGuid().ToString(),
"CustomerName", OfficialReceiptModel.CustomerName,
"Notes", OfficialReceiptModel.Notes
};
return(db.Scalar(sql, 1, parms).AsInt());
}
private void btnPost_Click(object sender, EventArgs e)
{
var collection = OfficialReceipt.WhereDocumentNumberIs(_officialReceipt.VoucherNo);
if (collection.Count > 0)
{
MessageWindow.ShowAlertMessage("OR No. already in use.");
return;
}
try
{
_officialReceipt.Collector = MainController.LoggedUser.CollectorName;
_officialReceipt.IsPosted = true;
_officialReceipt.Create();
// cash on hand
var or = new OfficialReceipt
{
MemberCode = _officialReceipt.MemberCode, MemberName = _officialReceipt.MemberName
};
var coh = Account.FindByCode(GlobalSettings.CodeOfCashOnHand);
or.AccountCode = coh.AccountCode;
or.AccountTitle = coh.AccountTitle;
// insert denomination details
or.Debit = _officialReceipt.Credit;
if (_denomonation != null)
{
#region --- Cash CashAndCheckBreakDown ---
//JEA: Since deno09 is not available (0.50), I use it as lieu to 200
or.Deno01 = _denomonation.Deno01; //1000
or.Deno02 = _denomonation.Deno02; //500
or.Deno03 = _denomonation.Deno03; //100
or.Deno04 = _denomonation.Deno04; //50
or.Deno05 = _denomonation.Deno05; //20
or.Deno06 = _denomonation.Deno06; //10
or.Deno07 = _denomonation.Deno07; //5
or.Deno08 = _denomonation.Deno08; //1
or.Deno09 = _denomonation.Deno09; //.5 -> 200
or.Deno10 = _denomonation.Deno10; //.25
#endregion --- Cash CashAndCheckBreakDown ---
#region --- Check CashAndCheckBreakDown ---
or.BankName1 = _denomonation.BankName1;
or.BankDate1 = _denomonation.BankDate1;
or.BankCheck1 = _denomonation.BankCheck1;
or.BankAmount1 = _denomonation.BankAmount1;
or.BankName2 = _denomonation.BankName2;
or.BankDate2 = _denomonation.BankDate2;
or.BankCheck2 = _denomonation.BankCheck2;
or.BankAmount2 = _denomonation.BankAmount2;
or.BankName3 = _denomonation.BankName3;
or.BankDate3 = _denomonation.BankDate3;
or.BankCheck3 = _denomonation.BankCheck3;
or.BankAmount3 = _denomonation.BankAmount3;
or.BankName4 = _denomonation.BankName4;
or.BankDate4 = _denomonation.BankDate4;
or.BankCheck4 = _denomonation.BankCheck4;
or.BankAmount4 = _denomonation.BankAmount4;
or.BankName5 = _denomonation.BankName5;
or.BankDate5 = _denomonation.BankDate5;
or.BankCheck5 = _denomonation.BankCheck5;
or.BankAmount5 = _denomonation.BankAmount5;
#endregion
}
or.AmountInWords = Converter.AmountToWords(_officialReceipt.Credit);
or.Amount = _officialReceipt.Credit;
or.VoucherDate = _officialReceipt.VoucherDate;
or.VoucherNo = _officialReceipt.VoucherNo;
or.VoucherType = VoucherTypes.OR;
or.Collector = MainController.LoggedUser.CollectorName;
or.IsPosted = true;
or.Create();
#region --- Voucher Log ---
var voucherLog = new VoucherLog();
voucherLog.Find("OR", _officialReceipt.VoucherNo);
voucherLog.Date = _officialReceipt.VoucherDate;
voucherLog.Initials = MainController.LoggedUser.Initials;
if (_denomonation != null && _denomonation.HasCheckDeposit)
{
voucherLog.Remarks = "CHK";
}
voucherLog.Save();
#endregion
MessageWindow.ShowNotifyMessage("Transaction posted! Printing validation...");
DialogResult = true;
Close();
}
catch (Exception exception)
{
MessageWindow.ShowAlertMessage(exception.Message);
}
}
public int UpdateOfficialReceipt(OfficialReceipt OfficialReceiptModel, string isFinalize)
{
return(OfficialReceipt.UpdateOfficialReceipt(OfficialReceiptModel, isFinalize));
}
public int SubmitSundry(OfficialReceipt OfficialReceiptModel, IEnumerable <Sundry> SundryAccount)
{
return(OfficialReceipt.SubmitSundry(OfficialReceiptModel, SundryAccount));
}
public int SubmitOfficialReceipt(OfficialReceipt OfficialReceiptModel)
{
return(OfficialReceipt.SubmitOfficialReceipt(OfficialReceiptModel));
}
