public static void ReadDatabaseSettings()
{
DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345";
OleDb oleDb;
oleDb = new OleDb(DataConfig.configFile);
try{
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM DatabaseSettings";
oleDb.ExecuteFill("DatabaseSettings");
DataConfig.localDatabase = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["localDatabase"].ToString();
DataConfig.typeDatabase = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeDatabase"].ToString();
DataConfig.typeConnection = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeConnection"].ToString();
DataConfig.serverConnection = oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["serverConnection"].ToString();
oleDb.Dispose();
Utilits.Console.Log("Настройки соединения с базой данных успешно загружены.");
}catch (Exception ex) {
oleDb.Error();
MessageBox.Show("[ReadDatabaseSettings]: " + ex.ToString(), "Ошибка");
Application.Exit();
}
DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
DataConfig.oledbConnectLineEnd = "";
DataConfig.oledbConnectPass = "";
}
public static bool SaveSettings()
{
DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345";
OleDb oleDb;
oleDb = new OleDb(DataConfig.configFile);
try{
oleDb.oleDbCommandSelect.CommandText = "SELECT [id], [autoUpdate], [showConsole], [period] FROM Settings";
oleDb.oleDbCommandUpdate.CommandText = "UPDATE Settings SET " +
"[autoUpdate] = @autoUpdate, " +
"[showConsole] = @showConsole, " +
"[period] = @period " +
"WHERE ([id] = @id)";
oleDb.oleDbCommandUpdate.Parameters.Add("@autoUpdate", OleDbType.VarChar, 255, "autoUpdate");
oleDb.oleDbCommandUpdate.Parameters.Add("@showConsole", OleDbType.VarChar, 255, "showConsole");
oleDb.oleDbCommandUpdate.Parameters.Add("@period", OleDbType.VarChar, 255, "period");
oleDb.oleDbCommandUpdate.Parameters.Add("@id", OleDbType.Integer, 10, "id");
oleDb.ExecuteFill("Settings");
oleDb.dataSet.Tables["Settings"].Rows[0]["autoUpdate"] = DataConfig.autoUpdate.ToString();
oleDb.dataSet.Tables["Settings"].Rows[0]["showConsole"] = DataConfig.showConsole.ToString();
oleDb.dataSet.Tables["Settings"].Rows[0]["period"] = DataConfig.period;
if (oleDb.ExecuteUpdate("Settings"))
{
oleDb.Dispose();
Utilits.Console.Log("Сохранение настроек программы прошло успешно.");
DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
DataConfig.oledbConnectLineEnd = "";
DataConfig.oledbConnectPass = "";
return(true);
}
else
{
oleDb.Error();
Utilits.Console.Log("[ОШИБКА] Настройки программы не сохранены.", false, true);
DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
DataConfig.oledbConnectLineEnd = "";
DataConfig.oledbConnectPass = "";
return(false);
}
}catch (Exception ex) {
oleDb.Error();
Utilits.Console.Log("[ОШИБКА] " + ex.Message.ToString(), false, true);
DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
DataConfig.oledbConnectLineEnd = "";
DataConfig.oledbConnectPass = "";
return(false);
}
}
void disposeDb()
{
if (oleDb != null)
{
oleDb.Dispose();
}
if (sqlServer != null)
{
sqlServer.Dispose();
}
}
public static bool SaveDatabaseSettings()
{
DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345";
OleDb oleDb;
oleDb = new OleDb(DataConfig.configFile);
try{
oleDb.oleDbCommandSelect.CommandText = "SELECT [id], [name], [localDatabase], [typeDatabase], [typeConnection], [serverConnection] FROM DatabaseSettings";
oleDb.oleDbCommandUpdate.CommandText = "UPDATE DatabaseSettings SET " +
"[name] = @name, " +
"[localDatabase] = @localDatabase, " +
"[typeDatabase] = @typeDatabase, " +
"[typeConnection] = @typeConnection, " +
"[serverConnection] = @serverConnection " +
"WHERE ([id] = @id)";
oleDb.oleDbCommandUpdate.Parameters.Add("@name", OleDbType.VarChar, 255, "name");
oleDb.oleDbCommandUpdate.Parameters.Add("@localDatabase", OleDbType.VarChar, 255, "localDatabase");
oleDb.oleDbCommandUpdate.Parameters.Add("@typeDatabase", OleDbType.VarChar, 255, "typeDatabase");
oleDb.oleDbCommandUpdate.Parameters.Add("@typeConnection", OleDbType.VarChar, 255, "typeConnection");
oleDb.oleDbCommandUpdate.Parameters.Add("@serverConnection", OleDbType.VarChar, 255, "serverConnection");
oleDb.oleDbCommandUpdate.Parameters.Add("@id", OleDbType.Integer, 10, "id");
oleDb.ExecuteFill("DatabaseSettings");
oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["localDatabase"] = DataConfig.localDatabase;
oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeDatabase"] = DataConfig.typeDatabase;
oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["typeConnection"] = DataConfig.typeConnection;
oleDb.dataSet.Tables["DatabaseSettings"].Rows[0]["serverConnection"] = DataConfig.serverConnection;
oleDb.ExecuteUpdate("DatabaseSettings");
oleDb.Dispose();
Utilits.Console.Log("Сохранение настроек соединения с базой данных прошло успешно.");
DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
DataConfig.oledbConnectLineEnd = "";
DataConfig.oledbConnectPass = "";
return(true);
}catch (Exception ex) {
oleDb.Error();
Utilits.Console.Log("[ОШИБКА] Сохранение настроек соединения с базой данных. " + ex.Message.ToString(), false, true);
DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
DataConfig.oledbConnectLineEnd = "";
DataConfig.oledbConnectPass = "";
return(false);
}
}
void FormUsersEditFormClosed(object sender, FormClosedEventArgs e)
{
if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL && oleDb != null)
{
oleDb.Dispose();
}
if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER && sqlServer != null)
{
sqlServer.Dispose();
}
Utilits.Console.Log(Text + ": закрыт.");
DataForms.FClient.messageInStatus("...");
Dispose();
}
void FormPurchasePlanJournalFormClosed(object sender, FormClosedEventArgs e)
{
if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL && oleDb != null)
{
oleDb.Dispose();
}
if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER && sqlServer != null)
{
sqlServer.Dispose();
}
DataForms.FClient.messageInStatus("...");
Utilits.Console.Log(this.Text + ": закрыт");
Dispose();
DataForms.FPurchasePlanJournal = null;
}
/* =================================================================================================
* РАЗДЕЛ: СОБЫТИЙ
* =================================================================================================
*/
void FormSelectUserFormClosed(object sender, FormClosedEventArgs e)
{
if (DataConfig.typeConnection == DataConstants.CONNETION_LOCAL && oleDb != null)
{
oleDb.Dispose();
}
if (DataConfig.typeConnection == DataConstants.CONNETION_SERVER && sqlServer != null)
{
sqlServer.Dispose();
}
if (DataConfig.programClose)
{
Application.Exit();
}
}
public static void ReadSettings()
{
DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
DataConfig.oledbConnectLineEnd = ";Jet OLEDB:Database Password="******"12345";
OleDb oleDb;
oleDb = new OleDb(DataConfig.configFile);
try{
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Settings";
oleDb.ExecuteFill("Settings");
if (oleDb.dataSet.Tables["Settings"].Rows[0]["autoUpdate"].ToString() == "True")
{
DataConfig.autoUpdate = true;
}
else
{
DataConfig.autoUpdate = false;
}
if (oleDb.dataSet.Tables["Settings"].Rows[0]["showConsole"].ToString() == "True")
{
DataConfig.showConsole = true;
}
else
{
DataConfig.showConsole = false;
}
DataConfig.period = oleDb.dataSet.Tables["Settings"].Rows[0]["period"].ToString();
oleDb.Dispose();
Utilits.Console.Log("[Настройки]: Настройки программы успешно загружены.");
}catch (Exception ex) {
oleDb.Error();
MessageBox.Show("[Настройки]: " + ex.ToString(), "Ошибка");
Application.Exit();
}
DataConfig.oledbConnectLineBegin = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
DataConfig.oledbConnectLineEnd = "";
DataConfig.oledbConnectPass = "";
}
void reportOleDb()
{
OleDb oleDb = null;
try{
oleDb = new OleDb(DataConfig.localDatabase);
oleDb.dataSet.Clear();
oleDb.oleDbCommandSelect.CommandText = getCommandSelectOleDb();
/*
* oleDb.oleDbCommandSelect.CommandText = "SELECT " +
* "OrderNomenclature.name " +
* "FROM OrderNomenclature, Orders "+
* "WHERE (OrderNomenclature.counteragentName = '" + counteragentTextBox.Text + "') "+
* "AND (Orders.docCounteragent = '" + counteragentTextBox.Text + "') "+
* "AND (OrderNomenclature.docOrder = Orders.docNumber) " +
* "AND (Orders.docDate BETWEEN #" +
* dateTimePicker1.Value.ToString("MM.dd.yyyy").Replace(".", "/") + "# AND #" +
* dateTimePicker2.Value.ToString("MM.dd.yyyy").Replace(".", "/") + "#) ";
*/
if (oleDb.ExecuteFill("OrderNomenclature"))
{
if (oleDb.dataSet.Tables.Count > 0)
{
dataGridView1.DataSource = oleDb.dataSet;
dataGridView1.DataMember = oleDb.dataSet.Tables[0].TableName;
settingsColumns();
}
}
}catch (Exception ex) {
if (oleDb != null)
{
oleDb.Dispose();
}
Utilits.Console.Log("[ОШИБКА]: " + ex.Message, false, true);
}
}
public void Dispose()
{
if (oleDbConnection != null)
{
if (oleDbDataReader != null)
{
oleDbDataReader.Close();
}
oleDbConnection.Close();
oleDbCommand.Dispose();
oleDbConnection.Dispose();
}
if (sqlConnection != null)
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
sqlConnection.Close();
sqlCommand.Dispose();
sqlConnection.Dispose();
}
if (oleDb != null)
{
oleDb.Dispose();
}
if (oleDbQuery != null)
{
oleDbQuery.Dispose();
}
if (sqlServer != null)
{
sqlServer.Dispose();
}
if (sqlQuery != null)
{
sqlQuery.Dispose();
}
}
void createOrdersOleDb()
{
Double sum = 0;
Double amount = 0;
Double price = 0;
Double vat = 0;
Double total = 0;
OleDb oleDb = null;
QueryOleDb oleDbQuery = null;
OrderDoc orderDoc;
try{
oleDb = new OleDb(DataConfig.localDatabase);
foreach (Price plist in priceList) // Обход прайсов
{
sum = 0;
amount = 0;
price = 0;
vat = 0;
total = 0;
/* Создание основной информации документа заказ */
orderDoc = new OrderDoc();
orderDoc.docDate = DateTime.Today.Date;
orderDoc.docNumber = createDocNumber();
orderDoc.docName = "Заказ";
orderDoc.docCounteragent = plist.counteragentName;
orderDoc.docAutor = DataConfig.userName;
orderDoc.docSum = 0;
orderDoc.docVat = 0;
orderDoc.docTotal = 0;
orderDoc.docPurchasePlan = docPPNumber;
oleDb = new OleDb(DataConfig.localDatabase);
oleDb.oleDbCommandSelect.CommandText = "SELECT " +
"id, nomenclatureID, nomenclatureName, units, amount, " +
"name, price, manufacturer, remainder, term, discount1, discount2, discount3, discount4, code, series, article, " +
"counteragentName, counteragentPricelist, " +
"docPurchasePlan, docOrder " +
"FROM OrderNomenclature WHERE (docPurchasePlan = '" + docPPNumber + "' AND counteragentName = '" + plist.counteragentName + "')";
oleDb.oleDbCommandUpdate.CommandText = "UPDATE OrderNomenclature SET " +
"nomenclatureID = @nomenclatureID, nomenclatureName = @nomenclatureName, units = @units, amount = @amount, " +
"name = @name, price = @price, manufacturer = @manufacturer, remainder = @remainder, term = @term, " +
"discount1 = @discount1, discount2 = @discount2, discount3 = @discount3, discount4 = @discount4, " +
"code = @code, series = @series, article = @article, " +
"counteragentName = @counteragentName, counteragentPricelist = @counteragentPricelist, " +
"docPurchasePlan = @docPurchasePlan, docOrder = @docOrder " +
"WHERE ([id] = @id)";
oleDb.oleDbCommandUpdate.Parameters.Add("@nomenclatureID", OleDbType.Integer, 10, "nomenclatureID");
oleDb.oleDbCommandUpdate.Parameters.Add("@nomenclatureName", OleDbType.VarChar, 255, "nomenclatureName");
oleDb.oleDbCommandUpdate.Parameters.Add("@units", OleDbType.VarChar, 255, "units");
oleDb.oleDbCommandUpdate.Parameters.Add("@amount", OleDbType.Double, 15, "amount");
oleDb.oleDbCommandUpdate.Parameters.Add("@name", OleDbType.VarChar, 255, "name");
oleDb.oleDbCommandUpdate.Parameters.Add("@price", OleDbType.Double, 15, "price");
oleDb.oleDbCommandUpdate.Parameters.Add("@manufacturer", OleDbType.VarChar, 255, "manufacturer");
oleDb.oleDbCommandUpdate.Parameters.Add("@remainder", OleDbType.Double, 15, "remainder");
oleDb.oleDbCommandUpdate.Parameters.Add("@term", OleDbType.Date, 15, "term");
oleDb.oleDbCommandUpdate.Parameters.Add("@discount1", OleDbType.Double, 15, "discount1");
oleDb.oleDbCommandUpdate.Parameters.Add("@discount2", OleDbType.Double, 15, "discount2");
oleDb.oleDbCommandUpdate.Parameters.Add("@discount3", OleDbType.Double, 15, "discount3");
oleDb.oleDbCommandUpdate.Parameters.Add("@discount4", OleDbType.Double, 15, "discount4");
oleDb.oleDbCommandUpdate.Parameters.Add("@code", OleDbType.VarChar, 255, "code");
oleDb.oleDbCommandUpdate.Parameters.Add("@series", OleDbType.VarChar, 255, "series");
oleDb.oleDbCommandUpdate.Parameters.Add("@article", OleDbType.VarChar, 255, "article");
oleDb.oleDbCommandUpdate.Parameters.Add("@counteragentName", OleDbType.VarChar, 255, "counteragentName");
oleDb.oleDbCommandUpdate.Parameters.Add("@counteragentPricelist", OleDbType.VarChar, 255, "counteragentPricelist");
oleDb.oleDbCommandUpdate.Parameters.Add("@docPurchasePlan", OleDbType.VarChar, 255, "docPurchasePlan");
oleDb.oleDbCommandUpdate.Parameters.Add("@docOrder", OleDbType.VarChar, 255, "docOrder");
oleDb.oleDbCommandUpdate.Parameters.Add("@id", OleDbType.Integer, 10, "id");
if (oleDb.ExecuteFill("OrderNomenclature")) // получаем перечень номенклатуры ПЗ
{
if (oleDb.dataSet.Tables["OrderNomenclature"].Rows.Count <= 0)
{
continue; // пропускаем (нет номенклатуры по данному контрагенту)
}
foreach (DataRow row in oleDb.dataSet.Tables["OrderNomenclature"].Rows)
{
/* Привязываем к документу */
row["docOrder"] = orderDoc.docNumber;
/* Вычисления */
price = (Double)row["price"];
amount = (Double)row["amount"];
sum += (price * amount);
}
/* Итоги вычислений */
sum = Math.Round(sum, 2);
vat = sum * DataConstants.ConstFirmVAT / 100;
vat = Math.Round(vat, 2);
total = sum + vat;
total = Math.Round(total, 2);
orderDoc.docSum = sum;
orderDoc.docVat = vat;
orderDoc.docTotal = total;
/* Создаём новый заказ */
oleDbQuery = new QueryOleDb(DataConfig.localDatabase);
oleDbQuery.SetCommand("INSERT INTO Orders " +
"(docDate, docNumber, docName, docCounteragent, " +
"docAutor, docSum, docVat, docTotal, docPurchasePlan) " +
"VALUES ('" + orderDoc.docDate + "', " +
"'" + orderDoc.docNumber + "', " +
"'" + orderDoc.docName + "', " +
"'" + orderDoc.docCounteragent + "', " +
"'" + orderDoc.docAutor + "', " +
"" + Conversion.DoubleToString(orderDoc.docSum) + ", " +
"" + Conversion.DoubleToString(orderDoc.docVat) + ", " +
"" + Conversion.DoubleToString(orderDoc.docTotal) + ", " +
"'" + orderDoc.docPurchasePlan + "')");
if (oleDbQuery.Execute())
{
/* Обновляем журнал Заказов */
DataForms.FClient.updateHistory("Orders");
Utilits.Console.Log("Ввод на основании: создан Заказ №" + orderDoc.docNumber + " для План закупок №" + docPPNumber);
/* Обновление номенклатуры ПЗ (добавляем номер документа Заказ) */
if (oleDb.ExecuteUpdate("OrderNomenclature"))
{
Utilits.Console.Log("Ввод на основании: План заказов №" + docPPNumber + " обновлён.");
}
else
{
if (oleDb != null)
{
oleDb.Dispose();
}
if (oleDbQuery != null)
{
oleDbQuery.Dispose();
}
Utilits.Console.Log("[ОШИБКА] Ввод на основании: План закупок №" + docPPNumber + " не удалось одновить! Заказ №" + orderDoc.docNumber, false, true);
MessageBox.Show("Не удалось обновить План закупок №" + docPPNumber + " Создание заказов прервано!", "Сообщение");
return;
}
}
else
{
if (oleDb != null)
{
oleDb.Dispose();
}
if (oleDbQuery != null)
{
oleDbQuery.Dispose();
}
Utilits.Console.Log("[ОШИБКА] Ввод на основании: Не удалось создать Заказ для План закупок №" + docPPNumber, false, true);
MessageBox.Show("Не удалось создать Заказ для План закупок №" + docPPNumber, "Сообщение");
return;
}
}
else
{
if (oleDb != null)
{
oleDb.Dispose();
}
if (oleDbQuery != null)
{
oleDbQuery.Dispose();
}
Utilits.Console.Log("[ОШИБКА] Ввод на основании: Не удалось загрузить перечень номенклатуры из документа" + docPPNumber, false, true);
MessageBox.Show("Не удалось загрузить перечень номенклатуры из документа" + docPPNumber + "" + Environment.NewLine +
"Создание Заказов на основании Плана закупок невозможно!", "Сообщение");
return;
}
}
}catch (Exception ex) {
if (oleDb != null)
{
oleDb.Dispose();
}
if (oleDbQuery != null)
{
oleDbQuery.Dispose();
}
Utilits.Console.Log("[ОШИБКА] Ввод на основании: " + ex.Message, false, true);
}
if (oleDb != null)
{
oleDb.Dispose();
}
if (oleDbQuery != null)
{
oleDbQuery.Dispose();
}
MessageBox.Show("План закупок №" + docPPNumber + " был успешно обработан!" + Environment.NewLine + "Заказы созданы в соответствии с выбранными прайс-листами и номенклатурой! ", "Сообщение");
}
public static bool Verification()
{
OleDb oleDb;
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Practice";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Practice";
if (!oleDb.ExecuteFill("Practice"))
{
return(false);
}
Forms.FMain.progressLoad(5);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Tests";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Tests";
if (!oleDb.ExecuteFill("Tests"))
{
return(false);
}
Forms.FMain.progressLoad(10);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "EngRusVocabulary";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM EngRusVocabulary";
if (!oleDb.ExecuteFill("EngRusVocabulary"))
{
return(false);
}
Forms.FMain.progressLoad(15);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "IrregularVerbs";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM IrregularVerbs";
if (!oleDb.ExecuteFill("IrregularVerbs"))
{
return(false);
}
Forms.FMain.progressLoad(20);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "ModalVerbs";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM ModalVerbs";
if (!oleDb.ExecuteFill("ModalVerbs"))
{
return(false);
}
Forms.FMain.progressLoad(30);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "RegularVerbs";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM RegularVerbs";
if (!oleDb.ExecuteFill("RegularVerbs"))
{
return(false);
}
Forms.FMain.progressLoad(40);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Pronouns";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Pronouns";
if (!oleDb.ExecuteFill("Pronouns"))
{
return(false);
}
Forms.FMain.progressLoad(45);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Articles";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Articles";
if (!oleDb.ExecuteFill("Articles"))
{
return(false);
}
Forms.FMain.progressLoad(50);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Nouns";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Nouns";
if (!oleDb.ExecuteFill("Nouns"))
{
return(false);
}
Forms.FMain.progressLoad(55);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Adjective";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Adjective";
if (!oleDb.ExecuteFill("Adjective"))
{
return(false);
}
Forms.FMain.progressLoad(60);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Numeral";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Numeral";
if (!oleDb.ExecuteFill("Numeral"))
{
return(false);
}
Forms.FMain.progressLoad(65);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Adverb";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Adverb";
if (!oleDb.ExecuteFill("Adverb"))
{
return(false);
}
Forms.FMain.progressLoad(70);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Conditions";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Conditions";
if (!oleDb.ExecuteFill("Conditions"))
{
return(false);
}
Forms.FMain.progressLoad(75);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Preposition";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Preposition";
if (!oleDb.ExecuteFill("Preposition"))
{
return(false);
}
Forms.FMain.progressLoad(80);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Unions";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Unions";
if (!oleDb.ExecuteFill("Unions"))
{
return(false);
}
Forms.FMain.progressLoad(85);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Particles";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Particles";
if (!oleDb.ExecuteFill("Particles"))
{
return(false);
}
Forms.FMain.progressLoad(90);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "ModalWords";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM ModalWords";
if (!oleDb.ExecuteFill("ModalWords"))
{
return(false);
}
Forms.FMain.progressLoad(95);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "IntroductoryWords";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM IntroductoryWords";
if (!oleDb.ExecuteFill("IntroductoryWords"))
{
return(false);
}
Forms.FMain.progressLoad(98);
oleDb.Dispose();
oleDb = new OleDb(Config.databaseFile);
oleDb.dataSet.Clear();
oleDb.dataSet.DataSetName = "Interjections";
oleDb.oleDbCommandSelect.CommandText = "SELECT * FROM Interjections";
if (!oleDb.ExecuteFill("Interjections"))
{
return(false);
}
Forms.FMain.progressLoad(100);
oleDb.Dispose();
return(true);
}
public void Dispose()
{
oleDb.Dispose();
tables.Clear();
tables = null;
}
