public List <Message> GetAllMessages()
{
using (NiChatWebContext db = new NiChatWebContext())
{
return(db.Messages.ToList()); //retornamos toda la lista de mensajes
}
}
public List <User> GetAllUsers()
{
using (NiChatWebContext db = new NiChatWebContext())
{
return(db.Users.ToList());
}
}
public Chat GetChatById(int id)
{
using (NiChatWebContext db = new NiChatWebContext())
{
return(db.Chats.First(x => x.Id == id)); //retornamos el primer chat que tenga ese id
}
}
public List <Chat> GetAllChats()
{
using (NiChatWebContext db = new NiChatWebContext())
{
return(db.Chats.ToList()); //retornamos todos los chats
}
}
public bool UpdateChat(Chat chat)
{
using (NiChatWebContext db = new NiChatWebContext())
{
db.Entry(chat).State = EntityState.Modified; //decimos que el estdo del chat cambio
db.SaveChanges();
return(true);
}
}
public List <Message> GetAllMessagesByChat(Chat chat = null, int?idChat = null)
{
if (idChat != null)
{
using (NiChatWebContext db = new NiChatWebContext())
{
return(db.Messages.Where(x => x.FChat == idChat).ToList()); //retornamos los menmsajes de ese chat
}
}
return(null);
}
public List <Message> GetAllMessagesByUser(User user = null, int?idUser = null) //obtener mensjaes de un user especifico
{
using (NiChatWebContext db = new NiChatWebContext())
{
if (user != null)
{
return(db.Messages.Where(x => x.FuserNavigation == user).ToList());
}
if (idUser != null)
{
return(db.Messages.Where(x => x.FUser == idUser).ToList()); //retornamos todos los mensajes de un usario especifico
}
}
return(null);
}
public List <Chat> GetAllChatsByUser(User user = null, int?idUser = null) //obtener chats de un user en especifico
{
if (idUser != null)
{
using (NiChatWebContext db = new NiChatWebContext())
{
var chats = from chat in GetAllChats()
join _union in db.UserChats on chat.Id equals _union.FChat
join _user in db.Users on _union.FUser equals _user.Id
where _user.Id == idUser
select chat; //selccionamos todos los chats que pertencezcan al id del usuario
return(chats.ToList()); //retornamos la lista de chats
}
}
return(null);
}
public bool InsertChat(UserChat joinChat)
{
using (NiChatWebContext db = new NiChatWebContext())
{
var newChat = joinChat.FchatNavigation; newChat.Creation = DateTime.Now;
db.Chats.Add(newChat); //anadimos el nuevo chat a la base de datos
db.SaveChanges();
joinChat.FChat = newChat.Id;
var queryJoin = @"INSERT INTO [dbo].[User_Chat] (FUser,FChat) VALUES
(@FUser,@FChat)";
var result = _connection.Execute(queryJoin, joinChat); //introducimos la union para que el usuario pertenezca a ese chat
if (result > 0)
{
return(true);
}
}
return(false);
}
