public ActionResult ListParams(int?CatalogId)
{
if (!User.Identity.IsAuthenticated)
{
return(AccessDeniedView());
}
var identity = ((CustomPrincipal)User).CustomIdentity;
var model = new DqParamListModel();
model.CATALOG_ID = CatalogId;
model.Catalogs = new SelectList(db.MdmCatalogs.Where(x => x.ENABLED == 1), "CATALOG_ID", "CATALOG_NAME").ToList();
//model.RegexList = new SelectList(db.MdmRegex, "REGEX_ID", "REGEX_NAME").ToList();
model.EntityList = new SelectList(db.EntityMast.Where(x => x.RECORD_STATUS == "1"), "ENTITY_ID", "ENTITY_NAME").ToList();
model.Dimensions = new SelectList(db.MDM_AGGR_DIMENSION, "DIMENSIONID", "DIMENSION_NAME").ToList();
model.Catalogs.Add(new SelectListItem
{
Value = "0",
Text = "All"
});
model.EntityList.Add(new SelectListItem
{
Value = "0",
Text = "All"
});
model.Dimensions.Add(new SelectListItem
{
Value = "0",
Text = "All",
Selected = true
});
//var weights = from Weights in db.MDM_WEIGHTS
// select new WeightsViewModel
// {
// WEIGHT_ID = Weights.WEIGHT_ID,
// WEIGHT_DESC = Weights.WEIGHT_DESC
// };
//model.Weights = weights.ToList();
PopulateWeights();
return(View(model));
}
public virtual ActionResult ListParams(DataSourceRequest command, DqParamListModel model, string sort, string sortDir)
{
//model.DQ_DIMENSION = 1;
var items = _dqParamService.GetAllEntities(model.SearchName, model.DQ_DIMENSION, model.ENTITY_ID, model.CATALOG_ID, command.Page - 1, command.PageSize, string.Format("{0} {1}", sort, sortDir));
//var logItems = _logger.GetAllLogs(createdOnFromValue, createdToFromValue, model.Message,
// logLevel, command.Page - 1, command.PageSize);
var gridModel = new DataSourceResult
{
Data = items.Select(c => new DqParamListModel
{
ENTITY_DETAIL_ID = c.ENTITY_DETAIL_ID,
ENTITY_ID = c.ENTITY_ID,
ENTITY_TAB_NAME = c.ENTITY_TAB_NAME,
ENTITY_COL_NAME = c.ENTITY_COL_NAME,
FLG_MANDATORY = c.FLG_MANDATORY,
WEIGHT_ID = c.WEIGHT_ID,
CREATED_BY = c.CREATED_BY,
//CREATED_DATE = c.CREATED_DATE,
LAST_MODIFIED_BY = c.LAST_MODIFIED_BY,
//LAST_MODIFIED_DATE = c.LAST_MODIFIED_DATE,
RECORD_STATUS = c.RECORD_STATUS,
REGEX = c.REGEX,
DEFAULT_VALUE = c.DEFAULT_VALUE,
COLUMN_ORDER = c.COLUMN_ORDER,
CATALOG_ID = c.CATALOG_ID,
USE_FOR_DQI = c.USE_FOR_DQI,
DQ_DIMENSION = c.DQ_DIMENSION,
WEIGHT_DESC = c.MDM_WEIGHTS.WEIGHT_DESC,
Weights = new WeightsViewModel()
{
WEIGHT_ID = c.MDM_WEIGHTS.WEIGHT_ID,
WEIGHT_DESC = c.MDM_WEIGHTS.WEIGHT_DESC
},
RegexCbo = new RegexsViewModel()
{
REGEX_ID = c.MdmRegex.REGEX_ID,
REGEX_NAME = c.MdmRegex.REGEX_NAME
},
DimsCbo = new DimensionsViewModel()
{
DIMENSIONID = c.MdmAggrDimensions.DIMENSIONID,
DIMENSION_NAME = c.MdmAggrDimensions.DIMENSION_NAME
},
CatalogsCbo = new CatalogsViewModel()
{
CATALOG_ID = c.MdmCatalog.CATALOG_ID,
CATALOG_NAME = c.MdmCatalog.CATALOG_NAME
},
//RECORD_ID = x.RECORD_ID,
//DATA_SOURCE = x.DATA_SOURCE,
//CATALOG_NAME = x.CATALOG_NAME,
//ERROR_DESC = x.ERROR_DESC,
//CREATED_DATE = x.CREATED_DATE
}),
Total = items.TotalCount
};
return(Json(gridModel));
}
