public JsonResult GetUserCategoryList(DataTableViewModel dataTableViewModel) { string SearchLevel1Str = Request.QueryString["SearchLevel1"]; int? SearchLevel1 = !string.IsNullOrEmpty(SearchLevel1Str) ? int.Parse(SearchLevel1Str) as int? : null; string SearchLevel2Str = Request.QueryString["SearchLevel2"]; int? SearchLevel2 = !string.IsNullOrEmpty(SearchLevel2Str) ? int.Parse(SearchLevel2Str) as int? : null; string SearchLevel3Str = Request.QueryString["SearchLevel3"]; int? SearchLevel3 = !string.IsNullOrEmpty(SearchLevel3Str) ? int.Parse(SearchLevel3Str) as int? : null; string SearchLevel4Str = Request.QueryString["SearchLevel4"]; int? SearchLevel4 = !string.IsNullOrEmpty(SearchLevel4Str) ? int.Parse(SearchLevel4Str) as int? : null; string SearchName = Request.QueryString["SearchName"]; var includeMultiProperties = new Expression <Func <ACT.Models.UserCategory, object> >[] { x => x.Level2, y => y.Level1, z => z.Level3, t => t.Level4 }; var data = _UserCategoryService.ListWithPaging( filter: x => (SearchLevel1 == null || x.Level1Id == SearchLevel1) && (SearchLevel2 == null || x.Level2Id == SearchLevel2) && (SearchLevel3 == null || x.Level3Id == SearchLevel3) && (SearchLevel4 == null || x.Level4Id == SearchLevel4) && x.Name.Contains(SearchName), includeProperties: includeMultiProperties, orderBy: o => o.DisplayOrder, pageSize: dataTableViewModel.length, page: dataTableViewModel.start); //fix serilaize json >> var dataMapped = Mapper.Map <List <UserCategoryViewModel> >(data.EntityData); return(Json(new { data = dataMapped, recordsTotal = data.Count, recordsFiltered = data.Count }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetDirectResponsible(DataTableViewModel dataTableViewModel) { string SearchLevelName = Request.QueryString["SearchLevelName"]; string SearchResponsibleName = Request.QueryString["SearchResponsibleName"]; var EntityData = new List <DirectResponsibleViewModel>(); int Count = 0; if (CurrentUser.MyLevelNumber == 0) { var data = _directResponsibleService.GetForlevel1(dataTableViewModel.length, dataTableViewModel.start, SearchLevelName, SearchResponsibleName); EntityData = data.EntityData; Count = data.Count; } else if (CurrentUser.MyLevelNumber == 1) { var data = _directResponsibleService.GetForlevel2(dataTableViewModel.length, dataTableViewModel.start, SearchLevelName, SearchResponsibleName); EntityData = data.EntityData; Count = data.Count; } else if (CurrentUser.MyLevelNumber == 2) { var data = _directResponsibleService.GetForlevel3(dataTableViewModel.length, dataTableViewModel.start, SearchLevelName, SearchResponsibleName); EntityData = data.EntityData; Count = data.Count; } else if (CurrentUser.MyLevelNumber == 3) { var data = _directResponsibleService.GetForlevel4(dataTableViewModel.length, dataTableViewModel.start, SearchLevelName, SearchResponsibleName); EntityData = data.EntityData; Count = data.Count; } return(Json(new { data = EntityData, recordsTotal = Count, recordsFiltered = Count }, JsonRequestBehavior.AllowGet)); }
public DataTableViewModel NganhDuoc_CN_GPP_CongBoWebsite(string SoGiayChungNhan, DateTime?tuNgay, DateTime?denNgay , string TenCoSo, string SoDKKD) { try { using (IDbConnection conn = Connection) { conn.Open(); var parameters = new DynamicParameters(); parameters.Add("SoGiayChungNhan", SoGiayChungNhan, DbType.String, ParameterDirection.Input); parameters.Add("tuNgay", tuNgay, DbType.DateTime, ParameterDirection.Input); parameters.Add("denNgay", denNgay, DbType.DateTime, ParameterDirection.Input); parameters.Add("TenCoSo", TenCoSo, DbType.String, ParameterDirection.Input); parameters.Add("SoDKKD", SoDKKD, DbType.String, ParameterDirection.Input); var datas = conn.ExecuteReader("NganhDuoc_CN_GPP_CongBoWebsite", parameters , commandType: CommandType.StoredProcedure); DataTableViewModel dt = new DataTableViewModel(datas); dt.Name = "DanhSachGPP"; return(dt); } } catch (Exception ex) { _logger.Error(ex.Message); return(new DataTableViewModel()); } }
public DataTableViewModel NganhDuoc_CC_Duoc_CongBoWebsite(string SoChungChi, DateTime?tuNgay, DateTime?denNgay , string HoTen, string SoGiayTo, string TrangThai) { try { using (var conn = Connection) { conn.Open(); var parameters = new DynamicParameters(); parameters.Add("SoChungChi", SoChungChi, DbType.String, ParameterDirection.Input); parameters.Add("tuNgay", tuNgay, DbType.DateTime, ParameterDirection.Input); parameters.Add("denNgay", denNgay, DbType.DateTime, ParameterDirection.Input); parameters.Add("HoTen", HoTen, DbType.String, ParameterDirection.Input); parameters.Add("SoGiayTo", SoGiayTo, DbType.String, ParameterDirection.Input); parameters.Add("TrangThai", TrangThai, DbType.String, ParameterDirection.Input); var datas = conn.ExecuteReader("NganhDuoc_CC_Duoc_CongBoWebsite", parameters , commandType: CommandType.StoredProcedure); DataTableViewModel dt = new DataTableViewModel(datas); dt.Name = "DanhSachCCDuoc"; return(dt); } } catch (Exception ex) { _logger.Error(ex.Message); return(new DataTableViewModel()); } }
public IHttpActionResult List(int start, int length, [FromUri(Name = "search.value")] string search) { IList <Employee> list = searchService.Search(start, length, search); DataTableViewModel vm = DataTableViewModel.GetViewModel(() => { List <List <string> > data = new List <List <string> >(); foreach (Employee emp in list) { List <string> item = new List <string>(); item.Add(emp.EmployeeName); item.Add(emp.Designation?.DesignationName); item.Add(emp.Department?.DepartmentName); item.Add(emp.User?.UserName); item.Add(emp.EmployeeId.ToString()); data.Add(item); } return(data); }); return(Json(vm)); }
public DataTableViewModel MotCua_HoSoTiepNhan_XuatDanhSach(int?linhVucID, int?thuTucID, string soBienNhan, DateTime?tuNgay, DateTime?denNgay, string hoTenNguoiNop, string soGiayTo, int?userDangNhapID, int?trangThaiHoSoID, string listHoSoID) { try { using (var conn = Connection) { conn.Open(); var parameters = new DynamicParameters(); parameters.Add("linhVucID", linhVucID, DbType.Int32, ParameterDirection.Input); parameters.Add("thuTucID", thuTucID, DbType.Int32, ParameterDirection.Input); parameters.Add("soBienNhan", soBienNhan, DbType.String, ParameterDirection.Input); parameters.Add("tuNgay", tuNgay, DbType.DateTime, ParameterDirection.Input); parameters.Add("denNgay", denNgay, DbType.DateTime, ParameterDirection.Input); parameters.Add("hoTenNguoiNop", hoTenNguoiNop, DbType.String, ParameterDirection.Input); parameters.Add("soGiayTo", soGiayTo, DbType.String, ParameterDirection.Input); parameters.Add("userDangNhapID", userDangNhapID, DbType.Int32, ParameterDirection.Input); parameters.Add("trangThaiHoSoID", trangThaiHoSoID, DbType.Int32, ParameterDirection.Input); parameters.Add("listHoSoID", listHoSoID, DbType.String, ParameterDirection.Input); var datas = conn.ExecuteReader("MotCua_HoSoTiepNhan_XuatDanhSach", parameters, commandType: CommandType.StoredProcedure); DataTableViewModel dt = new DataTableViewModel(datas); dt.Name = "DanhSachHoSo"; return(dt); } } catch (Exception ex) { _logger.Error(ex.Message); return(null); } }
public TreeViewModel(IConfiguration config, IMfgResources resources, TreeViewViewModel viewModel, DataTableViewModel dataTable) { this.config = config; this.resources = resources; this.viewModel = viewModel; this.dataTable = dataTable; }
public DataTableViewModel <AnnuaireUtilisateurDTO> GetFromParams(Dictionary <string, string> DataTableParameters) { //Int32 ParameterStart = Int32.Parse(DataTableParameters["start"]); //Int32 ParameterLength = Int32.Parse(DataTableParameters["length"]); Int32 ParameterSiteId = Int32.Parse(DataTableParameters["siteId"]); Site Site = _db.Sites.Where(s => s.SiteID == ParameterSiteId).FirstOrDefault(); String ParameterTrigramme = Site.Trigramme; string connectionPrefix = "LDAP://refresco.local"; DirectoryEntry entry = new DirectoryEntry(connectionPrefix); DirectorySearcher mySearcher = new DirectorySearcher(entry); mySearcher.Filter = "(&(objectCategory=Person)(objectClass=User)"; mySearcher.Filter += (ParameterTrigramme == null) ? "" : "(company=" + ParameterTrigramme + "))"; mySearcher.PropertiesToLoad.Add("cn"); mySearcher.PropertiesToLoad.Add("givenname"); mySearcher.PropertiesToLoad.Add("sn"); mySearcher.PropertiesToLoad.Add("telephonenumber"); mySearcher.PropertiesToLoad.Add("mobile"); mySearcher.PropertiesToLoad.Add("title"); mySearcher.PropertiesToLoad.Add("mail"); var results = SafeFindAll(mySearcher); mySearcher.Dispose(); List <AnnuaireUtilisateurDTO> AllAnuaireUtilisateurDTO = new List <AnnuaireUtilisateurDTO>(); foreach (var result in results) { AllAnuaireUtilisateurDTO.Add(new AnnuaireUtilisateurDTO() { NomEntier = result.Properties["cn"][0].ToString(), Prenom = result.Properties["givenname"][0].ToString(), Nom = (result.Properties["sn"].Count > 0) ? result.Properties["sn"][0].ToString() :"", NumInterne = (result.Properties["telephonenumber"].Count > 0) ? result.Properties["telephonenumber"][0].ToString() : "", NumExterne = (result.Properties["mobile"].Count > 0) ? result.Properties["mobile"][0].ToString() : "", Poste = (result.Properties["title"].Count > 0) ? result.Properties["title"][0].ToString() : "", Mail = (result.Properties["mail"].Count > 0) ? result.Properties["mail"][0].ToString() : "" }); } Object Response = new { AllAnuaireUtilisateurDTO = AllAnuaireUtilisateurDTO }; int RecordsFiltered = AllAnuaireUtilisateurDTO.Count(); int RecordsTotal = AllAnuaireUtilisateurDTO.Count(); DataTableViewModel <AnnuaireUtilisateurDTO> DataTableViewModel = new DataTableViewModel <AnnuaireUtilisateurDTO>() { recordsTotal = RecordsTotal, recordsFiltered = RecordsFiltered, data = AllAnuaireUtilisateurDTO }; return(DataTableViewModel); }
public JsonResult UserActivityDetails(DataTableViewModel objReq) { try { int CustomerID = GetLogin(); int RoleID = GetRole(); if (objReq != null) { DataTableResponse <UserGeoLocationModel> objResp = new DataTableResponse <UserGeoLocationModel>(); // IQueryable<UserGeoLocationModel> query = this.objUserDetailService.UserActivityDetails(); List <UserGeoLocationModel> objgeo = objUserDetailService.GetUserGeoLoctionLog(CustomerID); IQueryable <UserGeoLocationModel> query = objgeo.AsQueryable(); objResp.recordsTotal = query.Count(); for (int i = 0; i < objReq.order.Count; i++) { int idx = Convert.ToInt32(objReq.order[i].column); switch (objReq.columns[idx].data) { case "Username": if (objReq.order[i].dir == "asc") { query = query.OrderBy(x => x.Username); } else { query = query.OrderByDescending(x => x.Username); } break; default: case "CreatedOn": if (objReq.order[i].dir == "asc") { query = query.OrderBy(x => x.CreatedOn); } else { query = query.OrderByDescending(x => x.CreatedOn); } break; } } objResp.draw = objReq.draw; objResp.recordsFiltered = query.Count(); objResp.data = query.Skip(objReq.start).Take(objReq.length).ToList(); return(Json(objResp)); } return(null); } catch (Exception ex) { ErrorLog.Log("OrderController", "OrderListing", ex); throw; } }
public IEnumerable <TableData> FindDataToTable() { if (TableName.Length > 0) { return(DataTableViewModel.GetPropValue(dataTable, TableName)); } else { return(DataTableViewModel.GetPropValue(dataTable, TableNameNow)); } }
public JsonResult GetEvidenceList(DataTableViewModel dataTableViewModel) { string SearchName = Request.QueryString["SearchName"]; decimal SearchStandardId = Request.QueryString["SearchStandardId"].ToNullableDecimal().Value; var data = _evidenceService.ListWithPaging(filter: x => x.EvidenceDescription.Contains(SearchName) && x.StandardId == SearchStandardId, orderBy: o => o.DisplayOrder, pageSize: dataTableViewModel.length, page: dataTableViewModel.start); return(Json(new { data = data.EntityData, recordsTotal = data.Count, recordsFiltered = data.Count }, JsonRequestBehavior.AllowGet)); }
public ActionResult AllMoviesJson(int draw, int start, int length) { var allMovies = this.moviesSV.GetAllAndDeleted().Select(x => Mapper.Map <GridMovieViewModel>(x)).ToList(); var totalMoviesCount = allMovies.Count(); IDataTableViewModel <GridMovieViewModel> dataTableData = new DataTableViewModel <GridMovieViewModel>(); this.FillDataTable(dataTableData, allMovies, draw, totalMoviesCount, start, length); return(Json(dataTableData)); }
public JsonResult GetLevel1List(DataTableViewModel dataTableViewModel) { string SearchName = Request.QueryString["SearchName"]; var data = _level1Service.ListWithPaging(filter: x => x.Name.Contains(SearchName), orderBy: o => o.DisplayOrder, pageSize: dataTableViewModel.length, page: dataTableViewModel.start); return Json(new { data = data.EntityData, recordsTotal = data.Count, recordsFiltered = data.Count }, JsonRequestBehavior.AllowGet); }
public HttpResponseMessage Get() { _dialogueSecuriteRepository = new DialogueSecuriteRepository(); Dictionary <string, string> DataTableParameters = new Dictionary <string, string>(); DataTableParameters = Request.GetQueryNameValuePairs().ToDictionary(kv => kv.Key, kv => kv.Value, StringComparer.OrdinalIgnoreCase); DataTableViewModel <DialogueSecurite> DataTableViewModel = _dialogueSecuriteRepository.GetFromParams(DataTableParameters); return(Request.CreateResponse(HttpStatusCode.OK, DataTableViewModel)); }
public DataTableView() { this.vm = new DataTableViewModel(PlaneModel.GetModel()); InitializeComponent(); // notify on change vm.PropertyChanged += AltimeterChanged; vm.PropertyChanged += AirSpeedChanged; vm.PropertyChanged += HeadingChanged; vm.PropertyChanged += YawChanged; vm.PropertyChanged += PitchChanged; vm.PropertyChanged += RollChanged; }
public JsonResult GetList(DataTableViewModel objReq) { try { int LoginID = GetLogin(); if (LoginID > 0) { DataTableResponse <WS_SchedulerModel> objResp = new DataTableResponse <WS_SchedulerModel>(); //IQueryable<BlueNileDiscountModel> query = this.objSvc.GetBlueNileDiscountQueryable(); IQueryable <WS_SchedulerModel> query = this.objSchedulerService.SchedulerList(); objResp.recordsTotal = query.Count(); for (int i = 0; i < objReq.order.Count; i++) { int idx = Convert.ToInt32(objReq.order[i].column); switch (objReq.columns[idx].data) { case "WSID": if (objReq.order[i].dir == "asc") { query = query.OrderBy(x => x.WSID); } else { query = query.OrderByDescending(x => x.WSID); } break; case "Name": if (objReq.order[i].dir == "asc") { query = query.OrderBy(x => x.Name); } else { query = query.OrderByDescending(x => x.Name); } break; } } objResp.draw = objReq.draw; objResp.recordsFiltered = query.Count(); objResp.data = query.Skip(objReq.start).Take(objReq.length).ToList(); return(Json(objResp)); } return(null); } catch (Exception ex) { ErrorLog.Log("SchedulerController", "GetList", ex); throw; } }
public JsonResult GetCertificatesAndAwardList(DataTableViewModel dataTableViewModel) { var data = _CertificatesAndAwardService.ListWithPaging( filter: x => x.UserId == CurrentUser.Id, orderBy: o => o.CreateDate, pageSize: dataTableViewModel.length, page: dataTableViewModel.start); //fix serilaize json >> var dataMapped = Mapper.Map <List <CertificatesAndAwardViewModel> >(data.EntityData); return(Json(new { data = dataMapped, recordsTotal = data.Count, recordsFiltered = data.Count }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetUserList(DataTableViewModel dataTableViewModel) { //query string filter string SearchLevel1Str = Request.QueryString["SearchLevel1"]; decimal?SearchLevel1 = !string.IsNullOrEmpty(SearchLevel1Str) ? decimal.Parse(SearchLevel1Str) as decimal? : null; string SearchLevel2Str = Request.QueryString["SearchLevel2"]; decimal?SearchLevel2 = !string.IsNullOrEmpty(SearchLevel2Str) ? decimal.Parse(SearchLevel2Str) as decimal? : null; string SearchLevel3Str = Request.QueryString["SearchLevel3"]; decimal?SearchLevel3 = !string.IsNullOrEmpty(SearchLevel3Str) ? decimal.Parse(SearchLevel3Str) as decimal? : null; string SearchLevel4Str = Request.QueryString["SearchLevel4"]; decimal?SearchLevel4 = !string.IsNullOrEmpty(SearchLevel4Str) ? decimal.Parse(SearchLevel4Str) as decimal? : null; string SearchUserCategoryStr = Request.QueryString["SearchUserCategory"]; decimal?SearchUserCategory = !string.IsNullOrEmpty(SearchUserCategoryStr) ? decimal.Parse(SearchUserCategoryStr) as decimal? : null; string SearchJobTitleStr = Request.QueryString["SearchJobTitle"]; decimal?SearchJobTitle = !string.IsNullOrEmpty(SearchJobTitleStr) ? decimal.Parse(SearchJobTitleStr) as decimal? : null; string SearchFirstName = Request.QueryString["SearchFirstName"]; string SearchLastName = Request.QueryString["SearchLastName"]; string SearchEmail = Request.QueryString["SearchEmail"]; //include multi properties with data var includeMultiProperties = new Expression <Func <ACT.Models.User, object> >[] { x => x.UserCategory, y => y.JobTitle, }; var data = _UserService.ListWithPaging( //filter filter: x => (SearchLevel1 == null || x.Level1Id == SearchLevel1) && (SearchLevel2 == null || x.Level2Id == SearchLevel2) && (SearchLevel3 == null || x.Level3Id == SearchLevel3) && (SearchLevel4 == null || x.Level4Id == SearchLevel4) && (SearchUserCategory == null || x.UserCategoryId == SearchUserCategory) && (SearchJobTitle == null || x.JobTitleId == SearchJobTitle) && x.FirstName.Contains(SearchFirstName) && x.LastName.Contains(SearchLastName) && x.Email.Contains(SearchEmail), //includeProperties includeProperties: includeMultiProperties, orderBy: o => o.Id, pageSize: dataTableViewModel.length, page: dataTableViewModel.start); //fix serilaize json >> var dataMapped = Mapper.Map <List <UserViewModel> >(data.EntityData); return(Json(new { data = dataMapped, recordsTotal = data.Count, recordsFiltered = data.Count }, JsonRequestBehavior.AllowGet)); }
public JsonResult GetQualificationList(DataTableViewModel dataTableViewModel) { var data = _QualificationService.ListWithPaging( filter: x => x.UserId == CurrentUser.Id, includeProperties: x => x.CientificDegree, orderBy: o => o.Year, pageSize: dataTableViewModel.length, page: dataTableViewModel.start); //fix serilaize json >> var dataMapped = Mapper.Map <List <QualificationViewModel> >(data.EntityData); return(Json(new { data = dataMapped, recordsTotal = data.Count, recordsFiltered = data.Count }, JsonRequestBehavior.AllowGet)); }
public DataTableViewModel GetAllOrders() { var result = new List <PlatformOrderViewModel>(); var context = new TicketHubContext(); var orderRepository = new GenericRepository <Order>(context); var orderDetailRepository = new GenericRepository <OrderDetail>(context); var temp = from o in orderRepository.GetAll() join od in orderDetailRepository.GetAll() on o.Id equals od.OrderId select new { Id = o.Id, OrderDate = o.OrderedDate, UserId = o.UserId, UserName = o.User.UserName, Price = od.Price, }; var group = from t in temp group t by new { t.Id, t.OrderDate, t.UserId, t.UserName } into g select new PlatformOrderViewModel { Id = g.Key.Id, UserId = g.Key.UserId, OrderDate = g.Key.OrderDate, UserName = g.Key.UserName, TotalPrice = g.Sum(x => x.Price) }; DataTableViewModel table = new DataTableViewModel(); table.data = new List <List <string> >(); foreach (var item in group) { List <string> dataInstance = new List <string>(); dataInstance.Add(item.Id.ToString()); dataInstance.Add(item.UserId); dataInstance.Add(item.UserName); dataInstance.Add(item.TotalPrice.ToString()); table.data.Add(dataInstance); } return(table); }
public JsonResult GetAllRows() { IEnumerable <OrderFlatViewModel> orders; orders = _orderService.GetAllOrders().Orders.ConvertToOrderFlatViewModels(); DataTableViewModel data = new DataTableViewModel(); data.draw = "1"; data.recordsTotal = orders.ToList().Count.ToString(); data.recordsFiltered = orders.ToList().Count.ToString(); data.data = orders.ToList <object>(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult _CategoriesList(int draw, int start = 0, int length = 2) { string search = Request.Form["search[value]"]; string order_by = Request.Form["columns[" + Request.Form["order[0][column]"] + "][data]"]; string order_dir = Request.Form["order[0][dir]"]; DataTableViewModel result = new DataTableViewModel(); result.draw = draw; result.data = servicesManager.VideoService.GetCategories(start, length, search, order_by, order_dir); result.recordsTotal = servicesManager.VideoService.GetOnlineCategoriesCount(); result.recordsFiltered = result.recordsTotal; return(Json(result)); }
public JsonResult GetAllRows() { IEnumerable <PosSimFlatViewModel> posSims; posSims = _posSimService.GetAllPosSims().PosSims.ConvertToPosSimFlatViewModels(); DataTableViewModel data = new DataTableViewModel(); data.draw = "1"; data.recordsTotal = posSims.ToList().Count.ToString(); data.recordsFiltered = posSims.ToList().Count.ToString(); data.data = posSims.ToList <object>(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllRows() { IEnumerable <MenuItemFlatViewModel> menuItems; menuItems = _menuItemService.GetAllMenuItems().MenuItems.ConvertToMenuItemFlatViewModels(); DataTableViewModel data = new DataTableViewModel(); data.draw = "1"; data.recordsTotal = menuItems.ToList().Count.ToString(); data.recordsFiltered = menuItems.ToList().Count.ToString(); data.data = menuItems.ToList <object>(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllRows() { IEnumerable <RoleFlatViewModel> roles; roles = _roleService.GetAllRoles().Roles.ConvertToRoleFlatViewModels(); DataTableViewModel data = new DataTableViewModel(); data.draw = "1"; data.recordsTotal = roles.ToList().Count.ToString(); data.recordsFiltered = roles.ToList().Count.ToString(); data.data = roles.ToList <object>(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllRows() { IEnumerable <CategoryFlatViewModel> categories; categories = _categoryService.GetAllCategories().Categories.ConvertToCategoryFlatViewModels(); DataTableViewModel data = new DataTableViewModel(); data.draw = "1"; data.recordsTotal = categories.ToList().Count.ToString(); data.recordsFiltered = categories.ToList().Count.ToString(); data.data = categories.ToList <object>(); return(Json(data, JsonRequestBehavior.AllowGet)); }
public JsonResult GetAllRows() { IEnumerable <CustomerDemographicFlatViewModel> customerDemographics; customerDemographics = _customerDemographicService.GetAllCustomerDemographics().CustomerDemographics.ConvertToCustomerDemographicFlatViewModels(); DataTableViewModel data = new DataTableViewModel(); data.draw = "1"; data.recordsTotal = customerDemographics.ToList().Count.ToString(); data.recordsFiltered = customerDemographics.ToList().Count.ToString(); data.data = customerDemographics.ToList <object>(); return(Json(data, JsonRequestBehavior.AllowGet)); }
// GET: api/NonConformite public HttpResponseMessage Get() { _nonConformiteRepository = new NonConformiteRepository(); Dictionary <string, string> DataTableParameters = new Dictionary <string, string>(); DataTableParameters = Request.GetQueryNameValuePairs().ToDictionary(kv => kv.Key, kv => kv.Value, StringComparer.OrdinalIgnoreCase); DataTableViewModel <NonConformite> DataTableViewModel = _nonConformiteRepository.GetFromParams(DataTableParameters); //DataTableViewModel.aaData = nonConformites; //DataTableViewModel.iTotalRecords = 1; //DataTableViewModel.iTotalDisplayRecords = 1; //DataTableViewModel.sEcho = int.Parse(dataTableParameters["sEcho"]); return(Request.CreateResponse(HttpStatusCode.OK, DataTableViewModel)); }
public JsonResult _UsersList(int draw, int start = 0, int length = 2) { string search = Request.Form["search[value]"]; string order_by = Request.Form["columns[" + Request.Form["order[0][column]"] + "][data]"]; string order_dir = Request.Form["order[0][dir]"]; DataTableViewModel result = new DataTableViewModel(); result.draw = draw; int total_count; result.data = servicesManager.AccountService.GetUsers(out total_count, start, length, search, order_by, order_dir); result.recordsTotal = total_count; result.recordsFiltered = total_count; return(Json(result)); }
public JsonResult GetPosTerminalDataTable(System.Int32 id) { DataTableViewModel data; GetPosReceiptOfDeliveryRequest request = new GetPosReceiptOfDeliveryRequest(); request.PosReceiptOfDeliveryId = id; PosReceiptOfDeliveryView posReceiptOfDelivery = _posReceiptOfDeliveryService.GetPosReceiptOfDelivery(request).PosReceiptOfDelivery; data = new DataTableViewModel(); data.draw = "1"; data.recordsTotal = posReceiptOfDelivery.PosTerminals.ToList().Count.ToString(); data.recordsFiltered = posReceiptOfDelivery.PosTerminals.ToList().Count.ToString(); data.data = posReceiptOfDelivery.PosTerminals.ConvertToDetailPosReceiptOfDeliveryPosTerminalDetailViews().ToList <object>(); return(Json(data, JsonRequestBehavior.AllowGet)); }