public MemberAccountSummaryModel GetAccountSummary(string loyaltyId, string programCode, string externalId) { MemberAccountSummaryModel memberAccountSummaryOut = default; using (ConsoleCapture capture = new ConsoleCapture()) { try { var lwMemberPromo = lwSvc.GetAccountSummary(loyaltyId, programCode, externalId, out double time); memberAccountSummaryOut = LODConvert.FromLW <MemberAccountSummaryModel>(lwMemberPromo); } catch (LWClientException ex) { throw new LWServiceException(ex.Message, ex.ErrorCode); } catch (Exception ex) { throw new LWServiceException(ex.Message, -1); } finally { stepContext.AddAttachment(new Attachment("GetAccountSummary", capture.Output, Attachment.Type.Text)); } } return(memberAccountSummaryOut); }
public MemberAccountSummaryModel GetMemberAccountSummaryFromDB(string vckey) { StringBuilder query = new StringBuilder(); query.Append("select SUM(p.points) as currencybalance, lm.memberstatus, vc.createdate, md.a_tierenddate, md.a_lastactivitydate, md.a_mktgprogramid"); query.Append(" ,case when md.a_tiercode = 'RG' THEN 'Gold'"); query.Append(" when md.a_tiercode = 'FG' THEN 'Five Star'"); query.Append(" when md.a_tiercode = 'PC' THEN 'Presidents Circle'"); query.Append(" when md.a_tiercode = 'PL' THEN 'Platinum'"); query.Append(" when md.a_tiercode = 'PS' THEN 'Platinum Select'"); query.Append(" when md.a_tiercode = 'VP' THEN 'Platinum VIP'"); query.Append(" END as CURRENTTIERNAME"); query.Append(",case when lm.memberstatus = 1 THEN 'Active'"); query.Append(" when lm.memberstatus = 2 THEN 'Disabled'"); query.Append(" END as MEMBERSTATUS"); query.Append(" from bp_htz.ats_memberdetails md"); query.Append(" inner join bp_htz.lw_virtualcard vc on vc.ipcode = md.a_ipcode"); query.Append(" inner join bp_htz.lw_loyaltymember lm on lm.ipcode = vc.ipcode "); query.Append(" left join (select pt.vckey, pt.points, pt.expirationdate from bp_htz.lw_pointtransaction pt"); query.Append(" where pt.expirationdate > CURRENT_TIMESTAMP)p on p.vckey = vc.vckey"); query.Append($" where vc.vckey = {vckey}"); query.Append(" group by lm.memberstatus, vc.createdate, md.a_tierenddate, md.a_lastactivitydate, md.a_mktgprogramid"); query.Append(" ,case when md.a_tiercode = 'RG' THEN 'Gold'"); query.Append(" when md.a_tiercode = 'FG' THEN 'Five Star'"); query.Append(" when md.a_tiercode = 'PC' THEN 'Presidents Circle'"); query.Append(" when md.a_tiercode = 'PL' THEN 'Platinum'"); query.Append(" when md.a_tiercode = 'PS' THEN 'Platinum Select'"); query.Append(" when md.a_tiercode = 'VP' THEN 'Platinum VIP' END"); query.Append(" ,case when lm.memberstatus = 1 THEN 'Active'"); query.Append(" when lm.memberstatus = 2 THEN 'Disabled'"); query.Append(" END"); MemberAccountSummaryModel memberAccountSummary = dbContext.QuerySingleRow <MemberAccountSummaryModel>(query.ToString()); return(memberAccountSummary); }
public void GetAccountSummaryTestsTest_Positive(MemberModel createMember, IHertzProgram program) { MemberController memController = new MemberController(Database, TestStep); try { TestStep.Start("Assing Member unique LoyaltyIds for each virtual card", "Unique LoyaltyIds should be assigned"); createMember = memController.AssignUniqueLIDs(createMember); TestStep.Pass("Unique LoyaltyIds assigned", createMember.VirtualCards.ReportDetail()); TestStep.Start($"Make AddMember Call", "Member should be added successfully and member object should be returned"); MemberModel memberOut = memController.AddMember(createMember); AssertModels.AreEqualOnly(createMember, memberOut, MemberModel.BaseVerify); TestStep.Pass("Member was added successfully and member object was returned", memberOut.ReportDetail()); int transactionCount = 1; var memVirtualCard = memberOut.VirtualCards.First(); TestStep.Start($"Add random transaction(s) to members virtual card with VCKEY = {memVirtualCard.VCKEY}", "Transaction(s) should be added to members virtual card"); memVirtualCard.Transactions = TxnHeaderController.GenerateRandomTransactions(memVirtualCard, program, transactionCount, 500M); Assert.AreEqual(transactionCount, memVirtualCard.Transactions.Count, $"Expected {transactionCount} TxnHeader(s) to be present in members vitual card"); TestStep.Pass("Transaction(s) is added to members virtual card", memVirtualCard.Transactions.ReportDetail()); foreach (var transaction in memVirtualCard.Transactions) { transaction.A_TXNQUALPURCHASEAMT = TxnHeaderController.CalculateQualifyingPurchaseAmount(transaction); transaction.A_QUALTOTAMT = TxnHeaderController.CalculateQualifyingPurchaseAmount(transaction); } TestStep.Start("Update Existing Member with added transaction", "Member object should be returned from UpdateMember call"); MemberModel updatedMember = memController.UpdateMember(memberOut); Assert.IsNotNull(updatedMember, "Expected non null Member object to be returned"); TestStep.Pass("Member object returned from UpdateMember API call", updatedMember.ReportDetail()); var vckey = memVirtualCard.VCKEY.ToString(); TestStep.Start("Get Account Summary from DB", "Account Summary retrieved from DB"); MemberAccountSummaryModel memberAccountSummaryOutDb = memController.GetMemberAccountSummaryFromDB(vckey); Assert.IsNotNull(memberAccountSummaryOutDb, "Account Summary could not be retrieved from DB"); TestStep.Pass("Existing member was found", memberOut.ReportDetail()); var loyaltyId = memVirtualCard.LOYALTYIDNUMBER; var programCode = program != null ? program.EarningPreference : null; TestStep.Start("GetAccountSummary API call", "Account Summary retruned from API"); MemberAccountSummaryModel memberAccountSummaryOut = memController.GetAccountSummary(loyaltyId, programCode, null); Assert.IsNotNull(memberAccountSummaryOut, "Account Summary not returned from API"); TestStep.Pass("Account Summary was returned from API", memberOut.ReportDetail()); TestStep.Start("Compare Account Summary between DB and API", "Account Summary matches"); AssertModels.AreEqualWithAttribute(memberAccountSummaryOutDb, memberAccountSummaryOut); TestStep.Pass("Account Summary matches between DB and API", memberOut.ReportDetail()); } catch (LWServiceException ex) { TestStep.Fail(ex.Message, new[] { $"Error Code: {ex.ErrorCode}", $"Error Message: {ex.ErrorMessage}" }); Assert.Fail(); } catch (AssertModelEqualityException ex) { TestStep.Fail(ex.Message, ex.ComparisonFailures); Assert.Fail(); } catch (Exception ex) { TestStep.Abort(ex.Message); Assert.Fail(); } }
public void HertzTransferPoints_Positive(MemberModel memberSource, MemberModel memberDestionation, decimal points, IHertzTier tier, bool useRanum) { MemberController memController = new MemberController(Database, TestStep); try { //Generate unique LIDs for each virtual card in the member memberSource = memController.AssignUniqueLIDs(memberSource); string ranum; TestStep.Start($"Make AddMember Call", "Source Member should be added successfully"); MemberModel memberOutSource = memController.AddMember(memberSource); AssertModels.AreEqualOnly(memberSource, memberOutSource, MemberModel.BaseVerify); TestStep.Pass("Source Member was added successfully and member object was returned", memberOutSource.ReportDetail()); VirtualCardModel vcSource = memberOutSource.VirtualCards.First(); memberDestionation = memController.AssignUniqueLIDs(memberDestionation); TestStep.Start($"Make AddMember Call", "Destination Member should be added successfully"); MemberModel memberOutDestination = memController.AddMember(memberDestionation); AssertModels.AreEqualOnly(memberDestionation, memberOutDestination, MemberModel.BaseVerify); TestStep.Pass("Destination Member was added successfully and member object was returned", memberOutDestination.ReportDetail()); VirtualCardModel vcDestination = memberOutDestination.VirtualCards.First(); //Transactions are added to test the API with ranum and also to test the negative points scenario TestStep.Start($"Add Transaction to the source member", "Transactions added successfully"); vcSource.Transactions = TxnHeaderController.GenerateRandomTransactions(vcSource, tier.ParentProgram, 1, 500); if (useRanum) { ranum = vcSource.Transactions.Select(x => x.A_RANUM).First(); } else { ranum = null; } Assert.IsNotNull(vcSource.Transactions, "Expected populated transaction object, but transaction object returned was null"); TestStep.Pass("Transaction added to the source member", vcSource.Transactions.ReportDetail()); TestStep.Start("Update Existing Source Member with added transaction", "Source Member object should be returned from UpdateMember call"); MemberModel updatedMember = memController.UpdateMember(memberOutSource); Assert.IsNotNull(updatedMember, "Expected non null Member object to be returned"); TestStep.Pass("Member object returned from UpdateMember API call", updatedMember.ReportDetail()); var loyaltyIdSource = memberOutSource.VirtualCards.First().LOYALTYIDNUMBER; var loyaltyIdDestination = memberOutDestination.VirtualCards.First().LOYALTYIDNUMBER; var vckeySource = memberOutSource.VirtualCards.First().VCKEY.ToString(); var vckeyDestination = memberOutDestination.VirtualCards.First().VCKEY.ToString(); TestStep.Start("Get Account Summary from DB for Source Member", "Account Summary retrieved from DB"); MemberAccountSummaryModel memberAccountSummaryOutDbSourceInitial = memController.GetMemberAccountSummaryFromDB(vckeySource); Assert.IsNotNull(memberAccountSummaryOutDbSourceInitial, "Account Summary could not be retrieved from DB"); TestStep.Pass("Existing member was found", memberAccountSummaryOutDbSourceInitial.ReportDetail()); TestStep.Start("Get Account Summary from DB for Destination Member", "Account Summary retrieved from DB"); MemberAccountSummaryModel memberAccountSummaryOutDbDestinationInitial = memController.GetMemberAccountSummaryFromDB(vckeyDestination); Assert.IsNotNull(memberAccountSummaryOutDbDestinationInitial, "Account Summary could not be retrieved from DB"); TestStep.Pass("Existing member was found", memberAccountSummaryOutDbDestinationInitial.ReportDetail()); TestStep.Start($"Make HertzTransferPoints Call", "HertzTransferPoints call should return HertzTransferPoints object"); HertzTransferPointsResponseModel memberTransferPoints = memController.HertzTransferPoints(loyaltyIdSource, "csadmin", points.ToString(), loyaltyIdDestination, "automation"); Assert.IsNotNull(memberTransferPoints, "Expected populated HertzTransferPoints object, but HertzTransferPoints object returned was null"); TestStep.Pass("HertzTransferPoints object was returned", memberTransferPoints.ReportDetail()); TestStep.Start($"Verify CurrencyBalance of Source Member was decreased", "CurrencyBalance returned should be correct"); MemberAccountSummaryModel memberAccountSummaryOutDbSourceFinal = memController.GetMemberAccountSummaryFromDB(vckeySource); Assert.IsNotNull(memberAccountSummaryOutDbSourceFinal, "Account Summary could not be retrieved from DB"); Assert.AreEqual(memberAccountSummaryOutDbSourceInitial.CURRENCYBALANCE - points, memberAccountSummaryOutDbSourceFinal.CURRENCYBALANCE, $"CurrencyBalance wasn't decrease due TransferPoints"); TestStep.Pass("CurrencyBalance response is as expcted", memberAccountSummaryOutDbSourceFinal.ReportDetail()); TestStep.Start($"Verify CurrencyBalance of Destination Member was increased", "CurrencyBalance returned should be correct"); MemberAccountSummaryModel memberAccountSummaryOutDbDestinationFinal = memController.GetMemberAccountSummaryFromDB(vckeyDestination); Assert.IsNotNull(memberAccountSummaryOutDbDestinationFinal, "Account Summary could not be retrieved from DB"); Assert.AreEqual(memberAccountSummaryOutDbDestinationInitial.CURRENCYBALANCE + points, memberAccountSummaryOutDbDestinationFinal.CURRENCYBALANCE, $"CurrencyBalance wasn't decrease due TransferPoints"); TestStep.Pass("CurrencyBalance response is as expcted", memberAccountSummaryOutDbDestinationFinal.ReportDetail()); } catch (AssertionException ex) { TestStep.Fail(ex.Message); Assert.Fail(); } catch (LWServiceException ex) { TestStep.Fail(ex.Message, new[] { $"Error Code: {ex.ErrorCode}", $"Error Message: {ex.ErrorMessage}" }); Assert.Fail(); } catch (AssertModelEqualityException ex) { TestStep.Fail(ex.Message, ex.ComparisonFailures); Assert.Fail(); } catch (Exception ex) { TestStep.Abort(ex.Message); Assert.Fail(); } }
public void HertzAwardLoyaltyCurrency_Positive(MemberModel member, IHertzTier tier, string pointeventname, decimal points, bool useRanum) { MemberController memController = new MemberController(Database, TestStep); PointController pointController = new PointController(Database, TestStep); try { //Generate unique LIDs for each virtual card in the member member = memController.AssignUniqueLIDs(member); string ranum; TestStep.Start($"Make AddMember Call", "Member should be added successfully"); MemberModel memberOut = memController.AddMember(member); AssertModels.AreEqualOnly(member, memberOut, MemberModel.BaseVerify); TestStep.Pass("Member was added successfully and member object was returned", memberOut.ReportDetail()); VirtualCardModel vc = memberOut.VirtualCards.First(); //Transactions are added to test the API with ranum and also to test the negative points scenario TestStep.Start($"Add Transaction to the member", "Transactions added successfully"); vc.Transactions = TxnHeaderController.GenerateRandomTransactions(vc, tier.ParentProgram, 1, 200); if (useRanum) { ranum = vc.Transactions.Select(x => x.A_RANUM).First(); } else { ranum = null; } Assert.IsNotNull(vc.Transactions, "Expected populated transaction object, but transaction object returned was null"); TestStep.Pass("Transaction added to the member", vc.Transactions.ReportDetail()); TestStep.Start("Update Existing Member with added transaction", "Member object should be returned from UpdateMember call"); MemberModel updatedMember = memController.UpdateMember(memberOut); Assert.IsNotNull(updatedMember, "Expected non null Member object to be returned"); TestStep.Pass("Member object returned from UpdateMember API call", updatedMember.ReportDetail()); TestStep.Start("Find PointEventId in database", $"PointEventId should be found {pointeventname}"); IEnumerable <PointEventModel> pointEvent = pointController.GetPointEventIdsFromDb(pointeventname); decimal pointEventId = pointEvent.Select(x => x.POINTEVENTID).First(); Assert.IsTrue(pointEvent.Any(x => x.NAME.Equals(pointeventname)), "Expected pointevent name was not found in database"); TestStep.Pass("Pointevent name was found in the Database", pointEvent.ReportDetail()); var loyaltyId = memberOut.VirtualCards.First().LOYALTYIDNUMBER; TestStep.Start($"Make HertzAwardLoyaltyCurrency Call", "HertzAwardLoyaltyCurrency call should return HertzAwardLoyaltyCurrency object"); HertzAwardLoyaltyCurrencyResponseModel memberAwardLoyaltyCurrency = memController.HertzAwardLoyaltyCurrency(loyaltyId, "csadmin", points, Convert.ToInt64(pointEventId), "automation", ranum); Assert.IsNotNull(memberAwardLoyaltyCurrency, "Expected populated AwardLoyaltyCurrency object, but AwardLoyaltyCurrency object returned was null"); TestStep.Pass("HertzAwardLoyaltyCurrency object was returned", memberAwardLoyaltyCurrency.ReportDetail()); var vckey = memberOut.VirtualCards.First().VCKEY.ToString(); TestStep.Start("Get Account Summary from DB", "Account Summary retrieved from DB"); MemberAccountSummaryModel memberAccountSummaryOutDb = memController.GetMemberAccountSummaryFromDB(vckey); Assert.IsNotNull(memberAccountSummaryOutDb, "Account Summary could not be retrieved from DB"); TestStep.Pass("Existing member was found", memberAccountSummaryOutDb.ReportDetail()); TestStep.Start("Verify Points awarded matches the points in DB", "Points awarded matches the points in DB"); IEnumerable <PointTransactionModel> dbPointTransaction = pointController.GetPointTransactionsFromDb(decimal.Parse(vckey)).ToList(); Assert.IsNotNull(dbPointTransaction, "Expected populated PointTransaction object from database query, but PointTransaction object returned was null"); Assert.AreEqual(points, dbPointTransaction.Where(x => x.POINTEVENTID == pointEventId && x.POINTS == points).Select(x => x.POINTS).First(), $"Points awarded does not match database points{dbPointTransaction.Select(x => x.POINTS)} "); TestStep.Pass("Points awarded are added to the DB", dbPointTransaction.ReportDetail()); TestStep.Start($"Verify CurrencyBalance of HertzAwardLoyaltyCurrency", "CurrencyBalance returned should be correct"); Assert.AreEqual(dbPointTransaction.Sum(x => x.POINTS), memberAwardLoyaltyCurrency.CURRENCYBALANCE, $"CurrencyBalance does not match database points{dbPointTransaction.Select(x => x.POINTS)} "); Assert.AreEqual(0, memberAwardLoyaltyCurrency.CURRENCYTONEXTTIER, "CurrencyToNextTier does not match 0"); TestStep.Pass("CurrencyBalance response is as expcted", memberAwardLoyaltyCurrency.ReportDetail()); TestStep.Start("Compare Account Summary between DB and API", "Account Summary matches"); AssertModels.AreEqualWithAttribute(memberAccountSummaryOutDb, memberAwardLoyaltyCurrency); TestStep.Pass("Account Summary matches between DB and API", memberAccountSummaryOutDb.ReportDetail()); TestStep.Start($"Verify response of HertzAwardLoyaltyCurrency for GPR", "Response returned should be correct"); if (tier.ParentProgram.EarningPreference == "N1") { Assert.AreEqual(tier.RentalsToNextTier - vc.Transactions.Count(), memberAwardLoyaltyCurrency.RENTALSTONEXTTIER, $"RentalsToNextTier does not match {tier.RentalsToNextTier - vc.Transactions.Count()}"); Assert.AreEqual(tier.RevenueToNextTier - vc.Transactions.First().A_GRSREVNAMT, memberAwardLoyaltyCurrency.REVENUETONEXTTIER, $"RentalsToNextTier does not match {tier.RevenueToNextTier - vc.Transactions.First().A_GRSREVNAMT}"); Assert.AreEqual(vc.Transactions.Count(), memberAwardLoyaltyCurrency.TOTALRENTALSYTD, $"TotalRentalsYTD does not match {memberAwardLoyaltyCurrency.TOTALRENTALSYTD}"); Assert.AreEqual(vc.Transactions.Sum(x => x.A_GRSREVNAMT), memberAwardLoyaltyCurrency.TOTALREVENUEYTD, $"TotalRentalsYTD does not match {memberAwardLoyaltyCurrency.TOTALREVENUEYTD}"); Assert.AreEqual("Gold", memberAwardLoyaltyCurrency.CURRENTTIERNAME, $"CurrentTierName does not match {memberAwardLoyaltyCurrency.CURRENCYBALANCE}"); } TestStep.Pass("HertzAwardLoyaltyCurrency response is as expcted for GPR", memberAwardLoyaltyCurrency.ReportDetail()); } catch (AssertionException ex) { TestStep.Fail(ex.Message); Assert.Fail(); } catch (LWServiceException ex) { TestStep.Fail(ex.Message, new[] { $"Error Code: {ex.ErrorCode}", $"Error Message: {ex.ErrorMessage}" }); Assert.Fail(); } catch (AssertModelEqualityException ex) { TestStep.Fail(ex.Message, ex.ComparisonFailures); Assert.Fail(); } catch (Exception ex) { TestStep.Abort(ex.Message); Assert.Fail(); } }