public COMMANDE GetCommande(Guid?id)
{
redactapplicationEntities db = new Models.redactapplicationEntities();
COMMANDE commande = db.COMMANDEs.SingleOrDefault(x => x.commandeId == id);
return(commande);
}
public IEnumerable <NOTIFICATIONViewModel> GetAllMessages(Guid?redactId)
{
var messages = new List <NOTIFICATIONViewModel>();
using (var connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString))
{
connection.Open();
using (var command = new SqlCommand(@"SELECT * FROM [dbo].[NOTIFICATION] where toId ='" + redactId + "' and statut = 1", connection))
{
command.Notification = null;
var dependency = new SqlDependency(command);
dependency.OnChange += new OnChangeEventHandler(dependency_OnChange);
if (connection.State == ConnectionState.Closed)
{
connection.Open();
}
var reader = command.ExecuteReader();
while (reader.Read())
{
UTILISATEUR fromUser = GetUtilisateur((Guid)reader["fromId"]);
UTILISATEUR toUser = GetUtilisateur((Guid)reader["toId"]);
COMMANDE commande = (!string.IsNullOrEmpty(reader["commandeId"].ToString()))? GetCommande((Guid)reader["commandeId"]) : new COMMANDE();
if ((bool)reader["statut"])
{
messages.Add(item: new NOTIFICATIONViewModel()
{
notificationId = (Guid)reader["notificationId"],
commandeId = (Guid)reader["commandeId"],
commanderef = (int)commande.commandeREF,
statut = (bool)reader["statut"],
fromId = (Guid)reader["fromId"],
fromUserName = fromUser.userNom,
toId = (Guid)reader["toId"],
message = reader["message"].ToString(),
datenotif = Convert.ToDateTime(reader["datenotif"])
});
}
}
}
}
return(messages.OrderByDescending(x => x.datenotif).Take(6));
}