public JsonResult submit_data(int[] input, string pallet_name) { List <string> message = new List <string>(); for (int i = 0; i < input.Length; i++) { try { using (var tran = new TransactionScope()) { var entry = new pallet(); entry.ictags = input[i]; entry.pallet_name = pallet_name; db.pallet.Add(entry); tran.Complete(); message.Add(input[i] + "Successfully Added to Pallet: " + pallet_name); } db.SaveChanges(); } catch (Exception e) { message.Add(input[i] + ":" + e.InnerException.InnerException.Message); continue; } } return(Json(new { message = message }, JsonRequestBehavior.AllowGet)); }
public ActionResult DeleteConfirmed(int id) { pallet pallet = db.pallet.Find(id); db.pallet.Remove(pallet); 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 = "ictags,pallet_name,type,note")] pallet pallet) { if (ModelState.IsValid) { db.Entry(pallet).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(pallet)); }
public ActionResult Create([Bind(Include = "ictags,pallet_name,type,note")] pallet pallet) { if (ModelState.IsValid) { db.pallet.Add(pallet); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(pallet)); }
private static PalletProperties LoadPalletById(Document doc, List <pallet> listPallet, string sid) { pallet palletItem = listPallet.Find(delegate(pallet p) { return(p.id == sid); }); if (null == palletItem) { return(null); } else { // dimensions double[] dimensions = palletItem.dimensions.ToArray(); // type string typeName = string.Empty; switch (palletItem.type) { case palletType.BLOCK: typeName = "BLOCK"; break; case palletType.EUR: typeName = "EUR"; break; case palletType.EUR2: typeName = "EUR2"; break; case palletType.EUR3: typeName = "EUR3"; break; case palletType.EUR6: typeName = "EUR6"; break; case palletType.GMA: typeName = "GMA"; break; case palletType.STANDARD_UK: typeName = "STANDARD_UK"; break; default: throw new Exception("Pallet with id = {0} has an unknown pallet type"); } // instantiate pallet properties PalletProperties palletProperties = new PalletProperties(doc, typeName, dimensions[0], dimensions[1], dimensions[2]); // name palletProperties.Name = palletItem.name; // description palletProperties.Description = palletItem.description; // color palletProperties.Color = System.Drawing.Color.FromArgb((int)palletItem.color[0], (int)palletItem.color[1], (int)palletItem.color[2], (int)palletItem.color[3]); // weight palletProperties.Weight = palletItem.weight; // insert in list if (null != doc) { doc.AddType(palletProperties); } return(palletProperties); } }
// GET: pallets/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } pallet pallet = db.pallet.Find(id); if (pallet == null) { return(HttpNotFound()); } return(View(pallet)); }
public JsonResult insert_pallet(string pallet, string[] assets, string note) { // assets = assets.Where(x => !string.IsNullOrEmpty(x)).ToArray(); // assets = assets.Distinct().ToArray(); string message = ""; if (String.IsNullOrEmpty(note)) { note = ""; } for (int i = 0; i < assets.Length; i++) { try { using (var tran = new TransactionScope()) { var entry = new pallet(); entry.ictags = int.Parse(assets[i]); entry.pallet_name = pallet; entry.note = note; db.pallet.Add(entry); tran.Complete(); } } catch (Exception e) { message += assets[i] + ":" + e.InnerException.InnerException.Message; continue; } } db.SaveChanges(); message += "Complete"; return(Json(message, JsonRequestBehavior.AllowGet)); }
private void takedownpallet(pallet pal) { pal.Isplacede = false; managercontext.Update(pal); managercontext.SaveChanges(); }