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