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);
}
}
