public void TestPrinter() { IDataAccessor da = printerDA; read(da); Assert.AreEqual(0, dataSet.printer.Rows.Count, "Table is empty"); DataRow newRow = dataSet.printer.NewRow(); PrinterConverter.toDataRow(newRow, new Printer("TestPrinter")); dataSet.printer.Rows.Add(newRow); DataRow newRow2 = dataSet.printer.NewRow(); PrinterConverter.toDataRow(newRow2, new Printer("TestPrinter2")); dataSet.printer.Rows.Add(newRow2); write(da); read(da); Assert.AreEqual(1, dataSet.printer.Rows.Count, "Added one record"); DataRow firstRow = dataSet.printer.Rows[0]; Assert.AreEqual("TestPrinter", firstRow["name"], "Names are equals"); firstRow["name"] = "RenameTest"; write(da); List <DataRow> findList = dataSet.printer.Select("name = 'RenameTest'").OfType <DataRow>().ToList(); Assert.AreEqual("RenameTest", findList[0]["name"], "Names are equals"); firstRow.Delete(); write(da); read(da); int count = dataSet.printer.Rows.Count; Assert.AreEqual(0, count); }
public void TestTask() { IDataAccessor da = taskDA; read(da); DataTable table = dataSet.task; Assert.AreEqual(0, table.Rows.Count, "Table is empty"); DataRow personRow = dataSet.person.NewRow(); Person person = new Person("person", "", Person.PersonType.ADMIN); PersonConverter.toDataRow(personRow, person); dataSet.person.Rows.Add(personRow); write(personDA); DataRow modelRow = dataSet.model.NewRow(); Model model = new Model("model"); ModelConverter.toDataRow(modelRow, model); dataSet.model.Rows.Add(modelRow); write(modelDA); DataRow jobRow = dataSet.job.NewRow(); Job job = new Job(0, "job", DateTime.Now, "test", 0, 0); JobConverter.toDataRow(jobRow, job); dataSet.job.Rows.Add(jobRow); write(jobDA); DataRow printerRow = dataSet.printer.NewRow(); Printer printer = new Printer("printer"); PrinterConverter.toDataRow(printerRow, printer); dataSet.printer.Rows.Add(printerRow); write(printerDA); DataRow newRow = table.NewRow(); TaskConverter.toDataRow(newRow, new Task(0, "TestTask", 0, 0, DateTime.Now, DateTime.Now, DateTime.Now, Task.TaskStatus.NEW, 0)); table.Rows.Add(newRow); write(da); Assert.AreEqual(1, table.Rows.Count, "Added one record"); DataRow firstRow = table.Rows[0]; Assert.AreEqual("TestTask", firstRow["name"], "Names are equals"); firstRow["name"] = "RenameTest"; write(da); List <DataRow> findList = table.Select("name = 'RenameTest'").OfType <DataRow>().ToList(); Assert.AreEqual("RenameTest", findList[0]["name"], "Names are equals"); firstRow.Delete(); write(da); read(da); int count = dataSet.task.Rows.Count; Assert.AreEqual(0, count); }
public void TestClean() { IDataAccessor da = printerDA; read(da); DataTable table = dataSet.printer; DataRow newRow = table.NewRow(); PrinterConverter.toDataRow(newRow, new Printer("printerForClean")); table.Rows.Add(newRow); write(da); DBUtil.Clean(); read(da); Assert.AreEqual(0, dataSet.printer.Rows.Count); }
public void TestGetEmptyPrinters() { read(printerDA); System.Data.DataRow newRow; newRow = dataSet.printer.NewRow(); PrinterConverter.toDataRow(newRow, new Printer(1, "P1_e", Printer.PrinterStatus.EMPTY, true)); dataSet.printer.Rows.Add(newRow); newRow = dataSet.printer.NewRow(); PrinterConverter.toDataRow(newRow, new Printer(2, "P2_r", Printer.PrinterStatus.READY, true)); dataSet.printer.Rows.Add(newRow); newRow = dataSet.printer.NewRow(); PrinterConverter.toDataRow(newRow, new Printer(3, "P3_e", Printer.PrinterStatus.EMPTY, true)); dataSet.printer.Rows.Add(newRow); write(printerDA); logic.init(); System.Collections.Generic.List <Printer> list = logic.GetEmptyPrinters(); Assert.AreEqual(2, list.Count); }