private void GetData(string sql, Dictionary <string, ObjData> arrAllReturnData, out Dictionary <string, ObjData> arrAllReturnDataout)
{
using (DataManager.Current.OpenConnection())
{
SqlCommand searchEngineCmd = DataManager.CreateCommand(ConfigurationSettings.AppSettings["EdgeBI.Web.DataServices.MeasureDataService.Commands.GetData"].ToString(), CommandType.StoredProcedure);
searchEngineCmd.CommandTimeout = (60 * 1000) * 5;
searchEngineCmd.Parameters["@Sql"].Value = sql;
SqlDataReader reader = searchEngineCmd.ExecuteReader();
while (reader.Read())
{
ObjData _Data;
if (arrAllReturnData.ContainsKey(reader["ID"].ToString()))
{
_Data = arrAllReturnData[reader["ID"].ToString()];
}
else
{
_Data = new ObjData();
if (!reader["ID"].Equals(System.DBNull.Value))
{
_Data.ID = Convert.ToInt64(reader["ID"]);
}
if (!reader["NAME"].Equals(System.DBNull.Value))
{
_Data.Name = (string)reader["Name"];
}
}
for (int i = 2; i < reader.FieldCount; i++)
{
ObjValue _value = new ObjValue();
_value.FieldName = reader.GetName(i).ToString();
if (!reader[_value.FieldName].Equals(System.DBNull.Value))
{
_value.ValueData = Convert.ToString(reader[_value.FieldName]);
}
if (_Data.Values == null)
{
_Data.Values = new List <ObjValue>();
}
_Data.Values.Add(_value);
}
if (arrAllReturnData.ContainsKey(reader["ID"].ToString()))
{
arrAllReturnData[reader["ID"].ToString()] = _Data;
}
else
{
arrAllReturnData.Add(reader["ID"].ToString(), _Data);
}
}
reader.Close();
}
arrAllReturnDataout = arrAllReturnData;
}
private ObjData GetDataObject(List <ObjData> AllReturnData, Int64 Key)
{
ObjData RetEntity = new ObjData();
foreach (ObjData Entity in AllReturnData)
{
if (Entity.ID == Key)
{
RetEntity = Entity;
break;
}
}
return(RetEntity);
}
private void GetFormateData(out List <ObjData> dataout, List <ObjData> datain)
{
List <ObjData> data = new List <ObjData>();
foreach (ObjData d in datain)
{
ObjData rd = new ObjData();
foreach (ObjValue value in d.Values)
{
if (rd.Values == null)
{
rd.Values = new List <ObjValue>();
}
if (!value.FieldName.Contains(".Diff") && value.ValueData != null)
{
string StringFormat = DicMeasuresFormat[value.FieldName];
if (StringFormat.Contains("C"))
{
string MinusSign = "";
if (Convert.ToDouble(value.ValueData) < 0)
{
MinusSign = "-";
}
int NativeValue = decimal.ToInt32(Convert.ToDecimal(value.ValueData));
if (NativeValue < 0)
{
NativeValue = NativeValue * -1;
}
value.ValueData = string.Format("{0:" + StringFormat + "}", Convert.ToDouble(value.ValueData));
value.ValueData = value.ValueData.Replace(Convert.ToString(NativeValue), MinusSign + Convert.ToString(NativeValue));
}
if (StringFormat.Contains("$"))
{
int NativeValue = decimal.ToInt32(Convert.ToDecimal(value.ValueData));
if (NativeValue < 0)
{
NativeValue = NativeValue * -1;
}
value.ValueData = string.Format("{0:" + StringFormat + "}", Convert.ToDouble(value.ValueData));
}
else
{
value.ValueData = string.Format("{0:" + StringFormat + ";" + StringFormat + ";0}", Convert.ToDouble(value.ValueData));
}
}
else if (value.FieldName.Contains(".Diff") && value.ValueData != null)
{
if (value.FieldName.Contains(".DiffAbs"))
{
value.ValueData = string.Format("{0:" + ConfigurationSettings.AppSettings["EdgeBI.Web.DataServices.MeasureDataService.Formating.Diff.Abs"].ToString() + "}", Convert.ToDouble(value.ValueData));//"{0:0.##}"
}
else if (value.FieldName.Contains(".DiffRel"))
{
value.ValueData = string.Format("{0:" + ConfigurationSettings.AppSettings["EdgeBI.Web.DataServices.MeasureDataService.Formating.Diff.Rel"].ToString() + "}", Convert.ToDouble(value.ValueData));//"{0:0.##}"
}
}
rd.ID = d.ID;
rd.Name = d.Name;
rd.Values.Add(value);
}
data.Add(rd);
}
dataout = data;
}
