public ActionResult SendAllMess(string Content) { var obj = new HopThuItem(); obj.SendName = User.Identity.Name; obj.mes = Content; gamePlayerRepository.SendToMessenger(obj); return(Json(new { Error = false }, JsonRequestBehavior.AllowGet)); }
public ActionResult InsertMessByExcel(object data) { var file = Request["file"]; var namef = DateTime.Now.Ticks; System.IO.File.Move(Server.MapPath(ConfigWeb.TempPath + file), Server.MapPath("~/UploadFile/Files/" + namef + ".xlsx")); var fileName = Server.MapPath("~/UploadFile/Files/" + namef + ".xlsx"); const int startRow = 1; var existingFile = new FileInfo(fileName); // Open and read the XlSX file. using (var package = new ExcelPackage(existingFile)) { // Get the work book in the file var workBook = package.Workbook; if (workBook != null) { if (workBook.Worksheets.Count > 0) { var currentWorksheet = workBook.Worksheets.First(); for (int i = startRow + 1; i <= currentWorksheet.Dimension.End.Row; i++) { try { if (currentWorksheet.Cells[i, 2].Value != null) { var nickname = currentWorksheet.Cells[i, 1].Value.ToString(); var content = currentWorksheet.Cells[i, 2].Value.ToString(); var obj = new HopThuItem(); obj.SendName = User.Identity.Name; obj.ReceiveName = nickname; obj.mes = content; gamePlayerRepository.InsertOffMessenger(obj); } } catch (Exception) { continue; } } } } } return(Content(string.Empty)); }