private List <string> GetData(string entity) { DataTable dt = mw.Select($"select [name] from {entity}"); List <string> data = new List <string>(); foreach (DataRow dr in dt.Rows) { data.Add(dr["name"].ToString()); } return(data); }
private List <string> GetProductsId() { DataTable products = mw.Select("select [name] from Products"); List <string> ids = new List <string>(); foreach (DataRow dr in products.Rows) { ids.Add(dr["name"].ToString()); } return(ids); }
private void InputListBox() { DataTable articles = mainWindow.Select("select id, Articles.[name], [description], [price] from Articles"); List <Article> items = new List <Article>(); foreach (DataRow dr in articles.Rows) { items.Add(new Article() { ID = Convert.ToInt32(dr["id"]), Name = dr["name"].ToString(), Description = dr["description"].ToString(), Price = dr["price"].ToString() }); } Items.ItemsSource = items; }
private Article GetArticle() { Article article = new Article(); DataTable articles = mw.Select($"select Articles.id, Articles.[name], [description], [price], [year], " + $"AutoTypes.[name] as [type], AutoOils.[name] as [oil], AutoBrands.[name] as [brand], " + $"AutoPrivods.[name] as [privod], KPPTypes.[name] as [kpp], TypeBodies.[name] as [body] from Articles " + $"join AutoTypes on AutoTypes.id = idtype " + $"join AutoOils on AutoOils.id = idoiltype " + $"join AutoBrands on AutoBrands.id = idbrand " + $"join AutoPrivods on AutoPrivods.id = idprivod " + $"join KPPTypes on KPPTypes.id = idkpp " + $"join TypeBodies on TypeBodies.id = idbody where Articles.id={IDArticle}"); foreach (DataRow dr in articles.Rows) { article = new Article() { ID = Convert.ToInt32(dr["id"]), Name = dr["name"].ToString(), Description = dr["description"].ToString(), Price = dr["price"].ToString(), Year = Convert.ToInt32(dr["year"]), Type = dr["type"].ToString(), Oil = dr["oil"].ToString(), Brand = dr["brand"].ToString(), Privod = dr["privod"].ToString(), Kpp = dr["kpp"].ToString(), Body = dr["body"].ToString() }; } return(article); }
private void LoginClick(object sender, RoutedEventArgs e) { if (mainWindow.RegexAdmin(Login.Text, Password.Password)) { mainWindow.OpenPage(MainWindow.Pages.admin); } else if (mainWindow.RegexLogin(Login.Text)) { if (mainWindow.RegexPassword(Password.Password)) { DataTable find = mainWindow.Select($"select * from Users where login='******' and password='******'"); if (find.Rows.Count > 0) { mainWindow.OpenPage(MainWindow.Pages.main); mainWindow.login = Login.Text; MessageBox.Show("Пользователь авторизовался"); } else { MessageBox.Show("Такого пользователя не существует"); } } else { MessageBox.Show("Введите пароль"); } } else { MessageBox.Show("Введите логин"); } }
private int GetId(string name) { DataTable dt = mw.Select($"select id from Categories where [name]='{name}'"); int id = -1; try { foreach (DataRow dr in dt.Rows) { id = Convert.ToInt32(dr["id"]); } return(id); } catch (Exception error) { MessageBox.Show(error.Message); } return(id); }
private List <AutoPrivods> GetPrivods() { DataTable dt = mw.Select("select [name] from AutoPrivods"); List <AutoPrivods> privods = new List <AutoPrivods>(); foreach (DataRow dr in dt.Rows) { privods.Add(new AutoPrivods { Name = dr["name"].ToString() }); } return(privods); }
private List <AutoTypes> GetTypes() { DataTable dt = mw.Select("select [name] from AutoTypes"); List <AutoTypes> types = new List <AutoTypes>(); foreach (DataRow dr in dt.Rows) { types.Add(new AutoTypes { Name = dr["name"].ToString() }); } return(types); }
private List <AutoOils> GetOils() { DataTable dt = mw.Select("select [name] from AutoOils"); List <AutoOils> oils = new List <AutoOils>(); foreach (DataRow dr in dt.Rows) { oils.Add(new AutoOils { Name = dr["name"].ToString() }); } return(oils); }
private void InputListBox() { DataTable products = mainWindow.Select("select Products.[name], Categories.[name] as category, [description], Prices.[value] as price from Products join Categories on Categories.id=category_id join Prices on Prices.product_id = Products.id"); List <Product> items = new List <Product>(); foreach (DataRow dr in products.Rows) { items.Add(new Product() { Name = dr["name"].ToString(), Category = dr["category"].ToString(), Description = dr["description"].ToString(), Price = dr["price"].ToString() }); } Items.ItemsSource = items; }