public async Task <IActionResult> PutUserDetails([FromRoute] int id, [FromBody] UserDetails userDetails) { if (!ModelState.IsValid) { return(BadRequest(ModelState)); } if (id != userDetails.UserId) { return(BadRequest()); } _context.Entry(userDetails).State = EntityState.Modified; try { await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!UserDetailsExists(id)) { return(NotFound()); } else { throw; } } return(NoContent()); }
public async Task Post(UserDetails item) { try { _context.UserDetails.Add(item); await _context.SaveChangesAsync(); } catch (Exception ex) { Console.WriteLine(ex.Message); } }
public async Task <bool> InsertUserDetailsAsync(InsertUserRequest UserDetails) { try { var context = new UserDetailsContext(); var UserInformation = new UserDetail(); UserInformation.UserEmail = UserDetails.UserEmail; UserInformation.FirstName = UserDetails.FirstName; UserInformation.LastName = UserDetails.LastName; UserInformation.PhoneNumber = UserDetails.PhoneNumber; UserInformation.UserTypeId = (int)Enum.Parse(typeof(UserAccessType), UserDetails.UserStatus) + 1; var result = await context.AddAsync(UserInformation); await context.SaveChangesAsync(); Debug.Write(result); return(true); /*string connectionstring = * "Data Source=DESKTOP-02T0GUH\\SQLEXPRESS;Initial Catalog = UserDetails; User ID = DESKTOP-02T0GUH\\sonij; Password='';Integrated Security=true;"; * SqlConnection conn = new SqlConnection(connectionstring); * string query = "INSERT INTO UserDetails (FirstName,LastName,UserEmail,UserTypeId,PhoneNumber) VALUES (@firstname,@lastname,@useremail,@userTypeId,@phonenumber)"; * using (SqlCommand cmd = new SqlCommand(query, conn)) * { * //@phonenumber * cmd.CommandType = CommandType.Text; * conn.Open(); * * cmd.Parameters.AddWithValue("@userTypeId", (int)Enum.Parse(typeof(UserAccessType), UserDetails.UserStatus) + 1); * cmd.Parameters.AddWithValue("@firstname", UserDetails.FirstName.ToString()); * cmd.Parameters.AddWithValue("@lastname", UserDetails.LastName.ToString()); * cmd.Parameters.AddWithValue("@useremail", UserDetails.UserEmail.ToString()); * cmd.Parameters.AddWithValue("@phonenumber", UserDetails.PhoneNumber.ToString()); * try * { * var reader = await cmd.ExecuteNonQueryAsync(); * conn.Close(); * return true; * //return false; * } * catch (Exception e) * { * Debug.WriteLine(e); * conn.Close(); * return false; * } * }*/ } catch (Exception e) { Debug.Write(e); return(false); } }