private void GenerateData()
{
File.Delete(txtSqliteData.Text);
File.Create(txtSqliteData.Text).Close();
GenerateScriptHelper.SaveSqliteDb(ScriptSqliteHelper.TableAssessment, txtSqliteData.Text);
GenerateScriptHelper.SaveSqliteDb(ScriptSqliteHelper.TableAssessmentSectionQuestion, txtSqliteData.Text);
}
private void RunSectionQuestion()
{
chkSectionQuestion.BackColor = SystemColors.MenuHighlight;
using (var mysqlProvider = new MySqlDataProvider(_connectionString))
{
string script, strScriptSqlite;
DataTable table;
var total = mysqlProvider.GetCount(ScriptMySqlHelper.TableSectionQuestionCount);
_skip = 0;
if (total > Take)
{
while (_skip < total)
{
script = string.Format(ScriptMySqlHelper.TableSectionQuestion, _skip, Take);
table = mysqlProvider.GetDataTable(script);
GenerateScriptHelper.SaveSqliteDb(ScriptSqliteHelper.TableSectionQuestion, txtSaveSQLiteFile.Text);
strScriptSqlite = ScriptSqliteHelper.InsertSectionQuestionSchedule + table.GetScript(ScriptSqliteHelper.InsertSectionQuestionValue, 24);
GenerateScriptHelper.SaveSqliteDb(strScriptSqlite, txtSaveSQLiteFile.Text);
_skip += Take;
}
}
else
{
script = string.Format(ScriptMySqlHelper.TableSectionQuestion, _skip, total);
table = mysqlProvider.GetDataTable(script);
GenerateScriptHelper.SaveSqliteDb(ScriptSqliteHelper.TableSectionQuestion, txtSaveSQLiteFile.Text);
strScriptSqlite = ScriptSqliteHelper.InsertSectionQuestionSchedule + table.GetScript(ScriptSqliteHelper.InsertSectionQuestionValue, 24);
GenerateScriptHelper.SaveSqliteDb(strScriptSqlite, txtSaveSQLiteFile.Text);
}
}
chkSectionQuestion.BackColor = SystemColors.Control;
}
