public async Task <ActionResult <BaseResponse> > PutLopSinhVien(int id, LopSinhVien lopSinhVien) { var lopSinhVienSua = await _context.LopSinhViens.FindAsync(id); if (lopSinhVienSua == null) { return(new BaseResponse { ErrorCode = 1, Message = "Không tìm thấy" }); } lopSinhVienSua.MaLop = lopSinhVien.MaLop; lopSinhVienSua.NganhHoc = lopSinhVien.NganhHoc; lopSinhVienSua.Khoa = lopSinhVien.Khoa; _context.LopSinhViens.Update(lopSinhVienSua); await _context.SaveChangesAsync(); return(new BaseResponse { Message = "Cập nhật thành công", Data = lopSinhVien }); }
public async Task <ActionResult <BaseResponse> > PostLopSinhVien(LopSinhVien lopSinhVien) { try { _context.LopSinhViens.Add(lopSinhVien); await _context.SaveChangesAsync(); return(new BaseResponse { Message = "Thêm mới thành công", Data = lopSinhVien }); } catch { return(new BaseResponse { ErrorCode = 1, Message = "Thêm mới thất bại" }); } }
public async Task <ActionResult <BaseResponse> > ImportFile([FromForm] ImportFileRequest request) { LichThi lichThi; LopHocPhan lopHocPhan; LopSinhVien lopSinhVien; HocPhan hocPhan; using (var file = new OfficeOpenXml.ExcelPackage()) { using (var stream = request.File.OpenReadStream()) { file.Load(stream); } var worksheet = file.Workbook.Worksheets.First(); for (int i = 1; i < worksheet.Dimension.End.Row; i++) { var rowCells = worksheet.Cells[i, 1, i, worksheet.Dimension.End.Column]; var maLopSV = rowCells[i, 10].Value.ToString(); var khoa = rowCells[i, 9].Value.ToString();; lopSinhVien = LopSinhVienExists(maLopSV, khoa); if (lopSinhVien == null) { lopSinhVien = new LopSinhVien(); lopSinhVien.MaLop = maLopSV; lopSinhVien.NganhHoc = rowCells[i, 6].Value.ToString(); lopSinhVien.Khoa = khoa; await lopSVsCtrl.PostLopSinhVien(lopSinhVien); } var maHP = rowCells[i, 1].Value.ToString(); hocPhan = HocPhanExists(maHP); if (hocPhan == null) { hocPhan = new HocPhan(); hocPhan.MaHP = maHP; hocPhan.TenHP = rowCells[i, 3].Value.ToString(); hocPhan.SoTinChi = Int16.Parse(rowCells[i, 4].Value.ToString()); await hocPhansCtrl.PostHocPhan(hocPhan); } var maLopHP = rowCells[i, 2].Value.ToString(); lopHocPhan = LopHocPhanExists(maLopHP); if (lopHocPhan == null) { lopHocPhan = new LopHocPhan(); lopHocPhan.HocPhanId = hocPhan.Id; lopHocPhan.LopSVId = lopSinhVien.Id; lopHocPhan.MaLopHP = maLopHP; lopHocPhan.CSThi = rowCells[i, 16].Value.ToString(); var dateStr = rowCells[i, 15].Value.ToString().Substring(0, 10) + " " + rowCells[i, 13].Value.ToString().Replace("g", ":") + ":00"; lopHocPhan.NgayGioBDThi = DateTime.Parse(dateStr); lopHocPhan.Thu = rowCells[i, 14].Value.ToString(); lopHocPhan.ThoiKB = rowCells[i, 8].Value.ToString(); lopHocPhan.HeDaoTao = rowCells[i, 7].Value.ToString(); lopHocPhan.BacDaoTao = rowCells[i, 5].Value.ToString(); await lopHocPhansCtrl.PostLopHocPhan(lopHocPhan); } var phongThi = rowCells[i, 17].Value.ToString(); if (LichThiExists(maLopHP, phongThi) == null) { lichThi = new LichThi(); lichThi.LopHPId = lopHocPhan.Id; lichThi.PhongThi = rowCells[i, 17].Value.ToString(); lichThi.SoSV = Int16.Parse(rowCells[i, 12].Value.ToString()); await PostLichThi(lichThi); } } return(new BaseResponse { Message = "Import thành công" }); } }