public List <msg_conv> GetconvListByUserName(string username, int userId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
List <Users> usersList = context.Users.Where(usr => usr.userName == username).ToList();
List <msg_conv> Emptyconv = new List <msg_conv>();
if (usersList.Count == 0)
{
return(Emptyconv);
}
else
{
int tergetUserId = usersList[0].id;
List <msg_conv> convList = context.msg_conv.Where(conv => (conv.user1 == tergetUserId && conv.user2 == userId) || (conv.user1 == userId && conv.user2 == tergetUserId)).ToList();
if (convList.Count == 0)
{
msg_conv conv = CreateConversation(userId, usersList[0].id);
convList.Add(conv);
return(convList);
}
else
{
return(convList);
}
}
}
}
public msg_conv GetConversationByConversationId(int converationId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
msg_conv msg_Conv = context.msg_conv.Where(mc => mc.id == converationId).FirstOrDefault();
return(msg_Conv);
}
}
public static msg_conv CreateConversation(int user1, int user2)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
msg_conv conv = new msg_conv()
{
user1 = user1, user2 = user2
};
context.msg_conv.Add(conv);
context.SaveChanges();
return(conv);
}
}
public static msg_conv GetConversationByConversationId(int conversationId)
{
try
{ return(_DB.GetConversationByConversationId(conversationId)); }
catch (Exception ex)
{
LogManager.LogError("MessangerHelper GetConversationByConversationId", ex.Message, "Temporary Empty");
msg_conv msg_Conv = new msg_conv()
{
id = -1
};
return(msg_Conv);
}
}
public bool CheckConversationUser(int userId, int convId)
{
using (var context = new IgorMarkivMessengerDBEntities())
{
msg_conv conv = context.msg_conv.Where(cv => cv.id == convId).FirstOrDefault();
if (conv.user1 == userId)
{
return(true);
}
else
{
return(false);
}
}
}
