public Point_Shop_Item SelectById(string Point_Shop_Item_Id)
{
string connStr = ConfigurationManager.ConnectionStrings["ggna"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
string query = "SELECT * FROM Point_Shop_Item WHERE Point_Shop_Item_Id = @point_shop_item_id";
SqlDataAdapter da = new SqlDataAdapter(query, conn);
da.SelectCommand.Parameters.AddWithValue("@point_shop_item_id", Point_Shop_Item_Id);
DataSet ds = new DataSet();
da.Fill(ds);
Point_Shop_Item item = null;
int count = ds.Tables[0].Rows.Count;
if (count == 1)
{
DataRow row = ds.Tables[0].Rows[0];
string name = row["name"].ToString();
string partner = row["partner"].ToString();
string partner_email = row["partner_email"].ToString();
string description = row["description"].ToString();
int price = (int)row["price"];
string image = row["image"].ToString();
string type = row["type"].ToString();
string qr = row["qr"].ToString();
item = new Point_Shop_Item(name, partner, partner_email, description, price, image, type);
}
return(item);
}
public List <Point_Shop_Item> SelectAll()
{
string connStr = ConfigurationManager.ConnectionStrings["ggna"].ConnectionString;
SqlConnection conn = new SqlConnection(connStr);
string query = "SELECT * FROM Gem";
SqlDataAdapter da = new SqlDataAdapter(query, conn);
DataSet ds = new DataSet();
da.Fill(ds);
List <Point_Shop_Item> itemList = new List <Point_Shop_Item>();
int count = ds.Tables[0].Rows.Count;
for (int i = 0; i < count; i++)
{
DataRow row = ds.Tables[0].Rows[0];
string name = row["name"].ToString();
string partner = row["partner"].ToString();
string partner_email = row["partner_email"].ToString();
string description = row["description"].ToString();
int price = (int)row["price"];
string image = row["image"].ToString();
string type = row["type"].ToString();
string qr = row["qr"].ToString();
Point_Shop_Item item = new Point_Shop_Item(name, partner, partner_email, description, price, image, type);
itemList.Add(item);
}
return(itemList);
}
