public void New(Message msg, MaildbContext context, ApplicationUser appUser)
{
msg.MailDate = DateTime.Now;
msg.MailFrom = appUser.Email;
context.Messages.Add(msg);
context.SaveChanges();
}
private List <Message> ShowSpecificMessages(MaildbContext context, AdvancedSearchQuery query)
{
List <Message> message = new List <Message>();
if (query.MailFrom != null)
{
message.AddRange(context.Messages.Where(c => c.MailFrom.Contains(query.MailFrom)));
}
if (query.MailTo != null)
{
message.AddRange(context.Messages.Where(c => c.MailTo.Contains(query.MailTo)));
}
if (query.MailTitle != null)
{
message.AddRange(context.Messages.Where(c => c.MailTitle.Contains(query.MailTitle)));
}
if (query.MailHasWords != null)
{
message = HasWords(message, context, query.MailHasWords);
}
if (query.MailDoesntHave != null)
{
if (query.MailFrom == null && query.MailTo == null && query.MailTitle == null && query.MailHasWords == null)
{
message = context.Messages.ToList();
message = DoesntHave(message, context, query.MailDoesntHave);
}
else
{
message = DoesntHave(message, context, query.MailDoesntHave);
}
}
return(Encoding(message));
}
public MessagesController(MaildbContext context, IMessageControl msgCntrl, IAdvancedSearch advSearch, IPagingInfo pageInfo)
{
_context = context;
_msgCntrl = msgCntrl;
_advSearch = advSearch;
_pageInfo = pageInfo;
}
private List <Message> ShowAllMessages(MaildbContext context)
{
List <Message> messages = new List <Message>();
messages = context.Messages.ToList();
return(Encoding(messages));
}
public void DeleteFriend(string friendName)
{
using (var _context = new MaildbContext())
{
var friend = _context.ChatFriends.Single(c => c.Friend == friendName || c.FriendUserName == friendName);
_context.ChatFriends.Remove(friend);
_context.SaveChanges();
Clients.Caller.friendsToList(CreateFriendsList(Context.User.Identity.Name, _context));
}
}
private List <Message> HasWords(List <Message> messages, MaildbContext context, string MailHasWords)
{
string[] hasWords = MailHasWords.Split(' ');
foreach (var word in hasWords)
{
messages.AddRange(context.Messages.Where(c => c.MailContent.Contains(word) || c.MailTitle.Contains(word)));
}
return(messages);
}
public void Delete(MaildbContext _context, string[] rows)
{
if (rows != null)
{
foreach (var row in rows)
{
int id = Decode(row);
var delRow = _context.Messages.First(c => c.ID == id);
_context.Messages.Remove(delRow);
}
_context.SaveChanges();
}
}
private List <Message> DoesntHave(List <Message> messages, MaildbContext context, string MailDoesntHave)
{
string[] doesntHave = MailDoesntHave.Split(' ');
foreach (var word in doesntHave)
{
Message toRemove = messages.First(c => c.MailContent.Contains(word) || c.MailTitle.Contains(word));
if (toRemove != null)
{
messages.Remove(toRemove);
}
}
return(messages);
}
public List <Message> FindMessages(AdvancedSearchQuery query, MaildbContext context)
{
query = SetQueryNull(query);
List <Message> _messages = null;
if (query != null)
{
_messages = ShowSpecificMessages(context, query);
}
else
{
_messages = ShowAllMessages(context);
}
return(_messages.OrderByDescending(m => m.MailDate).Distinct().ToList());
}
private IEnumerable <ChatFriend> CreateFriendsList(string userName, MaildbContext _context)
{
List <ChatFriend> ChatFriends = new List <ChatFriend>();
ChatFriends = _context.ChatFriends.Include(c => c.ApplicationUser).Where(c => c.ApplicationUser.Email == userName || c.ApplicationUser.UserName == userName).ToList();
foreach (var friend in ChatFriends)
{
foreach (var user in ConnectedUsers)
{
if (user.UserName == friend.Friend)
{
friend.ConnectionID = user.ConnectionId;
}
}
}
return(ChatFriends.OrderBy(c => c.FriendUserName));
}
public void AddFriend(string friendName)
{
ChatFriend chtFr = new ChatFriend();
var me = Context.User.Identity.Name;
ApplicationUser friend = new ApplicationUser();
using (var _context = new MaildbContext())
{
var appUser = _context.Users.First(c => c.Email == me || c.UserName == me);
friend = _context.Users.First(c => c.Email == friendName || c.UserName == friendName);
chtFr.ApplicationUser = appUser;
chtFr.Friend = friend.Email;
chtFr.FriendUserName = friend.UserName;
_context.ChatFriends.Add(chtFr);
_context.SaveChanges();
Clients.Caller.friendsToList(CreateFriendsList(me, _context));
}
}
public void Connect(string userName)
{
string id = Context.ConnectionId;
using (var _context = new MaildbContext())
{
string userEmail = _context.Users.Single(c => c.UserName == userName).Email;
if (ConnectedUsers.Count(x => x.ConnectionId == id) == 0)
{
ConnectedUsers.Add(new UserDetails {
ConnectionId = id, UserName = userName, UserEmail = userEmail
});
Clients.Caller.onConnected(id, userName, ConnectedUsers, CreateFriendsList(userName, _context));
Clients.AllExcept(id).onNewUserConnected(id, userName, userEmail);
}
}
}
public HomeControllerTest(MaildbContext context)
{
_context = context;
}
public List <Message> GetAllSentMessages(MaildbContext _context, ApplicationUser appUser)
{
return(_context.Messages.Where(c => c.MailFrom == appUser.Email).OrderByDescending(c => c.MailDate).ToList());
//return rtnMsg();
}
public ApplicationUserStore(MaildbContext context)
: base(context)
{
}
public List <Message> GetAllMessages(MaildbContext _context, ApplicationUser appUser)
{
return(_context.Messages.ToList());
//return rtnMsg();
}
public static List <Message> Receive(MaildbContext _context)
{
return(_context.Messages.Where(c => c.MailTo == "*****@*****.**").ToList());
}