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