public void SetUp()
{
conn = new Connection();
bl = new BlRequests(conn.getSqlCon());
try
{
conn.open();
bl.InsertUser("Amitay", "amitay", "12345678"); // customer
bl.InsertUser("shimi", "amitay", "12345678"); // manager
bl.InsertCategory(1, "Entertainment", "stand-ups, tv-Shows, etc...");
bl.InsertSecurePayment("Paypal", 5);
bl.InsertManager("shimi");
bl.InsertBusiness(1, "Hamashbir", "menashe kapara 33 Rehovot", "in the shop you can find a lot of things", "shimi");
bl.InsertCoupon(1, "dead-sea-soap", 100, 70, new DateTime(2014, 04, 06).Date, 1, 1);
bl.InsertCouponCategory(1, 1);
bl.InsertCustomer("Amitay", "*****@*****.**", "0542819491");
bl.InsertCustomerPreference("Amitay", 1);
bl.InsertDeal(1, 0, "11111", 1, "Amitay", "Paypal");
bl.InsertRates("Amitay", 1, 3, "good");
bl.InsertUser("haliliAsaf", "asaf", "mordchai");
bl.InsertUser("Fahima", "fahima", "vdvldms!ds");
bl.InsertSecurePayment("Cash", 3);
bl.InsertCategory(4, "Pnay", "some staff");
}
catch (Exception)
{ }
}
