public void DeleteProduct(int productId)
{
Product p = db.Products.Where(x => x.ProductID == productId).FirstOrDefault();
db.Products.Remove(p);
db.SaveChanges();
}
public ActionResult Create(Product product)
{
if (product != null)
{
context.Products.Add(product);
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(Category category)
{
if (category.CategoryName == null)
{
return(Content("You can't add an empty element in database"));
}
db.Categories.Add(category);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Brand brand)
{
if (brand == null)
{
return(Content("You can not save a empty brand in database"));
}
db.Brands.Add(brand);
db.SaveChanges();
return(RedirectToAction("Index", "Brands"));
}
public ActionResult Create(Category category)
{
var Editedcategory = context.Categories.FirstOrDefault(c => c.CategoryID == category.CategoryID);
if (Editedcategory != null)
{
Editedcategory.CategoryID = category.CategoryID;
Editedcategory.CategoryName = category.CategoryName;
context.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Create(Product p)
{
if (ModelState.IsValid)
{
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
if (Request.Files.Count >= 1)
{
var file = Request.Files[0];
var imgBytes = new Byte[file.ContentLength];
file.InputStream.Read(imgBytes, 0, file.ContentLength);
var base64String = Convert.ToBase64String(imgBytes, 0, imgBytes.Length);
p.Photo = base64String;
}
db.Products.Add(p);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
ViewBag.Categories = db.Categories.ToList();
ViewBag.Brands = db.Brands.ToList();
return(View());
}
}
public ActionResult Create(Product p)
{
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
db.Products.Add(p);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Brand brand)
{
var Editedbrand = _context.Brands.FirstOrDefault(b => b.BrandID == brand.BrandID);
//left side datebase values and right side form values.
//assigning form values to database values.
if (Editedbrand != null)
{
Editedbrand.BrandID = brand.BrandID;
Editedbrand.BrandName = brand.BrandName;
_context.SaveChanges();
}
return(RedirectToAction("Index"));
}
public ActionResult Delete(long id, Product p)
{
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
Product existingProduct = db.Products.Where(temp => temp.ProductID == id).FirstOrDefault();
db.Products.Remove(existingProduct);
db.SaveChanges();
return(RedirectToAction("Index", "Products"));
}
public ActionResult Delete(Product product)
{
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
Product foundProduct = db.Products.Where(p => p.ProductID == product.ProductID).FirstOrDefault();
db.Products.Remove(foundProduct);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit(Product p)
{
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
Product existingProduct = db.Products.Where(temp => temp.ProductID == p.ProductID).FirstOrDefault();
existingProduct.ProductName = p.ProductName;
existingProduct.Price = p.Price;
existingProduct.DateOfPurchase = p.DateOfPurchase;
existingProduct.CategoryID = p.CategoryID;
existingProduct.BrandID = p.BrandID;
existingProduct.AvailabilityStatus = p.AvailabilityStatus;
existingProduct.Active = p.Active;
db.SaveChanges();
return(RedirectToAction("Index", "Products"));
}
public ActionResult Create(Product product)
{
try
{
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index", "Products"));
}
catch (Exception e)
{
ViewBag.message = e;
return(View(ViewBag.message));
}
}
public ActionResult Edit(Product product)
{
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
Product foundProduct = db.Products.Where(p => p.ProductID == product.ProductID).FirstOrDefault();
foundProduct.ProductName = product.ProductName;
foundProduct.Price = product.Price;
foundProduct.DateOfPurchase = product.DateOfPurchase;
foundProduct.AvailabilityStatus = product.AvailabilityStatus;
foundProduct.CategoryID = product.CategoryID;
foundProduct.BrandID = product.BrandID;
foundProduct.Active = product.Active;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(Product product)
{
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
if (Request.Files.Count >= 1)
{
var file = Request.Files[0];
var imgBytes = new Byte[file.ContentLength];
file.InputStream.Read(imgBytes, 0, file.ContentLength);
var base64String = Convert.ToBase64String(imgBytes, 0, imgBytes.Length);
product.Photo = base64String;
}
db.Products.Add(product);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult UpdateProduct(Product product)
{
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
Product exstingProduct = db.Products.Where(s => s.ProductID == product.ProductID).FirstOrDefault();
exstingProduct.ProductName = product.ProductName;
exstingProduct.Price = product.Price;
exstingProduct.DateOfPurchase = product.DateOfPurchase;
exstingProduct.AvailabilityStatus = product.AvailabilityStatus;
exstingProduct.Active = product.Active;
exstingProduct.BrandID = product.BrandID;
exstingProduct.CategoryID = product.CategoryID;
db.SaveChanges();
return(Redirect("/Products/Index"));
}
public ActionResult Create(Product prod)
{
Product p = new Product()
{
ProductID = prod.ProductID,
ProductName = prod.ProductName,
Price = prod.Price,
DateOfPurchase = prod.DateOfPurchase,
Active = prod.Active,
BrandID = prod.BrandID,
CategoryID = prod.CategoryID
};
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
db.Products.Add(p);
db.SaveChanges();
// List<Product> products = db.Products.ToList();
return(Redirect("/Products/Index"));
}
public ActionResult Edit(Product p)
{
EFDBFirstDatabaseEntities db = new EFDBFirstDatabaseEntities();
if (ModelState.IsValid)
{
Product existingProduct = db.Products.Where(temp => temp.ProductID == p.ProductID).FirstOrDefault();
existingProduct.ProductName = p.ProductName;
existingProduct.Price = p.Price;
existingProduct.DateOfPurchase = p.DateOfPurchase;
existingProduct.CategoryID = p.CategoryID;
existingProduct.BrandID = p.BrandID;
existingProduct.AvailabilityStatus = p.AvailabilityStatus;
existingProduct.Active = p.Active;
db.SaveChanges();
return(RedirectToAction("Index", "Products"));
}
else
{
ViewBag.Categories = db.Categories.ToList();
ViewBag.Brands = db.Brands.ToList();
return(View(db.Products.Where(temp => temp.ProductID == p.ProductID).FirstOrDefault()));
}
}
