public List <Lot> GetСonfirmedLots() { List <Lot> lots = new List <Lot>(); IEnumerable <DB_Lot> dblots = uow.Lots.GetWithInclude(l => (l.Category), l => (l.Owner)); foreach (DB_Lot lot in dblots) { if (lot.StartDate != new DateTime(0001, 1, 1, 0, 0, 0) && lot.EndDate > DateTime.Now) { Lot tempL = Mapper.Map <DB_Lot, Lot>(lot); lots.Add(tempL); } } foreach (Lot lot in lots) { if (lot.SubcategoryId > 0) { DB_Subcategory dbsubc = uow.Subcategories.FindById(lot.SubcategoryId); lot.Subcategory = dbsubc.Name; } else { lot.Subcategory = ""; } } return(lots); }
public void TestGetSubcategoriesByCateg() { ResetData(); List <DB_Subcategory> subcategories = new List <DB_Subcategory>(); DB_Subcategory subcatg1 = new DB_Subcategory(); DB_Subcategory subcatg2 = new DB_Subcategory(); subcatg1.Category = new DB_Category(); subcatg2.Category = new DB_Category(); string c_name = "New category"; string sc_name = "New subcategory"; subcatg1.Name = sc_name; subcatg1.Category.Name = c_name; subcategories.Add(subcatg1); subcategories.Add(subcatg2); mockSubcategories.Setup(a => a.GetWithInclude(s => s.Category)).Returns(subcategories); List <Subcategory> expected = new List <Subcategory>(); expected.Add(Mapper.Map <DB_Subcategory, Subcategory>(subcatg1)); var result = SubcO.GetSubcategoriesByCateg(c_name); Assert.AreEqual(expected.Capacity, result.Capacity); }
public void deleteSubcategory(int SubcategoryId) { DB_Subcategory subcategory = uow.Subcategories.FindById(SubcategoryId); if (subcategory != null) { uow.Subcategories.Remove(subcategory); } uow.Save(); }
public void SaveSubcategory(string SubcategoryName, string CategoryName) { int categ = 0; IEnumerable <DB_Category> categories = uow.Categories.Get(); foreach (DB_Category c in categories) { if (c.Name == CategoryName) { categ = c.CategoryId; } } DB_Subcategory subcateg = new DB_Subcategory { Name = SubcategoryName, Category = uow.Categories.FindById(categ) }; uow.Subcategories.Create(subcateg); uow.Save(); }
public void TestGetSubcategories() { ResetData(); List <DB_Subcategory> subcategories = new List <DB_Subcategory>(); DB_Subcategory subcatg1 = new DB_Subcategory(); DB_Subcategory subcatg2 = new DB_Subcategory(); subcategories.Add(subcatg1); subcategories.Add(subcatg2); mockSubcategories.Setup(a => a.GetWithInclude(s => s.Category)).Returns(subcategories); List <Subcategory> expected = new List <Subcategory>(); expected = Mapper.Map <List <DB_Subcategory>, List <Subcategory> >(subcategories); var result = SubcO.GetSubcategories(); Assert.AreEqual(expected.Capacity, result.Capacity); }
public void SaveSubcategory(string SubcategoryName, string CategoryName) { DB_Category categ = null; IEnumerable <DB_Category> categories = uow.Categories.Get(); foreach (DB_Category c in categories) { if (c.Name == CategoryName) { categ = c; } } DB_Subcategory subcateg = new DB_Subcategory { Name = SubcategoryName, Category = categ }; uow.Subcategories.Create(subcateg); uow.Save(); }