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));
}
// GET: SachGiaoTrinhs/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SachGiaoTrinh sachGiaoTrinh = await db.SachGiaoTrinhs.FindAsync(id);
if (sachGiaoTrinh == null)
{
return(HttpNotFound());
}
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 void AddRecordFromCSV(string fileName)
{
using (StreamReader sr = new StreamReader(fileName))
{
try
{
string line;
while ((line = sr.ReadLine()) != null)
{
string[] resultArray;
SachGiaoTrinh sachgiaotrinh = new SachGiaoTrinh();
Regex r = new Regex(",(?=(?:[^\"]*\"[^\"]*\")*(?![^\"]*\"))");
resultArray = r.Split(line);
string maibsn = resultArray[0];
SachGiaoTrinh checksach = db.SachGiaoTrinhs.Where(p => p.MaISBN == maibsn).FirstOrDefault();
if (checksach == null)
{
//maisbn,tensach,mota
sachgiaotrinh.MaISBN = resultArray[0];
sachgiaotrinh.TenSach = resultArray[1];
sachgiaotrinh.Mota = resultArray[2];
db.SachGiaoTrinhs.Add(sachgiaotrinh);
db.SaveChanges();
}
}
}
catch (Exception exception)
{
throw exception;
}
}
}
public async Task <ActionResult> DeleteConfirmed(int id)
{
SachGiaoTrinh sachGiaoTrinh = await db.SachGiaoTrinhs.FindAsync(id);
db.SachGiaoTrinhs.Remove(sachGiaoTrinh);
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
// GET: SachGiaoTrinhs/sachgiaotrinhls/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SachGiaoTrinh sachGiaoTrinh = await db.SachGiaoTrinhs.FindAsync(id);
if (sachGiaoTrinh == null)
{
return(HttpNotFound());
}
return(View(sachGiaoTrinh));
}
public async Task <ActionResult> Edit([Bind(Include = "MaSach,MaISBN,TenSach,MaLoai,MaLinhVuc,MaNXB,NamXuatBan")] SachGiaoTrinh sachGiaoTrinh)
{
if (ModelState.IsValid)
{
db.Entry(sachGiaoTrinh).State = EntityState.Modified;
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));
}
// GET: AdminSachGiaoTrinhs/Edit/5
public async Task <ActionResult> Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SachGiaoTrinh sachGiaoTrinh = await db.SachGiaoTrinhs.FindAsync(id);
if (sachGiaoTrinh == null)
{
return(HttpNotFound());
}
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)
{
SachGiaoTrinh sachGiaoTrinh = await db.SachGiaoTrinhs.FindAsync(id);
db.SachGiaoTrinhs.Remove(sachGiaoTrinh);
List <DSTacGia> dsTacGia = await db.DSTacGias.Where(p => p.MaSach == id).ToListAsync();
foreach (var tacgia in dsTacGia)
{
db.DSTacGias.Remove(tacgia);
}
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
public async Task <ActionResult> GetAllImage(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
SachGiaoTrinh sachGiaoTrinh = await db.SachGiaoTrinhs.FindAsync(id);
if (sachGiaoTrinh == null)
{
return(HttpNotFound());
}
List <ImageViewModel> lstImage = new List <ImageViewModel>
{
new ImageViewModel(sachGiaoTrinh.AnhBia1),
new ImageViewModel(sachGiaoTrinh.AnhBia4),
new ImageViewModel(sachGiaoTrinh.AnhBiaISBN)
};
return(View(lstImage));
}
