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 button3_Click_1(object sender, EventArgs e)
{
string name = textBox1.Text;
string description = textBox2.Text;
string[] sagesIdSt = textBox8.Text.Split(',');
int[] sagesId = Array.ConvertAll(sagesIdSt, s => int.Parse(s));
// TODO: check arguments
using (var cnt = new SageBookDbContext())
{
var sages = cnt.Sages.Where(s => sagesId.Contains(s.id));
Book book = new Book()
{
name = name, description = description,
};
foreach (var sage in sages)
{
book.Sages.Add(sage);
}
cnt.Books.Add(book);
cnt.SaveChanges();
}
loadBookRecords();
}
private void button9_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 book = cnt.Sages.First(s => s.id == id);
cnt.Sages.Remove(book);
cnt.SaveChanges();
}
}
loadSageRecords();
}
private void button8_Click(object sender, EventArgs e)
{
if (dataGridView2.CurrentRow.Index != -1)
{
using (var cnt = new SageBookDbContext())
{
int id = int.Parse(dataGridView2.CurrentRow.Cells["id"].Value.ToString());
var book = cnt.Books.First(b => b.id == id);
//var entry = cnt.Entry(book);
//if (entry.State == EntityState.Detached)
// cnt.Books.Attach(book);
cnt.Books.Remove(book);
cnt.SaveChanges();
}
}
loadBookRecords();
}
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();
}
private void button1_Click(object sender, EventArgs e)
{
int id = int.Parse(textBox5.Text.ToString());
string name = textBox1.Text;
string description = textBox2.Text;
string[] sagesIdSt = textBox8.Text.Split(',');
int[] sagesId = Array.ConvertAll(sagesIdSt, s => int.Parse(s));
using (var cnt = new SageBookDbContext())
{
var dbBook = cnt.Books.First(b => b.id == id);
dbBook.name = name;
dbBook.description = description;
var sages = cnt.Sages.Where(s => sagesId.Contains(s.id)).ToList();
//dbBook.Sages = dbBook.Sages;
//dbBook.Sages = sages;
cnt.SaveChanges();
}
loadBookRecords();
}
