コード例 #1
0
        void homestayown()
        {
            HomestayEntities db = new HomestayEntities();

            cbxHomestayown.DataSource    = db.Homestayown.ToList();
            cbxHomestayown.DisplayMember = "Name";
            cbxHomestayown.ValueMember   = "ID";
        }
コード例 #2
0
        void room(int ID)
        {
            HomestayEntities db = new HomestayEntities();

            grdListview.DataSource                        = db.Room.Where(b => b.Homestayown_ID == ID).ToList();
            grdListview.Columns["ID"].Visible             = false;
            grdListview.Columns["Homestayown"].Visible    = false;
            grdListview.Columns["Homestayown_ID"].Visible = false;
        }
コード例 #3
0
        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);
                }
            }
        }
コード例 #4
0
 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();
         }
     }
 }