using DevExpress.Web.Mvc; using GreenTree.Nachtragsmanagement.Core; using GreenTree.Nachtragsmanagement.Core.Authentication; using GreenTree.Nachtragsmanagement.Core.Domain.Appendix; using GreenTree.Nachtragsmanagement.Core.Domain.Deviation; using GreenTree.Nachtragsmanagement.Services.Appendix; using GreenTree.Nachtragsmanagement.Services.Deviation; using GreenTree.Nachtragsmanagement.Services.Logging; using GreenTree.Nachtragsmanagement.Services.Site; using GreenTree.Nachtragsmanagement.Web.Extensions; using GreenTree.Nachtragsmanagement.Web.Framework.Authorization; using GreenTree.Nachtragsmanagement.Web.Models.Deviation; using GreenTree.Nachtragsmanagement.Web.Models.Global; using Newtonsoft.Json; using System; using System.Collections.Generic; using System.Linq; using System.Net.Mime; using System.Web; using System.Web.Mvc; using static GreenTree.Nachtragsmanagement.Web.Extensions.MVCxGridViewGeneratorHelper; namespace GreenTree.Nachtragsmanagement.Web.Controllers { public class DeviationController : Controller { private readonly IDeviationService _deviationService; private readonly IAppendixService _appendixService; private readonly ISiteService _siteService; private readonly IUserHelper _userHelper; private readonly ILogger _logger; public DeviationController( IDeviationService deviationService, IAppendixService appendixService, ISiteService siteService, IUserHelper userHelper, ILogger logger) { _deviationService = deviationService; _appendixService = appendixService; _siteService = siteService; _userHelper = userHelper; _logger = logger; ViewData["AllDisturbances"] = _deviationService.GetAllDisturbances(); ViewData["AllStatuses"] = _deviationService.GetAllStatuses(); ViewData["AllKinds"] = _deviationService.GetAllKinds(); } #region Deviations /// /// Basic deviation view function /// [FunctionAuthorize(true, "Deviation-Deviations")] public ActionResult ViewDeviations() { var currentUser = _userHelper.FromCookies(); var deviations = _deviationService.GetAllUserAssignedDeviations(currentUser); var deviationModels = deviations .Select(u => DeviationDataModel.FromDeviation(u, false)) .ToList(); return View("~/Views/Deviations/View.cshtml", deviationModels); } /// /// Get JSON data of specific deviation /// /// Deviation id. public ActionResult GetDeviation(int id = -1) { var deviation = _deviationService.GetDeviationById(id); if (deviation == null) return new JsonResult { Data = "notFound", JsonRequestBehavior = JsonRequestBehavior.AllowGet }; var deviationModel = DeviationDataModel.FromDeviation(deviation, false); return new JsonResult { Data = JsonConvert.SerializeObject(deviationModel), JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } /// /// Callback result for deviation grid /// /// The height of the grid scrollable component. public ActionResult PartialDeviations(int scrollHeight = -1) { var currentUser = _userHelper.FromCookies(); var deviations = _deviationService.GetAllUserAssignedDeviations(currentUser); var deviationModels = deviations .Select(u => DeviationDataModel.FromDeviation(u, false)) .ToList(); ViewData["ScrollHeight"] = scrollHeight; return PartialView("~/Views/Deviations/_DeviationGridPartial.cshtml", deviationModels); } /// /// Export result for deviation grid /// [HttpPost] public ActionResult ExportPartialDeviations(string displayMode, string exportformat, string exportType) { if (String.IsNullOrEmpty(displayMode)) return new EmptyResult(); var currentUser = _userHelper.FromCookies(); var deviations = _deviationService.GetAllUserAssignedDeviations(currentUser); var deviationModels = deviations .Select(u => DeviationDataModel.FromDeviation(u, false)) .ToList(); var viewContext = new ViewContext(); var viewPage = new ViewPage(); var htmlHelper = new System.Web.Mvc.HtmlHelper(viewContext, viewPage); MVCxGridViewState gridViewState = (MVCxGridViewState)Session["DeviationGridViewState"]; var settings = GridViewSettingsHelper.DeviationGridViewSettings(htmlHelper); if (gridViewState != null) { var generator = new MVCReportGeneratonHelper(); generator.CustomizeColumnsCollection += new CustomizeColumnsCollectionEventHandler(generator_CustomizeColumnsCollection); generator.CustomizeGroupColumnSummary += new CustomizeColumnGroupSummaryEventHandler(generator_CustomizeGroupColumnSummary); generator.CustomizeTotalColumnSummary += new CustomizeColumnTotalSummaryEventHandler(generator_CustomizeTotalColumnSummary); var report = generator.GenerateMVCReport(gridViewState, deviationModels); if (displayMode == "popup") return PartialView("~/Views/Shared/_PrintPopupPartial.cshtml", new PrintGridModel(report, "Deviation", "ExportPartialDeviations", "devGridViewDeviation")); else if (displayMode == "callback") return PartialView("~/Views/Shared/_PrintDocumentViewerPartial.cshtml", new PrintGridModel(report, "Deviation", "ExportPartialDeviations", "devGridViewDeviation")); else if (displayMode == "export") { if (exportType != "print") { switch (exportformat.ToLower()) { case "xlsx": settings.TotalSummary["Value"].DisplayFormat = "{0:c2}"; settings.TotalSummary["Percentage"].DisplayFormat = "{0:p0}"; settings.TotalSummary["PercentageValue"].DisplayFormat = "{0:c2}"; settings.TotalSummary["DaysReceiptToAppendixOffering"].DisplayFormat = "Schnitt = {0:n0}"; settings.TotalSummary["Description"].DisplayFormat = "Anzahl = {0:n0}"; return GridViewExtension.ExportToXlsx(settings, deviationModels); case "xls": settings.TotalSummary["Value"].DisplayFormat = "{0:c2}"; settings.TotalSummary["Percentage"].DisplayFormat = "{0:p0}"; settings.TotalSummary["DaysReceiptToAppendixOffering"].DisplayFormat = "Schnitt = {0:n0}"; settings.TotalSummary["Description"].DisplayFormat = "Anzahl = {0:n0}"; return GridViewExtension.ExportToXls(settings, deviationModels); case "pdf": generator.WritePdfToResponse(Response, "VA-Liste.pdf", DispositionTypeNames.Attachment.ToString()); break; } } } return new EmptyResult(); } else return new EmptyResult(); } /// /// Customize created columns /// private void generator_CustomizeColumnsCollection(object source, ColumnsCreationEventArgs e) { foreach (var column in e.ColumnsInfo) { if (column.FieldName == "CustomNumber") { column.ColumnWidth = 30; } if (column.FieldName == "SiteDescription") { column.ColumnWidth = 60; } if (column.FieldName == "AppendixDescription") { column.ColumnWidth = 50; } if (column.FieldName == "StatusDescription") { column.ColumnWidth = 60; } if (column.FieldName == "Comment") { column.IsVisible = false; column.IsDetail = true; } } } /// /// Customize column summary /// private void generator_CustomizeGroupColumnSummary(object source, ColumnSummaryCreationEventArgs e) { if (e.FieldName == "Value") { e.Summary.FormatString = "Schätzung ∑ = {0:c2}"; } if (e.FieldName == "Percentage") { e.Summary.FormatString = "Bew. Ø = {0:p0}"; } if (e.FieldName == "PercentageValue") { e.Summary.FormatString = "S. Bew. ∑ = {0:c2}"; } if (e.FieldName == "DaysReceiptToAppendixOffering") { e.Summary.FormatString = "Tage VA-NT = {0:n0}"; } if (e.FieldName == "Description") { e.Summary.FormatString = "Alle = {0:n0}"; } } /// /// Customize column summary /// private void generator_CustomizeTotalColumnSummary(object source, ColumnSummaryCreationEventArgs e) { if (e.FieldName == "Value") { e.Summary.FormatString = "{0:c2}"; } if (e.FieldName == "Percentage") { e.Summary.FormatString = "{0:p0}"; } if (e.FieldName == "PercentageValue") { e.Summary.FormatString = "{0:c2}"; } if (e.FieldName == "DaysReceiptToAppendixOffering") { e.Summary.FormatString = "{0:n0}"; } if (e.FieldName == "Description") { e.Summary.FormatString = "Alle = {0:n0}"; } } /// /// Partial edit for editing of existing or for new deviation /// /// Id for existing deviation, otherweise -1. public ActionResult EditDeviation(int id = -1) { var deviation = _deviationService.GetDeviationById(id); var deviationModel = DeviationDataModel.FromDeviation(deviation, true); var defaultKind = _deviationService.GetDefaultKind(); var defaultStatus = _deviationService.GetDefaultStatus(); if (defaultKind != null) ViewData["DefaultKind"] = defaultKind.Id; if (defaultStatus != null) ViewData["DefaultStatus"] = defaultStatus.Id; return PartialView("~/Views/Deviations/_DeviationEditPartial.cshtml", deviationModel); } /// /// Partial edit for creating a new deviation for a site /// /// Id of the site which the deviation should be appended to. public ActionResult AppendDeviationToSite(int siteId) { var site = _siteService.GetSiteById(siteId); var allDeviations = new List(); allDeviations.AddRange( site.Appendices .SelectMany(a => a.Deviations)); allDeviations.AddRange( site.Deviations); var lastCustomNumber = 0; if (allDeviations.Any()) lastCustomNumber = allDeviations .Max(d => StaticHelper.TryParseInt(d.CustomNumber)); var deviationModel = new DeviationDataModel { Id = -1, SiteId = siteId, CustomNumber = (lastCustomNumber + 1).ToString(), Percentage = 1, }; var defaultKind = _deviationService.GetDefaultKind(); var defaultStatus = _deviationService.GetDefaultStatus(); if (defaultKind != null) ViewData["DefaultKind"] = defaultKind.Id; if (defaultStatus != null) ViewData["DefaultStatus"] = defaultStatus.Id; return PartialView("~/Views/Deviations/_DeviationEditPartial.cshtml", deviationModel); } /// /// Partial edit for creating a new deviation for an appendix /// /// Id of the appendix which the deviation should be appended to. public ActionResult AppendDeviationToAppendix(int appendixId) { var appendix = _appendixService.GetAppendixById(appendixId); var site = appendix.Site; var allDeviations = new List(); allDeviations.AddRange( site.Appendices .SelectMany(a => a.Deviations)); allDeviations.AddRange( site.Deviations); var lastCustomNumber = allDeviations .Max(d => StaticHelper.TryParseInt(d.CustomNumber)); var deviationModel = new DeviationDataModel { Id = -1, AppendixId = appendixId, CustomNumber = (lastCustomNumber + 1).ToString(), Percentage = 1, }; var defaultKind = _deviationService.GetDefaultKind(); var defaultStatus = _deviationService.GetDefaultStatus(); if (defaultKind != null) ViewData["DefaultKind"] = defaultKind.Id; if (defaultStatus != null) ViewData["DefaultStatus"] = defaultStatus.Id; return PartialView("~/Views/Deviations/_DeviationEditPartial.cshtml", deviationModel); } /// /// Partial edit result if ModelState is valid, otherwise simple JSON result for success /// /// Deviation model to be saved. [HttpPost, ValidateInput(false)] public ActionResult EditDeviation(DeviationDataModel deviationModel) { try { deviationModel.DisturbanceValueEntities = deviationModel.DisturbanceEntities .Select(r => JsonConvert.DeserializeObject(r)) .ToList(); for (int i = 0; i < deviationModel.DisturbanceValueEntities.Count; i++) deviationModel.DisturbanceValueEntities.ElementAt(i).Json = deviationModel.DisturbanceEntities.ElementAt(i); deviationModel.PercentageValue = deviationModel.Value * deviationModel.Percentage; if (!ModelState.IsValid) return PartialView("~/Views/Deviations/_DeviationEditPartial.cshtml", deviationModel); var disturbanceValues = deviationModel.DisturbanceValueEntities .Select(r => r.ToDisturbanceValue()) .ToList(); if (deviationModel.Id == -1) { var deviation = deviationModel.ToDeviation(); deviation.SetDisturbanceValues(disturbanceValues); _deviationService.InsertDeviation(deviation); _logger.Entity(deviation, Core.Domain.Logging.LogEntityActivity.Insert, _userHelper.FromCookies()); } else { var deviation = _deviationService.GetDeviationById(deviationModel.Id); deviation.CustomNumber = deviationModel.CustomNumber; deviation.Description = deviationModel.Description; deviation.ReceiptDate = deviationModel.ReceiptDate; deviation.AppendixDate = deviationModel.AppendixDate; deviation.Value = deviationModel.Value; deviation.AppendixId = deviationModel.AppendixId; deviation.StatusId = deviationModel.StatusId; deviation.KindId = deviationModel.KindId; deviation.Comment = deviationModel.Comment; deviation.SetDisturbanceValues(disturbanceValues); _deviationService.UpdateDeviation(deviation); _logger.Entity(deviation, Core.Domain.Logging.LogEntityActivity.Update, _userHelper.FromCookies()); } return new JsonResult { Data = "success" }; } catch (Exception ex) { _logger.Error("Fehler bei Speicherung einer Vertragsabweichung.", ex, _userHelper.FromCookies()); return PartialView("~/Views/Shared/_PopupError.cshtml", ex); } } /// /// Simple JSON result for deleting a specific deviation /// /// Deviation id. [HttpPost] public ActionResult DeleteDeviation(int id) { try { var deviation = _deviationService.GetDeviationById(id); if (deviation != null) _deviationService.DeleteDeviation(deviation); _logger.Entity(deviation, Core.Domain.Logging.LogEntityActivity.Delete, _userHelper.FromCookies()); return new JsonResult { Data = "success" }; } catch (Exception ex) { _logger.Error("Fehler bei Löschung einer Vertragsabweichung.", ex, _userHelper.FromCookies()); return PartialView("~/Views/Shared/_PopupError.cshtml", ex); } } #endregion #region Claims /// /// Basic claim view function /// [FunctionAuthorize(true, "Deviation-Claims")] public ActionResult ViewClaims() { return View("~/Views/Deviations/Claims.cshtml"); } /// /// Get JSON data of specific claim /// /// Claim type. /// Claim id. public ActionResult GetClaim(string claimType, int id = -1) { switch (claimType.ToLower()) { case "status": var status = _deviationService.GetStatusById(id); if (status == null) return new JsonResult { Data = "notFound", JsonRequestBehavior = JsonRequestBehavior.AllowGet }; else return new JsonResult { Data = JsonConvert.SerializeObject(status), JsonRequestBehavior = JsonRequestBehavior.AllowGet }; case "disturbance": var disturbance = _deviationService.GetDisturbanceById(id); if (disturbance == null) return new JsonResult { Data = "notFound", JsonRequestBehavior = JsonRequestBehavior.AllowGet }; else return new JsonResult { Data = JsonConvert.SerializeObject(disturbance), JsonRequestBehavior = JsonRequestBehavior.AllowGet }; case "kind": var kind = _deviationService.GetKindById(id); if (kind == null) return new JsonResult { Data = "notFound", JsonRequestBehavior = JsonRequestBehavior.AllowGet }; else return new JsonResult { Data = JsonConvert.SerializeObject(kind), JsonRequestBehavior = JsonRequestBehavior.AllowGet }; default: return new JsonResult { Data = "unknownClaimType", JsonRequestBehavior = JsonRequestBehavior.AllowGet }; } } /// /// Callback result for claim grid /// /// Claim type. public ActionResult PartialClaims(string claimType) { switch (claimType.ToLower()) { case "status": return PartialView("~/Views/Deviations/_StatusListPartial.cshtml", ViewData["AllStatuses"]); case "disturbance": return PartialView("~/Views/Deviations/_DisturbanceListPartial.cshtml", ViewData["AllDisturbances"]); case "kind": return PartialView("~/Views/Deviations/_KindListPartial.cshtml", ViewData["AllKinds"]); default: return new EmptyResult(); } } /// /// Partial edit for editing of existing or for new claim /// /// Claim type. /// Id for existing claim, otherweise -1. public ActionResult EditClaim(string claimType = "", int id = -1) { switch (claimType.ToLower()) { case "status": var status = _deviationService.GetStatusById(id); var statusModel = StatusDataModel.FromStatus(status, true); return PartialView("~/Views/Deviations/_StatusEditPartial.cshtml", statusModel); case "disturbance": var disturbance = _deviationService.GetDisturbanceById(id); var disturbanceModel = DisturbanceDataModel.FromDisturbance(disturbance, true); return PartialView("~/Views/Deviations/_DisturbanceEditPartial.cshtml", disturbanceModel); case "kind": var kind = _deviationService.GetKindById(id); var kindModel = KindDataModel.FromKind(kind, true); return PartialView("~/Views/Deviations/_KindEditPartial.cshtml", kindModel); default: return new EmptyResult(); } } /// /// Partial edit result if ModelState is valid, otherwise simple JSON result for success /// /// Status model to be saved. [HttpPost, ValidateInput(false)] public ActionResult EditStatus(StatusDataModel statusModel) { try { if (!ModelState.IsValid) return PartialView("~/Views/Deviations/_StatusEditPartial.cshtml", statusModel); var allStatuses = _deviationService.GetAllStatuses(); if (statusModel.IsDefault) { foreach (var status in allStatuses) { status.IsDefault = false; _deviationService.UpdateStatus(status); } } if (statusModel.Id == -1) { var claim = statusModel.ToStatus(); _deviationService.InsertStatus(claim); _logger.Entity(claim, Core.Domain.Logging.LogEntityActivity.Insert, _userHelper.FromCookies()); } else { var claim = _deviationService.GetStatusById(statusModel.Id); claim.Description = statusModel.Description; claim.IsDefault = statusModel.IsDefault; _deviationService.UpdateStatus(claim); _logger.Entity(claim, Core.Domain.Logging.LogEntityActivity.Update, _userHelper.FromCookies()); } return new JsonResult { Data = "success" }; } catch (Exception ex) { _logger.Error("Fehler bei Speicherung eines VA-Status.", ex, _userHelper.FromCookies()); return PartialView("~/Views/Shared/_PopupError.cshtml", ex); } } /// /// Partial edit result if ModelState is valid, otherwise simple JSON result for success /// /// Disturbance model to be saved. [HttpPost, ValidateInput(false)] public ActionResult EditDisturbance(DisturbanceDataModel disturbanceModel) { try { if (!ModelState.IsValid) return PartialView("~/Views/Deviations/_DisturbanceEditPartial.cshtml", disturbanceModel); if (disturbanceModel.Id == -1) { var claim = disturbanceModel.ToDisturbance(); _deviationService.InsertDisturbance(claim); _logger.Entity(claim, Core.Domain.Logging.LogEntityActivity.Insert, _userHelper.FromCookies()); } else { var disturbance = _deviationService.GetDisturbanceById(disturbanceModel.Id); disturbance.Description = disturbanceModel.Description; _deviationService.UpdateDisturbance(disturbance); _logger.Entity(disturbance, Core.Domain.Logging.LogEntityActivity.Update, _userHelper.FromCookies()); } return new JsonResult { Data = "success" }; } catch (Exception ex) { _logger.Error("Fehler bei Speicherung einer VA-Kategorie.", ex, _userHelper.FromCookies()); return PartialView("~/Views/Shared/_PopupError.cshtml", ex); } } /// /// Partial edit result if ModelState is valid, otherwise simple JSON result for success /// /// Kind model to be saved. [HttpPost, ValidateInput(false)] public ActionResult EditKind(KindDataModel kindModel) { try { if (!ModelState.IsValid) return PartialView("~/Views/Deviations/_KindEditPartial.cshtml", kindModel); var allKinds = _deviationService.GetAllKinds(); if (kindModel.IsDefault) { foreach (var kind in allKinds) { kind.IsDefault = false; _deviationService.UpdateKind(kind); } } if (kindModel.Id == -1) { var claim = kindModel.ToKind(); _deviationService.InsertKind(claim); _logger.Entity(claim, Core.Domain.Logging.LogEntityActivity.Insert, _userHelper.FromCookies()); } else { var kind = _deviationService.GetKindById(kindModel.Id); kind.Description = kindModel.Description; kind.IsDefault = kindModel.IsDefault; _deviationService.UpdateKind(kind); _logger.Entity(kind, Core.Domain.Logging.LogEntityActivity.Update, _userHelper.FromCookies()); } return new JsonResult { Data = "success" }; } catch (Exception ex) { _logger.Error("Fehler bei Speicherung einer Art.", ex, _userHelper.FromCookies()); return PartialView("~/Views/Shared/_PopupError.cshtml", ex); } } /// /// Simple JSON result for deleting a specific claim /// /// Claim type. /// Claim id. /// Id of claim which deviations get in place of deleting claim. [HttpPost] public ActionResult DeleteClaim(string claimType, int id, int replaceId) { switch (claimType.ToLower()) { case "status": try { var status = _deviationService.GetStatusById(id); var replaceStatus = _deviationService.GetStatusById(replaceId); var statusDeviations = _deviationService.GetDeviationsByStatus(id); foreach (var deviation in statusDeviations) { deviation.StatusId = replaceId; deviation.Status = replaceStatus; _deviationService.UpdateDeviation(deviation); } if (status != null) _deviationService.DeleteStatus(status); _logger.Entity(status, Core.Domain.Logging.LogEntityActivity.Delete, _userHelper.FromCookies()); } catch (Exception ex) { _logger.Error("Fehler bei Löschung eines VA-Status.", ex, _userHelper.FromCookies()); return PartialView("~/Views/Shared/_PopupError.cshtml", ex); } break; case "kind": try { var kind = _deviationService.GetKindById(id); var replaceKind = _deviationService.GetKindById(replaceId); var kindDeviations = _deviationService.GetDeviationsByKind(id); foreach (var deviation in kindDeviations) { deviation.KindId = replaceId; deviation.Kind = replaceKind; _deviationService.UpdateDeviation(deviation); } if (kind != null) _deviationService.DeleteKind(kind); _logger.Entity(kind, Core.Domain.Logging.LogEntityActivity.Delete, _userHelper.FromCookies()); } catch (Exception ex) { _logger.Error("Fehler bei Löschung einer Art.", ex, _userHelper.FromCookies()); return PartialView("~/Views/Shared/_PopupError.cshtml", ex); } break; case "disturbance": try { var disturbance = _deviationService.GetDisturbanceById(id); var replaceDisturbance = _deviationService.GetDisturbanceById(replaceId); var allDeviations = _deviationService.GetAllDeviations(); foreach (var deviation in allDeviations) { foreach (var disturbanceValue in deviation.DisturbanceValues) { if (disturbanceValue.DisturbanceId == id) { disturbanceValue.Disturbance = replaceDisturbance; disturbanceValue.DisturbanceId = replaceDisturbance.Id; } } _deviationService.UpdateDeviation(deviation); } if (disturbance != null) _deviationService.DeleteDisturbance(disturbance); _logger.Entity(disturbance, Core.Domain.Logging.LogEntityActivity.Delete, _userHelper.FromCookies()); } catch (Exception ex) { _logger.Error("Fehler bei Löschung einer VA-Kategorie.", ex, _userHelper.FromCookies()); return PartialView("~/Views/Shared/_PopupError.cshtml", ex); } break; default: return new EmptyResult(); } return new JsonResult { Data = "success" }; } #endregion } }