private void deletebtn_Click(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
if (payeelb.SelectedValue != null)
{
ImusCityHallEntities db = new ImusCityHallEntities();
int id = (int)payeelb.SelectedValue;
ImusCityGovernmentSystem.Model.Payee payee = db.Payees.Find(id);
payee.IsActive = false;
db.SaveChanges();
db = new ImusCityHallEntities();
payeelb.ItemsSource = db.Payees.Where(m => m.IsActive == true).OrderByDescending(m => m.PayeeID).ToList();
payeelb.DisplayMemberPath = "CompanyName";
payeelb.SelectedValuePath = "PayeeID";
var audit = new AuditTrailModel
{
Activity = "Deleted item in the payee list. PAYEE ID: " + id.ToString(),
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
}
else
{
}
}
else
{
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void MetroWindow_Loaded(object sender, RoutedEventArgs e)
{
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
ImusCityGovernmentSystem.Model.Payee payee = db.Payees.Find(PayeeID);
payeenotb.Text = payee.PayeeNo;
companynametb.Text = payee.CompanyName;
companyaddresstb.Text = payee.CompanyAddress;
tinnotb.Text = payee.TIN;
contactnotb.Text = payee.LandlineNo;
gd.Clear();
db = new ImusCityHallEntities();
if (db.PayeeRepresentatives.Where(m => m.PayeeID == PayeeID).Count() == 0)
{
var representative = db.PayeeRepresentativeViews.OrderBy(m => m.PayeeRepresentativeName).ToList();
foreach (var dr in representative)
{
PayeeRepresentativeClass i = new PayeeRepresentativeClass()
{
Name = dr.PayeeRepresentativeName.ToString(),
Id = dr.PayeeRepID
};
gd.Add(i);
}
}
else
{
var representative = db.PayeeRepresentativeViews.OrderBy(m => m.PayeeRepresentativeName).ToList();
foreach (var dr in representative)
{
PayeeRepresentativeClass i = new PayeeRepresentativeClass()
{
Name = dr.PayeeRepresentativeName.ToString(),
Id = dr.PayeeRepID,
IsSelected = dr.PayeeID == null || dr.PayeeID != PayeeID ? false : true
};
gd.Add(i);
}
}
represetativelb.ItemsSource = gd;
represetativelb.Items.Refresh();
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
}
private void savebtn_Click(object sender, RoutedEventArgs e)
{
Mouse.OverrideCursor = Cursors.Wait;
if (SystemClass.CheckConnection())
{
ImusCityHallEntities db = new ImusCityHallEntities();
if (gd.Where(m => m.IsSelected == true).Count() == 0)
{
Mouse.OverrideCursor = null;
MessageBox.Show("Please select at least representative for the payee!");
}
else 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
{
ImusCityGovernmentSystem.Model.Payee payee = db.Payees.Find(PayeeID);
payee.PayeeNo = payeenotb.Text;
payee.CompanyName = companynametb.Text;
payee.CompanyAddress = companyaddresstb.Text;
payee.TIN = tinnotb.Text;
payee.LandlineNo = contactnotb.Text;
db.SaveChanges();
foreach (var list in gd)
{
if (list.IsSelected == true)
{
PayeeRepresentative pr = db.PayeeRepresentatives.Find(list.Id);
pr.PayeeID = payee.PayeeID;
db.SaveChanges();
}
else
{
PayeeRepresentative pr = db.PayeeRepresentatives.Find(list.Id);
pr.PayeeID = null;
db.SaveChanges();
}
}
Mouse.OverrideCursor = null;
var audit = new AuditTrailModel
{
Activity = "Updated an item in payee list. PAYEE ID: " + PayeeID.ToString(),
ModuleName = this.GetType().Name,
EmployeeID = App.EmployeeID
};
SystemClass.InsertLog(audit);
MessageBox.Show("Payee updated successfully!");
}
}
else
{
Mouse.OverrideCursor = null;
MessageBox.Show(SystemClass.DBConnectionErrorMessage);
}
Mouse.OverrideCursor = null;
}
