public ActionResult List(JqGridFilterModel opts)
{
var devices = new AccountService().GetLstClients();
if (devices.LstClients == null)
{
devices.LstClients = new List <ConnectionFullModel>();
}
var result = new
{
page = 1,
records = devices.LstClients.Count,
total = 1,
rows = devices.LstClients.Select(e => new
{
id = e.DeviceId,
cell = new
{
id = e.DeviceId,
Name = e.DeviceName,
e.StartDateTx,
e.EndDateTx,
e.Code
}
})
};
return(Json(result));
}
public ActionResult List(JqGridFilterModel opts)
{
using (var repository = new GenericRepository <Drs.Repository.Entities.Franchise>())
{
var result = repository.JqGridFindBy(opts, FranchiseInfoJson.Key, FranchiseInfoJson.Columns, (e => e.IsObsolete == false)
, FranchiseInfoJson.DynamicToDto);
return(Json(result));
}
}
public static string OrderBy(JqGridFilterModel opt)
{
if (opt.sord.Trim().ToLower() == JQGRID_DESC)
{
return(string.Format("{0} {1}", opt.sidx, SQL_DESC));
}
return(string.Format("{0} {1}", opt.sidx, SQL_ASC));
}
public ActionResult List(JqGridFilterModel opts)
{
using (var repository = new GenericRepository <ViewStoreCoverage>())
{
var result = repository.JqGridFindBy(opts, ViewStoreCoverageJson.Key, ViewStoreCoverageJson.Columns, (e => e.IsObsolete == false)
, ViewStoreCoverageJson.DynamicToDto);
return(Json(result));
}
}
public ActionResult List(JqGridFilterModel opts)
{
using (var repository = new GenericRepository <Drs.Repository.Entities.ViewOrderInfo>())
{
var result = repository.JqGridFindBy(opts, OrderInfoJson.Key, OrderInfoJson.Columns,
(e => !SettingsData.Constants.TrackConst.OrderStatusEnd.Contains(e.LastStatus)), OrderInfoJson.DynamicToDto);
return(Json(result));
}
}
public ActionResult OffLineList(JqGridFilterModel opts, int id)
{
var userId = User.Identity.GetUserId();
var extraFilter = User.IsInRole(RoleConstants.STORE_MANAGER) ? ExtraFilterOffline(id, userId) : ExtraFilterOffline(id);
StoreOfflineInfoDto.UtcTime = DateTime.UtcNow;
using (var repository = new GenericRepository <FranchiseStoreOffLine>())
{
var result = repository.JqGridFindBy(opts, StoreOfflineInfoJson.Key, StoreOfflineInfoJson.Columns, extraFilter
, StoreOfflineInfoJson.DynamicToDto);
return(Json(result));
}
}
public ActionResult List(JqGridFilterModel opts)
{
Expression <Func <ViewStoreInfo, bool> > extraFilter;
var userId = User.Identity.GetUserId();
if (User.IsInRole(RoleConstants.STORE_MANAGER))
{
extraFilter = (e => e.IsObsolete == false && e.ManagerUserId == userId);
}
else
{
extraFilter = (e => e.IsObsolete == false);
}
using (var repository = new GenericRepository <ViewStoreInfo>())
{
var result = repository.JqGridFindBy(opts, StoreInfoJson.Key, StoreInfoJson.Columns, extraFilter
, StoreInfoJson.DynamicToDto);
return(Json(result));
}
}
public JqGridResultModel JqGridFindBy <TEntityDto>(JqGridFilterModel opts, string sKey, string sColumns, Expression <Func <TEntity, bool> > extraFilter = null,
Func <dynamic, TEntityDto> dtoFunc = null)
{
try
{
var result = new JqGridResultModel();
var query = _dbSet as IQueryable <TEntity>;
if (query == null)
{
return(null);
}
if (opts._search)
{
var filterDyn = new JavaScriptSerializer().Deserialize <JqGridMultipleFilterModel>(opts.filters);
JqGridQueryWhere whereOpts = JqGridClause.ExpresionToExec(filterDyn);
query = query.Where(whereOpts.Query, whereOpts.ArrParams);
}
if (extraFilter != null)
{
query = query.Where(extraFilter);
}
if (string.IsNullOrWhiteSpace(opts.sidx) == false && string.IsNullOrWhiteSpace(opts.sord) == false)
{
query = query.OrderBy(JqGridClause.OrderBy(opts));
}
result.total = 0;
result.page = 1;
result.records = query.Count();
if (opts.page.HasValue && opts.rows.HasValue)
{
query = query.Skip((opts.page.Value - 1) * opts.rows.Value).Take(opts.rows.Value);
result.page = opts.page.Value;
result.total = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(result.records) / opts.rows.Value));
}
IEnumerable qSel = query.Select(string.Format("New({0})", sColumns));
if (qSel == null)
{
return(null);
}
var lstObj = qSel.Cast <dynamic>().ToList();
if (lstObj.Count == 0)
{
result.rows = new List <JqGridRowsModel>();
}
else
{
var prop = lstObj[0].GetType().GetProperty(sKey);
result.rows = lstObj.Select(e => new JqGridRowsModel
{
id = prop.GetValue(e),
cell = dtoFunc == null ? e : dtoFunc(e)
}).ToList();
}
return(result);
}
catch (Exception ex)
{
SharedLogger.LogError(ex, opts, sKey, sColumns);
return(null);
}
}
