public SelectedSensitiveItemViewModel(SensitiveItemBaseClass sensitiveItem, WeaponAssignments weaponAssignment, RoleAssignments roleAssignment)
{
DisplayName = "SI Information";
if (sensitiveItem != null)
{
SensitiveItemBaseClass = sensitiveItem;
}
if (weaponAssignment != null)
{
WeaponAssignments = weaponAssignment;
}
if (roleAssignment.Role == weaponAssignment.Role)
{
RoleAssignments = roleAssignment;
if (roleAssignment.AssignedSoldier.Status == 4)
{
SIStatus = "Not Checked Out";
}
SIStatus = roleAssignment.AssignedSoldier.StatusString;
}
else
{
SIStatus = "Not Checked Out";
}
}
public void AddSIBtn()
{
if (RoleWeaponAssignment == null)
{
RoleWeaponAssignment = new WeaponAssignments();
RoleWeaponAssignment.Role = Role;
AllWeaponAssignemnts.Add(RoleWeaponAssignment);
}
SelectedRoleAddAssignedSIViewModel = new SelectedRoleAddAssignedSIViewModel(Role, RoleWeaponAssignment, ListOfSITypes, ListOfAllSI, AllWeaponAssignemnts);
_windowManager.ShowWindow(SelectedRoleAddAssignedSIViewModel);
SelectedRoleAddAssignedSIViewModel.Deactivated += SelectedRoleAddAssignedSIViewModel_Deactivated;
}
public static void RemoveWeaponAssignmnet(WeaponAssignments weaponAssignment, SensitiveItemBaseClass selectedSI)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@RoleID", weaponAssignment.Role.RoleID);
parameters.Add("@SIID", selectedSI.SiIndex);
cnn.Execute("Delete From SIAssignments where RoleID = @RoleID AND SIID = @SIID", parameters);
}
}
public SelectedRoleAddAssignedSIViewModel(Roles role, WeaponAssignments roleWeaponAssignments, Dictionary <int, string> listOfWeapons, List <SensitiveItemBaseClass> sensitiveItem, List <WeaponAssignments> allWeaponAssignments)
{
SelectedSI = new List <SensitiveItemBaseClass>();
DisplayName = "Assign SI to Role";
AvailSITypes = new BindableCollection <string>();
SensitiveItems = sensitiveItem;
WeaponAssignment = roleWeaponAssignments;
AllWeaponAssignments = allWeaponAssignments;
Role = role;
foreach (KeyValuePair <int, string> keyValuePair in listOfWeapons)
{
AvailSITypes.Add(keyValuePair.Value);
}
}
public static void SaveWeaponAssignments(WeaponAssignments newWeaponAssignmet)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
foreach (SensitiveItemBaseClass si in newWeaponAssignmet.AssignedSI)
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@RoleID", newWeaponAssignmet.Role.RoleID);
parameters.Add("@SIID", si.SiIndex);
var output = cnn.Query <RoleAssignments>("select * from SIAssignments where SIID == @SIID AND RoleID = @RoleID ", parameters);
List <RoleAssignments> tmp = output.ToList();
if (tmp.Count == 0)
{
cnn.Execute("insert into SIAssignments (SIID,RoleID) values (@SIID,@RoleID) ", parameters);
}
}
}
}
