public void loadData()
{
DataSet ds = sqlUpdate.getData();
foreach (DataTable table in ds.Tables)
{
foreach (DataRow row in table.Rows)
{
string name = Convert.ToString(row[0]);
string email = Convert.ToString(row[1]);
string tmp = Convert.ToString(row[2]);
Role rola = (Role)Enum.Parse(typeof(Role), tmp);
users.Add(new User(name, email, rola));
}
}
}
public void loadData()
{
DataSet ds = sqlUpdate.getData();
foreach (DataTable table in ds.Tables)
{
foreach (DataRow row in table.Rows)
{
string name = Convert.ToString(row[0]);
int NIP = Convert.ToInt32(row[1]);
string adress = Convert.ToString(row[2]);
customers.Add(new Customer(name, NIP, adress));
}
}
}
public void loadData()
{
DataSet ds = sqlUpdate.getData();
foreach (DataTable table in ds.Tables)
{
foreach (DataRow row in table.Rows)
{
string customer = Convert.ToString(row[0]);
string product = Convert.ToString(row[1]);
int ID = Convert.ToInt32(row[2]);
DateTime date = Convert.ToDateTime(row[3]);
int amount = Convert.ToInt32(row[4]);
bool reservation = Convert.ToBoolean(row[5]);
transactions.Add(new Transaction(customer, ID, product, date, amount, reservation));
}
}
}
public void loadData()
{
DataSet ds = sqlUpdate.getData();
foreach (DataTable table in ds.Tables)
{
foreach (DataRow row in table.Rows)
{
int ID = Convert.ToInt32(row[0]);
string name = Convert.ToString(row[1]);
string kategoria = Convert.ToString(row[2]);
double tmp = Convert.ToDouble(row[3]);
float cena = (float)tmp;
int ilosc = Convert.ToInt32(row[4]);
int dostepne = Convert.ToInt32(row[5]);
products.Add(new Product(ID, name, kategoria, cena, ilosc, dostepne));
if (Product.GET_ID < ID)
{
Product.GET_ID = ID;
}
}
}
}