public ActionResult DeleteConfirmed(int id)
{
Phieu_Nhap_Hang_Hoa phieu_Nhap_Hang_Hoa = db.Phieu_Nhap_Hang_Hoa.Find(id);
db.Phieu_Nhap_Hang_Hoa.Remove(phieu_Nhap_Hang_Hoa);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Hang_Hoa_id,Phieu_Nhap_Id,Don_gia,So_Luong")] Phieu_Nhap_Hang_Hoa phieu_Nhap_Hang_Hoa)
{
if (ModelState.IsValid)
{
db.Entry(phieu_Nhap_Hang_Hoa).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Phieu_Nhap_Id = new SelectList(db.Phieu_Nhap, "Phieu_Nhap_Id", "Phieu_Nhap_Id", phieu_Nhap_Hang_Hoa.Phieu_Nhap_Id);
ViewBag.Hang_Hoa_id = new SelectList(db.Hang_Hoa, "Hang_Hoa_Id", "Ten_Hang_Hoa", phieu_Nhap_Hang_Hoa.Hang_Hoa_id);
return(View(phieu_Nhap_Hang_Hoa));
}
// GET: Phieu_Nhap_Hang_Hoa/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Phieu_Nhap_Hang_Hoa phieu_Nhap_Hang_Hoa = db.Phieu_Nhap_Hang_Hoa.Find(id);
if (phieu_Nhap_Hang_Hoa == null)
{
return(HttpNotFound());
}
return(View(phieu_Nhap_Hang_Hoa));
}
// GET: Phieu_Nhap_Hang_Hoa/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Phieu_Nhap_Hang_Hoa phieu_Nhap_Hang_Hoa = db.Phieu_Nhap_Hang_Hoa.Find(id);
if (phieu_Nhap_Hang_Hoa == null)
{
return(HttpNotFound());
}
ViewBag.Phieu_Nhap_Id = new SelectList(db.Phieu_Nhap, "Phieu_Nhap_Id", "Phieu_Nhap_Id", phieu_Nhap_Hang_Hoa.Phieu_Nhap_Id);
ViewBag.Hang_Hoa_id = new SelectList(db.Hang_Hoa, "Hang_Hoa_Id", "Ten_Hang_Hoa", phieu_Nhap_Hang_Hoa.Hang_Hoa_id);
return(View(phieu_Nhap_Hang_Hoa));
}
public bool ThemPhieuNhapHH(int ma_phieu, Phieu_Nhap_Json pn)
{
using (QuanLyKhoEntities db = new QuanLyKhoEntities())
{
using (var tran = db.Database.BeginTransaction())
{
try
{
var pnhh = new Phieu_Nhap_Hang_Hoa();
pnhh.Phieu_Nhap_Id = ma_phieu;
pnhh.Don_gia = pn.Don_gia;
pnhh.So_Luong = pn.So_Luong;
pnhh.Hang_Hoa_id = pn.Hang_Hoa_id;
db.Phieu_Nhap_Hang_Hoa.Add(pnhh);
var kho = db.Kho_Chua.Find(pnhh.Hang_Hoa_id);
if (kho != null)
{
kho.So_Luong += pnhh.So_Luong;
db.Entry(kho).State = System.Data.Entity.EntityState.Modified;
}
else
{
kho = new Kho_Chua();
kho.Hang_Hoa_Id = pnhh.Hang_Hoa_id;
kho.So_Luong = pnhh.So_Luong;
db.Entry(kho).State = System.Data.Entity.EntityState.Added;
}
db.SaveChanges();
tran.Commit();
return(true);
}catch (Exception)
{
tran.Rollback();
return(false);
}
}
}
}
