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