public HomeController()
{
_messagesModel = new MessagesModel()
{
MainMessage = "Default Message from Code", OriginalRezolveName = null
};
}
// GET: /<controller>/
public IActionResult StoreImage(MessageViewModel model)
{
var userId = User.Identity.Name;
if (model.File == null || model.File.Length == 0)
{
return(Content("file not selected"));
}
var path = Path.Combine(
Directory.GetCurrentDirectory(), "wwwroot/uploads",
model.File.FileName);
using (var stream = new FileStream(path, FileMode.Create))
{
model.File.CopyToAsync(stream);
}
MessagesModel uploadFile = new MessagesModel
{
ImagePath = model.File.FileName,
SendTo = model.SendTo,
SendFrom = userId
};
IdentityContext.Messages.Add(uploadFile);
IdentityContext.SaveChanges();
return(RedirectToAction("ShowChat", new { Id = model.SendTo }));
}
public async Task <string> StartNodeAsync(int port)
{
string command = "cd " + Directory.GetCurrentDirectory() + @"\..\InMemoryDB\ & script.bat " + port.ToString();
Process.Start("cmd.exe", "/C " + command);
List <int> reshard = new List <int>();
for (int i = 0; i < Nodes.Ports.Count(); ++i)
{
var result = await MessagesModel.SendReshardingRequest(i);
if (result.Count() != 0)
{
reshard.AddRange(result);
}
}
if (reshard.Count() != 0)
{
ReshardingModel.Resharding(port, reshard);
}
Nodes.Ports.Add(port.ToString());
return("localhost:" + port.ToString());
}
//Insertar nuevo mensaje a la base de datos
public void CreateMessage(MessagesModel Mensaje, byte[] source, string fileName)
{
Mensaje.Archivo = null;
var NombreArchivo = fileName;
if (Mensaje.PoseeArchivo)
{
int i = 0;
while (true)
{
var x = GetFile(NombreArchivo);
if (x == null)
{
AddFile(source, NombreArchivo);
Mensaje.NombreArchivo = NombreArchivo;
_messages.InsertOne(Mensaje);
break;
}
else
{
var propiedades = fileName.Split(".");
NombreArchivo = propiedades[0] + i + "." + propiedades[1];
i++;
}
}
}
else
{
_messages.InsertOne(Mensaje);
}
}
/// <summary>
/// Constructor
/// </summary>
public ConversationStreamViewModel()
{
messagesModel = new MessagesModel();
MessagesList = messagesModel.MessagesList;
Conversation = null;
}
public ActionResult MessagesEdit(int id)
{
if (Session["UserTicket"] != null)
{
DataQueryService.IDataQueryService dataQueryService = new DataQueryService.DataQueryServiceClient();
var msg = dataQueryService.GetMessage(id, new Guid(Session["UserTicket"].ToString()));
var departments = dataQueryService.GetAllDeansOffices(new Guid(Session["UserTicket"].ToString())); // tu get deparmen
var model = new MessagesModel
{
departmentsList = departments.Select(d => new SelectListItem
{
Text = d.Department.Name,
Value = d.Id.ToString()
})
};
model.Id = msg.Id;
model.content = msg.Content;
model.title = msg.Title;
model.important = msg.Important;
model.selectedDepartmentId = msg.Department.Id;
model.UserId = msg.UserId;
return(View(model));
}
return(Redirect("~/Login/Login"));
}
public void UpdateMessage(MessagesModel Message)
{
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
if ((Message.AdminAccepted == "Accepted") || (Message.AdminAccepted == "Declined"))
{
conn.Open();
SqlCommand cmd = new SqlCommand(UpdateMessageAdminSQL, conn);
cmd.Parameters.AddWithValue("@messageID", Message.ID);
cmd.Parameters.AddWithValue("@AdminAccepted", Message.AdminAccepted);
cmd.ExecuteNonQuery();
}
else
{
conn.Open();
SqlCommand cmd = new SqlCommand(UpdateMessageUSQL, conn);
cmd.Parameters.AddWithValue("@messageID", Message.ID);
cmd.Parameters.AddWithValue("@UserAccepted", Message.UserAccepted);
cmd.ExecuteNonQuery();
}
}
}
catch (SqlException ex)
{
throw ex;
}
}
public ActionResult <UsersModels> PostMsg(MessagesModel Message)
{
var emisor = Message.EmisorMsg;
var validatedSend = _chatDatabaseService.ValidateUser(emisor);
var receptor = Message.ReceptorMsg;
var validatedGet = _chatDatabaseService.ValidateUser(receptor);
var secretKey = Libreria.Metodos.DiffieHelmannAlgorithm(validatedSend.IDDH, validatedGet.IDDH);
var mensajeOriginal = new byte[Message.Mensaje.Length];
for (int i = 0; i < Message.Mensaje.Length; i++)
{
mensajeOriginal[i] = Convert.ToByte(Convert.ToChar(Message.Mensaje[i]));
}
int result = (int)secretKey;
var messageEncriptado = Libreria.Metodos.EncryptionZigZag(mensajeOriginal, result);
var mensajeGuardar = string.Empty;
for (int i = 0; i < messageEncriptado.Length; i++)
{
mensajeGuardar += Convert.ToChar(messageEncriptado[i]);
}
Message.Mensaje = mensajeGuardar.ToString();
var start = DateTime.Now;
Message.FechaEnvio = start;
_chatDatabaseService.CreateMessage(Message, Message.Archivo, Message.NombreArchivo);
return(Ok());
}
public DetailPage(MessagesModel Message)
{
InitializeComponent();
this.Message = Message;
this.BindingContext = Message;
MarkRead();
}
public void ProcessRequest(HttpContext context)
{
MessagesModel r = new MessagesModel(false, "必须使用Post提交");
try
{
if (context.Request.HttpMethod == "POST") //限制只有POST提交才有效
{
DataTable dt = new BLL.APP.Contact().GetTable(0);
if (dt != null && dt.Rows.Count > 0)
{
r.Success = true;
r.Msg = dt.Rows[0]["context"].ToString();
}
else
{
r.Success = false;
r.Msg = "内容不存在!";
}
}
}
catch (Exception)
{
r.Msg = "读取出错";
}
finally
{
context.Response.ContentType = "application/json";
context.Response.Write(new JavaScriptSerializer().Serialize(r));
context.Response.End();
}
}
private bool SaveMsg(MessageModel m)
{
//这是表的Model，跟MessageModel不一样，MessageModel是自定义的消息结构
//if (MessagesBLL.Exist(m.id)) return true;
MessagesModel tableMessages = new MessagesModel
{
id = m.id,
uid = m.FromUid,
to_uid = m.ToUid ?? "0",
msg = m.Msg
};
try
{
return(MessagesBLL.Add(tableMessages) > 0);
}
catch (MySqlException e)
{
if (e.Message.Contains("Duplicate entry"))
{
return(true);
}
}
return(false);
}
public List <MessagesModel> GetMessagesForAdmin()
{
List <MessagesModel> messages = new List <MessagesModel>();
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(GetMessagesForAdminSQL, conn);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
MessagesModel message = new MessagesModel();
message.MessageBody = Convert.ToString(reader["messageBody"]);
message.SentByID = Convert.ToInt32(reader["SentByUserID"]);
message.SentToID = Convert.ToInt32(reader["toUserID"]);
message.ID = Convert.ToInt32(reader["id"]);
message.AdminAccepted = Convert.ToString(reader["adminAccepted"]);
messages.Add(message);
}
}
return(messages);
}
catch (SqlException ex)
{
throw ex;
}
}
public MessagesModel GetMessagebyID(int ID)
{
MessagesModel message = new MessagesModel();
message.ID = ID;
try
{
using (SqlConnection conn = new SqlConnection(connectionString))
{
conn.Open();
SqlCommand cmd = new SqlCommand(GetMessagebyIDSQL, conn);
cmd.Parameters.AddWithValue("@ID", ID);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
message.MessageBody = Convert.ToString(reader["messageBody"]);
message.SentByID = Convert.ToInt32(reader["SentByUserID"]);
message.SentToID = Convert.ToInt32(reader["toUserID"]);
}
}
return(message);
}
catch (SqlException ex)
{
throw ex;
}
}
public ActionResult MessageReceive(int?messageID = 0)
{
MessagesModel model = new MessagesModel();
List <MessagesModel> MessagesList = new List <MessagesModel>();
messagesGroups.U_ID = Convert.ToInt32(Session["UserId"]);
actionResult = messagesAction.Message_Received(messagesGroups);
if (actionResult.IsSuccess && actionResult.dtResult.Rows.Count > 0)
{
MessagesList = (from DataRow row in actionResult.dtResult.Rows
select new MessagesModel
{
MessageID = row["MessageID"] != DBNull.Value ? Convert.ToInt32(row["MessageID"]) : 0,
DateSent = row["DateSent"] != DBNull.Value ? row["DateSent"].ToString() : "",
FirstName = row["FirstName"] != DBNull.Value ? row["FirstName"].ToString() : "",
LastName = row["LastName"] != DBNull.Value ? row["LastName"].ToString() : "",
Description = row["Description"] != DBNull.Value ? row["Description"].ToString() : "",
MessageText = row["MessageText"] != DBNull.Value ? row["MessageText"].ToString() : "",
Draft = row["Draft"] != DBNull.Value ? row["Draft"].ToString() : "",
SentToSelf = row["SentToSelf"] != DBNull.Value ? row["SentToSelf"].ToString() : ""
}).ToList();
}
model.MessagesList = MessagesList;
return(View(model));
}
public static List <MessagesModel> ReadMessages(string username)
{
List <MessagesModel> messagesModel = new List <MessagesModel>();
UserDetails details = new UserDetails();
int id = FetchUserId(username);
using (UsersContext db = new UsersContext())
{
var ms = db.Messages.Where(u => u.touserid == id).ToList();
foreach (var m in ms)
{
MessagesModel mm = new MessagesModel();
mm.data = m.data;
mm.datecreated = m.datecreated;
mm.datemodified = m.datemodified;
mm.fromuserid = m.fromuserid;
var messageuser = GetUserDetailsId(m.fromuserid);
mm.fromname = messageuser.firstname + " " + messageuser.lastname;
//mm.fromname = "";
mm.messageid = m.messageid;
mm.status = m.status;
mm.touserid = m.touserid;
messagesModel.Add(mm);
}
// Check if user already exists
return(messagesModel);
}
}
/// <summary>
/// возвращает ветку темы
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public List <MessagesModel> GetMessagesThemeItem(Guid id)
{
List <MessagesModel> model = new List <MessagesModel>();
using (var db = new CMSdb(_context))
{
using (var tr = db.BeginTransaction())
{
var q = db.msg_messages.Where(w => w.id == id && w.f_site == _siteId && w.f_parent == null);
if (q.Any())
{
//делаем сообщения пользователя прочитанными
var e = db.msg_messages.Where(w => (w.id == id || w.f_parent == id) && w.b_admin == false)
.Set(s => s.b_views, true)
.Update();
var TopMessage = q.Single();
MessagesModel topelement = new MessagesModel()
{
Date = TopMessage.d_date,
Text = TopMessage.c_text,
Theme = TopMessage.c_theme,
Admin = TopMessage.b_admin,
MsgUser = db.core_AspNetUserProfiles.Where(w => w.UserId == TopMessage.f_user.ToString())
.Select(s => new UserModel
{
Surname = s.Surname,
Name = s.Name,
Id = TopMessage.f_user
}).Single()
};
model.Add(topelement);
var MsgList = db.msg_messages.Where(w => w.f_parent == TopMessage.id)
.OrderBy(o => o.d_date)
.Join(db.core_AspNetUserProfiles, n => n.fkuserid.Id, m => m.UserId, (n, m) => new { n, m })
.Select(s => new MessagesModel()
{
Date = s.n.d_date,
Text = s.n.c_text,
Admin = s.n.b_admin,
MsgUser = new UserModel
{
Surname = s.m.Surname,
Name = s.m.Name,
Id = s.n.f_user
}
}).ToList();
model.AddRange(MsgList);
model.Reverse();
tr.Commit();
return(model);
}
}
return(null);
}
}
public ActionResult ActivateClassified(long id)
{
var explanationMessage = new MessagesModel();
explanationMessage.ClassifiedsShown = _readOnlyRepository.FirstOrDefault <Classifieds>(x => x.Id == id);
return(View(explanationMessage));
}
public ActionResult ToInbox()
{
var mModel = new MessagesModel();
var x = _readOnlyRepository.FirstOrDefault <AccountLogin>(z => z.Email == HttpContext.User.Identity.Name);
mModel.MessagesList = x.AccountMessages.ToList();
return(View(mModel));
}
public Task <MessagesModel> GetHistoryChatAsync(int IdChat, int count, int offset, int rev = 0)
{
return(Task.Run(() =>
{
MessagesModel messageModel = GetHistoryChat(IdChat, count, offset, rev);
return messageModel;
}));
}
public int UpdateMessages(MessagesModel messages)
{
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter("@MessageNo", messages.MessageNo);
sqlParameters[1] = new SqlParameter("@MessageName", messages.MessageName);
sqlParameters[2] = new SqlParameter("@MessageDescription", messages.MessageDescription);
return(conn.executeUpdateQuery("sp_UpdateMessages", sqlParameters));
}
private void SetMessages()
{
if ((HubClientService != null && !string.IsNullOrEmpty(GroupId)) &&
HubClientService.MessagesModels.ContainsKey(GroupId))
{
Messages = HubClientService.MessagesModels[GroupId];
}
}
public IActionResult AdminDeclineEvent(int id)
{
TempData["Final"] = "You have declined this event both teams will be notified";
MessagesModel Message = messageDAL.GetMessagebyID(id);
Message.AdminAccepted = "Declined";
messageDAL.UpdateMessage(Message);
return(RedirectToAction("FinalizeEvent", "Admin"));
}
public IActionResult UserAcceptEvent(int id)
{
TempData["Final"] = "You have approved this event, now pending Admin approval";
MessagesModel Message = messageDAL.GetMessagebyID(id);
Message.UserAccepted = "Accepted";
messageDAL.UpdateMessage(Message);
return(RedirectToAction("SeeMessages", "Message"));
}
public IActionResult UserDeclineEvent(int id)
{
TempData["Final"] = "You have declined this event, the other team will be notified";
MessagesModel Message = messageDAL.GetMessagebyID(id);
Message.UserAccepted = "Declined";
messageDAL.UpdateMessage(Message);
return(RedirectToAction("SeeMessages", "Message"));
}
public ActionResult MessagesDelete(MessagesModel model)
{
if (Session["UserTicket"] != null)
{
model.deleteMessage(model, new Guid(Session["UserTicket"].ToString()));
return(Redirect("~/Messages/Messages"));
}
return(Redirect("~/Login/Login"));
}
public IActionResult Messages()
{
var model = new MessagesModel();
model.Allowed = _pushNotificationsService.GetAllowedReceivers();
model.Denied = _pushNotificationsService.GetDeniedReceivers();
return(View(model));
}
public ActionResult Messages(string aspNetUserIdSentMessage = null)
{
ValidateUserStatus();
_memberNotificationBadgeService.Reset(_userService.GetCurrentUserId(), (int)NotificationBadgeType.Messages);
MessagesModel mm = GetViewModel <MessagesModel>();
mm.AspNetUserId = aspNetUserIdSentMessage;
return(View(mm));
}
private static string ComposeFinalBody(MessagesModel message)
{
//todo - jay - make this a string builder object
var body = message.Greeting += "\n\n";
body += message.Body + "\n";
body += message.Signature;
return(body);
}
public void OnFirstRun()
{
if (Settings.Default.FirstRun == true)
{
SetPaperSize setPaperSize = new SetPaperSize();
MessagesModel messages = new MessagesModel();
messages.FirstRunInfo();
PSettings settings = new PSettings();
}
}
public async Task <IActionResult> Messages()
{
var model = new MessagesModel
{
Allowed = await _pushNotificationsService.GetAllowedReceivers(),
Denied = await _pushNotificationsService.GetDeniedReceivers()
};
return(View(model));
}
private ActionResult GetMessages(MessageType messageType, int? key)
{
int total;
var pageIndex = (key ?? 1);
var statistics = _conversationService.GetConversationStatistics(KatushaProfile.Id, messageType);
var messages = _conversationService.GetMessages(KatushaProfile.Id, messageType, out total, pageIndex, PageSize);
var messagesModel = Mapper.Map<IList<ConversationModel>>(messages);
var messagesAsIPagedList = new StaticPagedList<ConversationModel>(messagesModel, pageIndex, PageSize, total);
var model = new MessagesModel {
MessageType = messageType,
Statistics = statistics,
Conversations = new PagedListModel<ConversationModel> {List = messagesAsIPagedList, Total = total},
};
return View("Index", model);
}
public ActionResult Conversation(long id, int? page)
{
int total;
var pageIndex = (page ?? 1);
var messages = _conversationService.GetConversation(KatushaProfile.Id, id, out total, pageIndex, PageSize);
var messagesModel = Mapper.Map<IList<ConversationModel>>(messages);
var messagesAsIPagedList = new StaticPagedList<ConversationModel>(messagesModel, pageIndex, PageSize, total);
var model = new MessagesModel
{
MessageType = MessageType.Sent,
Statistics = new ConversationCountResult {Count = total, ProfileId = id, UnreadCount = -1 },
Conversations = new PagedListModel<ConversationModel> { List = messagesAsIPagedList, Total = total },
};
return View("Messages", model);
}
private bool ProcessMessages(MessageType type, MessagesModel messages)
{
var messagesTmp = TempData[GetMessageTempKey(type)] as IEnumerable;
var foundAny = false;
if (messagesTmp != null)
{
foreach (var messageTmp in messagesTmp)
{
messages.Add(new MessageModel(messageTmp.ToString(), type));
foundAny = true;
}
}
return foundAny;
}
protected override void OnActionExecuted(ActionExecutedContext filterContext)
{
if (!filterContext.Canceled && filterContext.Result != null && !ControllerContext.IsChildAction)
{
FillViewBagWithMetadata(filterContext);
}
//Process messages
var messages = new MessagesModel();
var hasMessages = Enum.GetNames(typeof (MessageType)).Aggregate(false, (current, typeName) =>
current | ProcessMessages((MessageType)Enum.Parse(typeof(MessageType), typeName), messages));
if (hasMessages)
{
this.SharedViewBag().Messages = messages;
}
}
public CartJsonModel()
{
Messages = new MessagesModel();
}
