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());
}
private void cmdRun_Click(object sender, EventArgs e)
{
try
{
cmdRun.Enabled = false;
lblStatus.Text = "Creating the DataLinkEngine";
AccessStorage storage = new AccessStorage(typeof(CustomersVerticalBar), "TestData.mdb");
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 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()
{
var storage = new AccessStorage(typeof(OrdersFixed), @"..\data\TestData.mdb");
storage.SelectSql = "SELECT * FROM Orders";
storage.FillRecordCallback = new FillRecordHandler(FillRecordOrders);
var 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);
}
public void OrdersFileToDb()
{
var 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");
}
public void CustomersFileToDb()
{
AccessStorage 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");
}
