public bool Save(Exam exam)
{
DatabaseService databaseService = DatabaseService.GetInstance();
ExamDatabaseWorker databaseWorker = databaseService.ExamDatabaseWorker;
try
{
if (databaseWorker != null)
{
if (id == null)
{
databaseWorker.Unload();
}
if (id != null)
{
databaseWorker.DeleteExam(id.Value);
}
id = databaseWorker.SaveExam(exam);
SaverName = exam.Name;
return(true);
}
else
{
LastExceptionMessage = "Подкючение к базе данных не установлено.";
return(false);
}
}
catch (Exception ex)
{
LastExceptionMessage = ex.Message;
return(false);
}
}
public Exam GetExam()
{
DatabaseService databaseService = DatabaseService.GetInstance();
ExamDatabaseWorker databaseWorker = databaseService.ExamDatabaseWorker;
try
{
if (id == null)
{
return(null);
}
if (databaseWorker != null)
{
databaseWorker.Unload();
Exam result = databaseWorker.GetExam(id.Value);
SaverName = result.Name;
return(result);
}
else
{
LastExceptionMessage = "Подкючение к базе данных не установлено.";
return(null);
}
}
catch (Exception ex)
{
LastExceptionMessage = ex.Message;
return(null);
}
}
public IList <Question> GetQuestions()
{
DatabaseService databaseService = DatabaseService.GetInstance();
ExamDatabaseWorker databaseWorker = databaseService.ExamDatabaseWorker;
try
{
if (id == null)
{
return(null);
}
if (databaseWorker != null)
{
databaseWorker.Unload();
Question[] result = databaseWorker.GetQuestions(id.Value);
return(result.ToList());
}
else
{
LastExceptionMessage = "Подкючение к базе данных не установлено.";
return(null);
}
}
catch (Exception ex)
{
LastExceptionMessage = ex.Message;
return(null);
}
}
public bool DeleteResult(ExecutionResult executionResult)
{
DatabaseService databaseService = DatabaseService.GetInstance();
ExamDatabaseWorker databaseWorker = databaseService.ExamDatabaseWorker;
try
{
if (id == null)
{
return(false);
}
if (databaseWorker != null)
{
databaseWorker.DeleteResult(id.Value, executionResult);
return(true);
}
else
{
LastExceptionMessage = "Подкючение к базе данных не установлено.";
return(false);
}
}
catch (Exception ex)
{
LastExceptionMessage = ex.Message;
return(false);
}
}
public void Connect(string host, uint port, string username, string password)
{
Host = host;
Port = port;
Username = username;
Password = password;
if (examDatabaseWorker != null)
{
examDatabaseWorker.Dispose();
ConnctionLosted?.Invoke(this, EventArgs.Empty);
}
examDatabaseWorker = new ExamDatabaseWorker();
try
{
examDatabaseWorker.Connect(host, port, username, password);
ConnctionEstablished?.Invoke(this, EventArgs.Empty);
}
catch
{
examDatabaseWorker = null;
}
}
