private void btnDelete_Click(object sender, RoutedEventArgs e) { MessageBoxResult result = MessageBox.Show("Bạn có muốn xóa dòng này?", "Confirmation", MessageBoxButton.YesNo); if (result == MessageBoxResult.Yes) { if (dgvReceipt.SelectedItem != null) { DTO_PhieuChi obj = dgvReceipt.SelectedItem as DTO_PhieuChi; String id = obj.MaPhieuChi; BUS_PhieuChi.DeletePC(id); dgvReceipt.ItemsSource = BUS_PhieuChi.showData(); } } }
public PrintForm_PhieuChi(Grid gridMain, DTO_PhieuChi obj) { InitializeComponent(); this.gridMain = gridMain; this.phieuChi = obj; report.SetParameterValue("pID", phieuChi.MaPhieuChi); report.SetParameterValue("pDate", phieuChi.NgayChi); report.SetParameterValue("pEditDate", phieuChi.NgayChinhSua); report.SetParameterValue("pEmployeeName", phieuChi.TenNhanVien); report.SetParameterValue("pImportID", phieuChi.MaPhieuNhap); report.SetParameterValue("pNote", phieuChi.GhiChu); report.SetParameterValue("pSumMoney", phieuChi.TongTienChi); reportViewer.ViewerCore.ReportSource = report; }
public void InsertPC(DTO_PhieuChi obj) { using (CellphoneComponentEntities db = new CellphoneComponentEntities()) { var result = db.Database .SqlQuery <String>("select MaNhanVien from dbo.NhanVien where TenNhanVien = N'" + obj.TenNhanVien + "'") .FirstOrDefault(); PhieuChi phieuChi = new PhieuChi(); phieuChi.MaPhieuChi = obj.MaPhieuChi; phieuChi.NgayChi = obj.NgayChi; phieuChi.NgayChinhSua = obj.NgayChinhSua; phieuChi.MaPhieuNhap = obj.MaPhieuNhap; phieuChi.GhiChu = obj.GhiChu; phieuChi.TongTienChi = obj.TongTienChi; phieuChi.MaNhanVien = result; db.PhieuChis.Add(phieuChi); db.SaveChanges(); } }
public UI_ThemPhieuChi(Grid gridMain, DTO_PhieuChi obj) { InitializeComponent(); this.gridMain = gridMain; if (obj == null) { AutoGenerateID(); dpReceiptEditDate.SelectedDate = DateTime.Today; dpReceiptDate.SelectedDate = DateTime.Today; txtEmployeeName.Text = Properties.Settings.Default.TenNhanVien; isNew = true; } else { txtReceiptID.Text = obj.MaPhieuChi; txtEmployeeName.Text = obj.TenNhanVien; cbbImportID.Text = obj.MaPhieuNhap; txtReceiptNote.Text = obj.GhiChu; txtSumMoney.Text = BUS_PhieuChi.Instance.sumMoneyPC(obj.MaPhieuNhap).ToString(); dpReceiptDate.SelectedDate = obj.NgayChi; dpReceiptEditDate.SelectedDate = obj.NgayChinhSua; isNew = false; } }
public void UpdatePC(DTO_PhieuChi obj) { PhieuChi.Instance.UpdatePC(obj); }
public void InsertPC(DTO_PhieuChi obj) { PhieuChi.Instance.InsertPC(obj); }