//Popunjavanje Data Table
#region PopunjavanjeDataTable
private void PopulateGrid()
{
panelPanelZaGV.Controls.Clear();
DataTable dt = new DataTable();
//logika za popunjavanje datatable
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
myProperty.GetSelectQuery());
if (myProperty.GetType() == typeof(PropertyOsoba))
{
PropertyOsoba pom = myProperty as PropertyOsoba;
reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
pom.GetSelectQueryRadnik());
}
if (myProperty.GetType() == typeof(PropertyKlijent))
{
PropertyKlijent pom = myProperty as PropertyKlijent;
reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
pom.GetSelectQueryZaFakturu());
}
if (myProperty.GetType() == typeof(PropertyModelVozila))
{
PropertyModelVozila pom = myProperty as PropertyModelVozila;
reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
pom.GetSelectLookUp());
}
dt.Load(reader);
reader.Close();
dgv.DataSource = dt;
dgv.BackgroundColor = Color.White;
dgv.HeaderBgColor = Color.CadetBlue;
panelPanelZaGV.Controls.Add(dgv);
dgv.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dgv.MultiSelect = false;
dgv.Dock = DockStyle.Fill;
dgv.Size = panelPanelZaGV.Size;
//izvuci display name
var type = myProperty.GetType();
var properties = type.GetProperties();
try
{
//promjeniti nazive kolona
foreach (DataGridViewColumn item in dgv.Columns)
{
item.HeaderText = properties.Where(x => x.GetCustomAttributes <SqlNameAttribute>()
.FirstOrDefault().Name == item.HeaderText).FirstOrDefault()
.GetCustomAttributes <DisplayNameAttribute>().FirstOrDefault().DisplayName;
}
}
catch { }
//design
//boja teksta i pozadina kada selektujemo item
dgv.DefaultCellStyle.SelectionBackColor = Color.FromArgb(44, 46, 62);
dgv.DefaultCellStyle.SelectionForeColor = Color.WhiteSmoke;
//boja header teksta u tabeli
dgv.ColumnHeadersDefaultCellStyle.ForeColor = Color.WhiteSmoke;
}
