public async Task TestDeleteCurrentProduct()
{
DbContextOptions <FoodProductsContext> options = new DbContextOptionsBuilder <FoodProductsContext>().UseInMemoryDatabase(databaseName: "DeleteCurrentProduct").Options;
using (var context = new FoodProductsContext(options))
{
context.CurrentProducts.Add(new CurrentProducts()
{
Product = "Milo"
});
context.SaveChanges();
CurrentProducts currentProducts1 = context.CurrentProducts.First();
CurrentProductsController currentProductsController = new CurrentProductsController(context);
IActionResult result = await currentProductsController.DeleteCurrentProducts(currentProducts1.Id) as IActionResult;
var okObjectResult = result as OkObjectResult;
Assert.IsNotNull(okObjectResult);
var model = okObjectResult.Value as CurrentProducts;
Assert.IsNotNull(model);
Assert.AreNotEqual(0, model.Id);
Assert.AreEqual(currentProducts1.Product, model.Product);
Assert.AreEqual(false, context.MailingList.Any(x => x.Id == currentProducts1.Id));
}
}
public async Task TestPostCurrentProduct()
{
DbContextOptions <FoodProductsContext> options = new DbContextOptionsBuilder <FoodProductsContext>().UseInMemoryDatabase(databaseName: "PostCurrentProduct").Options;
using (var context = new FoodProductsContext(options))
{
CurrentProducts currentProducts1 = new CurrentProducts {
Product = "Maggi"
};
CurrentProductsController currentProductsController = new CurrentProductsController(context);
IActionResult result = await currentProductsController.PostCurrentProducts(currentProducts1) as IActionResult;
var okObjectResult = result as OkObjectResult;
Assert.IsNotNull(okObjectResult);
var model = okObjectResult.Value as CurrentProducts;
Console.WriteLine(model);
Assert.IsNotNull(model);
Assert.AreNotEqual(0, model.Id);
Assert.AreEqual(currentProducts1.Product, model.Product);
Assert.AreEqual(true, context.CurrentProducts.Any(x => x.Id == model.Id));
}
}
public void UpdateEdit()
{
var theProds = CurrentProducts;
theProds.ForEach(tp => tp.FeatureName = _originalItem.FeatureName);
CurrentProducts.Clear();
CurrentProducts = theProds;
}
public async Task <ActionResult> PostCurrentProducts(CurrentProducts currentProducts)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.CurrentProducts.Add(currentProducts);
await _context.SaveChangesAsync();
return(Ok(currentProducts));
}
private void PopulateProductDropDown()
{
// Get the data from the BLL
var controller = new ProductController();
var data = controller.ListProducts();
// Use the data in the DropDownList control
CurrentProducts.DataSource = data; // supplies all the data to the control
CurrentProducts.DataTextField = nameof(Product.ProductName); // identify which property will be used to display text
CurrentProducts.DataValueField = nameof(Product.ProductID); // identify which property will be associated with the value of the <option> element
CurrentProducts.DataBind();
// Insert an item at the top to be our "placeholder" for the <select> tag
CurrentProducts.Items.Insert(0, "[select a product]");
}
private void PopulateProductsDropDown()
{
// We can populate some controls such as DropDownLists with data
// Populate CurrentProducts with all the products in the database
InventoryPurchasingController controller = new InventoryPurchasingController();
// controller is a NorthwindController object
List <Product> products = controller.ListAllProducts();
// products is a List<Product> object
CurrentProducts.DataSource = products;
// CurrentProducts is a DropDownList
CurrentProducts.DataTextField = "ProductName"; // The property of the Product class to display
CurrentProducts.DataValueField = "ProductID";
CurrentProducts.DataBind(); // Populate the DropDownList
CurrentProducts.Items.Insert(0, "[select a product]");
}
public void GetNextPage()
{
if (CurrentIndex >= AllProducts.Count)
{
return;
}
var diff = AllProducts.Count - CurrentIndex;
if (diff > PageSize)
{
diff = PageSize;
}
CurrentProducts.Clear();
CurrentProducts = AllProducts.GetRange((int)CurrentIndex, (int)diff);
CurrentIndex += diff;
}
public List <ExcelProduct> PerformGlobalSearch(SearchParam searchParam, SearchType type, string value)
{
CurrentProducts.Clear();
switch (type)
{
case SearchType.Equals:
return(EqualsSearch(searchParam, value));
case SearchType.StartsWith:
return(BeginsSearch(searchParam, value));
case SearchType.Contains:
return(ContainsSearch(searchParam, value));
case SearchType.EndsWith:
return(EndsSearch(searchParam, value));
case SearchType.NotEqualTo:
return(NotEqualsSearch(searchParam, value));
default:
return(EndsSearch(searchParam, value));
}
}
public void GetPreviousPage()
{
if (CurrentIndex <= 1)
{
return;
}
var diff = CurrentIndex - PageSize;
if (diff < 0)
{
diff = CurrentIndex;
}
else
{
diff = PageSize;
}
CurrentProducts.Clear();
CurrentProducts = AllProducts.GetRange((int)(CurrentIndex - diff), (int)diff);
CurrentIndex -= diff;
}
public void GlobalSeach()
{
CurrentProducts.Clear();
CurrentProducts = PerformGlobalSearch(SelectedSearchParam, SelectedSearchType, SearchValue);
}
