private void btn_luu_Click(object sender, System.EventArgs e)
{
if (!CheckBeforeSave())
{
return;
}
DTO_DichVu dvu = new DTO_DichVu();
dvu.khu_vuc = txt_khuvuc.Text;
dvu.phan_vung = txt_phanvung.Text;
dvu.don_gia_tan = Convert.ToInt32(txt_dongiatan.Text);
dvu.don_gia_chuyen = Convert.ToInt32(txt_dongiachuyen.Text);
if (txt_khuvuc.Enabled)
{
dal_dv.Create_DV(dvu);
}
else
{
dal_dv.Update_DVU(dvu);
}
BindDataGridView();
ResetControl();
btn_xoa.Enabled = false;
btn_sua.Enabled = false;
}
//private void OnClickRightDichVu(object sender, MouseEventArgs e)
//{
// ListView lstView = sender as ListView;
// if (e.Button == MouseButtons.Right)
// {
// ListViewItem item = lstView.GetItemAt(e.X, e.Y);
// if (item != null)
// {
// item.Selected = true;
// //Setup event list item
// ContextMenuStrip MenuAction = new ContextMenuStrip();
// ToolStripMenuItem XoaDichVu = new ToolStripMenuItem("Xóa dịch vụ");
// XoaDichVu.Click += new EventHandler(this.DichVu_OnClickRemove);
// MenuAction.Items.AddRange(new ToolStripItem[] { XoaDichVu });
// MenuAction.Show(Cursor.Position);
// }
// }
//}
//private void DichVu_OnClickRemove(object sender, EventArgs e)
//{
// imgListDichVu.Images[lstDichVuInsert.Count - 2] = (Image)imgListDichVu.Images[lstDichVuInsert.Count - 2].Clone();
// lstDichVuInsert.RemoveAt(lstDichVuTiecCuoi.SelectedIndices[0]);
// imgListDichVu.Images.RemoveAt(lstDichVuTiecCuoi.SelectedIndices[0]);
// lstDichVuTiecCuoi.Items.RemoveAt(lstDichVuTiecCuoi.SelectedIndices[0]);
//}
private void InsertNewDichVu(DTO_DichVu dichvu)
{
//Hiển thị hình ảnh
try
{
imgListDichVu.Images.Add(dichvu.TenDichVu, Image.FromFile(@"DanhSachDichVu\" + dichvu.HinhAnh));
imgListDichVu.ImageSize = new Size(80, 80);
lstDichVuTiecCuoi.LargeImageList = imgListDichVu;
lstDichVuTiecCuoi.Refresh();
}
catch (Exception ex)
{
}
//Gán vào list
try
{
ListViewItem item = new ListViewItem();
item.ImageIndex = lstDichVuTiecCuoi.Items.Count;
item.Text = dichvu.TenDichVu + " - Thành tiền: " + Environment.NewLine + dichvu.DonGia;
lstDichVuTiecCuoi.Items.Add(item);
lstDichVuTiecCuoi.Refresh();
}
catch (Exception ex)
{
}
}
public bool insertDichVu(DTO_DichVu dvu)
{
// Ket noi
SQLiteConnection connect = getConnection();
connect.Open();
try
{
// Query string
string SQL = string.Format("INSERT INTO DICHVU(MADICHVU, TENDICHVU, MOTA, DONGIA, GHICHU) VALUES ('{0}', '{1}', '{2}', '{3}', '{4}')", dvu.MaDichVu, dvu.TenDichVu, dvu.MoTa, dvu.DonGia, dvu.GhiChu);
SQLiteCommand cmd = new SQLiteCommand(SQL, connect);
// Query và kiểm tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e) { }
finally
{
// Dong ket noi
connect.Close();
}
return(false);
}
public bool editDichVu(DTO_DichVu dvu)
{
// Ket noi
SQLiteConnection connect = getConnection();
connect.Open();
try
{
// Query string
string SQL = string.Format("UPDATE DICHVU SET TENDICHVU = '{0}', MOTA = '{1}', DONGIA = '{2}', GHICHU = '{3}' WHERE MADICHVU = '{4}'", dvu.TenDichVu, dvu.MoTa, dvu.DonGia, dvu.GhiChu, dvu.MaDichVu);
SQLiteCommand cmd = new SQLiteCommand(SQL, connect);
// Query và kiểm tra
if (cmd.ExecuteNonQuery() > 0)
{
return(true);
}
}
catch (Exception e) { }
finally
{
// Dong ket noi
connect.Close();
}
return(false);
}
private void InsertNewImage(DTO_DichVu dichvu)
{
try
{
imgListDichVu.Images.Add(dichvu.TenDichVu, Image.FromFile(@"DanhSachDichVu\" + dichvu.HinhAnh));
imgListDichVu.ImageSize = new Size(90, 90);
lstHinhAnh.LargeImageList = imgListDichVu;
lstHinhAnh.Refresh();
}
catch (Exception ex)
{
MessageBox.Show("Hiển thị hình ảnh thất bại");
}
try
{
ListViewItem item = new ListViewItem();
item.ImageIndex = resultDichVuTable.Rows.Count - 1;
item.Text = dichvu.TenDichVu;
lstHinhAnh.Items.Add(item);
lstHinhAnh.Refresh();
}
catch (Exception ex)
{
MessageBox.Show("Gán hình ảnh vào List thất bại");
}
}
public List <DTO_DichVu> DOngia_2(DTO_DichVu dto)
{
string sql = "select * from dm_dich_vu where khu_vuc='" + dto.khu_vuc.Trim() + "' and phan_vung='" + dto.phan_vung.Trim() + "'";
SqlDataReader dr = data.ExcuteDataReader(sql, null);
return(data.MapDataReaderToObject <DTO_DichVu>(dr));
}
private void cbb_khuvuc_SelectedIndexChanged(object sender, EventArgs e)
{
if (cbb_khuvuc.SelectedText != "Chọn Khu Vực")
{
DTO_DichVu dvv = new DTO_DichVu();
dvv.khu_vuc = cbb_khuvuc.Text.Trim();
Load_cbb_phanvung(dvv);
}
}
public bool xoaDV(DTO_DichVu obj)
{
int paraNumber = 1;
string[] paraName = new string[paraNumber];
object[] values = new object[paraNumber];
paraName[0] = "MADV";
values[0] = obj.Madichvu;
return(Update("SP_DICHVU_XOA", paraName, values, paraNumber));
}
private void Load_cbb_phanvung(DTO_DichVu dv)
{
//List<DTO_DichVu> dv1 = new List<DTO_DichVu>();
//var groups = bll_dv.PV_2(dv);
//dv1.Add(new DTO_DichVu() { phan_vung = "Chọn Phân Vùng" });
//dv1.AddRange(groups);
cbb_phanvung.DataSource = bll_dv.PV_2(dv);
cbb_phanvung.ValueMember = "phan_vung";
cbb_phanvung.DisplayMember = "phan_vung";
}
private void btnChonDatDichVu_Click(object sender, EventArgs e)
{
//Kiểm tra đơn giá đặt dịch vụ có thêm chưa
if (txtDonGiaDatDichVu.Text == string.Empty)
{
txtDonGiaDatDichVu.Text = lblDonGiaDichVu.Text.Substring(0, lblDonGiaDichVu.Text.Length - 4);
}
//Check tính đúng của tiệc
if (!CheckRightTienDatCoc(txtDonGiaDatDichVu.Text))
{
MessageBox.Show("Đơn giá đặt dịch vụ phải là bội số của 500 đồng", "Thông báo");
return;
}
//Add chưa có mã tiệc cưới
if (txtDonGiaDatDichVu.Text == string.Empty)
{
txtDonGiaDatDichVu.Text = lblDonGiaDichVu.Text.Substring(0, lblDonGiaDichVu.Text.Length - 4);
}
if (txtSoLuongDichVuDat.Text == "")
{
txtSoLuongDichVuDat.Text = "1";
}
int index = cboDanhSachDichVu.SelectedIndex;
if (!lstDichVuInsert.Contains(Int32.Parse(dtDichVu.Rows[index][0].ToString())))
{
try
{
DTO_CT_PhieuDatDichVu phieudichvu = new DTO_CT_PhieuDatDichVu();
phieudichvu.MaDichVu = Int32.Parse(dtDichVu.Rows[index][0].ToString());
//phieudichvu.MaTiecCuoi = ???
phieudichvu.SoLuong = Int32.Parse(txtSoLuongDichVuDat.Text);
phieudichvu.DonGia = Int32.Parse(txtDonGiaDatDichVu.Text);
lstChiTietDichVu.Add(phieudichvu);
DTO_DichVu dichvu = new DTO_DichVu();
dichvu.MaDichVu = Int32.Parse(dtDichVu.Rows[index][0].ToString());
dichvu.TenDichVu = dtDichVu.Rows[index][1].ToString();
dichvu.DonGia = phieudichvu.DonGia * phieudichvu.SoLuong;
dichvu.HinhAnh = dtDichVu.Rows[index][3].ToString();
lstDichVuInsert.Add(dichvu.MaDichVu);
InsertNewDichVu(dichvu);
}
catch (Exception ex)
{
}
}
else
{
MessageBox.Show("Dịch vụ này đã được đặt ", "Thông báo");
}
}
public bool Update_DVU(DTO_DichVu DV)
{
string sql = "update dm_dich_vu set phan_vung=@phan_vung,don_gia_chuyen=@don_gia_chuyen,don_gia_tan=@don_gia_tan where khu_vuc=@khu_vuc";
SqlParameter[] prs =
{
new SqlParameter("@khu_vuc", DV.khu_vuc),
new SqlParameter("@phan_vung", DV.phan_vung),
new SqlParameter("@don_gia_chuyen", DV.don_gia_chuyen),
new SqlParameter("@don_gia_tan", DV.don_gia_tan)
};
return(data.ExcuteNonQuery(sql, prs));
}
public bool Create_DV(DTO_DichVu DV)
{
string sql = "insert into dm_dich_vu(khu_vuc,phan_vung,don_gia_chuyen,don_gia_tan) values(@khu_vuc,@phan_vung,@don_gia_chuyen,@don_gia_tan)";
SqlParameter[] prs =
{
new SqlParameter("@khu_vuc", DV.khu_vuc),
new SqlParameter("@phan_vung", DV.phan_vung),
new SqlParameter("@don_gia_chuyen", DV.don_gia_chuyen),
new SqlParameter("@don_gia_tan", DV.don_gia_tan)
};
return(data.ExcuteNonQuery(sql, prs));
}
public bool capnhatDV(DTO_DichVu obj)
{
int paraNumber = 3;
string[] paraName = new string[paraNumber];
object[] values = new object[paraNumber];
paraName[1] = "TENDV";
values[1] = obj.Tendichvu;
paraName[0] = "MADV";
values[0] = obj.Madichvu;
paraName[2] = "DONGIA";
values[2] = obj.Dongia;
return(Update("SP_DICHVU_SUA", paraName, values, paraNumber));
}
public static bool Update(DTO_DichVu dichvu)
{
string sTruyVan = string.Format("Update DichVu set TenDichVu=N'{0}', DonGia='{1}', GhiChu=N'{2}', HinhAnh = N'{3}' where MaDichVu='{4}'", dichvu.TenDichVu, dichvu.DonGia, dichvu.GhiChu, dichvu.HinhAnh, dichvu.MaDichVu);
try
{
int state = DatabaseHelper.ExcuteSql(sTruyVan);
if (state > 0)
{
return(true);
}
}
catch (Exception ex)
{
}
return(false);
}
public List <DTO_DichVu> GetServiceInfor()
{
List <DTO_DichVu> result = new List <DTO_DichVu>();
DataTable data = DAO_DichVu.Instance.GetServiceInfor();
foreach (DataRow row in data.Rows)
{
DTO_DichVu tmpObject = new DTO_DichVu();
tmpObject.MaDichVu = row["MADICHVU"].ToString();
tmpObject.TenDichVu = row["TENDICHVU"].ToString();
tmpObject.GiaTien = double.Parse(row["GIATIEN"].ToString());
result.Add(tmpObject);
}
return(result);
}
public List <DTO_DichVu> KV_2()
{
string sql = "select distinct khu_vuc from dm_dich_vu";
DataTable dt = data.ExcuteDataTable(sql, null);
if (dt != null && dt.Rows.Count > 0)
{
List <DTO_DichVu> dvv = new List <DTO_DichVu>();
foreach (DataRow dr in dt.Rows)
{
DTO_DichVu d = new DTO_DichVu();
d.khu_vuc = dr["khu_vuc"].ToString();
dvv.Add(d);
}
return(dvv);
}
return(null);
}
public List <DTO_DichVu> PV_2(DTO_DichVu dv)
{
string sql = "select phan_vung from dm_dich_vu where khu_vuc='" + dv.khu_vuc.Trim() + "'";
DataTable dt = data.ExcuteDataTable(sql, null);
if (dt != null && dt.Rows.Count > 0)
{
List <DTO_DichVu> dvv = new List <DTO_DichVu>();
foreach (DataRow dr in dt.Rows)
{
DTO_DichVu d = new DTO_DichVu();
d.phan_vung = dr["phan_vung"].ToString();
dvv.Add(d);
}
return(dvv);
}
return(null);
}
public static bool DeleteDichVu(DTO_DichVu dichVu)
{
string query = "DELETE FROM DICHVU WHERE MaDichVu = " + dichVu.maDichVu;
try
{
int state = DatabaseHelper.ExcuteSql(query);
if (state > 0)
{
return(true);
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
public static bool InsertDichVu(DTO_DichVu dichVu)
{
string query = "SET IDENTITY_INSERT DICHVU ON INSERT INTO DICHVU (MaDichVu,TenDichVu, DonGia) VALUES (" + dichVu.maDichVu + "," + "'" + dichVu.tenDichVu + "'" + "," + dichVu.donGia + ") SET IDENTITY_INSERT DICHVU OFF";
try
{
int state = DatabaseHelper.ExcuteSql(query);
if (state > 0)
{
return(true);
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
public static bool UpdateDichVu(DTO_DichVu dichVu)
{
string query = "Update DICHVU set DonGia = " + dichVu.donGia + " where MaDichVu = " + dichVu.maDichVu;
try
{
int state = DatabaseHelper.ExcuteSql(query);
if (state > 0)
{
return(true);
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
public static bool Delete(DTO_DichVu dichvu)
{
string sTruyVan = string.Format(@"Delete DichVu where MaDichVu={0}", dichvu.MaDichVu);
try
{
int state = DatabaseHelper.ExcuteSql(sTruyVan);
if (state > 0)
{
return(true);
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
public static bool Insert(DTO_DichVu dichvu)
{
string sTruyVan = string.Format(@"Insert into DichVu(TenDichVu,DonGia,GhiChu,HinhAnh) values(N'{0}',{1},N'{2}',N'{3}')", dichvu.TenDichVu, dichvu.DonGia, dichvu.GhiChu, dichvu.HinhAnh);
try
{
int state = DatabaseHelper.ExcuteSql(sTruyVan);
if (state > 0)
{
return(true);
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
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 UpdateImage(DTO_DichVu dichvu)
{
try
{
ptrHinhAnh.Image = Image.FromFile(ImageLocationPath);
int lastIndex = imgListDichVu.Images.Count;
imgListDichVu.Images[itemSelect].Dispose();
imgListDichVu.Images.Add(Image.FromFile(ImageLocationPath));
imgListDichVu.Images[itemSelect] = imgListDichVu.Images[lastIndex];
imgListDichVu.Images.RemoveAt(lastIndex);
lstHinhAnh.LargeImageList = imgListDichVu;
lstHinhAnh.Items[itemSelect].Text = dichvu.TenDichVu;
lstHinhAnh.Refresh();
}
catch (Exception ex)
{
MessageBox.Show("Cập nhật hình ảnh thất bại");
}
}
public static bool InsertDichVu(DTO_DichVu dichVu)
{
string query = String.Format(@"INSERT INTO DICHVU (TenDichVu, DonGia, GhiChu, HinhAnh) VALUES (N'{0}', {1}, N'{2}', N'{3}')",
dichVu.TenDichVu, dichVu.DonGia, dichVu.GhiChu, dichVu.HinhAnh);
try
{
int state = DatabaseHelper.ExcuteSql(query);
if (state > 0)
{
return(true);
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
public static bool UpdateDichVu(DTO_DichVu dichVu)
{
string query = String.Format(@"UPDATE DICHVU SET TenDichVu=N'{0}', DonGia={1}, GhiChu=N'{2}', HinhAnh=N'{3}' WHERE MaDichVu={4}",
dichVu.TenDichVu, dichVu.DonGia, dichVu.GhiChu, dichVu.HinhAnh, dichVu.MaDichVu);
try
{
int state = DatabaseHelper.ExcuteSql(query);
if (state > 0)
{
return(true);
}
}
catch (Exception ex)
{
return(false);
}
return(false);
}
private void cbb_phanvung_SelectedIndexChanged(object sender, EventArgs e)
{
string chonkv = cbb_khuvuc.SelectedValue.ToString().Trim();
if (cbb_khuvuc.SelectedIndex == 0)
{
txt_dongiachuyen.Text = "";
txt_dongiatan.Text = "";
}
else
{
DTO_DichVu dto = new DTO_DichVu();
dto.khu_vuc = cbb_khuvuc.SelectedValue.ToString();
dto.phan_vung = cbb_phanvung.SelectedValue.ToString();
List <DTO_DichVu> li = new BLL_DichVu().DOngia_2(dto);
foreach (DTO_DichVu dg in li)
{
txt_dongiachuyen.Text = dg.don_gia_chuyen.ToString();
txt_dongiatan.Text = dg.don_gia_tan.ToString();
}
}
}
private void grv_dichvu_CellClick(object sender, DataGridViewCellEventArgs e)
{
if (e.RowIndex < 0)
{
return;
}
DTO_DichVu DV = grv_dichvu.Rows[e.RowIndex].DataBoundItem as DTO_DichVu;
txt_khuvuc.Text = DV.khu_vuc;
txt_phanvung.Text = DV.phan_vung;
txt_dongiachuyen.Text = Convert.ToString(DV.don_gia_chuyen);
txt_dongiatan.Text = Convert.ToString(DV.don_gia_tan);
EnableControl(false);
MethodHelper.ClearErrorProvider();
EnableControl(false);
MethodHelper.ClearErrorProvider();
btn_luu.Enabled = false;
btn_sua.Enabled = true;
btn_xoa.Enabled = true;
}
private void btnXoa_Click(object sender, EventArgs e)
{
DialogResult dialog = MessageBox.Show("Bạn có muốn xóa dịch vụ này không?", "Thông báo", MessageBoxButtons.OKCancel, MessageBoxIcon.Question);
if (dialog == DialogResult.OK)
{
try
{
DTO_DichVu dichVu = new DTO_DichVu();
dichVu.HinhAnh = ResultTable.Rows[itemSelect][3].ToString();
dichVu.MaDichVu = Int32.Parse(ResultTable.Rows[itemSelect][0].ToString());
//Check State of Image
bool DeleteState = BUS_DichVu.DeleteDichVu(dichVu);
if (DeleteState)
{
DeleteImage();
imgListDichVu.Dispose();
lstHinhAnh.Items.Clear();
SetupImageListView();
MessageBox.Show("Xóa thành công!");
this.currentState = STATE.WAITING;
EnableFunctionsControl();
}
else
{
MessageBox.Show("Xóa thất bại!\nItem vẫn đang được sử dụng ở PhieuDatBan, vui lòng kiểm tra lại!");
}
}
catch (Exception ex)
{
MessageBox.Show("Thao tác xóa thất bại!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
}
private void bt_them_Click(object sender, EventArgs e)
{
if (txtMaDichVu.Text != "" && txtTenDichVu.Text != "" && txtDonGia.Text != "")
{
int DonGia = Convert.ToInt32(txtDonGia.Text);
if (DonGia <= 0)
{
MessageBox.Show("LỖI: Đơn giá không hợp lệ !");
}
else
{
DTO_DichVu dvu = new DTO_DichVu(txtMaDichVu.Text, txtTenDichVu.Text, txtMoTa.Text, DonGia, txtGhiChu.Text);
if (busYC6.insertDichVu(dvu))
{
MessageBox.Show("Thêm thành công");
datagv_dichvu.DataSource = busYC6.getDichVu();
txtMaDichVu.Text = "";
txtTenDichVu.Text = "";
txtDonGia.Text = "";
txtMoTa.Text = "";
txtGhiChu.Text = "";
txtMaDichVu.ReadOnly = false;
}
else
{
MessageBox.Show("LỖI: Thêm không thành công !");
}
}
}
else
{
MessageBox.Show("Xin hãy nhập đầy đủ các trường (Ghi Chú, Mô Tả có thể không nhập)");
}
}
