private void buttonXAddExisting_Click(object sender, EventArgs e) { var alllExistingF = DataExportClientDataManager.GetFormulaForUser(_userId); if (alllExistingF.Count == 0) { ToastNotification.Show(elementContainerControl1, "There are no one frmula.", eToastPosition.TopCenter); return; } var frm = new FormExistingsFormulas(alllExistingF) { Location = PointToScreen(new Point(elementContainerControl1.Location.X + 10, elementContainerControl1.Location.Y + 41)), Size = new Size(elementContainerControl1.Size.Width - 20, elementContainerControl1.Size.Height - 51) }; if (frm.ShowDialog() == DialogResult.OK) { const string fname = "new formula "; var i = 1; while (_formulas.Exists(a => a.Name == fname + i)) { i++; } var model = frm.SelectedFormula; model.Name = fname + i; model.IsSnapShot = _isSnapShot; AddFormula(model); } }
public bool AddQuery(QueryModel newQuery) { if (!Queries.Exists(query => query.QueryName == newQuery.QueryName)) { DataExportClientDataManager.AddQueryToProfile(Parameters.ProfileId, newQuery); Queries = DataExportClientDataManager.GetQueriesForProfile(Parameters.ProfileId); return(true); } return(false); }
public static void LoadProfiles() { Profiles = new List <Profile>(); var profileModels = DataExportClientDataManager.GetProfiles(UserId); foreach (var profileModel in profileModels) { var profile = new Profile(profileModel); Profiles.Add(profile); } }
public static bool CreateNewProfile(string name) { if (!Profiles.Exists(a => a.Parameters.ProfileName == name)) { var newProfileModel = new ProfileModel { ProfileName = name, EnableLinkExport = false, EnableScheduleJob = false }; DataExportClientDataManager.AddNewProfile(newProfileModel, UserId); return(true); } return(false); }
public static DataTable GetDataTable(QueryModel queryModel) { var sql = CreateSql(queryModel); _dataTable = CreateDataTable(queryModel.SelectedCols, queryModel.TimeFrame); MySqlDataReader reader; if (queryModel.TimeFrame == "Tick") { reader = DataExportClientDataManager.GetReaderLive(sql); } else { reader = DataExportClientDataManager.GetReaderBar(sql); } if (reader != null) { try { while (reader.Read()) { var row = _dataTable.NewRow(); for (int i = 0; i < _dataTable.Columns.Count; i++) { //try{ var el = reader.GetValue(i); row[i] = el; //}catch (Exception) { } } _dataTable.Rows.Add(row); } } finally { reader.Close(); } } if (!queryModel.DateOrDaysBack) { return((from rows in _dataTable.AsEnumerable() where rows.Field <DateTime>("Time").Hour > queryModel.Start.Hour && rows.Field <DateTime>("Time").Hour < queryModel.End.Hour select rows).CopyToDataTable()); } return(_dataTable); }
public static bool RenameCurrentProfile(string name) { if (!Profiles.Exists(a => a.Parameters.ProfileName == name) && CurrentProfile.Parameters.ProfileName != name) { var newProfileModel = new ProfileModel { ProfileName = name, EnableLinkExport = CurrentProfile.Parameters.EnableLinkExport, EnableScheduleJob = CurrentProfile.Parameters.EnableScheduleJob, SheduleJobs = CurrentProfile.Parameters.SheduleJobs ?? new List <SheduleJobModel>() }; DataExportClientDataManager.EditProfile(CurrentProfile.Parameters.ProfileId, newProfileModel); return(true); } return(false); }
public static void EditCurrentProfile(ProfileModel newProfileModel) { DataExportClientDataManager.EditProfile(CurrentProfile.Parameters.ProfileId, newProfileModel); LoadProfiles(); SetCurrentProfile(newProfileModel.ProfileName); }
public static void DeleteCurrentProfile() { DataExportClientDataManager.DeleteProfile(CurrentProfile.Parameters.ProfileId); CurrentProfile = null; }
public void EditCurrentQuery(QueryModel newQuery) { DataExportClientDataManager.EditQuery(CurrentQuery.QueryId, newQuery); Queries = DataExportClientDataManager.GetQueriesForProfile(Parameters.ProfileId); SetCurrentQuery(newQuery.QueryName); }
public void DeleteQuery(string name) { var queryId = Queries.Find(query => query.QueryName == name).QueryId; DataExportClientDataManager.DeleteQueryFromProfie(Parameters.ProfileId, queryId); }
public Profile(ProfileModel parameters) { Parameters = parameters; Queries = DataExportClientDataManager.GetQueriesForProfile(Parameters.ProfileId); }