public object ExecuteDataReader(EbApi Api) { EbDataSet dataSet; try { EbDataReader dataReader = Api.GetEbObject <EbDataReader>(this.Reference, Api.Redis, Api.ObjectsDB); List <DbParameter> dbParameters = new List <DbParameter>(); List <Param> InputParams = dataReader.GetParams((RedisClient)Api.Redis); Api.FillParams(InputParams); foreach (Param param in InputParams) { dbParameters.Add(Api.DataDB.GetNewParameter(param.Name, (EbDbTypes)Convert.ToInt32(param.Type), param.ValueTo)); } dataSet = Api.DataDB.DoQueries(dataReader.Sql, dbParameters.ToArray()); } catch (Exception ex) { throw new ApiException("[ExecuteDataReader], " + ex.Message); } return(dataSet); }
public override List <string> DiscoverRelatedRefids() { List <string> refids = new List <string>(); if (!DataSourceRefId.IsEmpty()) { EbDataReader ds = EbDataSource; if (ds is null) { refids.Add(DataSourceRefId); } } foreach (DVBaseColumn _col in Columns) { if (!_col.LinkRefId.IsNullOrEmpty()) { refids.Add(_col.LinkRefId); } if (!_col.GroupFormLink.IsNullOrEmpty()) { refids.Add(_col.GroupFormLink); } if (!_col.ItemFormLink.IsNullOrEmpty()) { refids.Add(_col.ItemFormLink); } if (_col is DVApprovalColumn && !(_col as DVApprovalColumn).FormRefid.IsNullOrEmpty()) { refids.Add((_col as DVApprovalColumn).FormRefid); } } return(refids); }
public string GetSql(Service service)// duplicate { EbDataReader dr = EbFormHelper.GetEbObject <EbDataReader>(this.DataSourceId, null, service.Redis, service); string Sql = dr.Sql.Trim(); if (Sql.LastIndexOf(";") == Sql.Length - 1) { Sql = Sql.Substring(0, Sql.Length - 1); } return(Sql); }
public override void FetchParamsMeta(IServiceClient ServiceClient, IRedisClient redis, EbControl[] Allctrls, Service service) { EbChartVisualization ChartVisualization = EbFormHelper.GetEbObject <EbChartVisualization>(TVRefId, ServiceClient, redis, service); if (string.IsNullOrEmpty(ChartVisualization.DataSourceRefId)) { throw new FormException($"Missing Data Reader of Chart control view that is connected to {this.Label}."); } EbDataReader DrObj = EbFormHelper.GetEbObject <EbDataReader>(ChartVisualization.DataSourceRefId, ServiceClient, redis, service); this.ParamsList = DrObj.GetParams(redis as RedisClient); }
public override void AfterRedisGet(RedisClient Redis) { try { this.EbDataSource = Redis.Get <EbDataReader>(this.DataSourceRefId); this.EbDataSource.AfterRedisGet(Redis); } catch (Exception e) { Console.WriteLine("Exception: " + e.ToString()); } }
public override List <string> DiscoverRelatedRefids() { List <string> _refids = new List <string>(); if (!DataSourceRefId.IsEmpty()) { EbDataReader ds = EbDataSource; if (ds is null) { _refids.Add(DataSourceRefId); } } return(_refids); }
public static string ExecuteDecrypt(String ciphertext, string KeyName, string Refid, EbApi Api, EncryptionAlgorithm EncryptionAlgorithm) { string pri_key = ""; string plaintext = ""; try { if (!String.IsNullOrEmpty(KeyName)) { pri_key = Api.Redis.Get <string>("privatekey_" + Api.SolutionId + "_" + KeyName); } if (String.IsNullOrEmpty(pri_key) && !String.IsNullOrEmpty(Refid)) { EbDataReader dataReader = Api.GetEbObject <EbDataReader>(Refid, Api.Redis, Api.ObjectsDB); List <DbParameter> dbParameters = new List <DbParameter> { Api.DataDB.GetNewParameter("keyname", EbDbTypes.String, KeyName) }; EbDataSet dataSet = Api.DataDB.DoQueries(dataReader.Sql, dbParameters.ToArray()); pri_key = dataSet.Tables?[0].Rows[0]["key"].ToString(); Api.Redis.Set <string>("privatekey_" + Api.SolutionId + "_" + KeyName, pri_key); } if (EncryptionAlgorithm == EncryptionAlgorithm.RSA) { plaintext = RSADecrypt(ciphertext, pri_key); } } catch (Exception ex) { throw new ApiException("[ExecuteEncrypt], " + ex.Message); } return(plaintext); }