public void Add(OHoaDonBan item) { conn.connect(); var comm = new SqlCommand("HDB_Add", conn.db); comm.CommandType = CommandType.StoredProcedure; if (comm == null) { return; } comm.Parameters.Add("@MaKhach", SqlDbType.Int).Value = item.MaKhach; comm.ExecuteNonQuery(); }
public void Update(OHoaDonBan item) { conn.connect(); var comm = new SqlCommand("HDB_Add", conn.db); comm.CommandType = CommandType.StoredProcedure; if (comm == null) { return; } comm.Parameters.Add("@MaHDB", SqlDbType.Int).Value = item.MaHDB; comm.Parameters.Add("@NgayGiao", SqlDbType.DateTime).Value = item.NgayGiao; comm.Parameters.Add("@IsActive", SqlDbType.Int).Value = item.TrangThai; comm.ExecuteNonQuery(); }
public ActionResult Update(OHoaDonBan model) { if (ModelState.IsValid) { var pro = hdbService.GetById(model.MaHDB); if (pro != null) { try { hdbService.Edit(model); return(RedirectToAction("Search", "HoaDonBan")); } catch (Exception e) { } } } ViewBag.IsEdit = true; return(View(model)); }
public OHoaDonBan GetById(int mahdb) { conn.connect(); var comm = new SqlCommand("HDB_Get", conn.db); comm.CommandType = CommandType.StoredProcedure; if (comm == null) { return(null); } comm.Parameters.Add("@mahdb", SqlDbType.Int).Value = mahdb; DataTable dt = new DataTable(); dt.Load(comm.ExecuteReader()); OHoaDonBan item = new OHoaDonBan(); item = Help.DAL.ConvertDataTable <OHoaDonBan>(dt).FirstOrDefault(); conn.Close(); return(item); }
public ActionResult DatHang() { string strChuoi = ""; decimal total = 0; ShoppingCartModels model = new ShoppingCartModels(); model.Cart = (Carts)Session["Cart"]; if (Session["Account"] == null || Session["Account"].ToString() == "") { //return RedirectToAction("Login", "Account"); return(Json(new { Success = false, Url = Url.Action("Login", "Account") })); } OAccount account = (OAccount)Session["Account"]; OAccount kh = accountService.Get(account.TenDN, account.MatKhau); if (kh == null) { return(Redirect("Error")); } OHoaDonBan ddh = new OHoaDonBan { MaKhach = kh.MaKhach, TrangThai = 0, }; hdbService.Add(ddh); int idHdb = hdbService.GetLastId(); foreach (var item in model.Cart.ListItem) { cTHDBService.Add(new OCTHDB { MaHDB = idHdb, MaSanPham = item.ProductId, SoLuong = item.Quantity, ThanhTien = item.Total, }); strChuoi += "<li> Tên sản phẩm: " + item.ProductName + "</li> "; strChuoi += "<li> Giá: " + item.Price.ToString("#,##") + " đ</li> "; strChuoi += "<li> Số lượng: " + item.Quantity + "</li> "; total += item.Total; var product = sachService.Get(new OSanPham { MaSanPham = item.ProductId }); var newproduct = sachService.Get(new OSanPham { MaSanPham = item.ProductId }); if (product != null) { newproduct.SoLuong = product.SoLuong - item.Quantity; sachService.Update(newproduct); } } strChuoi += "<li>Tổng tiền: " + total.ToString("#,##") + " đ </li>"; SendEmail(kh.Email, strChuoi); Session["Cart"] = null; return(Json(new { Success = true, Message = "Đặt hàng thành công. Bạn hãy check email nhé !" })); }