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