public static bool LoadAudioClipsFromDB()
{
AudioclipsLoaded = true;
EventSystem.Publish <AudioclipsLoaded>(new AudioclipsLoaded {
});
return(AudioClipsTableMgr.LoadAudioClipsFromDB(AudioClips));
}
private static void CreateDatabaseTables()
{
string filename = DBAdmin.CreateDBFile();
if (EventLogTableMgr.CreateEventLogDBTable())
{
Logger.AddLogEntry(LogCategory.INFO, "Created Database file \'" + filename + "\'.");
}
SettingsTableMgr.CreateSettingsDBTable();
AudioClipsTableMgr.CreateAudioClipsDBTable();
TimeTriggerClipsTableMgr.CreateTimeTriggerClipsDBTable();
RulesetsTableMgr.CreateRulesetsDBTable();
RulesTableMgr.CreateRulesetRulesDBTable();
SessionsTableMgr.CreateSessionsDBTable();
SessionClipsTableMgr.CreateSessionsDBTable();
OnlineVoicesTableMgr.CreateOnlineVoicesDBTable();
}
public static int AddAudioClip(AudioClip newClip)
{
if (AudioClips.FirstOrDefault(x => x.Label.Equals(newClip.Label)) == null)
{
AudioClips.Add(newClip);
if (AudioClipsTableMgr.AddAudioClip(newClip))
{
newClip.ClipId = AudioClipsTableMgr.GetClipId(newClip.Label);
Logger.AddLogEntry(LogCategory.INFO, "Added AudioClip: " + newClip.StateAudioFile);
return(newClip.ClipId);
}
else
{
return(-2); // problem updating database
}
}
return(-1); // audioclip label already exits
}
public static bool DeleteAudioClip(string label, out string outcome)
{
var clip = AudioClips.FirstOrDefault(x => x.Label.Equals(label));
if (clip != null)
{
AudioClips.Remove(clip);
if (AudioClipsTableMgr.DeleteAudioClip(label))
{
Logger.AddLogEntry(LogCategory.INFO, "Deleted AudioClip: " + label);
outcome = "AudioClip deleted";
return(true);
}
else
{
outcome = "Error deleting AudioClip from database";
return(false);
}
}
outcome = "AudioClip name \'" + label + "\' not found.";
return(false);
}
public static int UpdateAudioClipToDB(AudioClip clipCopy)
{
var originalClip = AudioClips.FirstOrDefault(x => x.ClipId.Equals(clipCopy.ClipId));
if (!originalClip.Label.Equals(clipCopy.Label))
{
if (AudioClips.FirstOrDefault(x => x.Label.Equals(clipCopy.Label)) != null)
{
return(-1); // name already exists
}
}
var index = AudioClips.FindIndex(c => c.ClipId == originalClip.ClipId);
AudioClips[index] = clipCopy;
if (!AudioClipsTableMgr.UpdateAudioClip(clipCopy))
{
return(-2); // problem updating database
}
else
{
return(clipCopy.ClipId);
}
}
public static bool UpdateAudioClipsToDB()
{
return(AudioClipsTableMgr.UpdateAudioClips(AudioClips));
}
