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)
{
}
}
