public async Task <NewRouletteResponse> NewRoulette() { NewRouletteResponse response = new NewRouletteResponse(); using (var ctx = GetInstance()) { string query = "INSERT INTO Roulette (State, Bet) VALUES (0, 0)"; using (var command = new SQLiteCommand(query, ctx)) { command.ExecuteNonQuery(); } query = "SELECT id FROM Roulette ORDER by id DESC LIMIT 1"; using (var command = new SQLiteCommand(query, ctx)) { using (var reader = command.ExecuteReader()) { while (reader.Read()) { response.id = Convert.ToInt32(reader[0]); } } } } return(response); }
public async Task <BaseResponse <NewRouletteResponse> > NewRoulete() { try { NewRouletteResponse response = await DbContex.NewRoulette(); if (response.id == 0) { return new BaseResponse <NewRouletteResponse> { Reponse = null, message = "Can't create roulette" } } ; return(new BaseResponse <NewRouletteResponse> { Reponse = response }); } catch (Exception ex) { return(new BaseResponse <NewRouletteResponse> { Reponse = null, message = "ERROR: " + ex.Message }); } }