//get all categories
public List <Category> GetAllCategories()
{
List <Category> categories = new List <Category>();
using (var context = new ShoppingAppContext(ShoppingAppContext.ops.dbOptions))
{
categories = context.Categories.ToList();
}
return(categories);
}
public List <Product> GetAllProductsByCategory(int id)
{
if (id <= 0)
{
throw new ArgumentException("Category id is invalid");
}
List <Product> products = new List <Product>();
using (var context = new ShoppingAppContext(ShoppingAppContext.ops.dbOptions))
{
products = context.Products.Where(s => s.category_id == id).ToList();
}
return(products);
}
//add new category
public async Task <Category> Addcategory(string category_name)
{
Category newcategory = new Category
{
Category_name = category_name
};
using (var context = new ShoppingAppContext(ShoppingAppContext.ops.dbOptions))
{
await context.AddAsync(newcategory);
await context.SaveChangesAsync();
}
return(newcategory);
}
private void btnReg_Click(object sender, EventArgs e)
{
ShoppingAppContext db = new ShoppingAppContext();
string fullname = txtFullName.Text;
string email = txtEmail.Text;
string password = txtPassword.Text;
string rePass = txtRePass.Text;
string[] myArr = { fullname, email, password, rePass };
if (Utilities.IsEmpty(myArr))
{
lblError.Visible = false;
}
else
{
lblError.Visible = true;
lblError.Text = "Please fill all the boxes!";
}
}
public ShoppingCartController(ShoppingAppContext shoppingAppContext)
{
_shoppingAppContext = shoppingAppContext;
}
public CustomerController(UserManager <IdentityUser> userManager, ShoppingAppContext shoppingAppContext)
{
_shoppingAppContext = shoppingAppContext;
_userManager = userManager;
}
public CommandProcessor(IUnitOfWork unitOfWork, ShoppingAppContext shoppingAppContext)
{
_unitOfWork = unitOfWork;
_shoppingAppContext = shoppingAppContext;
}
public ProductController(ILogger <ProductController> logger, ShoppingAppContext shoppingAppContext)
{
_logger = logger;
_shoppingAppContext = shoppingAppContext;
}
public OrdersController(ShoppingAppContext context)
{
_context = context;
}
public OrderRepository(ShoppingAppContext shoppingAppContext)
{
_shoppingAppContext = shoppingAppContext ?? throw new ArgumentNullException(nameof(shoppingAppContext));;
}
public ProductRepository(ShoppingAppContext shoppingAppContext)
{
_shoppingAppContext = shoppingAppContext;
}
public CustomersController(ShoppingAppContext context)
{
_context = context;
}
public UnitOfWork(ShoppingAppContext shoppingAppContext)
{
_shoppingAppContext = shoppingAppContext;
}
public ProductsController(ShoppingAppContext context)
{
_context = context;
}
public ShopController(UserManager <IdentityUser> userManager, ShoppingAppContext shoppingAppContext, ILogger <ShopController> logger)
{
_shoppingAppContext = shoppingAppContext;
_userManager = userManager;
_logger = logger;
}
