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); }