public async Task <IActionResult> Put(int id, StudentClassificationModel model)
{
var username = ApplicationUtility.GetTokenAttribute(Request.Headers["Authorization"], "sub");
var service = new StudentClassificationRepository(connString);
await service.UpdateStudentClassification(id, model, username);
var response = new GenericResponse <string>()
{
IsSuccess = true,
Message = "Student classification updated successfully.",
ResponseCode = 200,
Result = "Success"
};
return(Ok(response));
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <param name="model"></param>
/// <param name="actor"></param>
/// <returns></returns>
public async Task UpdateStudentClassification(int id, StudentClassificationModel model, string actor)
{
try
{
await _connection.OpenAsync();
var cmd = new MySqlCommand("Update_StudentClassification", _connection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("StudentClassificationIdVal", id);
cmd.Parameters.AddWithValue("ClassIdVal", model.ClassId);
cmd.Parameters.AddWithValue("SectionIdVal", model.SectionId);
cmd.Parameters.AddWithValue("UpdatedByVal", actor);
cmd.ExecuteNonQuery();
}
catch { throw; }
finally { await _connection.CloseAsync(); }
}
