public ActionResult DeleteConfirmed(int id)
{
EntranceComposition entranceComposition = db.EntranceComposition.Find(id);
db.EntranceComposition.Remove(entranceComposition);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Id,Entrance,Ingredient,Count,Cost")] EntranceComposition entranceComposition)
{
if (ModelState.IsValid)
{
db.Entry(entranceComposition).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Entrance = new SelectList(db.Entrance, "Id", "Id", entranceComposition.Entrance);
ViewBag.Ingredient = new SelectList(db.Ingredient, "Id", "Name", entranceComposition.Ingredient);
return(View(entranceComposition));
}
// GET: EntranceCompositions/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EntranceComposition entranceComposition = db.EntranceComposition.Find(id);
if (entranceComposition == null)
{
return(HttpNotFound());
}
return(View(entranceComposition));
}
public ActionResult Import(HttpPostedFileBase excelfile)
{
Thread.CurrentThread.CurrentCulture = new CultureInfo("en-US");
if (excelfile == null || excelfile.ContentLength == 0)
{
ViewBag.Error = "Файл не выбран! <br>";
return(View("Index", db.Entrance.ToList()));
}
else
{
if (excelfile.FileName.EndsWith("xls") || excelfile.FileName.EndsWith("xlsx"))
{
string path = Server.MapPath("~/Import/" + excelfile.FileName);
excelfile.SaveAs(path);
//Читаем из файла
// Excel.Application ap = new Excel.Application();
Excel.Application application = new Excel.Application();
Excel.Workbook workbook = application.Workbooks.Open(path);
Excel.Worksheet worksheet = workbook.ActiveSheet;
Excel.Range range = worksheet.UsedRange;
List <EntranceComposition> entranceCompositions = new List <EntranceComposition>();
for (int row = 2; row <= range.Rows.Count; row++)
{
EntranceComposition entranceComposition = new EntranceComposition();
string name = ((Excel.Range)range.Cells[row, 2]).Text;
entranceComposition.Entrance = Convert.ToInt32(((Excel.Range)range.Cells[row, 1]).Text);
entranceComposition.Ingredient = db.Ingredient.FirstOrDefault(m => m.Name == name).Id;
entranceComposition.Count = Convert.ToDouble(((Excel.Range)range.Cells[row, 3]).Text);
entranceComposition.Cost = Convert.ToDecimal(((Excel.Range)range.Cells[row, 4]).Text);
db.EntranceComposition.Add(entranceComposition);
db.SaveChanges();
}
workbook.Close();
ViewBag.Error = "Данные загружены <br>";
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
return(View("Index", db.Entrance.ToList()));
}
else
{
ViewBag.Error = "Это не Excel! <br>";
return(View("Index", db.Entrance.ToList()));
}
}
}
// GET: EntranceCompositions/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
EntranceComposition entranceComposition = db.EntranceComposition.Find(id);
if (entranceComposition == null)
{
return(HttpNotFound());
}
ViewBag.Entrance = new SelectList(db.Entrance, "Id", "Id", entranceComposition.Entrance);
ViewBag.Ingredient = new SelectList(db.Ingredient, "Id", "Name", entranceComposition.Ingredient);
return(View(entranceComposition));
}
