/// <summary> /// Downloads the table of the configuration database. /// </summary> public bool DownloadBaseTable(IBaseTable baseTable) { if (baseTable == null) { throw new ArgumentNullException(nameof(baseTable)); } DownloadFile( new RelativePath(TopFolder.Base, AppFolder.Root, baseTable.FileNameDat), 0, 0, false, DateTime.MinValue, () => { return(new MemoryStream()); }, out _, out FileReadingResult readingResult, out Stream stream); try { if (readingResult == FileReadingResult.EndOfFile && stream != null) { stream.Position = 0; BaseTableAdapter adapter = new BaseTableAdapter() { Stream = stream }; adapter.Fill(baseTable); return(true); } else { return(false); } } finally { stream?.Dispose(); } }
/// <summary> /// Opens an existing file for reading. /// </summary> protected override BinaryReader OpenRead(ConnectedClient client, RelativePath path) { switch (path.TopFolder) { case TopFolder.Base: if (coreLogic.ConfigDatabase.TableMap.TryGetValue(path.Path, out IBaseTable baseTable)) { BaseTableAdapter adapter = new BaseTableAdapter { Stream = new MemoryStream() }; adapter.Update(baseTable); adapter.Stream.Position = 0; return(new BinaryReader(adapter.Stream, Encoding.UTF8, false)); } else { throw new ScadaException(CommonPhrases.NamedFileNotFound, path); } case TopFolder.View: return(coreLogic.Storage.OpenBinary(DataCategory.View, path.Path)); default: throw new ProtocolException(ErrorCode.IllegalFunctionArguments, CommonPhrases.PathNotSupported); } }
public void Execute(DataTable table, string storageProc, params SqlParameter[] parameters) { BaseTableAdapter baseTableAdapter = TableAdapterFactory.AdapterFactory(table.TableName); baseTableAdapter.Connection = _transaction.Connection; baseTableAdapter.Transaction = this._transaction; baseTableAdapter.Execute(table, storageProc, parameters); }
/// <summary> /// Reads the table of the configuration database. /// </summary> public override void ReadBaseTable(IBaseTable baseTable) { BaseTableAdapter adapter = new BaseTableAdapter { FileName = Path.Combine(baseDir, baseTable.FileNameDat) }; adapter.Fill(baseTable); }
public void ReadData(DataTable table) { BaseTableAdapter baseTableAdapter = TableAdapterFactory.AdapterFactory(table.TableName); if (baseTableAdapter != null) { baseTableAdapter.Connection = _transaction.Connection; baseTableAdapter.Transaction = _transaction; baseTableAdapter.Fill(table); } }
public void UpdateData(DataTable table) { BaseTableAdapter baseTableAdapter = TableAdapterFactory.AdapterFactory(table.TableName); if (baseTableAdapter is UpdateBaseTableAdapter) { baseTableAdapter.Connection = _transaction.Connection; baseTableAdapter.Transaction = _transaction; ((UpdateBaseTableAdapter)baseTableAdapter).Update(table); } }
public void FillTablesFromDbForCustomerDataTest() { BaseTableAdapter table = null; foreach (string name in _glossariesName) { table = GetGlossary(name); } if (table != null) { int count = table.Fill(new DataTable("")); Assert.IsTrue(count > 0); } }
public void GetManyManyConnectionTableAdaptersTestMethod1() { Accounting.DAL.ConnectionManager.ConnectionManager.SetConnection(UserSettings.UserName, UserSettings.Password); //Accounting.DAL.ConnectionManager.ConnectionManager.Connection; BaseTableAdapter[] adapters = new BaseTableAdapter[10]; for (int i = 0; i < adapters.Length; i++) { adapters[i] = new GenderTableAdapter { Connection = Accounting.DAL.ConnectionManager.ConnectionManager.Connection }; adapters[i].Fill(new DataTable()); } Assert.AreEqual(adapters[0].Connection, adapters[1].Connection); }
protected BaseTableAdapter GetGlossary(string name) { BaseTableAdapter table = null; switch (name) { case "Address": table = new AddressTableAdapter() { Connection = _conn }; break; case "Customer": table = new Accounting.DAL.TableAdapters.CustomerTableAdapter.CustomerTableAdapter() { Connection = _conn }; break; case "Invalid": table = new InvalidBenefitsCategoryTableAdapter() { Connection = _conn }; break; case "Register": table = new RegisterTableAdapter() { Connection = _conn }; break; } return(table); }
protected BaseTableAdapter GetGlossary(string name) { BaseTableAdapter table = null; switch (name) { case "AdminDivision": table = new AdminDivisionTableAdapter() { Connection = _conn }; break; case "Gender": table = new GenderTableAdapter() { Connection = _conn }; break; case "ApppTpr": table = new ApppTprTableAdapter() { Connection = _conn }; break; case "Benefits": table = new BenefitsCategoryTableAdapter() { Connection = _conn }; break; case "ChiperRecept": table = new ChiperReceptTableAdapter() { Connection = _conn }; break; case "Disability": table = new DisabilityGroupTableAdapter() { Connection = _conn }; break; case "Land": table = new LandTableAdapter() { Connection = _conn }; break; case "Register": table = new RegisterTypeTableAdapter() { Connection = _conn }; break; case "TypeStreet": table = new TypeStreetTableAdapter() { Connection = _conn }; break; case "WhyDeReg": table = new WhyDeRegisterTableAdapter() { Connection = _conn }; break; } return(table); }