public async Task <ActionResult> DeleteConfirmed(int id, int?mankh, int?manhakhoahoc)
{
DSNguoiThamGiaDeTai dSNguoiThamGiaDeTai = await db.DSNguoiThamGiaDeTais.Where(p => p.MaDeTai == id && p.MaNKH == mankh).FirstOrDefaultAsync();
db.DSNguoiThamGiaDeTais.Remove(dSNguoiThamGiaDeTai);
await db.SaveChangesAsync();
return(RedirectToAction("Edit", new { id = id, manhakhoahoc = manhakhoahoc }));
}
public async Task <ActionResult> EditDanhSachNguoiThamGiaDeTai([Bind(Include = "MaDeTai,MaNKH,LaChuNhiem")] DSNguoiThamGiaDeTai dSNguoiThamGiaDeTai)
{
if (ModelState.IsValid)
{
db.DSNguoiThamGiaDeTais.AddOrUpdate(dSNguoiThamGiaDeTai);
await db.SaveChangesAsync();
return(RedirectToAction("DanhSachNguoiThamGiaDeTai"));
}
ViewBag.TenDeTai = db.DeTais.Find(dSNguoiThamGiaDeTai.MaDeTai).TenDeTai;
return(View(dSNguoiThamGiaDeTai));
}
// GET: AdminDSNguoiThamGiaDeTai/Details/5
public async Task <ActionResult> Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DSNguoiThamGiaDeTai dSNguoiThamGiaDeTai = await db.DSNguoiThamGiaDeTais.FindAsync(id);
if (dSNguoiThamGiaDeTai == null)
{
return(HttpNotFound());
}
return(View(dSNguoiThamGiaDeTai));
}
/*Edit danh sach nguoi tham gia*/
public async Task <ActionResult> EditDanhSachNguoiThamGiaDeTai(int?id, int?manhakhoahoc)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DSNguoiThamGiaDeTai dSNguoiThamGiaDeTai = await db.DSNguoiThamGiaDeTais.Where(p => p.MaDeTai == id && p.MaNKH == manhakhoahoc).FirstOrDefaultAsync();
if (dSNguoiThamGiaDeTai == null)
{
return(HttpNotFound());
}
ViewBag.TenDeTai = db.DeTais.Find(id).TenDeTai;
return(View(dSNguoiThamGiaDeTai));
}
/*Delete danh sach tham gia*/
public async Task <ActionResult> DeleteDanhSachNguoiThamGiaDeTai(int?id, int?manhakhoahoc)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DSNguoiThamGiaDeTai dSNguoiThamGiaDeTai = await db.DSNguoiThamGiaDeTais.Where(p => p.MaDeTai == id && p.MaNKH == manhakhoahoc).FirstOrDefaultAsync();
if (dSNguoiThamGiaDeTai == null)
{
return(HttpNotFound());
}
db.DSNguoiThamGiaDeTais.Remove(dSNguoiThamGiaDeTai);
await db.SaveChangesAsync();
return(RedirectToAction("DanhSachNguoiThamGiaDeTai"));
}
// GET: AdminDSNguoiThamGiaDeTai/Delete/5
public async Task <ActionResult> Delete(int?id, int?mankh, int?manhakhoahoc)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
DSNguoiThamGiaDeTai dSNguoiThamGiaDeTai = await db.DSNguoiThamGiaDeTais.Where(p => p.MaDeTai == id && p.MaNKH == mankh).FirstOrDefaultAsync();
if (dSNguoiThamGiaDeTai == null)
{
return(HttpNotFound());
}
ViewBag.madetai = id;
ViewBag.mankh = mankh;
ViewBag.manhakhoahoc = manhakhoahoc;
return(View(dSNguoiThamGiaDeTai));
}
public async Task <ActionResult> CreateDanhSachNguoiThamGiaDeTai([Bind(Include = "MaDeTai,MaNKH,LaChuNhiem")] DSNguoiThamGiaDeTai dSNguoiThamGiaDeTai)
{
if (ModelState.IsValid)
{
db.DSNguoiThamGiaDeTais.Add(dSNguoiThamGiaDeTai);
await db.SaveChangesAsync();
return(RedirectToAction("DanhSachNguoiThamGiaDetai"));
}
var dsnguoidathamgia = db.DSNguoiThamGiaDeTais.Where(p => p.MaDeTai == dSNguoiThamGiaDeTai.MaDeTai).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.TenDeTai = db.DeTais.Find(dSNguoiThamGiaDeTai.MaDeTai).TenDeTai;
ViewBag.MaDeTai = dSNguoiThamGiaDeTai.MaDeTai;
return(View());
}
public async Task <ActionResult> EditDanhSachNguoiThamGiaDeTai([Bind(Include = "MaDeTai,MaNKH,LaChuNhiem")] DSNguoiThamGiaDeTai dSNguoiThamGiaDeTai)
{
if (ModelState.IsValid)
{
DSNguoiThamGiaDeTai tacGia = db.DSNguoiThamGiaDeTais.Where(p => p.MaDeTai == dSNguoiThamGiaDeTai.MaDeTai && p.MaNKH == dSNguoiThamGiaDeTai.MaNKH).FirstOrDefault();
if (tacGia != null)
{
tacGia.LaChuNhiem = dSNguoiThamGiaDeTai.LaChuNhiem;
}
else
{
db.DSNguoiThamGiaDeTais.Add(dSNguoiThamGiaDeTai);
}
await db.SaveChangesAsync();
return(RedirectToAction("DanhSachNguoiThamGiaDeTai"));
}
ViewBag.TenDeTai = db.DeTais.Find(dSNguoiThamGiaDeTai.MaDeTai).TenDeTai;
return(View(dSNguoiThamGiaDeTai));
}
public async Task <ActionResult> Edit(List <string> DSNguoiThamGiaDT, [Bind(Include = "MaDeTai,MaDeTaiHoSo,TenDeTai,MaLoaiDeTai,MaCapDeTai,MaDVChuTri,MaDonViQLThucHien,MaLinhVuc,MucTieuDeTai,NoiDungDeTai,KetQuaDeTai,NamBD,NamKT,KinhPhi,MaXepLoai,MaTinhTrang,MaPhanLoaiSP,LienKetWeb")] DeTai deTai, HttpPostedFileBase linkUpload, string KinhPhiXoa, string KinhPhiMoi)
{
var detai = db.DeTais.Where(p => p.MaDeTai == deTai.MaDeTai).Include(p => p.KinhPhiDeTais).Include(p => p.DSNguoiThamGiaDeTais).FirstOrDefault();
if (ModelState.IsValid)
{
if (linkUpload != null && linkUpload.ContentLength > 0)
{
string filename = Path.GetFileNameWithoutExtension(linkUpload.FileName) + "_" + deTai.MaDeTai.ToString() + Path.GetExtension(linkUpload.FileName);
string path = Path.Combine(Server.MapPath("~/App_Data/uploads/detai_file"), filename);
if (!String.IsNullOrEmpty(detai.LinkFileUpload))
{
string oldpath = Path.Combine(Server.MapPath("~/App_Data/uploads/detai_file"), detai.LinkFileUpload);
if (System.IO.File.Exists(oldpath))
{
System.IO.File.Delete(oldpath);
}
}
linkUpload.SaveAs(path);
deTai.LinkFileUpload = filename;
}
else
{
deTai.LinkFileUpload = detai.LinkFileUpload;
}
db.DeTais.AddOrUpdate(deTai);
db.DSNguoiThamGiaDeTais.Where(p => p.MaDeTai == deTai.MaDeTai && p.LaChuNhiem == false).ForEach(x => db.DSNguoiThamGiaDeTais.Remove(x));
if (KinhPhiXoa != "")
{
List <int> kinhphixoa = JsonConvert.DeserializeObject <List <int> >(KinhPhiXoa);
db.KinhPhiDeTais.Where(p => kinhphixoa.Contains(p.MaPhi)).ForEach(p => db.KinhPhiDeTais.Remove(p));
}
db.SaveChanges();
/* phần xử lý thêm xóa sửa của kinh phí đề tài */
if (KinhPhiMoi != "")
{
if (KinhPhiMoi != "")
{
List <string[]> kinhphimoi = JsonConvert.DeserializeObject <List <string[]> >(KinhPhiMoi);
foreach (var x in kinhphimoi)
{
KinhPhiDeTai kinhphi_x = new KinhPhiDeTai
{
MaDeTai = Int32.Parse(x[0]),
LoaiKinhPhi = x[1],
NamTiepNhan = DateTime.Parse(x[2]),
SoTien = Int32.Parse(x[3]),
LoaiTien = x[4]
};
db.KinhPhiDeTais.Add(kinhphi_x);
}
}
}
if (DSNguoiThamGiaDT != null)
{
foreach (var mankh in DSNguoiThamGiaDT)
{
DSNguoiThamGiaDeTai nguoiTGDT = new DSNguoiThamGiaDeTai
{
LaChuNhiem = false,
MaDeTai = deTai.MaDeTai,
MaNKH = Int32.Parse(mankh)
};
db.DSNguoiThamGiaDeTais.AddOrUpdate(nguoiTGDT);
}
}
await db.SaveChangesAsync();
return(RedirectToAction("Index"));
}
else
{
ViewBag.MaCapDeTai = new SelectList(db.CapDeTais, "MaCapDeTai", "TenCapDeTai", deTai.MaCapDeTai);
ViewBag.MaLoaiDeTai = new SelectList(db.LoaiHinhDeTais, "MaLoaiDT", "TenLoaiDT", deTai.MaLoaiDeTai);
ViewBag.MaDVChuTri = new SelectList(db.DonViChuTris, "MaDVChuTri", "TenDVChuTri", deTai.MaDVChuTri);
ViewBag.MaDonViQLThucHien = new SelectList(db.DonViQLs, "MaDonVi", "TenDonVI", deTai.MaDonViQLThucHien);
ViewBag.MaLinhVuc = new SelectList(db.LinhVucs, "MaLinhVuc", "TenLinhVuc", deTai.MaLinhVuc);
ViewBag.MaXepLoai = new SelectList(db.XepLoais, "MaXepLoai", "TenXepLoai", deTai.MaXepLoai);
ViewBag.MaTinhTrang =
new SelectList(db.TinhTrangDeTais, "MaTinhTrang", "TenTinhTrang", deTai.MaTinhTrang);
ViewBag.MaPhanLoaiSP = new SelectList(db.PhanLoaiSPs, "MaPhanLoai", "TenPhanLoai", deTai.MaPhanLoaiSP);
return(View(deTai));
}
}