static void Main(string[] args)
{
try
{
IDbContext db = new MyDbContext();
db.RecreateDatabase();
ICategoryData categoryData = new CategoryData(db);
IProductData productData = new ProductData(db);
IShoppingBasketItemData shoppingBasketItemData = new ShoppingBasketItemData(db);
Console.WriteLine("Creating database entries");
categoryData.AddCategory(new ClassLibrary.Category {
CategoryId = 1, Name = "Fruits"
});
categoryData.AddCategory(new ClassLibrary.Category {
CategoryId = 2, Name = "Vegetables"
});
categoryData.AddCategory(new ClassLibrary.Category {
CategoryId = 3, Name = "Pulses"
});
productData.AddProduct(new ClassLibrary.Product {
ProductId = 1, Name = "Orange", Price = 0.45m, ImageFilePath = "https://upload.wikimedia.org/wikipedia/commons/c/c4/Orange-Fruit-Pieces.jpg", CategoryId = 1
});
productData.AddProduct(new ClassLibrary.Product {
ProductId = 2, Name = "Apple", Price = 0.35m, ImageFilePath = "https://cdn.ecommercedns.uk/files/1/231541/9/8022859/green20apple.jpg", CategoryId = 1
});
productData.AddProduct(new ClassLibrary.Product {
ProductId = 3, Name = "Banana", Price = 0.65m, ImageFilePath = "https://api.time.com/wp-content/uploads/2019/11/gettyimages-459761948.jpg?w=800&quality=85", CategoryId = 1
});
productData.AddProduct(new ClassLibrary.Product {
ProductId = 4, Name = "Cabbage", Price = 0.85m, ImageFilePath = "https://cdn-prod.medicalnewstoday.com/content/images/articles/284/284823/one-big-cabbage.jpg", CategoryId = 2
});
productData.AddProduct(new ClassLibrary.Product {
ProductId = 5, Name = "Pepper", Price = 0.40m, ImageFilePath = "http://www.lima-europe.eu/wp-content/uploads/2017/04/pepper.jpg", CategoryId = 2
});
productData.AddProduct(new ClassLibrary.Product {
ProductId = 6, Name = "Red Lentil", Price = 2.10m, ImageFilePath = "https://upload.wikimedia.org/wikipedia/commons/4/43/Split_Red_Lentil.jpg", CategoryId = 3
});
Console.WriteLine("Database entries created");
foreach (var product in productData.GetProducts())
{
Console.WriteLine($"ProductId={product.ProductId}\tName={product.Name}\tPrice={product.Price}\tImageFilePath={product.ImageFilePath}\tCategoryId={product.CategoryId}");
}
foreach (var category in categoryData.GetCategories())
{
Console.WriteLine($"CategoryId={category.CategoryId}\tName={category.Name}");
}
}
catch (Exception ex)
{
Console.WriteLine(ex.Message);
}
}
private void btnAddCategory_Click(object sender, EventArgs e)
{
try
{
if (txtCategory.TextLength != 0 && txtCategoryID.TextLength != 0)
{
string cateID = txtCategoryID.Text;
string cateName = txtCategory.Text;
if (CategoryDT.AddCategory(new Category(cateID, cateName)))
{
dtCategory.RejectChanges();
dtCategory.Rows.Add(cateID, cateName);
dtCategory.AcceptChanges();
MessageBox.Show("New Category added!");
}
else
{
MessageBox.Show("Error when adding Category");
}
}
else
{
MessageBox.Show("Please inset category name and category id");
}
}
catch (Exception ex)
{
if (ex.Message.Contains("duplicate"))
{
MessageBox.Show("This category ID is already existed");
}
else
{
MessageBox.Show(ex.Message);
}
}
}
