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