public List <NextLife> ListNextLife(int pIdGame, int pIdPlayer, int pIdHeart) { List <NextLife> list_next = new List <NextLife>(); string conn = "URI=file:" + Application.streamingAssetsPath + "/AdvScrabble.db"; //Path to database. IDbConnection dbconn; dbconn = (IDbConnection) new SqliteConnection(conn); dbconn.Open(); //Open connection to the database. IDbCommand dbcmd = dbconn.CreateCommand(); string sqlQuery = String.Format("SELECT * FROM next_life where id_game = \"{0}\" and id_player = \"{1}\" and id_heart = \"{2}\"", pIdGame, pIdPlayer, pIdHeart); dbcmd.CommandText = sqlQuery; IDataReader reader = dbcmd.ExecuteReader(); while (reader.Read()) { NextLife n = new NextLife(); n.Id_next_life = reader.GetInt32(3); n.Date_next_life = reader.GetDateTime(4); list_next.Add(n); } reader.Close(); reader = null; dbcmd.Dispose(); dbcmd = null; dbconn.Close(); dbconn = null; return(list_next); }
public void DeleteNextLife(int pIdGame, int pIdPlayer, int pIdHeart, NextLife n) { string conn = "URI=file:" + Application.streamingAssetsPath + "/AdvScrabble.db"; //Path to database. using (IDbConnection dbconn = new SqliteConnection(conn)) { dbconn.Open(); using (IDbCommand dbcmd = dbconn.CreateCommand()) { string sqlQuery = String.Format("DELETE FROM next_life WHERE id_game = \"{0}\" AND id_player = \"{1}\" AND id_heart = \"{2}\" AND id_next_life = \"{3}\"", pIdGame, pIdPlayer, pIdHeart, n.Id_next_life); dbcmd.CommandText = sqlQuery; dbcmd.ExecuteScalar(); dbconn.Close(); } } }
public void InsertNextLife(int pIdGame, int pIdPlayer, int pIdHeart, NextLife n) { n.Id_next_life = this.GetNextNextLifeIndex(); string conn = "URI=file:" + Application.streamingAssetsPath + "/AdvScrabble.db"; //Path to database. using (IDbConnection dbconn = new SqliteConnection(conn)) { dbconn.Open(); using (IDbCommand dbcmd = dbconn.CreateCommand()) { string sqlQuery = String.Format("INSERT INTO next_life (id_game, id_player,id_heart,id_next_life,date_next_life) VALUES (\"{0}\",\"{1}\",\"{2}\",\"{3}\",\"{4}\")", pIdGame, pIdPlayer, pIdHeart, n.Id_next_life, n.Date_next_life.ToString("yyyy-MM-dd HH:mm:ss")); dbcmd.CommandText = sqlQuery; dbcmd.ExecuteScalar(); dbconn.Close(); } } }
private void MinusLife() { if (UIManagerMenu.g.P.Heart.IsInfinite == false) { UIManagerMenu.g.P.Heart.Count_lifes--; NextLife n = new NextLife(); UIManagerMenu.g.P.Heart.List_next_life.Add(n); if (UIManagerMenu.g.P.Heart.List_next_life.Count == 1) { UIManagerMenu.g.P.Heart.List_next_life[UIManagerMenu.g.P.Heart.List_next_life.Count - 1].Date_next_life = DateTime.Now.AddMinutes(20); } else { UIManagerMenu.g.P.Heart.List_next_life[UIManagerMenu.g.P.Heart.List_next_life.Count - 1].Date_next_life = UIManagerMenu.g.P.Heart.List_next_life[UIManagerMenu.g.P.Heart.List_next_life.Count - 2].Date_next_life.AddMinutes(20); } new Persistence().InsertNextLife(UIManagerMenu.g.Id_game, UIManagerMenu.g.P.Id_player, UIManagerMenu.g.P.Heart.Id_heart, UIManagerMenu.g.P.Heart.List_next_life [UIManagerMenu.g.P.Heart.List_next_life.Count - 1]); new Persistence().UpdateHeart(UIManagerMenu.g.Id_game, UIManagerMenu.g.P.Id_player, UIManagerMenu.g.P.Heart); } }