private void DGVItemsView()
{
DGVMainData.setName(DataGridViewNew.DGVMainDataNames.items.ToString());
string[,] columns =
{
{ "id", "ID" },
{ "name", "Nazwa" },
{ "category", "Kategoria" },
{ "status", "Status" },
{ "room", "Pokój" },
{ "wardrobe", "Szafa" },
{ "shelf", "Półka" },
};
DGVMainData.AddColumns(columns);
var query = queries.getGridViewItem();
foreach (var item in query)
{
DGVMainData.Rows.Add(item.id, item.name, item.category, item.status,
item.room, item.wardorobe, item.shelf);
}
DGVMainData.changeIdColumnVisableToFalse();
}
private void DGVItemsView()
{
DGVMainData.clearRowsAndColumns();
DGVMainData.setName(DataGridViewNew.DGVMainDataNames.items.ToString());
string[,] columns =
{
{ "id", "ID" },
{ "name", "Nazwa" },
{ "category", "Kategoria" },
{ "status", "Status" },
{ "rooms", "Pokój" },
{ "wardrobe", "Szafa" },
{ "shelf", "Szuflada" },
};
DGVMainData.AddColumns(columns);
string name = textBoxItemName.Text;
string status = "";
string category = "";
string room = "";
string wardrobe = "";
try
{
status = ComboboxesImproved.getComboboxByName(ComboboxesImproved.names.status).SelectedItem.ToString();
}
catch { }
try
{
category = ComboboxesImproved.getComboboxByName(ComboboxesImproved.names.category).SelectedItem.ToString();
}
catch { }
try
{
room = ComboboxesImproved.getComboboxByName(ComboboxesImproved.names.room).SelectedItem.ToString();
}
catch { }
try
{
wardrobe = ComboboxesImproved.getComboboxByName(ComboboxesImproved.names.wardrobe).SelectedItem.ToString();
}
catch { }
var query = queries.getGridViewItemByName(name, category, status, wardrobe, room);
foreach (var item in query)
{
DGVMainData.Rows.Add(item.id, item.name, item.category, item.status,
item.room, item.wardorobe, item.shelf);
}
DGVMainData.changeIdColumnVisableToFalse();
}
public void refreashGrid()
{
string[,] columns =
{
{ "id", "ID" },
{ "name", "Nazwa" },
{ "category", "Kategoria" },
{ "status", "Status" },
{ "room", "Pokój" },
{ "wardrobe", "Szafa" },
{ "shelf", "Półka" },
};
grid.AddColumns(columns);
addItemsToGrid(grid);
}
private void DTVLastItemsFillColumns()
{
string [,] columns =
{
{ "id", "ID" },
{ "name", "Nazwa" },
{ "category", "Kategoria" },
{ "date", "Dni temu" }
};
DGVLastItems.AddColumns(columns);
var query = queries.getGridViewLastItems();
foreach (var item in query.OrderByDescending(X => X.modify_date).Take(7))
{
var calculatedDays = Utils.compareDateToNowAndGetDaysCount((DateTime)item.modify_date);
DGVLastItems.Rows.Add(item.id, item.name, item.category, calculatedDays);
}
DGVLastItems.changeIdColumnVisableToFalse();
}
