public void Send(string message) { Chats chat = new Chats(); chat.Chat = message; chat.UserName = Context.User.Identity.Name.ToString(); chat.DateAdded = DateTime.Now; ChatDBContext db = new ChatDBContext(); chat.addToDB(db); Clients.All.addNewMessageToPage(chat.UserName, message); }
public static List<Chats> getShiftChats(ChatDBContext db, DateTime dateNow) { string query = "SELECT * FROM Chats WHERE datepart(hh, DateAdded)"; if (dateNow.Hour >= 0 && dateNow.Hour <= 7) { query += "BETWEEN 0 AND 7"; } else if (dateNow.Hour >= 8 && dateNow.Hour <= 15) { query += "BETWEEN 8 AND 15"; } else if (dateNow.Hour >= 16 && dateNow.Hour <= 24) { query += "BETWEEN 16 AND 24"; } var sqlResults = db.Chats.SqlQuery(query); return sqlResults.ToList(); }
public void addToDB(ChatDBContext db) { db.Chats.Add(this); db.SaveChanges(); }