private void LoadDataBase(ViewSelector viewSelector) { DataViewer dataViewer = new DataViewer(); ShipmentDataGridView.DataSource = dataViewer.ShowData(viewSelector); HideIdAndRenameColumns(viewSelector); }
private void LoadDataBase() { viewSelector = new ViewSelector("Date", "Organization", "City", "Country", "Manager", "Amount", "Total"); DataViewer dataViewer = new DataViewer(); ShipmentDataGridView.DataSource = dataViewer.ShowData(viewSelector); HideIdAndRenameColumns(viewSelector); viewSelector = new ViewSelector("", "", "", "", "", "", ""); }
private void HideIdAndRenameColumns(ViewSelector viewSelector) { for (int i = 0; i < ShipmentDataGridView.Columns.Count; i++) { ShipmentDataGridView.Columns[i].Visible = false; } if (viewSelector.Date != "") { ShipmentDataGridView.Columns[1].HeaderText = "Дата"; ShipmentDataGridView.Columns[1].Visible = true; } if (viewSelector.Organization != "") { ShipmentDataGridView.Columns[2].HeaderText = "Организация"; ShipmentDataGridView.Columns[2].Visible = true; } if (viewSelector.City != "") { ShipmentDataGridView.Columns[3].HeaderText = "Город"; ShipmentDataGridView.Columns[3].Visible = true; } if (viewSelector.Country != "") { ShipmentDataGridView.Columns[4].HeaderText = "Страна"; ShipmentDataGridView.Columns[4].Visible = true; } if (viewSelector.Manager != "") { ShipmentDataGridView.Columns[5].HeaderText = "Менеджер"; ShipmentDataGridView.Columns[5].Visible = true; } if (viewSelector.Amount != "") { ShipmentDataGridView.Columns[6].HeaderText = "Количство"; ShipmentDataGridView.Columns[6].Visible = true; } if (viewSelector.Total != "") { ShipmentDataGridView.Columns[7].HeaderText = "Сумма"; ShipmentDataGridView.Columns[7].Visible = true; } }
public BindingList <ShipmentClass> ShowData(ViewSelector selectedParams) { string connectString = "Data Source=DESKTOP-MF59TE3;Initial Catalog=ITEnterpriseStorage;Integrated Security=True"; SqlConnection myConnection = new SqlConnection(connectString); myConnection.Open(); var result = String.Join(", ", selectedParams.GetParameters()); if (result != "") { query = "SELECT Id, " + result + " FROM Shipment"; } else { query = "SELECT * FROM Shipment"; } finalQuery = query.ToString(); SqlCommand command = new SqlCommand(finalQuery, myConnection); SqlDataReader Reader = command.ExecuteReader(); while (Reader.Read()) { ShipmentClass shipmentClass = new ShipmentClass(); shipmentClass.Id = (Guid)Reader["Id"]; if (selectedParams.Date != "") { shipmentClass.Date = (DateTime)Reader["Date"]; } if (selectedParams.Organization != "") { shipmentClass.Organization = Reader["Organization"].ToString(); } if (selectedParams.City != "") { shipmentClass.City = Reader["City"].ToString(); } if (selectedParams.Country != "") { shipmentClass.Country = Reader["Country"].ToString(); } if (selectedParams.Manager != "") { shipmentClass.Manager = Reader["Manager"].ToString(); } if (selectedParams.Amount != "") { shipmentClass.Amount = (int)Reader["Amount"]; } if (selectedParams.Total != "") { shipmentClass.Total = (decimal)Reader["Total"]; } Transactions.Add(shipmentClass); } Reader.Close(); myConnection.Close(); return(Transactions); }