private void DocumentHistoryListWindow_Loaded(object sender, RoutedEventArgs e) { using (var _uow = new Saina.Data.Context.SainaDbContext()) { var auditEntries = _uow.Database.SqlQuery <AuditEntryX>($@"SELECT e.AuditEntryID, e.EntitySetName, e.EntityTypeName, e.State, CASE e.State WHEN 0 THEN N'افزودن' WHEN 1 THEN N'حذف' WHEN 2 THEN N'تغییر' ELSE e.StateName END AS StateName, e.CreatedBy, e.CreatedDate FROM dbo.AuditEntries e INNER JOIN dbo.AuditEntryProperties p ON p.AuditEntryID = e.AuditEntryID WHERE e.EntityTypeName='AccDocumentItem' AND p.PropertyName='AccDocumentItemId' AND p.NewValue IN (SELECT AccDocumentItemId FROM Acc.AccDocumentItems WHERE AccDocumentHeaderId={accDocumentHeaderId})" ).ToList(); //_uow.AuditEntries.Where(X => X.EntityTypeName == "AccDocumentHeader").ToList(); documentsHistoriesRadGridView.ItemsSource = auditEntries; } }
private void OnExport() { if (_accessUtility.HasAccess(61)) { var errorMessage = ""; var getDocumentNumbering = _accDocumentHeadersService.GetDocumentNumbering(); var dateDocument = _appContextService.CurrentFinancialYear; EndNumber = getDocumentNumbering.EndNumber; var lastAccDocumentHeaderCode = _accDocumentHeadersService.GetLastAccDocumentHeaderCode(_appContextService.CurrentFinancialYear); if (lastAccDocumentHeaderCode > EndNumber) { Error("شماره گذاری اسناد به پایان رسیده،لطفا شماره گذاری اسناد را بررسی نمایید"); } else { var startYear = _currencyExchangesService.GetStartFinancialYear(dateDocument); PersianCalendar persianCalendar = new PersianCalendar(); if (DocumentDate == null) { Error("تاریخ تسعیر خالی می باشد"); } else if (DocumentDate != null) { var DocDate = persianCalendar.GetYear(DocumentDate.Value); if (DocDate != dateDocument) { Error("تاریخ تسعیر با سال مالی تطابق ندارد"); } else { var GetEnd = GetEndExchange(dateDocument); AccDocumentItems = new ObservableCollection <AccDocumentItemGroupedDTO>(_currencyExchangesService.GetGroupedAccDocumentItems(GetEnd.Value.Date, DocumentDate.Value.Date)); var c = AccDocumentItems.Count; // AccDocumentItems = new ObservableCollection<AccDocumentItemGroupedDTO>(await _currencyExchangesService.GetGroupedAccDocumentItemsAsync(StartFinancialYear.Date, DocumentDate.Value.Date)); if (!AccDocumentItems.Any()) { Error("سندی تا این تاریخ برای تسعیر وجود ندارد"); } else { if (AccHeaderDate == null) { Error("تاریخ سند خالی می باشد"); } else if (AccHeaderDate != null) { var accHeaderDate = persianCalendar.GetYear(AccHeaderDate.Value); if (accHeaderDate > dateDocument) { Error(" تاریخ سند با سال مالی تطابق ندارد"); } else { if (SL == null) { errorMessage += $"لطفا معین خود را انتخاب کنید {Environment.NewLine}"; // Error("معین خود را انتخاب کنید."); } else if (SL != null) { if (SL.DLType1 != 0 && DLs1 == null) { errorMessage += $"تفصیل اول نمی تواند خالی باشد {Environment.NewLine}"; } if (SL.DLType2 != 0 && DLs2 == null) { errorMessage += $" تفصیل دوم نمی تواند خالی باشد {Environment.NewLine}"; } if (Description1 == "" || Description1 == null) { errorMessage += $" شرح آرتیکل 1 نباید خالی باشد {Environment.NewLine}"; } } if (errorMessage.Length > 0) { Error(errorMessage); } else { var getHeader = _tLDocumentsService.GetAccDocumentHeaders(GetEnd.Value.Date, DocumentDate.Value.Date); if (getHeader == true) { Information?.Invoke("در بین اسناد وضعیت پیش نویس وجود دارد"); } else { IsBusy = true; AccDocumentHeader = new AccDocumentHeader(); var startNumber = getDocumentNumbering.StartNumber; if (lastAccDocumentHeaderCode == 0) { lastAccDocumentHeaderCode = startNumber; } else { lastAccDocumentHeaderCode++; } Enabled = false; IsEnable = false; //lastAccDocumentHeaderCode = _accDocumentHeadersService.GetLastAccDocumentHeaderCode(dateDocument); var lastDailyNumberCode = _accDocumentHeadersService.GetLastDailyNumberCode1(); var stringLastAccDocumentHeaderCode = lastAccDocumentHeaderCode.ToString(); var stringlastDailyNumberCode = lastDailyNumberCode.ToString(); var lastAccDocumentHeadersCode = stringLastAccDocumentHeaderCode; var lastDayAccDocumentHeadersCode = stringLastAccDocumentHeaderCode; AccDocumentHeader.DailyNumber = int.Parse($"{stringlastDailyNumberCode}"); AccDocumentHeader.DocumentNumber = int.Parse($"{lastAccDocumentHeadersCode}"); AccDocumentHeader.ManualDocumentNumber = int.Parse($"{lastAccDocumentHeadersCode}"); AccDocumentHeader.SystemFixNumber = int.Parse($"{lastAccDocumentHeadersCode}"); AccDocumentHeader.HeaderDescription = "هدر سند تسعیر"; AccDocumentHeader.DocumentDate = AccHeaderDate.Value; AccDocumentHeader.Exporter = _appContextService.CurrentUser.FriendlyName; AccDocumentHeader.SystemName = System.Environment.MachineName; AccDocumentHeader.Status = StatusEnum.Temporary; AccDocumentHeader.TypeDocumentId = 6; AccRow = 1; string AccRowCode = AccRow.ToString(); // var editingAccDocumentHeader = Mapper.Map<EditableAccDocumentHeader, AccDocumentHeader>(AccDocumentHeader); // Mapper.Map( AccDocumentItemListViewModel.AccDocumentItems.ToList(), editingAccDocumentHeader.AccDocumentItems); if (DocumentDate == null) { DocumentDate = _currencyExchangesService.GetEndFinancialYear1(dateDocument); } var accItems = new ObservableCollection <AccDocumentItemGroupedDTO>(_currencyExchangesService.GetGroupedAccDocumentItems(GetEnd.Value.Date, DocumentDate.Value.Date)); var accList = AccDocumentItems.Select((xd, i) => new AccDocumentItem { AccDocumentHeaderId = AccDocumentHeader.AccDocumentHeaderId, CurrencyId = xd.CurrencyId, SLId = (xd.SLId), DL1Id = (xd.DL1Id), DL2Id = (xd.DL2Id), Description1 = Description1, Description2 = Description2, Credit = (xd.SumDebit - xd.SumCredit) < 0 ? Math.Abs(xd.SumDebit - xd.SumCredit) : 0, Debit = (xd.SumDebit - xd.SumCredit) > 0 ? Math.Abs(xd.SumDebit - xd.SumCredit) : 0, // HasExchange= xd.HasExchange = true }); using (var _uow = new Saina.Data.Context.SainaDbContext()) { foreach (var item in AccDocumentItems) { var cmd = $@"UPDATE Acc.AccDocumentItems SET HasExchange=1 WHERE AccDocumentItemId={item.AccDocumentItemId} "; _uow.Database.ExecuteSqlCommand(cmd); } } AccDocumentHeader.AccDocumentItems = new ObservableCollection <AccDocumentItem>(accList.ToList()); _accDocumentHeadersService.AddAccDocumentHeader(AccDocumentHeader); // _accDocumentItemsService.AddAccDocumentItemsAsync(accList); var remainRial = accList.Sum(di => di.Debit - di.Credit); // var remainCurrencies = sumDebitCurrencies - sumCreditCurrencies; var remainCurrencies = _currencyExchangesService.GetRemainExchanges(GetEnd.Value.Date, DocumentDate.Value.Date); if (remainCurrencies == null) { remainCurrencies = 0; } var lastCurrency = _currencyExchangesService.GetLastCurrencyDocAsync(); var remain = (remainCurrencies) - remainRial; if (remain > 0) { Debit = Math.Abs(remain.Value); Credit = 0; } else { Credit = Math.Abs(remain.Value); Debit = 0; } if (remain != 0) { var accItem = new AccDocumentItem { AccDocumentHeaderId = AccDocumentHeader.AccDocumentHeaderId, SLId = (SL.SLId), DL1Id = AccDocumentItem.DL1Id, DL2Id = AccDocumentItem.DL2Id, Description1 = Description1, Description2 = Description2, Credit = Credit, Debit = Debit }; _accDocumentItemsService.AddAccDocumentItemAsync(accItem); } EndFinancialYear = _currencyExchangesService.GetEndFinancialYear1(_appContextService.CurrentFinancialYear); GetEnd = GetEndExchange(dateDocument); // AccDocumentItems = new ObservableCollection<AccDocumentItemGroupedDTO>(await _currencyExchangesService.GetGroupedAccDocumentItemsAsync(GetEnd.Value.Date, EndFinancialYear.Date)); AccDocumentItems = new ObservableCollection <AccDocumentItemGroupedDTO>(_currencyExchangesService.GetGroupedAccDocumentItems(GetEnd.Value.Date, EndFinancialYear.Date)); Information("سند با موفقیت ثبت شد"); Enabled = true; IsEnable = true; IsBusy = false; } } } } } } } } } }