public bool RetrieveAccountOverview(out AccountOverview accountOverview, out string message, out HttpStatusCode code)
{
message = ErrorCode.CONNECTION_FAILED;
accountOverview = null;
Api().CreateAuthenticated("api/account", "get")
.Execute(out HttpWebResponse response);
if (response.TryGetStatusCode(out code) && code == HttpStatusCode.OK)
{
ValidatedView <AccountOverview> validatedView = response.GetReponseString()
.DeserializeJsonSafe <ValidatedView <AccountOverview> >();
if (validatedView == null)
{
message = ErrorCode.ERROR_WHILE_READING_RESULT;
}
else
{
accountOverview = validatedView.Object;
message = validatedView.Message;
return(validatedView.IsValid);
}
}
return(false);
}
public static async Task <ValidatedView <AccountOverview> > RetrieveAccountOverview(int accountId)
{
try {
// check if player is ingame
if (GameManager.Players.TryGetValue(accountId, out PlayerController controller))
{
AccountOverview accountOverview = Mapper <AccountView> .Map <AccountOverview>(controller.Account);
accountOverview.ActiveShipID = controller.Account.CurrentHangar.ShipID;
return(ValidatedView <AccountOverview> .Valid(accountOverview));
}
AccountModel accountModel = await Model <AccountModel> .AsQueryable()
.FirstOrDefault(x => x.ID == accountId);
if (accountModel == null)
{
return(ValidatedView <AccountOverview> .Invalid(ErrorCode.ACCOUNT_NOT_FOUND));
}
return(ValidatedView <AccountOverview> .Valid(Mapper <AccountModel> .Map <AccountOverview>(accountModel)));
} catch (Exception e) {
GameContext.Logger.LogError(e);
}
return(ValidatedView <AccountOverview> .Invalid(ErrorCode.OPERATION_FAILED));
}
private void OnAccountOverviewRefreshed(AccountOverview obj)
{
Invoke(() => {
Account = obj;
StateHasChanged();
});
}
public static Account ExtractDirtyDbModels(this AccountOverview accountOverview)
{
Account returnAccount = null;
if (accountOverview.IsDirty || accountOverview.IsChildDirty)
{
returnAccount = accountOverview.ToDbModel();
foreach (var accountCategoryOverview in accountOverview.AccountCategories)
{
if (accountCategoryOverview.IsDirty || accountCategoryOverview.IsChildDirty)
{
var accountCategory = accountCategoryOverview.ToDbModel();
foreach (var accountActualOverview in accountCategoryOverview.AccountActuals)
{
if (accountActualOverview.IsDirty || accountActualOverview.IsDeleted)
{
accountCategory.AccountActuals.Add(accountActualOverview.ToDbModel());
}
}
returnAccount.AccountCategories.Add(accountCategory);
}
}
}
return(returnAccount);
}
public async Task <IActionResult> Searches()
{
var username = HttpContext.User.Identity.Name;
var search = await user.Overview(username);
var model = new AccountOverview()
{
User = search
};
return(View("Index", model));
}
protected override void OnInit()
{
if (!StateService.AccountOverview.Retrieve(out AccountOverview account, out string message, out _))
{
NotificationService.ShowError(message, "Failed to load account!");
ComponentService.Show(new Login());
}
else
{
Account = account;
}
StateService.OnAccountOverviewRefreshed += OnAccountOverviewRefreshed;
}
private bool RetrieveAccountOverview(out AccountOverview accountOverview, out string message, out HttpStatusCode code)
{
accountOverview = null;
message = ErrorCode.INVALID_SESSION;
code = HttpStatusCode.ServiceUnavailable;
if (!_accountService.IsAuthenticated() ||
!_accountService.RetrieveAccountOverview(out accountOverview, out message, out code))
{
return(false);
}
return(true);
}
public IActionResult Overview()
{
var accounts = _accountManager.GetHierarchy();
accounts = _accountManager.PopulateHierarchyExpeditures(accounts);
accounts = _accountManager.PopulateHierarchyTransfers(accounts);
var response = new List <AccountOverview>();
foreach (var account in accounts)
{
response.Add(AccountOverview.MapFromObject(account));
}
return(Ok(response));
}
public MainWindow()
{
InitializeComponent();
account = new Account();
accountOverviewTap = new AccountOverview(this);
StatusTab = new StatusUserControl(this);
mouseTab = new MouseUserControl(this);
UpdateStatus("Status User Control Displayed.");
MainUC.Children.Add(StatusTab);
Grid.SetColumn(StatusTab, 0);
Grid.SetRow(StatusTab, 0);
}
public async Task <IActionResult> Index()
{
var username = String.Empty;
if (HttpContext.User.Identity.IsAuthenticated)
{
username = HttpContext.User.Identity.Name;
}
if (username == String.Empty)
{
return(Unauthorized());
}
var overview = await user.Overview(username);
var model = new AccountOverview()
{
User = overview
};
return(View(model));
}
public static Account ToDbModel(this AccountOverview ao)
{
return(new Account
{
Id = ao.Id,
AccountTemplateId = ao.AccountTemplateId,
AccountTypeId = ao.AccountTypeId,
Description = ao.Description,
OwnerId = ao.OwnerId,
AreAccountCategoriesOpen = ao.AreAccountCategoriesOpen,
DisplayIndex = ao.DisplayIndex,
CreatedBy = ao.CreatedBy,
CreatedOn = ao.CreatedOn,
ModifiedBy = ao.ModifiedBy,
ModifiedOn = ao.ModifiedOn,
Ts = ao.Ts,
IsEnabled = ao.IsEnabled,
IsDefaultOfType = ao.IsDefaultOfType,
IsNew = ao.IsNew,
IsDirty = ao.IsDirty,
IsDeleted = ao.IsDeleted
});
}
public bool RetrieveAccountOverview(out AccountOverview accountOverview, out string message)
{
return(RetrieveAccountOverview(out accountOverview, out message, out _));
}
/// <summary>
/// The get accounts.
/// </summary>
/// <param name="sessionId">
/// The session id.
/// </param>
/// <returns>
/// </returns>
public AccountOverview GetAccounts(Guid sessionId)
{
var userId = this.VerifySession(sessionId);
using (var context = this.GetContext())
{
var query = from account in context.Users.Find(userId).AccountAccess.Select(x => x.Account)
let accountWithBalance = context.AccountsWithBalance.Find(account.AccountId)
select
new AccountOverviewAccount
{
AccountId = account.AccountId,
Balance = accountWithBalance.Available,
CurrencyId = accountWithBalance.Currency.CurrencyId,
DisplayName = account.DisplayName,
Type = account.AccountType
};
var result = new AccountOverview();
result.AddRange(query);
return result;
}
}
public void Init()
{
instance = new AccountOverview();
}
public void AccountIndexTest()
{
AppHost.Simulate("Website").Start(bs =>
{
// Arrange
var sessionId = Guid.NewGuid();
Mock<ISiteSession> sessionMock = null;
Mock<IClientService> serviceMock = null;
var accountOverview = new AccountOverview
{
new AccountOverviewAccount
{
AccountId = UnitTestHelper.Random.Next(1, 10000) * 2, Balance = (decimal)UnitTestHelper.Random.NextDouble() + 0.1m * 100000, CurrencyId = "BTC", DisplayName = null
},
new AccountOverviewAccount
{
AccountId = UnitTestHelper.Random.Next(1, 10000) * 2 + 1, Balance = (decimal)UnitTestHelper.Random.NextDouble() + 0.1m * 100000, CurrencyId = "USD", DisplayName = UnitTestHelper.GetRandomDisplayName(true)
}
};
FilterProviders.Providers.Add(
new MockInjectionFilterProvider(
fc =>
{
sessionMock = new Mock<ISiteSession>();
sessionMock.SetupGet(s => s.HasSession).Returns(true);
sessionMock.SetupGet(s => s.SessionId).Returns(sessionId);
((SiteController)fc.Controller).SessionPersister = sessionMock.Object;
serviceMock = new Mock<IClientService>();
serviceMock.Setup(s => s.GetAccounts(sessionId)).Returns(accountOverview);
((SiteController)fc.Controller).ClientService = serviceMock.Object;
return false;
}));
// Act
var result = bs.Get("Account");
// Assert
sessionMock.VerifyGet(s => s.HasSession);
sessionMock.Verify(s => s.SessionId);
serviceMock.Verify(s => s.GetAccounts(sessionId));
Assert.IsInstanceOf(typeof(ViewResult), result.ResultExecutedContext.Result);
var viewResult = (ViewResult)result.ResultExecutedContext.Result;
var document = new HtmlDocument();
document.LoadHtml(result.ResponseText);
Assert.IsNotNull(
document.DocumentNode.SelectSingleNode(
string.Format("//a[@href='/Account/Edit/{0}']", accountOverview[0].AccountId)));
Assert.IsNotNull(
document.DocumentNode.SelectSingleNode(
string.Format("//a[@href='/Account/Edit/{0}']", accountOverview[1].AccountId)));
Assert.IsNotNull(
document.DocumentNode.SelectSingleNode(
string.Format("//a[@href='/Account/Transfer/?SourceAccountId={0}']", accountOverview[0].AccountId)));
Assert.IsNotNull(
document.DocumentNode.SelectSingleNode(
string.Format("//a[@href='/Account/Transfer/?SourceAccountId={0}']", accountOverview[1].AccountId)));
});
}
/// <summary>
/// 获取店铺今日运营概况
/// </summary>
/// <param name="userContext"></param>
/// <returns></returns>
public AccountOverview GetAccountOverViewToday(UserContext userContext)
{
var accountBusiness = _accountBusinessDapperRepository.Find(x => x.accountid == userContext.AccId);
//销售情况
var strSqlCoupon =
@"SELECT @SalesMoney=cast(sum(RealMoney) as decimal(18, 2)),@GoodsSalesCount=SUM(saleNum) FROM dbo.T_SaleInfo
WHERE accID=@AccountId AND saleTime BETWEEN @sDate AND @eDate;
IF @SalesMoney IS NULL SET @SalesMoney=0;
IF @GoodsSalesCount IS NULL SET @GoodsSalesCount=0;
";
var sDate = DateTime.Now.ToShortDateString();
var eDate = DateTime.Now.ToShortDateString();
sDate = sDate + " 00:00:00";
eDate = eDate + " 23:59:59";
var sqlParams = new
{
AccountId = userContext.AccId,
sDate,
eDate
};
var dapperParam = new DynamicParameters(sqlParams);
dapperParam.Add("SalesMoney", dbType: DbType.Decimal, direction: ParameterDirection.Output);
dapperParam.Add("GoodsSalesCount", dbType: DbType.Int32, direction: ParameterDirection.Output);
var sqlQuery = new SqlQuery(strSqlCoupon, dapperParam);
_salesDapperRepository.FindAll(sqlQuery);
var salesMoney = dapperParam.Get <decimal>("SalesMoney");
var goodsSalesCount = dapperParam.Get <int>("GoodsSalesCount");
//库存警告
var strSqlGoodsWarning = new StringBuilder();
strSqlGoodsWarning.Append("SELECT @GoodsWarning=COUNT( DISTINCT a.gid) ");
strSqlGoodsWarning.Append("from T_GoodsInfo ");
strSqlGoodsWarning.Append("a left join T_Goods_Sku b ");
strSqlGoodsWarning.Append("on a.gid=b.gid ");
strSqlGoodsWarning.Append("where a.accID=@accId and ISNULL(a.isDown,0)=0 ");
strSqlGoodsWarning.Append(
"and ((a.IsExtend=1 and ( b.gsQuantity>=b.LimitUpper or b.gsQuantity<=b.LimitLower)) ");
strSqlGoodsWarning.Append(
"or (ISNULL(a.IsExtend,0)=0 and (a.gQuantity>=a.LimitUpper or a.gQuantity<=a.LimitLower))) ");
var sqlParamsGoodsWarning = new
{
accId = userContext.AccId
};
var dapperParamGoodsWarning = new DynamicParameters(sqlParamsGoodsWarning);
dapperParamGoodsWarning.Add("GoodsWarning", dbType: DbType.Int32, direction: ParameterDirection.Output);
var sqlQueryGoodsWarning = new SqlQuery(strSqlGoodsWarning.ToString(), dapperParamGoodsWarning);
_salesDapperRepository.FindAll(sqlQueryGoodsWarning);
var goodsWarning = dapperParamGoodsWarning.Get <int>("GoodsWarning");
//店铺会员生日
var userBirthdayCount = 0;
var responseUser = _userService.GetBirthdayUsers(userContext,
DateTime.Parse(DateTime.Now.ToShortDateString()));
if (responseUser.Code == (int)ErrorCodeEnum.Success)
{
userBirthdayCount = ((IEnumerable <BirthdayUsersResult>)responseUser.Data).Count();
}
var expenseService = new ExpensesService();
var accountOverview = new AccountOverview
{
SalesMoney = salesMoney,
GoodsSalesCount = goodsSalesCount,
UserBirthdayCount = userBirthdayCount,
GoodsStockCount = goodsWarning,
SmsCount = accountBusiness.dxunity
};
var searchParams = new ExpensesSearchParam
{
StartDate = new DateTime(DateTime.Now.Year, DateTime.Now.Month, 1, 0, 0, 0),
EndDate = DateTime.Now
};
//本月支出总额
var expenseResult = expenseService.GetExpenses(userContext, searchParams);
if (expenseResult.Code == (int)ErrorCodeEnum.Success)
{
accountOverview.ThisMonthExpense = ((ExpensesSearchResult)expenseResult.Data).TotalExpensesAmount;
}
//资金账户可提现余额
accountOverview.TotalMoeny =
((AccountBalanceResponse)_accountbookService.GetWithdrawingBalance(userContext).Data).TotalBalance;
//会员总数
accountOverview.UsersNum = _userInfoDapperRepository.FindAll(x => x.AccId == userContext.AccId).Count();
//今日手机橱窗订单总数
var ordersStrSql = new StringBuilder();
var searchDate = Convert.ToDateTime(DateTime.Now.ToShortDateString());
ordersStrSql.Append(
"SELECT COUNT(bid) as TotalOrdersNum FROM T_Goods_Booking WHERE accid=@accId AND payType=1 AND bState IN (4,6) AND bInsertTime BETWEEN @StartDate AND @EndDate;");
var sqlParamMobileOrdersNum = new
{
accId = userContext.AccId,
StartDate = searchDate,
EndDate = searchDate.AddDays(1).AddSeconds(-1)
};
var dapperParamMobileOrdersNum = new DynamicParameters(sqlParamMobileOrdersNum);
var sqlQueryMobileOrdersNum = new SqlQuery(ordersStrSql.ToString(), dapperParamMobileOrdersNum);
accountOverview.TodayMobileOrdersNum = Convert.ToInt32(_getRepository.FindAll(sqlQueryMobileOrdersNum).FirstOrDefault());
return(accountOverview);
}
