internal List <ShopTemp> GetShopItemTempFromSQL() { List <ShopTemp> ShopItemTempList = new List <ShopTemp>(); using (SqlConnection connection = new SqlConnection(DBHelper.connectionString)) { using (SqlCommand cmd = new SqlCommand(GetShopItemTempFromSQLCmd())) { connection.Open(); cmd.Connection = connection; cmd.Parameters.AddWithValue("@UserID", this.UserID); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { ShopTemp shopTemp = new ShopTemp(); shopTemp.ShopItem = reader.GetString(1); shopTemp.ShopItemPrice = reader.GetDouble(2); ShopItemTempList.Add(shopTemp); } } } } return(ShopItemTempList); }
internal void UpdateClubShopItem(ShopTemp ShopTempNew) { using (SqlConnection connection = new SqlConnection(DBHelper.connectionString)) { using (SqlCommand cmd = new SqlCommand(UpdateClubShopItemCmd())) { connection.Open(); cmd.Connection = connection; cmd.Parameters.AddWithValue("@ClubShopID", this.ShopID); cmd.Parameters.AddWithValue("@ClubShopItemNew", ShopTempNew.ShopItem); cmd.Parameters.AddWithValue("@ClubShopItem", this.ShopItem); cmd.Parameters.AddWithValue("@ClubShopItemPrice", ShopTempNew.ShopItemPrice); DBHelper dBHelper = new DBHelper(); dBHelper.ExecuteNonQuery(cmd); } } }