/// <summary>
/// 获取用户积分记录
/// </summary>
/// <param name="userDetailRequest"></param>
/// <returns></returns>
public async Task <XDocument> getuserscore(UserDetailRequest userDetailRequest)
{
return(await Task <XDocument> .Run(() =>
{
var fetchXml = $@"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true' count='{userDetailRequest.PageSize}' page='{userDetailRequest.PageIndex}'>
<entity name='mcs_memberintegraldetail'>
<attribute name='mcs_memberintegraldetailid' />
<attribute name='mcs_name' />
<attribute name='createdon' />
<attribute name='mcs_integralpointname' />
<attribute name='mcs_integraltype' />
<attribute name='mcs_num' />
<attribute name='overriddencreatedon' />
<order attribute='createdon' descending='true' />
<link-entity name='mcs_member' from='mcs_memberid' to='mcs_memberid' link-type='inner' alias='am'>
<link-entity name='mcs_user' from='mcs_memberid' to='mcs_memberid' link-type='inner' alias='an'>
<filter type='and'>
<condition attribute='mcs_userid' operator='eq' uitype='mcs_user' value='{userDetailRequest.id}' />
</filter>
</link-entity>
</link-entity>
</entity>
</fetch>";
return XDocument.Parse(fetchXml);
}));
}
/// <summary>
/// 获取用户积分记录
/// </summary>
/// <param name="userDetailRequest"></param>
/// <returns></returns>
public async Task <XDocument> getuserscorebalance(UserDetailRequest userDetailRequest)
{
return(await Task <XDocument> .Run(() =>
{
var fetchXml = $@"<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true'>
<entity name='mcs_member'>
<attribute name='mcs_memberid' />
<attribute name='mcs_name' />
<attribute name='createdon' />
<attribute name='mcs_code' />
<attribute name='mcs_mobile' />
<attribute name='mcs_memberlevelid' />
<attribute name='mcs_bonuspoint' />
<attribute name='mcs_accumulatepoint' />
<attribute name='mcs_provinceid' />
<attribute name='mcs_districtid' />
<attribute name='mcs_cityid' />
<order attribute='mcs_code' descending='true' />
<link-entity name='mcs_user' from='mcs_memberid' to='mcs_memberid' link-type='inner' alias='ab'>
<filter type='and'>
<condition attribute='mcs_userid' operator='eq' uitype='mcs_user' value='{userDetailRequest.id}' />
</filter>
</link-entity>
</entity>
</fetch>";
return XDocument.Parse(fetchXml);
}));
}
/// <summary>
/// 获取用户标签
/// </summary>
/// <param name="userDetailRequest"></param>
/// <returns></returns>
public async Task <UserTagListResponse> getusertag(UserDetailRequest userDetailRequest)
{
try
{
var response = new UserTagListResponse();
var crmRequestHelper = new CrmRequestHelper();
var fetchRequest = new CrmRetrieveCollectionAttributeRequestMessage()
{
EntityName = "mcs_user",
EntityId = Guid.Parse(userDetailRequest.id),
AttributeName = "mcs_mcs_user_mcs_usertag",
QueryExpression = "$select=mcs_name"
};
fetchRequest.Headers.Add("Prefer", dicHead["Prefer"]);
var crmResponseMessage = await _crmService.Execute(fetchRequest);
var entities = crmResponseMessage as CrmRetrieveCollectionAttributeResponseMessage;
response.tags = entities.Value.Results;
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult UpdateUserDetails(UserDetailRequest request)
{
bool isSucess = false;
string messageAlert = string.Empty;
bool userIdResult = false;
var currentUserId = HttpContext.Session.GetString(LookupKey.SessionVariables.UserId).IsNull() ? 0 : Convert.ToInt64(HttpContext.Session.GetString(LookupKey.SessionVariables.UserId));
var passedUserResult = _userService.GetAllUserDetails().Where(m => m.UserId == request.UserId).FirstOrDefault();
request.CreatedTime = passedUserResult.CreatedTime;
request.ModifiedBy = currentUserId;
request.ModifiedTime = DateTime.Now;
//if (ModelState.IsValid)
//{
#region Validate same username
var codeUserDetailResult = _userService.GetAllUserDetails().Where(u => u.UserName == request.UserName &&
u.UserId != request.UserId &&
u.IsActive).FirstOrDefault();
if (!codeUserDetailResult.IsNull())
{
return(Ok(new { isSucess = isSucess, messageAlert = Messages.UserNameValidation }));
}
#endregion
userIdResult = _userService.UpdateUserDetails(request);
if (!userIdResult)
{
return(Ok(new { isSucess = isSucess, messageAlert = Messages.ServerError }));
}
isSucess = true;
var response = new
{
isSuccess = isSucess,
messageAlert = messageAlert
};
return(Ok(response));
//}
//else
//{
// var errors = ModelState.Values.SelectMany(v => v.Errors)
// .ToList();
// foreach (var err in errors)
// {
// Logging.Information("(Response-Model-User) UpdateUserDetails : " + err.ErrorMessage);
// }
// return Json(new { isSucess = isSucess, messageAlert = Messages.ErrorOccuredDuringProcessing }, JsonRequestBehavior.AllowGet);
//}
}
/// <summary>
/// 获取详情
/// </summary>
/// <param name="userDetailRequest"></param>
/// <returns></returns>
public async Task <CrmEntity> getuserdetail(UserDetailRequest userDetailRequest)
{
try
{
var validateResult = new ValidateResult <CrmEntity>();
var crmRequestHelper = new CrmRequestHelper();
var entitie = await crmRequestHelper.Retrieve(_crmService, entityName, Guid.Parse(userDetailRequest.id));
return(entitie);
}
catch (Exception ex)
{
throw ex;
}
}
public async Task <UserScoreListResponse> getuserscore(UserDetailRequest userDetailRequest)
{
try
{
var response = new UserScoreListResponse();
var validateResult = new ValidateResult <List <CrmEntity> >();
var crmRequestHelper = new CrmRequestHelper();
XDocument fetchXdoc = null;
fetchXdoc = await _repository.getuserscore(userDetailRequest);
var entities = await crmRequestHelper.ExecuteAsync(_crmService, "mcs_memberintegraldetail", fetchXdoc);
response.scores = entities.Results;
response.ALLTotalCount = entities.Count;
response.PageSize = userDetailRequest.PageSize;
response.CurrentPage = userDetailRequest.PageIndex;
XDocument fetchXdoc2 = await _repository.getuserscorebalance(userDetailRequest);
var getbalanceentitys = await crmRequestHelper.ExecuteAsync(_crmService, "mcs_member", fetchXdoc2);
if (getbalanceentitys.Results != null && getbalanceentitys.Results.Count > 0)
{
var bonuspoint = getbalanceentitys.Results[0].Attributes
["mcs_bonuspoint"];
response.balance = bonuspoint == null ? 0 : (Int32)bonuspoint;
}
else
{
response.balance = 0;
}
return(response);
}
catch (Exception ex)
{
throw ex;
}
}
public static dbentities.UserDetail DtoToEntity(this UserDetailRequest request)
{
dbentities.UserDetail entity = null;
if (request != null)
{
entity = new dbentities.UserDetail
{
UserID = request.UserId,
UserName = request.UserName,
Password = request.Password,
UserRoleID = request.UserRoleId,
IsActive = request.IsActive,
CreatedBy = request.CreatedBy,
CreatedTime = request.CreatedTime,
ModifiedBy = request.ModifiedBy,
ModifiedTime = request.ModifiedTime
};
}
return(entity);
}
public JsonResult AddNewUserDetails(UserDetailRequest request)
{
bool isSucess = false;
string messageAlert = string.Empty;
long userIdResult = 0;
var currentUserId = Session[LookupKey.SessionVariables.UserId].IsNull() ? 0 : Convert.ToInt64(Session[LookupKey.SessionVariables.UserId]);
request.CreatedBy = currentUserId;
request.CreatedTime = DateTime.Now;
if (ModelState.IsValid)
{
userIdResult = _userServices.SaveUserDetails(request);
if (userIdResult == -100)
{
return(Json(new { isSucess = isSucess, messageAlert = Messages.UserNameValidation }, JsonRequestBehavior.AllowGet));
}
if (userIdResult == 0)
{
return(Json(new { isSucess = isSucess, messageAlert = Messages.ServerError }, JsonRequestBehavior.AllowGet));
}
isSucess = true;
var response = new
{
isSuccess = isSucess,
messageAlert = messageAlert
};
return(Json(response, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { isSucess = isSucess, messageAlert = Messages.ErrorOccuredDuringProcessing }, JsonRequestBehavior.AllowGet));
}
}
public async Task <IActionResult> Post([FromForm] UserDetailRequest model)
{
try
{
if (ModelState.IsValid)
{
string photoGuid = string.Empty;
string extension = string.Empty;
// Saving Image on Server
if (model.Photo?.Length > 0)
{
photoGuid = Guid.NewGuid().ToString();
var image = model.Photo;
extension = Path.GetExtension(image.FileName);
var filePath = Path.Combine("wwwroot/images", $"{photoGuid}.{extension}");
using (var fileStream = new FileStream(filePath, FileMode.Create))
{
image.CopyTo(fileStream);
}
}
var userDetails = new UserDetails(model.FirstName, model.SecondName, model.Age, photoGuid, extension);
userDetailRepository.Add(userDetails);
return(Ok("success"));
}
else
{
return(BadRequest("Model Validation Failed"));
}
}
catch (Exception ex)
{
//log error
logger.LogError(ex, $"{nameof(UserController)} - {nameof(Post)}");
return(BadRequest());
}
}
public ActionResult AddNewUserDetails(UserDetailRequest request)
{
bool isSucess = false;
string messageAlert = string.Empty;
long userIdResult = 0;
var currentUserId = HttpContext.Session.GetString(LookupKey.SessionVariables.UserId).IsNull() ? 0 : Convert.ToInt64(HttpContext.Session.GetString(LookupKey.SessionVariables.UserId));
request.CreatedBy = currentUserId;
request.CreatedTime = DateTime.Now;
if (ModelState.IsValid)
{
userIdResult = _userService.SaveUserDetails(request);
if (userIdResult == -100)
{
return(Ok(new { isSucess = isSucess, messageAlert = Messages.UserNameValidation }));
}
if (userIdResult == 0)
{
return(Ok(new { isSucess = isSucess, messageAlert = Messages.ServerError }));
}
isSucess = true;
var response = new
{
isSuccess = isSucess,
messageAlert = messageAlert
};
return(Ok(response));
}
else
{
return(Ok(new { isSucess = isSucess, messageAlert = Messages.ErrorOccuredDuringProcessing }));
}
}
public async Task <ObjectResult> Head(UserDetailRequest value)
{
if (!ModelState.IsValid)
{
return(new BadRequestObjectResult(0));
}
var query = db.Users.AsQueryable();
query = query.Where(x => x.Tenants.Any(t => t.TenantId == TenantId));
var result = await query.Where(x => x.PhoneNumber.Equals(value.PhoneNumber) && !x.IsDeleted)
.Select(x => x.Id).FirstOrDefaultAsync();
if (result > 0)
{
return(new OkObjectResult(result));
}
else
{
return(new NotFoundObjectResult(0));
}
}
public async Task<NewtonsoftJsonActionResult<CrmEntity>> getuserdetail(UserDetailRequest userDetailRequest)
{
return await _appUser.getuserdetail(userDetailRequest);
}
public async Task<NewtonsoftJsonActionResult<ValidateResult<CrmEntity>>> GetAgreement(UserDetailRequest model)
{
return await _appUser.GetAgreement(model.id);
}
public Task <CrmEntity> getuserdetail(UserDetailRequest userDetailRequest)
{
return(_userService.getuserdetail(userDetailRequest));
}
public Task <UserTagListResponse> getusertag(UserDetailRequest userDetailRequest)
{
return(_userService.getusertag(userDetailRequest));
}
public Task <UserScoreListResponse> getuserscore(UserDetailRequest userDetailRequest)
{
return(_userService.getuserscore(userDetailRequest));
}
public async Task<NewtonsoftJsonActionResult<UserScoreListResponse>> getuserscore(UserDetailRequest userDetailRequest)
{
return await _appUser.getuserscore(userDetailRequest);
}
