public ResponseObjectPackage<Dictionary> GetDictionaryViewModel(int dictionaryID)
{
DictionaryModel dict = this.GetDictionaryByID(dictionaryID).GetDataOrExceptionIfError();
List<DictionaryField> fields = new DictionaryFieldsLogic().GetDictionaryFieldsViewModel(dictionaryID).GetDataOrExceptionIfError();
Dictionary dictionary = new Dictionary(dict, fields);
return new ResponseObjectPackage<Dictionary>() { resultData = dictionary };
}
public JsonResult GetDictionaryFieldsViewModel(int dictionaryID)
{
try
{
ResponseObjectPackage<List<DictionaryField>> result = new DictionaryFieldsLogic().GetDictionaryFieldsViewModel(dictionaryID);
return Json(result);
}
catch (Exception ex)
{
return this.HandleException(ex);
}
}
public ResponseObjectPackage<List<Dictionary<string, object>>> GetDictionaryData(int dictionaryID)
{
DictionaryModel dictionary = new DictionariesLogic().GetDictionaryByID(dictionaryID).GetDataOrExceptionIfError();
List<DictionaryFieldModel> fields = new DictionaryFieldsLogic().GetDictionaryFieldsByDictionaryID(dictionaryID).GetDataOrExceptionIfError();
string sql = string.Format(
"select {0} " +
"from {1};",
string.Join(", ", fields.Select(e => e.columnName)),
dictionary.tableName
);
RequestPackage request = new RequestPackage() { requestString = sql };
ResponseObjectPackage<List<Dictionary<string, object>>> response = new DBUtils().RunSqlAction(new DynamicCRUD().GetDictionaryData, request);
return response;
}