public ActionResult OrderListAddSave(int publishid, int bookid, string time, int num)
{
try
{
电商.Areas.Admin.Models.Entities4 db = new Models.Entities4();
电商.Areas.Admin.Models.order order = new Models.order();
order.publish_id = publishid;
order.book_id = bookid;
order.time = time;
order.num = num;
db.order.Add(order);
db.SaveChanges();
return(Content("添加成功"));
}
catch (System.Data.Entity.Validation.DbEntityValidationException ex)
{
var msg = string.Empty;
var errors = (from u in ex.EntityValidationErrors select u.ValidationErrors).ToList();
foreach (var item in errors)
{
msg += item.FirstOrDefault().ErrorMessage;
}
return(Content(msg));
}
}
public ActionResult submit()
{
Model1 m1 = new Model1();
var username1 = User.Identity.Name;
var idselect = from c in m1.Customer
where c.customer_Name == username1
select c;
var abc = idselect.FirstOrDefault();
int d2 = abc.customerID;
Models.order o = new Models.order();
// o.orderID = ;
o.customerID = d2;
db.Order.Add(o);
db.SaveChanges();
var o2 = from o1 in db.Order
where o1.orderID == o.orderID
select o1;
var odr = o2.ToList().FirstOrDefault();
var x = (IEnumerable <p1>)TempData["selectedMenu"];
List <Models.detail> d1 = new List <Models.detail>();
int sum = 0;
foreach (p1 i in x)
{
foreach (var j in i.value)
{
if (Request[j.menu_Name].ToString() != "0")
{
Models.detail d = new Models.detail();
d.name = j.menu_Name;
d.price = Int32.Parse(j.price);
d.quantity = Int32.Parse(Request[j.menu_Name]);
d.order = odr;
// d.order.orderID = o.orderID;
db.Detail.Add(d);
db.SaveChanges();
d1.Add(d);
sum += (d.quantity * d.price);
ViewBag.total = sum;
Session["amount"] = sum;
// o.details.Add(d);
}
}
}
//ICollection<db.Detail>
// o.details.Add(d);
odr.details = d1;
//db.Order.U(o);
db.SaveChanges();
Session["oid"] = odr.orderID;
var order = from oo in db.Order
where oo.orderID == o.orderID
select new p2 {
detail = oo.details
};
var a1 = order.ToList();
TempData["re"] = "true";
return(View(a1));
}
