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");
}
}
}
