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