private void MetroWindow_Loaded(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); FundBank fundBank = db.FundBanks.Find(fundBankId); fundname.Text = string.Join("/", fundBank.AccountNumber, fundBank.Fund.FundName, fundBank.Bank.BankCode); List <DamageCheck> damageCheckList = new List <DamageCheck>(); foreach (var item in db.DamageChecks.Where(m => m.FundBankID == fundBankId)) { var damageCheck = new DamageCheck() { DamageCheckId = item.DamageCheckId, CheckNumber = item.CheckNumber, CreatedDate = item.CreatedDate }; damageCheckList.Add(damageCheck); } damgecheckdg.ItemsSource = damageCheckList.OrderBy(m => m.CheckNumber); damgecheckdg.SelectedValuePath = "DamageCheckId"; } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void LoadSelected(int id) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); FundBank account = db.FundBanks.Find(id); bankcb.ItemsSource = db.Banks.OrderBy(m => m.BankName).ToList(); bankcb.DisplayMemberPath = "BankName"; bankcb.SelectedValuePath = "BankID"; bankcb.SelectedValue = account.BankID; fundcb.ItemsSource = db.Funds.OrderBy(m => m.FundName).ToList(); fundcb.DisplayMemberPath = "FundName"; fundcb.SelectedValuePath = "FundID"; fundcb.SelectedValue = account.FundID; accountnumbertb.Text = account.AccountNumber; startingbalancetb.Text = String.Format("{0:n}", account.StartingBalance); currentbalancetb.Text = String.Format("{0:n}", account.CurrentBalance); advicenumbertb.Text = account.AdviceNo.HasValue ? account.AdviceNo.ToString() : ""; flooramounttb.Text = String.Format("{0:n}", account.AmountLimit); } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void MetroWindow_Loaded(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); FundBank fundBank = db.FundBanks.Find(fundBankId); fundname.Text = string.Join("/", fundBank.AccountNumber, fundBank.Fund.FundName, fundBank.Bank.BankCode); } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void MetroWindow_Loaded(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); FundBank fundbank = db.FundBanks.Find(FundBankID); fundtb.Text = fundbank.Fund.FundName; banktb.Text = fundbank.Bank.BankName; accountnumbertb.Text = fundbank.AccountNumber; currentamounttb.Text = String.Format("{0:0.##}", fundbank.CurrentBalance); } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void savebtn_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); int id = (int)accountslistlb.SelectedValue; FundBank account = db.FundBanks.Find(id); account.FundID = (int)fundcb.SelectedValue; account.BankID = (int)bankcb.SelectedValue; account.AccountNumber = accountnumbertb.Text; account.AmountLimit = Convert.ToDecimal(flooramounttb.Text); db.SaveChanges(); var audit = new AuditTrailModel { Activity = "Updated bank account in the database. FUND BANK ID: " + id.ToString(), ModuleName = this.GetType().Name, EmployeeID = App.EmployeeID }; SystemClass.InsertLog(audit); MessageBox.Show("Account updated succesfully"); fundcb.IsEnabled = false; bankcb.IsEnabled = false; accountnumbertb.IsEnabled = false; flooramounttb.IsEnabled = false; savebtn.IsEnabled = false; editbtn.IsEnabled = true; db = new ImusCityHallEntities(); accountslistlb.ItemsSource = db.FundBanks.Where(m => m.IsActive == true).OrderByDescending(m => m.FundBankID).ToList(); accountslistlb.DisplayMemberPath = "AccountNumber"; accountslistlb.SelectedValuePath = "FundBankID"; accountslistlb.SelectedValue = id; } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void generatebtn_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { if (fundcb.SelectedValue == null) { MessageBox.Show("Please select fund"); } else if (String.IsNullOrEmpty(startdatedp.Text) || String.IsNullOrEmpty(enddatedp.Text)) { MessageBox.Show("Please select start date and end date"); } else { DateTime dateToday = DateTime.Now; string year = dateToday.Year.ToString().Substring(dateToday.Year.ToString().Length - 2); string month = dateToday.Month.ToString().PadLeft(2, '0'); int accountId = (int)fundcb.SelectedValue; ImusCityHallEntities db = new ImusCityHallEntities(); CDSSignatory signatories = db.CDSSignatories.FirstOrDefault(); FundBank account = db.FundBanks.Find(accountId); List <CheckIssuedModel> list = new List <CheckIssuedModel>(); if (db.GetCheckIssued(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId).Count() <= 0) { MessageBox.Show("There are no record in this selection"); return; } var result = db.GetCheckIssued(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId); string adviceNo = account.AdviceNo.HasValue ? account.AdviceNo.ToString() : null; foreach (var checkIssued in result) { var check = new CheckIssuedModel { StartDate = startdatedp.SelectedDate.Value, EndDate = enddatedp.SelectedDate.Value, BankName = checkIssued.BankName, AccoutNumber = checkIssued.AccountNumber, ReportNumber = string.Join("-", checkIssued.FundPrefix, year, month, adviceNo), DateCreated = checkIssued.DateCreated.Value, CheckNo = checkIssued.CheckNo, VoucherNo = checkIssued.VoucherNo, Center = "", CompanyName = checkIssued.CompanyName, PaymentNature = checkIssued.PaymentNature, Amount = checkIssued.Amount.Value, DisbursingOfficer = SystemClass.GetSignatory(signatories.DisbursingOfficer), CanDelBy = checkIssued.CAN_DELETE_EMP, CanDelDate = checkIssued.CAN_DELETE_DATE, Status = checkIssued.Status, StatusID = checkIssued.StatusID.Value }; list.Add(check); } ReportDataSet ds = new ReportDataSet(); ds.Locale = CultureInfo.InvariantCulture; // FillDataSet(ds); DataTable chIss = ds.Tables["CheckIssuedDataTable"]; foreach (CheckIssuedModel ci in list) { DataRow dr = chIss.Rows.Add(); dr.SetField("AccountNumber", ci.AccoutNumber); dr.SetField("Amount", ci.Amount); dr.SetField("BankName", ci.BankName); dr.SetField("CanDelBy", ci.CanDelBy); dr.SetField("CanDelDate", ci.CanDelDate); dr.SetField("Center", ci.Center); dr.SetField("CheckNo", ci.CheckNo); dr.SetField("CompanyName", ci.CompanyName); dr.SetField("DateCreated", ci.DateCreated); dr.SetField("DisbursingOfficer", ci.DisbursingOfficer); dr.SetField("EndDate", ci.EndDate); dr.SetField("PaymentNature", ci.PaymentNature); dr.SetField("ReportNumber", ci.ReportNumber); dr.SetField("StartDate", ci.StartDate); dr.SetField("Status", ci.Status); dr.SetField("StatusID", ci.StatusID); dr.SetField("VoucherNo", ci.VoucherNo); } ReportDocument report; report = new CheckDisbursement.Report.CheckIssuedReport(); report.SetDataSource(chIss); report.SetParameterValue("employee", "Generated By: " + SystemClass.Employee(App.EmployeeID)); reportviewer.ViewerCore.ReportSource = report; } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void savebtn_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); if (fundcb.SelectedValue == null) { MessageBox.Show("Please select fund"); } else if (bankcb.SelectedValue == null) { MessageBox.Show("Please select bank"); } else if (String.IsNullOrEmpty(accountnumbertb.Text)) { MessageBox.Show("Please input account number"); } else if (db.FundBanks.Any(m => m.AccountNumber == accountnumbertb.Text)) { MessageBox.Show("The account number is already used"); } else if (String.IsNullOrEmpty(startingbalancetb.Text)) { MessageBox.Show("Please input starting balance"); } else if (String.IsNullOrEmpty(advicenumbertb.Text)) { MessageBox.Show("Please input advice number"); } else if (String.IsNullOrEmpty(flooramounttb.Text)) { MessageBox.Show("Please input floor amount"); } else { ImusCityGovernmentSystem.Model.FundBank account = new FundBank(); account.FundID = (int)fundcb.SelectedValue; account.BankID = (int)bankcb.SelectedValue; account.AccountNumber = accountnumbertb.Text; account.CurrentBalance = Convert.ToDecimal(startingbalancetb.Text); account.StartingBalance = Convert.ToDecimal(startingbalancetb.Text); account.IsActive = true; account.DateAdded = DateTime.Now; account.AdviceNo = Convert.ToInt32(advicenumbertb.Text); account.IsProcessed = true; account.AmountLimit = Convert.ToDecimal(flooramounttb.Text); db.FundBanks.Add(account); ImusCityGovernmentSystem.Model.BankTrail banktrail = new BankTrail(); banktrail.DebitCredit = "D"; banktrail.FundBankID = account.FundBankID; banktrail.Amount = Convert.ToDecimal(startingbalancetb.Text); banktrail.EntryName = nameof(BankTrailEntry.FundCreation); banktrail.CheckID = null; banktrail.EntryNameID = (int)BankTrailEntry.FundCreation; banktrail.EmployeeID = App.EmployeeID; banktrail.DateCreated = DateTime.Now; db.BankTrails.Add(banktrail); db.SaveChanges(); var audit = new AuditTrailModel { Activity = "Added new bank account in the database. FUNDBANK ID: " + account.FundBankID.ToString(), ModuleName = this.GetType().Name, EmployeeID = App.EmployeeID }; SystemClass.InsertLog(audit); MessageBox.Show("Account added successfully"); SystemClass.ClearTextBoxes(this); } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void generatebtn_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { if (fundcb.SelectedValue == null) { MessageBox.Show("Please select fund"); } else if (String.IsNullOrEmpty(startdatedp.Text) || String.IsNullOrEmpty(enddatedp.Text)) { MessageBox.Show("Please select start date and end date"); } else { int accountId = (int)fundcb.SelectedValue; ImusCityHallEntities db = new ImusCityHallEntities(); CDSSignatory signatories = db.CDSSignatories.FirstOrDefault(); FundBank account = db.FundBanks.Find(accountId); if (db.GetCheckRegister(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId).Count() <= 0) { MessageBox.Show("There are no record in this selection"); return; } var result = db.GetCheckRegister(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId).Where(m => m.Status == "Created" || m.Status == "Cancelled" || m.Status == "Damaged"); CurrencyToWords convert = new CurrencyToWords(); double totalAmount = Convert.ToDouble(db.GetCheckRegister(startdatedp.SelectedDate, enddatedp.SelectedDate, accountId).Sum(m => m.Amount).Value); string amountInWords = convert.NumberToWords(totalAmount).ToUpper(); ReportDataSet ds = new ReportDataSet(); ds.Locale = CultureInfo.InvariantCulture; DataTable checkRegisterList = ds.Tables["CheckRegisterDataTable"]; foreach (var checkregister in result) { DataRow dr = checkRegisterList.Rows.Add(); dr.SetField("FundName", checkregister.FundName); dr.SetField("Branch", checkregister.Branch); dr.SetField("AccountNumber", checkregister.AccountNumber); dr.SetField("BankName", checkregister.BankName); dr.SetField("DateCreated", checkregister.DateCreated); dr.SetField("CheckNo", checkregister.CheckNo); dr.SetField("CompanyName", checkregister.CompanyName); dr.SetField("Amount", checkregister.Amount); dr.SetField("AmountInWords", amountInWords); dr.SetField("Status", checkregister.Status); } ReportDocument report; report = new CheckDisbursement.Report.AccountantCheckDisbursementReport(); report.SetDataSource(checkRegisterList); report.SetParameterValue("Signatory1", SystemClass.GetSignatory(signatories.CityAccountant)); report.SetParameterValue("Signatory2", SystemClass.GetSignatory(signatories.AccountantRepresentative)); report.SetParameterValue("AdviceNo", account.AdviceNo.HasValue ? account.AdviceNo.ToString() : ""); report.SetParameterValue("employee", "Generated By: " + SystemClass.Employee(App.EmployeeID)); reportviewer.ViewerCore.ReportSource = report; } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }