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