public bool UpdateArmchair(Armchair armchair)
{
using (HorecaMebelEntities db = new HorecaMebelEntities())
{
var armchairFromDB = db.Armchairs.FirstOrDefault(x => x.id == armchair.id);
armchairFromDB.Name = armchair.Name;
armchairFromDB.ImagePath = armchair.ImagePath;
armchairFromDB.Price = armchair.Price;
armchairFromDB.NewPrice = armchair.NewPrice;
armchairFromDB.Descrption = armchair.Descrption;
armchairFromDB.WoodenFrame = armchair.WoodenFrame;
armchairFromDB.Seat = armchair.Seat;
armchairFromDB.Back = armchair.Back;
armchairFromDB.Width = armchair.Width;
armchairFromDB.Height = armchair.Height;
armchairFromDB.Depth = armchair.Depth;
armchairFromDB.Legs = armchair.Legs;
armchairFromDB.Skin = armchair.Skin;
armchairFromDB.ProductionTime = armchair.ProductionTime;
armchairFromDB.SkinColour = armchair.SkinColour;
db.SaveChanges();
return(true);
}
}
public ActionResult EditArmchair(int ArmchairId)
{
Armchair armchair = repository.Armchairs.
FirstOrDefault(l => l.ArmchairId == ArmchairId);
return(View(armchair));
}
// Удаляем запись из таблицы Armchairs
public Armchair DeleteArmchair(int ArmchairId)
{
Armchair dbEntry = context.Armchairs.Find(ArmchairId);
if (dbEntry != null)
{
context.Armchairs.Remove(dbEntry);
context.SaveChanges();
}
return(dbEntry);
}
public ActionResult DeleteArmchair(int ArmchairId)
{
Armchair deletedArmchair = repository.DeleteArmchair(ArmchairId);
if (deletedArmchair != null)
{
TempData["message"] = String.Format("{0} was deleted",
deletedArmchair.TypeOfArmchair);
}
return(RedirectToAction("ArmchairIndex"));
}
public Armchair GetArmchair()
{
Armchair armchair = new Armchair {
Name = "Офисное кресло", Size = 40
};
if ((armchair.Name == null) && (armchair.Size == 0))
{
Log.Info("Нет данных");
}
return(armchair);
}
// Получаем фото из таблицы Armchair
public FileContentResult ArmchairGetImage(int ArmchairId)
{
Armchair land = repository.Armchairs.FirstOrDefault(l => l.ArmchairId == ArmchairId);
if (land != null)
{
return(File(land.ImageData, land.ImageMimeType));
}
else
{
return(null);
}
}
public JsonResult AddArmchair(Armchair armchair)
{
try
{
if (armchair == null)
{
throw new Exception();
}
this.armchairDb.SaveArmchair(armchair);
return(Json(new { Status = true }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Status = false, Message = ex.Message }, JsonRequestBehavior.AllowGet));
}
}
public bool SaveArmchair(Armchair chair)
{
try
{
using (HorecaMebelEntities db = new HorecaMebelEntities())
{
db.Armchairs.Add(chair);
db.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
return(false);
}
}
// Сохраняем изменения в таблице Armchairs
public void SaveArmchair(Armchair armchair)
{
if (armchair.ArmchairId == 0)
{
context.Armchairs.Add(armchair);
}
else
{
Armchair dbEntry = context.Armchairs.Find(armchair.ArmchairId);
if (dbEntry != null)
{
dbEntry.TypeOfArmchair = armchair.TypeOfArmchair;
dbEntry.Tree = armchair.Tree;
dbEntry.Price = armchair.Price;
dbEntry.ImageData = armchair.ImageData;
dbEntry.ImageMimeType = armchair.ImageMimeType;
}
}
context.SaveChanges();
}
public ActionResult EditArmchair(Armchair armchair, HttpPostedFileBase image)
{
if (ModelState.IsValid)
{
if (image != null)
{
armchair.ImageMimeType = image.ContentType;
armchair.ImageData = new byte[image.ContentLength];
image.InputStream.Read(armchair.ImageData, 0, image.ContentLength);
}
repository.SaveArmchair(armchair);
TempData["message"] = string.Format("{0} has been saved",
armchair.TypeOfArmchair);
return(RedirectToAction("ArmchairIndex"));
}
else
{
return(View(armchair));
}
}
