private void PopulateGrid()
{
DataTable dt = new DataTable();
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
myProperty.GetLookupQuery());
dt.Load(reader);
reader.Close();
lookupGrid.DataSource = dt;
var type = myProperty.GetType();
var properties = type.GetProperties();
foreach (DataGridViewColumn item in lookupGrid.Columns)
{
item.HeaderText = properties.Where(x => x.GetCustomAttributes <SqlNameAttribute>().FirstOrDefault().Name == item.HeaderText
).FirstOrDefault().GetCustomAttributes <DisplayNameAttribute>().FirstOrDefault().DisplayName;
}
}
//Funkcija za popunjavanje kontrole u Input formi
private void PopunjavanjeKontrola(PropertyInfo item)
{
if (item.GetCustomAttributes <BrowsableAttribute>().Count() > 0)
{
//f-ja koja provjerava da li ima BrowsableAttribute ako ima da se ne prikazuje na input formi
return;
}
//Dodavanje kontrole za datum
if (item.PropertyType.Name == "DateTime")
{
InputDateControl uc = new InputDateControl();
uc.Name = item.Name;
uc.SetLabel(item.GetCustomAttributes <DisplayNameAttribute>().FirstOrDefault().DisplayName);
if (state == StateEnum.Update)
{
try
{
uc.SetValueInDateBox(item.GetValue(myInterface).ToString());
}
catch { }
}
//provjera da li smo kliknuli na detalje ako jesmo da polje bude samo read only
if (Detalji == "detalji")
{
uc.ReadOnly();
}
flowPanel.Controls.Add(uc);
}
//Dodavanje kontrole za Lookup
else if (item.GetCustomAttributes <Attributes.ForeignKeyAttribute>() != null && item.Name.Contains("ID"))
{
PropertyInterface foreignKeyInterface = Assembly.GetExecutingAssembly().
CreateInstance(item.GetCustomAttribute <ForeignKeyAttribute>().ClassName)
as PropertyInterface;
LookUpControl uc = new LookUpControl(foreignKeyInterface, userEmail, Id);
uc.Name = item.Name;
uc.SetLabel(item.GetCustomAttributes <DisplayNameAttribute>().FirstOrDefault().DisplayName);
if (uc.GetLabelValue() == "Radnik ID")
{
uc.SetValueTextBox(Id, userEmail);
}
//provjera da li smo kliknuli na detalje ako jesmo da polje bude samo read only
if (Detalji == "detalji")
{
uc.ReadOnly();
}
if (state == StateEnum.Update)
{
try
{
string broj = item.GetValue(myInterface).ToString();
string red = "";
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
foreignKeyInterface.GetSelectQueryZaJedanItem(broj));
DataTable dt = new DataTable();
dt.Load(reader);
if (uc.GetLabelValue() == "Radnik ID")
{
PropertyOsoba pom = new PropertyOsoba();
broj = dt.Rows[0][1].ToString();
reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
pom.GetSelectQueryZaJedanItem(broj));
dt = new DataTable();
dt.Load(reader);
}
//treba dodati i za ostale property-e sta treba da se prikaze u lookup polju
if (myInterface.GetType() == typeof(PropertyKlijent))
{
red = dt.Rows[0].ItemArray[1].ToString() + " " + dt.Rows[0].ItemArray[2].ToString();
}
else if (myInterface.GetType() == typeof(PropertyFaktura) && item.Name == "KlijentID")
{
DataTable dtpom = new DataTable();
bool prop = true;
foreach (PropertyInfo itemPom in foreignKeyInterface.GetType().GetProperties())
{
//Izbacivanje prikaza primarnog kljuca
if (prop == false)
{
if (itemPom.Name.Contains("ID"))
{
string klasa = itemPom.GetCustomAttributes <ForeignKeyAttribute>().FirstOrDefault().ClassName;
foreignKeyInterface = Assembly.GetExecutingAssembly().
CreateInstance(klasa) as PropertyInterface;
reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
foreignKeyInterface.GetLookupQuery(dt.Rows[0].ItemArray[1].ToString()));
dtpom.Load(reader);
}
}
prop = false;
}
red = dtpom.Rows[0].ItemArray[0].ToString();
}
else if (uc.GetLabelValue() == "Model ID")
{
PropertyProizvodjac pom = new PropertyProizvodjac();
broj = dt.Rows[0][2].ToString();
red = dt.Rows[0].ItemArray[1].ToString();
reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
pom.GetSelectQueryZaJedanItem(broj));
dt = new DataTable();
dt.Load(reader);
red += " " + dt.Rows[0].ItemArray[1].ToString();
}
else if (myInterface.GetType() == typeof(PropertyCijena) && item.Name == "VoziloID")
{
DataTable dtpom = new DataTable();
bool prop = true;
foreach (PropertyInfo itemPom in foreignKeyInterface.GetType().GetProperties())
{
//Izbacivanje prikaza primarnog kljuca
if (prop == false)
{
if (itemPom.Name.Contains("ID"))
{
string klasa = itemPom.GetCustomAttributes <ForeignKeyAttribute>().FirstOrDefault().ClassName;
foreignKeyInterface = Assembly.GetExecutingAssembly().
CreateInstance(klasa) as PropertyInterface;
reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
foreignKeyInterface.GetLookupQuery(dt.Rows[0].ItemArray[1].ToString()));
dtpom.Load(reader);
reader.Close();
red = dtpom.Rows[0].ItemArray[0].ToString();
bool prop1 = true;
foreach (PropertyInfo itemPom1 in foreignKeyInterface.GetType().GetProperties())
{
//Izbacivanje prikaza primarnog kljuca
if (prop1 == false)
{
if (itemPom1.Name.Contains("ID"))
{
string klasa1 = itemPom1.GetCustomAttributes <ForeignKeyAttribute>().FirstOrDefault().ClassName;
foreignKeyInterface = Assembly.GetExecutingAssembly().
CreateInstance(klasa1) as PropertyInterface;
reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
foreignKeyInterface.GetLookupQuery(dtpom.Rows[0].ItemArray[1].ToString()));
dtpom = new DataTable();
dtpom.Load(reader);
red += " " + dtpom.Rows[0].ItemArray[0].ToString();
break;
}
}
prop1 = false;
}
break;
}
}
prop = false;
}
}
else
{
red = dt.Rows[0].ItemArray[1].ToString();
try
{
red += " " + dt.Rows[0].ItemArray[2].ToString();
}
catch { }
}
reader.Close();
uc.SetValueTextBox(item.GetValue(myInterface).ToString(), red);
}
catch { }
}
flowPanel.Controls.Add(uc);
}
//Dodavanje kontrole za 2 radio dugmica
else if (item.GetCustomAttribute <TwoRadioButtonsAttribute>() != null)
{
TwoRadioButtonsControl uc = new TwoRadioButtonsControl();
uc.Name = item.Name;
uc.SetLabel(item.GetCustomAttributes <DisplayNameAttribute>().FirstOrDefault().DisplayName);
uc.SetRadioButtons(item.GetCustomAttribute <TwoRadioButtonsAttribute>().Value1, item.GetCustomAttribute <TwoRadioButtonsAttribute>().Value2);
//provjera da li smo kliknuli na detalje ako jesmo da polje bude samo read only
if (Detalji == "detalji")
{
uc.ReadOnly();
}
if (state == StateEnum.Update)
{
try
{
uc.SetChecked(item.GetValue(myInterface).ToString());
}
catch { }
}
flowPanel.Controls.Add(uc);
}
else if (item.GetCustomAttribute <ComboBoxAttribute>() != null)
{
ComboBoxControl uc = new ComboBoxControl();
uc.Name = item.Name;
uc.SetLabel(item.GetCustomAttributes <DisplayNameAttribute>().FirstOrDefault().DisplayName);
uc.FillComboBox(item.GetCustomAttribute <ComboBoxAttribute>().vrijednosti);
if (Detalji == "detalji")
{
uc.ReadOnly();
}
if (state == StateEnum.Update)
{
try
{
uc.SetComboBox(item.GetValue(myInterface).ToString());
}
catch { }
}
flowPanel.Controls.Add(uc);
}
//Dodavanje kontrole za TextBox
else
{
InputControl uc = new InputControl();
uc.Name = item.Name;
if (uc.Name == "Napomena")
{
uc.SetValueInTextBox(" ");
}
uc.SetLabel(item.GetCustomAttributes <DisplayNameAttribute>().FirstOrDefault().DisplayName);
if (Detalji == "detalji")
{
uc.ReadOnly();
}
if (state == StateEnum.Update)
{
try
{
uc.SetValueInTextBox(item.GetValue(myInterface).ToString());
}
catch { }
}
flowPanel.Controls.Add(uc);
}
}
//Najbolja metoda koju je iko ikad napravio
#region MetodaZaKupljenjePodatakaZaLookUp
public void LookUpKupljenje(PropertyInfo[] properties, DataGridViewRow row)
{
string columnName = properties.Where(x => x.GetCustomAttribute <LookupKeyAttribute>() != null)
.FirstOrDefault().GetCustomAttribute <SqlNameAttribute>().Name;
//dodan try/catch block by MARKO
try
{
Key = row.Cells[columnName].Value.ToString();
}
catch
{ return; }
columnName = properties.Where(x => x.GetCustomAttribute <LookupValueAttribute>() != null)
.FirstOrDefault().GetCustomAttribute <SqlNameAttribute>().Name;
if (columnName.Contains("ID"))
{
PropertyInterface foreignKeyInterface = Assembly.GetExecutingAssembly().
CreateInstance(properties.Where(x => x.GetCustomAttribute <ForeignKeyAttribute>() != null)
.FirstOrDefault().GetCustomAttribute <ForeignKeyAttribute>().ClassName)
as PropertyInterface;
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
foreignKeyInterface.GetLookupQuery(row.Cells[1].Value.ToString()));
DataTable dt = new DataTable();
dt.Load(reader);
reader.Close();
dgv.DataSource = dt;
row = dgv.Rows[0];
Value = row.Cells[0].Value.ToString();
try
{
Value2 = row.Cells[1].Value.ToString();
}
catch { }
}
else
{
Value = row.Cells[columnName].Value.ToString();
try
{
columnName = properties.Where(x => x.GetCustomAttribute <LookupValueAttribute>() != null)
.LastOrDefault().GetCustomAttribute <SqlNameAttribute>().Name;
if (columnName.Contains("ID"))
{
PropertyInterface foreignKeyInterface = Assembly.GetExecutingAssembly().
CreateInstance(properties.Where(x => x.GetCustomAttribute <ForeignKeyAttribute>() != null)
.FirstOrDefault().GetCustomAttribute <ForeignKeyAttribute>().ClassName)
as PropertyInterface;
SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.GetConnectionString(), CommandType.Text,
foreignKeyInterface.GetLookupQuery(row.Cells[2].Value.ToString()));
DataTable dt = new DataTable();
dt.Load(reader);
reader.Close();
dgv.DataSource = dt;
row = dgv.Rows[0];
Value2 = row.Cells[0].Value.ToString();
}
else
{
Value2 = row.Cells[columnName].Value.ToString();
}
}
catch
{
}
}
}