//Insert 1 location object public CreateLocationResult Post(CreateLocation request) { Db.ExecuteSql("INSERT INTO location (address, x, y, geom) Values ('" + request.address + "','" + request.x + "','" + request.y + "', ST_GeomFromText('POINT(" + request.x + " " + request.y + ")', 3414))"); long id = Db.GetLastInsertId(); var location = Db.GetByIdOrDefault<Location>(id); if (location == null) { throw new HttpError(HttpStatusCode.NotFound, new ArgumentException("Location does not exist: " + id.ToString())); } return new CreateLocationResult { Location = location }; }
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); }