public DatatableBag ReadCanvasListForLite(string FormId, int UserId) { DataSet ds = cm.ReadCanvasListForLite(FormId, UserId); DatatableBag dtb = new DatatableBag(); return(dtb.ConvertToDatatableBag(ds.Tables[0])); }
/// <summary> /// Reads All the users in my org /// </summary> /// <param name="orgId"></param> /// <returns></returns> public DatatableBag ReadAllUsersInMyOrg(int orgId) { DataSet ds = cm.ReadAllUsersInMyOrg(orgId); DatatableBag dtb = new DatatableBag(); return(dtb.ConvertToDatatableBag(ds.Tables[0])); }
/// <summary> /// Loads Canvas List for User /// </summary> /// <param name="user"></param> /// <returns></returns> public DatatableBag LoadCanvasListForUser(int UserId) { DataSet ds = cm.LoadCanvasListForUser(UserId); DatatableBag dtb = new DatatableBag(); return(dtb.ConvertToDatatableBag(ds.Tables[0])); }
// POST api/<controller> public HttpResponseMessage Post([FromBody] JObject value) { UserDomainService UserDomainService = new Ewav.Web.Services.UserDomainService(); CanvasDomainService CanvasDomainService = new Ewav.Web.Services.CanvasDomainService.CanvasDomainService(); ControllerCommon Common = new Controllers.ControllerCommon(); DatatableBag dtb = null; UserDTO possibleUser = new UserDTO(); possibleUser.UserName = value["id"].ToString(); var pwd = value["password"].ToString(); string KeyForUserPasswordSalt = System.Configuration.ConfigurationManager.AppSettings["KeyForUserPasswordSalt"]; Ewav.PasswordHasher ph = new Ewav.PasswordHasher(KeyForUserPasswordSalt); string salt = ph.CreateSalt(possibleUser.UserName); possibleUser.PasswordHash = ph.HashPassword(salt, pwd); UserDTO returnedUser = UserDomainService.GetUserForAuthentication(possibleUser); if (returnedUser.UserID != -1) { UserDTO LoadedUser = UserDomainService.LoadUser(returnedUser.UserName); dtb = CanvasDomainService.LoadCanvasListForUser(LoadedUser.UserID); } List <CanvasDto> CanvasList = new List <CanvasDto>(); for (int i = 0; i < dtb.RecordList.Count; i++) { CanvasList.Add( new CanvasDto() { CanvasId = Convert.ToInt32(Common.GetValueAtRow(dtb, "CanvasID", dtb.RecordList[i])), CanvasName = Common.GetValueAtRow(dtb, "CanvasName", dtb.RecordList[i]), UserId = Convert.ToInt32(Common.GetValueAtRow(dtb, "UserID", dtb.RecordList[i])), CanvasDescription = Common.GetValueAtRow(dtb, "CanvasDescription", dtb.RecordList[i]), CreatedDate = Convert.ToDateTime(Common.GetValueAtRow(dtb, "CreatedDate", dtb.RecordList[i])), ModifiedDate = Convert.ToDateTime(Common.GetValueAtRow(dtb, "ModifiedDate", dtb.RecordList[i])), DatasourceID = Convert.ToInt32(Common.GetValueAtRow(dtb, "DatasourceID", dtb.RecordList[i])), Status = Common.GetValueAtRow(dtb, "Status", dtb.RecordList[i]), Datasource = Common.GetValueAtRow(dtb, "DatasourceName", dtb.RecordList[i]) //XmlData = new System.Xml.Linq.XElement() }); } HttpResponseMessage ReturnedObj = new HttpResponseMessage() { Content = new StringContent(Newtonsoft.Json.JsonConvert.SerializeObject(CanvasList)) }; ReturnedObj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return(ReturnedObj); }
public static List <string> GetColumnNamesAsList(this DatatableBag datatableBag) { List <string> list = new List <string>(); foreach (MyString s in datatableBag.ColumnNameList) { list.Add(s.VarName); } return(list); }
// 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); }
/// <summary> /// Exports the Data in to DatatableBag /// </summary> /// <param name="dsName"></param> /// <param name="tableName"></param> /// <param name="ewavDataFilters"></param> /// <param name="rules"></param> /// <returns></returns> public DatatableBag ExportData(string dsName, string tableName, IEnumerable <EwavDataFilterCondition> ewavDataFilters, List <EwavRule_Base> rules) { DatatableBag dtb = new DatatableBag(); EpiDashboard.GadgetParameters gp = new EpiDashboard.GadgetParameters(); gp.DatasourceName = dsName; gp.TableName = tableName; EpiDashboard.DashboardHelper dbHelper = new EpiDashboard.DashboardHelper(gp, ewavDataFilters, rules); dbHelper.PopulateDataSet(); DataView dv = dbHelper.DataSet.Tables[0].DefaultView; ///Write code here return(dtb); }
void freqTableResults_Completed(object sender, EventArgs e) { InvokeOperation <DatatableBag> result = (InvokeOperation <DatatableBag>)sender; Exception ex = null; if (result.HasError) { result.MarkErrorAsHandled(); ex = result.Error; } DatatableBag returnedData = ((InvokeOperation <DatatableBag>)sender).Value; _freqCompleted(returnedData, ex); }
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."); } }
// public static string GetValue(this List<MyString> columnNameList, List<FieldsList> recordList) public static string GetValue(this DatatableBag datatableBag, string colName) { string thisColumn; int columnNum = 0; for (columnNum = 0; columnNum < datatableBag.ColumnNameList.Count; columnNum++) { thisColumn = datatableBag.ColumnNameList[columnNum].VarName; if (thisColumn == colName) { break; } } return(datatableBag.RecordList[0].Fields[columnNum].VarName); // recordListArray[0 ].Field. }
void applicationViewModel_CanvasListLoadedEvent(object o) { DatatableBag results = (DatatableBag)o; if (applicationViewModel.CanvasDtoListForLoggedUser.Count == 0) { spMsg.Visibility = System.Windows.Visibility.Visible; // tbSaveError.Text = "You do not have any saved dashboards."; } else { spMsg.Visibility = System.Windows.Visibility.Collapsed; cmbSavedDash.ItemsSource = null; cmbSavedDash.ItemsSource = new DashboardInfoCollection(applicationViewModel.CanvasDtoListForLoggedUser); cmbSavedDash.SelectedIndex = -1; } waitCursor.Visibility = System.Windows.Visibility.Collapsed; }
/// <summary> /// Applications the view model_ canvas list loaded event. /// </summary> /// <param name="o">The o.</param> void applicationViewModel_CanvasListLoadedEvent(object o) { results = (DatatableBag)o; if (applicationViewModel.CanvasDtoListForLoggedUser.Count == 0) { spMsg.Visibility = System.Windows.Visibility.Visible; tbSaveError.Text = "You do not have any saved dashboards."; //btnOpenDB.IsEnabled = false; } else { spMsg.Visibility = System.Windows.Visibility.Collapsed; cb1.ItemsSource = null; cb1.ItemsSource = new DashboardInfoCollection(applicationViewModel.CanvasDtoListForLoggedUser); //btnOpenDB.IsEnabled = true; } waitCursor.Visibility = System.Windows.Visibility.Collapsed; }
public static void AddField(this DatatableBag datatableBag, string fieldName) { // Add a new column MyString newColName = new MyString(); newColName.VarName = fieldName; // datatableBag.ColumnNameList.Add(newColName); datatableBag.ColumnNameList.Insert(int.Parse(fieldName), newColName); // Add a col value to each record foreach (FieldsList row in datatableBag.RecordList) { // FieldsList newCol = new FieldsList(); MyString newColValue = new MyString(); newColValue.VarName = "0"; row.Fields.Add(newColValue); row.Fields.Insert(int.Parse(fieldName), newColValue); } }
private void UpdateUserList(bool AllSelected) { DatatableBag dtb = applicationViewModel.AllUsersInMyOrg; userList = new List <UserListInfo>(); for (int i = 0; i < dtb.RecordList.Count; i++) { if (dtb.GetValueAtRow("USERNAME", dtb.RecordList[i]) != applicationViewModel.LoggedInUser.UserDto.UserName) { userList.Add(new UserListInfo (AllSelected, dtb.GetValueAtRow("FIRSTNAME", dtb.RecordList[i]), dtb.GetValueAtRow("LASTNAME", dtb.RecordList[i]), Convert.ToInt32(dtb.GetValueAtRow("USERID", dtb.RecordList[i])) )); } } BindGrid(); }
public static bool DatatableBagHasColumnName(this DatatableBag datatableBag, string columnName) { bool f; int columnNum = 0; for (columnNum = 0; columnNum < datatableBag.ColumnNameList.Count; columnNum++) { string thisColumn = datatableBag.ColumnNameList[columnNum].VarName; if (thisColumn == columnName) { f = true; } } f = false; return(f); }
/// <summary> /// Get the value of colName at the supplied row /// </summary> /// <param name="datatableBag"></param> /// <param name="colName">The name of the column </param> /// <param name="row">The FieldsList which is a List<> of record values </param> /// <returns></returns> public static string GetValueAtRow(this DatatableBag datatableBag, string colName, FieldsList row) { string thisColumn; int columnNum = 0; int fcol = 0; for (columnNum = 0; columnNum < datatableBag.ColumnNameList.Count; columnNum++) { thisColumn = datatableBag.ColumnNameList[columnNum].VarName; if (thisColumn.ToLower() == colName.ToLower()) { fcol = columnNum; break; } } return(row.Fields[fcol].VarName); }
/// <summary> /// Completion for frequency Table /// </summary> /// <param name="result"></param> /// <param name="e"></param> private void GetCombinedFrequencyCompleted(DatatableBag result, Exception e) { if (e != null) { NotificationEventArgs <Exception> notification = new NotificationEventArgs <Exception>("", e); this.Notify(ErrorNotice, notification); } else { NotificationEventArgs <Exception> notification = new NotificationEventArgs <Exception>("", e); this.FrequencyTable = result; //if (frequencyTable.Count < applicationViewModel.EwavSelectedDatasource.TotalRecords) //{ if (FrequencyTable.FieldsList.Fields.Count == 0) { this.Notify(ErrorNotice, new NotificationEventArgs <Exception>("No Data Selected", e));// new NotificationEventArgs<Exception>()); } else { this.Notify(FrequencyTableLoadedEvent, new NotificationEventArgs <Exception>()); } } }
private void GetEpiCurveResultsCompleted(DatatableBag result, Exception e) { if (e != null) { NotificationEventArgs <Exception> notification = new NotificationEventArgs <Exception>("", e); this.Notify(ErrorNotice, notification); } else { this.DataTableBag = result; if (DataTableBag == null || DataTableBag.ColumnNameList.Count == 0) { Exception exp = new Exception(SharedStrings.NO_RECORDS_SELECTED.ToString()); this.Notify(ErrorNotice, new NotificationEventArgs <Exception>("", exp)); //Notify(ErrorNotice, new NotificationEventArgs<Exception>(SharedStrings.NO_RECORDS_SELECTED)); } else { Notify(EpiCurveTableLoadedEvent, new NotificationEventArgs <Exception>()); } } }
// POST api/<controller> public HttpResponseMessage Post([FromBody] JObject value) { EpiCurveDomainService EpiCurveDomainService = new EpiCurveDomainService(); Google.DataTable.Net.Wrapper.DataTable dt = null; HttpResponseMessage ReturnedObj = null; GadgetParameters GadgetParameters = new GadgetParameters(); List <EwavRule_Base> Rules = new List <EwavRule_Base>(); ControllerCommon CommonClass = new ControllerCommon(); JObject chartJSON = (JObject)value["chart"]; List <EwavDataFilterCondition> dashboardFilters = new List <EwavDataFilterCondition>(); bool byEpiWeek = false; GadgetParameters.MainVariableName = string.Empty; GadgetParameters.WeightVariableName = string.Empty; GadgetParameters.StrataVariableNames = new List <string>(); GadgetParameters.CrosstabVariableName = string.Empty; GadgetParameters.InputVariableList = new Dictionary <string, string>(); GadgetParameters.ShouldSortHighToLow = false; GadgetParameters.DatasourceName = chartJSON["@DatasourceName"].ToString(); string strataVariable = string.Empty; GadgetParameters.MainVariableName = chartJSON["dateVariable"].ToString(); GadgetParameters.InputVariableList = new Dictionary <string, string>(); // tablename really menas DatasourName GadgetParameters.InputVariableList.Add("tableName", chartJSON["@DatasourceName"].ToString()); GadgetParameters.ShouldUseAllPossibleValues = false; GadgetParameters.InputVariableList.Add("xaxisstart", chartJSON["xAxisStartValue"].ToString()); GadgetParameters.InputVariableList.Add("xaxisend", chartJSON["xAxisEndValue"].ToString()); GadgetParameters.InputVariableList.Add("isdatecolumnnumeric", "false"); GadgetParameters.InputVariableList.Add("dateinterval", chartJSON["dateInterval"].ToString()); GadgetParameters.CrosstabVariableName = chartJSON["caseStatusVariable"].ToString(); GadgetParameters.TableName = CommonClass.GetDatabaseObject(GadgetParameters.DatasourceName); dashboardFilters = CommonClass.GetFilters(value); GadgetParameters.GadgetFilters = CommonClass.GetFilters(chartJSON, true); Rules = CommonClass.ReadRules(value); if (GadgetParameters.InputVariableList.ContainsKey("isdatecolumnnumeric")) { byEpiWeek = bool.Parse(GadgetParameters.InputVariableList["isdatecolumnnumeric"]); } DatatableBag data = EpiCurveDomainService.GetEpiCurveData(GadgetParameters, dashboardFilters, Rules, CommonClass.AdvancedDataFilterString, byEpiWeek, chartJSON["dateVariable"].ToString(), chartJSON["caseStatusVariable"].ToString()); dt = new Google.DataTable.Net.Wrapper.DataTable(); dt.AddColumn(new Column(ColumnType.String, "FreqVariable", "FreqVariable")); for (int i = 1; i < data.ColumnNameList.Count; i++) { dt.AddColumn(new Column(ColumnType.Number, "FrequencyColumn" + i, data.ColumnNameList[i].VarName.ToString())); } foreach (var item in data.RecordList) { //if (item.Fields[1].VarName.ToString().Length > 0) //{ Row r = dt.NewRow(); for (int i = 0; i < data.ColumnNameList.Count; i++) { string dateValue = item.Fields[i].VarName.ToString(); DateTime result = DateTime.Now; if (DateTime.TryParse(dateValue, out result)) { switch (chartJSON["dateInterval"].ToString().ToLower()) { case "hours": dateValue = result.ToString("g"); break; case "months": dateValue = result.ToString("MMM yyyy"); break; case "years": dateValue = result.ToString("yyyy"); break; default: //"days" dateValue = result.ToShortDateString(); break; } } r.AddCell(new Cell(dateValue)); } //); dt.AddRow(r); //} } ReturnedObj = new HttpResponseMessage() { Content = new StringContent(dt.GetJson()) }; ReturnedObj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return(ReturnedObj); }
/// <summary> /// This post method returns all the canvases for a user in a given datasource. /// </summary> /// <param name="value"></param> /// <returns></returns> public HttpResponseMessage Post([FromBody] JObject value) { UserDomainService UserDomainService = new Ewav.Web.Services.UserDomainService(); AdminDatasourcesDomainService AdminDatasourcesDomainService = new AdminDatasourcesDomainService(); CanvasDomainService CanvasDomainService = new Ewav.Web.Services.CanvasDomainService.CanvasDomainService(); ControllerCommon Common = new Controllers.ControllerCommon(); DatatableBag dtb = null; UserDTO possibleUser = new UserDTO(); possibleUser.UserName = value["id"].ToString(); UserDTO returnedUser = UserDomainService.GetUserForAuthentication(possibleUser); if (returnedUser.UserID != -1) { returnedUser = UserDomainService.LoadUser(returnedUser.UserName); //dtb = CanvasDomainService.LoadCanvasListForUser(LoadedUser.UserID); } //Guid DSGuid, UserGuid; //Guid.TryParse(value["datasourceid"].ToString(), out DSGuid); //Guid.TryParse(value["userid"].ToString(), out UserGuid); dtb = CanvasDomainService.ReadCanvasListForLite(value["datasourceid"].ToString(), returnedUser.UserID); //int ewavdatasourceid = AdminDatasourcesDomainService.ReadEwavDatasource(DSGuid); List <CanvasDto> CanvasList = new List <CanvasDto>(); Guid TempCanvasGuid; for (int i = 0; i < dtb.RecordList.Count; i++) { Guid.TryParse(Common.GetValueAtRow(dtb, "CanvasGUID", dtb.RecordList[i]), out TempCanvasGuid); CanvasList.Add( new CanvasDto() { CanvasId = Convert.ToInt32(Common.GetValueAtRow(dtb, "CanvasID", dtb.RecordList[i])), CanvasName = Common.GetValueAtRow(dtb, "CanvasName", dtb.RecordList[i]), UserId = Convert.ToInt32(Common.GetValueAtRow(dtb, "UserID", dtb.RecordList[i])), CanvasDescription = Common.GetValueAtRow(dtb, "CanvasDescription", dtb.RecordList[i]), CreatedDate = Convert.ToDateTime(Common.GetValueAtRow(dtb, "CreatedDate", dtb.RecordList[i])), ModifiedDate = Convert.ToDateTime(Common.GetValueAtRow(dtb, "ModifiedDate", dtb.RecordList[i])), DatasourceID = Convert.ToInt32(Common.GetValueAtRow(dtb, "DatasourceID", dtb.RecordList[i])), Status = Common.GetValueAtRow(dtb, "Status", dtb.RecordList[i]), Datasource = Common.GetValueAtRow(dtb, "DatasourceName", dtb.RecordList[i]), CanvasGUID = TempCanvasGuid //XmlData = new System.Xml.Linq.XElement() }); } // CanvasList = CanvasList.Where(canvas => canvas.DatasourceID == ewavdatasourceid).ToList(); HttpResponseMessage ReturnedObj = new HttpResponseMessage() { Content = new StringContent(Newtonsoft.Json.JsonConvert.SerializeObject(CanvasList)) }; ReturnedObj.Content.Headers.ContentType = new MediaTypeHeaderValue("application/json"); return(ReturnedObj); }