public void DeleteImport(ImportFileRequest request)
{
try
{
uow.CreateUnitOfWork();
uow.ReportRepository.DeleteImportRequest(request);
uow.Commit();
}
catch (Exception e)
{
throw;
}
}
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"
});
}
}
public void DeleteImportRequest(ImportFileRequest request)
{
Delete(DatabaseConnection.connection, SQLStoredProcedures.deleteImportFile, request, _connection, _transaction);
}
public void RollbackImportRequest(ImportFileRequest request)
{
Update(DatabaseConnection.connection, SQLStoredProcedures.rollbackImportFile, request, _connection, _transaction);
}
