public IActionResult themSach(SachChiNhanh Model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
SachChiNhanh sachChiNhanh = (from scn in context.SachChiNhanhs
where scn.IDChiNhanh == Model.IDChiNhanh && scn.IDSach == Model.IDSach
select new SachChiNhanh
{
IDSachChiNhanh = scn.IDSachChiNhanh,
IDSach = scn.IDSach,
IDChiNhanh = scn.IDChiNhanh,
TongSoLuong = scn.TongSoLuong,
SoSachCon = scn.SoSachCon
}).SingleOrDefault();
if (sachChiNhanh != null)
{
ModelState.AddModelError("", "Sách này đã trùng");
return(View());
}
//Model.ID = Int32.Parse(null);
context.SachChiNhanhs.Add(Model);
context.SaveChanges();
return(View("SachTrongChiNhanh"));
}
public IActionResult themSach(SachChiNhanh Model)
{
//phân quyền
if (HttpContext.Session.GetString("TaiKhoanNv") == null)
{
return(RedirectToAction("Login", "NhanVien"));
}
//
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
SachChiNhanh sachChiNhanh = (from scn in context.SachChiNhanhs
where scn.IDChiNhanh == Model.IDChiNhanh && scn.IDSach == Model.IDSach
select new SachChiNhanh
{
IDSachChiNhanh = scn.IDSachChiNhanh,
IDSach = scn.IDSach,
IDChiNhanh = scn.IDChiNhanh,
TongSoLuong = scn.TongSoLuong,
SoSachCon = scn.SoSachCon
}).SingleOrDefault();
if (sachChiNhanh != null)
{
sachChiNhanh.TongSoLuong += Model.TongSoLuong;
sachChiNhanh.SoSachCon += Model.TongSoLuong;
context.SachChiNhanhs.Update(sachChiNhanh);
context.SaveChanges();
return(RedirectToAction("SachTrongChiNhanh"));
}
else
{
Model.SoSachCon = Model.TongSoLuong;
context.SachChiNhanhs.Add(Model);
context.SaveChanges();
}
//Model.ID = Int32.Parse(null);
return(RedirectToAction("SachTrongChiNhanh"));
}
public IActionResult DatSach(int id, int?idchinhanh)
{
//phân quyền
if (HttpContext.Session.GetString("TaiKhoan") == null)
{
return(RedirectToAction("Login", "DocGia"));
}
//
if (idchinhanh == 0)
{
return(RedirectToAction("Details", "Sach", new { id = id }));
}
if (HttpContext.Session.GetInt32("LoaiTaiKhoan") == 0)
{
if (soSachDangMuon((int)HttpContext.Session.GetInt32("IDDocGia")) >= 5)
{
return(RedirectToAction("Details", "Sach", new { id = id }));
}
}
else if (HttpContext.Session.GetInt32("LoaiTaiKhoan") == 2)
{
if (soSachDangMuon((int)HttpContext.Session.GetInt32("IDDocGia")) >= 3)
{
return(RedirectToAction("Details", "Sach", new { id = id }));
}
}
var sach = context.Saches.SingleOrDefault(m => m.IDSach == id);
if (sach == null)
{
return(NotFound());
}
var nhanVien = (from cn in context.ChiNhanhs
join nv in context.NhanViens
on cn.IDChiNhanh equals nv.IDChiNhanh
where nv.LoaiNhanVien == 0 && cn.IDChiNhanh == idchinhanh
select new MuonSach
{
IDNhanVien = nv.IDNhanVien,
TenChiNhanh = cn.TenChiNhanh
}).SingleOrDefault();
var muonSach = new MuonSach()
{
IDSach = id,
IDDocGia = (int)HttpContext.Session.GetInt32("IDDocGia"),
IDNhanVien = nhanVien.IDNhanVien,
TenChiNhanh = nhanVien.TenChiNhanh,
PhiMuon = sach.TienMuon,
TienCoc = sach.TienMua,
NgayMuon = DateTime.Now,
TrangThai = 0,
TinhTrangSach = ""
};
context.MuonSaches.Add(muonSach);
context.SaveChanges();
SachChiNhanh sachChiNhanh = (from scn in context.SachChiNhanhs
where scn.IDChiNhanh == idchinhanh && scn.IDSach == id
select new SachChiNhanh
{
IDSachChiNhanh = scn.IDSachChiNhanh,
IDSach = scn.IDSach,
IDChiNhanh = scn.IDChiNhanh,
TongSoLuong = scn.TongSoLuong,
SoSachCon = scn.SoSachCon
}).SingleOrDefault();
if (sachChiNhanh.SoSachCon != 0 && sachChiNhanh != null)
{
sachChiNhanh.SoSachCon--;
context.SachChiNhanhs.Update(sachChiNhanh);
context.SaveChanges();
}
return(RedirectToAction("Index", "Home"));
}
