public async Task <ActionResult> Edit(List <string> DSTacGia, [Bind(Include = "MaSach,MaISBN,TenSach,MaLoai,MaLinhVuc,MaNXB,NamXuatBan")] SachGiaoTrinh sachGiaoTrinh)
{
if (ModelState.IsValid)
{
if (DSTacGia != null)
{
db.DSTacGias.Where(p => p.MaSach == sachGiaoTrinh.MaSach && p.LaChuBien == false).ForEach(z => db.DSTacGias.Remove(z));
foreach (var mankh in DSTacGia)
{
DSTacGia tacGia = new DSTacGia
{
LaChuBien = false,
MaSach = sachGiaoTrinh.MaSach,
MaNKH = Int32.Parse(mankh)
};
sachGiaoTrinh.DSTacGias.Add(tacGia);
}
}
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
var lstAllNKH = db.NhaKhoaHocs.Where(p => p.MaNKH != 1).Select(p => new
{
p.MaNKH,
TenNKH = p.HoNKH + " " + p.TenNKH
}).ToList();
var tacgiaphu = db.NhaKhoaHocs.Where(p => p.DSTacGias.Any(d => d.MaSach == sachGiaoTrinh.MaSach && d.LaChuBien == false)).Select(p => p.MaNKH).ToList();
ViewBag.MaLinhVuc = new SelectList(db.LinhVucs, "MaLinhVuc", "TenLinhVuc", sachGiaoTrinh.MaLinhVuc);
ViewBag.MaNXB = new SelectList(db.NhaXuatBans, "MaNXB", "TenNXB", sachGiaoTrinh.MaNXB);
ViewBag.MaLoai = new SelectList(db.PhanLoaiSaches, "MaLoai", "TenLoai", sachGiaoTrinh.MaLoai);
ViewBag.DSTacGia = new MultiSelectList(lstAllNKH, "MaNKH", "TenNKH", tacgiaphu);
return(View(sachGiaoTrinh));
}
public async Task <ActionResult> Create([Bind(Include = "MaSach,MaISBN,TenSach,MaLoai,MaLinhVuc,MaNXB,NamXuatBan")] SachGiaoTrinh sachGiaoTrinh, int MaChuBien)
{
if (ModelState.IsValid)
{
db.SachGiaoTrinhs.Add(sachGiaoTrinh);
await db.SaveChangesAsync();
DSTacGia dstacgia = new DSTacGia
{
MaNKH = MaChuBien,
MaSach = sachGiaoTrinh.MaSach,
LaChuBien = true
};
db.DSTacGias.Add(dstacgia);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
ViewBag.MaLinhVuc = new SelectList(db.LinhVucs, "MaLinhVuc", "TenLinhVuc", sachGiaoTrinh.MaLinhVuc);
ViewBag.MaNXB = new SelectList(db.NhaXuatBans, "MaNXB", "TenNXB", sachGiaoTrinh.MaNXB);
ViewBag.MaLoai = new SelectList(db.PhanLoaiSaches, "MaLoai", "TenLoai", sachGiaoTrinh.MaLoai);
return(View(sachGiaoTrinh));
}
public async Task <ActionResult> DeleteConfirmed(int id, int mankh, int?manhakhoahoc)
{
DSTacGia dSTacGia = await db.DSTacGias.Where(p => p.MaSach == id && p.MaNKH == mankh).FirstOrDefaultAsync();
db.DSTacGias.Remove(dSTacGia);
await db.SaveChangesAsync();
return(RedirectToAction("Edit", new { id = id, manhakhoahoc = manhakhoahoc }));
}
public async Task <ActionResult> EditDanhSachTacGia([Bind(Include = "MaSach,MaNKH,LaChuBien")] DSTacGia dSTacGia)
{
if (ModelState.IsValid)
{
db.DSTacGias.AddOrUpdate(dSTacGia);
await db.SaveChangesAsync();
return(RedirectToAction("DanhSachTacGia"));
}
ViewBag.tensach = db.SachGiaoTrinhs.Find(dSTacGia.MaSach).TenSach;
return(View(dSTacGia));
}
// GET: AdminDSTacGia/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DSTacGia dSTacGia = await db.DSTacGias.FindAsync(id);
if (dSTacGia == null)
{
return(HttpNotFound());
}
return(View(dSTacGia));
}
/*edit danh sach tac gia*/
public async Task <ActionResult> EditDanhSachTacGia(int?id, int?manhakhoahoc)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DSTacGia dSTacGia = await db.DSTacGias.Where(p => p.MaSach == id && p.MaNKH == manhakhoahoc).FirstOrDefaultAsync();
if (dSTacGia == null)
{
return(HttpNotFound());
}
ViewBag.tensach = db.SachGiaoTrinhs.Find(id).TenSach;
return(View(dSTacGia));
}
// GET: AdminDSTacGia/Delete/5
public async Task <ActionResult> Delete(int?id, int?mankh, int?manhakhoahoc)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DSTacGia dSTacGia = await db.DSTacGias.Where(p => p.MaSach == id && p.MaNKH == mankh).FirstOrDefaultAsync();
if (dSTacGia == null)
{
return(HttpNotFound());
}
ViewBag.manhakhoahoc = manhakhoahoc;
ViewBag.masach = id;
ViewBag.mankh = mankh;
return(View(dSTacGia));
}
/* delete danh sach tac gia*/
public async Task <ActionResult> DeleteDanhSachTacGia(int?id, int?manhakhoahoc)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DSTacGia dSTacGia = await db.DSTacGias.Where(p => p.MaSach == id && p.MaNKH == manhakhoahoc).FirstOrDefaultAsync();
if (dSTacGia == null)
{
return(HttpNotFound());
}
db.DSTacGias.Remove(dSTacGia);
await db.SaveChangesAsync();
return(RedirectToAction("DanhSachTacGia"));
}
public async Task <ActionResult> EditDanhSachTacGia([Bind(Include = "MaSach,MaNKH,LaChuBien")] DSTacGia dSTacGia)
{
if (ModelState.IsValid)
{
DSTacGia tacGia = db.DSTacGias.Where(p => p.MaSach == dSTacGia.MaSach && p.MaNKH == dSTacGia.MaNKH).FirstOrDefault();
if (tacGia != null)
{
tacGia.LaChuBien = dSTacGia.LaChuBien;
}
else
{
db.DSTacGias.Add(dSTacGia);
}
await db.SaveChangesAsync();
return(RedirectToAction("DanhSachTacGia"));
}
ViewBag.tensach = db.SachGiaoTrinhs.Find(dSTacGia.MaSach).TenSach;
return(View(dSTacGia));
}
public async Task <ActionResult> CreateDanhSachTacGia([Bind(Include = "MaSach,MaNKH,LaChuBien")] DSTacGia dSTacGia)
{
if (ModelState.IsValid)
{
db.DSTacGias.Add(dSTacGia);
await db.SaveChangesAsync();
return(RedirectToAction("DanhSachTacGia"));
}
var dsnguoidathamgia = db.DSTacGias.Where(p => p.MaSach == dSTacGia.MaSach).Select(p => p.MaNKH).ToList();
var lstAllNKH = db.NhaKhoaHocs.Where(p => !dsnguoidathamgia.Contains(p.MaNKH)).Select(p => new
{
p.MaNKH,
TenNKH = p.HoNKH + " " + p.TenNKH
}).ToList();
ViewBag.MaNKH = new SelectList(lstAllNKH, "MaNKH", "TenNKH");
ViewBag.masach = dSTacGia.MaSach;
ViewBag.TenSach = db.SachGiaoTrinhs.Find(dSTacGia.MaSach).TenSach;
return(View(dSTacGia));
}
