private void savebtn_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
if (String.IsNullOrEmpty(fundcodetb.Text) || String.IsNullOrEmpty(fundnametb.Text))
{
MessageBox.Show("Please input fund code and fund name");
}
else if (String.IsNullOrEmpty(voucherprefixtb.Text))
{
MessageBox.Show("Please enter voucher prefix");
}
else if (db.Funds.Any(m => m.FundCode == fundcodetb.Text))
{
MessageBox.Show("The fund code is already used");
}
else if (db.Funds.Any(m => m.FundName == fundnametb.Text))
{
MessageBox.Show("The fund name is already used");
}
else
{
ImusCityGovernmentSystem.Model.Fund fund = new Model.Fund();
fund.FundCode = fundcodetb.Text;
fund.FundName = fundnametb.Text;
fund.FundPrefix = voucherprefixtb.Text;
fund.IsActive = true;
db.Funds.Add(fund);
db.SaveChanges();
Mouse.OverrideCursor = null;
var audit = new AuditTrailModel
{
Activity = "Added new fund in the database. FUND CODE: " + fundcodetb.Text,
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("New item added successfully.");
SystemClass.ClearTextBoxes(this);
}
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
Mouse.OverrideCursor = null;
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
if (String.IsNullOrEmpty(bankcodetb.Text) || String.IsNullOrEmpty(banknametb.Text))
{
MessageBox.Show("Please input bank code and bank name");
}
else if (String.IsNullOrEmpty(branchtb.Text))
{
MessageBox.Show("Please enter branch name");
}
else if (db.Banks.Any(m => m.BankCode == bankcodetb.Text))
{
MessageBox.Show("The bank code is already used");
}
else
{
ImusCityGovernmentSystem.Model.Bank bank = new Model.Bank();
bank.BankCode = bankcodetb.Text;
bank.BankName = banknametb.Text;
bank.Branch = branchtb.Text;
bank.IsActive = true;
db.Banks.Add(bank);
db.SaveChanges();
Mouse.OverrideCursor = null;
var audit = new AuditTrailModel
{
Activity = "Added new bank in the database. BANK CODE: " + bankcodetb.Text,
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("New item added successfully.");
SystemClass.ClearTextBoxes(this);
}
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
Mouse.OverrideCursor = null;
}
public void ResetFields()
{
SystemClass.ClearTextBoxes(this);
currentimage.Source = null;
imagecapture.Source = null;
voucherNumbertb.Text = "";
checknumbertb.Text = "";
checkdatetb.Text = null;
companynametb.Text = "";
checkdescriptiontb.Text = "";
banktb.Text = "";
amountb.Text = "";
digitalsignatureimg.Source = null;
LoadCheckList();
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
Mouse.OverrideCursor = Cursors.Wait;
if (String.IsNullOrEmpty(fnametb.Text) || String.IsNullOrEmpty(lnametb.Text))
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please input first name and last name field!");
}
else if (String.IsNullOrEmpty(mobilenotb.Text))
{
MessageBox.Show("Please input mobile number");
}
else
{
ImusCityHallEntities db = new ImusCityHallEntities();
PayeeRepresentative pr = new PayeeRepresentative();
pr.FirstName = fnametb.Text;
pr.MiddleName = mnametb.Text;
pr.LastName = lnametb.Text;
pr.MobileNo = mobilenotb.Text;
pr.Landline = landlinetb.Text;
db.PayeeRepresentatives.Add(pr);
db.SaveChanges();
Mouse.OverrideCursor = null;
var audit = new AuditTrailModel
{
Activity = "Added new payee representative in the database. NAME: " + fnametb.Text + " " + lnametb.Text,
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Representative addedd successfully!");
SystemClass.ClearTextBoxes(this);
}
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
Mouse.OverrideCursor = null;
}
private void clearbtn_Click(object sender, RoutedEventArgs e)
{
SystemClass.ClearTextBoxes(this);
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
if (SystemClass.CheckConnection())
{
if (String.IsNullOrEmpty(payeenotb.Text) || String.IsNullOrEmpty(companynametb.Text) || String.IsNullOrEmpty(companyaddresstb.Text))
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please input company name, company address and payee number");
}
else if (gd.Where(m => m.IsSelected == true).Count() == 0)
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please select at least one representative for the payee!");
}
else
{
ImusCityHallEntities db = new ImusCityHallEntities();
if (db.Payees.FirstOrDefault(m => m.PayeeNo == payeenotb.Text) != null)
{
Mouse.OverrideCursor = null;
MessageBox.Show("Payee number already exist!");
}
else
{
ImusCityGovernmentSystem.Model.Payee payee = new Model.Payee();
payee.PayeeNo = payeenotb.Text;
payee.CompanyName = companynametb.Text;
payee.CompanyAddress = companyaddresstb.Text;
payee.TIN = tinnotb.Text;
payee.LandlineNo = contactnotb.Text;
payee.IsActive = true;
db.Payees.Add(payee);
db.SaveChanges();
foreach (var list in gd.Where(m => m.IsSelected == true))
{
PayeeRepresentative pr = db.PayeeRepresentatives.Find(list.Id);
pr.PayeeID = payee.PayeeID;
db.SaveChanges();
}
Mouse.OverrideCursor = null;
var audit = new AuditTrailModel
{
Activity = "Added new payee in the database. PAYEE NO." + payeenotb.Text,
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Payee added successfully!");
SystemClass.ClearTextBoxes(this);
LoadPayeeRepresentative();
}
}
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
Mouse.OverrideCursor = null;
}
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);
}
}
