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