private void deletebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
if (fundlb.SelectedValue != null)
{
ImusCityHallEntities db = new ImusCityHallEntities();
int id = (int)fundlb.SelectedValue;
ImusCityGovernmentSystem.Model.Fund fund = db.Funds.Find(id);
fund.IsActive = false;
db.SaveChanges();
db = new ImusCityHallEntities();
fundlb.ItemsSource = db.Funds.Where(m => m.IsActive == true).OrderByDescending(m => m.FundID).ToList();
fundlb.DisplayMemberPath = "FundName";
fundlb.SelectedValuePath = "FundID";
var audit = new AuditTrailModel
{
Activity = "Deleted item in the fund list. FUND 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.Fund fund = db.Funds.Find(FundID);
fundcodetb.Text = fund.FundCode;
fundnametb.Text = fund.FundName;
voucherprefixtb.Text = fund.FundPrefix;
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
if (SystemClass.CheckConnection())
{
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
{
ImusCityHallEntities db = new ImusCityHallEntities();
ImusCityGovernmentSystem.Model.Fund fund = db.Funds.Find(FundID);
fund.FundCode = fundcodetb.Text;
fund.FundName = fundnametb.Text;
fund.FundPrefix = voucherprefixtb.Text;
db.SaveChanges();
Mouse.OverrideCursor = null;
var audit = new AuditTrailModel
{
Activity = "Updated an item in fund list. FUND ID: " + FundID.ToString(),
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Fund updated successfully!");
}
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
Mouse.OverrideCursor = null;
}