public void LoadEntriesTests() { CuredLabel.Text = _card.IsCured ? "Cured" : "Not cured"; TestsTable.Controls.Clear(); _tests = DbConnector.GetInstance().GetTests(_card.id); TestsTable.RowCount = _tests.Count; TestsTable.Update(); for (int i = 0; i < _tests.Count; i++) { DateTimePicker lb1 = new DateTimePicker(); lb1.Size = new Size(120, lb1.Height); lb1.Text = _tests[i].DateTime; lb1.Show(); TextBox lb2 = new TextBox(); lb2.Font = new Font("Calibri", 12); lb2.Size = new Size(300, lb2.Height); lb2.Text = _tests[i].Result; lb2.Show(); ComboBox cb = new ComboBox(); cb.BeginUpdate(); _tt.ForEach(x => cb.Items.Add(x.Name)); cb.EndUpdate(); cb.Text = _tests[i].Type; Label lb3 = new Label(); lb3.Font = new Font("Calibri", 12); lb3.Text = _tt.Find(x => x.Name == _tests[i].Type).Cost.ToString(); lb3.Show(); DeleteButton b = new DeleteButton(_tests[i].id, "test"); b.Click += b_Click; this.TestsTable.Controls.Add(cb, 0, i); this.TestsTable.Controls.Add(lb1, 1, i); this.TestsTable.Controls.Add(lb2, 2, i); this.TestsTable.Controls.Add(lb3, 3, i); this.TestsTable.Controls.Add(b, 4, i); } }
private void SaveTestButton_Click(object sender, EventArgs e) { DbConnector db = DbConnector.GetInstance(); for (int i = 0; i < TestsTable.RowCount; i++) { tests[i].Name = TestsTable.GetControlFromPosition(0, i).Text; tests[i].Cost = int.Parse(TestsTable.GetControlFromPosition(1, i).Text); db.UpdateType(tests[i], "test"); } }
private void SaveButton_Click(object sender, EventArgs e) { DbConnector db = DbConnector.GetInstance(); for (int i = 0; i < _tests.Count; i++) { DateTime dt = DateTime.Parse(TestsTable.GetControlFromPosition(1, i).Text); int tid = _tt.Find(x => x.Name == TestsTable.GetControlFromPosition(0, i).Text).id; _tests[i].type_id = tid; _tests[i].DateTime = dt.ToString("yyy-MM-dd HH:mm:ss"); _tests[i].Result = TestsTable.GetControlFromPosition(2, i).Text; db.UpdateTest(_tests[i]); } LoadEntriesTests(); }
public void LoadEntriesTests() { TestsTable.Controls.Clear(); tests = DbConnector.GetInstance().GetTestTypes(); TestsTable.RowCount = tests.Count; TestsTable.Update(); for (int i = 0; i < tests.Count; i++) { TextBox lb = new TextBox(); lb.Font = new Font("Calibri", 12); lb.Text = tests[i].Name; lb.Show(); TextBox lb1 = new TextBox(); lb1.Font = new Font("Calibri", 12); lb1.Text = tests[i].Cost.ToString(); lb1.Show(); DeleteButton b1 = new DeleteButton(tests[i].id, "testtype"); b1.Click += b1_Click; this.TestsTable.Controls.Add(lb, 0, i); this.TestsTable.Controls.Add(lb1, 1, i); this.TestsTable.Controls.Add(b1, 2, i); } }