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);
}
