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 static void RemoveSensitiveItem(SensitiveItemBaseClass sensitiveItem)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@SiIndex", sensitiveItem.SiIndex);
cnn.Execute("delete from SensitiveItems where SiIndex = @SiIndex", parameters);
}
}
public void AddItemBtn()
{
if (SerialNumber != 0 && EquipmentName != "" && AdminNumber != "")
{
SensitiveItemBaseClass si = new SensitiveItemBaseClass();
si.EquipmentName = EquipmentName;
si.SerialNumber = SerialNumber;
si.RosterNumber = AdminNumber;
SiList.Add(si);
ArmyDataBaseConnector.SaveSensitiveItem(si);
TryClose();
}
}
public static void SaveSensitiveItem(SensitiveItemBaseClass sensitiveItem)
{
using (IDbConnection cnn = new SQLiteConnection(LoadConnectionString()))
{
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@EquipmentName", sensitiveItem.EquipmentName);
parameters.Add("@SerialNumber", sensitiveItem.SerialNumber);
parameters.Add("@RosterNumber", sensitiveItem.RosterNumber);
var output = cnn.Query <SensitiveItemBaseClass>("select * from SensitiveItems where EquipmentName == @EquipmentName AND SerialNumber == @SerialNumber AND RosterNumber = @RosterNumber", parameters);
List <SensitiveItemBaseClass> tmp = output.ToList();
if (tmp.Count == 0)
{
cnn.Execute("insert into SensitiveItems (EquipmentName,SerialNumber,RosterNumber) values (@EquipmentName,@SerialNumber,@RosterNumber) ", parameters);
}
}
}
public WeaponAssignments(SensitiveItemBaseClass siList, Roles newRole)
{
AssignedSI = new List <SensitiveItemBaseClass>();
AssignedSI.Add(siList);
Role = newRole;
}
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);
}
}
