public bool Update(MeetingNote note, string schema, string connectionString)
{
using (IDbConnection dbConnection = new SqlConnection(connectionString))
{
dbConnection.Open();
string updateQuery = $@"UPDATE [{schema}].[MeetingNote]
SET ReferanceId = @ReferanceId,
NoteText = @NoteText,
MeetingAttendeeId = @MeetingAttendeeId
CreatedDate = @CreatedDate
WHERE Id = @Id";
var instance = dbConnection.Execute(updateQuery, new
{
note.Id,
note.ReferanceId,
note.NoteText,
note.MeetingAttendeeId,
note.CreatedDate
});
return(instance == 1);
}
}
public async Task <IActionResult> UpdateMeetingNote(MeetingNote meetingNote)
{
var response = await MeetingNoteRepository.UpdateMeetingNote(meetingNote);
return(Ok(response));
}
public async Task <bool> CreateMeetingNote(MeetingNote meetingNote)
{
await InitiativeContext.MeetingNote.AddAsync(meetingNote);
return(await InitiativeContext.SaveChangesAsync() > 0);
}
public MeetingNote Post([FromBody] MeetingNote note)
{
var userInfo = Request.ExtractAuth(User, _authenticationService);
return(new MeetingNote());
}
