public ActionResult Add(AddProductModel product)
        {
            Product nProduct = new Product();
            nProduct.ProductID = _products.GetNextID();
            nProduct.Name = product.Name;
            nProduct.CategoryID = product.CategoryID;
            nProduct.Description = product.Description;
            nProduct.ImageSource = product.ImageSource;
            nProduct.ListedPrice = product.ListedPrice;
            nProduct.ImportDate = DateTime.Now;
            nProduct.Quantity = product.Quantity;
            string[] specs = product.Specifications.Split('\n');
            for (int i = 0; i < specs.Length;i++ )
            {
                string[] val = specs[i].Split(':');
                Specification s = new Specification();
                s.SpecificationID = _specs.GetNextID();
                s.Name = val[0];
                s.Value = val[1];
                s.ProductID = nProduct.ProductID;
                _dObject.Insert(s);

            }
            _dObject.Insert(nProduct);
            return Json("success");
        }
 public ActionResult Edit(EditProductModel product)
 {
     Product nProduct = _products.GetProduct(product.ProductID);
     nProduct.Name = product.Name;
     nProduct.CategoryID = product.CategoryID;
     nProduct.Description = product.Description;
     nProduct.ImageSource = product.ImageSource==""?nProduct.ImageSource:product.ImageSource;
     nProduct.ListedPrice = product.ListedPrice;
     nProduct.Quantity = product.Quantity;
     string[] specs = product.Specifications.Trim('\n').Split('\n');
     for (int i = 0; i < specs.Length;i++ )
     {
         _specs.DeleteSpecsOfProduct(product.ProductID);
         string[] val = specs[i].Split(':');
         Specification s = new Specification();
         s.SpecificationID = _specs.GetNextID();
         s.Name = val[0];
         s.Value = val[1];
         s.ProductID = nProduct.ProductID;
         _dObject.Insert(s);
     }
     _dObject.Update(nProduct);
     return Json("success");
 }