private void addToDB(List <string> cList) { DbEntities db = new DbEntities(); foreach (var str in cList) { string[] wordArray = str.Split(','); Participant tested = new Participant(); tested.Name = wordArray[0]; tested.Surname = wordArray[1]; tested.Age = wordArray[2]; tested.Capacity = "23"; tested.Date = DateTime.Now; tested.Rating = "28"; db.Participants.Add(tested); } db.SaveChanges(); }
private void btnAdd_Click(object sender, EventArgs e) { DbEntities db = new DbEntities(); Participant Person = new Participant(); Person.Name = txtInputName.Text; Person.Surname = txtInputSurname.Text; Person.Age = txtInputAge.Text; Person.Capacity = lblCapacityValue.Text; Person.Date = DateTime.Now; Person.Rating = lblNormValue.Text; db.Participants.Add(Person); db.SaveChanges(); DialogResult result = MessageBox.Show("Participant added successfully, do you want to add another person and clear the form?", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Information); if (result == DialogResult.Yes) { txtInputName.Text = ""; txtInputSurname.Text = ""; txtInputAge.Text = ""; txtHR1.Text = ""; txtHR2.Text = ""; txtHR3.Text = ""; txtHR4.Text = ""; txtHR5.Text = ""; lblCapacityValue.Text = ""; lblNormValue.Text = ""; sexFlag = 0; cmbSex.Text = ""; chkContraIndications.Checked = false; chkLifestyle.Checked = false; chkReadinessCheck.Checked = false; btnAdd.Enabled = false; } else if (result == DialogResult.No) { } }
private void dataGridView1_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e) { var s = dataGridView1.Columns[e.ColumnIndex].HeaderText; DbEntities db = new DbEntities(); List <Participant> testedList; switch (e.ColumnIndex) { case 0: testedList = db.Participants.OrderBy(c => c.Id).ToList(); break; case 1: testedList = db.Participants.OrderBy(c => c.Name).ToList(); break; case 2: testedList = db.Participants.OrderBy(c => c.Surname).ToList(); break; case 3: testedList = db.Participants.OrderBy(c => c.Age).ToList(); break; case 4: testedList = db.Participants.OrderBy(c => c.Date).ToList(); break; case 5: testedList = db.Participants.OrderBy(c => c.Capacity).ToList(); break; default: testedList = db.Participants.ToList(); break; } populateGrid(testedList); }
private void TabSelection_Selecting(object sender, TabControlCancelEventArgs e) { DbEntities db = new DbEntities(); populateGrid(db.Participants.ToList()); }