/// <summary>
/// AJAX request, retrieves data for basic grid
/// </summary>
/// <param name="gridSettings">Settings received from jqGrid request</param>
/// <returns>JSON view containing data for basic grid</returns>
public ActionResult GridDataBasic(GridSettings gridSettings)
{
var customers = _repo.GetCustomers(gridSettings);
var totalCustomers = _repo.CountCustomers(gridSettings);
var jsonData = new
{
total = totalCustomers / gridSettings.PageSize + 1,
page = gridSettings.PageIndex,
records = totalCustomers,
rows = (
from c in customers
select new
{
id = c.CustomerId, // Remove ravendb prefix from identifier
cell = new[]
{
c.CustomerId,
c.Fullname,
c.Company,
c.EmailAddress,
c.LastModified.ToShortDateString(),
c.Telephone
}
}).ToArray()
};
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
/// <summary>
/// Add a new grid
/// </summary>
/// <param name="gridSettings">Grid settings</param>
public void Add(GridSettings gridSettings)
{
int gridId = 0;
db.Grid.Add(gridSettings.GridName,
gridSettings.GameTypeId,
gridSettings.TreatmentTypeId,
gridSettings.RoundCount,
gridSettings.X,
gridSettings.Y,
gridSettings.PlayerCount,
gridSettings.BotCount,
gridSettings.FillFactor,
gridSettings.LowerThreshold,
gridSettings.UpperThreshold,
gridSettings.HighPayoff,
gridSettings.LowPayoff,
gridSettings.NoiseLevel,
gridSettings.RandomSeed,
gridSettings.ExchangeRate,
gridSettings.IntroTimer,
gridSettings.RoundTimer,
gridSettings.SummaryTimer,
gridSettings.EntryGrid,
gridSettings.ExitGrid,
gridSettings.PlayedMGames,
gridSettings.PlayedTGames,
gridSettings.Chained,
out gridId);
}
/// <summary>
/// AJAX request, retrieves data for basic grid
/// </summary>
/// <param name="gridSettings">Settings received from jqGrid request</param>
/// <returns>JSON view containing data for basic grid</returns>
public ActionResult GridDataBasic(GridSettings gridSettings)
{
var customers = _repo.GetCustomers(gridSettings);
var totalCustomers = _repo.CountCustomers(gridSettings);
var jsonData = new
{
total = totalCustomers / gridSettings.PageSize + 1,
page = gridSettings.PageIndex,
records = totalCustomers,
rows = (
from c in customers
select new
{
id = c.CustomerID,
cell = new[]
{
c.CustomerID.ToString(),
string.Format("{0} {1}", c.FirstName, c.LastName),
c.CompanyName,
c.EmailAddress,
c.ModifiedDate.ToShortDateString(),
c.Phone
}
}).ToArray()
};
return Json(jsonData, JsonRequestBehavior.AllowGet);
}
public void Grid_GridSettingsNotNull_GridMarkup()
{
var html = new HtmlHelper(new ViewContext(), new ViewDataContainer());
var gs = new GridSettings();
MvcHtmlString grid = html.Grid(gs);
Assert.AreEqual(gs.ToString(), grid.ToString());
}
protected void ObtenerFiltros(GridSettings settings, ControllerContext controllerContext)
{
if (settings.Where == null)
{
settings.Where = new GridFilter();
List<GridRule> rules = new List<GridRule>();
settings.Where.rules = rules.ToArray();
}
}
public int CountCustomers(GridSettings gridSettings)
{
var customers = _dataContext.Customers.AsQueryable();
if (gridSettings.IsSearch)
{
customers = gridSettings.Where.rules.Aggregate(customers, FilterCustomers);
}
return customers.Count();
}
public IList <Customer> GetCustomers(GridSettings gridSettings)
{
var orderedCustomers = OrderCustomers(Customers, gridSettings.SortColumn, gridSettings.SortOrder);
if (gridSettings.IsSearch)
{
orderedCustomers = gridSettings.Where.rules.Aggregate(orderedCustomers, FilterCustomers);
}
return(orderedCustomers.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize).ToList());
}
public JsonResult ConsultarGrid(GridSettings gridSettings)
{
int qtdRegistros;
var situacaoVPD = new Rule()
{
field = "Situacao", data = "A"
};
var unidadeGestoraEmitente = new Rule()
{
field = "UnidadeGestoraCodigoEmitente", data = ExercicioAnoSessao.Sessao.UnidadeGestoraAtual.Value.ToString()
};
if (gridSettings.Where == null)
{
gridSettings.Where = new MVC.Util.Filter()
{
rules = new Rule[] { situacaoVPD, unidadeGestoraEmitente }
}
}
;
else
{
var regras = gridSettings.Where.rules.ToList();
if (!ExercicioAnoSessao.Sessao.EhUsuarioSemac && !regras.Any(el => el.field == "UnidadeGestoraCodigoEmitente"))
{
regras.Add(unidadeGestoraEmitente);
}
regras.Add(situacaoVPD);
gridSettings.Where.rules = regras.ToArray();
}
var lista = documentoDA.GridObterVPDPrevia(gridSettings, out qtdRegistros);
var list = lista.AsEnumerable()
.Select(d => new GridRow
{
id = d.DocumentoID,
cell = new object[]
{
d.DocumentoID,
d.Numero,
d.DataEmissao.ToString("dd/MM/yyyy"),
d.UnidadeGestora.UnidadeGestoraCodigo + " - " + d.UnidadeGestora.Nome,
d.Credor != null ? d.Credor.CredorIdentificacao + " - " + d.Credor.Nome : string.Empty,
d.ValorDocumento.ToString("N2"),
d.ItemVariacaoPatrimonialDiminutiva.Select(x => new { TipoVPD = x.TipoVPD.Equals("A") ? "Prévia" : "Posterior" }).Select(x => x.TipoVPD).FirstOrDefault(),
d.Documento2 != null ? d.Documento2.Numero : string.Empty,
}
});
return(list.Retornar(gridSettings, qtdRegistros));
}
public List <AppointmentCategoryDTO> GetAll(GridSettings gridSettings)
{
try
{
return(appointmentCategoryRepository.GetAll(gridSettings).ToList());
}
catch (Exception e)
{
throw e;
}
}
public string GetEmbroideryFirmPricingGridData(GridSettings grid, Guid EmbroideryFirmId)
{
try
{
return(new EmbroideryFirmPriceSettingsBL().GetGridData(grid, EmbroideryFirmId));
}
catch (Exception ex)
{
return("");
}
}
public string GetGridData(GridSettings grid)
{
try
{
return(new EmbroideryFirmBL().GetGridData(grid));
}
catch (Exception ex)
{
return("");
}
}
public IList<Customer> GetCustomers(GridSettings gridSettings)
{
var orderedCustomers = OrderCustomers(Customers, gridSettings.SortColumn, gridSettings.SortOrder);
if (gridSettings.IsSearch)
{
orderedCustomers = gridSettings.Where.rules.Aggregate(orderedCustomers, FilterCustomers);
}
return orderedCustomers.Skip((gridSettings.PageIndex - 1)*gridSettings.PageSize).Take(gridSettings.PageSize).ToList();
}
public ActionResult DynamicGridData(GridSettings gridData)
{
//get data from user and map with value injecter to view model
IQueryable <UserViewModel> userViewModel = _userService.GetAll().AsQueryable().Select(c => new UserViewModel().InjectFrom(c)).Cast <UserViewModel>();
if (gridData.IsSearch)
{
if (gridData.Where.groupOp == "AND")
{
foreach (var rule in gridData.Where.rules)
{
userViewModel = userViewModel.Where <UserViewModel>(
rule.field, rule.data,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
}
}
else
{
var temp = new List <UserViewModel>().AsQueryable();
foreach (var rule in gridData.Where.rules)
{
var t = userViewModel.Where <UserViewModel>(
rule.field, rule.data,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
temp = temp.Concat <UserViewModel>(t);
}
userViewModel = temp.Distinct <UserViewModel>();
}
userViewModel = userViewModel.OrderBy <UserViewModel>(gridData.SortColumn, gridData.SortOrder);
}
int pageIndex = Convert.ToInt32(gridData.PageIndex) - 1;
int pageSize = gridData.PageSize;
int totalRecords = userViewModel.Count();
int totalPages = (int)Math.Ceiling((float)totalRecords / (float)pageSize);
var jsonData = new
{
total = totalPages,
page = pageIndex,
records = totalRecords,
rows = (from model in userViewModel
select new
{
i = model.UserId,
cell = new string[] { model.UserId.ToString(), model.UserName, model.Email }
}).ToArray()
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public List <UserDTO> GetAll(GridSettings gridSettings)
{
try
{
return(userRepository.GetAll(gridSettings).ToList());
}
catch (Exception e)
{
throw e;
}
}
private IEnumerable <Customer> GetData(GridSettings grid, out int totalRecords, bool allData = false)
{
IEnumerable <Customer> data;
var query = _customerRepository.GetAll();
//filtring
if (grid.Where != null)
{
if (grid.Where.groupOp == "AND")
{
foreach (var rule in grid.Where.rules)
{
query = query.Where(rule.field, rule.data, (WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
}
}
else
{
//Or
var temp = (new List <Customer>()).AsQueryable();
foreach (var rule in grid.Where.rules)
{
var t = query.Where(
rule.field, rule.data,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
temp = temp.Concat(t);
}
//remove repeating records
query = temp.Distinct();
}
}
query = query.Where(c => c.UserType == UserType.Customer);
//sorting
if (!string.IsNullOrEmpty(grid.SortColumn))
{
query = query.OrderBy(grid.SortColumn, grid.SortOrder);
}
totalRecords = query.Count();
if (!allData)
{
data = query.Skip((grid.PageIndex - 1) * grid.PageSize).Take(grid.PageSize);
}
else
{
data = query.AsEnumerable().ToList();
}
return(data);
}
/// <summary>
/// 分页的数据
/// </summary>
/// <returns></returns>
public JsonResult GetData(GridSettings setting)
{
string requestStringPar = Request["customPar"];
string page = Request["page"]; //当前页
string rows = Request["rows"]; //每页显示
int pageIndex = Convert.ToInt32(page); //当前页
int rowsint = Convert.ToInt32(rows);
//过滤参数
List <CommonSearchModel> parasD = null;
if (!string.IsNullOrEmpty(requestStringPar))
{
parasD = JsonConvert.DeserializeObject <List <CommonSearchModel> >(requestStringPar);;
}
int records = SysDataHelper <T_Sys_Users> .ResultDataCount_New(parasD);
int total = (int)Math.Ceiling((float)records / (float)rowsint);
List <T_Sys_Users> usersList = null;
try
{
usersList = SysDataHelper <T_Sys_Users> .FindDataByPageFilter(parasD,
string.IsNullOrEmpty(setting.sortColumn)? "UserId" : setting.sortColumn + " " + setting.sortOrder, pageIndex, rowsint).ToList();
}
catch (Exception ex)
{
throw;
}
var jsonData = new
{
total = total,
page = pageIndex,
records = records,
rows = (
from sta in usersList
select new
{
i = sta.UserId,
cell = new object[]
{
sta.UserId,
sta.UserName,
sta.RealName,
sta.Email,
sta.Sex == 0?"男":"女",
sta.Tel,
DateTime.Parse(sta.CreateDate.ToString()).ToString("yyyy-MM-dd")
}
}
).ToArray()
};
return(Json(jsonData, JsonRequestBehavior.AllowGet));
}
public string GetGridData(GridSettings grid)
{
try
{
return(new UserBL().GetGridData(grid));
}
catch (Exception ex)
{
return("");
}
}
public string GetGridData(GridSettings grid)
{
try
{
return(new StudentBL().GetGridData(grid));
}
catch (Exception ex)
{
return(ex.Message);
}
}
public List <MedicalHistoryDTO> GetAll(GridSettings gridSettings)
{
try
{
return(medicalHistoryRepository.GetAll(gridSettings).ToList());
}
catch (Exception e)
{
throw e;
}
}
public List <PatientDTO> GetAll(GridSettings gridSettings)
{
try
{
return(patientRepository.GetAll(gridSettings).ToList());
}
catch (Exception e)
{
throw e;
}
}
public IList <Thuoc> GetThuocs(string maNhaThuoc, GridSettings gridSettings)
{
var orderedThuocs = OrderThuocs(GetMany(e => e.NhaThuoc.MaNhaThuoc == maNhaThuoc), gridSettings.SortColumn, gridSettings.SortOrder);
if (gridSettings.IsSearch)
{
orderedThuocs = gridSettings.Where.rules.Aggregate(orderedThuocs, FilterThuocs);
}
return(orderedThuocs.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize).ToList());
}
public GridController(GridView view, GridSettings settings)
{
_model = new GridModel(settings);
_view = view;
_view.InitializeGrid(_model.gridSettings);
_view.onCellPressed += OnCellPressed;
SpawnRoundBalls();
}
public IQueryable <Customer> GetCustomers(GridSettings gridSettings)
{
var customers = orderCustomers(_dataContext.Customers.AsQueryable(), gridSettings.SortColumn, gridSettings.SortOrder);
if (gridSettings.IsSearch)
{
customers = gridSettings.Where.rules.Aggregate(customers, FilterCustomers);
}
return(customers.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize));
}
public IQueryable<Customer> GetCustomers(GridSettings gridSettings)
{
var customers = orderCustomers(_dataContext.Customers.AsQueryable(), gridSettings.SortColumn, gridSettings.SortOrder);
if (gridSettings.IsSearch)
{
customers = gridSettings.Where.rules.Aggregate(customers, FilterCustomers);
}
return customers.Skip((gridSettings.PageIndex - 1) * gridSettings.PageSize).Take(gridSettings.PageSize);
}
private void buttonOK_Click(object sender, EventArgs e)
{
if (!this.ValidateChildren())
{
MessageBox.Show("Validation failed!\nPlease check all fields with red border!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
ResultSettings = CRV_TS_Converter.Save(this);
Close();
}
private static SortConfiguration PrepareSortSettings(
GridSettings gridSettings, SortConfiguration defaultSortSettings)
{
if (string.IsNullOrEmpty(gridSettings.SortColumn))
{
return(defaultSortSettings);
}
var sortMode = gridSettings.SortOrder == "asc" ? SortMode.Ascending : SortMode.Descending;
return(new SortConfiguration(gridSettings.SortColumn, sortMode));
}
private string[] getCondition(GridSettings objGrdSettings)
{
string WhereCondition = "";
string sOrderBy = "", sSearchString = "";
//for sorting
string orderBy = "";
string pagination = "";
if (!string.IsNullOrEmpty(objGrdSettings.SortColumn))
{
if (objGrdSettings.SortColumn.Contains("date") || objGrdSettings.SortColumn.ToLower().Contains("time"))
{
sOrderBy += string.Format(" CONVERT(VARCHAR, ISNULL({0},0), 101) ", objGrdSettings.SortColumn, objGrdSettings.SortOrder);
}
else
{
sOrderBy += string.Format(" CONVERT(VARCHAR, ISNULL({0},0)) {1} ", objGrdSettings.SortColumn, objGrdSettings.SortOrder);
}
orderBy = string.Format(" order by {0}", sOrderBy);
}
//for search
sSearchString = "";
WhereCondition += "where 1=1";
if (objGrdSettings.Where != null)
{
foreach (var item in objGrdSettings.Where.rules)
{
if (item.field.Contains("date") || item.field.ToLower().Contains("time"))
{
sSearchString += string.Format(" and convert(varchar, {0}, 101) like '{1}%' ", item.field, item.data);
}
else
{
sSearchString += string.Format(" and CONVERT(VARCHAR, ISNULL({0},0)) like '{1}%' ", item.field, item.data);
}
}
WhereCondition += string.Format("{0}", sSearchString);
}
// for paging
if (objGrdSettings.PageSize > 0)
{
pagination = string.Format(" where rowid BETWEEN {0} AND {1}", ((objGrdSettings.PageIndex - 1) * objGrdSettings.PageSize) + 1, (objGrdSettings.PageIndex * objGrdSettings.PageSize));
}
string[] filter = new string[3];
filter[0] = orderBy;
filter[1] = WhereCondition;
filter[2] = pagination;
return(filter);
}
/// ------------------------------------------------------------------------------------
protected override void OnColumnWidthChanged(DataGridViewColumnEventArgs e)
{
base.OnColumnWidthChanged(e);
AutoResizeColumnHeadersHeight();
ColumnHeadersHeight += 8;
if (!DesignMode)
{
GridSettings = GridSettings.Create(this);
}
}
public ActionResult SearchByPreProduct(MasterListSearchViewModel model, GridSettings gridSettings)
{
try
{
var results = _preProductDomain.SearchMaterialList(model.MasterCode, gridSettings);
return(Json(results.Data));
}
catch (Exception ex)
{
return(Json(new { Success = false, ex.Message }));
}
}
public GridModel(GridSettings settings)
{
gridSettings = settings;
grid = new int[gridSettings.size, gridSettings.size];
freeCells = new List <int>();
for (int i = 0; i < gridSettings.size * gridSettings.size; i++)
{
freeCells.Add(i);
}
}
public IActionResult PostGridSettings([FromBody] GridSettings gridSettings)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_uow.GridRepo.SetGridSettings(gridSettings);
_uow.SaveChanges();
return(Ok(gridSettings));
}
public ActionResult GetDataWindow2(SearchCriteriaModel model, GridSettings gridSettings)
{
var inputDate = !string.IsNullOrEmpty(model.StartDate) ? ConvertHelper.ConvertToDateTimeFull(model.StartDate) : DateTime.Now;
var dataDate = !string.IsNullOrEmpty(model.EndDate) ? ConvertHelper.ConvertToDateTimeFull(model.EndDate) : DateTime.Now;
var result = _cleanlinessDataInputDomain.SearchDataWindow1(inputDate, dataDate, model.Location, gridSettings);
if (!result.IsSuccess)
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
return(Json(result.Data, JsonRequestBehavior.AllowGet));
}
public IEnumerable <ClinicDTO> GetAll(GridSettings gridSettings)
{
IEnumerable <Clinic> clinicList = dbset.Where(x => string.IsNullOrEmpty(gridSettings.SearchText) ? true :
(x.Name.Contains(gridSettings.SearchText) ||
x.Address.Contains(gridSettings.SearchText)
));
gridSettings.RowsCount = clinicList.Count();
return(_mapper.Map <List <ClinicDTO> >(clinicList.OrderByDescending(m => m.CreationDate)
.Skip(gridSettings.PageSize * gridSettings.PageIndex)
.Take(gridSettings.PageSize)));
}
public List <M.Category> Get(GridSettings settings)
{
var list = _categoryRepo.GetAll().FullTextSearch(settings.Keyword);
var retVal = list.OrderBy(settings.OrderBy).Paginate(settings).Select(x => new M.Category()
{
ID = x.ID,
Name = x.Name
});
return(retVal.ToList());
}
//public string GetGridData(GridSettings grid, int JariCompanyId = 0)
//{
// try
// {
// using (var ctx = new DBAJEntities())
// {
// var query = ctx.vw_Users.AsQueryable();
// if (JariCompanyId != 0)
// {
// query = query.Where(k => k.JariCompanyId == JariCompanyId);
// }
// else
// {
// string RoleGroupName = Convert.ToString(En_Role_Group.AJ);
// List<int> lstRole = ctx.Roles.Where(r => r.RoleGroup == RoleGroupName).Select(r => r.RoleId).ToList();
// query = query.Where(u => lstRole.Contains(u.RoleId));
// }
// int count;
// var data = query.GridCommonSettings(grid, out count);
// var result = new
// {
// total = (int)Math.Ceiling((double)count / grid.PageSize),
// page = grid.PageIndex,
// records = count,
// rows = (from u in data
// select new
// {
// u.UserId,
// u.RoleId,
// u.JariCompanyId,
// u.FirstName,
// u.LastName,
// u.Email,
// u.Mobile,
// u.Phone,
// u.Password,
// u.Status,
// u.ModifiedBy,
// u.ModifiedOn,
// u.JariCompanyName,
// u.CreateDate,
// u.ActivationEndDate,
// u.RoleGroup,
// u.RoleName,
// Action = u.UserId
// }).ToArray()
// };
// return JsonConvert.SerializeObject(result, new IsoDateTimeConverter());
// }
// }
// catch (Exception ex)
// {
// throw ex;
// }
//}
public string GetGridData(GridSettings grid)
{
try
{
using (var ctx = new DBAJEntities())
{
var query = ctx.vw_Users.AsQueryable();
string RoleGroupName = Convert.ToString(En_Role_Group.Company);
List <int> lstRole = ctx.Roles.Where(r => r.RoleGroup == RoleGroupName).Select(r => r.RoleId).ToList();
query = query.Where(u => lstRole.Contains(u.RoleId));
int count;
var data = query.GridCommonSettings(grid, out count);
var result = new
{
total = (int)Math.Ceiling((double)count / grid.PageSize),
page = grid.PageIndex,
records = count,
rows = (from u in data
select new
{
u.UserId,
u.RoleId,
u.JariCompanyId,
u.FirstName,
u.LastName,
u.Email,
u.Mobile,
u.Phone,
u.Password,
u.Status,
u.ModifiedBy,
u.ModifiedOn,
u.JariCompanyName,
u.CreateDate,
u.ActivationEndDate,
u.RoleGroup,
u.RoleName,
Action = u.UserId
}).ToArray()
};
return(JsonConvert.SerializeObject(result, new IsoDateTimeConverter()));
}
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <ActionResult> Search(SearchCriteriaRequest model, GridSettings gridSettings)
{
var result = await ExecuteSearch(model, gridSettings);
if (!result.IsSuccess)
{
return(Json(null, JsonRequestBehavior.AllowGet));
}
var response = Mapper.Map <GridResponse <CategoryListingWebModel> >(result.Data);
return(Json(response, JsonRequestBehavior.AllowGet));
}
public IEnumerable <AppointmentAdditionDTO> GetAll(GridSettings gridSettings)
{
double.TryParse(gridSettings.SearchText, out double price);
IEnumerable <AppointmentAddition> appointmentAdditionList = dbset.Where(x => string.IsNullOrEmpty(gridSettings.SearchText) ? true :
(x.Name.Contains(gridSettings.SearchText) ||
x.Price == price
));
gridSettings.RowsCount = appointmentAdditionList.Count();
return(_mapper.Map <List <AppointmentAdditionDTO> >(appointmentAdditionList.OrderByDescending(m => m.CreationDate)
.Skip(gridSettings.PageSize * gridSettings.PageIndex)
.Take(gridSettings.PageSize)));
}
public List <ClinicDTO> Delete(ClinicDTO clinic, GridSettings gridSettings)
{
try
{
clinicRepository.Delete(clinic);
UoW.SaveChanges();
}
catch (Exception e)
{
throw e;
}
return(GetAll(gridSettings));
}
public GridResult<Ensayo> ReadEnsayo(GridSettings grid)
{
return EnsayoRepository.ReadEnsayo(grid);
}
public GridResult<Lote> ReadLote(GridSettings grid)
{
return LoteRepository.ReadLote(grid);
}
public GridResult<Perfil> ReadPerfil(GridSettings grid)
{
return PerfilRepository.ReadPerfil(grid);
}
public GridResult<Equipo> ReadEquipo(GridSettings grid)
{
return EquipoRepository.ReadEquipo(grid);
}
public GridResult<Usuario> ReadUsuario(GridSettings grid)
{
return UsuarioRepository.ReadUsuario(grid);
}
public GridResult<Producto> ReadProducto(GridSettings grid)
{
return ProductoRepository.ReadProducto(grid);
}
/// <summary>
/// Called when deserializing
/// </summary>
/// <param name="info"></param>
/// <param name="context"></param>
protected EditorSceneSettings(SerializationInfo info, StreamingContext context)
{
_vLuxSettingsFile = info.GetString("_vLuxSettingsFile");
_bUseDefaultvLuxSettingsFile = info.GetBoolean("_bUseDefaultvLuxSettingsFile");
if (SerializationHelper.HasElement(info,"_shapeOrigin"))
_shapeOrigin = (Vector3F)info.GetValue("_shapeOrigin", typeof(Vector3F));
if (SerializationHelper.HasElement(info,"_cameraPosition"))
_cameraPosition = (Vector3F)info.GetValue("_cameraPosition", typeof(Vector3F));
if (SerializationHelper.HasElement(info,"_cameraAngles"))
_cameraAngles = (Vector3F)info.GetValue("_cameraAngles", typeof(Vector3F));
if (SerializationHelper.HasElement(info,"_description"))
_OLDdescription = info.GetString("_description");
if (SerializationHelper.HasElement(info,"_showDescAtStartup"))
_showDescAtStartup = info.GetBoolean("_showDescAtStartup");
if (SerializationHelper.HasElement(info,"_gridSettings"))
_gridSettings = (GridSettings)info.GetValue("_gridSettings", typeof(GridSettings));
if (SerializationHelper.HasElement(info, "_exportProfileName"))
_exportProfileName = info.GetString("_exportProfileName");
if (SerializationHelper.HasElement(info, "_autoSaveExportProfile"))
_autoSaveExportProfile = info.GetBoolean("_autoSaveExportProfile");
if (SerializationHelper.HasElement(info, "_screenshotSettings"))
{
_screenshotSettings = info.GetValue("_screenshotSettings", typeof(ScreenshotSettings)) as ScreenshotSettings;
}
else
{
_screenshotSettings = new ScreenshotSettings();
}
// the following settings are now in export profiles. Load them here for backwards compatibility
if (PATCH_PROFILE != null) ///...but only if no dedicated profile name has been loaded
{
if (SerializationHelper.HasElement(info, "_exportPath"))
CurrentProfile.ExportPath = info.GetString("_exportPath");
if (SerializationHelper.HasElement(info, "_bRunAfterExport"))
CurrentProfile.RunAfterExport = info.GetBoolean("_bRunAfterExport");
if (SerializationHelper.HasElement(info, "_exportedLayerNames"))
CurrentProfile.ExportedLayerNames = (StringCollection)info.GetValue("_exportedLayerNames", typeof(StringCollection));
if (SerializationHelper.HasElement(info, "_bIncludeVisibilityInfo"))
CurrentProfile.IncludeVisibilityInfo = info.GetBoolean("_bIncludeVisibilityInfo");
if (SerializationHelper.HasElement(info, "_bEmbedCustomLitFile"))
CurrentProfile.EmbedCustomLitFile = info.GetBoolean("_bEmbedCustomLitFile");
}
}
public JsonResult GetData(GridSettings grid)
{
//GridSettings grid = new GridSettings();
// Get the ObjectContext related to this DbContext
//var objectContext = (this as IObjectContextAdapter).ObjectContext;
//objectContext.CommandTimeout = 120;
// var query = _repository.PlanFactLists();
using (var context = new CMER_DWEnt())
{
var query = context.vwPlanFactLists.AsQueryable();
//filtring
if (grid.IsSearch)
{
if (grid.Where != null)
{
//And
if (grid.Where.groupOp == "AND")
foreach (var rule in grid.Where.rules)
query = query.Where<vwPlanFactLists>(
rule.field, rule.data,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
else
{
//Or
var temp = (new List<vwPlanFactLists>()).AsQueryable();
foreach (var rule in grid.Where.rules)
{
var t = query.Where<vwPlanFactLists>(
rule.field, rule.data,
(WhereOperation)StringEnum.Parse(typeof(WhereOperation), rule.op));
temp = temp.Concat<vwPlanFactLists>(t);
}
//remove repeating records
query = temp.Distinct<vwPlanFactLists>();
}
}
}
//sorting
query = query.OrderBy<vwPlanFactLists>(grid.SortColumn,
grid.SortOrder);
//count
var count = 17862269; //query.Count();
//paging
var data = query.Skip((grid.PageIndex - 1) * grid.PageSize).Take(grid.PageSize).ToArray();
//converting in grid format
var result = new
{
total = (int)Math.Ceiling((double)count / grid.PageSize),
page = grid.PageIndex,
records = count,
rows = (data).ToArray()
};
//convert to JSON and return to client
return Json(result, JsonRequestBehavior.AllowGet);
}
}
public ActionResult Manage(GridSettings settings)
{
var model = _repository.FindAll().ToList();
return View(model);
}
public int CountCustomers(GridSettings gridSettings)
{
return gridSettings.IsSearch ? gridSettings.Where.rules.Aggregate(Customers, FilterCustomers).Count() : Customers.Count();
}
public GridResult<Planta> ReadPlanta(GridSettings grid)
{
return PlantaRepository.ReadPlanta(grid);
}
public GridResult<Proveedor> ReadProveedor(GridSettings grid)
{
return ProveedorRepository.ReadProveedor(grid);
}
public GridResult<ResultadoDetalle> ReadResultadoDetalle(GridSettings grid)
{
return ResultadoDetalleRepository.ReadResultadoDetalle(grid);
}
public GridResult<Especificacion> ReadEspecificacion(GridSettings grid)
{
return EspecificacionRepository.ReadEspecificacion(grid);
}
public GridResult<Calibracion> ReadCalibracion(GridSettings grid)
{
return CalibracionRepository.ReadCalibracion(grid);
}
public GridResult<Silo> ReadSilo(GridSettings grid)
{
return SiloRepository.ReadSilo(grid);
}
public GridResult<Color> ReadColor(GridSettings grid)
{
return ColorRepository.ReadColor(grid);
}
public GridResult<SystemLog> ReadLog(GridSettings grid)
{
return SystemLogRepository.ReadLog(grid);
}
public GridResult<Resultado> ReadResultado(GridSettings grid)
{
return ResultadoRepository.ReadResultado(grid);
}
public GridResult<Menu> ReadMenu(GridSettings grid)
{
return MenuRepository.ReadMenu(grid);
}
public GridResult<NormaEnsayoValorIn> ReadNormaIn(GridSettings grid)
{
return NormaEnsayoValorInRepository.ReadNormaIn(grid);
}
public GridResult<NormaProducto> ReadNormaProducto(GridSettings grid)
{
return NormaProductoRepository.ReadNormaProducto(grid);
}
