public void SalesReceiptTransaction()
{
int empId = 5;
AddCommissionedEmployee t = new AddCommissionedEmployee(
empId, "Bob", "Home", 1000.00, 10, database);
t.Execute();
SalesReceiptTransaction srt = new SalesReceiptTransaction(
new DateTime(2005, 7, 31), 100.0, empId, database);
srt.Execute();
Employee e = database.GetEmployee(empId);
Assert.IsNotNull(e);
PaymentClassification pc = e.Classification;
Assert.IsTrue(pc is CommissionedClassification);
CommissionedClassification cc = pc as CommissionedClassification;
SalesReceipt sr = cc.GetSalesReceipt(new DateTime(2005, 7, 31));
Assert.IsNotNull(sr);
Assert.AreEqual(100, sr.Amount);
}
public async Task <bool> StoreNewSalesReceiptAsync(int InvoiceId, SalesReceipt SalesReceipt)
{
SalesReceipt.InvoiceId = InvoiceId;
_context.SalesReceipts.Add(SalesReceipt);
return((await _context.SaveChangesAsync()) > 0);
}
public void TestAddSalesReceiptTransaction()
{
#region Arrange
int employeeId = 5;
AddCommissionedEmployee t = new AddCommissionedEmployee(employeeId, "user", "home", 1000, 97.5);
t.Execute();
DateTime workingDate = new DateTime(2019, 4, 21);
SalesReceiptTransaction srt = new SalesReceiptTransaction(
employeeId, workingDate, 200
);
#endregion
#region Action
srt.Execute();
#endregion
#region Assert
Employee e = PayrollRepository.GetEmployee(employeeId);
e.Should().NotBeNull();
e.Classification.Should().BeOfType <CommissionedClassification>();
CommissionedClassification cc = e.Classification as CommissionedClassification;
SalesReceipt sr = cc.GetSalesReceipt(workingDate);
sr.Should().NotBeNull();
sr.Amount.Should().Be(200);
#endregion
}
public void TestSalesReceiptTransaction()
{
int empId = 5;
AddCommissionedEmployee t =
new AddCommissionedEmployee(
empId, "Bill", "Home", 2000, 15.25, database);
t.Execute();
SalesReceiptTransaction tct =
new SalesReceiptTransaction(
new DateTime(2005, 7, 31), 250.00, empId, database);
tct.Execute();
Employee e = database.GetEmployee(empId);
Assert.IsNotNull(e);
PaymentClassification pc = e.Classification;
Assert.IsTrue(pc is CommissionClassification);
CommissionClassification cc = pc as CommissionClassification;
SalesReceipt sr = cc.GetSalesReceipt(new DateTime(2005, 7, 31));
Assert.IsNotNull(sr);
Assert.AreEqual(250.00, sr.SaleAmount, .001);
}
public void SalesReceiptEmailToEmptyEmailAddressInBillEmailTest()
{
try
{
List <SalesReceipt> salesReceipts = Helper.FindAll <SalesReceipt>(dataServiceTestCases.GetContext(), new SalesReceipt(), 1, 10);
Assert.IsTrue(salesReceipts.Count > 0);
salesReceipts[0].BillEmail = new EmailAddress {
Address = ""
};
SalesReceipt updatedSalesReceipt = Helper.Update <SalesReceipt>(dataServiceTestCases.GetContext(), salesReceipts[0]);
Ipp.DataService.DataService service = new Ipp.DataService.DataService(dataServiceTestCases.GetContext());
SalesTransaction returnedEntity = service.SendEmail <SalesReceipt>(updatedSalesReceipt);
}
catch (IdsException idsEx)
{
Assert.IsNotNull(idsEx);
}
}
public void TestSalesReceiptTransaction()
{
int empId = 6;
DateTime saleDate = new DateTime(2017, 09, 07);
AddCommissionedEmployee t = new AddCommissionedEmployee(empId, "Commissioned", "Sertãozinho", 1000, 10, database);
t.Execute();
Employee e = database.GetEmployee(empId);
Assert.IsNotNull(e);
PaymentClassification pc = e.Classification;
Assert.IsTrue(pc is CommissionedClassification);
SalesReceiptTransaction srt = new SalesReceiptTransaction(empId, saleDate, 100.00, database);
srt.Execute();
CommissionedClassification cc = pc as CommissionedClassification;
SalesReceipt sr = cc.GetSalesReceipt(saleDate);
Assert.IsNotNull(sr);
Assert.AreEqual(100.00, sr.SaleAmount, .001);
}
public void SalesReceiptEmailToEmailAddressInBillEmailTest()
{
try
{
List <SalesReceipt> salesReceipts = Helper.FindAll <SalesReceipt>(dataServiceTestCases.GetContext(), new SalesReceipt(), 1, 10);
Assert.IsTrue(salesReceipts.Count > 0);
salesReceipts[0].BillEmail = new EmailAddress {
Address = "*****@*****.**"
};
SalesReceipt updatedSalesReceipt = Helper.Update <SalesReceipt>(dataServiceTestCases.GetContext(), salesReceipts[0]);
Ipp.DataService.DataService service = new Ipp.DataService.DataService(dataServiceTestCases.GetContext());
SalesTransaction returnedEntity = service.SendEmail <SalesReceipt>(updatedSalesReceipt);
}
catch (IdsException idsEx)
{
Assert.IsTrue(idsEx.Message == "Email address is either not in valid format or is not provided");
}
}
public void SalesReceiptAddTestUsingoAuth(ServiceContext qboContextoAuth)
{
//Creating the SalesReceipt for Add
SalesReceipt salesReceipt = QBOHelper.CreateSalesReceipt(qboContextoAuth);
//Adding the SalesReceipt
SalesReceipt added = Helper.Add <SalesReceipt>(qboContextoAuth, salesReceipt);
}
public void SalesReceiptAddAsyncTestsUsingoAuth(ServiceContext qboContextoAuth)
{
//Creating the SalesReceipt for Add
SalesReceipt entity = QBOHelper.CreateSalesReceipt(qboContextoAuth);
SalesReceipt added = Helper.AddAsync <SalesReceipt>(qboContextoAuth, entity);
}
public async Task <ActionResult> PostAsync(SalesReceipt model)
{
if (!this.ModelState.IsValid)
{
return(this.InvalidModelState(this.ModelState));
}
if (model.CashRepositoryId == 0 && model.BankAccountId == 0)
{
this.Failed(I18N.InvalidReceiptMode, HttpStatusCode.InternalServerError);
}
if (model.CashRepositoryId > 0 && (model.BankAccountId > 0 || !string.IsNullOrWhiteSpace(model.BankInstrumentCode) || !string.IsNullOrWhiteSpace(model.BankInstrumentCode)))
{
this.Failed(I18N.CashTransactionCannotContainBankTransactionDetails, HttpStatusCode.InternalServerError);
}
var meta = await AppUsers.GetCurrentAsync().ConfigureAwait(true);
model.UserId = meta.UserId;
model.OfficeId = meta.OfficeId;
model.LoginId = meta.LoginId;
try
{
long tranId = await Receipts.PostAsync(this.Tenant, model).ConfigureAwait(true);
return(this.Ok(tranId));
}
catch (Exception ex)
{
return(this.Failed(ex.Message, HttpStatusCode.InternalServerError));
}
}
public void TestSalesReceiptTransaction()
{
int empId = 4;
AddCommissionedEmployee t = new AddCommissionedEmployee(empId, "Bill", "Home", 2500, 3.2);
t.Execute();
SalesReceiptTransaction srt = new SalesReceiptTransaction(new DateTime(2005, 7, 31), 20, empId);
srt.Execute();
Employee e = PayrollDatabase.GetEmployee(empId);
Assert.IsNotNull(e);
PaymentClassification pc = e.Classification;
Assert.IsTrue(pc is CommissionedClassification);
CommissionedClassification hc = pc as CommissionedClassification;
SalesReceipt sr = hc.GetSalesReceipt(new DateTime(2005, 7, 31));
Assert.IsNotNull(sr);
Assert.AreEqual(20, sr.Amount);
}
public void TestSalesReceiptTransaction()
{
int empId = 5;
AddCommissionedEmployee t = new AddCommissionedEmployee(empId, "Bill", "Home", 1000.00, 15);
t.Execute();
SalesReceiptTransaction tct = new SalesReceiptTransaction(new DateTime(2005, 7, 31), 200.0, empId);
tct.Execute();
Employee e = PayrollDatabase.GetEmployee(empId);
Assert.IsNotNull(e);
PaymentClassification pc = e.Classification;
Assert.IsTrue(pc is ComissinedClassification);
ComissinedClassification hc = pc as ComissinedClassification;
SalesReceipt tc = hc.GetSalesReceipt(new DateTime(2005, 7, 31));
Assert.IsNotNull(tc);
Assert.AreEqual(200.0, tc.Amount);
}
public async Task <SalesReceipt> VoidSalesReceiptAsync(SalesReceipt receipt)
{
return(await PostRequest(receipt.VoidReturnObject() as SalesReceipt,
additionalParams : new Dictionary <string, string>
{
{ "operation", "void" }
}));
}
public void SalesReceiptQueryUsingoAuth()
{
QueryService <SalesReceipt> entityQuery = new QueryService <SalesReceipt>(qboContextoAuth);
SalesReceipt existing = Helper.FindOrAdd <SalesReceipt>(qboContextoAuth, new SalesReceipt());
//List<SalesReceipt> entities = entityQuery.Where(c => c.Id == existing.Id).ToList();
List <SalesReceipt> entities = entityQuery.ExecuteIdsQuery("SELECT * FROM SalesReceipt where Id='" + existing.Id + "'").ToList <SalesReceipt>();
Assert.IsTrue(entities.Count() > 0);
}
public void SalesReceiptVoidAsyncTestsUsingoAuth()
{
//Creating the SalesReceipt for Adding
SalesReceipt entity = QBOHelper.CreateSalesReceipt(qboContextoAuth);
//Adding the SalesReceipt
SalesReceipt added = Helper.Add <SalesReceipt>(qboContextoAuth, entity);
Helper.VoidAsync <SalesReceipt>(qboContextoAuth, added);
}
public void SalesReceiptFindByIdAsyncTestsUsingoAuth(ServiceContext qboContextoAuth)
{
//Creating the SalesReceipt for Adding
SalesReceipt entity = QBOHelper.CreateSalesReceipt(qboContextoAuth);
//Adding the SalesReceipt
SalesReceipt added = Helper.Add <SalesReceipt>(qboContextoAuth, entity);
//FindById and verify
Helper.FindByIdAsync <SalesReceipt>(qboContextoAuth, added);
}
public void SalesReceiptFindbyIdTestUsingoAuth()
{
//Creating the SalesReceipt for Adding
SalesReceipt salesReceipt = QBOHelper.CreateSalesReceipt(qboContextoAuth);
//Adding the SalesReceipt
SalesReceipt added = Helper.Add <SalesReceipt>(qboContextoAuth, salesReceipt);
SalesReceipt found = Helper.FindById <SalesReceipt>(qboContextoAuth, added);
QBOHelper.VerifySalesReceipt(found, added);
}
public SalesReceiptForm(SalesReceipt receipt)
{
InitializeComponent();
listViewItems.Resize += delegate { columnHeader2.Width = listViewItems.Width - 22 - (columnHeader1.Width + columnHeader3.Width + columnHeader4.Width + columnHeader5.Width + columnHeader6.Width + columnHeader7.Width); };
this.SalesReceipt = receipt;
newToolStripMenuItem.Click += delegate {
OnItemAdding(new SalesReceiptItemEventArgs(new SalesReceiptItem()));
};
}
public void SalesReceiptAddTestUsingoAuth()
{
//Creating the SalesReceipt for Add
SalesReceipt salesReceipt = QBOHelper.CreateSalesReceipt(qboContextoAuth);
//Adding the SalesReceipt
SalesReceipt added = Helper.Add <SalesReceipt>(qboContextoAuth, salesReceipt);
//Verify the added SalesReceipt
QBOHelper.VerifySalesReceipt(salesReceipt, added);
}
public void SalesReceiptSparseUpdateTestUsingoAuth(ServiceContext qboContextoAuth)
{
//Creating the SalesReceipt for Adding
SalesReceipt salesReceipt = QBOHelper.CreateSalesReceipt(qboContextoAuth);
//Adding the SalesReceipt
SalesReceipt added = Helper.Add <SalesReceipt>(qboContextoAuth, salesReceipt);
//Change the data of added entity
SalesReceipt changed = QBOHelper.SparseUpdateSalesReceipt(qboContextoAuth, added.Id, added.SyncToken);
//Update the returned entity data
SalesReceipt updated = Helper.Update <SalesReceipt>(qboContextoAuth, changed);//Verify the updated SalesReceipt
}
public void SalesReceiptUpdatedAsyncTestsUsingoAuth(ServiceContext qboContextoAuth)
{
//Creating the SalesReceipt for Adding
SalesReceipt entity = QBOHelper.CreateSalesReceipt(qboContextoAuth);
//Adding the SalesReceipt
SalesReceipt added = Helper.Add <SalesReceipt>(qboContextoAuth, entity);
//Update the SalesReceipt
SalesReceipt updated = QBOHelper.UpdateSalesReceipt(qboContextoAuth, added);
//Call the service
SalesReceipt updatedReturned = Helper.UpdateAsync <SalesReceipt>(qboContextoAuth, updated);
}
public async Task <long> PostAsync(string tenant, SalesReceipt model)
{
string connectionString = FrapidDbServer.GetConnectionString(tenant);
const string sql = @"EXECUTE sales.post_customer_receipt
@ValueDate, @BookDate,
@UserId, @OfficeId, @LoginId, @CustomerId,
@CurrencyCode, @CashAccountId, @Amount,
@ExchangeRateDebit, @ExchangeRateCredit,
@ReferenceNumber, @StatementReference,
@CostCenterId, @CashRepositoryId,
@PostedDate, @BankAccountId, @PaymentCardId, @BankInstrumentCode, @BankTranCode,
@TransactionMasterId OUTPUT
;";
using (var connection = new SqlConnection(connectionString))
{
using (var command = new SqlCommand(sql, connection))
{
command.Parameters.AddWithNullableValue("@ValueDate", model.ValueDate);
command.Parameters.AddWithNullableValue("@BookDate", model.BookDate);
command.Parameters.AddWithNullableValue("@UserId", model.UserId);
command.Parameters.AddWithNullableValue("@OfficeId", model.OfficeId);
command.Parameters.AddWithNullableValue("@LoginId", model.LoginId);
command.Parameters.AddWithNullableValue("@CustomerId", model.CustomerId);
command.Parameters.AddWithNullableValue("@CurrencyCode", model.CurrencyCode);
command.Parameters.AddWithNullableValue("@CashAccountId", model.CashAccountId);
command.Parameters.AddWithNullableValue("@Amount", model.Amount);
command.Parameters.AddWithNullableValue("@ExchangeRateDebit", model.DebitExchangeRate);
command.Parameters.AddWithNullableValue("@ExchangeRateCredit", model.CreditExchangeRate);
command.Parameters.AddWithNullableValue("@ReferenceNumber", model.ReferenceNumber);
command.Parameters.AddWithNullableValue("@StatementReference", model.StatementReference);
command.Parameters.AddWithNullableValue("@CostCenterId", model.CostCenterId);
command.Parameters.AddWithNullableValue("@CashRepositoryId", model.CashRepositoryId);
command.Parameters.AddWithNullableValue("@PostedDate", model.PostedDate);
command.Parameters.AddWithNullableValue("@BankAccountId", model.BankAccountId);
command.Parameters.AddWithNullableValue("@PaymentCardId", model.PaymentCardId);
command.Parameters.AddWithNullableValue("@BankInstrumentCode", model.BankInstrumentCode);
command.Parameters.AddWithNullableValue("@BankTranCode", model.BankTransactionCode);
command.Parameters.Add("@TransactionMasterId", SqlDbType.BigInt).Direction = ParameterDirection.Output;
connection.Open();
await command.ExecuteNonQueryAsync().ConfigureAwait(false);
return(command.Parameters["@TransactionMasterId"].Value.To <long>());
}
}
}
public void SalesReceiptUpdateTestUsingoAuth()
{
//Creating the SalesReceipt for Adding
SalesReceipt salesReceipt = QBOHelper.CreateSalesReceipt(qboContextoAuth);
//Adding the SalesReceipt
SalesReceipt added = Helper.Add <SalesReceipt>(qboContextoAuth, salesReceipt);
//Change the data of added entity
SalesReceipt changed = QBOHelper.UpdateSalesReceipt(qboContextoAuth, added);
//Update the returned entity data
SalesReceipt updated = Helper.Update <SalesReceipt>(qboContextoAuth, changed);//Verify the updated SalesReceipt
QBOHelper.VerifySalesReceipt(changed, updated);
}
public static QBResult AddSalesReceipt(SalesReceipt salesreceipt, string QBCompanyFile)
{
var saleXml = SalesReceiptViewModel.BuildSalesReceiptAddRq(salesreceipt);
if (saleXml != null)
{
var responseXml = QBPosContext.ProcessXML(saleXml.OuterXml, QBCompanyFile);
var addSalesReceipt = GetQBResult(responseXml);
addSalesReceipt.Comments = salesreceipt.Comments;
return(addSalesReceipt);
}
return(null);
}
public async Task <long> PostAsync(string tenant, SalesReceipt model)
{
string connectionString = FrapidDbServer.GetConnectionString(tenant);
const string sql = @"SELECT * FROM sales.post_customer_receipt
(
@ValueDate::date, @BookDate::date,
@UserId::integer, @OfficeId::integer, @LoginId::bigint, @CustomerId::integer,
@CurrencyCode::national character varying(12), @CashAccountId::integer, @Amount::public.money_strict,
@ExchangeRateDebit::public.decimal_strict, @ExchangeRateCredit::public.decimal_strict,
@ReferenceNumber::national character varying(24), @StatementReference::national character varying(128),
@CostCenterId::integer, @CashRepositoryId::integer,
@PostedDate::date, @BankAccountId::integer, @PaymentCardId::integer, @BankInstrumentCode::national character varying(128), @BankTranCode::national character varying(128)
);";
using (var connection = new NpgsqlConnection(connectionString))
{
using (var command = new NpgsqlCommand(sql, connection))
{
command.Parameters.AddWithNullableValue("@ValueDate", model.ValueDate);
command.Parameters.AddWithNullableValue("@BookDate", model.BookDate);
command.Parameters.AddWithNullableValue("@UserId", model.UserId);
command.Parameters.AddWithNullableValue("@OfficeId", model.OfficeId);
command.Parameters.AddWithNullableValue("@LoginId", model.LoginId);
command.Parameters.AddWithNullableValue("@CustomerId", model.CustomerId);
command.Parameters.AddWithNullableValue("@CurrencyCode", model.CurrencyCode);
command.Parameters.AddWithNullableValue("@CashAccountId", model.CashAccountId);
command.Parameters.AddWithNullableValue("@Amount", model.Amount);
command.Parameters.AddWithNullableValue("@ExchangeRateDebit", model.DebitExchangeRate);
command.Parameters.AddWithNullableValue("@ExchangeRateCredit", model.CreditExchangeRate);
command.Parameters.AddWithNullableValue("@ReferenceNumber", model.ReferenceNumber);
command.Parameters.AddWithNullableValue("@StatementReference", model.StatementReference);
command.Parameters.AddWithNullableValue("@CostCenterId", model.CostCenterId);
command.Parameters.AddWithNullableValue("@CashRepositoryId", model.CashRepositoryId);
command.Parameters.AddWithNullableValue("@PostedDate", model.PostedDate);
command.Parameters.AddWithNullableValue("@BankAccountId", model.BankAccountId);
command.Parameters.AddWithNullableValue("@PaymentCardId", model.PaymentCardId);
command.Parameters.AddWithNullableValue("@BankInstrumentCode", model.BankInstrumentCode);
command.Parameters.AddWithNullableValue("@BankTranCode", model.BankTransactionCode);
connection.Open();
var awaiter = await command.ExecuteScalarAsync().ConfigureAwait(false);
return(awaiter.To <long>());
}
}
}
protected void btnPlaceOrder_Click(object sender, EventArgs e)
{
string couponCode = CartSummary_Coupon?.Text;
string paymentMethod = PaymentTypeDDL?.SelectedValue;
MessageUserControl.TryRun(() => {
SalesCartController cartmgr = new SalesCartController();
SalesReceipt receipt = cartmgr.PlaceOrder(CurrentEmployeeID, couponCode, paymentMethod);
// clear the coupon code and payment method for the next customer
CartSummary_Coupon.Text = "";
PaymentTypeDDL.SelectedIndex = 0;
// switch the display to sales receipt mode and display receipt
ShowReceipt(receipt);
}, "Success", "Order registered. Use the top menu bar to start a new sale.");
}
public void SalesReceiptBatchUsingoAuth(ServiceContext qboContextoAuth)
{
Dictionary <OperationEnum, object> batchEntries = new Dictionary <OperationEnum, object>();
SalesReceipt existing = Helper.FindOrAdd(qboContextoAuth, new SalesReceipt());
batchEntries.Add(OperationEnum.create, QBOHelper.CreateSalesReceipt(qboContextoAuth));
batchEntries.Add(OperationEnum.update, QBOHelper.UpdateSalesReceipt(qboContextoAuth, existing));
batchEntries.Add(OperationEnum.query, "select * from SalesReceipt");
batchEntries.Add(OperationEnum.delete, existing);
ReadOnlyCollection <IntuitBatchResponse> batchResponses = Helper.Batch <SalesReceipt>(qboContextoAuth, batchEntries);
}
public void SalesReceiptDeleteTestUsingoAuth(ServiceContext qboContextoAuth)
{
//Creating the SalesReceipt for Adding
SalesReceipt salesReceipt = QBOHelper.CreateSalesReceipt(qboContextoAuth);
//Adding the SalesReceipt
SalesReceipt added = Helper.Add <SalesReceipt>(qboContextoAuth, salesReceipt);
//Delete the returned entity
try
{
SalesReceipt deleted = Helper.Delete <SalesReceipt>(qboContextoAuth, added);
}
catch (IdsException ex)
{
}
}
public void Create_CopiesAllProperties()
{
var salesReceipt = new SalesReceipt(1973)
{
Amount = 11m,
Date = DateTime.Now,
};
var id = _repository.Create(salesReceipt);
var storedReceipt = _repository.Get(id);
storedReceipt.Amount.Should().Be(salesReceipt.Amount);
storedReceipt.Date.Should().Be(salesReceipt.Date);
storedReceipt.EmployeeId.Should().Be(salesReceipt.EmployeeId);
storedReceipt.Id.Should().Be(id);
}
private void CreateSalesReceipt(
QuickBooksOnlineClient client,
int?customerId,
string taxCode,
int product,
DateTime date,
decimal amount,
string memo)
{
var salesReceipt = new SalesReceipt
{
CustomerRef = new PropertyRentalManagement.QuickBooksOnline.Models.Reference {
Value = customerId.ToString()
},
TxnDate = date.ToString("yyyy-MM-dd"),
TotalAmount = amount,
PrivateNote = memo,
Line = new List <SalesLine>
{
new SalesLine
{
Amount = amount,
DetailType = "SalesItemLineDetail",
SalesItemLineDetail = new SalesItemLineDetail
{
ItemRef = new PropertyRentalManagement.QuickBooksOnline.Models.Reference {
Value = product.ToString()
},
Quantity = 1,
UnitPrice = amount,
TaxCodeRef = new PropertyRentalManagement.QuickBooksOnline.Models.Reference {
Value = Constants.QUICKBOOKS_INVOICE_LINE_TAXABLE
}
}
}
},
TxnTaxDetail = new TxnTaxDetail
{
TxnTaxCodeRef = new PropertyRentalManagement.QuickBooksOnline.Models.Reference {
Value = taxCode
}
}
};
client.Create(salesReceipt);
}
public void AddSalesReceipt(SalesReceipt receipt)
{
salesReceipts[receipt.Date] = receipt;
}
