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