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));
}
}
