//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;
}
}
