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