private async Task <UserEmailModal> getEmailAddress(string userID)
{
string conn = ConfigurationManager.ConnectionStrings["PhysioDatabaseConnection"].ConnectionString;
SqlConnection connection = new SqlConnection(conn);
string cmd = "SELECT Email FROM [dbo].[AspNetUsers] Where Id = '" + userID + "';";
UserEmailModal userEmail = new UserEmailModal();
using (SqlCommand command = new SqlCommand(cmd, connection))
{
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
while (reader.Read())
{
userEmail.EmailAddress = reader.GetString(0);
}
}
connection.Close();
}
return(userEmail);
}
public async Task UpdateExerciseEmail()
{
string[] keys = Request.Form.AllKeys;
List <AssignedExerciseViewModal> tableData = JsonConvert.DeserializeObject <List <AssignedExerciseViewModal> >(Request.Form[keys[0]]);
string userID = Request.Form[keys[1]];
UserEmailModal userEmail = await getEmailAddress(userID);
string htmlTabel = ComposeUpdateTable(tableData, Request.Form[keys[2]]);
await sendUpdateEmail(htmlTabel, userEmail.EmailAddress);
}
