public ActionResult Edit([Bind(Include = "StockImageID,StockImage,StockID")] StocksImage stocksImage, HttpPostedFileBase image1)
{
var img = db.StocksImages.Where(x => x.StockImage == stocksImage.StockImage).Select(x => x.StockImage).Single();
if (image1 != null)
{
stocksImage.StockImage = new byte[image1.ContentLength];
image1.InputStream.Read(stocksImage.StockImage, 0, image1.ContentLength);
db.Entry(stocksImage).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else if (img != null)
{
stocksImage.StockImage = img;
//image1.InputStream.Read(beverage.Beverage_Image, 0, image1.ContentLength);
db.Entry(stocksImage).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
ViewBag.imageError = "Please add an Image";
}
ViewBag.StockID = new SelectList(db.Stocks, "StockID", "StockID", stocksImage.StockID);
return(View(stocksImage));
}
public ActionResult DeleteConfirmed(int id)
{
StocksImage stocksImage = db.StocksImages.Find(id);
db.StocksImages.Remove(stocksImage);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create([Bind(Include = "StockImageID,StockImage,StockID")] StocksImage stocksImage, HttpPostedFileBase image1, string crop)
{
int ID;
if (image1 != null)
{
stocksImage.StockImage = new byte[image1.ContentLength];
image1.InputStream.Read(stocksImage.StockImage, 0, image1.ContentLength);
var id1 = db.CropInfoes.Where(x => x.Name == crop).Select(y => y.CropID).First();
int cid = Convert.ToInt16(id1);
var findStock = db.Stocks.Where(x => x.CropID == cid).Select(y => y.StockID).Count();
if (findStock > 0)
{
var id2 = db.Stocks.Where(x => x.CropID == cid).Select(y => y.StockID).First();
ID = Convert.ToInt16(id2);
}
else
{
ViewBag.noStock = "Stock has not yet been created ie. Harvest pending";
ViewBag.crop = new SelectList(db.CropInfoes, "Name", "Name");
return(View());
}
}
else
{
ModelState.AddModelError(string.Empty, "Please add image");
return(View(stocksImage));
}
if (ModelState.IsValid)
{
var imageExists = db.StocksImages.Where(x => x.ImageName == crop).Select(y => y.ImageName).Count();
if (imageExists > 0)
{
var stockid = db.StocksImages.Where(x => x.ImageName == crop).Select(y => y.StockImageID).First();
stocksImage.StockImageID = Convert.ToInt16(stockid);
stocksImage.StockID = ID;
stocksImage.ImageName = crop;
db.Entry(stocksImage).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
stocksImage.StockID = ID;
stocksImage.ImageName = crop;
db.StocksImages.Add(stocksImage);
db.SaveChanges();
return(RedirectToAction("Index"));
}
}
ViewBag.crop = new SelectList(db.CropInfoes, "Name", "Name");
//ViewBag.StockID = new SelectList(db.Stocks, "StockID", "StockID", stocksImage.StockID);
return(View(stocksImage));
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StocksImage stocksImage = db.StocksImages.Find(id);
if (stocksImage == null)
{
return(HttpNotFound());
}
return(View(stocksImage));
}
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
StocksImage stocksImage = db.StocksImages.Find(id);
if (stocksImage == null)
{
return(HttpNotFound());
}
ViewBag.StockID = new SelectList(db.Stocks, "StockID", "StockID", stocksImage.StockID);
return(View(stocksImage));
}
