public ActionResult changeStatus(int[] chkVal)
{
string member = Session[CDitionay.USER_Account] as string;
serialNum sn = new serialNum();
foreach (var i in chkVal)
{
tOrderList t = db.tOrderList.FirstOrDefault(x => x.forderListId == i);
t.fOrderStatus = 2;
using (var transaction = db.Database.BeginTransaction())
{
db.tShippingOrder.Add(new tShippingOrder()
{
fCreatedDateTime = DateTime.Now.ToLocalTime(),
fId = t.fId,
fStatus = "New",
fShippingOrderId = sn.getNum()
});
try
{
db.SaveChanges();
transaction.Commit();
}
catch
{
transaction.Rollback();
}
}
}
db.SaveChanges();
var z = from y in db.tOrderList
where y.fUser == member
orderby y.forderListId
select new {
y.fCost,
y.fId,
y.fItem,
y.forderListId,
y.fOrderStatus,
y.fPrice,
y.fUser
};
return(Json(z, JsonRequestBehavior.AllowGet));
}
public ActionResult detail(int?Id)
{
tOrderList t = db.tOrderList.FirstOrDefault(x => x.forderListId == Id);
return(View(t));
}
