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