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