public int CreateCartOrderID(string cid)
{
int id = int.Parse(cid);
var citem = musicDB.view_cartItem.Where(vc => vc.cartid == id).ToList();
string username = Session["username"].ToString();
int oid = createOrder(username);
tb_orderDetails od = new tb_orderDetails();
foreach (view_cartItem cview in citem)
{
od.albumId = cview.albumid;
od.quantity = cview.quantity;
od.unitprice = cview.price;
od.orderId = oid;
musicDB.tb_orderDetails.Add(od);
musicDB.SaveChanges();
}//将购物车中的商品信息写入订单。
var cartderails = musicDB.tb_cartDetails.Where(cd => cd.cartId == id).ToList();
foreach (tb_cartDetails cd in cartderails)
{//生成订单后删除购物车信息
musicDB.tb_cartDetails.Remove(cd);
}
musicDB.SaveChanges();
return(oid);
}
/// <summary>
/// 丰富订单详情
/// </summary>
/// <param name="orderid"></param>
/// <param name="albumid"></param>
/// <param name="num"></param>
/// <returns></returns>
public bool createDetails(int orderid, int albumid, int num)
{
//insert order details
tb_orderDetails orderDetails = new tb_orderDetails();
orderDetails.orderId = orderid;
orderDetails.albumId = albumid;
orderDetails.unitprice = (from a in musicDB.tb_album
where a.albumId == albumid
select a.price).Single();
////how to deliver the number of album?
orderDetails.quantity = num;
musicDB.tb_orderDetails.Add(orderDetails);
//change the storage
var album = musicDB.tb_album.Where(a => a.albumId == albumid).Single();
album.leftNum -= num;
musicDB.SaveChanges();
return(true);
}