public void CTPhieuGiaCong_Upd(CTGiaCong_DTO pbh)
{
var obj = vbdq.CTGIACONGs.Single(x => x.SoPhieuGiaCong == pbh.SoPhieuGiaCong && x.SoPhieuDV == pbh.SoPhieuDV && x.STT == pbh.STT);
obj.SoLuong = pbh.SoLuong;
obj.DonGia = pbh.DonGia;
obj.ThanhTien = Decimal.Parse(pbh.ThanhTien.ToString());
obj.MaTho = pbh.MaTho;
vbdq.SubmitChanges();
}
public FormCTPhieuGiaCong_AddUpd(CTGiaCong_DTO pbh)
{
InitializeComponent();
comboBox_MaTho.DataSource = ctphieugc_bus.LayDSMaTho();
comboBox_MaTho.ValueMember = "MaTho";
comboBox_MaTho.DisplayMember = "MaTho";
//
txtSoPhieugc.Text = pbh.SoPhieuGiaCong.ToString();
txtSoPhieudv.Text = pbh.SoPhieuDV.ToString();
txtSTT.Text = pbh.STT.ToString();
txtSoLuong.Text = pbh.SoLuong.ToString();
txtDonGia.Text = pbh.DonGia.ToString();
txtThanhTien.Text = pbh.ThanhTien.ToString();
comboBox_MaTho.SelectedValue = pbh.MaTho;
btnThem.Enabled = false;
}
private void btnCapNhat_Click(object sender, EventArgs e)
{
Decimal tien;
CTGiaCong_DTO phieugc = new CTGiaCong_DTO();
phieugc.SoPhieuGiaCong = Int16.Parse(txtSoPhieugc.Text);
phieugc.SoPhieuDV = Int16.Parse(txtSoPhieudv.Text);
phieugc.STT = Int16.Parse(txtSTT.Text);
phieugc.DonGia = Decimal.Parse(txtDonGia.Text);
phieugc.SoLuong = Int16.Parse(txtSoLuong.Text);
tien = phieugc.ThanhTien;
phieugc.ThanhTien = Decimal.Parse(txtThanhTien.Text);
phieugc.MaTho = Int16.Parse(comboBox_MaTho.SelectedValue.ToString());
ctphieugc_bus.CTPhieuGiaCong_Upd(phieugc);
ctphieugc_bus.CapNhatTongTien(phieugc.SoPhieuGiaCong, phieugc.SoPhieuDV, phieugc.STT, tien, 2);
this.Close();
}
private void btnThem_Click(object sender, EventArgs e)
{
if (txtSoPhieugc.Text.CompareTo("") != 0)
{
CTGiaCong_DTO phieugc = new CTGiaCong_DTO();
phieugc.SoPhieuGiaCong = Int16.Parse(txtSoPhieugc.Text);
phieugc.SoPhieuDV = Int16.Parse(txtSoPhieudv.Text);
phieugc.STT = Int16.Parse(txtSTT.Text);
phieugc.DonGia = Decimal.Parse(txtDonGia.Text);
phieugc.SoLuong = Int16.Parse(txtSoLuong.Text);
phieugc.ThanhTien = Decimal.Parse(txtThanhTien.Text);
phieugc.MaTho = Int16.Parse(comboBox_MaTho.SelectedValue.ToString());
ctphieugc_bus.CTPhieuGiaCong_Add(phieugc);
ctphieugc_bus.CapNhatTongTien(phieugc.SoPhieuGiaCong, phieugc.SoPhieuDV, phieugc.STT, 0, 1);
this.Close();
}
}
public void CTPhieuGiaCong_Add(CTGiaCong_DTO pbh)
{
CTGIACONG obj = new CTGIACONG();
obj.SoPhieuGiaCong = pbh.SoPhieuGiaCong;
obj.SoPhieuDV = pbh.SoPhieuDV;
obj.STT = pbh.STT;
obj.SoLuong = pbh.SoLuong;
obj.DonGia = pbh.DonGia;
obj.ThanhTien = Decimal.Parse(pbh.ThanhTien.ToString());
obj.MaTho = pbh.MaTho;
vbdq.CTGIACONGs.InsertOnSubmit(obj);
//update tinh trang cho phieu dv
var phieudv = vbdq.CTPHIEUDICHVUs.Single(x => x.STT == pbh.STT && x.SoPhieuDV == pbh.SoPhieuDV);
phieudv.TinhTrang = 1;
vbdq.SubmitChanges();
}
private void btnSua_Click(object sender, EventArgs e)
{
if (txtSoPhieugc.Text.CompareTo("") == 0)
{
MessageBox.Show("Vui lòng chọn dòng dữ liệu muốn Sửa !");
}
else
{
CTGiaCong_DTO phieugc = new CTGiaCong_DTO();
phieugc.SoPhieuGiaCong = Int16.Parse(txtSoPhieugc.Text);
phieugc.SoPhieuDV = Int16.Parse(txtSoPhieudv.Text);
phieugc.STT = Int16.Parse(txtSTT.Text);
phieugc.DonGia = Decimal.Parse(txtDonGia.Text);
phieugc.SoLuong = Int16.Parse(txtSoLuong.Text);
phieugc.ThanhTien = Decimal.Parse(txtThanhTien.Text);
phieugc.MaTho = Int32.Parse(txtMaTho.Text);
FormCTPhieuGiaCong_AddUpd form = new FormCTPhieuGiaCong_AddUpd(phieugc);
DialogResult dr = form.ShowDialog();
dataGridView.DataSource = ctphieugc_bus.LayTatCa(sophieugc);
}
}