public MainViewModel(string filePath)
{
ArmySIExcelSheet = new ArmySIExcelSheet(filePath);
foreach (SensitiveItemBaseClass si in ArmySIExcelSheet.SIList.AllItems)
{
ArmyDataBaseConnector.SaveSensitiveItem(si);
}
foreach (Soldier soldier in ArmySIExcelSheet.SoldierList)
{
ArmyDataBaseConnector.SaveSoldierInfo(soldier);
}
SensitiveItemsList = ArmyDataBaseConnector.LoadSensitiveItemList();
ArmySIExcelSheet.RolesList = ArmyDataBaseConnector.LoadRoles();
RolesList = ArmyDataBaseConnector.LoadRoles();
SoldiersList = ArmyDataBaseConnector.LoadSoldierInfo();
RolesAssignmentsList = ArmyDataBaseConnector.LoadRoleAssignments(SoldiersList, RolesList);
WeaponAssignmentsList = ArmyDataBaseConnector.LoadWeaponAssignments(RolesList, SensitiveItemsList);
/*//Test Stuff out
* ArmySIExcelSheet.SoldierList = ArmyDataBaseConnector.LoadSoldierInfo();
* ArmySIExcelSheet.SIList.AllItems = ArmyDataBaseConnector.LoadSensitiveItemList();
* Roles testRole = new Roles();
* //testing role stuff
* testRole.FireTeam = 1;
* testRole.Platoon = 1;
* testRole.RoleName = "Alpha Team Leader";
* testRole.Squad = 1;
* testRole.RoleID = ArmyDataBaseConnector.SaveRole(testRole);
*
* //Testing Assigned Roles
* RoleAssignments roleAssignments = new RoleAssignments();
* roleAssignments.Role = testRole;
* roleAssignments.AssignedSoldier = _armySIExcelSheet.SoldierList[10];
* ArmyDataBaseConnector.SaveRoleAssignments(roleAssignments);
*
* //Testing loading Assigned Roles
* List<Roles> roles = new List<Roles>();
* roles.Add(testRole);
* List<RoleAssignments> roleAssignments1 = ArmyDataBaseConnector.LoadRoleAssignments(ArmySIExcelSheet.SoldierList, roles);
*
* //Testing Weapon Assignments
* WeaponAssignments weaponAssignments = new WeaponAssignments();
* weaponAssignments.AssignedSI.Add(ArmySIExcelSheet.SIList.AllItems[110]);
* weaponAssignments.Role = testRole;
* ArmyDataBaseConnector.SaveWeaponAssignments(weaponAssignments);
* ArmyDataBaseConnector.RemoveWeaponAssignmnet(weaponAssignments, ArmySIExcelSheet.SIList.AllItems[110]);
*
* //End of testing stuff*/
Items.Add(new SoldierRosterPlatoonTabControlViewModel(this));
Items.Add(new SensitiveItemTabControlViewModel(SensitiveItemsList, RolesAssignmentsList, WeaponAssignmentsList));
Items.Add(new RolesInformationViewModel(this));
Items.Add(new FinalReportViewModel(SoldiersList, SensitiveItemsList, WeaponAssignmentsList, RolesList, RolesAssignmentsList));
ArmySIExcelSheet.ExportSISheet("test.xlsx", SoldiersList, WeaponAssignmentsList, RolesList, RolesAssignmentsList, SensitiveItemsList);
}
public ArmyDrillSheet(ref ArmySIExcelSheet armySIExcelSheet)
{
_soldierAttended = new List <Soldier>();
_armySIWorksheet = armySIExcelSheet;
_siItems = new SensitiveItemList();
_siRoster = new Dictionary <Soldier, SensitiveItemList>();
_drillDate = new DateTime();
_excelTableName = "ArmySIRoster";
}
public void ExportExcelBtn()
{
if (ExcelSheetFilePath != "")
{
ArmySIExcelSheet armySIExcelSheet = new ArmySIExcelSheet();
int ret = armySIExcelSheet.ExportSISheet(ExcelSheetFilePath, Soldiers, WeaponAssignments, Roles, RoleAssignments, SensitiveItemBaseClasses);
if (ret == 1)
{
MessageBox.Show("Exported Excel Sheet to " + ExcelSheetFilePath);
}
}
}
public MainViewModel()
{
ArmySIExcelSheet = new ArmySIExcelSheet();
SensitiveItemsList = ArmyDataBaseConnector.LoadSensitiveItemList();
RolesList = ArmyDataBaseConnector.LoadRoles();
SoldiersList = ArmyDataBaseConnector.LoadSoldierInfo();
RolesAssignmentsList = ArmyDataBaseConnector.LoadRoleAssignments(SoldiersList, RolesList);
WeaponAssignmentsList = ArmyDataBaseConnector.LoadWeaponAssignments(RolesList, SensitiveItemsList);
Items.Add(new SoldierRosterPlatoonTabControlViewModel(this));
Items.Add(new SensitiveItemTabControlViewModel(SensitiveItemsList, RolesAssignmentsList, WeaponAssignmentsList));
Items.Add(new RolesInformationViewModel(this));
Items.Add(new FinalReportViewModel(SoldiersList, SensitiveItemsList, WeaponAssignmentsList, RolesList, RolesAssignmentsList));
//ArmySIExcelSheet.ExportSISheet("test.xlsx", SoldiersList, WeaponAssignmentsList, RolesList, RolesAssignmentsList, SensitiveItemsList);
}
