//запись данных в файл
//запись в базу данных
private void Button_Click(object sender, RoutedEventArgs e)
{
//работа с Excel
//save.XLWb = save.XApp.Workbooks.Open(save.FileName);
//save.Worksheet = save.XLWb.Sheets[1];
//save.NumLastRow = save.Worksheet.Cells[save.Worksheet.Rows.Count, "C"].End[Excel.XlDirection.xlUp].Row;
//save.NumLastRow++;
//save.Worksheet.Cells[save.NumLastRow, "A"] = TBSite.Text;
//save.Worksheet.Cells[save.NumLastRow, "B"] = TBLogin.Text;
//save.Worksheet.Cells[save.NumLastRow, "C"] = PBPass.Password;
//MessageBox.Show("Save data!");
//save.XLWb.Close(true);
// для удаления из базы данных DataBaseWorker.QueryWithoutResponse("DELETE FROM [DBPass] WHERE id=1");
DataBaseWorker.Conection();
string site = TBSite.Text;
string log = TBLogin.Text;
string pas = PBPass.Password;
if (site != "Write Source" && log != "Write Login" && log != "")
{
string sqlExpression = String.Format("INSERT INTO DBPass(LoginSite,Login,Password) VALUES ('{0}', '{1}','{2}')", site, log, pas);
DataBaseWorker.QueryWithoutResponse(sqlExpression);
DataBaseWorker.CloseConection();
TBSite.Text = "Write Source";
TBLogin.Text = "Write Login";
PBPass.Clear();
}
else
{
MessageBox.Show("Specify data to write", "Attantion", MessageBoxButton.OK, MessageBoxImage.Error);
}
}
/// Functions
#region Functions
/// <summary>
///
/// </summary>
public void saveData2File()
{
testData.screen_Height = Screen.PrimaryScreen.Bounds.Height;
testData.screen_Width = Screen.PrimaryScreen.Bounds.Width;
testData.date = Program.datosCompartidos.startTimeTest;
testData.date_loc = DataConverter.LocalDateFromUTC(Program.datosCompartidos.startTimeTest);
testData.eyetracker = Program.datosCompartidos.EyeTrackerInfo;
testData.user_id = Program.datosCompartidos.activeUser;
testData.tester_id = Program.datosCompartidos.activeTester;
testData.windows_username = Environment.UserName;
//testData.pointer_type = "eyetracker"; // settings.pointercontroltypeSelected.ToString();
//testData.blink_time_min = 0;
//testData.blink_time_max = 0;
//testData.dwell_area = settings.DwellArea;
//testData.dwell_time = settings.DwellTime;
//testData.dewll_time_latency = settings.DwellLatency;
testData.calibration_error_left_px = Program.datosCompartidos.meanCalibrationErrorLeftPx;
testData.calibration_error_right_px = Program.datosCompartidos.meanCalibrationErrorRightPx;
testData.filter_type = settings.filtertypeSelected.ToString();
testData.typeTestDone = Program.datosCompartidos.testSelected;
testData.readingTestTypeDone = Program.datosCompartidos.readingTestTypeSelected;
testData.image2read = getReadingTestTypeDone();
testData.assemblyVersion = System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
DataBaseWorker.SaveTestData(testData, Program.datosCompartidos.activeUser, "");
string path = DataConverter.OldTypeDirectory(Program.datosCompartidos.startTimeTest, Program.datosCompartidos.activeUser);
DataValidation.CheckDirectoryPath(path, true, FileAttributes.Hidden);
File.WriteAllText(path + @"\testData.json", JsonConvert.SerializeObject(testData));
}
private void Init(bool showLastTest, bool newTestAvailable, string inputData, string eyetrackerDataJson, OutputTestData2 testData)
{
labelVersion.Text = "Version: " + System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
closeApp = true;
if (showLastTest)
{
inputData = DataBaseWorker.LoadLastPursuitData(out date, out user_id, out eyetrackerDataJson, out testData);
}
this.date_loc = testData.date_loc;
this.user_id = testData.user_id;
date = testData.date;
buttonNewTest.Enabled = newTestAvailable;
//Console.WriteLine("selectedPath: " + selectedPath);
toolStripStatusLabelFileName.Text = string.Format("{0}-us{1}", date_loc, user_id);
eyetrackerDataL = ReviewClass.loadEyetrackerDataFromJson(eyetrackerDataJson);
_testData = DataConverter.TestData2ToTestData1(testData);
stimuloPersuitSetup = ReviewClass.loadPersuitDataFromJson(inputData);
everythingOk = ReviewClass.eyetrackerDataFound(eyetrackerDataL) & ReviewClass.testDataFound(_testData) & ReviewClass.persuitDataFound(stimuloPersuitSetup);
if (everythingOk)
{
plotGazeData2Control();
}
}
private void Edit_Button_Click(object sender, RoutedEventArgs e)
{
if (ItemToEditName_TextBox.Text == "")
{
MyMessageBox.Show("Необходимо заполнить все поля!\nПоле \'Название\' было пустое.", "Недостаточно данных", MessageBoxButton.OK, MessageBoxImage.Warning);
ItemToEditName_TextBox.Focus();
}
else if (ItemToEditMod_ComboBox.Text == "")
{
MyMessageBox.Show("Необходимо заполнить все поля!\nПоле \'Мод\' было пустое.", "Недостаточно данных", MessageBoxButton.OK, MessageBoxImage.Warning);
ItemToEditMod_ComboBox.Focus();
}
else
{
if (ItemToEditMod_ComboBox.Text.IsOneOf(ServerViewModel.Mods.ToArray()) == false)
{
var result = MyMessageBox.Show("Вы указали в поле \'Мод\' значение, которого ещё нет в таблице.\nХотите добавить новый тип значений для \'Мод\'", "Изменение данных", MessageBoxButton.YesNo, MessageBoxImage.Information);
if (result != MessageBoxResult.Yes)
{
return;
}
}
Item editedItem = new Item()
{
Header = ItemToEditName_TextBox.Text,
Count = ItemToEditCount_IntUpDown.Value.Value,
Price = ItemToEditPrice_IntUpDown.Value.Value,
Mod = ItemToEditMod_ComboBox.Text
};
DataBaseWorker.UpdateData(App.Server, editedItem, ItemViewModel.SelectedItem.ID);
MyMessageBox.Show("Редактирование данных прошло успешно!", "Успех", MessageBoxButton.OK, MessageBoxImage.Information);
RefillFilterCheckBoxes();
EditSelectItem_ComboBox.SelectedIndex = -1;
}
}
//показ базы паролей
private void Button_Click_ShowDB(object sender, RoutedEventArgs e)
{
//работа с Excel
//if (File.Exists(save.FileName))
//{
// Process.Start(save.FileName);
//}
//else
//{
// MessageBox.Show("Not file!");
//}
DataBaseWorker.Conection();
List <string[]> mas = DataBaseWorker.GetData("SELECT * FROM DBPass", 4);
Info info = new Info();
if (mas != null)
{
foreach (var item in mas)
{
info.a = item[1];
info.b = item[2];
info.v = item[3];
listDB.Items.Add(info);
}
Grid_ListView.Visibility = Visibility.Visible;
}
else
{
MessageBox.Show("DataBase is empty!");
}
DataBaseWorker.CloseConection();
}
//
public ATMViewModel()
{
AllCards = DataBaseWorker.getCardsFromDataBase(DataBaseWorker.CardPath);
MoneyInATM = DataBaseWorker.getMoneyInATM(DataBaseWorker.AtmInfoPath);
DataBaseWorker.blockCards(this.AllCards, DataBaseWorker.BlockedCardPath);
this.AttemptsToSingIn = 3;
LastLogin = String.Empty;
}
// поиск сайта по базе
private void Find(object sender, RoutedEventArgs e)
{
//работа с Excel
//save.XLWb = save.XApp.Workbooks.Open(save.FileName);
//save.Worksheet = save.XLWb.Sheets[1];
//string data = SearchSite.Text;
//string Site = "";
//string Login = "";
//string Pas = "";
//int i = 2;
//int g = 1;
//bool flag = false;
// while (save.Worksheet.Cells[i, g].Value2!=null)
// {
// if (save.Worksheet.Cells[i, g].Value2 == data)
// {
// Site = save.Worksheet.Cells[i, g].Value2;
// Login = save.Worksheet.Cells[i, g+1].Value2;
// Pas = save.Worksheet.Cells[i, g + 2].Value2;
// TBSite.Text = Site;
// TBLogin.Text = Login;
// PBPass.Password = Pas;
// flag = true;
// break;
// }
// i++;
// }
//if (flag!=true)
//{
// MessageBox.Show("Not found");
//}
//SearchSite.Text = "What to find?";
//save.XLWb.Close(true);
DataBaseWorker.Conection();
List <string[]> mas = DataBaseWorker.GetData("SELECT * FROM DBPass", 4);
bool flag = false;
foreach (var item in mas)
{
if (item[1] == SearchSite.Text)
{
TBSite.Text = item[1];
TBLogin.Text = item[2];
PBPass.Password = item[3];
flag = true;
break;
}
}
if (flag == false)
{
MessageBox.Show("Not found", "Attantion", MessageBoxButton.OK, MessageBoxImage.Error);
}
DataBaseWorker.CloseConection();
}
private void App_ServerChanged(object sender, EventArgs e)
{
if (DataBaseWorker.GetData(App.Server).Count != 0)
{
RefillFilterCheckBoxes();
}
FilterMod.Clear();
RefillFilterCheckBoxes();
}
private void InitializeMapping()
{
if (_mappingInfoContainer == null)
{
_mappingInfoContainer = TypeMapping.GetMappingInfo(_mappingOptionSet.GetTypeMappingOptions(typeof(T)));
_dbWorker = new DataBaseWorker(_connectionString, this);
_cache = new WeakCache(_mappingInfoContainer.LoadBehavior == LoadBehavior.OnFirstAccessFullLoad);
}
}
private void OnGetCalibrationCompleted(object sender, CalibrationReadyEventArgs e)
{
DataBaseWorker.SaveCalibrationData(JsonConvert.SerializeObject(e.CalibrationPointDataL), Program.datosCompartidos.activeUser, LookAndPlayForm.Program.datosCompartidos.startTimeTest);
string path = DataConverter.OldTypeDirectory(Program.datosCompartidos.startTimeTest, Program.datosCompartidos.activeUser);
DataValidation.CheckDirectoryPath(path, true, FileAttributes.Hidden);
File.WriteAllText(path + @"\calibrationData.json", JsonConvert.SerializeObject(e.CalibrationPointDataL));
}
//МЕТОДЫ
public RiealtorAgencyDB(string connectionString)
{
this.connectionString = connectionString;
workerDB = new DataBaseWorker(connectionString, this);
manager = new MngrClient(this);
workerDB.FillDataSet(); //Заполнение DataSet
manager.StartClientList(); //Заполнение ckientList
}
public void SavePersuitData()
{
DataBaseWorker.SavePursuitData(JsonConvert.SerializeObject(this), Program.datosCompartidos.activeUser, LookAndPlayForm.Program.datosCompartidos.startTimeTest);
string path = DataConverter.OldTypeDirectory(Program.datosCompartidos.startTimeTest, Program.datosCompartidos.activeUser);
DataValidation.CheckDirectoryPath(path, true, FileAttributes.Hidden);
File.WriteAllText(path + @"\persuitData.json", JsonConvert.SerializeObject(this));
}
private void Delete_Button_Click(object sender, RoutedEventArgs e)
{
MessageBoxResult res = MyMessageBox.Show("Вы пытаетесь удалить объект из таблицы.\nЭто действие нельзя отменить.\nПродолжить?", "Подтверждение", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (res == MessageBoxResult.Yes)
{
DataBaseWorker.DeleteData(App.Server, ItemViewModel.SelectedItem);
MyMessageBox.Show("Удаление данных прошло успешно!", "Успех", MessageBoxButton.OK, MessageBoxImage.Information);
}
}
private void Window_Loaded(object sender, RoutedEventArgs e)
{
buttonConnector = new ButtonModuleConnector();
buttonConnector.OnModuleConnectionChange += ButtonConnector_OnModuleConnectionChange;
buttonConnector.OnNewPortNames += ButtonConnector_OnNewPortNames;
buttonConnector.PortName = "COM4";
buttonConnector.Init();
registrationManager = new RegistrationManager();
registrationManager.Init(buttonConnector);
registrationManager.OnPlayerDisable += RegistrationManager_OnPlayerDisable;
registrationManager.OnPlayerRegistrated += RegistrationManager_OnPlayerRegistrated;
dbWorker = new DataBaseWorker();
dbWorker.Init();
QuizInfo playersInfo = dbWorker.GetFullInfo();
RoundNumber = playersInfo.RoundIndex;
quizManager = new QuizManager();
quizManager.OnNewQuestion += QuizManager_OnNewQuestion;
quizManager.OnPlayerButtonClicked += QuizManager_OnPlayerButtonClicked;
quizManager.OnRightAnswer += QuizManager_OnRightAnswer;
quizManager.OnWrongAnswer += QuizManager_OnWrongAnswer;
quizManager.OnRoundEnd += QuizManager_OnRoundEnd;
quizManager.Init(dbWorker.GetQuestions(), buttonConnector);
if (playersInfo.PlayersNames.Count == 0)
{
AddPlayer();
AddPlayer();
}
else
{
for (int i = 0; i < playersInfo.PlayersNames.Count; ++i)
{
AddPlayer(playersInfo.PlayersNames[i]);
AddPoints(i, playersInfo.PlayersPoints[i]);
}
}
MediaBlock.LoadedBehavior = MediaState.Manual;
MediaBlock.UnloadedBehavior = MediaState.Manual;
MediaBlock.Volume = 0.5f;
RightAnswerMediaBlock.LoadedBehavior = MediaState.Manual;
RightAnswerMediaBlock.UnloadedBehavior = MediaState.Manual;
RightAnswerMediaBlock.Volume = 0.5f;
Sound.LoadedBehavior = MediaState.Manual;
Sound.UnloadedBehavior = MediaState.Manual;
Sound.Volume = 0.5f;
Sound.Stop();
}
private void RefillFilterCheckBoxes()
{
MainFilterList_ListView.Items.Clear();
foreach (var item in DataBaseWorker.GetOnlyColumnList(App.Server, "i_mod"))
{
MainFilterList_ListView.Items.Add(new CheckBox()
{
Content = item
});
}
}
public bool getMoney(int howMuch)
{
if (CurrentCard.MoneyRubels < howMuch || MoneyInATM < howMuch)
{
return(false);
}
CurrentCard.MoneyRubels -= howMuch;
MoneyInATM -= howMuch;
DataBaseWorker.saveMoneyInATM(MoneyInATM, DataBaseWorker.AtmInfoPath);
DataBaseWorker.saveCards(AllCards, DataBaseWorker.CardPath);
return(true);
}
void saveData2File()
{
FixDataJson = JsonConvert.SerializeObject(fixData);
DataBaseWorker.SaveFixData(FixDataJson, user_id, date);
string path = DataConverter.OldTypeDirectory(date, user_id);
DataValidation.CheckDirectoryPath(path, true, FileAttributes.Hidden);
File.WriteAllText(path + @"\fixData.json", FixDataJson);
//FixDataFound = true;
}
public void saveData2File()
{
generalDataEyeX.targetTraceL = TargetTraceEyeXL;
DataBaseWorker.SaveEyeTrackerData(JsonConvert.SerializeObject(generalDataEyeX), Program.datosCompartidos.activeUser, LookAndPlayForm.Program.datosCompartidos.startTimeTest);
string path = DataConverter.OldTypeDirectory(Program.datosCompartidos.startTimeTest, Program.datosCompartidos.activeUser);
DataValidation.CheckDirectoryPath(path, true, FileAttributes.Hidden);
File.WriteAllText(path + @"\eyetrackerData.json", JsonConvert.SerializeObject(generalDataEyeX));
ClearList();
}
private void LoadTesters()
{
testersList = DataBaseWorker.LoadTesters();
if (testersList == null || testersList.Count < 1)
{
comboBoxTesters.Enabled = false;
buttonOk.Enabled = false;
}
else
{
testersFileData2Form();
}
}
protected override void OnStart(string[] args)
{
DataBaseWorker reader = new DataBaseWorker(dataOptions.ConnectionString);
FileTransfer fileTransfer = new FileTransfer(dataOptions.OutputFolder, dataOptions.SourcePath);
string customersFileName = "customers";
await reader.GetCustomersAsync(dataOptions.OutputFolder, appInsights, customersFileName);
await fileTransfer.SendFileToFtpAsync($"{customersFileName}.xml");
await fileTransfer.SendFileToFtpAsync($"{customersFileName}.xsd");
await appInsights.InsertInsightAsync("Files uploaded");
}
//очистить базу данных
private void Button_Click_3(object sender, RoutedEventArgs e)
{
MessageBoxResult result;
result = MessageBox.Show("Delete DataBase?", "Attantion", MessageBoxButton.YesNo, MessageBoxImage.Question);
if (result == MessageBoxResult.Yes)
{
DataBaseWorker.Conection();
string qury = "TRUNCATE TABLE DBPass";
DataBaseWorker.QueryWithoutResponse(qury);
DataBaseWorker.CloseConection();
}
}
private void LoadPatients()
{
patientsList = DataBaseWorker.LoadUsers();
if (patientsList != null && patientsList.Count > 0)
{
patientsFile2Form();
}
else
{
comboBoxPatients.Enabled = false;
buttonOk.Enabled = false;
}
}
static async Task Main()
{
ConfigManager configManager;
DataOptions dataOptions;
DataBaseWorker appInsights;
try
{
if (File.Exists(xmlPath) && File.Exists(xsdPath))
{
XmlSchemaSet schema = new XmlSchemaSet();
schema.Add(string.Empty, xsdPath);
XDocument xdoc = XDocument.Load(xmlPath);
xdoc.Validate(schema, ValidationEventHandler);
configManager = new ConfigManager(xmlPath, typeof(DataOptions));
}
else if (File.Exists(jsonPath))
{
configManager = new ConfigManager(jsonPath, typeof(DataOptions));
}
else
{
throw new Exception("No options");
}
dataOptions = configManager.GetOptions <DataOptions>();
appInsights = new DataBaseWorker(dataOptions.LoggerConnectionString);
await appInsights.ClearInsightsAsync();
await appInsights.InsertInsightAsync("Connection established");
}
catch (Exception ex)
{
using (StreamWriter sw = new StreamWriter(Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "Exceptions.txt"), true))
{
await sw.WriteLineAsync($"{DateTime.Now:dd/MM/yyyy HH:mm:ss} Exception: {ex.Message}");
}
return;
}
try
{
DataManager service = new DataManager(dataOptions, appInsights);
ServiceBase.Run(service);
}
catch (Exception ex)
{
await appInsights.InsertInsightAsync("Exception: " + ex.Message);
await appInsights.WriteInsightsToXmlAsync(dataOptions.OutputFolder);
}
}
public App()
{
new ForumEconomyParser().GetPostData("Galaxy");
#if RESEASE
if (!IsUserAdministrator())
{
MyMessageBox.Show("Run as administrator.", "Нет прав", MessageBoxButton.OK, MessageBoxImage.Error);
return;
}
#endif
if (!File.Exists(Path.GetDirectoryName(Process.GetCurrentProcess().MainModule.FileName) + "\\economy.db"))
{
DataBaseWorker.CreateDataBase();
}
ServerChanged += App_ServerChanged;
Server = EconomyViewer.Properties.Settings.Default.DefaultServer;
}
private void CommonAddData()
{
if (ToAddItemName_TextBox.Text == "")
{
MyMessageBox.Show("Необходимо заполнить все поля!\nПоле \"Название\" было пустое.", "Недостаточно данных", MessageBoxButton.OK, MessageBoxImage.Warning);
ToAddItemName_TextBox.Focus();
return;
}
if (ToAddItemMod_ComboBox.SelectedIndex == -1 && ToAddItemMod_ComboBox.Text == "")
{
MyMessageBox.Show("Необходимо заполнить все поля!\nПоле \"Мод\" было пустое.", "Недостаточно данных", MessageBoxButton.OK, MessageBoxImage.Warning);
ToAddItemMod_ComboBox.Focus();
return;
}
if (ToAddItemMod_ComboBox.Text != "" && !ServerViewModel.Mods.Contains(ToAddItemMod_ComboBox.Text))
{
var result = MyMessageBox.Show("Вы указали в поле \'Мод\' значение, которого ещё нет в таблице.\nХотите добавить новый тип значений для \'Мод\'", "Изменение данных", MessageBoxButton.YesNo, MessageBoxImage.Information);
if (result != MessageBoxResult.Yes)
{
return;
}
}
Item newItem = new Item()
{
Header = ToAddItemName_TextBox.Text,
Count = ToAddItemCount_IntUpDown.Value.Value,
Price = ToAddItemPrice_IntUpDown.Value.Value,
Mod = ToAddItemMod_ComboBox.Text
};
if (ItemViewModel.ItemList.Contains(newItem) == false)
{
DataBaseWorker.InsertData(App.Server, newItem);
MyMessageBox.Show("Добавление новых данных прошло успешно!", "Успех", MessageBoxButton.OK, MessageBoxImage.Information);
RefillFilterCheckBoxes();
}
else
{
MyMessageBox.Show("Таблица уже содержит такой объект.", "Ошибка", MessageBoxButton.OK, MessageBoxImage.Error);
}
ToAddItemName_TextBox.Text = ToAddItemMod_ComboBox.Text = "";
ToAddItemCount_IntUpDown.Value = ToAddItemPrice_IntUpDown.Value = 1;
}
public Resumen(bool showLastTest, bool newTestAvailable, string fixDataJson, string eyetrackerDataJson, OutputTestData2 testData)
{
InitializeComponent();
labelVersion.Text = "Version: " + System.Reflection.Assembly.GetExecutingAssembly().GetName().Version.ToString();
closeApp = true;
if (showLastTest)
{
fixDataJson = DataBaseWorker.LoadLastReadingData(out date, out user_id, out eyetrackerDataJson, out testData);
}
this.dateloc = testData.date_loc;
this.user_id = testData.user_id;
date = testData.date;
buttonNewTest.Enabled = newTestAvailable;
//Console.WriteLine("selectedPath: " + selectedPath);
_testData = DataConverter.TestData2ToTestData1(testData);
if (string.IsNullOrWhiteSpace(fixDataJson))
{
fixDataJson = processFixData(eyetrackerDataJson, _testData, testData.date, user_id);//procesa los datos de los ojos y genera un archivo fixData.json
}
toolStripStatusLabelFileName.Text = string.Format("{0}-us{1}", dateloc, user_id);
fixDataFound = loadFixationDataFromJson(fixDataJson); //carga el archivo fixData.json
eyetrackerDataL = ReviewClass.loadEyetrackerDataFromJson(eyetrackerDataJson);
getStimulusFeactures(ReviewClass.eyetrackerDataFound(eyetrackerDataL));
imageFound = class4Graphic.loadImage2Control(ReviewClass.testDataFound(_testData), _testData, pictureBoxStimulus);
everythingOk = fixDataFound & ReviewClass.eyetrackerDataFound(eyetrackerDataL) & ReviewClass.testDataFound(_testData) & imageFound;
if (everythingOk)
{
processMetrics();
}
}
public LoginContinions singInWithAttempts(string login, string password)
{
if (!login.Equals(LastLogin))
{
AttemptsToSingIn = maxAttempstToSingIn;
LastLoginCard = findCard(login);
LastLogin = login;
}
if (LastLoginCard.Blocked)
{
return(LoginContinions.BLOCKED);
}
if (AttemptsToSingIn == 0)
{
LastLoginCard.Blocked = true;
DataBaseWorker.saveBlockedCard(LastLoginCard, DataBaseWorker.BlockedCardPath);
}
if (LastLoginCard.Blocked)
{
return(LoginContinions.BLOCKED);
}
if (LastLoginCard == null)
{
return(LoginContinions.DOESNTEXIST);
}
if (LastLoginCard.Password.Equals(password))
{
AttemptsToSingIn = maxAttempstToSingIn;
CurrentCard = LastLoginCard;
LastLoginCard = null;
return(LoginContinions.SUCCESS);
}
else
{
AttemptsToSingIn--;
return(LoginContinions.PASSWORDERROR);
}
}
public void updateDataBase(System.Windows.Forms.NumericUpDown numericUpDownInstitutionID, institution_class_data institutionDataSelected)
{
try
{
if (institutionsList != null && institutionsList.Count > 0)
{
if (numericUpDownInstitutionID.Value > Convert.ToDecimal(institutionsList.Last().institution_id))
{
DataBaseWorker.AddInstitution(institutionDataSelected);
}
}
else
{
institutionsList = new List <institution_class_data>();
institutionsList.Add(institutionDataSelected);
DataBaseWorker.AddInstitution(institutionDataSelected);
}
}
catch (Exception ex)
{
ErrorLog.ErrorLog.toErrorFile(ex.GetBaseException().ToString());
}
}
private void buttonOk_Click(object sender, EventArgs e)
{
IsTestSelected = false;
try
{
if (dgvTests.SelectedRows != null && dgvTests.SelectedRows.Count > 0)
{
DataGridViewRow row = dgvTests.SelectedRows[0];
//string date = DataConverter.UTCDateFormat(row.Cells["DateUTC"].Value.ToString());
string date = row.Cells["DateUTC"].Value.ToString();
string patient = row.Cells["Patient"].Value.ToString();
string ttype = row.Cells["Test"].Value.ToString();
TestType = (ttype == "reading") ? TestType.reading : TestType.pursuit;
string user_id = row.Cells["PatientID"].Value.ToString();
TestData = DataBaseWorker.LoadTestDataByDateAndID(date, user_id);
EyeTrackerData = DataBaseWorker.LoadEyeTrackerData(date, user_id);
if (TestType == TestType.reading)
{
FixData = DataBaseWorker.LoadReadingData(date, user_id);
}
else
{
PursuitData = DataBaseWorker.LoadPursuitData(date, user_id);
}
IsTestSelected = true;
}
else
{
IsTestSelected = false;
}
}
catch (Exception ex)
{
ErrorLog.ErrorLog.toErrorFile(ex.GetBaseException().ToString());;
}
}
/// Functions
#region Functions
/// <summary>
///
/// </summary>
private void Search()
{
//string date = DataValidation.DateValidation(tbFilter_Date.Text);
string date = dtpFilter_Date.Checked ? dtpFilter_Date.Value.ToString() : "";
testType = ((bFilter_Reading.Tag != null) ? 2 : 0) + ((bFilter_Pursuit.Tag != null) ? 1 : 0);
dgvTests.Rows.Clear();
DataTable dt = DataBaseWorker.SearchTest(tbFilter_PatientName.Text, tbFilter_TesterName.Text, date, testType);
if (dt == null)
{
return;
}
int i = 0;
foreach (DataRow row in dt.Rows)
{
try
{
dgvTests.Rows.Add();
dgvTests.Rows[i].Cells["Patient"].Value = row["Patient"].ToString();
dgvTests.Rows[i].Cells["PatientID"].Value = row["PatientID"].ToString();
dgvTests.Rows[i].Cells["Tester"].Value = row["Tester"].ToString();
dgvTests.Rows[i].Cells["Date"].Value = row["Date"].ToString();
dgvTests.Rows[i].Cells["DateUTC"].Value = DataConverter.UTCDateFromLocalTime(row["DateUTC"].ToString());
int testTypex = int.Parse(row["TestType"].ToString());
dgvTests.Rows[i].Cells["Test"].Value = (TestType)testTypex;
i++;
}
catch (Exception ex)
{
ErrorLog.ErrorLog.toErrorFile(ex.GetBaseException().ToString());;
}
}
}
