protected void btnDatHang_Click(object sender, EventArgs e) { loadDsHang(); try { tbl_Order dh = new tbl_Order(); var session = (LoginSession)Session[CommonContanst.USER_SESSION]; if (session != null) { var userID = db.tbl_Customer.Find(session.userName).UserID; dh.UserID = userID; } var r = db.tbl_Order.ToList(); dh.Order_ID = (r.ToList().Count + 1).ToString(); dh.VAT_Transport = 20000; dh.VAT_Gift = 0; dh.SumWeight = 0; dh.SumMoney = 0; for (int i = 0; i < dsHangHoa.Count; i++) { dh.SumWeight += dsHangHoa[i].Weight; dh.SumMoney += dsHangHoa[i].Price_Export * dsHangHoa[i].Quantium; } dh.Date = DateTime.Now; dh.Address_Received = txtDiaChi.Text; dh.Mesage = ""; dh.Pay_ID = int.Parse(drThanhToan.SelectedValue); dh.Transport_ID = int.Parse(drVanChuyen.SelectedValue); dh.Phone_Received = int.Parse(txtSoDienThoai.Text); dh.Phone_Pay = int.Parse(txtSoDienThoai.Text); dh.Address_Pay = txtDiaChi.Text; dh.State = "Chưa xử lý"; dh.Name_Pay = txtHoTen.Text; dh.Name_Received = txtHoTen.Text; db.tbl_Order.Add(dh); db.SaveChanges(); for (int i = 0; i < dsHangHoa.Count; i++) { tbl_OrderDetial chitietDh = new tbl_OrderDetial(); chitietDh.Order_ID = dh.Order_ID; chitietDh.Product_ID = dsHangHoa[i].Product_ID; chitietDh.Price_Export = dsHangHoa[i].Price_Export; chitietDh.Amount = dsHangHoa[i].Amount; chitietDh.Money = chitietDh.Amount * chitietDh.Price_Export; chitietDh.State = "chưa xử lý"; db.tbl_OrderDetial.Add(chitietDh); db.SaveChanges(); } Session.Remove(CommonContanst.CART_SESSION); Response.Redirect("DatThanhCong.aspx"); } catch (Exception ex) { } }
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { Label lbma = (Label)GridView1.Rows[e.RowIndex].FindControl("lbMaSP"); tbl_Product p = db.tbl_Products.SingleOrDefault(c => c.Product_ID == int.Parse(lbma.Text)); var a = from s in db.tbl_OrderDetials where s.Order_ID == Label1.Text select new { s.Amount }; foreach (var item in a) { p.Amount = p.Amount - int.Parse(item.Amount.ToString()); } tbl_OrderDetial od = db.tbl_OrderDetials.SingleOrDefault(c => c.Product_ID == int.Parse(lbma.Text)); od.State = "Đã xử lý"; load(); db.SubmitChanges(); }
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e) { try { int index = GridView1.SelectedIndex; GridViewRow row = GridView1.SelectedRow; string id1 = row.Cells[0].Text; int id2 = int.Parse(row.Cells[1].Text); tbl_OrderDetial od = db.tbl_OrderDetial.Find(id1, id2); od.State = "Đã xử lý"; db.SaveChanges(); load(); } catch (Exception ex) { } }