private void InitializeComboBoxes() { using (var context = new DataClasses2DataContext()) { var users = context.uzytkownicy.Select(x => new ComboboxModel { DisplayMember = x.imie + x.nazwisko, Id = x.id_uzytkownika }).ToArray(); var categories = context.kategoria.Where(x => x.id_nadkategoria == null).Select(x => new ComboboxModel { DisplayMember = x.nazwa, Id = x.id_kategoria }).ToArray(); var operationForms = context.forma_platnosci.Select(x => new ComboboxModel { DisplayMember = x.nazwa, Id = x.id_forma_platnosci }).ToArray(); comboBoxUsers.Items.AddRange(users); comboBoxCategory.Items.AddRange(categories); comboBoxOperationForm.Items.AddRange(operationForms); } comboBoxUsers.DisplayMember = "DisplayMember"; comboBoxUsers.ValueMember = "Id"; comboBoxCategory.DisplayMember = "DisplayMember"; comboBoxCategory.ValueMember = "Id"; comboBoxSubcategory.DisplayMember = "DisplayMember"; comboBoxSubcategory.ValueMember = "Id"; comboBoxOperationForm.DisplayMember = "DisplayMember"; comboBoxOperationForm.ValueMember = "Id"; wczytaj_kategorie(); }
private void buttonSave_Click(object sender, EventArgs e) { using (var context = new DataClasses2DataContext()) { var userId = comboBoxUsers.SelectedIndex != -1 ? ((ComboboxModel)comboBoxUsers.Items[comboBoxUsers.SelectedIndex]).Id : 0; var categoryId = comboBoxCategory.SelectedIndex != -1 ? ((ComboboxModel)comboBoxCategory.Items[comboBoxCategory.SelectedIndex]).Id : 0; var subcategoryId = comboBoxSubcategory.SelectedIndex != -1 ? ((ComboboxModel)comboBoxSubcategory.Items[comboBoxSubcategory.SelectedIndex]).Id : 0; var operationFormId = comboBoxOperationForm.SelectedIndex != -1 ? ((ComboboxModel)comboBoxOperationForm.Items[comboBoxOperationForm.SelectedIndex]).Id : 0; if (Walidacja() == true) { return; } if (Walidacja() == false) { if (IsEditMode) { var operation = context.operacje.FirstOrDefault(x => x.id_operacji == OperationDto.Id); if (operation != null) { operation.data = dateTimePickerDate.Value; operation.kwota = TryParse(textBoxPrice.Text, out var price) ? price : 0; operation.id_uzytkownika = userId; operation.id_kategoria = subcategoryId; operation.id_forma_platnosci = operationFormId; operation.opis = richTextBoxDescription.Text; } } else { context.operacje.InsertOnSubmit(new operacje() { data = dateTimePickerDate.Value, kwota = TryParse(textBoxPrice.Text, out var price) ? price : 0, id_uzytkownika = userId, id_kategoria = subcategoryId, id_forma_platnosci = operationFormId, opis = richTextBoxDescription.Text });
void wyswietlUzytkownikow() { using (var context = new DataClasses2DataContext()) { var query = from u in context.uzytkownicy select new { uzytkownik = u.imie + " " + u.nazwisko, id = u.id_uzytkownika }; foreach (var r in query) { tW_users.Nodes.Add(r.id.ToString(), r.uzytkownik); } } }
private void dodajToolStripMenuItem_Click(object sender, EventArgs e) { var text = string.Empty; if (tW_kategorie.SelectedNode != null) { int id; using (var context = new DataClasses2DataContext()) { if (tW_kategorie.SelectedNode.Level == 0) { id = -1; if (tW_kategorie.SelectedNode.Name == "wydatek") { text = "wydatek"; } else { text = "przychod"; } } else if (tW_kategorie.SelectedNode.Level == 1) // dodaj kat jak kliknie na nadkategorie { var query = context.kategoria.Where(t => t.nazwa == tW_kategorie.SelectedNode.Text); id = query.FirstOrDefault().id_kategoria; } else { var query = context.kategoria.Where(t => t.nazwa == tW_kategorie.SelectedNode.Parent.Text); id = query.FirstOrDefault().id_kategoria; } } var uDK = new uc_dodaj_kategorię(this, 0, id, text) { Size = new Size(121, 90), Location = new Point(3, 250) }; this.Controls.Add(uDK); uDK.BringToFront(); } }
private void ReadEditedOperation() { using (var context = new DataClasses2DataContext()) { var operation = context.operacje.FirstOrDefault(x => x.id_operacji == EditedId); if (operation == null) { throw new ArgumentException("No operation with given id in the database"); } OperationDto = new OperationDto() { Id = operation.id_operacji, Data = operation.data, Price = operation.kwota, CategoryId = operation.id_kategoria, UserId = operation.id_uzytkownika, PaymentFormId = operation.id_forma_platnosci, Description = operation.opis, }; } SetEditedOperationData(); }
private bool Walidacja() { using (var context = new DataClasses2DataContext()) { bool Check = false; if (comboBoxUsers.SelectedIndex == -1) { labelWybierzUzytkownika.Visible = true; pictureBox1.Visible = true; Check = true; } else { labelWybierzUzytkownika.Visible = false; pictureBox1.Visible = false; } if (comboBoxOperationForm.SelectedIndex == -1) { labelWybierzPłatność.Visible = true; pictureBox2.Visible = true; Check = true; } else { labelWybierzPłatność.Visible = false; pictureBox2.Visible = false; } if (comboBoxCategory.SelectedIndex == -1) { labelWybierzKategorie.Visible = true; pictureBox3.Visible = true; Check = true; } else { labelWybierzKategorie.Visible = false; pictureBox3.Visible = false; } if (comboBoxSubcategory.SelectedIndex == -1) { labelWybierzPodkategorie.Visible = true; pictureBox4.Visible = true; Check = true; } else { labelWybierzPodkategorie.Visible = false; pictureBox4.Visible = false; } if (textBoxPrice.Text == "") { labelWpiszKwote.Visible = true; pictureBox5.Visible = true; Check = true; } else { labelWpiszKwote.Visible = false; pictureBox5.Visible = false; } int parsedValue; if (!int.TryParse(textBoxPrice.Text, out parsedValue)) { labelWpiszLiczby.Visible = true; pictureBox5.Visible = true; Check = true; } else { labelWpiszLiczby.Visible = false; pictureBox5.Visible = false; } return(Check); } }