/// <summary>
/// Reminders the note.
/// </summary>
/// <param name="noteId">The note identifier.</param>
/// <param name="userId">The user identifier.</param>
/// <param name="reminder">The reminder.</param>
/// <returns></returns>
public async Task <bool> ReminderNote(int noteId, int userId, AddReminderRequest reminder)
{
try
{
SqlConnection connection = DBConnection();
SqlCommand command = StoreProcedureConnection("spReminder", connection);
connection.Open();
command.Parameters.AddWithValue("@UserId", userId);
command.Parameters.AddWithValue("@Id", noteId);
command.Parameters.AddWithValue("@AddReminder", reminder.Reminder.ToLocalTime());
command.Parameters.AddWithValue("@ModifiedDateTime", DateTime.Now);
int result = await command.ExecuteNonQueryAsync();
connection.Close();
if (result != 0)
{
return(true);
}
else
{
return(false);
};
}
catch (Exception e)
{
throw e;
}
}
public async Task <IActionResult> ReminderNote(int noteId, AddReminderRequest reminder)
{
var userId = TokenUserId();
if (await note.ReminderNote(noteId, userId, reminder))
{
string status = "reminder set successfully";
return(Ok(new { status, userId, noteId, reminder }));
}
else
{
string status = "reminder is not set";
return(BadRequest(new { status, userId, noteId, reminder }));
}
}
public static void AddReminder(object sender, AddReminderEventArgs ea)
{
AddReminderRequest?.Invoke(sender, ea);
}
/// <summary>
/// Reminders the note.
/// </summary>
/// <param name="noteId">The note identifier.</param>
/// <param name="userId">The user identifier.</param>
/// <param name="reminder">The reminder.</param>
/// <returns></returns>
public async Task <bool> ReminderNote(int noteId, int userId, AddReminderRequest reminder)
{
return(await notes.ReminderNote(noteId, userId, reminder));
}
