private void button5_Click(object sender, EventArgs e)
{
if (dataGridView1.CurrentRow.Index != -1)
{
using (var cnt = new SageBookDbContext())
{
int id = int.Parse(dataGridView1.CurrentRow.Cells["id"].Value.ToString());
var sage = cnt.Sages.Where(s => s.id == id);
string name = textBox3.Text;
int age = Int32.Parse(textBox4.Text);
byte[] photo = Sage.ImageToByteArray(pictureBox1.Image);
string city = textBox7.Text;
updateSageInfo(id, name, age, photo, city);
//var booksIds = cnt.Books.Where(b => b.Sages.);
//Sage sage = new Sage() { name = name, age = age, city = city, photo = Sage.ImageToByteArray(photo) };
var dbSage = cnt.Sages.First(b => b.id == id);
dbSage.name = name;
dbSage.age = age.ToString();
dbSage.photo = photo;
dbSage.city = city;
//var sages = cnt.Sages.Where(s => sagesId.Contains(s.id)).ToList();
//dbBook.Sages = dbBook.Sages;
//dbBook.Sages = sages;
cnt.SaveChanges();
}
}
loadSageRecords();
}
private void button4_Click(object sender, EventArgs e)
{
string name = textBox3.Text;
string age = textBox4.Text;
var photo = pictureBox1.Image;
string city = textBox7.Text;
// TODO: check arguments
using (var cnt = new SageBookDbContext())
{
//var booksIds = cnt.Books.Where(b => b.Sages.);
Sage sage = new Sage()
{
name = name, age = age, city = city, photo = Sage.ImageToByteArray(photo)
};
cnt.Sages.Add(sage);
cnt.SaveChanges();
}
loadSageRecords();
}