//function for bottom 3 windows coas info from index2 page public JsonResult update_counter(int count) { var updateQuery = new asset_tag_counter() { Company = "interconnection", count = count }; db.asset_tag_counter.Attach(updateQuery); db.Entry(updateQuery).Property(x => x.count).IsModified = true; db.SaveChanges(); return(Json(JsonRequestBehavior.AllowGet)); }
public ActionResult Edit([Bind(Include = "station_name,station_dropdown_value,description")] station_setting station_setting) { if (ModelState.IsValid) { db.Entry(station_setting).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(station_setting)); }
public ActionResult Edit([Bind(Include = "Id,Email,EmailConfirmed,PasswordHash,SecurityStamp,PhoneNumber,PhoneNumberConfirmed,TwoFactorEnabled,LockoutEndDateUtc,LockoutEnabled,AccessFailedCount,UserName,department")] aspnetusers aspNetUsers) { if (ModelState.IsValid) { db.Entry(aspNetUsers).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(aspNetUsers)); }
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 Edit([Bind(Include = "ictag,time,serial,brand,model,cpu,hdd,ram,optical_drive,location,pallet,pre_coa,refurbisher")] rediscovery rediscovery) { if (ModelState.IsValid) { db.Entry(rediscovery).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(rediscovery)); }
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 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 Edit([Bind(Include = "row_id,serial,rma_number,production_finding,channel,date_requested,ictag,description")] rma rma) { if (ModelState.IsValid) { db.Entry(rma).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(rma)); }
public ActionResult Edit([Bind(Include = "channel_name,background,type,full_name")] setting setting) { if (ModelState.IsValid) { db.Entry(setting).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(setting)); }
public ActionResult Edit([Bind(Include = "user_name,work_status,pw,role")] users users) { if (ModelState.IsValid) { db.Entry(users).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(users)); }
public ActionResult Edit([Bind(Include = "time,manu,monitor_ID,serial,size,resou,model,ictag")] monitor_log monitor_log) { if (ModelState.IsValid) { db.Entry(monitor_log).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(monitor_log)); }
public ActionResult Edit([Bind(Include = "last_manual_count,last_auto_count,qty,sku,ictag")] ts_stock ts_stock) { if (ModelState.IsValid) { db.Entry(ts_stock).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(ts_stock)); }
public ActionResult admin(int?counter_value) { var channel_list = db.asset_tag_counter .Select(p => p.Company) .ToList(); SelectList list = new SelectList(channel_list); ViewBag.myList = list; var updateQuery = new asset_tag_counter() { Company = "interconnection", count = counter_value }; db.asset_tag_counter.Attach(updateQuery); db.Entry(updateQuery).Property(x => x.count).IsModified = true; db.SaveChanges(); ModelState.Clear(); return(View("admin")); }
//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; } }