private void btnSave_Click(object sender, EventArgs e)
{
if (roomID == 0)
{
try
{
HomestayEntities db = new HomestayEntities();
Room bk = new Room();
bk.Room_Name = txtRoom.Text;
bk.Status = txtStatus.Text;
bk.Price = txtPrice.Text;
bk.Space = txtSpace.Text;
bk.Homestayown_ID = (int)cbxHomestayown.SelectedValue;
ImageConverter converter = new ImageConverter();
byte[] image = (byte[])converter.ConvertTo(pictureBox.Image, typeof(byte[]));
Room upload = new Room();
upload.Image = image;
bk.Image = image;
db.Room.Add(bk);
db.SaveChanges();
MessageBox.Show("Add new product success");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
try
{
HomestayEntities db = new HomestayEntities();
bkedit = db.Room.Find(bkedit.ID);
bkedit.Room_Name = txtRoom.Text;
bkedit.Status = txtStatus.Text;
bkedit.Price = txtPrice.Text;
bkedit.Space = txtSpace.Text;
bkedit.Homestayown_ID = (int)cbxHomestayown.SelectedValue;
ImageConverter converter = new ImageConverter();
byte[] image = (byte[])converter.ConvertTo(pictureBox.Image, typeof(byte[]));
Room upload = new Room();
upload.Image = image;
bkedit.Image = image;
db.Entry(bkedit).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
MessageBox.Show("Edit product success");
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
if (grdListview.SelectedRows.Count == 1)
{
if (MessageBox.Show("Do you want to delete this?", "Confirm", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
var row = grdListview.SelectedRows[0];
var cell = row.Cells["ID"];
int ID = (int)cell.Value;
HomestayEntities db = new HomestayEntities();
Room bk = db.Room.Single(b => b.ID == ID);
db.Room.Remove(bk);
db.SaveChanges();
room((int)cbxHomestayown.SelectedValue);
ShowList();
}
}
}
