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; } } } }