public Frm_edit(int id)
{
InitializeComponent();
db = new CAKEMANAGEMENTEntities();
cake = db.cakes.Single(cake => cake.id == id);
this.Load += Form3_Load;
}
private void Form2_Load(object sender, EventArgs e)
{
CAKEMANAGEMENTEntities db = new CAKEMANAGEMENTEntities();
Cbb_kindName.DataSource = db.kinds.ToList();
Cbb_kindName.DisplayMember = "kindname";
Cbb_kindName.ValueMember = "id";
}
void LoadDB()
{
db = new CAKEMANAGEMENTEntities();
dtgBakery.DataSource = db.cakes.Select(cake => new
{
cake.id,
cake.cakename,
kind = cake.kind.kindname
}).ToList();
}
private void btn_save_Click(object sender, EventArgs e)
{
cake cake = new cake();
cake.cakename = txt_cakeName.Text;
cake.id_cakekind = (int)Cbb_kindName.SelectedValue;
CAKEMANAGEMENTEntities db = new CAKEMANAGEMENTEntities();
db.cakes.Add(cake);
db.SaveChanges();
MessageBox.Show("Thêm bánh mới thành công");
this.Close();
}
private void dELETEToolStripMenuItem_Click(object sender, EventArgs e)
{
if (dtgBakery.SelectedRows.Count == 1)
{
var row = dtgBakery.SelectedRows[0];
var cell = row.Cells["id"];
int id = (int)cell.Value;
db = new CAKEMANAGEMENTEntities();
cake cake = db.cakes.Where(ca => ca.id == id).ToList()[0];
db.cakes.Remove(cake);
db.SaveChanges();
MessageBox.Show("Xóa bánh Thành công");
}
else
{
MessageBox.Show("Mời bạn chọn 1 dòng");
}
LoadDB();
}
