public async Task Create(PhieuBanHangViewModel obj) { PhieuBanHang order = new PhieuBanHang { SoPhieuBanHang = obj.soPhieuBanHang, NgayBan = obj.ngayBan, MaNhanVien = obj.maNhanVien, Ghichu = obj.ghiChu, TenKhachHang = obj.tenKhachHang, SoDienThoai = obj.soDienThoai, TongTien = obj.tongTien, TrangThai = true, NgayChinhSua = DateTime.Now }; order.ChiTetPhieuBanHangs = new List <ChiTietPhieuBanHang>(); DateTime today = DateTime.Now; int thang = today.Month; int nam = today.Year; foreach (var i in obj.chiTietPhieuBanHang) { order.ChiTetPhieuBanHangs.Add(i); //Sơn _hangHoaBus.CapNhatHangHoaKhiTaoPhieuBanHang(i.MaHangHoa, i.SoLuong); _hangHoaBus.CapNhatHangHoaVaoBaoCaoTonKhoKhiTaoPhieuBanHang(i.MaHangHoa, i.SoLuong, thang, nam); } await _phieuBanHangRepo.InsertAsync(order); }
public ActionResult SuaPhieuBanHang(PhieuBanHang phieuBanHang) { bool status = false; try { var phieubanhang = db.PhieuBanHangs.SingleOrDefault(pbh => pbh.SoPhieuBanHang == phieuBanHang.SoPhieuBanHang); if (phieubanhang != null) { phieubanhang.NgayBan = phieuBanHang.NgayBan; phieubanhang.MaNguoiDung = phieuBanHang.MaNguoiDung; phieubanhang.TenKhachHang = phieuBanHang.TenKhachHang; phieubanhang.TongTien = phieuBanHang.TongTien; phieubanhang.SoDienThoai = phieuBanHang.SoDienThoai; phieubanhang.GhiChu = phieuBanHang.GhiChu; phieubanhang.IsDeleted = phieuBanHang.IsDeleted; phieubanhang.NgayChinhSua = DateTime.Now.Date; db.SaveChanges(); status = true; SetAlert("Sửa phiếu bán hàng thành công!", "success"); } else { status = false; } } catch { status = false; throw; } return(new JsonResult { Data = new { status = status } }); }
public async Task Create(PhieuBanHangViewModel O) { var nhanVien = _nhanVienRepo.GetAll().ToList(); var maNhienVien = nhanVien.FirstOrDefault(t => t.TenNhanvien == O.tenNhanVien).MaNhanVien; PhieuBanHang order = new PhieuBanHang { SoPhieuBanHang = O.soPhieuBanHang, NgayBan = O.ngayBan, MaNhanVien = maNhienVien, Ghichu = O.ghiChu, TrangThai = true, TenKhachHang = O.tenKhachHang, SoDienThoai = O.soDienThoai, TongTien = O.tongTien, NgayChinhSua = DateTime.Now, ChiTietPhieuBanHangs = O.chiTietPhieuBanHang }; await _phieuBanHangRepo.InsertAsync(order); // Lấy các mã hàng hóa để giảm số lượng => Lấy trong chi tiết phiếu bán hàng foreach (var item in order.ChiTietPhieuBanHangs) { _hangHoaBus.CapNhapHangHoaVaoBaoCaoTonKhiTaoPhieuBanHang(item.MaHangHoa, item.SoLuong, DateTime.Now.Month, DateTime.Now.Year); //Tìm trong csdl các hàng hóa có mã hàng hóa ở trên var hanghoa = _hangHoaRepo.Fetch(t => t.MaHangHoa == item.MaHangHoa).FirstOrDefault(); //Trừ số lượng người nhập hanghoa.SoLuongTon = hanghoa.SoLuongTon - item.SoLuong; //Lưu lại await _hangHoaRepo.EditAsync(hanghoa); } }
public ActionResult LuuPhieuBanHang(PhieuBanHang phieuBanHang) { PhieuBanHang pbh = new PhieuBanHang { NgayBan = phieuBanHang.NgayBan, MaNguoiDung = phieuBanHang.MaNguoiDung, TenKhachHang = phieuBanHang.TenKhachHang, TongTien = phieuBanHang.TongTien, SoDienThoai = phieuBanHang.SoDienThoai, GhiChu = phieuBanHang.GhiChu, IsDeleted = phieuBanHang.IsDeleted, NgayChinhSua = DateTime.Now.Date }; bool status = false; try { db.PhieuBanHangs.Add(pbh); db.SaveChanges(); SaveAllCTPBH(phieuBanHang.ChiTietPhieuBanHangs, pbh.SoPhieuBanHang); SetAlert("Tạo phiếu bán hàng thành công!", "success"); status = true; } catch { status = false; throw; } return(new JsonResult { Data = new { status = status } }); }
//[HttpPost] public async Task <ActionResult> Deletes(int id) { PhieuBanHang huyPhieuBanHang = (PhieuBanHang)await _phieuBanHangBus.Find(id); if (huyPhieuBanHang == null) { SetAlert("Đã xảy ra lỗi! Bạn hãy hủy lại", "error"); return(RedirectToAction("Edit")); } else { try { await _phieuBanHangBus.HuyPhieuBanHang(huyPhieuBanHang); SetAlert("Đã hủy phiếu kiểm kho thành công!!!", "success"); } catch { SetAlert("Đã xảy ra lỗi! Bạn hãy hủy lại", "error"); return(RedirectToAction("Edit")); } } return(RedirectToAction("Index")); }
public async Task <ActionResult> Deletes(int id) { PhieuBanHang deletePhieuBanHang = (PhieuBanHang)await _phieuBanHangBUS.Find(id); if (deletePhieuBanHang == null) { return(HttpNotFound()); } else { // Access delete from Business try { await _phieuBanHangBUS.Delete(deletePhieuBanHang); SetAlert("Đã hủy phiếu bán hàng thành công!!!", "success"); } catch { SetAlert("Đã xảy ra lỗi! Bạn hãy hủy lại", "error"); return(RedirectToAction("Delete")); } } return(RedirectToAction("Index")); }
private void gridView1_MasterRowEmpty(object sender, DevExpress.XtraGrid.Views.Grid.MasterRowEmptyEventArgs e) { GridView view = sender as GridView; PhieuBanHang Phieu = view.GetRow(e.RowHandle) as PhieuBanHang; if (Phieu != null) { e.IsEmpty = !CT_phieu.Any(x => x.MaPBH == Phieu.MaBH); } }
private void gridView1_MasterRowGetChildList(object sender, DevExpress.XtraGrid.Views.Grid.MasterRowGetChildListEventArgs e) { GridView view = sender as GridView; PhieuBanHang Phieu = view.GetRow(e.RowHandle) as PhieuBanHang; if (Phieu != null) { e.ChildList = CT_phieu.Where(x => x.MaPBH == Phieu.MaBH).ToList(); } }
public ActionResult DeleteConfirmed(int id) { DeleteAllCTPBH(id); PhieuBanHang phieuBanHang = db.PhieuBanHangs.Find(id); DeleteAllCTPBH(id); db.PhieuBanHangs.Remove(phieuBanHang); db.SaveChanges(); SetAlert("Xóa phiếu bán hàng thành công!", "success"); return(RedirectToAction("Index")); }
public bool CheckSoLuong(PhieuBanHang pbh) { foreach (var i in pbh.ChiTietPhieuBanHangs) { var hanghoa = db.HangHoas.Where(hh => hh.MaHangHoa == i.MaHangHoa).FirstOrDefault(); if (i.SoLuong > hanghoa.SoLuong) { return(false); } } return(true); }
public ActionResult Edit([Bind(Include = "SoPhieuBanHang,NgayBan,MaNguoiDung,TenKhachHang,SoDienThoai,TongTien,GhiChu,NgayChinhSua,IsDeleted")] PhieuBanHang phieuBanHang) { if (ModelState.IsValid) { db.Entry(phieuBanHang).State = EntityState.Modified; db.SaveChanges(); return(RedirectToAction("Index")); } var user = (NguoiDung)Session["Account"]; ViewBag.MaNguoiDung = new SelectList(db.NguoiDungs.Where(nd => nd.MaNguoiDung == user.MaNguoiDung), "MaNguoiDung", "TenNguoiDung"); ViewBag.MaHangHoa = new SelectList(db.HangHoas.Where(hh => hh.IsDeleted == false), "MaHangHoa", "TenHangHoa"); ViewBag.ChiTietPhieuBanHang = db.ChiTietPhieuBanHangs.ToList(); return(View(phieuBanHang)); }
// GET: PhieuBanHang/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PhieuBanHang phieuBanHang = db.PhieuBanHangs.Find(id); if (phieuBanHang == null) { return(HttpNotFound()); } return(View(phieuBanHang)); }
// GET: PhieuBanHang/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PhieuBanHang phieuBanHang = db.PhieuBanHangs.Find(id); if (phieuBanHang == null) { return(HttpNotFound()); } ViewBag.MaHangHoa = new SelectList(db.HangHoas.Where(i => i.IsDeleted != true), "MaHangHoa", "TenHangHoa"); ViewBag.ChiTietPhieuBanHang = db.ChiTietPhieuBanHangs.ToList(); return(View(phieuBanHang)); }
private void btnOpenForm_Click(object sender, EventArgs e) { Button btn = sender as Button; if (btn.Text == "Nhập hàng") { PhieuNhapHang frmPhieuNhap = new PhieuNhapHang(); frmPhieuNhap.ShowDialog(); } else if (btn.Text == "Bán hàng") { PhieuBanHang frmBanHang = new PhieuBanHang(); frmBanHang.ShowDialog(); } else if (btn.Text == "Khách hàng") { KhachHang frmKhachHang = new KhachHang(); frmKhachHang.ShowDialog(); } else if (btn.Text == "Kiểm tra kho hàng") { KhoHang frmKhoHang = new KhoHang(); frmKhoHang.ShowDialog(); } else if (btn.Text == "Nhà cung cấp") { NhaCungCap frmNhaCungCap = new NhaCungCap(); frmNhaCungCap.ShowDialog(); } else if (btn.Text == "Ghi nợ") { GhiNo frmGhiNo = new GhiNo(); frmGhiNo.ShowDialog(); } else if (btn.Text == "Thống kê") { ThongKe frmThongKe = new ThongKe(); frmThongKe.ShowDialog(); } else { ThayDoiQuyDinh frmThayDoiQuyDinh = new ThayDoiQuyDinh(); frmThayDoiQuyDinh.ShowDialog(); } }
// GET: PhieuBanHang/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PhieuBanHang phieuBanHang = db.PhieuBanHangs.Find(id); if (phieuBanHang == null) { return(HttpNotFound()); } var user = (NguoiDung)Session["Account"]; ViewBag.MaNguoiDung = new SelectList(db.NguoiDungs.Where(nd => nd.MaNguoiDung == user.MaNguoiDung), "MaNguoiDung", "TenNguoiDung"); ViewBag.MaHangHoa = new SelectList(db.HangHoas.Where(hh => hh.IsDeleted == false), "MaHangHoa", "TenHangHoa"); ViewBag.ChiTietPhieuBanHang = db.ChiTietPhieuBanHangs.ToList(); return(View(phieuBanHang)); }
public async Task HuyPhieuBanHang(object editModel) { try { PhieuBanHang editPhieuBanHang = (PhieuBanHang)editModel; var phieuBanHang = dbContext.ChiTietPhieuBanHanges.Where(x => x.SoPhieuBanHang == editPhieuBanHang.SoPhieuBanHang); foreach (var i in phieuBanHang) { _hangHoaBus.CapNhapHangHoaVaoBaoCaoTonKhiHuyPhieuBanHang(i.MaHangHoa, i.SoLuong, editPhieuBanHang.NgayBan.Month, editPhieuBanHang.NgayBan.Year); _hangHoaBus.CapNhatHangHoaKhiXoaPhieuBanHang(i.MaHangHoa, i.SoLuong); } editPhieuBanHang.TrangThai = false; await _phieuBanHangRepo.EditAsync(editPhieuBanHang); } catch (Exception) { } }
public async Task Delete(object deleteModel) { PhieuBanHang xoaPhieuBanHang = (PhieuBanHang)deleteModel; xoaPhieuBanHang.NgayChinhSua = DateTime.Now; xoaPhieuBanHang.TrangThai = false; //Sơn var phieuBanHang = dbContext.ChiTietPhieuBanHangs.Where(x => x.SoPhieuBanHang == xoaPhieuBanHang.SoPhieuBanHang); int thang = dbContext.PhieuBanHangs.SingleOrDefault(x => x.SoPhieuBanHang == xoaPhieuBanHang.SoPhieuBanHang).NgayBan.Month; int nam = dbContext.PhieuBanHangs.SingleOrDefault(x => x.SoPhieuBanHang == xoaPhieuBanHang.SoPhieuBanHang).NgayBan.Year; foreach (var i in phieuBanHang) { _hangHoaBus.CapNhatHangHoaKhiXoaPhieuBanHang(i.MaHangHoa, i.SoLuong); _hangHoaBus.CapNhatHangHoaVaoBaoCaoTonKhoKhiXoaPhieuBanHang(i.MaHangHoa, i.SoLuong, thang, nam); } await _phieuBanHangRepo.EditAsync(xoaPhieuBanHang); //await _phieuBanHangRepo.DeleteAsync(xoaPhieuBanHang); }
private void gr_btn_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e) { int intRow = gridView1.FocusedRowHandle; if ((intRow >= 0) && (gridView1.GetRowCellValue(intRow, "DonHangID") != null)) { string strDonHangID = gridView1.GetRowCellValue(intRow, "DonHangID").ToString(); switch (e.Button.Caption.ToUpper()) { case "PRINT": PhieuBanHang rp = new PhieuBanHang(); rp.SetDataSource(reportsController.prtDonHang(strDonHangID)); rp.Refresh(); ThongTinShop shop = ThongTinShopController.GetItem(); rp.SetParameterValue("TenShop", shop.TenShop); rp.SetParameterValue("DiaChi", shop.DiaChi); rp.SetParameterValue("SoDienThoai", shop.SoDienThoai); rp.SetParameterValue("WebSite", shop.website); frmViewReports fReport = null; foreach (Form item in MdiChildren) { if (item.GetType() == typeof(frmViewReports)) { fReport = (item as frmViewReports); fReport.crystalReportViewer1.ReportSource = rp; fReport.Activate(); return; } } fReport = new frmViewReports(); fReport.crystalReportViewer1.ReportSource = rp; fReport.MdiParent = this.MdiParent; fReport.Show(); break; case "DEL": if (MessageBox.Show("Bạn muốn xóa đơn hàng này", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { DonHangController.Del(strDonHangID); gridControl1.DataSource = DonHangController.GetAllList(); } break; case "VIEW": DonHang viewItem = DonHangController.GetItem(strDonHangID); if (viewItem != null) { frmAddDonHang f = new frmAddDonHang(); f.ViewItem = viewItem; f.forMode = "view"; f.MdiParent = this.MdiParent; f.Show(); this.Dispose(); } break; default: break; } } }
public ActionResult LuuPhieuBanHangTuPhieuDatHang(PhieuBanHang phieuBanHang) { var idnguoidung = -1; if (Session["Account"] != null) { if (!CheckSoLuong(phieuBanHang)) { return(new JsonResult { Data = new { status = false } }); } NguoiDung a = Session["Account"] as NguoiDung; idnguoidung = a.MaNguoiDung; PhieuBanHang pbh = new PhieuBanHang { NgayBan = phieuBanHang.NgayBan, MaNguoiDung = idnguoidung, TenKhachHang = phieuBanHang.TenKhachHang, TongTien = phieuBanHang.TongTien, SoDienThoai = phieuBanHang.SoDienThoai, GhiChu = phieuBanHang.GhiChu, IsDeleted = phieuBanHang.IsDeleted, NgayChinhSua = DateTime.Now.Date }; bool status = false; try { db.PhieuBanHangs.Add(pbh); db.SaveChanges(); SaveAllCTPBH(phieuBanHang.ChiTietPhieuBanHangs, pbh.SoPhieuBanHang); SetAlert("Tạo phiếu bán hàng thành công!", "success"); status = true; } catch { status = false; throw; } return(new JsonResult { Data = new { status = status } }); } else //NO SESSION { if (!CheckSoLuong(phieuBanHang)) { return(new JsonResult { Data = new { status = false } }); } PhieuBanHang pbh = new PhieuBanHang { NgayBan = phieuBanHang.NgayBan, MaNguoiDung = phieuBanHang.MaNguoiDung, TenKhachHang = phieuBanHang.TenKhachHang, TongTien = phieuBanHang.TongTien, SoDienThoai = phieuBanHang.SoDienThoai, GhiChu = phieuBanHang.GhiChu, IsDeleted = phieuBanHang.IsDeleted, NgayChinhSua = DateTime.Now.Date }; bool status = false; try { db.PhieuBanHangs.Add(pbh); db.SaveChanges(); SaveAllCTPBH(phieuBanHang.ChiTietPhieuBanHangs, pbh.SoPhieuBanHang); status = true; } catch { status = false; throw; } return(new JsonResult { Data = new { status = status } }); } }