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