public static bool ThemHHVaoHD(CTHoaDon hhtt) { string sql = string.Format("insert into CTHoaDon(SoHD,MaHang,TenHang,DVT,SoLuong,DonGia,ThanhTien) values ({0}, '{1}', '{2}', '{3}', {4}, {5}, {6})", hhtt.SoHD, hhtt.MaHang, hhtt.TenHang, hhtt.DVT, hhtt.SoLuong, hhtt.DonGia, hhtt.ThanhTien); bool kq = DBConnection.ExecuteNonQuery(sql); return(kq); }
private bool saveCtHoaDon(int idhoadon) { ///delete ct hoa don cu bool kq = cthdBUS.deleteCtHoaDon(idhoadon); if (kq == true) { var temp = listHHSelect.GroupBy(x => new { x.ID }) .Select(g => new { ID = g.Key.ID, SoLuong = g.Sum(x => x.SoLuong.toLong()), ThanhTien = g.Sum(x => x.ThanhTien.toLong()) }).ToList(); for (int i = 0; i < temp.Count; i++) { CTHoaDon ct = new CTHoaDon() { HoaDonBanId = idhoadon, HangHoaId = temp[i].ID.toInt(), ThanhTien = temp[i].ThanhTien.toDouble(), SoLuongBan = temp[i].SoLuong.toInt(), }; cthdBUS.insertCTHD(ct); if (cthdBUS.ErrorCTHDBUS != null) { MessageBox.Show("Lỗi khi thêm chi tiết hóa đơn", "Error"); return(false); } } return(true); } return(false); }
//public bool XoaCTHD(CTHoaDon ct) //{ // string[] param = { "@MaHD"}; // object [] values={ct.MaHD}; // string query = "Delete from tblCTHoaDon where MaHD=@MaHD"; // return db.ExecuteNonQueryPara(query, param, values); //} public bool XoaMon(CTHoaDon ct) { string[] param = { "@MaHD","@MaMon" }; object[] values = { ct.MaHD,ct.MaMon }; string query = "Delete from tblCTHoaDon where MaHD=@MaHD and MaMon=@MaMon"; return db.ExecuteNonQueryPara(query, param, values); }
/// <summary> /// Hàm xử lý sự kiện khi click vào 1 ô trên dtgvHD. /// Thực hiện load chi tiết hóa đơn đó. /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void dtgvHoaDon_CellClick(object sender, DataGridViewCellEventArgs e) { lstCTHD = new List <CTHoaDon>(); int RowIndex = e.RowIndex; // khi click vao 1 o no lay ds o do int SoHD = int.Parse(dtgvHoaDon.Rows[RowIndex].Cells[0].Value.ToString()); // lay gia tri cua o do string query = "EXEC SP_LOAD_CTHD @SoHD"; object[] thamso = new object[] { SoHD.ToString() }; //là giá trị tương đương vs biến @ trên DataTable data = DataProvider.ExecuteQuery(query, thamso); foreach (DataRow item in data.Rows) { CTHoaDon tmp = new CTHoaDon(); tmp.SoHD = Int32.Parse(item[1].ToString()); tmp.MaSP = Int32.Parse(item[2].ToString()); tmp.GiaBan = double.Parse(item[3].ToString()); tmp.SoLuong = Int32.Parse(item[4].ToString()); tmp.ThanhTien = double.Parse(item[5].ToString()); lstCTHD.Add(tmp); } dtgvCTHD.DataSource = lstCTHD; }
public ActionResult DatHang(FormCollection collection) { //Them Don hang HoaDon ddh = new HoaDon(); Account kh = (Account)Session["Taikhoan"]; List <Giohang> gh = Laygiohang(); ddh.makh = kh.makh; ddh.ngaydat = DateTime.Now; var ngaysuat = String.Format("{0:MM/dd/yyyy}", collection["Ngaygiao"]); ddh.ngaysuat = DateTime.Parse(ngaysuat); ddh.tinhtranggiaohang = false; ddh.dathanhtoan = false; //data.HoaDons.InsertOnSubmit(ddh); //data.SubmitChanges(); //Them chi tiet don hang foreach (var item in gh) { CTHoaDon ctdh = new CTHoaDon(); ctdh.ma = ddh.ma; ctdh.maHoaDon = item.iMahang; ctdh.soluong = item.iSoluong; //ctdh.gia = (decimal)item.dDongia; //data.CTHoaDons.InsertOnSubmit(ctdh); } data.SaveChanges(); Session["Giohang"] = null; return(RedirectToAction("Xacnhandonhang", "Giohang")); }
public bool SuaCTHD(CTHoaDon ct) { string[] param = { "@MaHD","@MaMon","@SoLuong"}; object[] values = {ct.MaHD, ct.MaMon,ct.SoLuong }; string query = "Update tblCTHoaDon set SoLuong=@SoLuong where MaMon=@MaMon and MaHD=@MaHD"; return db.ExecuteNonQueryPara(query, param, values); }
public bool ThemCTHD(CTHoaDon ct) { string[] param = { "@MaHD","@MaMon", "@TenMon", "@SoLuong", "@DonGia", "@ThanhTien" }; object[] values={ct.MaHD,ct.MaMon,ct.TenMon,ct.SoLuong,ct.DonGia,ct.ThanhTien}; string query = "Insert into tblCTHoaDon(MaHD,MaMon,TenMon,SoLuong,DonGia,ThanhTien) values(@MaHD,@MaMon,@TenMon,@SoLuong,@DonGia,@ThanhTien)"; return db.ExecuteNonQueryPara(query, param, values); }
public int TaoCTHD(int idHD) { try { var db = new TraSuaDbContext(); var cart = Session["CartItem"] as List <CartModel>; foreach (var item in cart) { var cthd = new CTHoaDon { MaHD = idHD, MaSP = item.SP.MaSP, SoLuong = item.Quantity, MaSize = item.size.MaSize }; db.CTHoaDons.Add(cthd); db.SaveChanges(); } return(1); } catch { return(0); } }
public List <CTHoaDon> GetCTHoaDons(string idhd) { List <CTHoaDon> CTHoaDonList = new List <CTHoaDon>(); DataTable data = DataProvider.Instance.ExecuteQuery("select * from CTHoaDon where IDHoaDon= '" + idhd + "'"); foreach (DataRow item in data.Rows) { CTHoaDon cTHoaDon = new CTHoaDon(item); CTHoaDonList.Add(cTHoaDon); } return(CTHoaDonList); }
public void insertCTHD(CTHoaDon ct) { ErrorCTHDBUS = null; try { cthdDAO.CTHoaDons.Add(ct); cthdDAO.SaveChanges(); } catch (System.Exception ex) { ErrorCTHDBUS = ex; } }
public bool ThemCTHD(CTHoaDon o) { try { dc.CTHoaDons.InsertOnSubmit(o); dc.SubmitChanges(); return(true); } catch { return(false); } }
private XRControl createrLabel2(int stt, CTHoaDon cTHoaDon, float x, float y) { XRLabel lbl = new XRLabel(); lbl.Font = new Font("Times New Roman", 12, FontStyle.Bold); string temp = string.Format("{0,-20}{1,-55}{2,-15}{3,-10}{4,-20}{5,-20}", stt, cTHoaDon.HangHoa.Name, cTHoaDon.HangHoa.DVT, cTHoaDon.SoLuongBan, cTHoaDon.HangHoa.DonGiaBan, cTHoaDon.ThanhTien); lbl.Text = temp; lbl.AutoWidth = true; lbl.CanGrow = false; lbl.WordWrap = false; lbl.LocationF = new PointF(x, y); lbl.PreviewClick += xrLabel_PreviewClick; return(lbl); }
public List <CTHoaDon> ListCTHoaDon(string maphong, int thang) { List <CTHoaDon> list = new List <CTHoaDon>(); string query = string.Format("ChiTietHoaDonOfPhong '{0}','{1}'", maphong, thang); DataTable table = new DataTable(); table = SQL.ThuVienSQL.Instance.Execute_Query(query); foreach (DataRow i in table.Rows) { CTHoaDon tktb = new CTHoaDon(i); list.Add(tktb); } return(list); }
public ActionResult Create2(ChiTietHD model) { if (ModelState.IsValid) { model.id = Environment.TickCount; model.BangSanPham = db.BangSanPhams.Find(model.SP_id); var CTHoaDon = Session["CTHoaDon"] as List <ChiTietHD>; if (CTHoaDon == null) { CTHoaDon = new List <ChiTietHD>(); } CTHoaDon.Add(model); Session["CTHoaDon"] = CTHoaDon; return(RedirectToAction("Create", "BangHoaDon")); } ViewBag.SP_id = new SelectList(db.BangSanPhams, "id", "TenSP", model.SP_id); return(View("Create", model)); }
public ActionResult Edit2(CashBillDetail cashBillDetail) { if (ModelState.IsValid) { cashBillDetail.ID = Environment.TickCount; cashBillDetail.Product = db.Products.Find(cashBillDetail.ProductID); var CTHoaDon = Session["CashBillDetail"] as List <CashBillDetail>; if (CTHoaDon == null) { CTHoaDon = new List <CashBillDetail>(); } CTHoaDon.Add(cashBillDetail); Session["CashBillDetail"] = CTHoaDon; return(Redirect(ControllerContext.HttpContext.Request.UrlReferrer.ToString())); } ViewBag.ProductID = new SelectList(db.Products, "ID", "ProductName", cashBillDetail.ProductID); return(View("Create", cashBillDetail)); }
public ActionResult Create2(CashBillDetail cashBillDetail) { if (ModelState.IsValid) { cashBillDetail.ID = Environment.TickCount; cashBillDetail.Product = db.Products.Find(cashBillDetail.ProductID); var CTHoaDon = Session["CashBillDetail"] as List <CashBillDetail>; if (CTHoaDon == null) { CTHoaDon = new List <CashBillDetail>(); } CTHoaDon.Add(cashBillDetail); Session["CashBillDetail"] = CTHoaDon; return(RedirectToAction("Create", "CashBills")); } ViewBag.ProductID = new SelectList(db.Products, "ID", "ProductName", cashBillDetail.ProductID); return(View("Create", cashBillDetail)); }
public bool addCTHoaDon(CTHoaDon cthd) { String sql = "insert into cthoadon(id_hoadon,id_thucdon,soluong) values (@id_hoadon, @id_thucdon,@soluong)"; SqlConnection conn = DBConnection.Instance.getConnection(); try { cmd = new SqlCommand(sql, conn); conn.Open(); cmd.Parameters.Add("@id_hoadon", SqlDbType.Int).Value = cthd.Id_hoadon; cmd.Parameters.Add("@id_thucdon", SqlDbType.Int).Value = cthd.Id_thucdon; cmd.Parameters.Add("@soluong", SqlDbType.Int).Value = cthd.Soluong; cmd.ExecuteNonQuery(); conn.Close(); }catch (Exception e) { return(false); } return(true); }
private void button2_Click(object sender, EventArgs e) { int rowindex = dgvHoaDon.CurrentCell.RowIndex; int columnindex = dgvHoaDon.CurrentCell.ColumnIndex; string result = dgvHoaDon.Rows[rowindex].Cells[0].Value.ToString(); CTHoaDon httt = new CTHoaDon(); HoaDon hd = new HoaDon(); try { httt.SoHD = int.Parse(dgvHoaDon.Rows[rowindex].Cells[0].Value.ToString()); httt.MaHang = comboBox2.SelectedValue.ToString(); httt.TenHang = tbTHH.Text; httt.DVT = tbDVT.Text; httt.SoLuong = int.Parse(tbSoLuong.Text); httt.DonGia = float.Parse(DonGia.Text); httt.ThanhTien = float.Parse(ThanhTien.Text); bool kq1 = HangHoaTTBLL.ThemHHVaoHD(httt); if (kq1 == true) { MessageBox.Show("Thêm Đơn thành công!", "Thông báo!!!", MessageBoxButtons.OK, MessageBoxIcon.Information); TinhTong(); hd.TongTien = float.Parse(tbTCTTT.Text); HoaDonBLL.UpdateHD(hd); int x = dgvHoaDon.CurrentCell.RowIndex; string y = dgvHoaDon.Rows[rowindex].Cells[0].Value.ToString(); DataTable _dshhtt = HangHoaTTBLL.LayDSHHTT(y); dgvHHTT.DataSource = _dshhtt; } else { MessageBox.Show("Hóa Đơn này đã có!", "Thông báo!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch { MessageBox.Show("Hàng hóa đã đã có!", "Thông báo!!!", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
void TaoDonDatHang(HoaDon ddh, KhachHang kh1) { int demDDH = db.HoaDons.Count(); ddh.MaHD = autoIDHD(demDDH); ddh.MaKH = kh1.MaKH; ddh.NgayDat = DateTime.Now; db.HoaDons.Add(ddh); db.SaveChanges(); List <ItemGioHang> lstGioHang = LayGioHang(); foreach (var item in lstGioHang) { CTHoaDon ctdh = new CTHoaDon(); ctdh.MaHD = ddh.MaHD; ctdh.MaSP = item.MaSP; ctdh.SoLuong = item.SoLuong; SanPham sp = db.SanPhams.Single(x => x.MaSP == item.MaSP); sp.SoLuong -= item.SoLuong; db.CTHoaDons.Add(ctdh); db.SaveChanges(); } }
public bool SuaCTHD(CTHoaDon ct) { return(cthoadon.SuaCTHD(ct)); }
//public int SoDongInDSBan(int id) //{ // for (var i = 0; i < DSBan.Count; i++) // { // if (DSBan[i].IDBan == id) // { // return i; // } // } // return -1; //} #endregion //Gop ban public bool GopBan(int idBanGop, int idBanBiGop) { var timhdbanbigop = this.TimHoaDonTheoIDBan(idBanBiGop); var timhd = this.TimHoaDonTheoIDBan(idBanGop); var hd = new HoaDon() { IDBan = idBanGop, IDNhanVienLap = timhdbanbigop.IDNhanVienLap }; //ban cau co hoa don if (timhd == null) { ThemHoaDon(hd); } foreach (var item in DSCTHD) { if (item.IDHoaDon == timhdbanbigop.IDHoaDon) { //Neu ban gop chua co hoa don if (timhd == null) { var o = new CTHoaDon() { IDHoaDon = hd.IDHoaDon, IDDoUong = item.IDDoUong, GiaBan = item.GiaBan, GiaGoc = item.GiaGoc, SoLuong = item.SoLuong, }; ThemCTHD(o); } //Neu ban gop da co hoa don: lay sp tu ban bi gop + vao ban gop else { var kq = TimCTHDTheoDoUong(timhd.IDHoaDon, item.IDDoUong); //1 San pham gop chua co trong ban gop if (kq == null) { var o = new CTHoaDon() { IDHoaDon = timhd.IDHoaDon, IDDoUong = item.IDDoUong, GiaBan = item.GiaBan, GiaGoc = item.GiaGoc, SoLuong = item.SoLuong, }; ThemCTHD(o); } //San pham da co trong ban gop:them item.SoLuong vao hoa don co ma la timhd.IDHoaDon if (kq != null) { SuaCTHD(timhd.IDHoaDon, item.IDDoUong, item.SoLuong); } } this.XoaCTHD(item.IDHoaDon, item.IDDoUong); } } //sau khi gop ban //+1. Cap nhat trang thai ban //+2. Xoa hao don var ban = new Ban() { IDBan = idBanBiGop, TenBan = TimBan(idBanBiGop).TenBan, TrangThai = "Trống" }; CapNhatBan(ban); dc.SubmitChanges(); return(true); }
public static bool ThemHHVaoHD(CTHoaDon hhtt) { bool kq = CTHoaDonDAL.ThemHHVaoHD(hhtt); return(kq); }
private void bntXacNhanGoiMon_Click(object sender, EventArgs e) { if (txtSoLuongTDConLai.Text == "") { MessageBox.Show("Chọn thực đơn!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (Convert.ToInt32(txtSoLuongTDConLai.Text) < 1) { MessageBox.Show("Thực đơn chọn tạm hết! Vui lòng chọn thực đơn khác!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { if (nbrSoLuong.Value < 1 || nbrSoLuong.Value > Convert.ToInt32(txtSoLuongTDConLai.Text)) { MessageBox.Show("Chưa chọn số lượng thực đơn!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { if (lbbbb.Visible == true) { HoaDon hd = new HoaDon(); hd.Id_ban = Convert.ToInt32(cbbMaBanChon.SelectedValue); hd.Id_khachhang = -1; hd.Ngayhd = DateTime.Now; hd.Sotie = Convert.ToInt32(ChuyenDoi.Instance.ChuyenDoiThanhSo(txtSoTienChon.Text)); hd.Trangthai = 1; if (XuLyHoaDonController.Instance.AddHoaDon(hd)) { CTHoaDon cthd = new CTHoaDon(); cthd.Id_hoadon = Convert.ToInt32(txtIDHoaDonChon.Text); cthd.Id_thucdon = Convert.ToInt32(cbbMaTDChon.SelectedValue); cthd.Soluong = (int)nbrSoLuong.Value; int soluongconlai = int.Parse(txtSoLuongTDConLai.Text) - (int)nbrSoLuong.Value; if (XuLyCTHoaDonController.Instance.addCTHoaDon(cthd) && XuLyThucDonController.Instance.UpdateSoLuongThucDon(cthd.Id_thucdon, soluongconlai)) { MessageBox.Show("Gọi món thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.showCTHoaDon(hd.Id_ban); pn_goimon.Enabled = false; loadDSThucDon(); loadConlai(); if (XuLyBanController.Instance.updateTrangThaiBan(hd.Id_ban, 1)) { loadBan(); } loadCBBBan(); } else { MessageBox.Show("Gọi món thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { MessageBox.Show("Gọi món thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } else { HoaDon hd = new HoaDon(); hd.Id = Convert.ToInt32(txtIDHoaDonChon.Text); hd.Sotie = Convert.ToInt32(ChuyenDoi.Instance.ChuyenDoiThanhSo(txtSoTienChon.Text)); CTHoaDon cthd = new CTHoaDon(); cthd.Id_hoadon = Convert.ToInt32(txtIDHoaDonChon.Text); cthd.Id_thucdon = Convert.ToInt32(cbbMaTDChon.SelectedValue); cthd.Soluong = (int)nbrSoLuong.Value; int soluongconlai = int.Parse(txtSoLuongTDConLai.Text) - (int)nbrSoLuong.Value; if (XuLyCTHoaDonController.Instance.addCTHoaDon(cthd) && XuLyThucDonController.Instance.UpdateSoLuongThucDon(cthd.Id_thucdon, soluongconlai) && XuLyHoaDonController.Instance.updatSoTienHoaDon(hd)) { MessageBox.Show("Gọi món thành công!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); this.showCTHoaDon(Convert.ToInt32(cbbMaBanChon.SelectedValue)); pn_goimon.Enabled = false; loadDSThucDon(); loadConlai(); if (XuLyBanController.Instance.updateTrangThaiBan(Convert.ToInt32(cbbMaBanChon.SelectedValue), 1)) { loadBan(); } loadCBBBan(); } else { MessageBox.Show("Gọi món thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } } } } }
public bool addCTHoaDon(CTHoaDon cthd) { return(CTHoaDonController.Instance.addCTHoaDon(cthd)); }
public bool XoaMon(CTHoaDon ct) { return(cthoadon.XoaMon(ct)); }
public ActionResult DatHang(FormCollection f) { var tenKH = f["deliveryname"]; var SDT = f["deliveryphone"]; var email = f["deliveryemail"]; var diaChi = f["deliveryaddress"]; var ghiChu = f["deliveryNote"]; var HTTT = "Thanh toán sau khi nhận hàng"; var TrangThaiVC = "Đang vận chuyển"; var ThanhToan = false; var TongTien = f["sumOrder"]; var sum = 0; if (Session["TaiKhoan"] == null) { List <ChiTietDHSession> ListSP = LayDonHang(); sum = Convert.ToInt32(TongTien); HoaDon hd = new HoaDon(); hd.MaND = "VangLai"; hd.TenKH = tenKH; hd.SDT = SDT; hd.Email = email; hd.DiaChi = diaChi; hd.HTTT = HTTT; hd.TrangThaiVC = TrangThaiVC; hd.ThanhToan = ThanhToan; hd.Ghichu = ghiChu; hd.Ngay = DateTime.Today; hd.TongTien = sum; db.HoaDon.Add(hd); db.SaveChanges(); //cap nhat chi tiet hoa don foreach (var item in ListSP) { CTHoaDon ct = new CTHoaDon(); ct.MaHD = hd.MaHD; ct.MaSach = item.maSach; ct.SoLuong = item.soLuong; ct.DonGia = item.giaBan; db.CTHoaDon.Add(ct); db.SaveChanges(); } // xoa san pham trong gio hang List <ItemCart> lstGH = LayGioHang(); var SPGHCheck = lstGH.Where(m => m.Chon == true).ToList(); foreach (var item in SPGHCheck) { lstGH.Remove(item); db.SaveChanges(); } } else { NguoiDung ND = (NguoiDung)Session["TaiKhoan"]; var ListSP = db.ChiTietDH.Where(m => m.MaND == ND.TenDN).ToList(); foreach (var item in ListSP) { sum = sum + Convert.ToInt32(item.GiaBan * item.SoLuong); } HoaDon hd = new HoaDon(); hd.MaND = ND.TenDN; hd.TenKH = tenKH; hd.SDT = SDT; hd.Email = email; hd.DiaChi = diaChi; hd.HTTT = HTTT; hd.TrangThaiVC = TrangThaiVC; hd.ThanhToan = ThanhToan; hd.Ghichu = ghiChu; hd.Ngay = DateTime.Today; hd.TongTien = sum; db.HoaDon.Add(hd); db.SaveChanges(); //cap nhat chi tiet hoa don foreach (var item in ListSP) { CTHoaDon ct = new CTHoaDon(); ct.MaHD = hd.MaHD; ct.MaSach = item.MaSach; ct.SoLuong = item.SoLuong; ct.DonGia = item.GiaBan; db.CTHoaDon.Add(ct); db.SaveChanges(); } // xoa san pham trong gio hang var SPGHCheck = db.GioHang.Where(m => m.MaND == ND.TenDN).Where(m => m.Chon == true).ToList(); foreach (var item in SPGHCheck) { db.GioHang.Remove(item); db.SaveChanges(); } } return(View()); }
public bool ThemCTHD(CTHoaDon ct) { return(cthoadon.ThemCTHD(ct)); }