private void btnUpdate_Click(object sender, EventArgs e)
{
DBEntities db = new DBEntities();
int i = int.Parse(textBox2.Text);
Conservative con = db.Conservatives.Where(a => a.Id == i).First();
con.Position = textBox3.Text;
con.Name = textBox4.Text;
con.Usefulness = checkBox1.Checked;
db.SaveChanges();
populateGrid(db.Conservatives.ToList());
}
private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex == -1)
{
return;
}
int c = (int)dataGridView1.Rows[e.RowIndex].Cells[0].Value;
DBEntities db = new DBEntities();
Conservative con = db.Conservatives.Where(i => i.Id == c).First();
textBox2.Text = con.Id.ToString();
textBox3.Text = con.Position.ToString();
textBox4.Text = con.Name.ToString();
checkBox1.Checked = con.Usefulness;
}
private void addToDb(List <string> cList)
{
DBEntities db = new DBEntities();
foreach (var item in cList)
{
string[] wordArray = item.Split(',');
Conservative c = new Conservative();
c.Position = wordArray[0].ToString();
c.Name = wordArray[1].ToString();
c.Usefulness = false;
db.Conservatives.Add(c);
}
db.SaveChanges();
}
