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