private void deletebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
if (banklb.SelectedValue != null)
{
ImusCityHallEntities db = new ImusCityHallEntities();
int id = (int)banklb.SelectedValue;
ImusCityGovernmentSystem.Model.Bank bank = db.Banks.Find(id);
bank.IsActive = false;
db.SaveChanges();
db = new ImusCityHallEntities();
banklb.ItemsSource = db.Banks.Where(m => m.IsActive == true).OrderByDescending(m => m.BankID).ToList();
banklb.DisplayMemberPath = "BankName";
banklb.SelectedValuePath = "BankID";
var audit = new AuditTrailModel
{
Activity = "Deleted item in the fund list. BANK ID: " + id.ToString(),
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
}
else
{
MessageBox.Show("Please select an item");
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void MetroWindow_Loaded(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
ImusCityGovernmentSystem.Model.Bank bank = db.Banks.Find(BankID);
bankcodetb.Text = bank.BankCode;
banknametb.Text = bank.BankName;
branchtb.Text = bank.Branch;
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
if (SystemClass.CheckConnection())
{
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
{
ImusCityHallEntities db = new ImusCityHallEntities();
ImusCityGovernmentSystem.Model.Bank bank = db.Banks.Find(BankID);
bank.BankCode = bankcodetb.Text;
bank.BankName = banknametb.Text;
bank.Branch = branchtb.Text;
db.SaveChanges();
Mouse.OverrideCursor = null;
var audit = new AuditTrailModel
{
Activity = "Updated an item in bank list. BANK ID: " + BankID.ToString(),
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Bank updated successfully!");
}
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
Mouse.OverrideCursor = null;
}