public void removeCatalogCoupon()
{
using (var db = new CS_DBEntities3())//adding user and category for test
{
ca_da.addCatalogCoupon(cat1);
Assert.IsTrue(ca_da.existsCatalogCoupon(cat1));
ca_da.removeCatalogCoupon(cat1);
Assert.IsFalse(ca_da.existsCatalogCoupon(cat1));
TestBuisness.clearAllTable();
}
TestBuisness.clearAllTable();
}
public void updateCatalogCouponAverageRank()
{
using (var db = new CS_DBEntities3())//adding user and category for test
{
ca_da.addCatalogCoupon(cat1);
Assert.IsTrue(ca_da.existsCatalogCoupon(cat1));
double newValue = 13;
ca_da.updatAverageRank(cat1, newValue);
CatalogCoupon afterUpdate = ca_da.findCatalogCoupon(cat1);
Assert.AreEqual(newValue, afterUpdate.averageRank);
TestBuisness.clearAllTable();
}
TestBuisness.clearAllTable();
}
public void updateCatalogCouponDescription()
{
using (var db = new CS_DBEntities3())//adding user and category for test
{
ca_da.addCatalogCoupon(cat1);
Assert.IsTrue(ca_da.existsCatalogCoupon(cat1));
string newDescription = "Shusi and gril";
ca_da.updateDescription(cat1, newDescription);
CatalogCoupon afterUpdate = ca_da.findCatalogCoupon(cat1);
Assert.AreEqual(newDescription, afterUpdate.description);
TestBuisness.clearAllTable();
}
TestBuisness.clearAllTable();
}
public void updateCatalogCouponPriceAfterDiscount()
{
using (var db = new CS_DBEntities3())//adding user and category for test
{
ca_da.addCatalogCoupon(cat1);
Assert.IsTrue(ca_da.existsCatalogCoupon(cat1));
double newValue = 5.54;
ca_da.updatePriceAfterDiscount(cat1, newValue);
CatalogCoupon afterUpdate = ca_da.findCatalogCoupon(cat1);
Assert.AreEqual(newValue, afterUpdate.priceAfterDiscount);
TestBuisness.clearAllTable();
}
TestBuisness.clearAllTable();
}
public static void clearAllTable()
{
using (var db = new CS_DBEntities3())
{
foreach (var cat in db.Categories)
{
db.Entry(cat).Collection("Users_Customer").Load();
foreach (var item in db.Users_Customer)
{
cat.Users_Customer.Remove(item);
}
}
db.SaveChanges();
var query1 = from b in db.Buisnesses
select b;
foreach (var item in query1)
{
db.Buisnesses.Remove(item);
}
var query2 = from b in db.Users
select b;
foreach (var item in query2)
{
db.Users.Remove(item);
}
var query3 = from b in db.Categories
select b;
foreach (var item in query3)
{
db.Categories.Remove(item);
}
var query4 = from b in db.Users_BuisnessOwner
select b;
foreach (var item in query4)
{
db.Users_BuisnessOwner.Remove(item);
}
var query5 = from b in db.Locations
select b;
foreach (var item in query5)
{
db.Locations.Remove(item);
}
var query6 = from b in db.CatalogCoupons
select b;
foreach (var item in query6)
{
db.CatalogCoupons.Remove(item);
}
var query7 = from b in db.CatalogCoupons_SocialNetworkCoupon
select b;
foreach (var item in query7)
{
db.CatalogCoupons_SocialNetworkCoupon.Remove(item);
}
var query8 = from b in db.OrderedCoupons
select b;
foreach (var item in query8)
{
db.OrderedCoupons.Remove(item);
}
var query9 = from b in db.Users_Customer
select b;
foreach (var item in query9)
{
db.Users_Customer.Remove(item);
}
var query10 = from b in db.Users_SystemAdministrator
select b;
foreach (var item in query10)
{
db.Users_SystemAdministrator.Remove(item);
}
db.SaveChanges();
}
}
