private void btnSave_Click(object sender, EventArgs e)
{
//_sotienthu = 0;
if (spRemain.Value > 0)
{
_sotienthu = spPayment.Value;
}
else
{
_sotienthu = spMoneyShouldPay.Value;
}
m_CashReceiptVoucherObject = new CCashReceiptVoucherDTO("PT00000000",
lkCustomerName.EditValue.ToString(),
"NV0000001",
DateTime.ParseExact(labCRVDateValue.Text, "dd/MM/yyyy", null),
(int)_sotienthu);
m_CashReceiptVoucherExecute.AddCashReceiptVoucherToDatabase(m_CashReceiptVoucherObject);
//
decimal _sotienno = 0;
if (spRemain.Value > 0)
{
_sotienno = spRemain.Value;
}
m_CustomerObject = new CCustomerDTO();
m_CustomerObject.maKhachHang = lkCustomerName.EditValue.ToString();
m_CustomerObject.tenKhachHang = lkCustomerName.Text;
m_CustomerObject.diaChi = txtCustomerAddress.Text;
m_CustomerObject.soDienThoai = txtCustomerPhone.Text;
m_CustomerObject.Email = txtCustomerEmail.Text;
m_CustomerObject.tienNo = (int)_sotienno;
m_CustomerExecute.UpdateDebitOfCustomerDataToDatabase(m_CustomerObject);
}
public bool DeleteCashReceiptVoucherToDatabase(CCashReceiptVoucherDTO _CashReceiptVoucherObject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "DeleteCashReceiptVoucherDataToDatabase";
m_cmd.Parameters.Add("MaPhieuNhap", SqlDbType.NVarChar).Value = _CashReceiptVoucherObject.maPhieuThu;
return(m_CashReceiptVoucherExecute.updateData(m_cmd) > 0);
}
public frmCashReceiptVoucher()
{
InitializeComponent();
m_CashReceiptVoucherObject = new CCashReceiptVoucherDTO();
m_CashReceiptVoucherExecute = new CCashReceiptVoucherBUS();
m_CustomerData = new DataTable();
m_CustomerExecute = new CCustomerBUS();
}
public frmCashReceiptVoucher()
{
InitializeComponent();
m_CashReceiptVoucherObject = new CCashReceiptVoucherDTO();
m_CashReceiptVoucherExecute = new CCashReceiptVoucherBUS();
m_CustomerData = new DataTable();
m_CustomerExecute = new CCustomerBUS();
btnView.Enabled = false;
btnSave.Enabled = false;
}
public frmCashReceiptVoucher(String _maKhachHang, decimal _tienMuaHang)
{
InitializeComponent();
m_CashReceiptVoucherObject = new CCashReceiptVoucherDTO();
m_CashReceiptVoucherExecute = new CCashReceiptVoucherBUS();
m_CustomerData = new DataTable();
m_CustomerExecute = new CCustomerBUS();
m_maKhachHang = _maKhachHang;
m_tienMuaHang = _tienMuaHang;
}
public bool UpdateCashReceiptVoucherToDatabase(CCashReceiptVoucherDTO _CashReceiptVoucherObject)
{
m_cmd = new SqlCommand();
m_cmd.CommandType = CommandType.StoredProcedure;
m_cmd.CommandText = "UpdateCashReceiptVoucherDataToDatabase";
m_cmd.Parameters.Add("MaPhieuThu", SqlDbType.NVarChar).Value = _CashReceiptVoucherObject.maPhieuThu;
m_cmd.Parameters.Add("MaKH", SqlDbType.NVarChar).Value = _CashReceiptVoucherObject.maKhachHang;
m_cmd.Parameters.Add("MaNV", SqlDbType.NVarChar).Value = _CashReceiptVoucherObject.maNhanVien;
m_cmd.Parameters.Add("NgayThu", SqlDbType.SmallDateTime).Value = _CashReceiptVoucherObject.ngayThu;
m_cmd.Parameters.Add("SoTienThu", SqlDbType.Int).Value = _CashReceiptVoucherObject.soTienThu;
return(m_CashReceiptVoucherExecute.updateData(m_cmd) > 0);
}
public frmCashReceiptVoucher(String _maKhachHang, decimal _tienMuaHang)
{
InitializeComponent();
m_CashReceiptVoucherObject = new CCashReceiptVoucherDTO();
m_CashReceiptVoucherExecute = new CCashReceiptVoucherBUS();
m_CustomerData = new DataTable();
m_CustomerExecute = new CCustomerBUS();
m_maKhachHang = _maKhachHang;
m_tienMuaHang = _tienMuaHang;
lkCustomerName.Properties.ReadOnly = true;
btnAdd.Enabled = false;
m_saveCashReceiptVoucher = true;
}
private void btnSave_Click(object sender, EventArgs e)
{
//_sotienthu = 0;
if (lkCustomerName.Text == "")
{
XtraCustomMessageBox.Show("Thông tin khách hàng không được trống!", "Thông báo", true);
return;
}
if (spMoneyShouldPay.Value == 0)
{
XtraCustomMessageBox.Show("Khách hàng không còn nợ!\nXin vui lòng chọn khách hàng khác!", "Thông báo", true);
return;
}
try
{
m_saveCashReceiptVoucher = false;
_sotienthu = spPayment.Value;
m_CashReceiptVoucherObject = new CCashReceiptVoucherDTO("PT00000000",
lkCustomerName.EditValue.ToString(),
ucLogin.m_EmployeeObject.maNhanVien,
DateTime.ParseExact(labCRVDateValue.Text, "dd/MM/yyyy", null),
(int)_sotienthu);
m_CashReceiptVoucherExecute.AddCashReceiptVoucherToDatabase(m_CashReceiptVoucherObject);
//
if (spRemain.Value < 0)
{
_sotienno = -(spRemain.Value);
}
m_CustomerObject = new CCustomerDTO();
m_CustomerObject.maKhachHang = lkCustomerName.EditValue.ToString();
m_CustomerObject.tenKhachHang = lkCustomerName.Text;
m_CustomerObject.diaChi = txtCustomerAddress.Text;
m_CustomerObject.soDienThoai = txtCustomerPhone.Text;
m_CustomerObject.Email = txtCustomerEmail.Text;
m_CustomerObject.tienNo = (int)_sotienno;
m_CustomerExecute.UpdateLiabilitiesDataToDataBase(m_CustomerObject.maKhachHang, (int)_sotienno, DateTime.ParseExact(labCRVDateValue.Text, "dd/MM/yyyy", null));
if (m_CustomerExecute.UpdateDebitOfCustomerDataToDatabase(m_CustomerObject))
{
XtraCustomMessageBox.Show("Lưu dữ liệu thành công!", "Thông báo", true);
btnView.Enabled = true;
}
else
{
XtraCustomMessageBox.Show("Lưu dữ liệu thất bại!", "Lỗi", true);
}
}
catch (System.Exception)
{
XtraCustomMessageBox.Show("Lưu dữ liệu thất bại!", "Lỗi", true);
}
}
public bool UpdateCashReceiptVoucherToDatabase(CCashReceiptVoucherDTO _CashReceiptVoucherObject)
{
return(m_CashReceiptVoucherDAL.UpdateCashReceiptVoucherToDatabase(_CashReceiptVoucherObject));
}
public CCashReceiptVoucherDAL()
{
m_CashReceiptVoucherObject = null;
m_CashReceiptVoucherExecute = new CDataExecute();
m_cmd = new SqlCommand();
}
public CCashReceiptVoucherDAL(CCashReceiptVoucherDTO _CashReceiptVoucherObject)
{
m_CashReceiptVoucherObject = _CashReceiptVoucherObject;
m_CashReceiptVoucherExecute = new CDataExecute();
m_cmd = new SqlCommand();
}
