/// <summary>
/// Add the student to list
/// </summary>
/// <param name="dto"></param>
/// <returns></returns>
public async Task <ResponseDto> AddStudentAsync(StudentDto dto)
{
IDbConnection connection = Connection;
dto.UpdateCreatedAuditFields();
string sql = string.Format("insert into StudentManagement (FirstName, LastName, Age, Gpa,ClassId, CreatedDate) values ('{0}', '{1}', {2}, {3},{4}, '{5}')",
dto.FirstName, dto.LastName, dto.Age, dto.Gpa, dto.ClassId, dto.CreatedDate);
var data = await connection.ExecuteAsync(sql, null, transaction : Transaction);
return(new ResponseDto()
{
ResponseCode = ResponseCode.SUCCESS
});
}