public JsonResult Delete()
{
int id = Convert.ToInt32(Request.Params["id"]);
MessageDAL.Delete(id);
JsonResult jr = new JsonResult();
jr.Data = MessageDAL.GetMessages();
return(jr);
}
public void InitMessagesFromBuliding(ObservableCollection <MessageToCompanyModel> messagesToCompanyToWindow)
{
MessageDAL messageDAL = new MessageDAL();
List <MessageToCompanyModel> messages = messageDAL.GetMessagesFromBuilding();
foreach (var item in messages)
{
messagesToCompanyToWindow.Add(item);
}
}
public void AddNewMessage(MessageFromCompanyModel messageModel)
{
try
{
MessageDAL.AddNewMessage(messageModel);
}
catch (Exception e)
{
}
}
public void InitMessagesFromCompanyList(ObservableCollection <MessageFromCompanyModel> messagesFormCompanyToWindow)
{
MessageDAL messageDAL = new MessageDAL();
List <MessageFromCompanyModel> messages = messageDAL.GetMessagesFromCompanies();
foreach (var item in messages)
{
messagesFormCompanyToWindow.Add(item);
}
}
public static MessageInfo GetMessage(int id)
{
var m = MessageDAL.GetMessage(id);
if (m.IsRead == false)
{
m.IsRead = true;
MessageDAL.UpdateMessage(m);
}
return(createMessageInfo(m));
}
public void AddNewMessageToBuliding(MessageFromCompanyModel messageModel)
{
try
{
MessageDAL messageDAL = new MessageDAL();
messageDAL.AddNewMessage(messageModel);
}
catch (Exception e)
{
}
}
// Mappa un oggetto di tipo MessageDAL (Infrastructure.logging.dal) su un oggetto Message(Infrastructure.logging.datamodel.model)
public Message messageDALtoMessage(MessageDAL messageDAL)
{
Message messageToBack = new Message();
messageToBack.id = messageDAL.MessageId;
messageToBack.messaggio = messageDAL.message;
messageToBack.sorgente = messageDAL.source;
messageToBack.exception = messageDAL.exception;
messageToBack.tipo = categoryDALtoCategory(messageDAL.categoryDAL);
return messageToBack;
}
public void AddNewMessage(MessageFromCompanyModel messageModel)
{
try
{
MessageDAL messageDAL = new MessageDAL();
messageDAL.AddNewMessage(messageModel);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
}
public IHttpActionResult NewMessage([FromBody] Message message)
{
var result = new BaseResult();
result.ResultCode = "1";
result.ResultMessage = "Error";
if (message.MessageContent == null)
{
result.ResultMessage = "消息内容不能为空";
return(Ok(result));
}
Data.Model.Message newMessage = new Data.Model.Message();
newMessage.Id = Guid.NewGuid();
newMessage.CreateTime = DateTime.Now;
newMessage.Status = 1;
newMessage.Text = message.MessageContent;
newMessage.FromWho = message.FromWho;
newMessage.ToWho = message.ToWho;
newMessage.MessageBatch = message.FromWho + "-" + DateTime.Now.ToString("yyyyMMddHHmmss");
if (message.Picture != null && message.Picture.Length > 0)
{
CommonPicture pic = new CommonPicture();
pic.Id = Guid.NewGuid();
pic.CreateTime = DateTime.Now;
pic.FileData = message.Picture;
pic.Status = 1;
pic.UserId = message.FromWho;
new CommonPictureDAL().Insert(pic);
newMessage.PicId = pic.Id;
}
var re = new MessageDAL().Insert(newMessage);
if (re)
{
result.ResultCode = "0";
result.ResultMessage = "Success";
result.ResultData = new
{
Batch = newMessage.MessageBatch,
FromWho = new CommonUserDAL().GetSingleById(newMessage.FromWho.Value).NickName,
ToWho = new CommonUserDAL().GetSingleById(newMessage.ToWho.Value).NickName,
CreateTime = newMessage.CreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss"),
Text = newMessage.Text,
FromId = newMessage.FromWho,
ToId = newMessage.ToWho
};
}
else
{
result.ResultMessage = "发送消息失败";
}
return(Ok(result));
}
public List <MessageToCompanyModel> GetMessagesFromBuildingToCompany(int CompanyId)
{
List <MessageToCompanyModel> result = new List <MessageToCompanyModel>();
try
{
result = MessageDAL.GetMessagesFromBuildingToCompany(CompanyId);
}
catch (Exception e)
{
}
return(result);
}
// Mappa un oggetto di tipo Message(Infrastructure.logging.datamodel.model) su un oggetto MessageDAL (Infrastructure.logging.dal)
public MessageDAL messagetoMessageDAL(Message message)
{
MessageDAL messageDAL = new MessageDAL();
messageDAL.MessageId = message.id;
messageDAL.message = message.messaggio;
messageDAL.source = message.sorgente;
// la data di un nuovo messaggio di log è sempre settata al tempo corrente.
messageDAL.timestamp = DateTime.Now;
messageDAL.exception = message.exception;
messageDAL.CategoryId = categoryToCategoryDAL(message.tipo).CategoryId;
return messageDAL;
}
public MessageFromCompanyModel GetMessage(int MessageId, int CompanyId)
{
MessageFromCompanyModel result = new MessageFromCompanyModel();
try
{
MessageDAL messageDAL = new MessageDAL();
result = messageDAL.GetMessageFromCompanyById(MessageId, CompanyId);
}
catch (Exception e)
{
}
return(result);
}
public List <MessageFromCompanyModel> GetCompanyMessages(int Id)
{
List <MessageFromCompanyModel> result = new List <MessageFromCompanyModel>();
try
{
MessageDAL messaged = new MessageDAL();
result = messaged.GetMessagesByCompany(Id);
}
catch (Exception e)
{
}
return(result);
}
public IHttpActionResult GetMessage([FromUri] string batch)
{
var result = new BaseResult();
result.ResultCode = "1";
result.ResultMessage = "Error";
var list = new MessageDAL().GetListByBatch(batch);
if (list.Any())
{
result.ResultCode = "1";
result.ResultMessage = "Success";
result.ResultData = list;
}
return Ok(result);
}
public JsonResult Update()
{
Message message = new Message();
message.id = Convert.ToInt32(Request.Params["id"]);
message.MessageTitle = Request.Params["nickName"];
message.MessageContent = Request.Params["messageContent"];
message.PostTime = DateTime.Now;
MessageDAL.Update(message);
JsonResult jr = new JsonResult();
jr.Data = MessageDAL.GetMessages();
return(jr);
}
public MessageToCompanyModel GetMessageFromBuliding(int MessageId)
{
MessageToCompanyModel result = new MessageToCompanyModel();
try
{
MessageDAL messageDAL = new MessageDAL();
result = messageDAL.GetMessageFromBuilding(MessageId);
}
catch (Exception e)
{
throw new Exception(e.Message);
}
return(result);
}
public static void SendMessage(string Title, string Body, string Sender, string Recipient, string Status, string Attachment, DateTime SentOn)
{
if (Recipient.Length >= 1)
{
int messageID = MessageDAL.InsertMessage(Title, Body, Sender, Recipient, Status, Attachment, SentOn);
string[] users = Recipient.Split(new char[] { ';' });
foreach (string user in users)
{
string recep = user.Trim();
if (recep != "")
{
MessageDAL.InsertReceivedMessage(Title, Body, Sender, Recipient, Status, Attachment, SentOn, recep);
}
}
}
}
public void AddNewMessageTest()
{
MessageFromCompanyModel model = new MessageFromCompanyModel();
model.Subject = "TestMessage";
model.Text = "TestValue";
CompanyDAL companyDAL = new CompanyDAL();
model.CompanyId = companyDAL.GetCompanies().Select(x => x.Id).Min();
MessageDAL messageDAL = new MessageDAL();
messageDAL.AddNewMessage(model);
MessageFromCompanyModel testmodel = messageDAL.GetMessagesByCompany(model.CompanyId).Where(x => x.Subject == "TestMessage" && x.Text == "TestValue").FirstOrDefault();
Assert.That(testmodel != null, Is.True);
}
public IHttpActionResult GetMessage([FromUri] string batch)
{
var result = new BaseResult();
result.ResultCode = "1";
result.ResultMessage = "Error";
var list = new MessageDAL().GetListByBatch(batch);
if (list.Any())
{
result.ResultCode = "1";
result.ResultMessage = "Success";
result.ResultData = list;
}
return(Ok(result));
}
public void AddNewMessagesSubjectTest()
{
CompanyDAL companyDAL = new CompanyDAL();
List <CompanyModel> companies = companyDAL.GetCompanies();
MessagesFromBulidingModel model = new MessagesFromBulidingModel();
model.Subject = "testSubject";
model.Text = "testText";
model.Companies = companies;
MessageDAL messageDAL = new MessageDAL();
messageDAL.AddNewMessages(model);
List <MessageToCompanyModel> messages = messageDAL.GetMessagesFromBuilding();
Assert.That(messages.Where(x => x.Subject == "testSubject").Any(), Is.True);
}
public ActionResult MessagePassing(int?Id, int?page)
{
int pageSize = 5;
int pageNumber = (page ?? 1);
MessageReplyViewModel vm = new MessageReplyViewModel();
ReplyDAL replyDAL = new ReplyDAL();
MessageDAL queDAL = new MessageDAL();
var count = queDAL.MessagesDal.Count();
decimal totalPages = count / (decimal)pageSize;
ViewBag.TotalPages = Math.Ceiling(totalPages);
vm.Messages = queDAL.MessagesDal
.OrderBy(x => x.DatePosted).ToPagedList(pageNumber, pageSize);
ViewBag.MessagesInOnePage = vm.Messages;
ViewBag.PageNumber = pageNumber;
if (Id != null)
{
var replies = replyDAL.Replies.Where(x => x.MessageId == Id.Value).OrderByDescending(x => x.ReplyDateTime);
if (replies != null)
{
foreach (var rep in replies)
{
/* MessageReplyViewModel.MessageReply reply = new MessageReplyViewModel.MessageReply();*/
MessageReplyViewModel.MessageReply reply = new MessageReplyViewModel.MessageReply();
reply.MessageId = rep.MessageId;
reply.Id = rep.Id;
reply.ReplyMessage = rep.ReplyMessage;
reply.ReplyDateTime = rep.ReplyDateTime;
reply.MessageDetails = vm.Messages.Where(x => x.Id == rep.MessageId).Select(s => s.MessageToPost).FirstOrDefault();
reply.ReplyFrom = rep.ReplyFrom;
vm.Replies.Add(reply);
}
}
else
{
vm.Replies.Add(null);
}
ViewBag.MessageId = Id.Value;
}
return(View(vm));
}
//[Filter.LoginFilter]
public JsonResult Add()
{
JsonResult jr = new JsonResult();
if (string.IsNullOrEmpty(Request.Params["nickName"]) || string.IsNullOrEmpty(Request.Params["messageContent"]))
{
jr.Data = MessageDAL.GetMessages();
//jr.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(jr);
}
Message message = new Message();
message.MessageTitle = Request.Params["nickName"];
message.MessageContent = Request.Params["messageContent"];
message.PostTime = DateTime.Now;
MessageDAL.Add(message);
jr.Data = MessageDAL.GetMessages();
//jr.JsonRequestBehavior = JsonRequestBehavior.AllowGet;
return(jr);
}
public IHttpActionResult GetMessage([FromUri] Guid UserId)
{
var result = new BaseResult();
result.ResultCode = "1";
result.ResultMessage = "Error";
var list = new MessageDAL().GetListByUserId(UserId).OrderBy(a => a.CreateTime).ThenBy(a => a.MessageBatch);
if (list.Any())
{
result.ResultCode = "0";
result.ResultMessage = "Success";
result.ResultData = list.Select(a => new
{
Batch = a.MessageBatch,
FromWho = new CommonUserDAL().GetSingleById(a.FromWho.Value).NickName,
ToWho = new CommonUserDAL().GetSingleById(a.ToWho.Value).NickName,
CreateTime = a.CreateTime.Value.ToString("yyyy-MM-dd"),
Text = a.Text
});
}
return Ok(result);
}
public ActionResult DeleteMessage(int?Id)
{
int?num;
num = Id;
if (Session["AdminLoggedIn"] != null)
{
MessageDAL msgDAL = new MessageDAL();
ReplyDAL rplDAL = new ReplyDAL();
try {
List <Message> msg = (from x in msgDAL.MessagesDal where x.Id == num select x).ToList <Message>();
Message msgToDelete = msg[0];
msgDAL.MessagesDal.Attach(msgToDelete);
msgDAL.MessagesDal.Remove(msgToDelete);
msgDAL.SaveChanges();
List <Reply> rpl = (from x in rplDAL.Replies where x.MessageId == num select x).ToList <Reply>();
foreach (var rplToDelete in rpl)
{
rplDAL.Replies.Attach(rplToDelete);
rplDAL.Replies.Remove(rplToDelete);
rplDAL.SaveChanges();
}
}catch (Exception e) { }
}
else
{
TempData["WarningMessage"] = "Only Admin can delete posts.";
return(RedirectToAction("MessagePassing", "Forum"));
}
return(RedirectToAction("MessagePassing", "Forum"));
}
public IHttpActionResult GetMessage([FromUri] Guid UserId)
{
var result = new BaseResult();
result.ResultCode = "1";
result.ResultMessage = "Error";
var list = new MessageDAL().GetListByUserId(UserId).OrderBy(a => a.CreateTime).ThenBy(a => a.MessageBatch);
if (list.Any())
{
result.ResultCode = "0";
result.ResultMessage = "Success";
result.ResultData = list.Select(a => new
{
Batch = a.MessageBatch,
FromWho = new CommonUserDAL().GetSingleById(a.FromWho.Value).NickName,
ToWho = new CommonUserDAL().GetSingleById(a.ToWho.Value).NickName,
CreateTime = a.CreateTime.Value.ToString("yyyy-MM-dd"),
Text = a.Text
});
}
return(Ok(result));
}
public MessageHandler(MessageDAL messageDAL, ServiceConfigDAL serviceConfigDAL)
{
this.messageDAL = messageDAL;
this.serviceConfigDAL = serviceConfigDAL;
}
public MessageHandler()
{
messageDAL = new MessageDAL();
serviceConfigDAL = new ServiceConfigDAL();
}
public void AddNewMessages(MessagesFromBulidingModel model)
{
MessageDAL messageDAL = new MessageDAL();
messageDAL.AddNewMessages(model);
}
public ActionResult List()
{
List <Message> list = MessageDAL.GetMessages();
return(View(list));
}
public static DataTable AddMsg(Guid FK_FromId, Guid FK_ToId, string msg, string date)
{
return(MessageDAL.AddMsg(FK_FromId, FK_ToId, msg, date));
}
public static DataTable GetMsgBySelection(int FK_FromId, int FK_ToId)
{
return(MessageDAL.GetMsgBySelection(FK_FromId, FK_ToId));
}
public static DataTable GetMsgByFKToId(int Fk_FromId, int FK_ToId)
{
return(MessageDAL.GetMsgByFKToId(Fk_FromId, FK_ToId));
}
public MessageBLL()
{
md = new MessageDAL();
}
public List <Message> GetSomeMessages(User sender, User receiver, int n)
{
MessageDAL dal = new MessageDAL();
return(dal.GetSomeMessage(sender, receiver, n));
}
public IHttpActionResult Replay([FromBody] Message message)
{
var result = new BaseResult();
result.ResultCode = "1";
result.ResultMessage = "Error";
if (message.MessageContent == null)
{
result.ResultMessage = "消息内容不能为空";
return Ok(result);
}
if (message.Batch == null)
{
result.ResultMessage = "消息号不能为空";
return Ok(result);
}
Data.Model.Message newMessage = new Data.Model.Message();
newMessage.Id = Guid.NewGuid();
newMessage.CreateTime = DateTime.Now;
newMessage.Status = 1;
newMessage.Text = message.MessageContent;
newMessage.FromWho = message.FromWho;
newMessage.ToWho = message.ToWho;
newMessage.MessageBatch = message.Batch;
if (message.Picture != null && message.Picture.Length > 0)
{
CommonPicture pic = new CommonPicture();
pic.Id = Guid.NewGuid();
pic.CreateTime = DateTime.Now;
pic.FileData = message.Picture;
pic.Status = 1;
pic.UserId = message.FromWho;
new CommonPictureDAL().Insert(pic);
newMessage.PicId = pic.Id;
}
var re = new MessageDAL().Insert(newMessage);
if (re)
{
result.ResultCode = "0";
result.ResultMessage = "Success";
result.ResultData = new
{
Batch = newMessage.MessageBatch,
FromWho = new CommonUserDAL().GetSingleById(newMessage.FromWho.Value).NickName,
ToWho = new CommonUserDAL().GetSingleById(newMessage.ToWho.Value).NickName,
CreateTime = newMessage.CreateTime.Value.ToString("yyyy-MM-dd HH:mm:ss"),
Text = newMessage.Text,
FromId = newMessage.FromWho,
ToId = newMessage.ToWho
};
}
else
{
result.ResultMessage = "发送消息失败";
}
return Ok(result);
}
