private void DisplayItemsFromBox(int boxid) { //List<ViewModel.ItemViewModel> allitems = new List<ViewModel.ItemViewModel>(); DBAction.GetData getallitems = new DBAction.GetData(); //allitems = database.Items // .ToList() // .Where(x => x.BoxId == currentinfo.BoxID) // .Select(x => ViewModel.ItemViewModel.Create(x.Name, x.Number, x.Description, x.ItemId)) // .ToList(); datagridItems.ItemsSource = getallitems.DisplayItems(currentinfo.BoxID); }
private void btnSerachFindItem_Click(object sender, RoutedEventArgs e) { string search_name = tbNameFindItem.Text.Trim(); List <BD.Item> allbox = new List <BD.Item>(); DBAction.GetData finditem = new DBAction.GetData(); allbox = finditem.FindItem(search_name); if (allbox.Count() > 0) { datagridBoxesListFindItem.ItemsSource = allbox; } else { MessageBox.Show("Taki przedmiot nie istnieje. Sprawdź pisownie."); } }
private void btnVerifyAndRemindRemindPassword_Click(object sender, RoutedEventArgs e) { DBAction.GetData getuserdata = new DBAction.GetData(); IQueryable <BD.User> fituser = getuserdata.RemindPassword(tbLoginRemindPassword.Text, tbNameRemindPassword.Text, tbSurnameRemindPassword.Text); if (fituser.Count() > 0) { foreach (var i in fituser) { tbPasswordRemindPassword.Text = i.Password.ToString(); } } else { MessageBox.Show("Użytkownik nie istnieje. \nWprowadź poprawne dane, podane podczas rejestracji."); ClearAllTextBox(); } }
private void datagridItems_SelectionChanged(object sender, SelectionChangedEventArgs e) { try { var row_list = GetDataGridRows(datagridItems); foreach (DataGridRow single_row in row_list) { if (single_row.IsSelected == true) { int currentitemID = GetSelectedItemId(); DBAction.GetData getphoto = new DBAction.GetData(); byte[] photo = getphoto.GetItemPhoto(currentitemID); CheckIfPhotoExist(photo); } } } catch { } }
private void DisplayBoxes(int iduser) { DBAction.GetData getallboxes = new DBAction.GetData(); datagridBoxesList.ItemsSource = getallboxes.DispalyBoxes(iduser); }