public JsonResult GetAllUsers(string sord = "asc", string sidx = "UserName", int page = 1, int rows = 10)
{
IList <object> users = new List <object>(_repository.Find(sord, sidx, (page - 1) * rows, rows));
var jsonData = JqGridModel.GridData(page, rows, _repository.Count, users);
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public JsonResult GetAllCategorys(string sord = "asc", string sidx = "CategoryName", int page = 1, int rows = 10)
{
IList <object> pros = new List <object>(FindCategoryViewModels(sord, sidx, (page - 1) * rows, rows));
var jsonData = JqGridModel.GridData(page, rows, initCategoryViewModels().Count(), pros);
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public async Task <JsonResult> ExportAndSend(WriterListViewModel vm, JqGridModel model)
{
var result = false;
var htmlBuilder = new StringBuilder();
try
{
string jsonPostData;
using (var input = Request.InputStream)
{
input.Position = 0;
using (var reader = new System.IO.StreamReader(input))
{
jsonPostData = reader.ReadToEnd();
}
}
var jqGrid = JsonConvert.DeserializeObject <JqGridModel>(jsonPostData, new JqGridConverter());
int totalRecords;
var data = GetData(jqGrid.GridSettings, out totalRecords, true);
var colStates = ConvertDataToExcel.ConvertColStateToColumnModels(jqGrid.ColStates);
foreach (var columnModel in colStates)
{
if (!string.IsNullOrEmpty(columnModel.Header))
{
htmlBuilder.AppendFormat(@"{0};", columnModel.Header);
}
}
htmlBuilder.AppendFormat(Environment.NewLine);
htmlBuilder = ConvertDataToExcel.ConvertDataToArray(data, jqGrid.ColStates, htmlBuilder);
//var fileName = String.Format("{0}.csv", vm.GridData.Caption);
//var attach = new Dictionary<string, string> {[fileName] = htmlBuilder.ToString() };
var user = await _userManager.FindByIdAsync(User.Identity.GetUserId());
//result = Email.SendZipEmail(user.Email, Server.MapPath("~/Reports/"), fileName, htmlBuilder.ToString());
var fileName = String.Format("{1}{0}.csv", vm.GridData.Caption, Server.MapPath(WebConfigurationManager.AppSettings["ReportsPath"]));
var resp = await _emailingService.SendMessage(user.Email, fileName, htmlBuilder.ToString());
result = resp.RejectReason == null;
}
catch (Exception ex)
{
//_log.Error(ex);
return(new JsonResult
{
Data = new { ErrorMessage = ex.Message, Success = false },
ContentEncoding = System.Text.Encoding.UTF8,
JsonRequestBehavior = JsonRequestBehavior.DenyGet
});
}
return(new JsonResult()
{
Data = new { Success = result },
});
}
public async Task <ActionResult> jqGridTempl(OrderListViewModel vm, JqGridModel model)
{
var result = false;
string jsonPostData;
using (var stream = Request.InputStream)
{
stream.Position = 0;
using (var reader = new System.IO.StreamReader(stream))
{
jsonPostData = reader.ReadToEnd();
}
}
var user = await _userManager.FindByIdAsync(User.Identity.GetUserId());
if (model.Action.Equals("apply"))
{
user.Templates += JsonTemplateConverter.ConvertToDB(jsonPostData, vm.GridData.Caption);
var resultIdent = await _userManager.UpdateAsync(user);
result = resultIdent.Succeeded;
}
else if (model.Action.Equals("remove"))
{
user.Templates = JsonTemplateConverter.RemoveTempl(user.Templates, model.TemplName, vm.GridData.Caption);
var resultIdent = await _userManager.UpdateAsync(user);
result = resultIdent.Succeeded;
}
//TODO
else if (model.Action.Equals("jqGridTempl"))
{
//var jqGrid = JsonConvert.DeserializeObject<JqGridModel>(jsonPostData, new JqGridConverter());
//int totalRecords;
//var data = GetData(jqGrid.GridSettings, out totalRecords, true);
//var arr = ConvertDataToExcel.ConvertDataToArray(data, jqGrid.ColStates);
//var colStates = ConvertDataToExcel.ConvertColStateToColumnModels(jqGrid.ColStates);
//return View("MyView");
//using (var stream = new FileStream("Orders.xlsx", FileMode.Create))
//{
// ExportToExcel.FillSpreadsheetDocument(stream, colStates.ToArray(), arr.ToArray(), "Orders");
// //return new FileStreamResult(stream, writer.MimeType);
//}
result = true;
}
return(Json(new { success = result }));
}
public JsonResult ITArrivalTimeRequestIndex2(string sord = "asc", string sidx = "ProductName", int page = 1,
int rows = 10, bool _search = false, string searchField = "", string searchOper = "", string searchString = "")
{
List <Entities.ImportTrans_main_record> test_JqGrids = _importTrans_main_recordService.getAll();
int count = test_JqGrids.Count();
// var objpros = new List<object>(pros);editArrivalTime
var jsonData = JqGridModel.GridData(page, rows, count, test_JqGrids);
return(Json(jsonData));
}
public JsonResult JqGridIndex2(string sord = "asc", string sidx = "ProductName", int page = 1,
int rows = 10, bool _search = false, string searchField = "", string searchOper = "", string searchString = "")
{
List <Entities.test_JqGrid> test_JqGrids = _itest_JqGridService.getAlltest_JqGrid();
int count = test_JqGrids.Count();
// var objpros = new List<object>(pros);
var jsonData = JqGridModel.GridData(page, rows, count, test_JqGrids);
return(Json(jsonData));
}
public ActionResult GetLogList(JqGridModel.JqGrid jq, PubPage fg)
{
if (jq.page == 0)
{
jq.page = 1;
jq.rows = 10;
jq.sidx = "CreateTime";
jq.sord = "DESC";
}
var list = _iSysLogServices.PageSysLog(fg, jq);
return(Json(JqGridModel.GridData(list.Item1, jq, list.Item2), JsonRequestBehavior.AllowGet));
}
public JsonResult GetAllPros(string sord = "asc", string sidx = "ProductName", int page = 1,
int rows = 10, bool _search = false, string searchField = "", string searchOper = "", string searchString = "")
{
var rawpros = GetRawPros(_search, searchField, searchOper, searchString);
var propertyInfo = typeof(Product).GetProperty(switchSidx(sidx));
Func <Product, object> expn = e => propertyInfo.GetValue(e, null);
var enumerable = rawpros as Product[] ?? rawpros.ToArray();
IEnumerable <Product> pros = sord == "asc" ? enumerable.OrderBy(expn).Skip((page - 1) * rows).Take(rows).ToArray()
: enumerable.OrderByDescending(expn).Skip((page - 1) * rows).Take(rows).ToArray();
var objpros = new List <object>(pros);
var jsonData = JqGridModel.GridData(page, rows, enumerable.Count(), objpros);
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public async Task <JqGridModel <T> > FindListPager <T>(string str, JqgridParam param)
{
JqGridModel <T> resultModel = new JqGridModel <T>();
var skip = (param.page - 1) * param.rows;
string sql = string.Format(SqlPagerTempalte(str, skip, param.rows));
var ds = await dbHelper.Query(sql);
var dt = ds.Tables[0];
var entities = DataTableToEntityHelper.ToEntityList <T>(dt);
string countSql = string.Format(TotalCountSqlTemplate(), str);
resultModel.records = int.Parse((await dbHelper.GetSingle(countSql)).ToString());
resultModel.total = resultModel.records % param.rows == 0 ? resultModel.records / param.rows : resultModel.records / param.rows + 1;
resultModel.rows = entities.ToList();
resultModel.page = param.page;
return(resultModel);
}
