示例#1
0
    //Get Product//
    public List <fitassitant> getProductAll()
    {
        List <fitassitant> prodList = new List <fitassitant>();
        string             topsize, bottomsize, footlength;
        decimal            height, weight;

        string        queryStr = "SELECT * FROM Fit Order By height";
        SqlConnection conn     = new SqlConnection(_connStr);
        SqlCommand    cmd      = new SqlCommand(queryStr, conn);

        conn.Open();
        SqlDataReader dr = cmd.ExecuteReader();

        //Continue to read the resultsets row by row if not the end
        while (dr.Read())
        {
            height     = decimal.Parse(dr["height"].ToString());
            weight     = decimal.Parse(dr["weight"].ToString());
            topsize    = dr["topsize"].ToString();
            bottomsize = dr["bottomsize"].ToString();
            footlength = (dr["footlength"].ToString());

            fitassitant a = new fitassitant(height, weight, topsize, bottomsize, footlength);
            prodList.Add(a);
        }
        conn.Close();
        dr.Close();
        dr.Dispose();
        return(prodList);
    }
示例#2
0
    // Get measurement//
    public fitassitant getmeasure(decimal height)
    {
        fitassitant detail = null;
        decimal     Height, Weight;
        string      topSize, bottomSize, footlength;


        string        queryStr = "SELECT * FROM Fit WHERE height= @height";
        SqlConnection conn     = new SqlConnection(_connStr);
        SqlCommand    cmd      = new SqlCommand(queryStr, conn);

        cmd.Parameters.AddWithValue("@Height", this.height);
        conn.Open();
        SqlDataReader dr = cmd.ExecuteReader();


        if (dr.Read())
        {
            Height     = decimal.Parse(dr["height"].ToString());
            Weight     = decimal.Parse(dr["weight"].ToString());
            topSize    = dr["topSize"].ToString();
            bottomSize = dr["bottomSize"].ToString();
            footlength = dr["footlength"].ToString();
            detail     = new fitassitant();
        }
        else
        {
            detail = null;
        }

        conn.Close();
        dr.Close();
        dr.Dispose();
        return(detail);
    }