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