private static DateTime GetFromPeriod(ITime time, FilterPeriod period)
{
DateTime fromDate = DateTime.Today;
var today = time.GetAppNowTime().Date;
switch (period)
{
case FilterPeriod.Day: //Day
fromDate = today;
break;
case FilterPeriod.Week: //Week
fromDate = today.AddDays(-7);
break;
case FilterPeriod.Month: //Month
fromDate = today.AddMonths(-1);
break;
case FilterPeriod.ThreeMonth: //3 month
fromDate = today.AddMonths(-3);
break;
}
return(fromDate);
}
public static IList <SalesReportViewModel> GetAllByDate(IUnitOfWork db,
ITime time,
FilterPeriod period)
{
DateTime fromDate = GetFromPeriod(time, period);
var items = db.SalesReports.GetSalesByDateReport(fromDate);
return(items.Select(i => new SalesReportViewModel(i)).ToList());
}
public void PopulateDataGridView()
{
if (cbxFilterOptions.SelectedIndex == -1)
{
return;
}
FilterOptions selectedOption = (FilterOptions)cbxFilterOptions.SelectedIndex;
FilterPeriod selectedPeriod = (FilterPeriod)cbxFilterPeriod.SelectedIndex;
DateTime selectedDateFrom = dtpPeriodFrom.Value.Date;
DateTime selectedDateTo = dtpPeriodTo.Value.Date;
List <string> selectedTypes = clbFileTypes.CheckedItems.Cast <string>().ToList();
switch (selectedOption)
{
case FilterOptions.ShowAll:
ShowAllFiles(selectedTypes);
break;
case FilterOptions.TimeCreated:
ShowFilesByPeriodOfTime("CreationTime", selectedPeriod, selectedDateFrom, selectedDateTo, selectedTypes);
break;
case FilterOptions.LastModifyTime:
ShowFilesByPeriodOfTime("LastModificationTime", selectedPeriod, selectedDateFrom, selectedDateTo, selectedTypes);
break;
case FilterOptions.LastAccessTime:
ShowFilesByPeriodOfTime("LastAccessTime", selectedPeriod, selectedDateFrom, selectedDateTo, selectedTypes);
break;
case FilterOptions.DeletedFiles:
ShowDeletedFiles(selectedPeriod, selectedDateFrom, selectedDateTo, selectedTypes);
break;
default:
break;
}
}
public void ShowDeletedFiles(FilterPeriod selectedPeriod, DateTime selectedDateFrom, DateTime selectedDateTo, List <string> selectedTypes)
{
try
{
switch (selectedPeriod)
{
case FilterPeriod.ForDay:
if (RecievedFolder == null)
{
dgvFiles.DataSource = database.GetDeletedFilesForFolder(selectedDrive, null, selectedTypes, selectedDateFrom);
}
else
{
dgvFiles.DataSource = database.GetDeletedFilesForFolder(selectedDrive, RecievedFolder.Name, selectedTypes, selectedDateFrom);
}
break;
default:
if (RecievedFolder == null)
{
dgvFiles.DataSource = database.GetDeletedFilesForFolder(selectedDrive, null, selectedTypes, selectedDateFrom, selectedDateTo);
}
else
{
dgvFiles.DataSource = database.GetDeletedFilesForFolder(selectedDrive, RecievedFolder.Name, selectedTypes, selectedDateFrom, selectedDateTo);
}
break;
}
SetUpDataGridViewColumnsSettings();
lblNumberOfFiles.Visible = true;
lblNumberOfFiles.Text = dgvFiles.Rows.Count.ToString();
}
catch (Exception)
{
lblErrorLabel.Visible = true;
}
}
public void ShowFilesByPeriodOfTime(string columnName, FilterPeriod selectedPeriod, DateTime selectedDateFrom, DateTime selectedDateTo, List <string> selectedTypes)
{
try
{
switch (selectedPeriod)
{
case FilterPeriod.ForDay:
dgvFiles.DataSource = database.GetFilesByPeriodOfTime(selectedDrive, columnName, selectedTypes, selectedDateFrom).Distinct(new CacheModelComaparer()).ToList();
break;
default:
dgvFiles.DataSource = database.GetFilesByPeriodOfTime(selectedDrive, columnName, selectedTypes, selectedDateFrom, selectedDateTo).Distinct(new CacheModelComaparer()).ToList();
break;
}
SetUpDataGridViewColumnsSettings();
lblNumberOfFiles.Visible = true;
lblNumberOfFiles.Text = dgvFiles.Rows.Count.ToString();
}
catch (Exception)
{
lblErrorLabel.Visible = true;
}
}
public static IQueryable <BuyBoxStatusViewModel> GetAll(IUnitOfWork db,
int market,
string marketplaceId,
FilterPeriod period,
bool inStock,
bool includeIgnored)
{
var items = db.BuyBoxStatus.GetAllWithItems()
.Where(bb => !String.IsNullOrEmpty(bb.ParentASIN))
.Select(bb => new BuyBoxStatusViewModel()
{
EntityId = bb.Id,
ASIN = bb.ASIN,
Market = (MarketType)bb.Market,
MarketplaceId = bb.MarketplaceId,
Status = bb.Status,
CheckedDate = bb.CheckedDate,
LostWinnerDate = bb.LostWinnerDate,
WinnerMerchantName = bb.WinnerMerchantName,
WinnerPrice = bb.WinnerPrice,
WinnerSalePrice = bb.WinnerSalePrice,
WinnerAmountSaved = bb.WinnerAmountSaved,
IsIgnored = bb.IsIgnored,
Price = bb.Price,
Quantity = bb.Quantity < 0 ? 0 : bb.Quantity,
ParentASIN = bb.ParentASIN,
Size = bb.Size,
Images = bb.Images,
SKU = bb.SKU,
StyleId = bb.StyleId,
StyleString = bb.StyleString
});
DateTime?fromDate = null;
switch (period)
{
case FilterPeriod.NotWinAll:
items = items.Where(i => i.Status == BuyBoxStatusCode.NotWin);
break;
case FilterPeriod.WinLostLastMonth:
fromDate = DateTime.UtcNow.AddDays(-30);
break;
case FilterPeriod.WinLostLastWeek:
fromDate = DateTime.UtcNow.AddDays(-7);
break;
case FilterPeriod.WinLostLastDay:
fromDate = DateTime.UtcNow.AddDays(-1);
break;
}
if (fromDate.HasValue)
{
items = items.Where(i => i.LostWinnerDate >= fromDate.Value);
}
if (!includeIgnored)
{
items = items.Where(i => !i.IsIgnored);
}
if (inStock)
{
items = items.Where(i => i.Quantity > 0);
}
if (market != 0)
{
items = items.Where(i => (int)i.Market == market);
}
if (!String.IsNullOrEmpty(marketplaceId))
{
items = items.Where(i => i.MarketplaceId == marketplaceId);
}
return(items);
}
