private static GroupMessageStatus getGroupMessageStatusbyidAndReceiver(long GroupMessageId, long ReceiverId) { GroupMessageStatus chat = null; var db = new SQLiteConnection(CommonConstant.DBPath); try { chat = db.Query <GroupMessageStatus>("select * from 'GroupMessageStatus' where GroupMessageId=" + GroupMessageId + " and ReceiverId = " + ReceiverId + " and UserId=" + CommonHelper.GetUserId()) .ToList() .FirstOrDefault(); } catch (Exception ex) { Console.WriteLine(ex.Message, ex); } db.Close(); return(chat); }
public static GroupMessageStatus UpdateGroupMessageStatus(GroupMessageStatusViewModel grpMessage) { var db = new SQLiteConnection(CommonConstant.DBPath); GroupMessageStatus grpMsg = null; try { if (grpMessage != null) { grpMsg = getGroupMessageStatusbyidAndReceiver(grpMessage.GroupMessageId, grpMessage.ReceiverId); if (grpMsg != null) { grpMsg.IsSend = grpMessage.IsSend; grpMsg.IsRead = grpMessage.IsRead; grpMsg.IsRecieved = grpMessage.IsRecieved; grpMsg.UserId = CommonHelper.GetUserId(); db.Update(grpMsg); } else { grpMsg = new GroupMessageStatus(); grpMsg.GroupMessageId = grpMessage.GroupMessageId; grpMsg.IsSend = grpMessage.IsSend; grpMsg.IsRead = grpMessage.IsRead; grpMsg.IsRecieved = grpMessage.IsRecieved; grpMsg.ReceiverId = grpMessage.ReceiverId; grpMsg.UserId = CommonHelper.GetUserId(); db.Insert(grpMsg); } db.Commit(); } } catch (Exception ex) { Console.WriteLine(ex.Message, ex); } db.Close(); return(grpMsg); }
public static GroupMessageStatus GetGroupMessageOverallStatusbyid(long GroupMessageId) { List <GroupMessageStatus> var = null; var db = new SQLiteConnection(CommonConstant.DBPath); try { var = db.Query <GroupMessageStatus>("select * from 'GroupMessageStatus' where GroupMessageId=" + GroupMessageId + " and UserId=" + CommonHelper.GetUserId()) .ToList(); } catch (Exception ex) { Console.WriteLine(ex.Message, ex); } db.Close(); GroupMessageStatus returnStatus = new GroupMessageStatus(); if (var != null) { if (var.Where(a => a.IsSend == true).ToList().Count == var.Count) { returnStatus.IsSend = true; } if (var.Where(a => a.IsRead == true).ToList().Count == var.Count) { returnStatus.IsRead = true; } if (var.Where(a => a.IsRecieved == true).ToList().Count == var.Count) { returnStatus.IsRecieved = true; } } return(returnStatus); }