예제 #1
0
 public NewDrinkScreen()
 {
     allDrinkButtons = new List<ImageButton>();
     buttonIdToIconId = new Dictionary<int, int>();
     newDrink = new DrinkItem();
     volume = 0.5;
     alcoholByVolume = 0.5;
 }
예제 #2
0
 public DrinkItem GetItem(int id)
 {
     var t = new DrinkItem();
     lock (locker)
     {
         connection = new SqliteConnection("Data Source=" + path);
         connection.Open();
         using (var command = connection.CreateCommand())
         {
             // "CREATE TABLE [Items] (_id INTEGER PRIMARY KEY ASC, Name NTEXT,
             // About NTEXT, Volume REAL, AlcoholByVolume REAL, IconNumber INTEGER);"
             command.CommandText = "SELECT [_id], [Name], [About], [Volume], [AlcoholByVolume], [IconNumber] from [Items] WHERE [_id] = ?";
             command.Parameters.Add(new SqliteParameter(DbType.Int32) { Value = id });
             var r = command.ExecuteReader();
             while (r.Read())
             {
                 t = FromReader(r);
                 break;
             }
         }
         connection.Close();
     }
     return t;
 }
예제 #3
0
 public static int SaveDrink(DrinkItem item)
 {
     return DrinkItemRepositoryADO.SaveDrink(item);
 }
예제 #4
0
 public static int SaveDrink(DrinkItem item)
 {
     return me.db.SaveItem(item);
 }
예제 #5
0
 DrinkItem FromReader(SqliteDataReader r)
 {
     var t = new DrinkItem();
     t.ID = Convert.ToInt32(r["_id"]);
     t.Name = r["Name"].ToString();
     t.AlcoholByVolume = Convert.ToDouble(r["AlcoholByVolume"]);
     t.Volume = Convert.ToDouble(r["Volume"]);
     t.IconId = Convert.ToInt32(r["IconNumber"]);
     t.About = r["About"].ToString();
     return t;
 }
예제 #6
0
        public int SaveItem(DrinkItem item)
        {
            int r;
            lock (locker)
            {
                if (item.ID != 0)
                {
                    connection = new SqliteConnection("Data Source=" + path);
                    connection.Open();
                    using (var command = connection.CreateCommand())
                    {
                        // SELECT [_id], [Name], [About], [Volume], [AlcoholByVolume], [IconNumber]
                        command.CommandText = "UPDATE [Items] SET [Name] = ?, [About] = ?, [Volume] = ?, [AlcoholByVolume] = ?, [IconNumber] = ? WHERE [_id] = ?;";
                        command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Name });
                        command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.About });
                        command.Parameters.Add(new SqliteParameter(DbType.Double) { Value = item.Volume });
                        command.Parameters.Add(new SqliteParameter(DbType.Double) { Value = item.AlcoholByVolume });
                        command.Parameters.Add(new SqliteParameter(DbType.Int32) { Value = item.IconId });
                        r = command.ExecuteNonQuery();
                    }
                    connection.Close();
                    return r;
                }
                else
                {
                    connection = new SqliteConnection("Data Source=" + path);
                    connection.Open();
                    using (var command = connection.CreateCommand())
                    {
                        command.CommandText = "INSERT INTO [Items] ( [Name], [About], [Volume], [AlcoholByVolume], [IconNumber]) VALUES (? ,?, ?, ?, ?)";
                        command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.Name });
                        command.Parameters.Add(new SqliteParameter(DbType.String) { Value = item.About });
                        command.Parameters.Add(new SqliteParameter(DbType.Double) { Value = item.Volume });
                        command.Parameters.Add(new SqliteParameter(DbType.Double) { Value = item.AlcoholByVolume });
                        command.Parameters.Add(new SqliteParameter(DbType.Int32) { Value = item.IconId });
                        r = command.ExecuteNonQuery();
                    }
                    connection.Close();
                    return r;
                }

            }
        }