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