public List <MessageDal> GetAll()
{
List <MessageDal> la = new List <MessageDal>();
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "select * from VueMessageAlert";
con.Open();
using (SqlDataReader read = command.ExecuteReader())
{
while (read.Read())
{
MessageDal a = new MessageDal();
a.messageAlertId = (int)read["messageAlertId"];
a.messageContenu = (string)read["messageContenu"];
a.messageDateDebut = (DateTime)read["messageDateDebut"];
a.messageDateFin = (DateTime)read["messageDateFin"];
//a.clientPwd = (string)read["biereImage"];
//a.brasserieId = (int)read["brasserieId"];
a.nomBrasserie = (string)read["nomBrasserie"];
la.Add(a);
}
}
}
}
return(la);
}
public ActionResult deleteMsg(Int32 id)
{
List <Message> msg = new List <Message>();
MessageDal mdal = new MessageDal();
try
{
msg =
(from x in mdal.Messages
where x.id == id
select x).ToList <Message>();
}
catch
{
User Eusr = new User((User)TempData["mdl"]);
return(View("Error", new User(Eusr)));
}
Message ms = msg[0];
mdal.Messages.Remove(ms);
mdal.SaveChanges();
User usr = new User((User)TempData["mdl"]);
return(RedirectToAction("InboxPage", usr));
}
public MessageDal GetOne(int id)
{
MessageDal b = new MessageDal();
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "Select * from MessageAlert where messageAlertId=@id";
command.Parameters.AddWithValue("id", id);
con.Open();
using (SqlDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
b.messageAlertId = (int)dataReader["messageAlertId"];
b.brasserieId = (int?)dataReader["brasserieId"];
b.messageDateDebut = (DateTime)dataReader["messageDateDebut"];
b.messageDateFin = (DateTime)dataReader["messageDateFin"];
b.messageContenu = (string)dataReader["messageContenu"];
}
}
}
}
return(b);
}
/// <summary>
/// 获取站内信数量
/// </summary>
/// <param name="user_id"></param>
/// <param name="year"></param>
/// <param name="month"></param>
/// <param name="day"></param>
/// <returns></returns>
public int GetSenderMessageCount(string user_id, DateTime start, DateTime end)
{
var pdal = new MessageDal();
return(pdal.GetCount(x => x.SenderUserID == user_id &&
x.UpdateTime >= start && x.UpdateTime < end));
}
public List <MessageDal> GetAll()
{
List <MessageDal> lb = new List <MessageDal>();
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "Select * from MessageAlert";
con.Open();
using (SqlDataReader dataReader = command.ExecuteReader())
{
while (dataReader.Read())
{
MessageDal b = new MessageDal();
b.messageAlertId = (int)dataReader["messageAlertId"];
b.brasserieId = (int?)dataReader["brasserieId"];
b.messageDateDebut = (DateTime)dataReader["messageDateDebut"];
b.messageDateFin = (DateTime)dataReader["messageDateFin"];
b.messageContenu = (string)dataReader["messageContenu"];
lb.Add(b);
}
}
}
}
return(lb);
}
/// <summary>
/// 获取最新的站内信
/// </summary>
/// <param name="receiverID"></param>
/// <param name="count"></param>
/// <returns></returns>
public List <MessageModel> GetTopMessage(string receiverID, int count = 100)
{
var mdal = new MessageDal();
var list = mdal.QueryList(where : x => x.ReceiverUserID == receiverID,
orderby: x => x.UpdateTime, Desc: true, start: 0, count: count);
return(list);
}
/// <summary>
/// 获取站内信数量
/// </summary>
/// <param name="user_id"></param>
/// <param name="year"></param>
/// <param name="month"></param>
/// <param name="day"></param>
/// <returns></returns>
public int GetSenderMessageCount(int user_id, DateTime start, DateTime end)
{
string key = Com.GetCacheKey("messagecount", user_id.ToString(), start.ToString(), end.ToString());
return(Cache(key, () =>
{
var pdal = new MessageDal();
return pdal.GetCount(x => x.SenderUserID == user_id &&
x.UpdateTime >= start && x.UpdateTime < end);
}));
}
public static MessageDal GetMessageDal(this MessageWPF wpf)
{
MessageDal dal = new MessageDal();
dal.brasserieId = wpf.brasserieId;
dal.messageAlertId = wpf.messageAlertId;
dal.messageContenu = wpf.messageContenu;
dal.messageDateDebut = wpf.messageDateDebut;
dal.messageDateFin = wpf.messageDateFin;
return(dal);
}
public static MessageWPF GetMessageWPF(this MessageDal dal)
{
MessageWPF wpf = new MessageWPF();
wpf.brasserieId = dal.brasserieId;
wpf.messageAlertId = dal.messageAlertId;
wpf.messageContenu = dal.messageContenu;
wpf.messageDateDebut = dal.messageDateDebut;
wpf.messageDateFin = dal.messageDateFin;
return(wpf);
}
public static MessageDal GetMessageDal(this MessageAPI messageAPI)
{
MessageDal messageDal = new MessageDal();
messageDal.messageAlertId = messageAPI.messageAlertId;
messageDal.messageContenu = messageAPI.messageContenu;
messageDal.messageDateDebut = messageAPI.messageDateDebut;
messageDal.messageDateFin = messageAPI.messageDateFin;
messageDal.nomBrasserie = messageAPI.nomBrasserie;
return(messageDal);
}
public UserService(IOptions <AppSettings> appSettings, IIdentity userIdentity)
{
_appSettings = appSettings.Value;
playerDal = new PlayerDal();
if (userIdentity != null)
{
messageDal = new MessageDal(int.Parse(userIdentity.Name));
myPlayer = playerDal.Get(new Player {
Id = int.Parse(userIdentity.Name)
}).GetObject();
}
}
/// <summary>
/// 发送消息
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public string SendMessage(MessageModel model)
{
string err = CheckModel(model);
if (ValidateHelper.IsPlumpString(err))
{
return(err);
}
var dal = new MessageDal();
return(dal.Add(model) > 0 ? SUCCESS : "发送失败");
}
/// <summary>
/// 获取最新的站内信
/// </summary>
/// <param name="receiverID"></param>
/// <param name="count"></param>
/// <returns></returns>
public List <MessageModel> GetTopMessage(int receiverID, int count = 100)
{
string key = "topmessage,uid:" + receiverID + "count:" + count;
return(Cache(key, () =>
{
var mdal = new MessageDal();
var list = mdal.QueryList(where : x => x.ReceiverUserID == receiverID,
orderby: x => x.UpdateTime, Desc: true, start: 0, count: count);
return list;
}));
}
/// <summary>
/// Schleust die zu erstellende Nachricht zur Dal durch mit einer Sqltransaction
/// </summary>
/// <param name="message">
/// zu erstellende Nachricht
/// </param>
public static void CreateMessage(Message message)
{
// Öffnen der Sql-Server-Verbindung
using (SqlTransaction transaction = ConnectionManager.GetOpenConnection().BeginTransaction())
{
//Zugriffssicht auf díe Datenbank deklarieren und instanzieren
MessageDal msgDal = new MessageDal();
//Aufruf der Nachrichterstellenmethode
msgDal.CreateMessage(message, transaction);
//Transaktion speichern
transaction.Commit();
}
}
/// <summary>
/// Setzt die Nachrichten auf gelesen
/// </summary>
/// <param name="messageId">
/// Nachrichten-id
/// </param>
public static void MessageReaded(int?messageId)
{
//Öffnen der Sql-Server-Verbindung
using (SqlTransaction transaction = ConnectionManager.GetOpenConnection().BeginTransaction())
{
//Zugriffssicht auf díe Datenbank deklarieren und instanzieren
MessageDal msgDal = new MessageDal();
//Aufruf der Nachrichtgelesenmethode
msgDal.MessageReaded(messageId, transaction);
//Transaktion speichern
transaction.Commit();
}
}
/// <summary>
/// Holt die Nachrichten aus der Dal
/// </summary>
/// <param name="userId">
/// id des angemledeten Benutzers
/// </param>
/// <returns>
/// Gibt eine Nachrichtenliste wieder
/// </returns>
public static List <Message> ReadMessage(Guid userId)
{
//Öffnen der Sql-Server-Verbindung
using (SqlTransaction transaction = ConnectionManager.GetOpenConnection().BeginTransaction())
{
//Zugriffssicht auf díe Datenbank deklarieren und instanzieren
MessageDal msgDal = new MessageDal();
//Aufruf der Nachrichtenlesenmethode
List <Message> messageList = msgDal.ReadMessage(userId, transaction);
//Zurückgeben der Nachrichtenliste
return(messageList);
}
}
public ActionResult ReciverMessages()
{
if (!Authorize())
{
return(RedirectToAction("RedirectByUser", "Home"));
}
VMMessages msgs = new VMMessages();
MessageDal msDal = new MessageDal();
User curr = (User)Session["CurrentUser"];
msgs.Messages = (from msg in msDal.messages
where msg.Receiver == curr.UserName
select msg).ToList <Message>();
return(View(msgs));
}
public void Update(MessageDal parametre)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "EditMessageAlert";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue(nameof(parametre.messageAlertId), parametre.messageAlertId);
command.Parameters.AddWithValue(nameof(parametre.messageContenu), parametre.messageContenu);
command.Parameters.AddWithValue(nameof(parametre.messageDateDebut), parametre.messageDateDebut);
command.Parameters.AddWithValue(nameof(parametre.messageDateFin), parametre.messageDateFin);
con.Open();
command.ExecuteNonQuery();
}
}
}
public ActionResult UnionPage(User usr)
{
List <Message> msg = new List <Message>();
MessageDal mdal = new MessageDal();
try
{
msg =
(from x in mdal.Messages
where x.reciverName == usr.UserName && x.senderName == "Union system"
select x).ToList <Message>();
}
catch
{
return(View("Error", new User(usr)));
}
ViewBag.MsgDB = msg;
TempData["inboxFlag"] = 3;
return(View("InboxPage", new User(usr)));
}
// GET: Communication
public ActionResult InboxPage(User usr)
{
List <Message> msg = new List <Message>();
try
{
MessageDal mdal = new MessageDal();
msg =
(from x in mdal.Messages
where (x.reciverName == usr.UserName) && (x.subject != "Alert") && (x.senderName != "Union system") && (x.senderName != "Follow system")
select x).ToList <Message>();
}
catch
{
return(View("Error", new User(usr)));
}
ViewBag.MsgDB = msg;
TempData["inboxFlag"] = 0;
return(View(new User(usr)));
}
public ActionResult viewMsg(Int32 id)
{
List <Message> msg = new List <Message>();
try
{
MessageDal mdal = new MessageDal();
msg =
(from x in mdal.Messages
where x.id == id
select x).ToList <Message>();
}
catch
{
User Eusr = new User((User)TempData["mdl"]);
return(RedirectToAction("InboxPage", Eusr));
}
TempData["mid"] = new Message(msg[0]);
User usr = new User((User)TempData["mdl"]);
return(View(usr));
}
public ActionResult SendMessage(Message msg)
{
if (!Authorize())
{
return(RedirectToAction("RedirectByUser", "Home"));
}
User CurrentUser = (User)Session["CurrentUser"];
UserDal usDal = new UserDal();
if (usDal.Users.FirstOrDefault <User>(x => x.UserName == msg.Receiver) == null)
{
TempData["notUser"] = "******";
return(RedirectToAction("NewMessage"));
}
MessageDal msDal = new MessageDal();
msg.Sender = CurrentUser.UserName;
msg.DateAndTime = DateTime.Now;
msDal.messages.Add(msg);
msDal.SaveChanges();
TempData["OK"] = "הודעה נשלחה למשתמש";
return(RedirectToAction("NewMessage"));
}
public int Create(MessageDal parametre)
{
using (SqlConnection con = new SqlConnection())
{
con.ConnectionString = connectionString;
using (SqlCommand command = con.CreateCommand())
{
command.CommandText = "AddMessageAlertBis";
SqlParameter pid = new SqlParameter();
pid.ParameterName = "ID";
pid.Value = 0;
pid.Direction = System.Data.ParameterDirection.Output;
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.AddWithValue(nameof(parametre.messageContenu), parametre.messageContenu);
command.Parameters.AddWithValue(nameof(parametre.messageDateDebut), parametre.messageDateDebut);
command.Parameters.AddWithValue(nameof(parametre.messageDateFin), parametre.messageDateFin);
command.Parameters.Add(pid);
con.Open();
command.ExecuteNonQuery();
int id = (int)command.Parameters["ID"].Value;
return(id);
}
}
}
public MessageController()
{
message_dal = new MessageDal();
}
private void saveBrodMsg(User usr, int level, int brodId, string rec, string subj, string msgC)
{
List <int> idList = new List <int>();
switch (level)
{
case 0:
/*
* SyearDal sdal = new SyearDal();
* List<Syear> syears =
* (from x in sdal.Syears
* where brodId == x.SyearId
* select x).ToList<Syear>();
* if (syears.Any())
* {
* UserDal dal = new UserDal();
* List<User> users =
* (from x in dal.Users
* where x.year == )
* }*///continue after connecting user to yr
break;
case 1:
break;
case 2:
try
{
InstitutionDal idal = new InstitutionDal();
List <Institution> institutions =
(from x in idal.Institutions
where brodId == x.InstitutionId
select x).ToList <Institution>();
if (institutions.Any())
{
Institution insti = institutions[0];
UserDal dal = new UserDal();
List <User> users =
(from y in dal.Users
where y.institution.ToLower() == insti.InstName.ToLower()
select y).ToList <User>();
foreach (User x in users)
{
idList.Add(x.id);
}
}
}
catch
{
break;
}
break;
}
if (idList.Any())
{
MessageDal mdal = new MessageDal();
foreach (int id in idList)
{
List <User> user = new List <User>();
try
{
UserDal dal = new UserDal();
user =
(from x in dal.Users
where x.id == id
select x).ToList <User>();
}
catch
{
}
if (user.Any())
{
Message ms = new Message()
{
date = DateTime.Now,
senderName = usr.UserName,
reciverName = user[0].UserName,
mag = msgC,
subject = subj
};
mdal.Messages.Add(ms);
mdal.SaveChanges();
}
}
}
}
public ActionResult saveMsg(User usr)
{
string rec;
string subj;
string msgC;
try
{
rec = Request.Form["to"];
subj = Request.Form["subject"];
msgC = Request.Form["msgContent"];
}
catch
{
return(View("Error", new User(usr)));
}
int inst, dep, yr;
try
{
inst = Int32.Parse(Request.Form["inst"]);
}
catch
{
inst = -1;
}
try
{
dep = Int32.Parse(Request.Form["dep"]);
}
catch
{
dep = -1;
}
try
{
yr = Int32.Parse(Request.Form["yr"]);
}
catch
{
yr = -1;
}
if (yr + dep + inst > -3)
{
if (usr.rank == 0)
{
if (yr != -1)
{
saveBrodMsg(new User(usr), 0, yr, rec, subj, msgC);
}
else if (dep != -1)
{
saveBrodMsg(new User(usr), 1, dep, rec, subj, msgC);
}
else if (inst != -1)
{
saveBrodMsg(new User(usr), 2, inst, rec, subj, msgC);
}
return(RedirectToAction("InboxPage", new User(usr)));
}
if (usr.rank == 1)
{
List <ManageConnection> manageConnections = new List <ManageConnection>();
if (yr != -1)
{
try
{
ManageConnectionDal mcdal = new ManageConnectionDal();
manageConnections =
(from x in mcdal.ManageConnections
where x.managerId == usr.id && x.sYear == yr
select x).ToList <ManageConnection>();
}
catch
{
}
if (manageConnections.Any())
{
saveBrodMsg(new User(usr), 0, yr, rec, subj, msgC);
}
}
else if (dep != -1)
{
try
{
ManageConnectionDal mcdal = new ManageConnectionDal();
manageConnections =
(from x in mcdal.ManageConnections
where x.managerId == usr.id && x.department == dep
select x).ToList <ManageConnection>();
}
catch
{
}
if (manageConnections.Any())
{
saveBrodMsg(new User(usr), 1, dep, rec, subj, msgC);
}
}
else if (inst != -1)
{
try
{
ManageConnectionDal mcdal = new ManageConnectionDal();
manageConnections =
(from x in mcdal.ManageConnections
where x.managerId == usr.id && x.institution == inst
select x).ToList <ManageConnection>();
}
catch
{
}
if (manageConnections.Any())
{
saveBrodMsg(new User(usr), 2, inst, rec, subj, msgC);
}
}
return(RedirectToAction("InboxPage", new User(usr)));
}
}
MessageDal mdal = new MessageDal();
Message ms = new Message()
{
date = DateTime.Now,
senderName = usr.UserName,
reciverName = rec,
mag = msgC,
subject = subj
};
List <User> user = new List <User>();
try
{
UserDal dal = new UserDal();
user =
(from x in dal.Users
where x.UserName == usr.UserName
select x).ToList <User>();
}
catch
{
}
if (user.Any())
{
mdal.Messages.Add(ms);
mdal.SaveChanges();
}
return(RedirectToAction("InboxPage", new User(usr)));
}
