public ActionResult DeleteConfirmed(int id)
{
Bill_Import bill_Import = db.Bill_Import.Find(id);
db.Bill_Import.Remove(bill_Import);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Bill_Import_id,NXB_id,Total,Deliver,CreatedDate")] Bill_Import bill_Import)
{
if (ModelState.IsValid)
{
db.Entry(bill_Import).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.NXB_id = new SelectList(db.NXBs, "NXB_id", "NXB_name", bill_Import.NXB_id);
return(View(bill_Import));
}
public ActionResult ThemChiTietPhieuNhap()
{
Bill_Import bill = new Bill_Import();
bill = (Bill_Import)Session["PhieuNhap"];
var lstBookid = (from b in db.Books
where b.NXB_id == bill.NXB_id
select b).ToList();
ViewBag.sach = new SelectList(lstBookid, "Book_id", "Book_name");
//ViewBag.sach = new SelectList(db.Books,"Book_id","Book_name");
//var phieunhap = (Bill_Import)TempData["PhieuNhap"];
return(View());
}
public ActionResult Create([Bind(Include = "Bill_Import_id,NXB_id,Total,Deliver,CreatedDate")] Bill_Import bill_Import)
{
if (ModelState.IsValid)
{
bill_Import.CreatedDate = DateTime.Now;
var tempbillimport = bill_Import;
Session["ctphieunhap"] = new List <Detail_Bill_Import>();
Session["PhieuNhap"] = bill_Import;
return(RedirectToAction("ThemChiTietPhieuNhap"));
}
ViewBag.NXB_id = new SelectList(db.NXBs, "NXB_id", "NXB_name", bill_Import.NXB_id);
return(View(bill_Import));
}
// GET: Bill_Import/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Bill_Import bill_Import = db.Bill_Import.Find(id);
if (bill_Import == null)
{
return(HttpNotFound());
}
return(View(bill_Import));
}
// GET: Bill_Import/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Bill_Import bill_Import = db.Bill_Import.Find(id);
if (bill_Import == null)
{
return(HttpNotFound());
}
ViewBag.NXB_id = new SelectList(db.NXBs, "NXB_id", "NXB_name", bill_Import.NXB_id);
return(View(bill_Import));
}
// GET: Bill_Import/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Bill_Import bill_Import = db.Bill_Import.Find(id);
var a = (from b in db.Detail_Bill_Import
where b.Bill_Import_id == id
select b).ToList();
ViewBag.ctpn = a;
if (bill_Import == null)
{
return(HttpNotFound());
}
return(View(bill_Import));
}
public ActionResult ThemChiTietPhieuNhap(FormCollection chitiet)
{
//test
Bill_Import bill = new Bill_Import();
bill = (Bill_Import)Session["PhieuNhap"];
var lstBookid = (from b in db.Books
where b.NXB_id == bill.NXB_id
select b).ToList();
ViewBag.sach = new SelectList(lstBookid, "Book_id", "Book_name");
//
ViewBag.loi = null;
if (Request.Form["add"] != null)
{
if (ModelState.IsValid)
{
bool check = true;
foreach (var ctpn in (List <Detail_Bill_Import>)Session["ctphieunhap"])
{
if (ctpn.Book_id == Int32.Parse(chitiet["sach"].ToString()))
{
check = false;
ViewBag.loi = "Sách đã được thêm vào phiếu trước đó";
break;
}
}
if (check)
{
if (chitiet["sach"] == null)
{
ViewBag.loi = "Không có sách của NXB này";
goto baoloi;
}
var sach = db.Books.Find(Int32.Parse(chitiet["sach"].ToString()));
if (sach == null)
{
ViewBag.loi = "Mã sách không tồn tại";
goto baoloi;
}
else
{
int soluong = Int32.Parse(chitiet["soluong"].ToString());
if (soluong > 0)
{
Detail_Bill_Import ctpn = new Detail_Bill_Import();
ctpn.Bill_Import_id = (db.Bill_Import.Max(u => (int?)u.Bill_Import_id) != null ? db.Bill_Import.Max(u => u.Bill_Import_id) : 0) + 1;// db.Bill_Import.Count() + 1;
ctpn.Book_id = Int32.Parse(chitiet["sach"].ToString());
ctpn.Quantity = soluong;
ctpn.Cost = db.Books.Find(ctpn.Book_id).Cost_Import;
ctpn.Total = ctpn.Quantity * ctpn.Cost;
//((List<Int32>)Session["BookID"]).Add(ctpn.Book_id);
((List <Detail_Bill_Import>)Session["ctphieunhap"]).Add(ctpn);
}
else
{
ViewBag.loi = "Nhập số lượng lớn hơn 0";
goto baoloi;
}
}
return(RedirectToAction("ThemChiTietPhieuNhap"));
}
else
{
//không làm gì để nó return View();
}
}
}
else if (Request.Form["create"] != null)
{
if (ModelState.IsValid)
{
if (((List <Detail_Bill_Import>)Session["ctphieunhap"]).Count == 0)
{
ViewBag.loi = "Không được để phiếu trống";
goto baoloi;
}
double tongTien = 0;
double? temptongtien = 0;
Bill_Import test = new Bill_Import();
test = (Bill_Import)Session["PhieuNhap"];
var luu = db.Bill_Import.Add(test);
db.SaveChanges();
foreach (var ctpn in (List <Detail_Bill_Import>)Session["ctphieunhap"])
{
temptongtien += (ctpn.Cost * ctpn.Quantity);
tongTien = double.Parse(temptongtien.ToString());
//tongSoLuong += ctpn.SoLuongNhap;
Detail_Bill_Import ctPhieuNhap = new Detail_Bill_Import();
ctPhieuNhap = ctpn;
db.Detail_Bill_Import.Add(ctPhieuNhap);
//db.SaveChanges();
//cập nhật tồn kho công ty
Inventory_Book tonkho = new Inventory_Book();
tonkho.UpdatedDate = DateTime.Now;
Inventory_Book tonkho1 = db.Inventory_Book.OrderByDescending(m => m.id).FirstOrDefault(m => m.Book_id == (int)ctpn.Book_id);
if (tonkho1 != null)
{
tonkho.Book_id = ctpn.Book_id;
tonkho.Quantity = tonkho1.Quantity + ctpn.Quantity;
}
else
{
tonkho.Book_id = ctpn.Book_id;
tonkho.Quantity = ctpn.Quantity;
}
db.Inventory_Book.Add(tonkho);
}
//addedPhieuNhap.TongSoLuong = tongSoLuong;
luu.Total = tongTien;
db.Bill_Import.Attach(luu);
db.Entry(luu).State = EntityState.Modified;
db.SaveChanges();
//cập nhật công nợ NXB
Debt_NXB debt = new Debt_NXB();
debt.update_date = DateTime.Now;
Debt_NXB debt1 = db.Debt_NXB.OrderByDescending(m => m.id).FirstOrDefault(m => m.NXB_id == (int)luu.NXB_id);
if (debt1 != null)
{
debt.NXB_id = luu.NXB_id;
debt.debt = debt1.debt + luu.Total;
}
else
{
debt.NXB_id = luu.NXB_id;
debt.debt = luu.Total;
}
db.Debt_NXB.Add(debt);
db.SaveChanges();
Session["ctphieunhap"] = null;
Session["PhieuNhap"] = null;
return(RedirectToAction("Create"));
}
}
baoloi:
return(View());
}
