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)); }