public int CreateStudent(StudentDet info)
{
var connectionString = _configuration.GetConnectionString("BotDatabase");
var firstName = info.FirstName;
var lastName = info.LastName;
var userId = info.UserId;
using (var conn = new MySqlConnection(connectionString))
{
conn.Open();
var countSql = "SELECT COUNT(*) FROM student WHERE user_id=@UserId";
var num_stud = conn.ExecuteScalar <int>(countSql, new { userId });
if (num_stud == 1)
{
return(409);
}
else
{
var sqlQuery = "INSERT INTO student(first_name, last_name, user_id) VALUES (@FirstName,@LastName,@UserId)";
conn.Execute(sqlQuery,
new
{
firstName,
lastName,
userId
});
}
}
return(0);
}
public async Task <IActionResult> CreateStudent(StudentDet info)
{
int result = _repository.CreateStudent(info);
if (result == 409)
{
return(StatusCode(409));
}
return(Accepted());
}