public void modifyEntryTest() { ConnectionManager c = new ConnectionManager(); MySqlConnection connection = c.connectDatabase("Database = proximoDB; Data Source = us-cdbr-azure-central-a.cloudapp.net; User Id = b5fb261919a40c; Password = aff5b96f"); DateTime dt1 = new DateTime(2015, 01, 01); DateTime dt2 = new DateTime(2017, 01, 01); c.openConnection(connection); List <object> l = c.retrieveEntry(connection, dt1, dt2, "orderEntry"); c.closeConnection(connection); c.openConnection(connection); ((DailySalesDetails)l[1]).setDate(DateTime.Now); SalesEntry se = new SalesEntry(); DailySalesDetails ds = new DailySalesDetails(); SalesReturn sr = new SalesReturn(); ReturnEntry re = new ReturnEntry(); sr.addReturnEntry(re); sr.ReturnerID = 750; ds.SubmitterID = 565; ds.addEntry(se); se.Quantity = 50; System.DateTime now = System.DateTime.Now; ds.setDate(now); //c.modifyEntry(connection, ds, l[1]); }
public void storeEntryTest() { ConnectionManager c = new ConnectionManager(); MySqlConnection connection = c.connectDatabase("Database = proximoDB; Data Source = us-cdbr-azure-central-a.cloudapp.net; User Id = b5fb261919a40c; Password = aff5b96f"); SalesEntry se = new SalesEntry(); DailySalesDetails ds = new DailySalesDetails(); SalesReturn sr = new SalesReturn(); ReturnEntry re = new ReturnEntry(); Order newOrder = new Order(); newOrder.OrderId = 4578; newOrder.OrderRequestedDate = System.DateTime.Now; sr.addReturnEntry(re); sr.ReturnerID = 750; ds.SubmitterID = 565; ds.addEntry(se); se.Quantity = 50; se.Product = new Product(); c.openConnection(connection); System.DateTime now = System.DateTime.Now; ds.setDate(now); bool b = c.storeEntry(connection, ds); c.closeConnection(connection); }