public async Task <List <RevenueViewModel> > GetRevenueStatistics(int take, TimeEnum time)
{
var now = DateTime.Now;
DateTime start = now, end = now;
if (time == TimeEnum.Week)
{
start = now.Date.AddDays(-7); // prev sunday 00:00
//end = start.AddDays(7); // next sunday 00:00
end = now;
}
else if (time == TimeEnum.Month)
{
//todo: process later
}
var query = from receiptVoucher in _context.PhieuThu
where receiptVoucher.NgayLap >= start &&
receiptVoucher.NgayLap < end
group receiptVoucher by receiptVoucher.NgayLap.Date
into groupReceipt
select new RevenueViewModel
{
Timeline = groupReceipt.Key.Date.ToString("dd/MM"),
Value = groupReceipt.Sum(re => re.TongTien)
};
var result = await query.ToListAsync();
return(result);
}
public void TypeRentConstructorTest()
{
TimeEnum time = TimeEnum.Hour;
TypeRent typeRent = new TypeRent(time);
Assert.IsNotNull(typeRent);
}
private static void AddToCache(string key, object value, int expiryTime, TimeEnum expiryUnits, CacheItemPriority priority)
{
CacheItemPolicy policy = new CacheItemPolicy();
policy.AbsoluteExpiration = DateTime.Now.AddMilliseconds(TimeHelper.GetTimeInMilliseconds(expiryTime, expiryUnits));
policy.Priority = priority;
cache.Set(key, value, policy, null);
}
public void AddCustomStringToCache(string key, string value, int expiryTime, TimeEnum expiryTimeUnits)
{
if (value == null)
{
value = String.Empty;
}
TraceManager.PipelineComponent.TraceInfo("{0} - Adding string value {1} to the cache with a key of {2}", CallToken, value, key);
AddToCache(key, value, expiryTime, expiryTimeUnits, priority);
}
public static string Abbreviation(this TimeEnum unitEnum)
{
switch (unitEnum)
{
case TimeEnum.Seconds: return("s");
case TimeEnum.Minutes: return("mins.");
case TimeEnum.Hours: return("hr");
default: throw new ArgumentOutOfRangeException(nameof(unitEnum), unitEnum, null);
}
}
public static double ConversionFactor(this TimeEnum unitEnum)
{
switch (unitEnum)
{
case TimeEnum.Seconds: return(1);
case TimeEnum.Minutes: return(60);
case TimeEnum.Hours: return(3600);
default: throw new ArgumentOutOfRangeException(nameof(unitEnum), unitEnum, null);
}
}
public TypeRent(TimeEnum time)
{
this.time = time;
switch (time)
{
case TimeEnum.Hour:
this.price = 5;
break;
case TimeEnum.Day:
this.price = 20;
break;
case TimeEnum.Week:
this.price = 60;
break;
default:
this.price = 0;
break;
}
}
public float GetFloat(TimeEnum waitTime)
{
switch (waitTime)
{
case TimeEnum.Full:
break;
case TimeEnum.Half:
break;
case TimeEnum.Quarter:
break;
default:
break;
}
return(0);
}
void ChangeTime()
{
if (Controller.GetAxis().x > 0)
{
switch (currentTime)
{
case TimeEnum.Red:
currentTime = TimeEnum.Green;
vrCamera.cullingMask = greenMask;
break;
case TimeEnum.Green:
currentTime = TimeEnum.Blue;
vrCamera.cullingMask = blueMask;
break;
case TimeEnum.Blue:
currentTime = TimeEnum.Red;
vrCamera.cullingMask = redMask;
break;
}
}
else
{
switch (currentTime)
{
case TimeEnum.Red:
currentTime = TimeEnum.Blue;
vrCamera.cullingMask = blueMask;
break;
case TimeEnum.Green:
currentTime = TimeEnum.Red;
vrCamera.cullingMask = redMask;
break;
case TimeEnum.Blue:
currentTime = TimeEnum.Green;
vrCamera.cullingMask = greenMask;
break;
}
}
}
/// <summary>
/// //函数GetDate()，能计算一个日期若干（日 / 周 / 月）后的日期
/// </summary>
public static DateTime GetDate(string dateString, int amount, TimeEnum unit)
{
DateTime basetime = DateTime.ParseExact(dateString, "yyyyMMdd", System.Globalization.CultureInfo.CurrentCulture);
switch (unit)
{
case TimeEnum.day:
return(basetime.AddDays(amount));
case TimeEnum.week:
return /*Convert.ToDateTime(*/ (basetime.AddDays(amount * 7));
case TimeEnum.mouth:
return(basetime.AddMonths(amount));
default:
break;
}
return(basetime);
}
public static int GetTimeInMilliseconds(int expiryTime, TimeEnum expiryUnits)
{
switch (expiryUnits)
{
case TimeEnum.Seconds:
return(expiryTime * 1000);
case TimeEnum.Minutes:
return(expiryTime * 60 * 1000);
case TimeEnum.Hours:
return(expiryTime * 60 * 60 * 1000);
case TimeEnum.Days:
return(expiryTime * 24 * 60 * 60 * 1000);
default:
return(expiryTime);
}
}
/// <summary>
/// Calculates time value to hours
/// </summary>
/// <param name="value"></param>
/// <param name="timeType"></param>
/// <returns></returns>
public static int CalculateValueToHours(int value, TimeEnum timeType)
{
switch (timeType)
{
case TimeEnum.YEAR:
return(value * (int)TimeInHours.YEAR);
case TimeEnum.MONTH:
return(value * (int)TimeInHours.MONTH);
case TimeEnum.WEEK:
return(value * (int)TimeInHours.WEEK);
case TimeEnum.DAY:
return(value * (int)TimeInHours.DAY);
case TimeEnum.HOUR:
return(value);
default:
return(0);
}
}
GetBestSellingGoods(int take, TimeEnum time, ProductType type)
{
var now = DateTime.Now;
DateTime start = now, end = now;
if (time == TimeEnum.Week)
{
start = now.Date.AddDays(-(int)now.DayOfWeek); // prev sunday 00:00
end = start.AddDays(7); // next sunday 00:00
}
else if (time == TimeEnum.Month)
{
//start and end day of this month
start = new DateTime(now.Year, now.Month, 1);
end = start.AddMonths(1).AddDays(-1);
}
var query = from invoice in _context.DonHang
where invoice.NgayLap >= start && invoice.NgayLap < end
join detail in _context.ChiTietDonHang
on invoice.Id equals detail.DonHangId
group detail by detail.HangHoaId;
var invoicesInAWeek = await query.ToListAsync();
var query2 = invoicesInAWeek.Select((g) =>
{
var statistic = g.Aggregate(new ProductStatistics(),
(acc, c) => acc.Accumulate(c),
acc => acc.Compute());
var product = (from pro in _context.HangHoa.Include(m => m.TrangThai)
where pro.Id == g.Key
select pro).First();
return(new ProductFilterViewModel
{
Id = g.Key,
ProductTypeId = product.LoaiHangHoaId,
TotalSold = statistic.TotalSold,
Name = product.TenHangHoa,
Available = product.TonKho,
RetailPrice = product.GiaBanLe != null ? product.GiaBanLe.Value : 0,
WholeSaleprice = product.GiaBanSi != null ? product.GiaBanSi.Value : 0,
ImageUrl = product.ImageUrl,
ShortcutStatus = product.TrangThai.VietTat
});
}).OrderByDescending(i => i.TotalSold);
List <ProductFilterViewModel> results;
if (type == ProductType.Both)
{
results = query2.Where(i => i.ShortcutStatus == "Use").Take(take).ToList();
return(results);
}
results = query2.Where(f => f.ProductTypeId == (int)type).Take(take).ToList();
return(results);
}
public string GetCachedValueFromSSOConfigStore(string applicationName, string key, int expiryTime, TimeEnum expiryTimeUnits, FailureActionEnum failureAction)
{
string value = null;
object obj = null;
string cacheKey = String.Format("BRE Pipeline Framework SSO Cache - {0} - {1}", applicationName, key);
obj = cache.Get(cacheKey);
if (obj != null)
{
value = obj.ToString();
return(value);
}
else
{
try
{
value = StaticHelpers.ReadFromSSO(applicationName, key, failureAction, value);
if (!string.IsNullOrEmpty(value))
{
AddToCache(cacheKey, value, expiryTime, expiryTimeUnits, priority);
}
}
catch (Exception e)
{
base.SetException(e);
}
return(value);
}
}
TimeType(TimeEnum unitEnum)
{
UnitEnum = unitEnum;
}
public void UpdateCacheExpiryTime(int expiryTime, TimeEnum expiryTimeUnits)
{
contextExpiryTime = expiryTime;
contextExpiryUnits = expiryTimeUnits;
}
public void Stop()
{
state = TimeEnum.STOP;
}
public void set(string key, string value, long timeout, TimeEnum timeEnum)
{
}
public void Run()
{
startTime = Time.time;
state = TimeEnum.RUNNING;
}
// Use this for initialization
void Awake()
{
trackedObj = GetComponent <SteamVR_TrackedObject>();
currentTime = TimeEnum.Red;
vrCamera.cullingMask = redMask;
}
