public ActionResult DeleteConfirmed(string id) { pallet_master pallet_master = db.pallet_master.Find(id); db.pallet_master.Remove(pallet_master); db.pallet.RemoveRange(db.pallet.Where(c => c.pallet_name == id)); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult bulk(HttpPostedFileBase FileUpload, string pallet_name) { string path = ""; DataTable dt = new DataTable(); //check we have a file if (FileUpload.ContentLength > 0) { //Workout our file path string fileName = Path.GetFileName(FileUpload.FileName); path = Path.Combine(Server.MapPath("~/App_Data/uploads"), fileName); try { FileUpload.SaveAs(path); List <string> temp_line = new List <string>(); using (StringReader reader = new StringReader(System.IO.File.ReadAllText(path))) { string line = null; while ((line = reader.ReadLine()) != null) { if (!temp_line.Contains(line)) { temp_line.Add(line); } } } using (StreamWriter writer = new StreamWriter(System.IO.File.Open(path, FileMode.Create))) foreach (string r in temp_line) { var updateQuery = new pallet(); updateQuery.ictags = int.Parse(r); updateQuery.pallet_name = pallet_name; db.pallet.Add(updateQuery); } var palletmaster = new pallet_master(); palletmaster.pallet_id = pallet_name; db.pallet_master.Add(palletmaster); db.SaveChanges(); if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } } catch (Exception ex) { if (System.IO.File.Exists(path)) { System.IO.File.Delete(path); } //Catch errors TempData["message"] = ex.ToString(); } } return(RedirectToAction("bulk")); }
public ActionResult Edit([Bind(Include = "pallet_id")] pallet_master pallet_master) { if (ModelState.IsValid) { db.Entry(pallet_master).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(pallet_master)); }
public ActionResult Create([Bind(Include = "pallet_id")] pallet_master pallet_master) { if (ModelState.IsValid) { db.pallet_master.Add(pallet_master); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(pallet_master)); }
// GET: pallet_master/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } pallet_master pallet_master = db.pallet_master.Find(id); if (pallet_master == null) { return(HttpNotFound()); } return(View(pallet_master)); }
public JsonResult create_pallet(string pallet_name) { string message = ""; var entry = new pallet_master(); entry.pallet_id = pallet_name; db.pallet_master.Add(entry); try { db.SaveChanges(); message = "pallet " + pallet_name + " created."; } catch (Exception e) { message = e.InnerException.InnerException.Message; } return(Json(message, JsonRequestBehavior.AllowGet)); }