public AccountingSettings GetAccountingSettings()
{
try {
AccountingSettings result = new AccountingSettings();
using (DbConnection = new SQLitePersistence(DbConnectionSettings)) {
if (DbConnection.IsConnected()) {
using (DbCommand = new SQLiteCommand()) {
string sql =
"SELECT InterfaceId, Setting1, Setting2, Setting3, Setting4, Setting5 from Accounting";
DbCommand.CommandText = sql;
DataTable returnDT = DbConnection.ExecuteQuery(DbCommand);
if (returnDT.Rows.Count > 0) {
DataRow row = returnDT.Rows[0];
result.InterfaceId = Convert.ToInt32(row["InterfaceId"]);
result.Setting1 = row["Setting1"].ToString();
result.Setting2 = row["Setting2"].ToString();
result.Setting3 = row["Setting3"].ToString();
result.Setting4 = row["Setting4"].ToString();
result.Setting5 = row["Setting5"].ToString();
row = null;
}
returnDT = null;
}
}else {
throw new Exception("Unable to Connect");
}
}
return result;
}catch {
throw;
}
}
public int SaveAccountingSettings(AccountingSettings accountingSettings)
{
try {
int result = -1;
bool isNew = true;
using (DbConnection = new SQLitePersistence(DbConnectionSettings)) {
if (DbConnection.IsConnected()) {
using (DbCommand = new SQLiteCommand()) {
string sql = "SELECT COUNT(*) AS COUNT FROM Accounting ";
DbCommand.CommandText = sql;
isNew = Convert.ToBoolean(DbConnection.ExecuteCommand(DbCommand));
if (isNew) {
sql = "insert into Accounting (InterfaceId,Setting1,Setting2,Setting3,Setting4,Setting5) Values(@InterfaceId,@Setting1,@Setting2,@Setting3,@Setting4,@Setting5)";
}else {
sql =
@"UPDATE Accounting
SET InterfaceId = @InterfaceId, Setting1 = @Setting1,Setting2 = @Setting2,Setting3 = @Setting3,Setting4 = @Setting4,Setting5 = @Setting5
";
}
DbCommand.CommandText = sql;
DbCommand.Parameters.Clear();
DbCommand.Parameters.AddWithValue("@InterfaceId", accountingSettings.InterfaceId);
DbCommand.Parameters.AddWithValue("@Setting1", accountingSettings.Setting1 ?? string.Empty);
DbCommand.Parameters.AddWithValue("@Setting2", accountingSettings.Setting2 ?? string.Empty);
DbCommand.Parameters.AddWithValue("@Setting3", accountingSettings.Setting3 ?? string.Empty);
DbCommand.Parameters.AddWithValue("@Setting4", accountingSettings.Setting4 ?? string.Empty);
DbCommand.Parameters.AddWithValue("@Setting5", accountingSettings.Setting5 ?? string.Empty);
result = DbConnection.ExecuteCommand(DbCommand);
}
}else {
throw new Exception("Unable to Connect");
}
}
return result;
}catch {
throw;
}
}
public static void Startup(AccountingSettings settings)
{
Vars.ApplicationName = "Etech ServiceHost";
Vars.AccountingSettings = settings;
//@"C:\Users\Public\Documents\Intuit\QuickBooks\Company Files\Test Company.qbw";
}