namespace Ladaer.BackEnd.Infrastructures.DTO.StoredProcedureResults
{
    /// <summary>
    /// Result class for sp_SearchCustomersForReconciliation stored procedure
    /// </summary>
    public class CustomerReconciliationSpResult
    {
        public int CustomerId { get; set; }
        public string FullName { get; set; } = string.Empty;
        public string PhoneNumber { get; set; } = string.Empty;
        public string Email { get; set; } = string.Empty;
        public string UserName { get; set; } = string.Empty;
        public int CodOrderCount { get; set; }
        public int BankTransferOrderCount { get; set; }
        public int TotalOrderCount { get; set; }
        public decimal TotalCodAmount { get; set; }
        public decimal TotalCodFee { get; set; }
        public decimal TotalTransferFee { get; set; }
        public decimal EstimatedNetAmount { get; set; }
        public DateTimeOffset? OldestOrderDate { get; set; }
        public DateTimeOffset? LatestOrderDate { get; set; }
        public int TotalRecords { get; set; }
    }
}
