public int Insert(UserInfoAddRequest model, string userId)
{
var id = 0;
DataProvider.ExecuteNonQuery(GetConnection, "dbo.Users_Insert",
inputParamMapper : delegate(SqlParameterCollection parameterCollection)
{
parameterCollection.AddWithValue("@FirstName", model.FirstName);
parameterCollection.AddWithValue("@LastName", model.LastName);
parameterCollection.AddWithValue("@UserName", model.UserName);
parameterCollection.AddWithValue("@Email", model.Email);
parameterCollection.AddWithValue("@Phone", model.Phone);
parameterCollection.AddWithValue("@Gender", model.Gender);
parameterCollection.AddWithValue("@Bio", model.Bio);
parameterCollection.AddWithValue("@UserId", userId);
SqlParameter s = new SqlParameter("@Id", System.Data.SqlDbType.Int)
{
Direction = System.Data.ParameterDirection.Output
};
parameterCollection.Add(s);
},
returnParameters : delegate(SqlParameterCollection para)
{
int.TryParse(para["@Id"].Value.ToString(), out id);
}
);
return(id);
}
public bool ConfirmEmail(Guid tokenId)
{
bool result = false;
Token token = UserTokensService.Get(tokenId);
ApplicationUserManager userManager = UserService.GetUserManager();
ApplicationUser user = userManager.FindByName(token.UserName);
if (user != null)
{
// Set the EmailConfirmed flag in AspNetUsers table
DataProvider.ExecuteNonQuery(GetConnection, "dbo.AspNetUsers_UpdateEmailConfirmed"
, inputParamMapper : delegate(SqlParameterCollection UpdateEmailConfirmed)
{
UpdateEmailConfirmed.AddWithValue("@EmailConfirmed", true);
UpdateEmailConfirmed.AddWithValue("@UserName", token.UserName);
});
// Insert new record in Users table
ApplicationUser au = UserService.GetUserbyUserName(token.UserName);
UserInfoAddRequest req = new UserInfoAddRequest();
req.UserName = token.UserName;
req.Phone = au.PhoneNumber;
req.Email = au.Email;
Insert(req, au.Id);
// Delete the token from UserTokens table
UserTokensService.Delete(tokenId);
result = true;
}
return(result);
}
public UserInfo(UserInfoAddRequest objAddRequestObject)
{
FullName = objAddRequestObject.FullName;
IsActive = objAddRequestObject.IsActive;
Age = objAddRequestObject.Age;
Email = objAddRequestObject.Email;
Phone = objAddRequestObject.Phone;
}
public async Task <IActionResult> AddEntity([FromBody] UserInfoAddRequest entityObject)
{
UserInfo dataObject = new UserInfo(entityObject);
APIResponse = await baseService.AddEntity(dataObject);
return(Ok(APIResponse));
}
public HttpResponseMessage DeletsUserInfo(UserInfoAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
return(Request.CreateResponse(model));
}
public Task <ResponseMessage <string> > UserInfoAddAsync(UserInfoAddRequest request)
{
var apiUrl = new AkmiiApiUrl
{
Method = "POST",
Url = _context.DomainUrl + "/YeeOfficeSettings/_api/ver(3.0)/admin/userinfo"
};
return(GetResponseAsync <ResponseMessage <string> >(apiUrl, request.Convert2Json()));
}
public IHttpActionResult Post(UserInfoAddRequest model)
{
try
{
ItemResponse <int> response = new ItemResponse <int>
{
Item = _userInfoService.Insert(model),
IsSuccessful = true
};
return(Ok(response));
}
catch (Exception ex) { return(BadRequest(ex.Message)); }
}
public HttpResponseMessage AddUserData(UserInfoAddRequest model)
{
if (!ModelState.IsValid)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState));
}
ItemResponse <int> response = new ItemResponse <int>();
string userId = UserService.GetCurrentUserId();
response.Item = _userDataService.Insert(model, userId);
return(Request.CreateResponse(response));
}
public int Insert(UserInfoAddRequest model)
{
int id = 0;
Adapter.ExecuteQuery("dbo.UserInfo_Insert", new[] {
SqlDbParameter.Instance.BuildParameter("@UserBaseId", model.UserBaseId, System.Data.SqlDbType.Int),
SqlDbParameter.Instance.BuildParameter("@FirstName", model.FirstName, System.Data.SqlDbType.NVarChar),
SqlDbParameter.Instance.BuildParameter("@LastName", model.LastName, System.Data.SqlDbType.NVarChar),
SqlDbParameter.Instance.BuildParameter("@UserAvatar", model.UserAvatar, SqlDbType.NVarChar),
SqlDbParameter.Instance.BuildParameter("@Bio", model.Bio, System.Data.SqlDbType.NVarChar),
SqlDbParameter.Instance.BuildParameter("@DateOfBirth", model.DateOfBirth, System.Data.SqlDbType.Date),
SqlDbParameter.Instance.BuildParameter("@Interest", model.Interest, System.Data.SqlDbType.Int),
SqlDbParameter.Instance.BuildParameter("@Id", id, System.Data.SqlDbType.Int, 0, ParameterDirection.Output)
}, (parameters =>
{
id = parameters.GetParmValue <int>("@Id"); //for inserts
}));
return(id);
}
