public string AddMsgbyRole(string roleID, string title, string message, string url)
{
string ret = "false";
try
{
var qryU = db.UserData.Where(x => x.RoleID == roleID);
foreach (UserData u in qryU)
{
if(u.EndDate.CompareTo(DateTime.Now) > 0){
var qryD = db.UserDevice.Where(x => x.UserID == u.UserID);
foreach (UserDevice d in qryD)
{
//int mID = db.MessageBox.AsEnumerable().Select(x => x.MessageID).DefaultIfEmpty(0).Max(x => x) + 1;
MessageBox messageBox = new MessageBox();
//messageBox.MessageID = mID;
messageBox.DeviceID = d.DeviceID;
messageBox.Title = title;
messageBox.MessageConten =u.UserName + message;
messageBox.URL = url;
messageBox.WriteDT = DateTime.Now;
db.MessageBox.Add(messageBox);
//db.SaveChanges();
}
}
}
db.SaveChanges();
ret = "true";
}
catch
{
}
return ret;
}
public string AddMsgbyUser(string userID, string title, string message, string url)
{
string ret = "false";
try
{
var qryD = db.UserDevice.Where(x => x.UserID == userID);
foreach (UserDevice d in qryD)
{
MessageBox messageBox = new MessageBox();
messageBox.DeviceID = d.DeviceID;
messageBox.Title = title;
messageBox.MessageConten = message;
messageBox.URL = url;
messageBox.WriteDT = DateTime.Now;
db.MessageBox.Add(messageBox);
}
db.SaveChanges();
ret = "true";
}
catch
{
}
return ret;
}
