Exemple #1
0
        private void retrieveShipment_Click(object sender, EventArgs e)
        {
            using (SqlConnection sqlCon = new SqlConnection(connectionString))
            {
                SqlShipmentRepository    shipment     = new SqlShipmentRepository(connectionString);
                IReadOnlyList <Shipment> shipmentList = shipment.RetrieveShipments();
                dataGridView1.DataSource = shipmentList;
            }

            for (int i = 0; i < dataGridView1.Columns.Count; i++)
            {
                DataGridViewColumn columnOne = dataGridView1.Columns[0];
                columnOne.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
            }
        }
Exemple #2
0
        private void CreateShipmentButton_Click(object sender, EventArgs e)
        {
            try
            {
                SqlShipmentRepository shipments = new SqlShipmentRepository(connectionString);

                Shipment createShipment = shipments.CreateShipment(Convert.ToDateTime(ShipmentDateTextbox.Text), ShipmentAddressTextbox.Text);
                list.Add(createShipment);

                ShipmentsData sd = new ShipmentsData();
                sd.dataGridView1.DataSource = list;
            }
            catch (Exception ex)
            {
                MessageBox.Show("There cannot be any empty or incorrectly entered parameters. Check submission.");
            }
        }
Exemple #3
0
        private void RecieveShipmentDate_Click(object sender, EventArgs e)
        {
            try
            {
                SqlShipmentRepository shipments = new SqlShipmentRepository(connectionString);

                Shipment        s    = shipments.FetchShipmentDate(Convert.ToInt32(OrderIdTextbox.Text));
                List <Shipment> list = new List <Shipment>();
                list.Add(s);
                dataGridView1.DataSource = list;

                for (int i = 0; i < dataGridView1.Columns.Count; i++)
                {
                    DataGridViewColumn columnOne = dataGridView1.Columns[0];
                    columnOne.AutoSizeMode = DataGridViewAutoSizeColumnMode.Fill;
                }
            }catch (Exception ex)
            {
                MessageBox.Show("Incorrect input. Parameter takes an integer.");
            }
        }