| | | 1 | | using System; |
| | | 2 | | using System.ComponentModel.DataAnnotations; |
| | | 3 | | using System.ComponentModel.DataAnnotations.Schema; |
| | | 4 | | using System.Globalization; |
| | | 5 | | |
| | | 6 | | namespace OzonDomains.Models; |
| | | 7 | | |
| | | 8 | | [Table("orders_history")] |
| | | 9 | | public class OrderHistory |
| | | 10 | | { |
| | | 11 | | [Key] |
| | | 12 | | [DatabaseGenerated(DatabaseGeneratedOption.Identity)] |
| | | 13 | | [Column("Id")] |
| | 59 | 14 | | public int Id { get; set; } |
| | | 15 | | |
| | | 16 | | [Required] |
| | | 17 | | [Column("OrderId")] |
| | 333 | 18 | | public int OrderId { get; set; } |
| | | 19 | | |
| | | 20 | | [Column("ColumnName")] |
| | | 21 | | [MaxLength(100)] |
| | 431 | 22 | | public string? ColumnName { get; set; } |
| | | 23 | | |
| | | 24 | | [Column("ColumnDisplayName")] |
| | | 25 | | [MaxLength(200)] |
| | 325 | 26 | | public string? ColumnDisplayName { get; set; } |
| | | 27 | | |
| | | 28 | | [Column("OldValue")] |
| | 271 | 29 | | public string? OldValue { get; set; } |
| | | 30 | | |
| | | 31 | | [Column("NewValue")] |
| | 407 | 32 | | public string? NewValue { get; set; } |
| | | 33 | | |
| | | 34 | | [Required] |
| | | 35 | | [Column("ChangedAt")] |
| | 408 | 36 | | public DateTime ChangedAt { get; set; } |
| | | 37 | | |
| | | 38 | | [Column("ChangedBy")] |
| | | 39 | | [MaxLength(255)] |
| | 245 | 40 | | public string? ChangedBy { get; set; } |
| | | 41 | | |
| | | 42 | | /// <summary>Идентификатор одной операции сохранения; у старых записей отсутствует.</summary> |
| | | 43 | | [Column("OperationId", TypeName = "char(36)")] |
| | | 44 | | [MaxLength(36)] |
| | 7 | 45 | | public Guid? OperationId { get; set; } |
| | | 46 | | |
| | | 47 | | // Навигационное свойство |
| | | 48 | | [ForeignKey("OrderId")] |
| | 0 | 49 | | public virtual Order? Order { get; set; } |
| | | 50 | | |
| | | 51 | | // Методы для форматирования значений |
| | | 52 | | [NotMapped] |
| | 35 | 53 | | public string FormattedOldValue => FormatValue(OldValue); |
| | | 54 | | |
| | | 55 | | [NotMapped] |
| | 37 | 56 | | public string FormattedNewValue => FormatValue(NewValue); |
| | | 57 | | |
| | | 58 | | [NotMapped] |
| | 0 | 59 | | public string FormattedChangedAt => ChangedAt.ToString("dd.MM.yyyy HH:mm:ss"); |
| | | 60 | | |
| | | 61 | | private string FormatValue(string? value) |
| | | 62 | | { |
| | 72 | 63 | | if (string.IsNullOrEmpty(value)) |
| | 18 | 64 | | return string.Empty; |
| | | 65 | | |
| | 54 | 66 | | if (string.Equals(value.Trim(), "NULL", StringComparison.OrdinalIgnoreCase)) |
| | 1 | 67 | | return "Не указано"; |
| | | 68 | | |
| | 53 | 69 | | if (decimal.TryParse(value, NumberStyles.Any, CultureInfo.InvariantCulture, out var decimalValue)) |
| | | 70 | | { |
| | 29 | 71 | | return decimalValue.ToString("0.##", CultureInfo.InvariantCulture); |
| | | 72 | | } |
| | | 73 | | |
| | 24 | 74 | | if (double.TryParse(value, NumberStyles.Any, CultureInfo.InvariantCulture, out var doubleValue)) |
| | | 75 | | { |
| | 0 | 76 | | return doubleValue.ToString("0.##", CultureInfo.InvariantCulture); |
| | | 77 | | } |
| | 24 | 78 | | return value; |
| | | 79 | | } |
| | | 80 | | [NotMapped] |
| | 0 | 81 | | public bool IsOldValueNumeric => IsNumeric(OldValue); |
| | | 82 | | |
| | | 83 | | [NotMapped] |
| | 0 | 84 | | public bool IsNewValueNumeric => IsNumeric(NewValue); |
| | | 85 | | |
| | | 86 | | private bool IsNumeric(string? value) |
| | | 87 | | { |
| | 0 | 88 | | if (string.IsNullOrEmpty(value)) |
| | 0 | 89 | | return false; |
| | | 90 | | |
| | 0 | 91 | | return decimal.TryParse(value, NumberStyles.Any, CultureInfo.InvariantCulture, out _) || |
| | 0 | 92 | | double.TryParse(value, NumberStyles.Any, CultureInfo.InvariantCulture, out _); |
| | | 93 | | } |
| | | 94 | | } |