public async Task <IViewComponentResult> InvokeAsync(EbFilterDialog paramDiv)
{
if (paramDiv != null)
{
ViewBag.HtmlHead = paramDiv.GetHead();
ViewBag.HtmlBody = paramDiv.GetHtml();
}
return(View());
}
public static DataSourceDataSetResponse ExecuteDataset(string RefId, int UserId, List <Param> Params, EbConnectionFactory ebConnectionFactory, IRedisClient Redis)
{
DataSourceDataSetResponse resp = new DataSourceDataSetResponse();
resp.Columns = new List <ColumnColletion>();
string _sql = string.Empty;
try
{
EbDataReader _ds = Redis.Get <EbDataReader>(RefId);
if (_ds == null)
{
List <EbObjectWrapper> result = EbObjectsHelper.GetParticularVersion(ebConnectionFactory.ObjectsDB, RefId);
_ds = EbSerializers.Json_Deserialize(result[0].Json);
if (_ds == null)
{
resp.ResponseStatus = new ResponseStatus {
Message = "DataReader is null.... RefId: " + RefId
};
return(resp);
}
Redis.Set <EbDataReader>(RefId, _ds);
}
if (_ds.FilterDialogRefId != string.Empty && _ds.FilterDialogRefId != null)
{
EbFilterDialog _dsf = Redis.Get <EbFilterDialog>(_ds.FilterDialogRefId);
if (_dsf == null)
{
List <EbObjectWrapper> result = EbObjectsHelper.GetParticularVersion(ebConnectionFactory.ObjectsDB, _ds.FilterDialogRefId);
_dsf = EbSerializers.Json_Deserialize(result[0].Json);
Redis.Set <EbFilterDialog>(_ds.FilterDialogRefId, _dsf);
}
if (Params == null)
{
Params = _dsf.GetDefaultParams();
}
}
IDatabase MyDataStore = _ds.GetDatastore(ebConnectionFactory);
if (_ds != null)
{
string _c = string.Empty;
_sql = _ds.Sql;
}
try
{
IEnumerable <DbParameter> parameters = DataHelper.GetParams(MyDataStore, false, Params, 0, 0);
resp.DataSet = MyDataStore.DoQueries(_sql, parameters.ToArray <System.Data.Common.DbParameter>());
foreach (EbDataTable dt in resp.DataSet.Tables)
{
resp.Columns.Add(dt.Columns);
}
//if (GetLogEnabled(RefId))
//{
// TimeSpan T = resp.DataSet.EndTime - resp.DataSet.StartTime;
// InsertExecutionLog(resp.DataSet.RowNumbers, T, resp.DataSet.StartTime, UserId, Params, RefId);
//}
}
catch (Exception e)
{
resp.ResponseStatus = new ResponseStatus {
Message = e.Message
};
Console.WriteLine("DataSourceDataSetResponse------" + e.StackTrace);
Console.WriteLine("DataSourceDataSetResponse------" + e.Message);
}
}
catch (Exception e)
{
Console.WriteLine(e.Message + "\n" + e.StackTrace);
}
return(resp);
}
