private void LoadDichVu() { try { dtDichVu = new DataTable(); dtDichVu = BUS_DichVuNhaHang.GetDataDichVu(); cboDanhSachDichVu.DataSource = dtDichVu; cboDanhSachDichVu.DisplayMember = dtDichVu.Columns["TenDichVu"].ToString(); cboDanhSachDichVu.ValueMember = dtDichVu.Columns["MaDichVu"].ToString(); cboDanhSachDichVu.SelectedIndex = 0; } catch (Exception ex) { } }
private void btnXoa_Click(object sender, EventArgs e) { StateButton = STATEBUTTON.REMOVE; DialogResult dialog = MessageBox.Show("Bạn có muốn xóa dịch vụ: " + resultDichVuTable.Rows[itemSelect][1].ToString(), "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dialog == DialogResult.OK) { try { DTO_DichVu dichvu = new DTO_DichVu(); dichvu.HinhAnh = resultDichVuTable.Rows[itemSelect][3].ToString(); dichvu.MaDichVu = Int32.Parse(resultDichVuTable.Rows[itemSelect][0].ToString()); //Check State of Image int stateRowEffect = BUS_DichVuNhaHang.DeleteRecordEffect(dichvu); bool DeleteState = BUS_DichVuNhaHang.Delete(dichvu); if (DeleteState) { //Delete image in data if (stateRowEffect > 1 && dichvu.HinhAnh != "unknow.png") { imgListDichVu.Images.RemoveAt(itemSelect); lstHinhAnh.Items.RemoveAt(itemSelect); } else { DeleteImage(); } resultDichVuTable = BUS_DichVuNhaHang.GetDataDichVu(); MessageBox.Show("Xóa thành công"); btnThem.Enabled = true; btnSua.Enabled = btnXoa.Enabled = btnHuy.Enabled = btnLuu.Enabled = false; } else { MessageBox.Show("Xóa thất bại"); } } catch (Exception ex) { MessageBox.Show("Thao tác xóa thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } //itemSelect = -1; } }
private void GetDataDichVuCurrent() { resultDichVuTable = BUS_DichVuNhaHang.GetDataDichVu(); }
private void btnLuu_Click(object sender, EventArgs e) { //Check state Insert if (StateButton == STATEBUTTON.INSERT) { //Save image Region bool stateSaveImage = true; string pathImage = ImageLocationPath; try { if (lblThongTinHinhAnh.Text == string.Empty) { lblThongTinHinhAnh.Text = "unknow.png"; } if (File.Exists(@"DanhSachDichVu\" + lblThongTinHinhAnh.Text)) { stateSaveImage = false; } } catch (Exception ex) { lblThongTinHinhAnh.Text = "unknow.png"; } //Insert Region DTO_DichVu dichvu = new DTO_DichVu(); if (txtTenDichVu.Text == string.Empty || txtDonGia.Text == string.Empty) { ShowNotification(); return; } //Add information dichvu.TenDichVu = txtTenDichVu.Text; try { dichvu.DonGia = Convert.ToDecimal(txtDonGia.Text); } catch (FormatException ex) { MessageBox.Show("Đơn giá nhập lỗi ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } dichvu.GhiChu = txtGhiChu.Text; //Insert name Hinh Anh if (lblThongTinHinhAnh.Text == "") { dichvu.HinhAnh = "unknow.png"; } else { dichvu.HinhAnh = lblThongTinHinhAnh.Text; } //Insert region bool InsertState = BUS_DichVuNhaHang.Insert(dichvu); if (InsertState) { if (stateSaveImage) { try { string pathFolderProject = @"DanhSachDichVu\"; var path = Path.Combine(pathFolderProject, Path.GetFileName(pathImage)); File.Copy(pathImage, path); ImageLocationPath = string.Empty; } catch (Exception ex) { MessageBox.Show("Thao tác thêm ảnh vào CSDL thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); } } resultDichVuTable = BUS_DichVuNhaHang.GetDataDichVu(); InsertNewImage(dichvu); MessageBox.Show("Thêm dịch vụ thành công", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.None); } else { MessageBox.Show("Thêm dịch vụ thất bại", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.None); } //Reset State Region lblThongTinHinhAnh.Text = string.Empty; txtDonGia.Text = txtGhiChu.Text = txtTenDichVu.Text = string.Empty; ptrHinhAnh.Image = null; StateButton = STATEBUTTON.DEFAULT; EnableStateButton(false); EnableStateTextBox(true); HideNotification(); } else //Update state if (StateButton == STATEBUTTON.UPDATE) { //State image now string pathImage = resultDichVuTable.Rows[itemSelect][3].ToString(); //Check state region DTO_DichVu dichvu = new DTO_DichVu(); dichvu.MaDichVu = Int32.Parse(resultDichVuTable.Rows[itemSelect][0].ToString()); if (txtTenDichVu.Text == string.Empty || txtDonGia.Text == string.Empty) { ShowNotification(); return; } dichvu.TenDichVu = txtTenDichVu.Text; try { dichvu.DonGia = Convert.ToDecimal(txtDonGia.Text); } catch (FormatException ex) { MessageBox.Show("Đơn giá sửa bị lỗi ", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning); return; } dichvu.GhiChu = txtGhiChu.Text; //Insert name Hinh Anh if (lblThongTinHinhAnh.Text == "") { dichvu.HinhAnh = "unknow.png"; } else { dichvu.HinhAnh = lblThongTinHinhAnh.Text; } bool UpdateState = BUS_DichVuNhaHang.Update(dichvu); //DTO_DichVu PreviousDichVu = new DTO_DichVu(); //PreviousDichVu.HinhAnh = ImageInstance; //int RecordEffect = BUS_DichVuNhaHang.DeleteRecordEffect(PreviousDichVu); if (UpdateState) { //Check state image with image in DB string pathCheck = ImageLocationPath; if (lblThongTinHinhAnh.Text != pathImage) { if (dichvu.HinhAnh != "unknow.png") { //Delete old image and insert new image vào Database try { //copy new image string pathFolderProject = @"DanhSachDichVu\"; var path = Path.Combine(pathFolderProject, Path.GetFileName(pathCheck)); File.Copy(pathCheck, path); } catch (Exception ex) { } UpdateImage(dichvu); } else { int lastIndex = imgListDichVu.Images.Count; imgListDichVu.Images[itemSelect].Dispose(); imgListDichVu.Images.Add(Image.FromFile(@"DanhSachDichVu\unknow.png")); imgListDichVu.Images[itemSelect] = imgListDichVu.Images[lastIndex]; imgListDichVu.Images.RemoveAt(lastIndex); lstHinhAnh.LargeImageList = imgListDichVu; lstHinhAnh.Items[itemSelect].Text = dichvu.TenDichVu; lstHinhAnh.Refresh(); } } else { lblThongTinHinhAnh.Text = pathImage; lstHinhAnh.Items[itemSelect].Text = dichvu.TenDichVu; lstHinhAnh.Refresh(); } resultDichVuTable = BUS_DichVuNhaHang.GetDataDichVu(); //Reset State Region lstHinhAnh_SelectedIndexChanged(sender, e); ptrHinhAnh.Image = null; StateButton = STATEBUTTON.DEFAULT; EnableStateButton(false); EnableStateTextBox(true); HideNotification(); ImageLocationPath = string.Empty; MessageBox.Show("Cập nhật thành công "); } else { MessageBox.Show("Cập nhật thất bại"); } } }