public void PeriodicChatSpeakDelete(SharedPeriodicChatSpeak ChatCommand)
{
lock (this)
{
string sql = DeletePeriodicChatSpeakSQL;
m_context.Database.ExecuteSqlCommand(sql, new SQLiteParameter[] { new SQLiteParameter(":speakid", ChatCommand.SpeakId) });
}
}
public SharedPeriodicChatSpeak GetPeriodicChatSpeakBySpeakId(int speakid)
{
SharedPeriodicChatSpeak ChatCommand = null;
lock (this)
{
string sql = "select " + SelectPeriodicChatSpeakSQLFields + " from PeriodicChatSpeak WHERE SpeakId=:speakid;";
ChatCommand = m_context.Database.SqlQuery <SharedPeriodicChatSpeak>(sql,
new SQLiteParameter[]
{
}).FirstOrDefault();
}
return(ChatCommand);
}
public SharedPeriodicChatSpeak PeriodicChatSpeakSave(SharedPeriodicChatSpeak PeriodicSpeak)
{
SQLiteParameter[] sQLiteParameters = new SQLiteParameter[]
{
new SQLiteParameter(":channelname", PeriodicSpeak.ChannelName),
new SQLiteParameter(":speaktext", PeriodicSpeak.SpeakText),
new SQLiteParameter(":cooldownseconds", PeriodicSpeak.CoolDownSeconds),
new SQLiteParameter(":usercreated", PeriodicSpeak.UserCreated),
new SQLiteParameter(":datecreated", PeriodicSpeak.DateCreated),
new SQLiteParameter(":usermodified", PeriodicSpeak.UserModified),
new SQLiteParameter(":datemodified", PeriodicSpeak.DateModified),
new SQLiteParameter(":isactive", PeriodicSpeak.IsActive),
new SQLiteParameter(":speakid", PeriodicSpeak.SpeakId)
};
if (PeriodicSpeak.SpeakId != 0)
{
// Update
SharedPeriodicChatSpeak result = PeriodicSpeak;
lock (this)
{
string sql = UpdatePeriodicChatSpeakSQL + " CommandId=:commandid";
m_context.Database.ExecuteSqlCommand(sql, sQLiteParameters);
}
result = GetPeriodicChatSpeakBySpeakId(PeriodicSpeak.SpeakId);
return(result);
}
else
{
// Insert
SharedPeriodicChatSpeak result = PeriodicSpeak;
//lock (this)
//{
string sql = InsertPeriodicChatSpeakSQLFields;
m_context.Database.ExecuteSqlCommand(sql, sQLiteParameters);
//}
int resultid = m_context.Database.SqlQuery <int>(GetLastInsertedPeriodicChatSpeakCommandSQL, new SQLiteParameter[] { }).FirstOrDefault();
result = GetPeriodicChatSpeakBySpeakId(resultid);
return(result);
}
}
public void PeriodicChatSpeakDelete(SharedPeriodicChatSpeak ChatCommand)
{
data.PeriodicChatSpeakDelete(ChatCommand);
}
public SharedPeriodicChatSpeak PeriodicChatSpeakSave(SharedPeriodicChatSpeak PeriodicSpeak)
{
return(data.PeriodicChatSpeakSave(PeriodicSpeak));
}
