public static Message.MessageRecipient ConvertFromMessageRecipientDB(MessageRecipientDB item) { Message.MessageRecipient toReturn = new Message.MessageRecipient(); toReturn.AccountID = new Guid(item.AccountGuid); toReturn.IsRead = item.IsRead; return toReturn; }
public static MessageRecipientDB ConvertFromMessageRecipient(Message.MessageRecipient item) { MessageRecipientDB toReturn = new MessageRecipientDB(); toReturn.AccountGuid = item.AccountID.ToString(); toReturn.IsRead = item.IsRead; return toReturn; }
public void MarkMessageRead(string messageGuid, string ownerAccountID) { #if(DEBUG) Console.WriteLine("Will mark message read! {0}", messageGuid); #endif lock (this.dbLock) { using (SQLiteConnection sqlCon = new SQLiteConnection(this.DBPath)) { sqlCon.Execute(WZConstants.DBClauseSyncOff); sqlCon.BeginTransaction(); try { if (sqlCon.Execute("UPDATE MessageRecipientDB SET IsRead=? WHERE MessageGuid=? AND AccountGuid=?", true, messageGuid, ownerAccountID) == 0) { MessageRecipientDB msgRcp = new MessageRecipientDB() { AccountGuid = ownerAccountID, MessageGuid = messageGuid, IsRead = true }; #if(DEBUG) Console.WriteLine("Created a new message recipient! {0}", msgRcp); #endif sqlCon.Insert(msgRcp, typeof(MessageRecipientDB)); }//end if sqlCon.Commit(); } catch (Exception ex) { #if(DEBUG) Console.WriteLine("Error in MarkMessageRead! {0}--{1}", ex.Message, ex.StackTrace); #endif sqlCon.Rollback(); }//end try catch }//end using sqlCon }//end lock }