private static string CreateBackupTable(IDataBase db, Table table)
{
var script = Base.JoinScriptFragments(table.Script(new ScriptingOptions {DriPrimaryKey = false, Statistics = false}));
var scriptForBackupTable = TransformCreationScriptForBackup(script, table.Name);
db.ExecuteNonQuery(scriptForBackupTable);
return Analyst.GetBackupTableName(table.Name);
}
private static DbState AndTheDbHasAtLeast2NonEmptyTablesWithDifferentNumberOfRowsAndFirstTableShouldntHaveTheHighestRowCount(IDataBase db)
{
var state = new DbState(db);
int? firstNonEmptyNumberOfRows = null;
foreach (var rowCount in state.Values)
{
if (rowCount == 0)
{
continue;
}
if (firstNonEmptyNumberOfRows == null)
{
firstNonEmptyNumberOfRows = rowCount;
}
else
{
if (firstNonEmptyNumberOfRows.Value < rowCount)
{
return state;
}
}
}
Assert.Fail("Test setup is wrong: should have at least 2 tables with different rowcount and bigger than zero, and the first table shouldn't be the one with the highest rowcount...");
return null;
}
public SettingsForm()
{
InitializeComponent();
_path = "base.txt";
_loader = new DB_File(_path);
}
public void Execute(IDataBase db)
{
var group = db.GetElements<Group>()[0];
db.FillElement(group);
var peoples = group.Peoples;
var test = db.GetElements<Test>()[0];
db.FillElement(test);
var passedTest1 = new PassedTest();
var passedTest2 = new PassedTest();
passedTest1.SetPeople(peoples[0]);
passedTest2.SetPeople(peoples[1]);
passedTest1.SetTest(test);
passedTest2.SetTest(test);
passedTest1.Replies[test.Questions[0]] = "Я не знаю ответа.";
passedTest1.Replies[test.Questions[1]] = "И тут я тоже не знаю ответа, увы.";
passedTest2.Replies[test.Questions[0]] = "Бла-бла-бла";
passedTest2.Replies[test.Questions[1]] = "Этой строки быть не должно";
passedTest2.Replies[test.Questions[1]] = "Проверка на изменение ответа";
db.ExecuteCommand(Parameters.Insert, passedTest1);
db.ExecuteCommand(Parameters.Insert, passedTest2);
}
public void Execute(IDataBase db)
{
var positions = new[]
{
"Плотник",
"Программист"
};
foreach (var position in positions)
{
db.InsertPosition(position);
}
var peoples = new[]
{
new People("Иванов Иван", positions[0]),
new People("Петров Петр", positions[0]),
new People("Князь Владимир", positions[1]),
new People("Клинт Бартон", positions[1]),
};
var groups = new[]
{
new Group("Карлики"),
new Group("Забегаловка")
};
groups[0].SetPeoples(new[] { peoples[0], peoples[2] });
groups[1].SetPeoples(new[] { peoples[1], peoples[3] });
foreach (var group in groups)
{
db.ExecuteCommand(Parameters.Insert, group);
}
}
public GoodsFiller(int link_id, IDataBase cdb, IXMLReader xreader, decimal userSale)
{
this.XGoods = new dev_xml_goods();
this.cdb = cdb;
this.cdb.SetStoredProcedure("WebSite.GetGoodsXML");
this.cdb.AddParameter(new SqlParameter("@Link_id", link_id));
this.cdb.AddParameter(new SqlParameter("@UserSale", userSale));
this.xreader = xreader;
this.xreader.LoadXML(this.cdb.GetScalarValue());
XGoods.Brand_id = this.xreader.GetAttribute<int>("brand_id", 0);
XGoods.Link_id = this.xreader.GetAttribute<int>("link_id", 0);
XGoods.Group_id = this.xreader.GetAttribute<int>("group_id", 0);
XGoods.Root = this.xreader.GetAttribute<int>("root", 0);
XGoods.Sound = this.xreader.GetAttribute<int>("sound", 0);
XGoods.Info = this.xreader.GetAttribute<int>("info", 0);
XGoods.Consists_id = this.xreader.GetAttribute<int>("consists_id", 0);
XGoods.Country_id = this.xreader.GetAttribute<int>("country_id", 0);
XGoods.Gtype_id = this.xreader.GetAttribute<int>("gtype_id", 0);
XGoods.Seria_id = this.xreader.GetAttribute<int>("seria_id", 0);
XGoods.Weight = this.xreader.GetAttribute<decimal>("weight", 0);
XGoods.Sale = this.xreader.GetAttribute<byte>("sale", 0);
XGoods.Seria_name = this.xreader.GetAttribute<string>("seria_name", "");
XGoods.Consists_name = this.xreader.GetAttribute<string>("consists_name", "");
XGoods.Gtype_name = this.xreader.GetAttribute<string>("gtype_name", "");
XGoods.Country_name = this.xreader.GetAttribute<string>("country_name", "");
XGoods.UT_video = this.xreader.GetAttribute<string>("ut_video", "");
XGoods.Name = this.xreader.GetAttribute<string>("name", "");
XGoods.Brand_name = this.xreader.GetAttribute<string>("brand_name", "");
XGoods.HasImg = this.xreader.GetAttribute<string>("has_img", "0").Equals("1") ? true : false;
XGoods.Descr = this.xreader.GetValue<string>("//link/descr", "").Replace(@"\n", "<br/>");
XGoods.Descr_Seo = this.xreader.GetValue<string>("//link/descr_seo", "");
//filling goods properies
XmlNodeList goodsList = this.xreader.GetXmlNodes("//link//goods//good");
foreach (XmlNode child in goodsList)
{
SGoodsFiller sgFiller = new SGoodsFiller(child, this.xreader);
XGoods.Items.Add(sgFiller.XSGoods);
}
//filling goods mechs
XmlNodeList mechList = this.xreader.GetXmlNodes("//link//mechs//mech");
foreach (XmlNode child in mechList)
{
GoodsMechsFiller smFiller = new GoodsMechsFiller(child, this.xreader);
XGoods.Mechs.Add(smFiller.Mech);
}
//filling goods sames
XmlNodeList sameList = this.xreader.GetXmlNodes("//link//sames//same");
foreach (XmlNode child in sameList)
{
GoodsSamesFiller gsameFiller = new GoodsSamesFiller(child, this.xreader);
XGoods.Sames.Add(gsameFiller.Same);
}
}
public void BisectDatabase(IDataBase db, Func<IDataBase, bool> testOperation)
{
Table tableToBisect;
while ((tableToBisect = _analyst.ChooseTableToBisect(db)) != null)
{
_bisector.BisectTableOnce(db, tableToBisect, testOperation);
}
}
private void InsertSomeDataInBisectedTable(IDataBase db)
{
const string insertSql = @"
SET IDENTITY_INSERT {0} ON
INSERT INTO baz(ID,baf) VALUES (1,'lele')
SET IDENTITY_INSERT {0} OFF";
db.ExecuteNonQuery(String.Format(insertSql, AndTheTableIChooseIs(db).Name));
}
public MinesweeperEngine(IDataBase db, ICommandManager commandManager, IInputReader reader, IOutputWriter writer)
{
this.db = db;
this.commandManager = commandManager;
this.commandManager.Engine = this;
this.reader = reader;
this.writer = writer;
}
static DALBase()
{
DataBaseAccess _db = CmsDataBase.Main;
DbFact = _db.DataBaseAdapter;
_table_prefix = CmsDataBase.TablePrefix;
//SQLPack对象
SP = SqlPack.Factory(_db.DbType);
}
public AccountingModel()
{
_db = new DataBase.Repository.DataBase();
_goodsRepository = new GoodsRepository(_db);
_roleRepository = new RoleRepository(_db);
_orderRepository = new OrderRepository(_db);
_userRepository = new UserRepository(_db);
}
public MainForm(People people, IDataBase db)
{
_passedTest = new PassedTest();
_passedTest.SetPeople(people);
_db = db;
InitializeComponent();
}
private static void CheckAndInit()
{
if (!inited)
{
DataBaseAccess _db = CmsDataBase.Instance;
DbFact = _db.DataBaseAdapter;
//SQLPack对象
inited = true;
}
}
private void submit_Click(object sender, EventArgs e)
{
if (_method.Equals("DB_File"))
_loader = new DB_File(_path);
else if (_method.Equals("DB_Connected"))
_loader = new DB_Connected();
else if (_method.Equals("DB_Disconnected"))
_loader = new DB_Disconnected();
Method(_loader);
}
public void Execute(IDataBase db)
{
var generalComponents = new[]
{
new Component("Знания"),
new Component("Умения"),
new Component("Владения практическими навыками"),
new Component("Ответственность"),
new Component("Инициатива и творческий подход"),
};
var _3level = new[]
{
new Component("Стратегия взаимодействия и общения в процессе обучения"),
new Component("Владение информационной этикой"),
new Component("Дистанционная коммуникация"),
new Component("Работа с аппаратным обеспечением"),
new Component("Работа с программным обеспечением"),
new Component("Работа с современными технологиями обработки информации и нормативными документами"),
new Component("Потребность в работе с информацией"),
new Component("Понимание значимости принимаемых решений"),
new Component("Интерес к знаниям, стремление добиться успеха в проф. Деятельности"),
new Component("Осознание ответственности за действия"),
new Component("Контроль произведенных действий, выработка рекомендаций для будущих действий"),
new Component("Анализ, планирование и предвидение ситуации")
};
foreach (var component3Level in _3level)
{
component3Level.Components.AddRange(generalComponents);
}
var _2level = new[]
{
new Component("Рефлексивно-коммуникативный компонент"),
new Component("Профессионально-деятельностный компонент"),
new Component("Ценностно-мотивационный компонент"),
new Component("Ответственно-аналитический компонент")
};
_2level[0].Components.AddRange(new[] { _3level[0], _3level[1], _3level[2] });
_2level[1].Components.AddRange(new[] { _3level[3], _3level[4], _3level[5] });
_2level[2].Components.AddRange(new[] { _3level[6], _3level[7], _3level[8] });
_2level[3].Components.AddRange(new[] { _3level[9], _3level[10], _3level[11] });
var component = new Component("Компоненты, составляющие компонентов и показатели учения и др. характеристики информационной компетентности специалистов здравоохранения");
component.Components.AddRange(_2level);
db.ExecuteCommand(Parameters.Insert, component);
}
/// <summary>
/// 数据库实例
/// </summary>
/// <returns>数据库对象</returns>
public static IDataBase GetInstance()
{
lock (locker)
{
if (_DbHelper != null)
{
return _DbHelper;
}
else
{
return _DbHelper = new DataBase("DbConn");
}
}
}
public void Execute(IDataBase db)
{
var cerifiedTest = new CertifiedTest();
var passedTest = db.GetElements<PassedTest>()[0];
var olapRound = db.GetOlapRounds()[0];
db.FillElement(passedTest);
cerifiedTest.SetPassedTest(passedTest);
cerifiedTest.Assessments[cerifiedTest.PassedTest.Test.Questions[0]] = 70;
cerifiedTest.Assessments[cerifiedTest.PassedTest.Test.Questions[1]] = 43;
db.ExecuteCommand(Parameters.Insert, cerifiedTest);
db.InsertLinkOlapRoundPassedTest(olapRound, passedTest);
}
static void MoveData(IDataBase db, Table source, Table destination)
{
if (!AreTablesEquivalent(source, destination))
{
throw new InvalidOperationException("Both tables need to have same set of columns to move data between them");
}
string commaSeparatedColumns = String.Join(",", (from Column column in source.Columns select column.Name).ToArray());
const string copyToTableSql = @"
SET IDENTITY_INSERT {0} ON
INSERT INTO {0}({1}) SELECT {1} FROM {2}
SET IDENTITY_INSERT {0} OFF";
db.ExecuteNonQuery(String.Format(copyToTableSql, destination, commaSeparatedColumns, source.Name));
DeleteContentsOfTable(db, source);
}
public NewTest(IDataBase db)
{
InitializeComponent();
_db = db;
_2Level = new List<string>();
_3Level = new Dictionary<string, List<string>>();
_generalComponents = new List<string>();
_questions = new List<Question>();
_selectedComponent = null;
_assessments = new Dictionary<string, TemplateAssessments>();
}
public static List<ClassDefinition> ReadSchema(IDataBase driver)
{
List<ClassDefinition> tables = new List<ClassDefinition>();
using (IDbConnection connection = driver.getConnection())
{
if (connection.State == ConnectionState.Broken ||
connection.State == ConnectionState.Closed)
connection.Open();
DataTable tableList = driver.getSchema("Tables", new string[] { });
tableList.DefaultView.RowFilter = "(table_schema <> 'information_schema') AND (table_schema <> 'pg_catalog')";
foreach (DataRow row in tableList.DefaultView.ToTable().Rows)
tables.Add(new ClassDefinition(row["TABLE_NAME"].ToString()));
}
return tables;
}
private void Authorization_Load(object sender, EventArgs e)
{
try
{
_db = new DataBaseMicrosoft(SolutionConfiguration.DatabaseType, SolutionConfiguration.DatabaseArguments);
UpdateElements();
}
catch (Exception ex)
{
var exceptionMessage = ex.InnerException?.Message ?? ex.Message;
MessageBox.Show(exceptionMessage, "Ошибка", MessageBoxButtons.OK, MessageBoxIcon.Error);
Application.Exit();
}
}
public static List<BankEntryDTO> Validate(List<BankEntryDTO> bankEntries, IDataBase db)
{
IList<BankEntry> allEntriesInTimeInterval = db.getEntries();
//a preferable solution would be
//SortEntriesByDate()
//GetEntriesInDateInterval()
//Naive looping
foreach (BankEntryDTO bankEntryDTO in bankEntries)
{
markAsFine(bankEntryDTO);
markDuplicate(bankEntryDTO, allEntriesInTimeInterval);
}
return bankEntries;
}
public static void BisectTableOnce(IDataBase db, Table table, Func<IDataBase,bool> verification)
{
string backupTableName = CreateBackupTable(db, table);
db.Tables.Refresh();
Table backupTable = db.Tables[backupTableName];
MoveData(db, table, backupTable);
if (!verification.Invoke(db))
{
DeleteContentsOfTable(db, table);
MoveData(db, backupTable, table);
} else {
DeleteContentsOfTable(db, table);
}
}
public MainModel(IDataBase method)
{
_list = new QuestionList();
_DBMethod = method;
_level = 1;
try
{
_random = new Question();
Load();
}
catch (ArgumentNullException ex)
{
// QUESTION.Text = ex.ParamName;
}
catch (IndexOutOfRangeException ex)
{
// QUESTION.Text = ex.ToString();
}
}
public Table ChooseTableToBisect(IDataBase db)
{
var state = new DbState(db);
var candidateTables = new HashSet<string>(state.Keys);
foreach (Table table in db.Tables)
{
foreach (ForeignKey fk in table.ForeignKeys)
{
candidateTables.Remove(fk.ReferencedTable);
}
if (IsBackUpTable(table.Name) || state.Keys.Contains(GetBackupTableName(table.Name)))
{
candidateTables.Remove(table.Name);
}
}
KeyValuePair<string, int>? highest = null;
foreach (var table in candidateTables)
{
var rowCount = state[table];
if (state[table] > 0)
{
if (highest == null ||
highest.Value.Value < rowCount)
{
highest = new KeyValuePair<string, int>(table, rowCount);
}
}
}
if (highest == null)
return null;
return db.Tables[highest.Value.Key];
}
public ItemController(IDataBase db)
{
_db = db;
}
public AppointmentMapperSqlite(IDataBase db) : base(db)
{
}
public MarketRepository(IDataBase dbService)
{
_dbService = dbService;
}
public override void AddNew()
{
string sql = "insert into PS_SLUICE(ID,US_OBJECT_ID,DS_OBJECT_ID,SYSTEM_TYPE,INVERT_LEVEL,Width,OPEN_LIMIT,SLUICE_TYPE,"
+ "STATE,PRESSURE,ROAD_NAME,ACQUISITION_DATE,Remark,US_SURVEY_ID,DS_SURVEY_ID,"
+ "ACQUISITION_UNIT,PROCESS_DATE,PROCESS_UNIT,SHAPE_Length)"
+ " values(@ID,@US_OBJECT_ID,@DS_OBJECT_ID,@SYSTEM_TYPE,@INVERT_LEVEL,@Width,@OPEN_LIMIT,@SLUICE_TYPE,"
+ "@STATE,@PRESSURE,@ROAD_NAME,@ACQUISITION_DATE,@Remark,@US_SURVEY_ID,@DS_SURVEY_ID,"
+ "@ACQUISITION_UNIT,@PROCESS_DATE,@PROCESS_UNIT,@SHAPE_Length)";
SQLiteParameter[] Parameters = new SQLiteParameter[]
{
new SQLiteParameter()
{
ParameterName = "@ID", Value = this.ID
},
new SQLiteParameter()
{
ParameterName = "@US_OBJECT_ID", Value = this.US_OBJECT_ID
},
new SQLiteParameter()
{
ParameterName = "@DS_OBJECT_ID", Value = this.DS_OBJECT_ID
},
new SQLiteParameter()
{
ParameterName = "@SYSTEM_TYPE", Value = this.SYSTEM_TYPE
},
new SQLiteParameter()
{
ParameterName = "@INVERT_LEVEL", Value = string.IsNullOrEmpty(this.INVERT_LEVEL)?DBNull.Value:(object)double.Parse(this.INVERT_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@Width", Value = string.IsNullOrEmpty(this.Width)?DBNull.Value:(object)double.Parse(this.Width)
},
new SQLiteParameter()
{
ParameterName = "@OPEN_LIMIT", Value = string.IsNullOrEmpty(this.OPEN_LIMIT)?DBNull.Value:(object)double.Parse(this.OPEN_LIMIT)
},
new SQLiteParameter()
{
ParameterName = "@SLUICE_TYPE", Value = this.SLUICE_TYPE
},
new SQLiteParameter()
{
ParameterName = "@STATE", Value = this.STATE
},
new SQLiteParameter()
{
ParameterName = "@ROAD_NAME", Value = this.ROAD_NAME
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_DATE", Value = this.ACQUISITION_DATE
},
new SQLiteParameter()
{
ParameterName = "@Remark", Value = this.Remark
},
new SQLiteParameter()
{
ParameterName = "@US_SURVEY_ID", Value = this.US_SURVEY_ID
},
new SQLiteParameter()
{
ParameterName = "@DS_SURVEY_ID", Value = this.DS_SURVEY_ID
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_UNIT", Value = this.ACQUISITION_UNIT
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_DATE", Value = this.PROCESS_Date
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_UNIT", Value = this.PROCESS_Unit
},
new SQLiteParameter()
{
ParameterName = "@SHAPE_Length", Value = string.IsNullOrEmpty(this.Lenght)?DBNull.Value:(object)double.Parse(this.Lenght)
}
};
IDataBase pDataBase = SysDBUnitiy.OleDataBase;
pDataBase.OpenConnection();
try
{
pDataBase.ExecuteNonQuery(sql, Parameters);
this.CurClassName = "PS_SLUICE";
//sql = "select max(objectid) from PS_SLUICE";
//this.ObjectID = int.Parse(pDataBase.ExecuteScalar(sql).ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
pDataBase.CloseConnection();
}
}
public VoteController(IDataBase database)
{
Data = database;
}
protected override void OnUnsubscribe(IDataBase dataBase)
{
dataBase.Dispatcher.Invoke(() => dataBase.TableContext.Tables.TablesStateChanged -= Tables_TablesStateChanged);
}
public DashboardController(IDataBase db)
{
_db = db;
}
public override void AddNew()
{
SQLiteParameter[] Parameters = new SQLiteParameter[]
{
new SQLiteParameter()
{
ParameterName = "@ID", Value = this.ID
},
new SQLiteParameter()
{
ParameterName = "@SYSTEM_TYPE", Value = this.SYSTEM_TYPE
},
new SQLiteParameter()
{
ParameterName = "@ROAD_NAME", Value = this.ROAD_NAME
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_DATE", Value = this.ACQUISITION_DATE
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_UNIT", Value = this.ACQUISITION_UNIT
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_UNIT", Value = this.PROCESS_Unit
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_DATE", Value = this.PROCESS_Date
},
new SQLiteParameter()
{
ParameterName = "@STATE", Value = this.STATE
},
new SQLiteParameter()
{
ParameterName = "@Remark", Value = this.Remark
},
new SQLiteParameter()
{
ParameterName = "@GROUND_LEVEL", Value = string.IsNullOrEmpty(this.GROUND_LEVEL)?DBNull.Value:(object)this.GROUND_LEVEL
},
new SQLiteParameter()
{
ParameterName = "@CO_X", Value = this.X
},
new SQLiteParameter()
{
ParameterName = "@CO_Y", Value = this.Y
},
new SQLiteParameter()
{
ParameterName = "@SURVEY_ID", Value = this.SURVEY_ID
},
new SQLiteParameter()
{
ParameterName = "@INVERT_LEVEL", Value = string.IsNullOrEmpty(this.INVERT_LEVEL)?DBNull.Value: (object)this.INVERT_LEVEL
},
new SQLiteParameter()
{
ParameterName = "@MANHOLE_TYPE", Value = this.MANHOLE_TYPE
},
new SQLiteParameter()
{
ParameterName = "@SEDIMENT_DEPTH", Value = string.IsNullOrEmpty(this.SEDIMENT_DEPTH)?DBNull.Value:(object)this.SEDIMENT_DEPTH
},
new SQLiteParameter()
{
ParameterName = "@FLOW_STATE", Value = this.FLOW_STATE
},
new SQLiteParameter()
{
ParameterName = "@BOTTOM_TYPE", Value = this.BOTTOM_TYPE
},
new SQLiteParameter()
{
ParameterName = "@MANHOLE_MATERIAL", Value = this.MANHOLE_MATERIAL
},
new SQLiteParameter()
{
ParameterName = "@MANHOLE_SHAPE", Value = this.MANHOLE_SHAPE
},
new SQLiteParameter()
{
ParameterName = "@COVER_MATERIAL", Value = this.COVER_MATERIAL
},
new SQLiteParameter()
{
ParameterName = "@COVER_STATE", Value = this.COVER_STATE
},
new SQLiteParameter()
{
ParameterName = "@WATER_QUALITY", Value = this.WATER_QUALITY
},
new SQLiteParameter()
{
ParameterName = "@WATER_LEVEL", Value = string.IsNullOrEmpty(this.WATER_LEVEL)?DBNull.Value:(object)this.WATER_LEVEL
}
// new SQLiteParameter(){ ParameterName="@ObjectID" ,Value=this.ObjectID,OleDbType= OleDbType.Integer}
};
string sql = "insert into PS_MANHOLE(ID,SYSTEM_TYPE,ROAD_NAME,ACQUISITION_DATE,ACQUISITION_UNIT"
+ ",PROCESS_UNIT,PROCESS_DATE,STATE,Remark,GROUND_LEVEL,CO_X,CO_Y,SURVEY_ID,INVERT_LEVEL,"
+ " MANHOLE_TYPE,SEDIMENT_DEPTH,FLOW_STATE,BOTTOM_TYPE,MANHOLE_MATERIAL,MANHOLE_SHAPE,COVER_MATERIAL,"
+ "COVER_STATE,WATER_QUALITY,WATER_LEVEL"
+ ") values( "
+ " @ID,@SYSTEM_TYPE,@ROAD_NAME,@ACQUISITION_DATE,@ACQUISITION_UNIT,@PROCESS_UNIT,@PROCESS_DATE,@STATE,"
+ " @Remark,@GROUND_LEVEL,@CO_X,@CO_Y,@SURVEY_ID,@INVERT_LEVEL,@MANHOLE_TYPE,@SEDIMENT_DEPTH,@FLOW_STATE,"
+ "@BOTTOM_TYPE,@MANHOLE_MATERIAL,@MANHOLE_SHAPE,@COVER_MATERIAL,@COVER_STATE,@WATER_QUALITY,@WATER_LEVEL)";
IDataBase pDataBase = SysDBUnitiy.OleDataBase;
pDataBase.OpenConnection();
try
{
pDataBase.ExecuteNonQuery(sql, Parameters);
sql = string.Format("insert into pointstable(ID,CO_X,CO_Y,ClassName,SURVEY_ID) values('{0}',{1},{2},'{3}','{4}')",
ID, this.X, this.Y, this.ClassName, this.SURVEY_ID);
pDataBase.ExecuteNonQuery(sql);
//this.CurClassName = "PS_MANHOLE";
//sql = "select max(objectid) from PS_MANHOLE";
//this.ObjectID = int.Parse(pDataBase.ExecuteScalar(sql).ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
pDataBase.CloseConnection();
}
}
public TableRootTreeViewItemViewModel(Authentication authentication, IDataBase dataBase, object selector)
: base(authentication, dataBase.TableContext.Root, selector)
{
this.dataBaseName = dataBase.Name;
}
public ProductsService(IDataBase database, IRepository <ProductOptions> productOptionsrepository, FilterService filterService)
{
this.database = database;
this.productOptionsrepository = productOptionsrepository;
this.filterService = filterService;
}
public GameLoop(IWriteToClient writeToClient, ICache cache, ICommands commands, ICombat combat, IDataBase database, IDice dice, IUpdateClientUI client, ITime time, ICore core, ISpellList spelllist, IWeather weather)
{
_writeToClient = writeToClient;
_cache = cache;
_commands = commands;
_combat = combat;
_db = database;
_dice = dice;
_client = client;
_time = time;
_core = core;
_spellList = spelllist;
_weather = weather;
if (_hints == null)
{
_hints = _core.Hints();
}
}
public static void InitMockDataBase()
{
_database = new MockDataBase();
}
public BaseTest()
{
this.db = new DBSql();
}
public MobController(IDataBase db)
{
_db = db;
}
public UserRepository(IDataBase _database, ILogger <UserRepository> _logger)
{
database = _database;
logger = _logger;
}
public AlarmController(IDataBase scheduleDb, IDataBase alarmDb, IDataBase settingsDB)
{
this.scheduleDatabase = scheduleDb;
this.alarmHistoryDatabase = alarmDb;
this.settingsDatabase = settingsDB;
}
public Participant(IDataBase dataBase)
{
Data = dataBase;
}
void dgViewLoad()
{
dgEntrusted.DataSource = IDataBase.DataToDataTable("select * from Books where IsActive=1 and Status=1");
dgBooks.DataSource = IDataBase.DataToDataTable("select * from Books where IsActive=1 and Status=0");
dgReaders.DataSource = IDataBase.DataToDataTable("select * from Readers where IsActive=1 ");
}
public ProviderSQL()
{
_db = DataBase.GetDataBase();
}
public FlightPlanManager(IDataBase sqliteData)
{
sqliteDataBase = sqliteData;
}
public DashboardController(IDataBase db, ICache cache)
{
_db = db;
_cache = cache;
}
public override void Update()
{
SQLiteParameter[] Parameters = new SQLiteParameter[]
{
new SQLiteParameter()
{
ParameterName = "@SYSTEM_TYPE", Value = this.SYSTEM_TYPE
},
new SQLiteParameter()
{
ParameterName = "@ROAD_NAME", Value = this.ROAD_NAME
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_DATE", Value = this.ACQUISITION_DATE
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_UNIT", Value = this.ACQUISITION_UNIT
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_UNIT", Value = this.PROCESS_Unit
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_DATE", Value = this.PROCESS_Date
},
new SQLiteParameter()
{
ParameterName = "@STATE", Value = this.STATE
},
new SQLiteParameter()
{
ParameterName = "@REMARK", Value = this.Remark
},
new SQLiteParameter()
{
ParameterName = "@GROUND_LEVEL", Value = string.IsNullOrEmpty(this.GROUND_LEVEL)?DBNull.Value:(object)this.GROUND_LEVEL
},
new SQLiteParameter()
{
ParameterName = "@CO_X", Value = this.X
},
new SQLiteParameter()
{
ParameterName = "@CO_Y", Value = this.Y
},
new SQLiteParameter()
{
ParameterName = "@SURVEY_ID", Value = this.SURVEY_ID
},
new SQLiteParameter()
{
ParameterName = "@INVERT_LEVEL", Value = string.IsNullOrEmpty(this.INVERT_LEVEL)?DBNull.Value: (object)this.INVERT_LEVEL
},
new SQLiteParameter()
{
ParameterName = "@MANHOLE_TYPE", Value = this.MANHOLE_TYPE
},
new SQLiteParameter()
{
ParameterName = "@SEDIMENT_DEPTH", Value = string.IsNullOrEmpty(this.SEDIMENT_DEPTH)?DBNull.Value:(object)this.SEDIMENT_DEPTH
},
new SQLiteParameter()
{
ParameterName = "@FLOW_STATE", Value = this.FLOW_STATE
},
new SQLiteParameter()
{
ParameterName = "@BOTTOM_TYPE", Value = this.BOTTOM_TYPE
},
new SQLiteParameter()
{
ParameterName = "@MANHOLE_MATERIAL", Value = this.MANHOLE_MATERIAL
},
new SQLiteParameter()
{
ParameterName = "@MANHOLE_SHAPE", Value = this.MANHOLE_SHAPE
},
new SQLiteParameter()
{
ParameterName = "@COVER_MATERIAL", Value = this.COVER_MATERIAL
},
new SQLiteParameter()
{
ParameterName = "@COVER_STATE", Value = this.COVER_STATE
},
new SQLiteParameter()
{
ParameterName = "@WATER_QUALITY", Value = this.WATER_QUALITY
},
new SQLiteParameter()
{
ParameterName = "@WATER_LEVEL", Value = string.IsNullOrEmpty(this.WATER_LEVEL)?DBNull.Value:(object)this.WATER_LEVEL
},
new SQLiteParameter()
{
ParameterName = "@ID", Value = this.ID
}
//new SQLiteParameter(){ ParameterName="@ObjectID" ,Value=this.ObjectID,OleDbType= OleDbType.Integer}
};
string sql = string.Format("update PS_MANHOLE set SYSTEM_TYPE=@SYSTEM_TYPE,ROAD_NAME=@ROAD_NAME,"
+ "ACQUISITION_DATE=@ACQUISITION_DATE,ACQUISITION_UNIT=@ACQUISITION_UNIT,PROCESS_UNIT=@PROCESS_UNIT,"
+ "PROCESS_DATE=@PROCESS_DATE,STATE=@STATE,REMARK=@REMARK,"
+ "GROUND_LEVEL=@GROUND_LEVEL,CO_X=@CO_X,CO_Y=@CO_Y,SURVEY_ID=@SURVEY_ID,INVERT_LEVEL=@INVERT_LEVEL,"
+ " MANHOLE_TYPE=@MANHOLE_TYPE,SEDIMENT_DEPTH=@SEDIMENT_DEPTH,FLOW_STATE=@FLOW_STATE,BOTTOM_TYPE=@BOTTOM_TYPE,"
+ " MANHOLE_MATERIAL=@MANHOLE_MATERIAL,MANHOLE_SHAPE=@MANHOLE_SHAPE,COVER_MATERIAL=@COVER_MATERIAL,COVER_STATE=@COVER_STATE,"
+ " WATER_QUALITY=@WATER_QUALITY"
+ " where ID=@ID ");
IDataBase pDataBase = SysDBUnitiy.OleDataBase;
pDataBase.OpenConnection();
try
{
pDataBase.ExecuteNonQuery(sql, Parameters);
}
catch (Exception ex)
{
throw ex;
}
finally
{
pDataBase.CloseConnection();
}
}
public EventRepository(IDataBase dbService)
{
_dbService = dbService;
}
public override void Update()
{
string sql = "update PS_PIPE set US_OBJECT_ID=@US_OBJECT_ID,DS_OBJECT_ID=@DS_OBJECT_ID,SYSTEM_TYPE=@SYSTEM_TYPE,Width=@Width,PIPE_LENGTH=@PIPE_LENGTH,"
+ "US_POINT_INVERT_LEVEL=@US_POINT_INVERT_LEVEL,US_INVERT_LEVEL=@US_INVERT_LEVEL,DS_POINT_INVERT_LEVEL=@DS_POINT_INVERT_LEVEL,DS_INVERT_LEVEL=@DS_INVERT_LEVEL,SEDIMENT_DEPTH=@SEDIMENT_DEPTH,"
+ "MATERIAL=@MATERIAL,STATE=@STATE,PRESSURE=@PRESSURE,ROAD_NAME=@ROAD_NAME,ACQUISITION_DATE=@ACQUISITION_DATE,Remark=@Remark,US_SURVEY_ID=@US_SURVEY_ID,DS_SURVEY_ID=@DS_SURVEY_ID,"
+ "ACQUISITION_UNIT=@ACQUISITION_UNIT,PROCESS_DATE=@PROCESS_DATE,PROCESS_UNIT=@PROCESS_UNIT,SHAPE_Length=@SHAPE_Length,Water_State=@Water_State,WATER_QUALITY=@WATER_QUALITY,WATER_LEVEL=@WATER_LEVEL,Dirtcion=@Dirtcion where ID=@ID ";
SQLiteParameter[] Parameters = new SQLiteParameter[]
{
new SQLiteParameter()
{
ParameterName = "@US_OBJECT_ID", Value = this.US_OBJECT_ID
},
new SQLiteParameter()
{
ParameterName = "@DS_OBJECT_ID", Value = this.DS_OBJECT_ID
},
new SQLiteParameter()
{
ParameterName = "@SYSTEM_TYPE", Value = this.SYSTEM_TYPE
},
new SQLiteParameter()
{
ParameterName = "@Width", Value = string.IsNullOrEmpty(this.Width)?DBNull.Value:(object)int.Parse(this.Width)
},
new SQLiteParameter()
{
ParameterName = "@PIPE_LENGTH", Value = string.IsNullOrEmpty(this.Pipe_Length)?DBNull.Value:(object)double.Parse(this.Pipe_Length)
},
new SQLiteParameter()
{
ParameterName = "@US_POINT_INVERT_LEVEL", Value = string.IsNullOrEmpty(this.US_POINT_INVERT_LEVEL)?DBNull.Value:(object)double.Parse(this.US_POINT_INVERT_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@US_INVERT_LEVEL", Value = string.IsNullOrEmpty(this.US_INVERT_LEVEL)?DBNull.Value:(object)double.Parse(this.US_INVERT_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@DS_POINT_INVERT_LEVEL", Value = string.IsNullOrEmpty(this.DS_POINT_INVERT_LEVEL)?DBNull.Value:(object)double.Parse(this.DS_POINT_INVERT_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@DS_INVERT_LEVEL", Value = string.IsNullOrEmpty(this.DS_INVERT_LEVEL)?DBNull.Value:(object)double.Parse(this.DS_INVERT_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@SEDIMENT_DEPTH", Value = string.IsNullOrEmpty(this.SEDIMENT_DEPTH)?DBNull.Value:(object)double.Parse(this.SEDIMENT_DEPTH)
},
new SQLiteParameter()
{
ParameterName = "@MATERIAL", Value = this.MATERIAL
},
new SQLiteParameter()
{
ParameterName = "@STATE", Value = this.STATE
},
new SQLiteParameter()
{
ParameterName = "@PRESSURE", Value = this.PRESSURE
},
new SQLiteParameter()
{
ParameterName = "@ROAD_NAME", Value = this.ROAD_NAME
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_DATE", Value = this.ACQUISITION_DATE
},
new SQLiteParameter()
{
ParameterName = "@Remark", Value = this.Remark
},
new SQLiteParameter()
{
ParameterName = "@US_SURVEY_ID", Value = this.US_SURVEY_ID
},
new SQLiteParameter()
{
ParameterName = "@DS_SURVEY_ID", Value = this.DS_SURVEY_ID
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_UNIT", Value = this.ACQUISITION_UNIT
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_DATE", Value = this.PROCESS_Date
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_UNIT", Value = this.PROCESS_Unit
},
new SQLiteParameter()
{
ParameterName = "@SHAPE_Length", Value = string.IsNullOrEmpty(this.Lenght)?DBNull.Value:(object)double.Parse(this.Lenght)
},
new SQLiteParameter()
{
ParameterName = "@Water_State", Value = this.WATER_State
},
new SQLiteParameter()
{
ParameterName = "@WATER_QUALITY", Value = this.WATER_QUALITY
},
new SQLiteParameter()
{
ParameterName = "@WATER_LEVEL", Value = string.IsNullOrEmpty(this.WATER_LEVEL)?DBNull.Value:(object)double.Parse(this.WATER_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@Dirtcion", Value = this.Dirtcion
},
//new SQLiteParameter(){ ParameterName="@OBJECTID" ,Value=this.ObjectID,OleDbType= OleDbType.Integer }
new SQLiteParameter()
{
ParameterName = "@ID", Value = this.ID
}
};
IDataBase pDataBase = SysDBUnitiy.OleDataBase;
pDataBase.OpenConnection();
try
{
pDataBase.ExecuteNonQuery(sql, Parameters);
}
catch (Exception ex)
{
throw ex;
}
finally
{
pDataBase.CloseConnection();
}
}
/* public override void Delete()
* {
*
* string sql = string.Format("update {0} set IsDelete=0 where ID='{1}'", this.ClassName, this.ID);
* IDataBase pDataBase = SysDBUnitiy.OleDataBase;
* pDataBase.OpenConnection();
* try
* {
* pDataBase.ExecuteNonQuery(sql);
* }
* finally
* {
* pDataBase.CloseConnection();
* }
*
*
* }*/
public override void AddNew()
{
string sql = "insert into PS_PIPE(ID,US_OBJECT_ID,DS_OBJECT_ID,SYSTEM_TYPE,Width,PIPE_LENGTH,"
+ "US_POINT_INVERT_LEVEL,US_INVERT_LEVEL,DS_POINT_INVERT_LEVEL,DS_INVERT_LEVEL,SEDIMENT_DEPTH,"
+ "MATERIAL,STATE,PRESSURE,ROAD_NAME,ACQUISITION_DATE,Remark,US_SURVEY_ID,DS_SURVEY_ID,"
+ "ACQUISITION_UNIT,PROCESS_DATE,PROCESS_UNIT,SHAPE_Length,Water_State,WATER_QUALITY,WATER_LEVEL,Dirtcion) "
+ " values(@ID,@US_OBJECT_ID,@DS_OBJECT_ID,@SYSTEM_TYPE,@Width,@PIPE_LENGTH,"
+ "@US_POINT_INVERT_LEVEL,@US_INVERT_LEVEL,@DS_POINT_INVERT_LEVEL,@DS_INVERT_LEVEL,@SEDIMENT_DEPTH,"
+ "@MATERIAL,@STATE,@PRESSURE,@ROAD_NAME,@ACQUISITION_DATE,@Remark,@US_SURVEY_ID,@DS_SURVEY_ID,"
+ "@ACQUISITION_UNIT,@PROCESS_DATE,@PROCESS_UNIT,@SHAPE_Length,@Water_State,@WATER_QUALITY,@WATER_LEVEL,@Dirtcion)";
SQLiteParameter[] Parameters = new SQLiteParameter[]
{
new SQLiteParameter()
{
ParameterName = "@ID", Value = this.ID
},
new SQLiteParameter()
{
ParameterName = "@US_OBJECT_ID", Value = this.US_OBJECT_ID
},
new SQLiteParameter()
{
ParameterName = "@DS_OBJECT_ID", Value = this.DS_OBJECT_ID
},
new SQLiteParameter()
{
ParameterName = "@SYSTEM_TYPE", Value = this.SYSTEM_TYPE
},
new SQLiteParameter()
{
ParameterName = "@Width", Value = this.Width
},
new SQLiteParameter()
{
ParameterName = "@PIPE_LENGTH", Value = string.IsNullOrEmpty(this.Pipe_Length)?DBNull.Value:(object)double.Parse(this.Pipe_Length)
},
new SQLiteParameter()
{
ParameterName = "@US_POINT_INVERT_LEVEL", Value = string.IsNullOrEmpty(this.US_POINT_INVERT_LEVEL)?DBNull.Value:(object)double.Parse(this.US_POINT_INVERT_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@US_INVERT_LEVEL", Value = string.IsNullOrEmpty(this.US_INVERT_LEVEL)?DBNull.Value:(object)double.Parse(this.US_INVERT_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@DS_POINT_INVERT_LEVEL", Value = string.IsNullOrEmpty(this.DS_POINT_INVERT_LEVEL)?DBNull.Value:(object)double.Parse(this.DS_POINT_INVERT_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@DS_INVERT_LEVEL", Value = string.IsNullOrEmpty(this.DS_INVERT_LEVEL)?DBNull.Value:(object)double.Parse(this.DS_INVERT_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@SEDIMENT_DEPTH", Value = string.IsNullOrEmpty(this.SEDIMENT_DEPTH)?DBNull.Value:(object)double.Parse(this.SEDIMENT_DEPTH)
},
new SQLiteParameter()
{
ParameterName = "@MATERIAL", Value = this.MATERIAL
},
new SQLiteParameter()
{
ParameterName = "@STATE", Value = this.STATE
},
new SQLiteParameter()
{
ParameterName = "@PRESSURE", Value = this.PRESSURE
},
new SQLiteParameter()
{
ParameterName = "@ROAD_NAME", Value = this.ROAD_NAME
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_DATE", Value = this.ACQUISITION_DATE
},
new SQLiteParameter()
{
ParameterName = "@Remark", Value = this.Remark
},
new SQLiteParameter()
{
ParameterName = "@US_SURVEY_ID", Value = this.US_SURVEY_ID
},
new SQLiteParameter()
{
ParameterName = "@DS_SURVEY_ID", Value = this.DS_SURVEY_ID
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_UNIT", Value = this.ACQUISITION_UNIT
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_DATE", Value = this.PROCESS_Date
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_UNIT", Value = this.PROCESS_Unit
},
new SQLiteParameter()
{
ParameterName = "@SHAPE_Length", Value = string.IsNullOrEmpty(this.Lenght)?DBNull.Value:(object)double.Parse(this.Lenght)
},
new SQLiteParameter()
{
ParameterName = "@Water_State", Value = this.WATER_State
},
new SQLiteParameter()
{
ParameterName = "@WATER_QUALITY", Value = this.WATER_QUALITY
},
new SQLiteParameter()
{
ParameterName = "@WATER_LEVEL", Value = string.IsNullOrEmpty(this.WATER_LEVEL)?DBNull.Value:(object)double.Parse(this.WATER_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@Dirtcion", Value = this.Dirtcion
}
};
IDataBase pDataBase = SysDBUnitiy.OleDataBase;
pDataBase.OpenConnection();
try
{
pDataBase.ExecuteNonQuery(sql, Parameters);
//this.CurClassName = "PS_PIPE";
//sql = "select max(objectid) from PS_PIPE";
//this.ObjectID = int.Parse(pDataBase.ExecuteScalar(sql).ToString());
}
catch (Exception ex)
{
throw ex;
}
finally
{
pDataBase.CloseConnection();
}
}
public override void Update()
{
string sql = "update PS_SLUICE set US_OBJECT_ID=@US_OBJECT_ID,DS_OBJECT_ID=@DS_OBJECT_ID,SYSTEM_TYPE=@SYSTEM_TYPE,INVERT_LEVEL=@INVERT_LEVEL,Width=@Width,"
+ "OPEN_LIMIT=@OPEN_LIMIT,SLUICE_TYPE=@SLUICE_TYPE,STATE=@STATE,ROAD_NAME=@ROAD_NAME,ACQUISITION_DATE=@ACQUISITION_DATE,Remark=@Remark,US_SURVEY_ID=@US_SURVEY_ID,DS_SURVEY_ID=@DS_SURVEY_ID,"
+ "ACQUISITION_UNIT=@ACQUISITION_UNIT,PROCESS_DATE=@PROCESS_DATE,PROCESS_UNIT=@PROCESS_UNIT,SHAPE_Length=@SHAPE_Length where ID=@ID ";
SQLiteParameter[] Parameters = new SQLiteParameter[]
{
new SQLiteParameter()
{
ParameterName = "@US_OBJECT_ID", Value = this.US_OBJECT_ID
},
new SQLiteParameter()
{
ParameterName = "@DS_OBJECT_ID", Value = this.DS_OBJECT_ID
},
new SQLiteParameter()
{
ParameterName = "@SYSTEM_TYPE", Value = this.SYSTEM_TYPE
},
new SQLiteParameter()
{
ParameterName = "@INVERT_LEVEL", Value = string.IsNullOrEmpty(this.INVERT_LEVEL)?DBNull.Value:(object)double.Parse(this.INVERT_LEVEL)
},
new SQLiteParameter()
{
ParameterName = "@Width", Value = string.IsNullOrEmpty(this.Width)?DBNull.Value:(object)double.Parse(this.Width)
},
new SQLiteParameter()
{
ParameterName = "@OPEN_LIMIT", Value = string.IsNullOrEmpty(this.OPEN_LIMIT)?DBNull.Value:(object)double.Parse(this.OPEN_LIMIT)
},
new SQLiteParameter()
{
ParameterName = "@SLUICE_TYPE", Value = this.SLUICE_TYPE
},
new SQLiteParameter()
{
ParameterName = "@STATE", Value = this.STATE
},
new SQLiteParameter()
{
ParameterName = "@ROAD_NAME", Value = this.ROAD_NAME
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_DATE", Value = this.ACQUISITION_DATE
},
new SQLiteParameter()
{
ParameterName = "@Remark", Value = this.Remark
},
new SQLiteParameter()
{
ParameterName = "@US_SURVEY_ID", Value = this.US_SURVEY_ID
},
new SQLiteParameter()
{
ParameterName = "@DS_SURVEY_ID", Value = this.DS_SURVEY_ID
},
new SQLiteParameter()
{
ParameterName = "@ACQUISITION_UNIT", Value = this.ACQUISITION_UNIT
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_DATE", Value = this.PROCESS_Date
},
new SQLiteParameter()
{
ParameterName = "@PROCESS_UNIT", Value = this.PROCESS_Unit
},
new SQLiteParameter()
{
ParameterName = "@SHAPE_Length", Value = string.IsNullOrEmpty(this.Lenght)?DBNull.Value:(object)double.Parse(this.Lenght)
},
new SQLiteParameter()
{
ParameterName = "@ID", Value = this.ID
}
};
IDataBase pDataBase = SysDBUnitiy.OleDataBase;
pDataBase.OpenConnection();
try
{
pDataBase.ExecuteNonQuery(sql, Parameters);
}
catch (Exception ex)
{
throw ex;
}
finally
{
pDataBase.CloseConnection();
}
}
public SelectTable(DBType dbType, string ConnectionStr) : this()
{
dataBase = DataBaseFactory.GetDataBase(dbType, ConnectionStr);
}
public static void InitDataBase()
{
_database = new SQL();
}
/// <summary>
/// Process the startup args and initialise the logging.
/// </summary>
/// <param name="o"></param>
/// <param name="args"></param>
private static void Startup(DamselflyOptions o, string[] args)
{
Logging.Verbose = o.Verbose;
Logging.Trace = o.Trace;
if (Directory.Exists(o.SourceDirectory))
{
if (!Directory.Exists(o.ConfigPath))
{
Directory.CreateDirectory(o.ConfigPath);
}
Logging.LogFolder = Path.Combine(o.ConfigPath, "logs");
Log.Logger = Logging.InitLogs();
if (o.ReadOnly)
{
o.NoEnableIndexing = true;
o.NoGenerateThumbnails = true;
}
// TODO: Do away with static members here. We should pass this
// through to the config service and pick them up via DI
IndexingService.EnableIndexing = !o.NoEnableIndexing;
IndexingService.RootFolder = o.SourceDirectory;
ThumbnailService.PicturesRoot = o.SourceDirectory;
ThumbnailService.Synology = o.Synology;
ThumbnailService.SetThumbnailRoot(o.ThumbPath);
ThumbnailService.EnableThumbnailGeneration = !o.NoGenerateThumbnails;
var tieredPGO = System.Environment.GetEnvironmentVariable("DOTNET_TieredPGO") == "1";
Logging.Log("Startup State:");
Logging.Log($" Damselfly Ver: {Assembly.GetExecutingAssembly().GetName().Version}");
Logging.Log($" CLR Ver: {Environment.Version}");
Logging.Log($" OS: {Environment.OSVersion}");
Logging.Log($" CPU Arch: {RuntimeInformation.ProcessArchitecture}");
Logging.Log($" Processor Count: {Environment.ProcessorCount}");
Logging.Log($" Read-only mode: {o.ReadOnly}");
Logging.Log($" Synology = {o.Synology}");
Logging.Log($" Indexing = {!o.NoEnableIndexing}");
Logging.Log($" ThumbGen = {!o.NoGenerateThumbnails}");
Logging.Log($" Images Root set as {o.SourceDirectory}");
Logging.Log($" TieredPGO Enabled={tieredPGO}");
IDataBase dbType = null;
if (!o.UsePostgresDB)
{
string dbFolder = Path.Combine(o.ConfigPath, "db");
if (!Directory.Exists(dbFolder))
{
Logging.Log(" Created DB folder: {0}", dbFolder);
Directory.CreateDirectory(dbFolder);
}
string dbPath = Path.Combine(dbFolder, "damselfly.db");
dbType = new SqlLiteModel(dbPath);
Logging.Log(" Sqlite Database location: {0}", dbPath);
}
else // Postgres
{
// READ Postgres config json
dbType = PostgresModel.ReadSettings("settings.json");
Logging.Log(" Postgres Database location: {0}");
}
// TODO: https://docs.microsoft.com/en-us/ef/core/managing-schemas/migrations/providers?tabs=dotnet-core-cli
BaseDBModel.InitDB <ImageContext>(dbType, o.ReadOnly);
// Make ourselves low-priority.
System.Diagnostics.Process.GetCurrentProcess().PriorityClass = System.Diagnostics.ProcessPriorityClass.Idle;
StartWebServer(o.Port, args);
Logging.Log("Shutting down.");
}
else
{
Console.WriteLine("Folder {0} did not exist. Exiting.", o.SourceDirectory);
}
}
private void CreateConnection()
{
switch (cbxDriver.SelectedIndex)
{
case (int) Config.DBMS.PostgreSQL:
driver = new CsDO.Drivers.Npgsql.NpgsqlDriver(
Config.Server, Config.Port, Config.User,
Config.Database, Config.Password);
break;
case (int) Config.DBMS.OleDB:
driver = new CsDO.Drivers.OleDb.OleDbDriver(
Config.Server, Config.Database, Config.User,
Config.Password);
break;
case (int) Config.DBMS.MSSQLServer:
driver = new CsDO.Drivers.SqlServer.SqlServerDriver(
Config.Server, Config.User, Config.Database,
Config.Password);
break;
default:
driver = null;
break;
}
}
public PTTradingUnitOperator(IDataBase crtDataBase) : base(crtDataBase)
{
CurrentDataBase = crtDataBase;
TableName = MyTableName;
}
static Conf()
{
_driver = new CsDO.Drivers.Generic();
}
public TestOperator(IDataBase crtDataBase) : base(crtDataBase)
{
CurrentDataBase = crtDataBase;
this.TableName = MyTableName;
}
private void SetDBMethod(IDataBase method)
{
_mainModel.DBMethod = method;
_adminPanel.DB_Method = method;
_mainModel.Load();
}
public OracleDAOTestOperator(IDataBase database) : base(database)
{
TableName = myTableName;
}