private StandardAffiliateViewModel StandardAffiliate(SysUser user) { var viewModel = Mapper.Map <StandardAffiliateViewModel>(user); var affiliate = _affiliateService.Queryable().FirstOrDefault(x => x.Id == user.AffiliateId); // Affiliate url viewModel.AffiliateUrl = $"{HttpContext.Request.Scheme}://{HttpContext.Request.Host}" + Url.Action("Register", "Authentication", new { id = viewModel.Id }); viewModel.IsTier2TabVisible = affiliate.IsTier2TabVisible; viewModel.IsTier3TabVisible = affiliate.IsTier3TabVisible; // Total sale SqlParameter TotalAffiliateSaleParam = new SqlParameter() { ParameterName = "@TotalAffiliateSale", SqlDbType = SqlDbType.Money, Direction = ParameterDirection.Output, IsNullable = true }; SqlParameter TodayAffiliateSaleParam = new SqlParameter() { ParameterName = "@TodayAffiliateSale", SqlDbType = SqlDbType.Money, Direction = ParameterDirection.Output, IsNullable = true }; SqlParameter YesterdayAffiliateSaleParam = new SqlParameter() { ParameterName = "@YesterdayAffiliateSale", SqlDbType = SqlDbType.Money, Direction = ParameterDirection.Output, IsNullable = true }; SqlParameter[] parameters = { new SqlParameter() { ParameterName = "@SysUserId", SqlDbType = SqlDbType.Int, Value = user.Id, Direction = ParameterDirection.Input }, TotalAffiliateSaleParam, TodayAffiliateSaleParam, YesterdayAffiliateSaleParam }; _dataContextAsync.ExecuteSqlCommand("exec dbo.usp_GetAffiliateSale @SysUserId, @TotalAffiliateSale OUTPUT, @TodayAffiliateSale OUTPUT, @YesterdayAffiliateSale OUTPUT", parameters); viewModel.TotalAffiliateSale = Convert.ToInt32((TotalAffiliateSaleParam.Value as int?).GetValueOrDefault(0)); viewModel.TodayAffiliateSale = Convert.ToInt32((TodayAffiliateSaleParam.Value as int?).GetValueOrDefault(0)); viewModel.YesterdayAffiliateSale = Convert.ToInt32((YesterdayAffiliateSaleParam.Value as int?).GetValueOrDefault(0)); // Total user register viewModel.TotalIntroducedUsers = _sysUserService.Queryable() .Count(x => x.IsIntroducedById != null && x.IsIntroducedById == user.Id); viewModel.TotalIntroducedUsersToday = _sysUserService.Queryable() .Where(x => x.IsIntroducedById.HasValue && x.IsIntroducedById.Value == user.Id && x.AffiliateCreatedDate.HasValue && x.AffiliateCreatedDate.Value.Date == DateTime.Now.Date).Count(); viewModel.TotalIntroducedUsersYesterday = _sysUserService.Queryable() .Where(x => x.IsIntroducedById.HasValue && x.IsIntroducedById.Value == user.Id && x.AffiliateCreatedDate.HasValue && x.AffiliateCreatedDate.Value.Date == DateTime.Now.AddDays(-1).Date).Count(); return(viewModel); }