private void savebtn_Click(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); if (db.CDSSignatories.Any()) { ImusCityGovernmentSystem.Model.CDSSignatory signatory = db.CDSSignatories.FirstOrDefault(); signatory.CityMayor = mayorcb.SelectedValue == null ? null : (int?)mayorcb.SelectedValue; switch (mayorrb.IsChecked) { case true: signatory.UseActingMayor = false; break; case false: signatory.UseActingMayor = true; break; } signatory.CityTreasurer = treasurercb.SelectedValue == null ? null : (int?)treasurercb.SelectedValue; signatory.CityAccountant = accountantcb.SelectedValue == null ? null : (int?)accountantcb.SelectedValue; signatory.AccountantRepresentative = accountantrepcb.SelectedValue == null ? null : (int?)accountantrepcb.SelectedValue; signatory.CityAdministrator = administratorcb.SelectedValue == null ? null : (int?)administratorcb.SelectedValue; signatory.DisbursingOfficer = disbursingcb.SelectedValue == null ? null : (int?)disbursingcb.SelectedValue; db.SaveChanges(); MessageBox.Show("Signatories for CDS was updated"); var audit = new AuditTrailModel { Activity = "Updated CDS signatories", ModuleName = this.GetType().Name, EmployeeID = App.EmployeeID }; SystemClass.InsertLog(audit); } else { ImusCityGovernmentSystem.Model.CDSSignatory signatory = new CDSSignatory(); switch (mayorrb.IsChecked) { case true: signatory.UseActingMayor = false; break; case false: signatory.UseActingMayor = true; break; } signatory.CityMayor = mayorcb.SelectedValue == null ? null : (int?)mayorcb.SelectedValue; signatory.CityTreasurer = treasurercb.SelectedValue == null ? null : (int?)treasurercb.SelectedValue; signatory.CityAccountant = accountantcb.SelectedValue == null ? null : (int?)accountantcb.SelectedValue; signatory.AccountantRepresentative = accountantrepcb.SelectedValue == null ? null : (int?)accountantrepcb.SelectedValue; signatory.CityAdministrator = administratorcb.SelectedValue == null ? null : (int?)administratorcb.SelectedValue; signatory.DisbursingOfficer = disbursingcb.SelectedValue == null ? null : (int?)disbursingcb.SelectedValue; db.CDSSignatories.Add(signatory); db.SaveChanges(); MessageBox.Show("Signatories for CDS was updated"); var audit = new AuditTrailModel { Activity = "Added new CDS Signatories", ModuleName = this.GetType().Name, EmployeeID = App.EmployeeID }; SystemClass.InsertLog(audit); } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }
private void MetroWindow_Loaded(object sender, RoutedEventArgs e) { if (SystemClass.CheckConnection()) { ImusCityHallEntities db = new ImusCityHallEntities(); var result = from p in db.Employees select new { ID = p.EmployeeID, Name = p.FirstName + " " + p.LastName }; mayorcb.ItemsSource = result.OrderBy(m => m.Name).ToList(); mayorcb.DisplayMemberPath = "Name"; mayorcb.SelectedValuePath = "ID"; treasurercb.ItemsSource = result.OrderBy(m => m.Name).ToList(); treasurercb.DisplayMemberPath = "Name"; treasurercb.SelectedValuePath = "ID"; accountantcb.ItemsSource = result.OrderBy(m => m.Name).ToList(); accountantcb.DisplayMemberPath = "Name"; accountantcb.SelectedValuePath = "ID"; accountantrepcb.ItemsSource = result.OrderBy(m => m.Name).ToList(); accountantrepcb.DisplayMemberPath = "Name"; accountantrepcb.SelectedValuePath = "ID"; administratorcb.ItemsSource = result.OrderBy(m => m.Name).ToList(); administratorcb.DisplayMemberPath = "Name"; administratorcb.SelectedValuePath = "ID"; disbursingcb.ItemsSource = result.OrderBy(m => m.Name).ToList(); disbursingcb.DisplayMemberPath = "Name"; disbursingcb.SelectedValuePath = "ID"; if (db.CDSSignatories.Any()) { ImusCityGovernmentSystem.Model.CDSSignatory signatory = db.CDSSignatories.FirstOrDefault(); switch (signatory.UseActingMayor) { case true: mayorrb.IsChecked = false; actingrb.IsChecked = true; break; case false: mayorrb.IsChecked = true; actingrb.IsChecked = false; break; } mayorcb.SelectedValue = signatory.CityMayor; treasurercb.SelectedValue = signatory.CityTreasurer; accountantcb.SelectedValue = signatory.CityAccountant; accountantrepcb.SelectedValue = signatory.AccountantRepresentative; administratorcb.SelectedValue = signatory.CityAdministrator; disbursingcb.SelectedValue = signatory.DisbursingOfficer; } else { mayorrb.IsChecked = true; } } else { MessageBox.Show(SystemClass.DBConnectionErrorMessage); } }