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