public ActionResult DeleteConfirmed(int id)
{
ChiTietPhieuNhapKho chiTietPhieuNhapKho = db.ChiTietPhieuNhapKhoes.Find(id);
db.ChiTietPhieuNhapKhoes.Remove(chiTietPhieuNhapKho);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "SoPhieuNhapKho,MaHangHoa,SoLuong,GiaNhap,MaNhaCungCap,ThanhTien")] ChiTietPhieuNhapKho chiTietPhieuNhapKho)
{
if (ModelState.IsValid)
{
db.Entry(chiTietPhieuNhapKho).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.MaHangHoa = new SelectList(db.HangHoas, "MaHangHoa", "TenHangHoa", chiTietPhieuNhapKho.MaHangHoa);
ViewBag.SoPhieuNhapKho = new SelectList(db.PhieuNhapKhoes, "SoPhieuNhapKho", "GhiChu", chiTietPhieuNhapKho.SoPhieuNhapKho);
return(View(chiTietPhieuNhapKho));
}
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");
}
}
// GET: ChiTietPhieuNhapKho/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietPhieuNhapKho chiTietPhieuNhapKho = db.ChiTietPhieuNhapKhoes.Find(id);
if (chiTietPhieuNhapKho == null)
{
return(HttpNotFound());
}
return(View(chiTietPhieuNhapKho));
}
// GET: ChiTietPhieuNhapKho/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
ChiTietPhieuNhapKho chiTietPhieuNhapKho = db.ChiTietPhieuNhapKhoes.Find(id);
if (chiTietPhieuNhapKho == null)
{
return(HttpNotFound());
}
ViewBag.MaHangHoa = new SelectList(db.HangHoas, "MaHangHoa", "TenHangHoa", chiTietPhieuNhapKho.MaHangHoa);
ViewBag.SoPhieuNhapKho = new SelectList(db.PhieuNhapKhoes, "SoPhieuNhapKho", "GhiChu", chiTietPhieuNhapKho.SoPhieuNhapKho);
return(View(chiTietPhieuNhapKho));
}
public async Task <IActionResult> PutChiTietPhieuNhapKho(int id, ChiTietPhieuNhapKho chiTietPhieuNhapKho)
{
var a = await _context.ChiTietPhieuNhapKhos.FindAsync(id);
if (a == null)
{
return(NotFound());
}
a.soluong = chiTietPhieuNhapKho.soluong;
a.gia = chiTietPhieuNhapKho.gia;
a.donvi = chiTietPhieuNhapKho.donvi;
a.NguyenLieu_ID = chiTietPhieuNhapKho.NguyenLieu_ID;
a.PhieuNhapKho_ID = chiTietPhieuNhapKho.PhieuNhapKho_ID;
_context.ChiTietPhieuNhapKhos.Update(a);
await _context.SaveChangesAsync();
return(Ok(a));
}
public void Insert_ChiTietPhieuNhapKho(ChiTietPhieuNhapKho chitiet)
{
query = "INSERT INTO ChiTietPhieuNhapKho (maPNK, maHH, tenHH, soluong, dongia, thanhtien) " +
"VALUES (@MaPNK, @MaHH, @TenHH, @Soluong, @Dongia, @Thanhtien)";
using (conn)
{
conn.Open();
using (SqlCommand cmd = new SqlCommand(query, conn))
{
cmd.Parameters.Add("@MaPNK", SqlDbType.VarChar).Value = chitiet.SoPhieu;
cmd.Parameters.Add("@MaHH", SqlDbType.VarChar).Value = chitiet.MaHH;
cmd.Parameters.Add("@TenHH", SqlDbType.NVarChar).Value = chitiet.TenHH;
cmd.Parameters.Add("@Soluong", SqlDbType.Int).Value = chitiet.Soluong;
cmd.Parameters.Add("@Dongia", SqlDbType.Float).Value = float.Parse(chitiet.Dongia);
cmd.Parameters.Add("@Thanhtien", SqlDbType.Float).Value = double.Parse(chitiet.Thanhtien);
cmd.ExecuteNonQuery();
}
}
}
public async Task <ActionResult <ChiTietPhieuNhapKho> > PostChiTietPhieuNhapKho(ChiTietPhieuNhapKho chiTietPhieuNhapKho)
{
NguyenLieu nl = await _context.NguyenLieus.SingleAsync(x => x.Id == chiTietPhieuNhapKho.NguyenLieu_ID);
nl.soluong += chiTietPhieuNhapKho.soluong;
_context.ChiTietPhieuNhapKhos.Add(chiTietPhieuNhapKho);
await _context.SaveChangesAsync();
return(CreatedAtAction("GetChiTietPhieuNhapKho", new { id = chiTietPhieuNhapKho.Id }, chiTietPhieuNhapKho));
}
