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)); }