public void GetCombinedFrequencyResults(EwavCombinedFrequencyGadgetParameters combinedParameters, string groupVar, GadgetParameters gadgetParameters, IEnumerable <EwavDataFilterCondition> ewavDataFilters, List <EwavRule_Base> rules, string filterString, Action <DatatableBag, Exception> completed)
{
_freqCompleted = completed;
freqCtx = new CombinedFrequencyDomainContext();
InvokeOperation <DatatableBag> freqResults = freqCtx.GenerateCombinedFrequency(combinedParameters, groupVar, gadgetParameters, ewavDataFilters, rules, filterString);
freqResults.Completed += new EventHandler(freqTableResults_Completed);
}
// TODO: Add properties using the mvvmprop code snippet
#endregion
#region Methods
public void GetCombinedFrequency(EwavCombinedFrequencyGadgetParameters combinedParameters, string groupVar, GadgetParameters gp)
{
this.serviceAgent.GetCombinedFrequencyResults(combinedParameters, groupVar, gp,
ApplicationViewModel.Instance.EwavDatafilters,
ApplicationViewModel.Instance.EwavDefinedVariables,
ApplicationViewModel.Instance.FilterString,
GetCombinedFrequencyCompleted);
}
// POST api/<controller>
public HttpResponseMessage Post([FromBody] JObject value)
{
CombinedFrequencyDomainService CFDS = new CombinedFrequencyDomainService();
HttpResponseMessage ReturnedObj = null;
GadgetParameters GadgetParameters = null;
ControllerCommon CommonClass = new ControllerCommon();
List <EwavRule_Base> Rules = new List <EwavRule_Base>();
JObject gadgetJSON = (JObject)value["gadget"];
CFDS = new CombinedFrequencyDomainService();
EwavCombinedFrequencyGadgetParameters CombinedParameters = new EwavCombinedFrequencyGadgetParameters();
CombinedParameters.CombineMode = (CombineModeTypes)Enum.Parse(typeof(CombineModeTypes), gadgetJSON["combinedmode"].ToString());
CombinedParameters.ShowDenominator = Convert.ToBoolean(gadgetJSON["showdenominator"].ToString());
CombinedParameters.SortHighToLow = Convert.ToBoolean(gadgetJSON["sort"].ToString());
CombinedParameters.TrueValue = (gadgetJSON["truevalue"].ToString().Trim().Length == 0 ? null : value["truevalue"].ToString());
GadgetParameters = new GadgetParameters();
GadgetParameters.DatasourceName = gadgetJSON["@DatasourceName"].ToString();
GadgetParameters.MainVariableName = gadgetJSON["mainVariable"].ToString();
GadgetParameters.InputVariableList = new Dictionary <string, string>();
GadgetParameters.InputVariableList.Add("tableName", gadgetJSON["@DatasourceName"].ToString());
GadgetParameters.TableName = CommonClass.GetDatabaseObject(GadgetParameters.DatasourceName);
string groupVar = gadgetJSON["mainVariable"].ToString();
List <EwavDataFilterCondition> dashboardFilters = new List <EwavDataFilterCondition>();
Rules = CommonClass.ReadRules(value);
dashboardFilters = CommonClass.GetFilters(value);
GadgetParameters.GadgetFilters = CommonClass.GetFilters(gadgetJSON, true);
DatatableBag dtBag = CFDS.GenerateCombinedFrequency(CombinedParameters, groupVar, GadgetParameters, dashboardFilters, Rules);
ReturnedObj = new HttpResponseMessage()
{
Content = new StringContent(Newtonsoft.Json.JsonConvert.SerializeObject(dtBag))
};
ReturnedObj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json");
return(ReturnedObj);
}
public DatatableBag GenerateCombinedFrequency(EwavCombinedFrequencyGadgetParameters combinedParameters, string groupVar, GadgetParameters gadgetParameters,
IEnumerable <EwavDataFilterCondition> ewavDataFilters, List <EwavRule_Base> rules, string filterString = "")
{
if (gadgetParameters.UseAdvancedDataFilter)
{
dh = new DashboardHelper(gadgetParameters, filterString, rules);
gadgetParameters.UseAdvancedDataFilter = true;
gadgetParameters.AdvancedDataFilterText = filterString;
}
else
{
dh = new DashboardHelper(gadgetParameters, ewavDataFilters, rules);
}
//DataTable dt = dh.GenerateCombinedBooleanFrequencyTable(groupVar, sortHighToLow, gadgetParameters, rules);
bool booleanResults = false;
int fields = -1;
int denominator = -1;
DataTable dt = dh.GenerateCombinedFrequencyTable(combinedParameters, groupVar, ref booleanResults, ref fields, ref denominator, gadgetParameters, rules);
if (dt != null)
{
DatatableBag dtBag = new DatatableBag(dt, "");
List <DictionaryDTO> DictionaryObject = new List <DictionaryDTO>();
DictionaryObject.Add(new DictionaryDTO()
{
Key = new MyString("booleanResults"), Value = new MyString(booleanResults.ToString())
});
DictionaryObject.Add(new DictionaryDTO()
{
Key = new MyString("fields"), Value = new MyString(fields.ToString())
});
DictionaryObject.Add(new DictionaryDTO()
{
Key = new MyString("denominator"), Value = new MyString(denominator.ToString())
});
dtBag.ExtraInfo = DictionaryObject;
return(dtBag);
}
else
{
throw new Exception("No Records found.");
}
}
