public static bool DeleteCharacter(CharacterInformation.Character existingChar)
{
if (_activeConnection == null)
{
_activeConnection = CreateConnection();
}
bool success = false;
try
{
SqliteCommand command = _activeConnection.CreateCommand();
command.CommandText = "DELETE FROM Celebrities WHERE celeb_id = '" + existingChar.CharID + "'";
command.ExecuteNonQuery();
success = true;
EndConnection();
}
catch (Exception ex)
{
Debug.LogWarning("Error deleting character " + existingChar.Name + ": " + ex.Message);
}
return(success);
}
public void RegisterPhoto(string path, List <CharacterInformation.Character> celebritiesInPhoto)
{
Photo newPhoto = new Photo(path, GameNumber);
newPhoto.CelebritiesInPhoto = new List <CharacterInformation.Character>(celebritiesInPhoto);
newPhoto.RoundTakenDuring = _gameNumber;
newPhoto.LoadImage();
//Record index of PhotosThisRound with their associated celebrities
CharacterInformation[] celebsInScene = new CharacterInformation[CelebTargets.Keys.Count];
CelebTargets.Keys.CopyTo(celebsInScene, 0);
for (int i = 0; i < celebsInScene.Length; i++)
{
CharacterInformation.Character celebChar = celebsInScene[i].GetInfo();
if (newPhoto.CelebritiesInPhoto.Contains(celebChar))
{
int celebPhotoIndex = PhotosThisRound.Count;
CelebTargets[celebsInScene[i]] = celebPhotoIndex;
//TEMP tell player that they took a picture of that celeb
IndicateCelebColors.SetCelebFound(i);
}
}
PhotosThisRound.Add(newPhoto);
}
public static bool AddCharacter(CharacterInformation.Character newChar)
{
if (_activeConnection == null)
{
_activeConnection = CreateConnection();
}
bool success = false;
try
{
SqliteCommand command = _activeConnection.CreateCommand();
command.CommandText = "INSERT INTO Celebrities(celeb_id, name) VALUES(" + newChar.CharID + ", '" + newChar.Name + "');";
command.ExecuteNonQuery();
success = true;
EndConnection();
}
catch (Exception ex)
{
Debug.LogWarning("Error inserting character " + newChar.Name + ": " + ex.Message);
}
return(success);
}
