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