private void MetroWindow_Loaded(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { foreach (var item in Enum.GetValues(typeof(CheckStatus))) { if (item.ToString() == "Released" && item.ToString() == "Created") { } else { checkstatuscb.Items.Add(item); } } ImusCityHallEntities db = new ImusCityHallEntities(); ImusCityGovernmentSystem.Model.Check check = db.Checks.Find(CheckID); checknumbertb.Text = check.CheckNo; checkdatecreateddp.Text = check.DateCreated.Value.ToShortDateString(); checkstatuscb.SelectedIndex = check.Status.HasValue ? check.Status.Value : 0; } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
public void SaveCheckReleased(int Id, int checkId) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); ImusCityGovernmentSystem.Model.CheckRelease released = new CheckRelease(); released.CustomerID = Id; released.ReleasedDate = DateTime.Now; released.CheckID = checkId; released.Photo = ConvertImageSourceToByte(imagecapture); released.DigitalSignature = ConvertImageSourceToByte(digitalsignatureimg); released.ReleasedBy = App.EmployeeID; released.IdentificationCardNumber = idcardnumbertb.Text; released.IdentificationCardTypeID = (int)idtypecb.SelectedValue; db.CheckReleases.Add(released); ImusCityGovernmentSystem.Model.Check check = db.Checks.Find(checkId); check.Status = (int)CheckStatus.Released; int cardId = (int)idtypecb.SelectedValue; CustomerIdentificationCard customerCard = db.CustomerIdentificationCards.FirstOrDefault(m => m.IdentificationCardTypeID == cardId && m.CustomerID == Id && m.IdentificationCardType.IsActive == true); if (customerCard != null) { customerCard.IdentificationNumber = idcardnumbertb.Text; db.SaveChanges(); } else { CustomerIdentificationCard custCard = new CustomerIdentificationCard(); custCard.CustomerID = Id; custCard.IdentificationCardTypeID = (int)idtypecb.SelectedValue; custCard.IdentificationNumber = idcardnumbertb.Text; db.CustomerIdentificationCards.Add(custCard); } db.SaveChanges(); MessageBox.Show("Check has been successfully released"); LoadIdentificationCardType(); var audit = new AuditTrailModel { Activity = "Released check to CUSTOMER ID: " + released.CustomerID.ToString() + " with CHECK NUMBER: " + released.Check.CheckNo, ModuleName = this.GetType().Name, EmployeeID = App.EmployeeID }; SystemClass.InsertLog(audit); ResetFields(); } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
public void CheckReport(int id) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); CDSSignatory signatories = db.CDSSignatories.FirstOrDefault(); CheckModel check = new CheckModel(); ImusCityGovernmentSystem.Model.Check checklist = db.Checks.Find(id); check.CheckNo = checklist.CheckNo; check.CheckDate = checklist.DateCreated.Value; check.CompanyName = checklist.Disbursement.Payee == null ? checklist.Disbursement.PayeeName : checklist.Disbursement.Payee.CompanyName; CurrencyToWords convert = new CurrencyToWords(); double amount = Convert.ToDouble(checklist.Amount.Value); check.AmountInWords = convert.NumberToWords(amount).ToUpper(); check.CheckDescription = checklist.CheckDescription; check.VoucherNo = checklist.Disbursement.VoucherNo; check.Amount = checklist.Amount.Value; check.Signatory1 = SystemClass.GetSignatory(signatories.CityMayor); check.Signatory2 = SystemClass.GetSignatory(signatories.CityTreasurer); ReportDocument report; switch (bankName) { case "LB": report = new LBCheckReport(); report.SetDataSource(new[] { check }); reportviewer.ViewerCore.ReportSource = report; break; case "UCPB": report = new UCPBCheckReport(); report.SetDataSource(new[] { check }); reportviewer.ViewerCore.ReportSource = report; break; case "DBP": report = new DBPCheckReport(); report.SetDataSource(new[] { check }); reportviewer.ViewerCore.ReportSource = report; break; } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void checklistcb_SelectionChanged(object sender, SelectionChangedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); if (checklistcb.SelectedValue == null) { return; } int id = (int)checklistcb.SelectedValue; ImusCityGovernmentSystem.Model.Check check = db.Checks.Find(id); voucherNumbertb.Text = check.Disbursement.VoucherNo; checknumbertb.Text = check.CheckNo; checkdatetb.Text = check.DateCreated.Value.ToShortDateString(); companynametb.Text = check.Disbursement.Payee == null ? check.Disbursement.PayeeName : check.Disbursement.Payee.CompanyName; checkdescriptiontb.Text = check.CheckDescription; banktb.Text = string.Join("/", check.Disbursement.FundBank.Fund.FundName, check.Disbursement.FundBank.Bank.BankName); amountb.Text = string.Format("{0:n}", check.Amount); } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void savebtn_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); ImusCityGovernmentSystem.Model.Check check = db.Checks.Find(CheckID); check.Status = checkstatuscb.SelectedIndex; if (checkstatuscb.SelectedIndex == (int)CheckStatus.Cancelled) { check.CancelledBy = App.EmployeeID; check.CancelledDate = DateTime.Now; ImusCityGovernmentSystem.Model.BankTrail banktrail = new BankTrail(); ImusCityGovernmentSystem.Model.Disbursement disbursement = db.Disbursements.Find(check.DisbursementID); banktrail.DebitCredit = "C"; banktrail.FundBankID = disbursement.FundBankID; banktrail.Amount = Convert.ToDecimal(check.Amount); banktrail.EntryName = nameof(BankTrailEntry.CheckCancelled); banktrail.CheckID = check.CheckID; banktrail.EntryNameID = (int)BankTrailEntry.CheckCancelled; banktrail.EmployeeID = App.EmployeeID; banktrail.DateCreated = DateTime.Now; db.BankTrails.Add(banktrail); ImusCityGovernmentSystem.Model.FundBank account = db.FundBanks.Find(disbursement.FundBankID); account.CurrentBalance += Convert.ToDecimal(check.Amount); } else if (checkstatuscb.SelectedIndex == (int)CheckStatus.Deleted) { check.DeletedBy = App.EmployeeID; check.DeletedDate = DateTime.Now; ImusCityGovernmentSystem.Model.BankTrail banktrail = new BankTrail(); ImusCityGovernmentSystem.Model.Disbursement disbursement = db.Disbursements.Find(check.DisbursementID); banktrail.DebitCredit = "C"; banktrail.FundBankID = disbursement.FundBankID; banktrail.Amount = Convert.ToDecimal(check.Amount); banktrail.EntryName = nameof(BankTrailEntry.CheckDeleted); banktrail.CheckID = check.CheckID; banktrail.EntryNameID = (int)BankTrailEntry.CheckDeleted; banktrail.EmployeeID = App.EmployeeID; banktrail.DateCreated = DateTime.Now; db.BankTrails.Add(banktrail); ImusCityGovernmentSystem.Model.FundBank account = db.FundBanks.Find(disbursement.FundBankID); account.CurrentBalance += Convert.ToDecimal(check.Amount); } db.SaveChanges(); var audit = new AuditTrailModel { Activity = "Updated check in the database. CHECK NUMBER: " + check.CheckNo, ModuleName = this.GetType().Name, EmployeeID = App.EmployeeID }; SystemClass.InsertLog(audit); MessageBox.Show("Check entry updated successfully"); } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }