Kaffeplaneten.DAL.ProductDAL.getAllProducts C# (CSharp) Method

getAllProducts() public method

public getAllProducts ( ) : List
return List
        public List<ProductModel> getAllProducts()
        {
            using (var db = new CustomerContext())
            {
                List<ProductModel> ProductList = new List<ProductModel>();
                try
                {

                    ProductList = new List<ProductModel>();

                    var produkter = (from p in db.Products select p).ToList();
                    if(produkter!=null)
                    foreach (var p in produkter)
                    {
                        var newProductModel = new ProductModel();
                        newProductModel.productID = p.productID;
                        newProductModel.category = p.category;
                        newProductModel.productName = p.productName;
                        newProductModel.price = p.price;
                        newProductModel.imageURL = p.imageURL;
                        newProductModel.description = p.description;
                        newProductModel.stock = p.stock;
                        ProductList.Add(newProductModel);
                    }
                    return ProductList;
                }
                catch (Exception ex)
                {
                    _logging.logToDatabase(ex);
                }
                return null;
            }
        }