//Insert 1 analysis object public CreateAnalysisResult Post(CreateAnalysis request) { Db.ExecuteSql("INSERT INTO analysis (abuseper, totalframe, smileframe, angryframe, sadframe, neutralframe, leftfistframe, rightfistframe, leftpalmframe, rightpalmframe, soundresult, soundpath, feverresult) Values ('" + request.abuseper + "', '" + request.totalframe + "','" + request.smileframe + "','" + request.angryframe + "', '" + request.sadframe + "', '" + request.neutralframe + "', '" + request.leftfistframe + "', '" + request.rightfistframe + "', '" + request.leftpalmframe + "', '" + request.rightpalmframe + "', '" + request.soundresult + "', '" + request.soundpath + "', '" + request.feverresult + "')"); long id = Db.GetLastInsertId(); var analysis = Db.GetByIdOrDefault<Analysis>(id); if (analysis == null) { throw new HttpError(HttpStatusCode.NotFound, new ArgumentException("Analysis does not exist: " + id.ToString())); } return new CreateAnalysisResult { Analysis = analysis }; }
private void insertRecord(CreateAnalysis cAna, CreateLocation cLoc, CreateFile cFile) { AnalysisService analysis = new AnalysisService(); CreateAnalysisResult anaResult = analysis.Post(cAna); int analysisID = anaResult.Analysis.ID; cFile.analysisid = analysisID; LocationsService location = new LocationsService(); CreateLocationResult locResult = location.Post(cLoc); int locationID = locResult.Location.ID; cFile.locationid = locationID; FileService file = new FileService(); file.Post(cFile); }
private void insertIntoDatabase() { abuseper = 0; //Face if (angry > smile && angry > sad && angry > neutral && angry > noDetect) { abuseper = abuseper + 25; } //Motion if ((((leftfist + rightfist + leftpalm + rightpalm) / totalFrame) * 100) > 20) { abuseper = abuseper + 25; } //Sound if (soundresult == true) { abuseper = abuseper + 25; } //Heat if (feverresult >= 50) { abuseper = abuseper + 25; } CreateAnalysis cAna = new CreateAnalysis(abuseper, totalFrame, smile, angry, sad, neutral, leftfist, rightfist, leftpalm, rightpalm, soundresult, soundpath, feverresult); CreateLocation cLoc = new CreateLocation(address, x, y); CreateFile cFile = new CreateFile(title, date, path, desc, type); insertRecord(cAna, cLoc, cFile); }