public bool CreateMentorReportCard([FromBody] MentorReportCard reportCardBody)
{
MentorReportCard requestBody = reportCardBody;
Console.WriteLine("REPORT CARD BODY");
Console.WriteLine(reportCardBody);
Console.WriteLine("END REPORT CARD BODY");
ReportCardService service = new ReportCardService();
try
{
Console.WriteLine("Callling Service");
service.createMentorReportCard(requestBody);
}
catch (Exception e)
{
Console.WriteLine($"Failed to save to db: {e}");
}
return(true);
}
public void createMentorReportCard(MentorReportCard requestBody)
{
MentorReportCard body = new MentorReportCard();
body.mentorType = (requestBody.mentorType == null) ? 8 : 0;
body.mentorReportCardId = (requestBody.mentorReportCardId == null) ? 9 : 0;
Console.WriteLine("In CreateMentoreReportCard");
string sql = "INSERT INTO MentorReportCards (MentorReportCardID, MentorType) VALUES (@mentorReportCardID, @mentorType);";
using (var dbConn = new MySqlConnection(conn_string.ToString()))
{
try
{
Console.WriteLine("attempting sql execute");
dbConn.Execute(sql, new { mentorReportCardID = body.mentorReportCardId, mentorType = body.mentorType });
}
catch (Exception e)
{
Console.WriteLine($"Failed to execute query: {e}");
}
}
}