349 lines
16 KiB
C#
349 lines
16 KiB
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.IO;
|
|
using System.Linq;
|
|
using System.Net;
|
|
using System.Web;
|
|
using System.Web.Mvc;
|
|
using Kreta.BusinessLogic.HelperClasses;
|
|
using Kreta.BusinessLogic.HelperClasses.ImportCo;
|
|
using Kreta.BusinessLogic.Helpers.ImportExport;
|
|
using Kreta.BusinessLogic.Security;
|
|
using Kreta.Enums.ManualEnums;
|
|
using Kreta.Enums.ManualEnums.ImportExport;
|
|
using Kreta.Resources;
|
|
using Kreta.Web.Areas.ImportExport.Models.CommonModels;
|
|
using Kreta.Web.Areas.ImportExport.Models.OratervImportExport;
|
|
using Kreta.Web.Classes;
|
|
using Kreta.Web.Helpers;
|
|
using Kreta.Web.Models.EditorTemplates;
|
|
using Kreta.Web.Security;
|
|
|
|
namespace Kreta.Web.Areas.ImportExport.Controllers
|
|
{
|
|
[MvcRoleClaimsAuthorize(true)]
|
|
[MvcRolePackageDenyAuthorize(KretaClaimPackages.IsSzirIntezmeny.ClaimValue)]
|
|
[MvcRolePackageAuthorize(TanevEnum.AktEsKovTanev, KretaClaimPackages.Adminisztrator.ClaimValue)]
|
|
public class OratervImportExportController : BaseTantargyfelosztasImportExportController
|
|
{
|
|
#region Fields
|
|
|
|
private const string TovabbUrl = @"/Tantargy/OraTerv";
|
|
|
|
#endregion Fields
|
|
|
|
#region Properties
|
|
|
|
public static string GridName => "OratervTantargyGrid";
|
|
public static string GridRowTemplateName => "OratervTantargyGridRowTemplate";
|
|
|
|
public static string OratervGridName => "OratervGrid";
|
|
public static string OratervGridRowTemplateName => "OratervGridRowTemplate";
|
|
|
|
public static string JavascriptHelperClassName => "OratervImportExportHelper";
|
|
|
|
public static string ConrtollerName => "OratervImportExport";
|
|
|
|
#endregion
|
|
|
|
#region Constructors
|
|
|
|
public OratervImportExportController(IUploadFileValidator uploadFileValidator)
|
|
{
|
|
UploadFileValidator = uploadFileValidator ?? throw new ArgumentNullException(nameof(uploadFileValidator));
|
|
}
|
|
|
|
#endregion Constructors
|
|
|
|
public ActionResult Index()
|
|
{
|
|
var model = new OratervImportExportModel
|
|
{
|
|
MaxAllowedFileSizeInBytes = UploadFileValidator.Configuration.ImportMaxAllowedFileSizeInBytes,
|
|
AllowedFileExtensions = UploadFileValidator.Configuration.ImportAllowedFileExtensions,
|
|
};
|
|
return View(model);
|
|
}
|
|
|
|
#region Sablon
|
|
|
|
public ActionResult DownloadTemplate()
|
|
{
|
|
MemoryStream memoryStream = new OratervImportExportHelper(ConnectionTypeExtensions.GetSessionConnectionType()).GetTemplate();
|
|
return new FileStreamResult(memoryStream, Core.Constants.ContentTypes.Xlsx) { FileDownloadName = ImportExportOratervResource.ImportSablonFileName };
|
|
}
|
|
|
|
#endregion Sablon
|
|
|
|
#region Export
|
|
|
|
[HttpPost]
|
|
[MvcValidateAjaxAntiForgeryToken]
|
|
public string Export()
|
|
{
|
|
MemoryStream memoryStream = new OratervImportExportHelper(ConnectionTypeExtensions.GetSessionConnectionType()).GetExport();
|
|
return GetExportFileString(memoryStream);
|
|
}
|
|
|
|
public string NemImportalhatoSorokExport()
|
|
{
|
|
MemoryStream memoryStream = new OratervImportExportHelper(ConnectionTypeExtensions.GetSessionConnectionType()).GetNemImportalhatoSorokExport();
|
|
return GetExportFileString(memoryStream);
|
|
}
|
|
|
|
#endregion Export
|
|
|
|
#region Import
|
|
|
|
public JsonResult UploadFile(HttpPostedFileBase importFile, int importMuvelet)
|
|
{
|
|
UploadFileValidator.ValidateImportFile(importFile);
|
|
|
|
var errorResult = new List<string>();
|
|
|
|
Dictionary<int, string> importHeaderList = OratervImportExportHelper.ImportHeaderList;
|
|
List<List<string>> importData = ImportExportHelper.GetImportDataFromExcel(importFile.InputStream, importHeaderList, out List<string> fileErrorResultList);
|
|
errorResult.AddRange(fileErrorResultList);
|
|
|
|
if (errorResult.Count > 0)
|
|
{
|
|
JsonResult errorJson = ThrowCustomError(errorResult);
|
|
return errorJson;
|
|
}
|
|
|
|
new OratervImportExportHelper(ConnectionTypeExtensions.GetSessionConnectionType()).SetImportCo(importData, importMuvelet);
|
|
|
|
return Json(null);
|
|
}
|
|
|
|
public ActionResult OpenImportPreviewPopup()
|
|
{
|
|
OratervImportCo importCo = new OratervImportExportHelper(ConnectionTypeExtensions.GetSessionConnectionType()).ImportCo;
|
|
var oratervCoList = importCo.OratervCOList.GroupBy(x => x.OratervId).Select(x => x.First()).ToList();
|
|
var importInfoModel = new OratervImportInfoModel
|
|
{
|
|
ImportInfoSummaryList = new ImportInfoSummaryListModel
|
|
{
|
|
ImportInfoSummaryModelList = new List<ImportInfoSummaryModel>
|
|
{
|
|
GetTantargyImportInfoSummary(importCo.TantargyImportJsonItemList, importCo.TantargyCOList),
|
|
GetOratervImportInfoSummary(importCo, oratervCoList),
|
|
GetOratervTantargyImportInfoSummary(importCo, importCo.OratervTantargyCOList),
|
|
}
|
|
},
|
|
TantargyImportItemList = new TantargyImportItemListModel
|
|
{
|
|
ImportItemModelList = GetTantargyImportItemModelList(importCo.TantargyImportJsonItemList, importCo.TantargyCOList),
|
|
},
|
|
OratervImportItemList = new OratervImportItemListModel
|
|
{
|
|
ImportItemModelList = GetOratervImportItemModelList(importCo.OratervImportJsonItemList, importCo.OratervCOList)
|
|
},
|
|
MainImportItemList = new OratervTantargyImportItemListModel
|
|
{
|
|
ImportItemModelList = GetOratervTantargyImportItemModelList(importCo.OratervTantargyImportJsonItemList, importCo.OratervTantargyCOList, oratervCoList),
|
|
},
|
|
NemImportalhatoItemList = new OratervImportNemImportalhatoItemListModel
|
|
{
|
|
NemImportalhatoItemModelList = GetNemImportalhatoItemModelList(importCo.NemImportalhatoItemList),
|
|
}
|
|
};
|
|
|
|
var popUpModel = new PopUpModel(importInfoModel, ImportPreviewPopupName);
|
|
popUpModel.AddCancelBtn(popUpModel, "KretaWindowHelper.destroyAllWindow");
|
|
popUpModel.AddBtn(popUpModel, "ImportBtnOk", CommonResource.Importalas, $"{JavascriptHelperClassName}.import", "BtnOk", setDisabledAfterClick: true);
|
|
popUpModel.AddBtn(popUpModel, "NemImportalhatoSorokExportBtnOk", ImportExportCommonResource.NemImportalhatoSorokExportalasa, $"{JavascriptHelperClassName}.nemImportalhatoSorokExport", "BtnOk");
|
|
return PartialView(Constants.General.PopupView, popUpModel);
|
|
}
|
|
|
|
private List<OratervImportNemImportalhatoItemModel> GetNemImportalhatoItemModelList(List<OratervImportItemCo> nemImportalhatoItemList)
|
|
{
|
|
var nemImportalhatoItemModelList = new List<OratervImportNemImportalhatoItemModel>();
|
|
foreach (OratervImportItemCo nemImportalhatoItem in nemImportalhatoItemList)
|
|
{
|
|
nemImportalhatoItemModelList.Add(new OratervImportNemImportalhatoItemModel
|
|
{
|
|
TantervNeveImportData = nemImportalhatoItem.TantervNeveImportData,
|
|
OratervNeveImportData = nemImportalhatoItem.OratervNeveImportData,
|
|
EvfolyamNeveImportData = nemImportalhatoItem.EvfolyamNeveImportData,
|
|
TantargyNeveImportData = nemImportalhatoItem.TantargyNeveImportData,
|
|
EvesOraszamImportData = nemImportalhatoItem.EvesOraszamImportData,
|
|
ErrorList = string.Join(Environment.NewLine, nemImportalhatoItem.ErrorList)
|
|
});
|
|
}
|
|
|
|
return nemImportalhatoItemModelList.OrderBy(x => x.TantervNeveImportData).ThenBy(x => x.OratervNeveImportData).ThenBy(x => x.TantargyNeveImportData).ToList();
|
|
}
|
|
|
|
protected static ImportInfoSummaryModel GetOratervImportInfoSummary(OratervImportCo importCo, List<OratervCO> coList)
|
|
{
|
|
List<OratervImportJsonItemCo> importJsonItemList = importCo.OratervImportJsonItemList;
|
|
int updateRowCount = importJsonItemList?.Count(x => x.Operation == (int)ImportItemOperationEnum.Update) ?? 0;
|
|
int unchangedRowCount = 0;
|
|
switch (importCo.ImportMuvelet)
|
|
{
|
|
case (int)ImportMuveletEnum.Insert:
|
|
unchangedRowCount = coList.Count;
|
|
break;
|
|
|
|
case (int)ImportMuveletEnum.InsertAndUpdate:
|
|
unchangedRowCount = coList.Count - updateRowCount;
|
|
break;
|
|
}
|
|
|
|
var importInfoSummary = new ImportInfoSummaryModel
|
|
{
|
|
ImportName = ImportExportOratervResource.Oraterv,
|
|
InsertRowCount = importJsonItemList?.Count(x => x.Operation == (int)ImportItemOperationEnum.Insert).ToString() ?? "0",
|
|
UpdateRowCount = updateRowCount.ToString(),
|
|
DeleteRowCount = "-",
|
|
UnchangedRowCount = unchangedRowCount.ToString(),
|
|
InvalidRowCount = importCo.NemImportalhatoItemList.Count.ToString()
|
|
};
|
|
return importInfoSummary;
|
|
}
|
|
|
|
protected List<OratervImportItemModel> GetOratervImportItemModelList(List<OratervImportJsonItemCo> importJsonItemList, List<OratervCO> oratervItemCoList)
|
|
{
|
|
var importItemModelList = new List<OratervImportItemModel>();
|
|
if (importJsonItemList == null)
|
|
{
|
|
if (oratervItemCoList.Count == 0)
|
|
{
|
|
return importItemModelList;
|
|
}
|
|
|
|
importJsonItemList = new List<OratervImportJsonItemCo>();
|
|
}
|
|
|
|
//NOTE: Hozzáadjuk azokat a az elemeket, amik az excel-ből jöttek!
|
|
foreach (OratervImportJsonItemCo importJsonItem in importJsonItemList)
|
|
{
|
|
importItemModelList.Add(new OratervImportItemModel
|
|
{
|
|
Tanterv = importJsonItem.TantervNeve ?? string.Empty,
|
|
Oraterv = importJsonItem.OratervNeve ?? string.Empty,
|
|
Evfolyam = importJsonItem.EvfolyamNeve ?? string.Empty,
|
|
Operation = importJsonItem.Operation
|
|
});
|
|
}
|
|
|
|
//NOTE: Hozzáadjuk azokat a az elemeket, amik az adatbázisból jöttek!
|
|
foreach (var co in oratervItemCoList)
|
|
{
|
|
if (!importJsonItemList.Select(x => x.Id).Contains(co.OratervId))
|
|
{
|
|
importItemModelList.Add(new OratervImportItemModel
|
|
{
|
|
Tanterv = co.TantervNev ?? string.Empty,
|
|
Oraterv = co.Nev ?? string.Empty,
|
|
Evfolyam = co.EvfolyamNev ?? string.Empty,
|
|
Operation = (int)ImportItemOperationEnum.Default
|
|
});
|
|
}
|
|
}
|
|
|
|
return importItemModelList
|
|
.OrderBy(x => x.Tanterv)
|
|
.ThenBy(x => x.Oraterv)
|
|
.ThenBy(x => x.Evfolyam)
|
|
.ThenByDescending(x => x.OperationText).ToList();
|
|
}
|
|
|
|
protected static ImportInfoSummaryModel GetOratervTantargyImportInfoSummary(OratervImportCo importCo, List<OratervTantargyCO> coList)
|
|
{
|
|
List<OratervTargyImportJsonItemCo> importJsonItemList = importCo.OratervTantargyImportJsonItemList;
|
|
int updateRowCount = importJsonItemList?.Count(x => x.Operation == (int)ImportItemOperationEnum.Update) ?? 0;
|
|
int unchangedRowCount = 0;
|
|
switch (importCo.ImportMuvelet)
|
|
{
|
|
case (int)ImportMuveletEnum.Insert:
|
|
unchangedRowCount = coList.Count;
|
|
break;
|
|
|
|
case (int)ImportMuveletEnum.InsertAndUpdate:
|
|
unchangedRowCount = coList.Count - updateRowCount;
|
|
break;
|
|
}
|
|
|
|
var importInfoSummary = new ImportInfoSummaryModel
|
|
{
|
|
ImportName = ImportExportOratervResource.OratervTantargy,
|
|
InsertRowCount = importJsonItemList?.Count(x => x.Operation == (int)ImportItemOperationEnum.Insert).ToString() ?? "0",
|
|
UpdateRowCount = updateRowCount.ToString(),
|
|
DeleteRowCount = "-",
|
|
UnchangedRowCount = unchangedRowCount.ToString(),
|
|
InvalidRowCount = importCo.NemImportalhatoItemList.Count.ToString()
|
|
};
|
|
return importInfoSummary;
|
|
}
|
|
|
|
protected List<OratervTantargyImportItemModel> GetOratervTantargyImportItemModelList(List<OratervTargyImportJsonItemCo> importJsonItemList, List<OratervTantargyCO> oratervTantargyItemCoList, List<OratervCO> oratervItemCoList)
|
|
{
|
|
var importItemModelList = new List<OratervTantargyImportItemModel>();
|
|
if (importJsonItemList == null)
|
|
{
|
|
if (oratervTantargyItemCoList.Count == 0)
|
|
{
|
|
return importItemModelList;
|
|
}
|
|
|
|
importJsonItemList = new List<OratervTargyImportJsonItemCo>();
|
|
}
|
|
|
|
//NOTE: Hozzáadjuk azokat a az elemeket, amik az excel-ből jöttek!
|
|
foreach (var importJsonItem in importJsonItemList)
|
|
{
|
|
importItemModelList.Add(new OratervTantargyImportItemModel
|
|
{
|
|
Tanterv = importJsonItem.TantervNeve ?? string.Empty,
|
|
Oraterv = importJsonItem.OratervNeve ?? string.Empty,
|
|
Evfolyam = importJsonItem.EvfolyamNeve ?? string.Empty,
|
|
Tantargy = importJsonItem.TantargyNeve ?? string.Empty,
|
|
EvesOraszam = importJsonItem.EvesOraszam.ToString(),
|
|
Operation = importJsonItem.Operation
|
|
});
|
|
}
|
|
|
|
//NOTE: Hozzáadjuk azokat a az elemeket, amik az adatbázisból jöttek!
|
|
foreach (var co in oratervTantargyItemCoList)
|
|
{
|
|
if (!importJsonItemList.Select(x => x.Id).Contains(co.OratervTantargyId))
|
|
{
|
|
var oratervCo = oratervItemCoList.SingleOrDefault(x => x.OratervId == co.OratervId);
|
|
importItemModelList.Add(new OratervTantargyImportItemModel
|
|
{
|
|
Tanterv = oratervCo?.TantervNev ?? string.Empty,
|
|
Oraterv = co.OratervNev ?? string.Empty,
|
|
Evfolyam = oratervCo?.EvfolyamNev ?? string.Empty,
|
|
Tantargy = co.TantargyNev ?? string.Empty,
|
|
EvesOraszam = co.EvesOraszam.ToString(),
|
|
Operation = (int)ImportItemOperationEnum.Default
|
|
});
|
|
}
|
|
}
|
|
|
|
return importItemModelList
|
|
.OrderBy(x => x.Tanterv)
|
|
.ThenBy(x => x.Oraterv)
|
|
.ThenBy(x => x.Evfolyam)
|
|
.ThenByDescending(x => x.OperationText).ToList();
|
|
}
|
|
|
|
public ActionResult Import()
|
|
{
|
|
if (ModelState.IsValid)
|
|
{
|
|
var helper = new OratervImportExportHelper(ConnectionTypeExtensions.GetSessionConnectionType());
|
|
OratervImportCo importCo = helper.ImportCo;
|
|
helper.Import(new { ImportJson = importCo });
|
|
|
|
return Content(Url.Content(TovabbUrl));
|
|
}
|
|
|
|
return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
|
|
}
|
|
|
|
#endregion
|
|
}
|
|
}
|