public void OrdersProvider() { var storage = new AccessStorage(typeof (OrdersFixed), @"..\data\TestData.mdb"); storage.SelectSql = "SELECT * FROM Orders"; storage.FillRecordCallback = new FillRecordHandler(FillRecordOrder); object[] res = storage.ExtractRecords(); Assert.AreEqual(830, res.Length); Assert.AreEqual(typeof (OrdersFixed), res[0].GetType()); }
public void CustomersProvider() { var storage = new AccessStorage(typeof (CustomersVerticalBar), @"..\data\TestData.mdb"); storage.SelectSql = "SELECT * FROM Customers"; storage.FillRecordCallback = new FillRecordHandler(FillRecordCust); object[] res = storage.ExtractRecords(); Assert.AreEqual(91, res.Length); Assert.AreEqual(typeof (CustomersVerticalBar), res[0].GetType()); }
public void CustomersDbToFile() { var storage = new AccessStorage(typeof (CustomersVerticalBar), @"..\data\TestData.mdb"); storage.SelectSql = "SELECT * FROM Customers"; storage.FillRecordCallback = new FillRecordHandler(FillRecordCustomers); mLink = new FileDataLink(storage); mLink.ExtractToFile(@"..\data\temp.txt"); int extractNum = mLink.LastExtractedRecords.Length; var records = (CustomersVerticalBar[]) mLink.FileHelperEngine.ReadFile(@"..\data\temp.txt"); Assert.AreEqual(extractNum, records.Length); }
public void OrdersDbToFileEasy() { AccessStorage storage = new AccessStorage(typeof(OrdersFixed), @"..\data\TestData.mdb"); storage.SelectSql = "SELECT * FROM Orders"; storage.FillRecordCallback = new FillRecordHandler(FillRecordOrders); OrdersFixed[] records = (OrdersFixed[]) FileDataLink.EasyExtractToFile(storage,@"..\data\temp.txt"); int extractNum = records.Length; records = (OrdersFixed[]) CommonEngine.ReadFile(typeof(OrdersFixed), @"..\data\temp.txt"); Assert.AreEqual(extractNum, records.Length); }
private void cmdRun_Click(object sender, EventArgs e) { try { cmdRun.Enabled = false; lblStatus.Text = "Creating the DataLinkEngine"; AccessStorage storage = new AccessStorage(typeof(CustomersVerticalBar), MainClass.GlobalTestMdb); storage.SelectSql = "SELECT * FROM Customers"; storage.FillRecordCallback = new FillRecordHandler(FillRecord); storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSql); FileDataLink mLink = new FileDataLink(storage); Application.DoEvents(); Thread.Sleep(800); // Db -> File lblStatus.Text = "Extracting records from the access db to a file"; mLink.ExtractToFile(@"temp.txt"); Application.DoEvents(); Thread.Sleep(800); // File -> Db lblStatus.Text = "Inserting records from a file to the access db"; mLink.InsertFromFile(@"temp.txt"); if (File.Exists(@"temp.txt")) File.Delete(@"temp.txt"); Application.DoEvents(); Thread.Sleep(800); lblStatus.Text = "DONE !!!"; } catch (Exception ex) { MessageBox.Show(ex.ToString(), "Unexpected Error !!", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cmdRun.Enabled = true; } }
public void CustomersFileToDb() { var storage = new AccessStorage(typeof(CustomersVerticalBar), @"..\data\TestData.mdb"); storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlCust); mLink = new FileDataLink(storage); ClearData(((AccessStorage) mLink.DataStorage).AccessFileName, "CustomersTemp"); int count = Count(((AccessStorage) mLink.DataStorage).AccessFileName, "CustomersTemp"); Assert.AreEqual(0, count); mLink.InsertFromFile(@"..\data\UpLoadCustomers.txt"); count = Count(((AccessStorage) mLink.DataStorage).AccessFileName, "CustomersTemp"); Assert.AreEqual(91, count); ClearData(((AccessStorage) mLink.DataStorage).AccessFileName, "CustomersTemp"); }
public void OrdersFileToDb() { AccessStorage storage = new AccessStorage(typeof(OrdersFixed), @"..\data\TestData.mdb"); storage.InsertSqlCallback = new InsertSqlHandler(GetInsertSqlOrder); mLink = new FileDataLink(storage); ClearData(((AccessStorage) mLink.DataStorage).AccessFileName, "OrdersTemp"); int count = Count(((AccessStorage) mLink.DataStorage).AccessFileName, "OrdersTemp"); Assert.AreEqual(0, count); mLink.InsertFromFile(@"..\data\UpLoadOrders.txt"); count = Count(((AccessStorage) mLink.DataStorage).AccessFileName, "OrdersTemp"); Assert.AreEqual(830, count); ClearData(((AccessStorage) mLink.DataStorage).AccessFileName, "OrdersTemp"); }