public async Task <IHttpActionResult> GetAccountHistory(int acctid, int days)
{
DateTime fromDate = DateTime.Now.AddDays(days * (-1));
string fromDateString = fromDate.ToString("MM-dd-yyyy");
string userId = RequestContext.Principal.Identity.GetUserId();
Guid fiId = Guid.Parse(fiIdString);
try
{
string encryptedPin = db.PINs.Where(p => p.FinancialInstitutionID == fiId && p.UserID == userId).Select(p => p.Pin).First();
string decryptedPin = Helpers.StringCipher.Decrypt(encryptedPin, userId);
var acct = db.AssociatedAccounts.Where(p => p.UserID == userId && p.AssociatedAccountID == acctid).First();
string[] rows = await COB.GetAccountHistory(acct.AccountNumber, acct.MemberID, decryptedPin, fromDateString);
string xml = string.Empty;
foreach (string row in rows)
{
string[] parts = row.Split(new string[] { "\t1" }, StringSplitOptions.RemoveEmptyEntries);
if (parts.Length > 1)
{
xml += parts[1];
}
}
xml = "<HISTORY>" + xml + "</HISTORY>";
XElement history = XElement.Parse(xml);
return(Ok(history));
}
catch (Exception ex)
{
return(Ok(ex.Message));
}
}
public async Task <AccountBalance[]> GetAccountBalanceArray(string acctnums)
{
List <AccountBalance> balanceList = new List <AccountBalance>();
string[] acctnumArray = acctnums.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
string userId = RequestContext.Principal.Identity.GetUserId();
Guid fiId = Guid.Parse(fiIdString);
string encryptedPin = db.PINs.Where(p => p.FinancialInstitutionID == fiId && p.UserID == userId).Select(p => p.Pin).First();
string decryptedPin = Helpers.StringCipher.Decrypt(encryptedPin, userId);
foreach (string acctnum in acctnumArray)
{
string[] balance = await COB.GetAccountBalance(acctnum, decryptedPin);
if (balance.Length > 1)
{
balanceList.Add(new AccountBalance {
AccountNumber = acctnum, CurrentBalance = balance[0], AvailableBalance = balance[1]
});
}
else
{
balanceList.Add(new AccountBalance {
AccountNumber = acctnum, CurrentBalance = "Error", AvailableBalance = "Error"
});
}
}
return(balanceList.ToArray());
}
private COB COB_AR; //AR: Direct Energy Rig
// ReSharper restore InconsistentNaming
public override void SetUpCob()
{
COB_CL = ResolveCob("CL", "Direct - Casualty - Marine Liability");
COB_CR = ResolveCob("CR", "Direct Casualty Energy Liability");
COB_AT = ResolveCob("AT", "Direct - Property - Hul");
COB_AV = ResolveCob("AV", "Direct Property Cargo");
COB_AW = ResolveCob("AW", "Direct - Property - War");
COB_AR = ResolveCob("AR", "Direct Energy Rig");
}
protected COB ResolveCob(string id, string narrative)
{
var cob = _consoleRepository.Query <COB>(c => c.Id == id).SingleOrDefault();
if (cob == null)
{
cob = new COB {
Id = id, Narrative = narrative, CreatedBy = "InitialSetup", CreatedOn = DateTime.Now, ModifiedBy = "InitialSetup", ModifiedOn = DateTime.Now
};
_consoleRepository.Add(cob);
}
return(cob);
}
public static void Setup(TestContext t)
{
using (IConsoleRepository _rep = new ConsoleRepository())
{
Team teamA = new Team() { Title = "Team A", DefaultPolicyType = "MARINE", QuoteExpiryDaysDefault = 30 };
_rep.Add<Team>(teamA);
Team teamB = new Team() { Title = "Team B", DefaultPolicyType = "MARINE", QuoteExpiryDaysDefault = 30 };
_rep.Add<Team>(teamB);
COB aa = new COB() { Id = "AA", Narrative = "AA" };
COB bb = new COB() { Id = "BB", Narrative = "BB" };
COB xx = new COB() { Id = "XX", Narrative = "XX" };
COB yy = new COB() { Id = "YY", Narrative = "YY" };
COB zz = new COB() { Id = "ZZ", Narrative = "ZZ" };
_rep.Add<COB>(aa);
_rep.Add<COB>(bb);
_rep.Add<COB>(xx);
_rep.Add<COB>(yy);
_rep.Add<COB>(zz);
teamA.RelatedCOBs = new List<COB>();
teamA.RelatedCOBs.Add(aa);
teamA.RelatedCOBs.Add(bb);
teamA.RelatedCOBs.Add(xx);
teamB.RelatedCOBs = new List<COB>();
teamB.RelatedCOBs.Add(xx);
teamB.RelatedCOBs.Add(yy);
teamB.RelatedCOBs.Add(zz);
User user1 = new User() { DomainLogon = @"talbot\user1", UnderwriterCode = "AED" };
_rep.Add<User>(user1);
_rep.SaveChanges();
newUserId = user1.Id;
TeamAId = teamA.Id;
TeamBId = teamB.Id;
}
context = new Mock<ICurrentHttpContext>();
var user = @"talbotdev\MurrayE";
context.Setup(h => h.CurrentUser).Returns(new GenericPrincipal(new GenericIdentity(user), null));
context.Setup(h => h.Context).Returns(MvcMockHelpers.FakeHttpContextWithSession());
}
public async Task <AccountBalance> GetAccountBalance(string acctnum)
{
string userId = RequestContext.Principal.Identity.GetUserId();
Guid fiId = Guid.Parse(fiIdString);
string encryptedPin = db.PINs.Where(p => p.FinancialInstitutionID == fiId && p.UserID == userId).Select(p => p.Pin).First();
string decryptedPin = Helpers.StringCipher.Decrypt(encryptedPin, userId);
string[] balance = await COB.GetAccountBalance(acctnum, decryptedPin);
if (balance.Length > 1)
{
return new AccountBalance {
AccountNumber = acctnum, CurrentBalance = balance[0], AvailableBalance = balance[1]
}
}
;
return(new AccountBalance {
AccountNumber = acctnum, CurrentBalance = "Error", AvailableBalance = "Error"
});
}
private COB COB_CL; //CL: Direct - Casualty - Marine Liability
// ReSharper restore InconsistentNaming
public override void SetUpCob()
{
COB_AY = _consoleRepository.Query <COB>(cob => cob.Id == "AY").SingleOrDefault();
COB_AY = COB_AY ?? new COB {
Id = "AY", Narrative = "Direct - Property - Yachts", CreatedBy = "InitialSetup", CreatedOn = DateTime.Now, ModifiedBy = "InitialSetup", ModifiedOn = DateTime.Now
};
COB_AT = _consoleRepository.Query <COB>(cob => cob.Id == "AT").SingleOrDefault();
COB_AT = COB_AT ?? new COB {
Id = "AT", Narrative = "Direct - Property - Hull", CreatedBy = "InitialSetup", CreatedOn = DateTime.Now, ModifiedBy = "InitialSetup", ModifiedOn = DateTime.Now
};
COB_AW = _consoleRepository.Query <COB>(cob => cob.Id == "AW").SingleOrDefault();
COB_AW = COB_AW ?? new COB {
Id = "AW", Narrative = "Direct - Property - War", CreatedBy = "InitialSetup", CreatedOn = DateTime.Now, ModifiedBy = "InitialSetup", ModifiedOn = DateTime.Now
};
COB_CL = _consoleRepository.Query <COB>(cob => cob.Id == "CL").SingleOrDefault();
COB_CL = COB_CL ?? new COB {
Id = "CL", Narrative = "Direct - Casualty - Marine Liability", CreatedBy = "InitialSetup", CreatedOn = DateTime.Now, ModifiedBy = "InitialSetup", ModifiedOn = DateTime.Now
};
}
// ReSharper restore InconsistentNaming
public override void SetUpCob()
{
COB_AK = ResolveCob("AK", "Direct - Property - Political Risk");
}
public AmtCollection CoordinationofBenefits(COB) TotalNon - Covered = new AmtCollection();
public AmtCollection CoordinationofBenefits(COB) PayerPaidAmount = new AmtCollection();
public void Setup()
{
_rep = new FakeConsoleRepository();
COB c = new COB() { Id = "CA", Narrative = "Cargo" };
Office off = new Office() { Id = "LON", Title = "London" };
List<User> users = new List<User>();
User u = new User() { DomainLogon = @"talbotdev\murraye" };
u.FilterCOBs = new List<COB>();
u.AdditionalCOBs = new List<COB>();
u.FilterOffices = new List<Office>();
u.AdditionalOffices = new List<Office>();
u.FilterMembers = new List<User>();
u.AdditionalUsers = new List<User>();
u.AdditionalCOBs.Add(c);
users.Add(u);
_rep.Users = users.AsQueryable();
List<globalVM::Validus.Models.Submission> subs = new List<globalVM::Validus.Models.Submission>();
for (int i = 0; i < 15; i++)
{
subs.Add(new globalVM::Validus.Models.Submission()
{
Id = i,
CreatedBy = "InitialSetup",
CreatedOn = DateTime.Now,
ModifiedBy = "InitialSetup",
ModifiedOn = DateTime.Now,
InsuredName = (i == 3 || i == 6 ? "Fergus Baillie" : "ALLAN MURRAY"),
BrokerCode = String.Format("11{0}", i),
BrokerPseudonym = "AAA",
BrokerSequenceId = 822,
InsuredId = 182396,
Brokerage = 1,
BrokerContact = "ALLAN MURRAY",
UnderwriterCode = "AED",
UnderwriterContactCode = "JAC",
QuotingOfficeId = "LON",
Leader = "AG",
Domicile = "AD",
Title = "Unit Test Submission",
Options = new List<Option>()
});
}
List<Option> options = new List<Option>();
Option o = new Option() { Title = "Test", SubmissionId = 3, Submission = subs[3] };
options.Add(o);
List<OptionVersion> optionVersions = new List<OptionVersion>();
OptionVersion ov = new OptionVersion() { Title = "Test", Option = o };
optionVersions.Add(ov);
List<Quote> quotes = new List<Quote>();
Quote q = new Quote() {
COB = c, COBId = c.Id,
OriginatingOffice = off,
OriginatingOfficeId = off.Id,
EntryStatus = "PARTIAL",
OptionVersion = ov,
SubscribeReference = "BAN169784A13"
};
quotes.Add(q);
ov.Quotes = quotes;
o.OptionVersions = optionVersions;
for (int i = 0; i < 15; i++)
{
subs[i].Options = options;
}
_rep.Submissions = subs.AsQueryable();
var mockSubscribeService = new Mock<IPolicyService>();
mockSubscribeService.Setup(s => s.CreateQuote(It.IsAny<CreateQuoteRequest>()))
.Returns(new CreateQuoteResponse
{
CreateQuoteResult = new StandardOutput { OutputXml = MvcMockHelpers.CreateQuoteResponseXml() },
objInfoCollection = new InfoCollection { PolId = "BAN165118A13" }
});
mockSubscribeService.Setup(s => s.GetReference(It.IsAny<GetReferenceRequest>()))
.Returns(new GetReferenceResponse
{
GetReferenceResult =
new StandardOutput {OutputXml = MvcMockHelpers.CreateGetReferenceResponseXml()}
});
var mockPolicyData = new Mock<IPolicyData>();
var context = new Mock<ICurrentHttpContext>();
var user = @"talbotdev\murraye";
//user = user.Replace(@"\\", @"\");
context.Setup(h => h.CurrentUser).Returns(new GenericPrincipal(new GenericIdentity(user), null));
context.Setup(h => h.Context).Returns(MvcMockHelpers.FakeHttpContextWithSession());
_webSiteModuleManager = new WebSiteModuleManager(_rep, context.Object);
_submissionModule = new SubmissionModule(_rep, mockSubscribeService.Object, new LogHandler(), context.Object, _webSiteModuleManager, mockPolicyData.Object);
//_submissionModule = new SubmissionModule(rep, null, null, cont);
}
public override void SetUpCob()
{
COB_AD = ResolveCob("AD", "Direct - Property - Contingency");
}
private COB COB_CC; //CR: Direct Casualty Energy Liability
public override void SetUpCob()
{
COB_AG = ResolveCob("AG", "Direct - Property - Construction");
COB_CC = ResolveCob("CC", "Direct - Casualty - Construction");
}
// ReSharper restore InconsistentNaming
public override void SetUpCob()
{
COB_AH = ResolveCob("AH", "Direct - Property - Accident and Health");
}
public async Task <IHttpActionResult> PostAssociateAccounts(string memberId, string pin)
{
string userId = RequestContext.Principal.Identity.GetUserId();
Guid fiId = Guid.Parse(fiIdString);
COBAccount[] memberAccountList = await COB.GetMemberAccountList(memberId, pin);
if (memberAccountList.Length > 0)
{
string encryptedPin = Helpers.StringCipher.Encrypt(pin, userId);
var userPin = db.PINs.Where(p => p.FinancialInstitutionID == fiId && p.UserID == userId).FirstOrDefault();
if (userPin == null)
{
userPin = new PIN
{
PINID = Guid.NewGuid(),
FinancialInstitutionID = fiId,
UserID = userId,
Pin = encryptedPin,
Updated = DateTime.Now
};
db.PINs.Add(userPin);
}
else
{
userPin.Pin = encryptedPin;
userPin.Updated = DateTime.Now;
}
db.SaveChanges();
//Gather existing associated accounts
var existingAccounts = db.AssociatedAccounts.Where(p => p.UserID == userId);
//Identify default account if exists
bool defaultSpecified = existingAccounts.Where(p => p.DefaultAccount).Count() > 0;
//only link accounts which do not currently exist
var newAccounts = from p in memberAccountList
where !existingAccounts.Select(q => q.AccountNumber).Contains(p.AcctNbr) &&
p.AcctStatusCode.Equals("ACT")
select new AssociatedAccount
{
FinancialInstitutionID = fiId,
MemberID = memberId,
UserID = userId,
AccountNumber = p.AcctNbr,
AccountType = p.MajorTypeDesc,
DefaultAccount = false,
Description = p.ProductCategoryDesc,
Description2 = p.MinorTypeDesc,
Description3 = p.MinorCustDesc,
Created = DateTime.Now,
Status = "Active",
Updated = DateTime.Now
//################################################
// TEST CODE
//################################################
,
Verified = DateTime.Now
//################################################
};
//Reactivate all existing accounts
foreach (AssociatedAccount acct in existingAccounts)
{
acct.Status = "Active";
acct.Updated = DateTime.Now;
}
db.AssociatedAccounts.AddRange(newAccounts);
db.SaveChanges();
var userAccounts = db.AssociatedAccounts.Where(p => p.UserID == userId && !COBExcludedAcctTypes.Contains(p.Description2));
//If no default account exists, create it
if (!defaultSpecified)
{
var newDefault = userAccounts.Where(p => p.AccountType == "Savings" && p.Description2.Equals("Deposits")).OrderByDescending(p => p.Created).FirstOrDefault();
if (newDefault != null)
{
newDefault.DefaultAccount = true;
db.SaveChanges();
}
}
MailSender.SendMessage(User.Identity.GetUserName(), "E-Pay - Account(s) Linked", "We have successfully linked one or more accounts to your profile.");
return(Ok(userAccounts));
}
return(Ok("No Accounts have been found."));
}
