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);
}
