public ActionResult DeleteConfirmed(string id) { ship_log ship_log = db.ship_log.Find(id); db.ship_log.Remove(ship_log); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Edit([Bind(Include = "ictag,shipdate,status,order_id,order_num,row_id,store_id,sku")] ship_log ship_log) { if (ModelState.IsValid) { db.Entry(ship_log).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(ship_log)); }
public ActionResult Create([Bind(Include = "ictag,shipdate,status,order_id,order_num,row_id,store_id,sku")] ship_log ship_log) { if (ModelState.IsValid) { db.ship_log.Add(ship_log); db.SaveChanges(); return(RedirectToAction("Index")); } return(View(ship_log)); }
// GET: ship_log/Delete/5 public ActionResult Delete(string id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } ship_log ship_log = db.ship_log.Find(id); if (ship_log == null) { return(HttpNotFound()); } return(View(ship_log)); }
//process the item in custom fields public void count_item(shipstation_log entry) { try { var write_table = new ship_log(); if (string.IsNullOrEmpty(entry.custom_field_2)) { } else { try { string[] lines = entry.custom_field_2.Split(new string[] { "\r\n", "\n" }, StringSplitOptions.None); lines = lines.Where(x => !string.IsNullOrEmpty(x)).ToArray(); foreach (var item in lines) { using (db_a094d4_icdbEntities1 db = new db_a094d4_icdbEntities1()) { var exisit = (from t in db.ship_log where t.ictag == item select t).SingleOrDefault(); if (exisit == null) { write_table.ictag = item; write_table.order_id = entry.order_id; write_table.order_num = entry.order_num; write_table.shipdate = entry.shipment_date; write_table.sku = entry.sku; write_table.status = entry.status; write_table.store_id = entry.store_id; db.ship_log.Add(write_table); db.SaveChanges(); } var update = db.ts_stock.Where(s => s.ictag == item).FirstOrDefault(); if (update != null) { update.status = "Shipped"; update.update_time = DateTime.Now; using (var dbCtx = new db_a094d4_icdbEntities1()) { //Mark entity as modified dbCtx.Entry(update).State = System.Data.Entity.EntityState.Modified; //call SaveChanges dbCtx.SaveChanges(); } } } } } catch { entry.custom_field_2 = ""; } } } catch (System.Data.Entity.Validation.DbEntityValidationException dbEx) { Exception raise = dbEx; foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { string message = string.Format("{0}:{1}", validationErrors.Entry.Entity.ToString(), validationError.ErrorMessage); // raise a new exception nesting // the current instance as InnerException raise = new InvalidOperationException(message, raise); } } throw raise; } }