public List <BaseOrderLineDTO> GetSalesRows(int userId, DashboardEnums.eSaleBoxType type, FiltersToken filter)
{
try
{
using (var context = new lfeAuthorEntities())
{
string paymentSource = null;
byte? lineTypeId = null;
switch (type)
{
case DashboardEnums.eSaleBoxType.ONE_TIME:
paymentSource = DashboardEnums.eSaleSources.AS.ToString();
lineTypeId = (byte)BillingEnums.eOrderLineTypes.SALE;
break;
case DashboardEnums.eSaleBoxType.SUBSCRIPTION:
paymentSource = DashboardEnums.eSaleSources.AS.ToString();
lineTypeId = (byte)BillingEnums.eOrderLineTypes.SUBSCRIPTION;
break;
case DashboardEnums.eSaleBoxType.RENTAL:
paymentSource = DashboardEnums.eSaleSources.AS.ToString();
lineTypeId = (byte)BillingEnums.eOrderLineTypes.RENTAL;
break;
case DashboardEnums.eSaleBoxType.SALES_BY_AFFILIATES:
paymentSource = DashboardEnums.eSaleSources.BAFS.ToString();
break;
case DashboardEnums.eSaleBoxType.AFFILIATE_SALES:
paymentSource = DashboardEnums.eSaleSources.AFS.ToString();
break;
}
var result = context.tvf_DB_GetUserSalesDetails(filter.DateRange.from, filter.DateRange.to, userId, filter.CurrencyId, filter.StoreId, paymentSource, lineTypeId).ToList();
var lines = result.Select(x => x.DbSaleEntity2BaseOrderLineDto()).OrderByDescending(x => x.OrderNumber).ToList();
return(lines);
}
}
catch (Exception ex)
{
Logger.Error("GetSalesRows", ex, CommonEnums.LoggerObjectTypes.Dashboard);
return(new List <BaseOrderLineDTO>());
}
}
