コード例 #1
0
        public void Compra(int Request, Prodotto prodotto)
        {
            SqlConnection connection = new SqlConnection(GetConnection());

            connection.Open();
            SqlCommand command = new SqlCommand("AddOrdine", connection);

            command.CommandType = System.Data.CommandType.StoredProcedure;
            command.Parameters.Add("@Richiesta", System.Data.SqlDbType.Int).Value = Request;
            command.Parameters.Add("@Prodotti", System.Data.SqlDbType.Int).Value  = prodotto.Id;
            command.Parameters.Add("@Quantita", System.Data.SqlDbType.Int).Value  = prodotto.Quantita;
            command.ExecuteNonQuery();
            command.Dispose();
            connection.Close();
        }
コード例 #2
0
        public int RichiestaOrdine()
        {
            int             Request    = 0;
            Prodotto        product    = new Prodotto();
            List <Prodotto> Listona    = new List <Prodotto>();
            SqlConnection   connection = new SqlConnection(GetConnection());

            connection.Open();
            SqlCommand command = new SqlCommand("Request", connection);

            command.CommandType = System.Data.CommandType.StoredProcedure;
            command.Parameters.Add("@data", SqlDbType.DateTime).Value = DateTime.Now.ToString("dd-MM-yyyy");
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                Request = (int)reader.GetDecimal(0);
            }
            reader.Close();
            command.Dispose();
            return(Request);
        }
コード例 #3
0
        public Prodotto RicercaperID(int Cod)
        {
            Prodotto      product    = new Prodotto();
            SqlConnection connection = new SqlConnection(GetConnection());

            connection.Open();
            SqlCommand command = new SqlCommand("RicercaID", connection);

            command.CommandType = System.Data.CommandType.StoredProcedure;
            command.Parameters.Add("@Id", SqlDbType.Int).Value = Cod;
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                product.Id          = (int)reader.GetInt32(0);
                product.Descrizione = (string)reader.GetValue(1);
                product.Quantita    = (int)reader.GetInt32(2);
            }
            reader.Close();
            connection.Close();

            return(product);
        }
コード例 #4
0
        public List <Prodotto> RicercaperDescrizione(string Desc)
        {
            Prodotto      product    = new Prodotto();
            SqlConnection connection = new SqlConnection(GetConnection());

            connection.Open();
            List <Prodotto> Listona = new List <Prodotto>();
            SqlCommand      command = new SqlCommand("RicercaDESC", connection);

            command.CommandType = System.Data.CommandType.StoredProcedure;
            command.Parameters.Add("@Desc", SqlDbType.NVarChar).Value = Desc;
            SqlDataReader reader = command.ExecuteReader();

            while (reader.Read())
            {
                product.Id          = (int)reader.GetInt32(0);
                product.Descrizione = (string)reader.GetValue(1);
                product.Quantita    = (int)reader.GetInt32(2);
                Listona.Add(product);
            }
            reader.Close();
            connection.Close();
            return(Listona);
        }
コード例 #5
0
 protected void Page_Load(object sender, EventArgs e)
 {
     prodotto = new Prodotto();
 }