//Show Flow layout with orders
private void btnServiceFind_Click(object sender, EventArgs e)
{
var services = new List <Service>();
flwServicesList.Controls.Clear();
using (SqlConnection connection = new SqlConnection(@"Data Source=GSZWEDPC\SQLEXPRESS;Initial Catalog=WeddingManagmentDB;Integrated Security=True"))
{
connection.Open();
var command = @"SELECT Name FROM ServiceTable";
SqlDataAdapter adapter = new SqlDataAdapter(command, connection);
DataTable dataTable = new DataTable();
connection.Close();
adapter.Fill(dataTable);
if (dataTable.Rows.Count > 0)
{
foreach (DataRow row in dataTable.Rows)
{
services.Add(new Service((string)row[0]));
}
}
}
var amount = services.Count;
CntrlService[] cntrls = new CntrlService[amount];
for (int i = 0; i < cntrls.Length; i++)
{
cntrls[i] = TransformServiceToCntrl(new CntrlService(employee.GetPermission()), services[i]);
}
flwServicesList.Controls.AddRange(cntrls);
DashboardPanels[2].BringToFront();
}
//Transform Object Service to Cntrl
private CntrlService TransformServiceToCntrl(CntrlService cntrl, Service service)
{
if (cntrl != null && service != null)
{
cntrl.Nazwa = service.GetName();
cntrl.Kategoria = service.GetCategory();
cntrl.Cena = service.GetPrize();
cntrl.Kolor = Color.White;
cntrl.Identyfikator = service.GetId();
cntrl.StanProduktu = service.GetAmount();
cntrl.StanKrytyczny = service.GetCriticalAmount();
//dodac funkcje zmieniajaca kolor ilosci pozostalych uslug
return(cntrl);
}
else
{
return(null);
}
}