public ActionResult UploadFileTaiLieu(int id, HttpPostedFileBase fileTaiLieu) { using (var kHKTKhoaHocKiThuatRepository = new KHKTKhoaHocKiThuatService()) { try { if (fileTaiLieu.ContentLength > 0) { //string filename = Path.GetFileName(fileTaiLieu.FileName); KhoaHocKiThuat khoaHocKiThuat = kHKTKhoaHocKiThuatRepository.GetKhoaHocKiThuatById(id); if (khoaHocKiThuat == null) { return(Json("failed")); } string filename = String.Format("{0:00}", khoaHocKiThuat.LinhVucId) + '-' + khoaHocKiThuat.Id.ToString() + Path.GetExtension(fileTaiLieu.FileName); string _path = Path.Combine(Server.MapPath("~/UploadedFiles/KhoaHocKiThuat"), filename); fileTaiLieu.SaveAs(_path); kHKTKhoaHocKiThuatRepository.UpdateFileTaiLieuKhoaHocKiThuat(id, filename.Trim()); return(Json(new ReturnFormat(200, "success", null), JsonRequestBehavior.AllowGet)); } else { kHKTKhoaHocKiThuatRepository.DeleteKHKTById(id); return(Json("failed")); } } catch { kHKTKhoaHocKiThuatRepository.DeleteKHKTById(id); return(Json("failed")); } } }
public ActionResult DownloadZipFile(int detaiId) { Account account = (Account)Session[Utils.Constant.MANAGER_SESSION]; if (account == null) { return(RedirectToRoute("login")); } using (var kHHTLinhVucRepository = new KHHTLinhVucService()) { using (var kHKTKhoaHocKiThuatRepository = new KHKTKhoaHocKiThuatService()) { KHKTLinhVucThamGia kHKTLinhVucThamGia = kHHTLinhVucRepository.GetHKTLinhVucThamGiaById(detaiId); List <KhoaHocKiThuat> khoaHocKiThuats = kHKTKhoaHocKiThuatRepository.GetKhoaHocKiThuatByDeTaiId(detaiId); using (var memoryStream = new MemoryStream()) { using (var ziparchive = new ZipArchive(memoryStream, ZipArchiveMode.Create, true)) { for (int i = 0; i < khoaHocKiThuats.Count; i++) { if (khoaHocKiThuats[i].FileTaiLieu != null) { ziparchive.CreateEntryFromFile(System.Web.HttpContext.Current.Server.MapPath("~/UploadedFiles/KhoaHocKiThuat/" + khoaHocKiThuats[i].FileTaiLieu), khoaHocKiThuats[i].FileTaiLieu); } } } return(File(memoryStream.ToArray(), "application/zip", kHKTLinhVucThamGia.Name.Trim() + ".zip")); } } } }
public ActionResult DsKhoaHocKiThuat() { var manager = (Account)Session[Constant.MANAGER_SESSION]; if (manager == null) { return(RedirectToRoute("quanlylogin")); } var managerPersmission = (List <UserPermission>)Session[Constant.MANAGER_PERMISSION_SESSION]; //var permission = 9; if (managerPersmission.Where(s => s.PermissionId == 9).FirstOrDefault() == null) { return(RedirectToRoute("quanlylogin")); } using (var kHKTKhoaHocKiThuatRepository = new KHKTKhoaHocKiThuatService()) { using (var kHHTLinhVucRepository = new KHHTLinhVucService()) { List <KHKTLinhVucThamGia> linhVucThamGias = kHHTLinhVucRepository.GetKHKTLinhVucThamGias(); List <KhoaHocKiThuatDetailDTO> khoaHocKiThuatDetailDTOs = kHKTKhoaHocKiThuatRepository.GetKhoaHocKiThuats(); ViewBag.KHKT = khoaHocKiThuatDetailDTOs; ViewBag.LinhVucs = linhVucThamGias; return(View()); } } }
public ActionResult DeleteKHKTById(int id) { using (var kHKTKhoaHocKiThuatRepository = new KHKTKhoaHocKiThuatService()) { bool deleted = kHKTKhoaHocKiThuatRepository.DeleteKHKTById(id); if (deleted == true) { return(Json(new ReturnFormat(200, "success", null), JsonRequestBehavior.AllowGet)); } return(Json(new ReturnFormat(400, "failed", null), JsonRequestBehavior.AllowGet)); } }
public ActionResult Index() { var school = (T_DM_Truong)Session[Constant.SCHOOL_SESSION]; if (school == null) { return(RedirectToRoute("login")); } using (var kHKTKhoaHocKiThuatRepository = new KHKTKhoaHocKiThuatService()) { List <KhoaHocKiThuatDetailDTO> hocKiThuatDetailDTOs = kHKTKhoaHocKiThuatRepository.GetKhoaHocKiThuatsBySchoolId(school.SchoolID); ViewBag.DSKHKT = hocKiThuatDetailDTOs; } return(View()); }
public ActionResult DangKiKHKT(KhoaHocKithuatDTO khoaHocKithuatDTO) { var school = (T_DM_Truong)Session[Constant.SCHOOL_SESSION]; if (school == null) { return(RedirectToRoute("login")); } khoaHocKithuatDTO.SchoolId = school.SchoolID; using (var kHKTKhoaHocKiThuatRepository = new KHKTKhoaHocKiThuatService()) { KhoaHocKiThuat khoaHocKiThuat = kHKTKhoaHocKiThuatRepository.CreateKhoaHocKiThuat(khoaHocKithuatDTO); if (khoaHocKiThuat == null) { return(Json(new ReturnFormat(400, "failed", null), JsonRequestBehavior.AllowGet)); } return(Json(new ReturnFormat(200, "success", khoaHocKiThuat.Id), JsonRequestBehavior.AllowGet)); } }
public async Task <ActionResult> DownloadFileByTruong() { var school = (T_DM_Truong)Session[Constant.SCHOOL_SESSION]; if (school == null) { return(RedirectToRoute("login")); } using (var kHKTKhoaHocKiThuatRepository = new KHKTKhoaHocKiThuatService()) { List <KhoaHocKiThuatDetailDTO> khoaHocKiThuatDetailDTOs = kHKTKhoaHocKiThuatRepository.GetKhoaHocKiThuatsBySchoolId(school.SchoolID); ViewBag.KHKT = khoaHocKiThuatDetailDTOs; string fileName = string.Concat("ds-khoahockythuat.xlsx"); string filePath = System.Web.HttpContext.Current.Server.MapPath("~/Utils/Files/" + fileName); await Utils.ExportExcel.GenerateXLSKhoaHocKiThuat(khoaHocKiThuatDetailDTOs, filePath); return(File(filePath, "application/vnd.ms-excel", fileName)); } }
public async Task <ActionResult> TaoDsKhoaHocKithuat() { Account account = (Account)Session[Utils.Constant.MANAGER_SESSION]; if (account == null) { return(RedirectToRoute("login")); } using (var kHKTKhoaHocKiThuatRepository = new KHKTKhoaHocKiThuatService()) { List <KhoaHocKiThuatDetailDTO> khoaHocKiThuatDetailDTOs = kHKTKhoaHocKiThuatRepository.GetKhoaHocKiThuats(); ViewBag.KHKT = khoaHocKiThuatDetailDTOs; string fileName = string.Concat("ds-khoahockythuat.xlsx"); string filePath = System.Web.HttpContext.Current.Server.MapPath("~/Utils/Files/" + fileName); await Utils.ExportExcel.GenerateXLSKhoaHocKiThuat(khoaHocKiThuatDetailDTOs, filePath); return(File(filePath, "application/vnd.ms-excel", fileName)); } }
public ActionResult TaiFileTaiLieuKHKT(int id) { Account account = (Account)Session[Utils.Constant.MANAGER_SESSION]; if (account == null) { return(RedirectToRoute("login")); } using (var kHKTKhoaHocKiThuatRepository = new KHKTKhoaHocKiThuatService()) { KhoaHocKiThuat khoaHocKiThuat = kHKTKhoaHocKiThuatRepository.GetKhoaHocKiThuatById(id); string filePath = System.Web.HttpContext.Current.Server.MapPath("~/UploadedFiles/KhoaHocKiThuat/" + khoaHocKiThuat.FileTaiLieu.Trim()); if (khoaHocKiThuat.FileTaiLieu.Contains(".docx")) { return(File(filePath, "application/vnd.openxmlformats-officedocument.wordprocessingml.document", khoaHocKiThuat.FileTaiLieu)); } else if (khoaHocKiThuat.FileTaiLieu.Contains(".xlsx")) { return(File(filePath, "application/vnd.ms-excel", khoaHocKiThuat.FileTaiLieu)); } return(File(filePath, "application/msword", khoaHocKiThuat.FileTaiLieu)); } }