public async Task <ActionResult <PhieuNhapKho> > PostPhieuNhapKho(PhieuNhapKho phieuNhapKho) { _context.PhieuNhapKhos.Add(phieuNhapKho); await _context.SaveChangesAsync(); return(CreatedAtAction("GetPhieuNhapKho", new { id = phieuNhapKho.Id }, phieuNhapKho)); }
private void XoaPhieuNhapKho() { try { PhieuNhapKho vitri = (PhieuNhapKho)gridViewPhieuNhapKho.GetFocusedRow(); if (vitri == null) { return; } else if (db.ChangeTracker.HasChanges()) { XtraMessageBox.Show("Bạn phải lưu dữ liệu vừa thêm/sửa trước khi xoá!", "Xoá", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else if ((XtraMessageBox.Show("Việc nãy sẽ xoá dữ liệu nhập kho của bạn! Bạn chắc chắn muốn xoá " + PhieuNhapKho.TableName + " này?", "Xoá", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)) { var ctp = db.PhieuNhapKhoChiTiets.Where(s => s.SoHoaDon == vitri.SoHoaDon).ToList(); db.PhieuNhapKhoChiTiets.RemoveRange(ctp); db.PhieuNhapKhoes.Remove(vitri); db.SaveChanges(); XtraMessageBox.Show("Đã xoá thành công!", "Xoá", MessageBoxButtons.OK, MessageBoxIcon.Information); NapDuLieu(); } else { XtraMessageBox.Show("Chưa xoá được!", "Xoá", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } catch (Exception ex) { XtraMessageBox.Show("Không xoá được!" + Environment.NewLine + "Lỗi: " + ex.ToString(), "Xoá", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
public async Task <IActionResult> PutPhieuNhapKho(int id, PhieuNhapKho phieuNhapKho) { if (id != phieuNhapKho.Id) { return(BadRequest()); } _context.Entry(phieuNhapKho).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!PhieuNhapKhoExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public ActionResult LuuPhieuNhapKho(PhieuNhapKho phieuNhapKho) { PhieuNhapKho pnk = new PhieuNhapKho { NgayNhapKho = phieuNhapKho.NgayNhapKho, MaNguoiDung = phieuNhapKho.MaNguoiDung, MaNhaCungCap = phieuNhapKho.MaNhaCungCap, TongTien = phieuNhapKho.TongTien, GhiChu = phieuNhapKho.GhiChu, IsDeleted = phieuNhapKho.IsDeleted, NgayChinhSua = DateTime.Now.Date }; bool status = false; try { db.PhieuNhapKhoes.Add(pnk); db.SaveChanges(); SaveAllCTPNK(phieuNhapKho.ChiTietPhieuNhapKhoes, pnk.SoPhieuNhapKho); status = true; SetAlert("Tạo phiếu nhập kho thành công!", "success"); } catch { status = false; throw; } return(new JsonResult { Data = new { status = status } }); }
public ActionResult SuaPhieuNhapKho(PhieuNhapKho phieuNhapKho) { bool status = false; try { var phieunhapkho = db.PhieuNhapKhoes.SingleOrDefault(pnk => pnk.SoPhieuNhapKho == phieuNhapKho.SoPhieuNhapKho); if (phieunhapkho != null) { phieunhapkho.NgayNhapKho = phieuNhapKho.NgayNhapKho; phieunhapkho.MaNguoiDung = phieuNhapKho.MaNguoiDung; phieunhapkho.MaNhaCungCap = phieuNhapKho.MaNhaCungCap; phieunhapkho.TongTien = phieuNhapKho.TongTien; phieunhapkho.GhiChu = phieuNhapKho.GhiChu; phieunhapkho.NgayChinhSua = DateTime.Now.Date; DeleteAllCTPNK(phieunhapkho.SoPhieuNhapKho); SaveAllCTPNK(phieuNhapKho.ChiTietPhieuNhapKhoes, phieunhapkho.SoPhieuNhapKho); db.SaveChanges(); status = true; SetAlert("Sửa phiếu nhập kho thành công!", "success"); } else { status = false; } } catch { status = false; throw; } return(new JsonResult { Data = new { status = status } }); }
private void NapDuLieuPhieu(PhieuNhapKho p) { if (p != null) { textEditSoPhieu.Text = p.SoHoaDon; searchLookUpEditDoiTac.EditValue = p.IdDoiTac; dateEditNgayTao.EditValue = p.NgayLapPhieu; searchLookUpEditNguoiTao.EditValue = p.NguoiTao; spinEditChietKhau.EditValue = p.ChietKhau; memoEditGhiChu.EditValue = p.GhiChu; labelControlTongTien.Text = p.TongTien.ToString("c0"); labelControlTienChietKhau.Text = p.TienChietKhau.ToString("c0"); labelControlThanhTien.Text = p.ThanhTien.ToString("c0"); } else { textEditSoPhieu.Text = DateTime.Now.ToString("yyyyMMddHHmmss", System.Globalization.CultureInfo.GetCultureInfo("vi-VN")); searchLookUpEditDoiTac.EditValue = null; dateEditNgayTao.EditValue = DateTime.Now.Date; searchLookUpEditNguoiTao.EditValue = FrmDangNhap.IdTaiKhoan; spinEditChietKhau.EditValue = null; memoEditGhiChu.EditValue = null; labelControlTongTien.Text = Core.NullData; labelControlTienChietKhau.Text = Core.NullData; labelControlThanhTien.Text = Core.NullData; } }
public bool InsertPhieuNhapKho(PhieuNhapKho phieuNhap, DataGridView dataGridView) { bool result = false; PhieuNhapDAL phieuNhapDAL = new PhieuNhapDAL(); ChiTietPhieuNhapDAL chiTietPhieuNhapDAL = new ChiTietPhieuNhapDAL(); try { if (!DatabaseDAL.TestConnection()) { DatabaseDAL.CreatConn(); } DatabaseDAL.Transaction(); try { result = phieuNhapDAL.InsertPhieuNhapHang(phieuNhap); for (int i = 0; i < dataGridView.RowCount; i++) { if (dataGridView.Rows[i].Cells["STT"].Value != null) { ChiTietPhieuNhap chiTietPhieu = new ChiTietPhieuNhap(); chiTietPhieu.SoChungTu = phieuNhap.SoChungTu; chiTietPhieu.MaHang = dataGridView.Rows[i].Cells["MaHang"].Value?.ToString(); chiTietPhieu.TenHang = dataGridView.Rows[i].Cells["TenHang"].Value?.ToString(); chiTietPhieu.DonViTinh = dataGridView.Rows[i].Cells["DonVitinh"].Value?.ToString(); chiTietPhieu.SoLuongNhap = Convert.ToInt32(dataGridView.Rows[i].Cells["SoLuongNhap"].Value?.ToString()); chiTietPhieu.DonGia = Convert.ToInt32(dataGridView.Rows[i].Cells["DonGia"]?.Value?.ToString()); chiTietPhieu.ThanhTien = Convert.ToDecimal(dataGridView.Rows[i].Cells["ThanhTien"].Value?.ToString()); if (!isEmptyOrNullOrSpecialCharacters(chiTietPhieu.SoChungTu) && !isEmptyOrNullOrSpecialCharacters(chiTietPhieu.MaHang) && !isEmptyOrNullOrSpecialCharacters(chiTietPhieu.TenHang) && !isEmptyOrNullOrSpecialCharacters(chiTietPhieu.DonViTinh) && !isEmptyOrNotNumber(chiTietPhieu.SoLuongNhap) && !isEmptyOrNotNumber(chiTietPhieu.DonGia) && !isEmptyOrNotNumber(chiTietPhieu.ThanhTien)) { if (!isBelongToNSX(chiTietPhieu.MaHang, phieuNhap.MaNSX)) { DatabaseDAL.Rollback(); return(false); } result = chiTietPhieuNhapDAL.InsertChiTietPhieuNhap(chiTietPhieu); } } } DatabaseDAL.Commit(); DatabaseDAL.CloseConnection(); return(result); } catch (Exception e) { MessageBox.Show(e.Message); DatabaseDAL.Rollback(); DatabaseDAL.CloseConnection(); return(false); } } catch (Exception e) { DatabaseDAL.CloseConnection(); MessageBox.Show(e.Message); return(false); } }
private void BtnInPhieu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { PhieuNhapKho phieu = db.PhieuNhapKhoes.Where(s => s.SoHoaDon == textEditSoPhieu.Text).FirstOrDefault(); if (isThemMoi) { CapNhatSoLuongTon(phieu); } _pnk.InPhieu(phieu); }
public ActionResult DeleteConfirmed(int id) { PhieuNhapKho phieuNhapKho = db.PhieuNhapKhoes.Find(id); DeleteAllCTPNK(id); db.PhieuNhapKhoes.Remove(phieuNhapKho); db.SaveChanges(); SetAlert("Xóa phiếu nhập kho thành công!", "success"); return(RedirectToAction("Index")); }
private void CapNhatSoLuongTon(PhieuNhapKho phieu) { db = new ModelQuanLiCafeDbContext(); var listPct = db.PhieuNhapKhoChiTiets.Where(s => s.SoHoaDon == phieu.SoHoaDon).ToList(); foreach (var item in listPct) { var nl = db.NguyenLieux.Where(s => s.IdNguyenLieu == item.IdNguyenLieu).FirstOrDefault(); nl.SoLuongTon += item.SoLuong; } db.SaveChanges(); }
//private void gridViewChiTietPhieu_CellValueChanged(object sender, DevExpress.XtraGrid.Views.Base.CellValueChangedEventArgs e) //{ // //GridView view = sender as GridView; // //if (view == null) return; // //if (e.Column.Caption != "Nguyên liệu") return; // //var dongia = db.NguyenLieux.Find((int)e.Value).DonGia; // //view.SetRowCellValue(e.RowHandle, view.Columns["DonGia"], dongia); // //view.SetRowCellValue(e.RowHandle, view.Columns["SoHoaDon"], textEditSoPhieu.Text); //} private void BtnLuu_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e) { var tempDb = new ModelQuanLiCafeDbContext(); var p = tempDb.PhieuNhapKhoes.Where(s => s.SoHoaDon == textEditSoPhieu.Text).FirstOrDefault(); if (p == null)//thêm mới { p = new PhieuNhapKho(); p.SoHoaDon = textEditSoPhieu.Text; p.IdDoiTac = int.Parse(searchLookUpEditDoiTac.EditValue.ToString()); p.NgayLapPhieu = dateEditNgayTao.DateTime; p.NguoiTao = int.Parse(searchLookUpEditNguoiTao.EditValue.ToString()); try { p.ChietKhau = double.Parse(spinEditChietKhau.EditValue.ToString()); } catch (Exception) { p.ChietKhau = 0; } p.GhiChu = memoEditGhiChu.EditValue != null?memoEditGhiChu.EditValue.ToString() : null; tempDb.PhieuNhapKhoes.Add(p); tempDb.SaveChanges(); } else { p.IdDoiTac = int.Parse(searchLookUpEditDoiTac.EditValue.ToString()); p.ChietKhau = double.Parse(spinEditChietKhau.EditValue.ToString()); p.GhiChu = memoEditGhiChu.EditValue != null?memoEditGhiChu.EditValue.ToString() : null; tempDb.SaveChanges(); } try { gridControlChiTietPhieu.EmbeddedNavigator.Buttons.DoClick(gridControlChiTietPhieu.EmbeddedNavigator.Buttons.EndEdit); int dem = db.SaveChanges(); if (dem > 0) { XtraMessageBox.Show("Đã lưu " + dem + " mẩu tin!", "Lưu", MessageBoxButtons.OK, MessageBoxIcon.Information); NapDuLieuChiTiet(); } NapDuLieuPhieu(p); } catch (Exception ex) { XtraMessageBox.Show("Không lưu được!" + Environment.NewLine + ex.ToString(), "Lưu", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void btn_luu_Click(object sender, EventArgs e) { PhieuNhapKho pnk = new PhieuNhapKho(); pnk.Nhanvien = nhanvien; pnk.MaPNK = txt_sophieu.Text; pnk.MaNCC = txt_maNCC.Text; pnk.Ngaylap = dtp_ngaylap.Value; pnk.Tongtien = float.Parse(lbl_thanhtien.Text); List <ChiTietPhieuNhapKho> listchitiet = new List <ChiTietPhieuNhapKho>(); ChiTietPhieuNhapKho ctpnk; for (int i = 0; i < dgv_chitietPNK.Rows.Count - 1; i++) { ctpnk = new ChiTietPhieuNhapKho(); if (dgv_chitietPNK[0, i].Value != null) { ctpnk.SoPhieu = pnk.MaPNK; ctpnk.MaHH = dgv_chitietPNK[0, i].Value.ToString(); ctpnk.TenHH = dgv_chitietPNK[1, i].Value.ToString(); ctpnk.Dongia = dgv_chitietPNK[2, i].Value.ToString(); ctpnk.Soluong = dgv_chitietPNK[3, i].Value.ToString(); ctpnk.Thanhtien = dgv_chitietPNK[4, i].Value.ToString(); } listchitiet.Add(ctpnk); } pnk.ListchitietPNK = listchitiet; provider = new DataProvider(); int pnk_success = provider.Insert_PhieuNhapKho(pnk); if (pnk_success > 0 && dgv_chitietPNK.Rows.Count > 0) { foreach (ChiTietPhieuNhapKho chitiet in listchitiet) { provider = new DataProvider(); provider.Insert_ChiTietPhieuNhapKho(chitiet); } } if (pnk_success > 0) { MessageBox.Show("Lập phiếu thành công.", "Thông báo"); } else { MessageBox.Show("Lập phiếu thất bại", "Thông báo"); } }
private void buttonX6_Click(object sender, EventArgs e) { if (txt_maphieu.Text == null || txt_maphieu.Text == "") { MessageBox.Show("Hãy Chọn Phiếu Nhập Để In!"); } else { //ReportPhieuXuat.MAPX = txb_maPX.Text; PhieuNhapKho baocaof = new PhieuNhapKho(txt_maphieu.Text); baocaof.ShowDialog(); } }
public void InPhieu(PhieuNhapKho phieu) { if (phieu == null) { return; } var report = new Reports.ReportPhieuNhapKho(); report.KhoiTao(phieu); var printTool = new ReportPrintTool(report); printTool.Report.CreateDocument(true); printTool.ShowPreview(); }
// GET: PhieuNhapKho/Delete/5 public ActionResult Delete(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PhieuNhapKho phieuNhapKho = db.PhieuNhapKhoes.Find(id); if (phieuNhapKho == null) { return(HttpNotFound()); } return(View(phieuNhapKho)); }
public ActionResult Edit([Bind(Include = "SoPhieuNhapKho,NgayNhapKho,MaNguoiDung,MaNhaCungCap,TongTien,GhiChu,IsDeleted,NgayChinhSua")] PhieuNhapKho phieuNhapKho) { if (ModelState.IsValid) { db.Entry(phieuNhapKho).State = EntityState.Modified; db.SaveChanges(); SetAlert("Sửa phiếu nhập kho thành công!", "success"); return(RedirectToAction("Index")); } var user = (NguoiDung)Session["Account"]; ViewBag.MaNguoiDung = new SelectList(db.NguoiDungs.Where(nd => nd.MaNguoiDung == user.MaNguoiDung), "MaNguoiDung", "TenNguoiDung"); ViewBag.MaNhaCungCap = new SelectList(db.NhaCungCaps, "MaNhaCungCap", "TenNhaCungCap", phieuNhapKho.MaNhaCungCap); ViewBag.MaHangHoa = new SelectList(db.HangHoas.Where(i => i.IsDeleted != true), "MaHangHoa", "TenHangHoa"); ViewBag.ChiTietPhieuNhapKho = db.ChiTietPhieuNhapKhoes.ToList(); return(View(phieuNhapKho)); }
// GET: PhieuNhapKho/Details/5 public ActionResult Details(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PhieuNhapKho phieuNhapKho = db.PhieuNhapKhoes.Find(id); if (phieuNhapKho == null) { return(HttpNotFound()); } ViewBag.MaHangHoa = new SelectList(db.HangHoas.Where(i => i.IsDeleted != true), "MaHangHoa", "TenHangHoa"); ViewBag.ChiTietPhieuNhapKho = db.ChiTietPhieuNhapKhoes.ToList(); return(View(phieuNhapKho)); }
public int Insert_PhieuNhapKho(PhieuNhapKho pnk) { query = "INSERT INTO PhieuNhapKho VALUES (@MaPNK, @Ngaylap, @Tongtien, @MaNV, @MaNCC)"; using (conn) { conn.Open(); using (SqlCommand cmd = new SqlCommand(query, conn)) { cmd.Parameters.Add("@MaPNK", SqlDbType.VarChar).Value = pnk.MaPNK; cmd.Parameters.Add("@Ngaylap", SqlDbType.Date).Value = pnk.Ngaylap.Date; cmd.Parameters.Add("@Tongtien", SqlDbType.Float).Value = pnk.Tongtien; cmd.Parameters.Add("@MaNV", SqlDbType.VarChar).Value = pnk.Nhanvien.MaNV; cmd.Parameters.Add("@MaNCC", SqlDbType.VarChar).Value = pnk.MaNCC; return(cmd.ExecuteNonQuery()); } } }
// GET: PhieuNhapKho/Edit/5 public ActionResult Edit(int?id) { if (id == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } PhieuNhapKho phieuNhapKho = db.PhieuNhapKhoes.Find(id); if (phieuNhapKho == null) { return(HttpNotFound()); } var user = (NguoiDung)Session["Account"]; ViewBag.MaNguoiDung = new SelectList(db.NguoiDungs.Where(nd => nd.MaNguoiDung == user.MaNguoiDung), "MaNguoiDung", "TenNguoiDung"); ViewBag.MaNhaCungCap = new SelectList(db.NhaCungCaps.Where(i => i.IsDeleted != true), "MaNhaCungCap", "TenNhaCungCap", phieuNhapKho.MaNhaCungCap); ViewBag.MaHangHoa = new SelectList(db.HangHoas.Where(i => i.IsDeleted != true), "MaHangHoa", "TenHangHoa"); ViewBag.ChiTietPhieuNhapKho = db.ChiTietPhieuNhapKhoes.ToList(); return(View(phieuNhapKho)); }
private void btnGhiSo_Click(object sender, EventArgs e) { PhieuNhapBLL bLL = new PhieuNhapBLL(); PhieuNhapKho phieuNhap = new PhieuNhapKho(); phieuNhap.SoChungTu = txbSohieu.Text; phieuNhap.MaKho = ((DataRowView)cbKhoNhap.SelectedItem)["MaKho"].ToString(); phieuNhap.NgayLapPhieu = dateTimePickerNgayLapPhieu.Value.Date; phieuNhap.NguoiLapPhieu = txbTenNV.Text; phieuNhap.NguoiGiaoHang = txbNguoigiao.Text; phieuNhap.MaNSX = ((DataRowView)cbNhaSX.SelectedItem)["MaNsx"].ToString(); if (bLL.InsertPhieuNhapKho(phieuNhap, dtgvDsHangNhap)) { MessageBox.Show("Đã thêm thành công phiếu nhập!"); } else { MessageBox.Show("Không thể thêm phiếu nhập!"); } }
public int TaoPNK(ePhieuNhapKho pnk) { if (KtraTonTai(pnk.SoPDNN)) { throw new Exception("Không có phiếu đề nghị này"); } if (ktranv(pnk.MaNV, pnk.MaKho)) { throw new Exception("Bạn không phải nhân viên kho này"); } PhieuNhapKho pn = new PhieuNhapKho(); pn.sopnk = pnk.SoPDNN; pn.manhanvien = pnk.MaNV; pn.makho = pnk.MaKho; pn.ghichu = pnk.GhiChu; pn.ngaylap = pnk.NgayLap; db.PhieuNhapKhos.InsertOnSubmit(pn); db.SubmitChanges(); UpdateTinhTrang(pnk); //Chuyen tinh trang phieu DNNK da nhap TaoChiTietKho(pnk.SoPDNN); //Tao chi tiet kho, them maSp va soLuong theo kho đó return(1); }
public void KhoiTao(PhieuNhapKho info, bool isCreateNew) { phieu = info; isThemMoi = isCreateNew; NapDuLieu(); }
public void KhoiTao(PhieuNhapKho p) { phieu = p; }
public bool InsertPhieuNhapHang(PhieuNhapKho phieuNhap) { int result = DatabaseDAL.ExecuteNonQuery("exec USP_InsertPhieuNhapKho @sochungtu , @makho , @nguoilapphieu , @ngaylapphieu , @nguoigiao , @maNSX", new object[] { phieuNhap.SoChungTu, phieuNhap.MaKho, phieuNhap.NguoiLapPhieu, phieuNhap.NgayLapPhieu, phieuNhap.NguoiGiaoHang, phieuNhap.MaNSX }); return(result > 0); }