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