public AboutModel Execute(AboutRequest request)
{
var sqlHelper = _session.CreateSqlHelper("SELECT count(*) from table_case");
var caseCount = Convert.ToInt32(sqlHelper.ExecuteScalar());
sqlHelper.CommandText = "SELECT count(*) from table_subcase";
var subcaseCount = Convert.ToInt32(sqlHelper.ExecuteScalar());
sqlHelper.CommandText = "SELECT count(*) from table_site";
var siteCount = Convert.ToInt32(sqlHelper.ExecuteScalar());
sqlHelper.CommandText = "SELECT count(*) from table_contact";
var contactCount = Convert.ToInt32(sqlHelper.ExecuteScalar());
sqlHelper.CommandText = "SELECT count(*) from table_probdesc";
var solutionCount = Convert.ToInt32(sqlHelper.ExecuteScalar());
return(new AboutModel
{
Version = Assembly.GetCallingAssembly().GetName().Version.ToString(),
CaseCount = caseCount,
ContactCount = contactCount,
SiteCount = siteCount,
SolutionCount = solutionCount,
SubcaseCount = subcaseCount
});
}
public AboutModel Execute(AboutRequest request)
{
var sqlHelper = _session.CreateSqlHelper("SELECT count(*) from table_case");
var caseCount = Convert.ToInt32(sqlHelper.ExecuteScalar());
sqlHelper.CommandText = "SELECT count(*) from table_subcase";
var subcaseCount = Convert.ToInt32(sqlHelper.ExecuteScalar());
sqlHelper.CommandText = "SELECT count(*) from table_site";
var siteCount = Convert.ToInt32(sqlHelper.ExecuteScalar());
sqlHelper.CommandText = "SELECT count(*) from table_contact";
var contactCount = Convert.ToInt32(sqlHelper.ExecuteScalar());
sqlHelper.CommandText = "SELECT count(*) from table_probdesc";
var solutionCount = Convert.ToInt32(sqlHelper.ExecuteScalar());
return new AboutModel
{
Version = Assembly.GetCallingAssembly().GetName().Version.ToString(),
CaseCount = caseCount,
ContactCount = contactCount,
SiteCount = siteCount,
SolutionCount = solutionCount,
SubcaseCount = subcaseCount
};
}
public async Task <HttpResponseMessage> UpdateAbout([FromBody] AboutRequest request)
{
var response = await _profileService.UpdateUserAbout(request, Request.GetSession()).ConfigureAwait(false);
return(Request.SystemResponse(response));
}
public async Task <StatusData <string> > UpdateUserAbout(AboutRequest request, SystemSession session)
{
var response = (await Task.Factory.StartNew(() => Client.UserService.updateUserAbout(session.UserId.ToString(), request.Headline, request.About, session.GetSession())).ConfigureAwait(false)).GetStatusData <string>();
return(response);
}
public Task <StatusData <string> > UpdateUserAbout(AboutRequest request, SystemSession session)
{
return(_jUnitOfWork.Profile.UpdateUserAbout(request, session));
}
