public void PhieuGiaCong_Del(String sophieugc) { PHIEUGIACONG phieugc = (from phieu in vbdq.PHIEUGIACONGs select phieu).Single(n => n.SoPhieuGiaCong.CompareTo(sophieugc) == 0); vbdq.PHIEUGIACONGs.DeleteOnSubmit(phieugc); vbdq.SubmitChanges(); }
public void PhieuGiaCong_Add(PhieuGiaCong_DTO pbh) { PHIEUGIACONG obj = new PHIEUGIACONG(); obj.SoPhieuGiaCong = pbh.SoPhieuGiaCong; obj.NgayLap = DateTime.Parse(pbh.NgayLap.ToString()); obj.TongTien = Decimal.Parse(pbh.TongTien.ToString()); vbdq.PHIEUGIACONGs.InsertOnSubmit(obj); vbdq.SubmitChanges(); }
private void LoadThongTinPgc() { BUL_PhieuGiaCong bulPhieuGiaCong = new BUL_PhieuGiaCong(); PHIEUGIACONG pgc = bulPhieuGiaCong.GetPhieuGiaCongById(_soPGC); _maNv = pgc.MaNV; LoadEmployeeName(_maNv); LoadTho(pgc.MaTho); dateEditNgayNhanHang.DateTime = pgc.NgayNhanHang; dateEditNgayThanhToan.DateTime = pgc.NgayThanhToan; }
private void simpleButtonLuu_Click(object sender, EventArgs e) { //Check logic condition if (comboBoxEditTenTho.SelectedIndex == -1) { MessageBox.Show(Resources.NhapPhieuGiaCong_TenThoEmpty, Resources.TitleMessageBox_Error, MessageBoxButtons.OK, MessageBoxIcon.Error); comboBoxEditTenTho.Focus(); return; } if (dateEditNgayNhanHang.Text.Equals("")) { MessageBox.Show(Resources.NhapPhieuGiaCong_NgayNhanHangEmpty, Resources.TitleMessageBox_Error, MessageBoxButtons.OK, MessageBoxIcon.Error); dateEditNgayNhanHang.Focus(); return; } if (dateEditNgayThanhToan.Text.Equals("")) { MessageBox.Show(Resources.NhapPhieuGiaCong_NgayThanhToanEmpty, Resources.TitleMessageBox_Error, MessageBoxButtons.OK, MessageBoxIcon.Error); dateEditNgayThanhToan.Focus(); return; } if (dateEditNgayNhanHang.DateTime > dateEditNgayThanhToan.DateTime) { MessageBox.Show(Resources.NhapPhieuGiaCong_NgayThanhToanTruocNgayNhanHang, Resources.TitleMessageBox_Error, MessageBoxButtons.OK, MessageBoxIcon.Error); dateEditNgayThanhToan.Focus(); return; } if (_dataTableCtpgcReview.Rows.Count == 0) { MessageBox.Show(Resources.NhapPhieuGiaCong_SLChiTietPGCToiThieu, Resources.TitleMessageBox_Error, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //Create PGC BUL_PhieuGiaCong bulPhieuGiaCong = new BUL_PhieuGiaCong(); PHIEUGIACONG phieugiacong = new PHIEUGIACONG(); phieugiacong.SoPhieuGC = _soPGC; phieugiacong.NgayThanhToan = dateEditNgayThanhToan.DateTime; phieugiacong.TongTien = Convert.ToDecimal(textEditTongTien.Text); bulPhieuGiaCong.UpdatePhieuGiaCong(phieugiacong); //Neu ok het MessageBox.Show(Resources.SuaPhieuGiaCong_SuaPGCThanhCong, Resources.TitleMessageBox_ThongBao, MessageBoxButtons.OK, MessageBoxIcon.Information); simpleButtonLuu.Enabled = false; simpleButtonThem.Enabled = false; simpleButtonXoa.Enabled = false; simpleButtonSua.Enabled = false; _isResultOk = true; Close(); }
private void simpleButtonLuu_Click(object sender, EventArgs e) { //Check logic condition if (comboBoxEditTenTho.SelectedIndex == -1) { MessageBox.Show(Resources.NhapPhieuGiaCong_TenThoEmpty, Resources.TitleMessageBox_Error, MessageBoxButtons.OK, MessageBoxIcon.Error); comboBoxEditTenTho.Focus(); return; } if (dateEditNgayNhanHang.Text.Equals("")) { MessageBox.Show(Resources.NhapPhieuGiaCong_NgayNhanHangEmpty, Resources.TitleMessageBox_Error, MessageBoxButtons.OK, MessageBoxIcon.Error); dateEditNgayNhanHang.Focus(); return; } if (dateEditNgayThanhToan.Text.Equals("")) { MessageBox.Show(Resources.NhapPhieuGiaCong_NgayThanhToanEmpty, Resources.TitleMessageBox_Error, MessageBoxButtons.OK, MessageBoxIcon.Error); dateEditNgayThanhToan.Focus(); return; } if (dateEditNgayNhanHang.DateTime != DateTime.Today) { MessageBox.Show(Resources.NgNhanHang, Resources.TitleMessageBox_Error, MessageBoxButtons.OK, MessageBoxIcon.Error); dateEditNgayNhanHang.Focus(); return; } if (dateEditNgayNhanHang.DateTime > dateEditNgayThanhToan.DateTime) { MessageBox.Show(Resources.NhapPhieuGiaCong_NgayThanhToanTruocNgayNhanHang, Resources.TitleMessageBox_Error, MessageBoxButtons.OK, MessageBoxIcon.Error); dateEditNgayThanhToan.Focus(); return; } if (_dataTableCtpgcReview.Rows.Count == 0) { MessageBox.Show(Resources.NhapPhieuGiaCong_SLChiTietPGCToiThieu, Resources.TitleMessageBox_Error, MessageBoxButtons.OK, MessageBoxIcon.Error); return; } //Create PGC BUL_PhieuGiaCong bulPhieuGiaCong = new BUL_PhieuGiaCong(); PHIEUGIACONG phieugiacong = new PHIEUGIACONG(); phieugiacong.NgayNhanHang = dateEditNgayNhanHang.DateTime; phieugiacong.NgayThanhToan = dateEditNgayThanhToan.DateTime; phieugiacong.MaTho = ((THO)((ContainerItem)comboBoxEditTenTho.SelectedItem).Value).MaTho; phieugiacong.TongTien = Convert.ToDecimal(textEditTongTien.Text); phieugiacong.MaNV = _maNV; int sophieuGc = bulPhieuGiaCong.AddNewPhieuGiaCong(phieugiacong); //Create CTPGC BUL_CTPGC bulCtpgc = new BUL_CTPGC(); foreach (DataRow dtRow in _dataTableCtpgcReview.Rows) { CTPGC ctpgc = new CTPGC(); ctpgc.SoPhieuGC = sophieuGc; ctpgc.Id = Convert.ToInt32(dtRow["Id"]); ctpgc.SoLuong = Convert.ToInt32(dtRow["SoLuong"]); ctpgc.TienCong = Convert.ToDecimal(dtRow["TienCong"]); ctpgc.ThanhTien = Convert.ToDecimal(dtRow["ThanhTien"]); ctpgc.TrongLuong = 0.1; bulCtpgc.AddNewCTPGC(ctpgc); } //Neu ok het MessageBox.Show(Resources.NhapPhieuGiaCong_TaoPGCThanhCong, Resources.TitleMessageBox_ThongBao, MessageBoxButtons.OK, MessageBoxIcon.Information); simpleButtonLuu.Enabled = false; simpleButtonThem.Enabled = false; simpleButtonXoa.Enabled = false; _isResultOk = true; Close(); }