public async Task <IActionResult> Update([FromBody] UpdateMemberParms parms) { try { await _memberRepo.Update(parms); return(this.Ok("Success")); } catch (Exception ex) { Log.LogError(ex, "MemberViewController threw an exception"); return(BadRequest("There was an error creating the member profile")); } }
public async Task <bool> Update(UpdateMemberParms parms) { var parameters = new { MemberID = parms.MemberID, UpdatedByID = parms.UpdatedByID, MemberTypeID = parms.MemberTypeID, FirstName = parms.FirstName, LastName = parms.LastName, MiddleInitial = parms.MiddleInitial, NickName = parms.NickName, Address1 = parms.Address1, City = parms.City, State = parms.State, Zip = parms.Zip, Email = parms.Email, PhoneNumber1 = parms.PhoneNumber1, PhoneType1 = parms.PhoneType1, PhoneNumber2 = parms.PhoneNumber2, PhoneType2 = parms.PhoneType2, PhotoURL = parms.PhotoURL, MemberNote = parms.MemberNote, Active = parms.Active, }; using (SqlConnection connection = new SqlConnection(ConnectionString)) { try { bool ok = 1 == (int)await connection.ExecuteAsync("dbo.UpdateMember", parameters, commandType : CommandType.StoredProcedure); return(ok); } catch (Exception ex) { Console.Write(string.Format("Error: {0}", ex.Message)); return(false); } } }