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