Exemple #1
0
        public List <ClothesModels> GetClothes()
        {
            string sqlExpression = "GetClothes";

            using (SqlConnection connection = new SqlConnection(cs))
            {
                connection.Open();
                using (SqlCommand command = new SqlCommand(sqlExpression, connection))
                {
                    List <ClothesModels> clothes = new List <ClothesModels>()
                    {
                    };
                    var reader = command.ExecuteReader();
                    if (reader.HasRows)
                    {
                        Console.WriteLine("{0}\t{1}\t{2}\t{3}", reader.GetName(0), reader.GetName(1), reader.GetName(2), reader.GetName(3));
                        while (reader.Read())
                        {
                            ClothesModels clothe = new ClothesModels();
                            clothe.id       = Convert.ToInt32(reader["id"]);
                            clothe.name     = reader["name"].ToString();
                            clothe.size     = Convert.ToInt32(reader["size"]);
                            clothe.quantity = Convert.ToInt32(reader["quantity"]);
                            clothe.ToString();
                            clothes.Add(clothe);
                        }
                    }
                    reader.Close();
                    return(clothes);
                }
            }
        }
Exemple #2
0
        public List <ClothesModels> SortFieldClothes(string SortField)
        {
            string sqlExpression = "SortFieldClothes";

            using (SqlConnection connection = new SqlConnection(cs))
            {
                connection.Open();
                using (SqlCommand command = new SqlCommand(sqlExpression, connection))
                {
                    command.CommandType = System.Data.CommandType.StoredProcedure;
                    SqlParameter SortFieldParam = new SqlParameter
                    {
                        ParameterName = "@SortField",
                        Value         = SortField
                    };
                    command.Parameters.Add(SortFieldParam);
                    List <ClothesModels> clothes = new List <ClothesModels>()
                    {
                    };
                    var reader = command.ExecuteReader();
                    if (reader.HasRows)
                    {
                        Console.WriteLine("{0}\t{1}\t{2}\t{3}", reader.GetName(0), reader.GetName(1), reader.GetName(2), reader.GetName(3));
                        while (reader.Read())
                        {
                            ClothesModels clothe = new ClothesModels();
                            clothe.id       = Convert.ToInt32(reader["id"]);
                            clothe.name     = reader["name"].ToString();
                            clothe.size     = Convert.ToInt32(reader["size"]);
                            clothe.quantity = Convert.ToInt32(reader["quantity"]);
                            clothe.ToString();
                            clothes.Add(clothe);
                        }
                    }
                    reader.Close();
                    return(clothes);
                }
            }
        }