/// <summary> /// Deprecated Method for adding a new object to the C7_10tblGPPaymentInstructions EntitySet. Consider using the .Add method of the associated ObjectSet<T> property instead. /// </summary> public void AddToC7_10tblGPPaymentInstructions(C7_10tblGPPaymentInstructions c7_10tblGPPaymentInstructions) { base.AddObject("C7_10tblGPPaymentInstructions", c7_10tblGPPaymentInstructions); }
private static DeepBlue.Models.Entity.UnderlyingFund GetUnderlyingFundFromBlue(C7_10tblGPPaymentInstructions blueUFund) { DeepBlue.Models.Entity.UnderlyingFund uf = new DeepBlue.Models.Entity.UnderlyingFund(); uf.EntityID = Globals.DefaultEntityID; // ToDO: IssuerID uf.FundName = blueUFund.Fund; uf.FundTypeID = GetFundType(blueUFund.FundType); uf.IsFeesIncluded = blueUFund.FeesInside.HasValue ? blueUFund.FeesInside.Value : false; uf.VintageYear = blueUFund.VintageYear.HasValue ? (short?)blueUFund.VintageYear : null; // TODO: Convert FundSize to money in DB and re-gen the model uf.TotalSize = Convert.ToInt32(blueUFund.FundSize); if (blueUFund.TerminationDate.HasValue) { uf.TerminationYear = Convert.ToInt16(blueUFund.TerminationDate.Value.Year); } // WARNING: these fields are present in blue but absent in deepblue // What are these fields used for in blue? //blueUFund.Website; //blueUFund.WebLogin; //blueUFund.WebPassword; uf.IndustryID = GetIndustryFocus(blueUFund.Industry_Focus); uf.GeographyID = Globals.Geograpies.First().GeographyID; uf.ReportingFrequencyID = GetReportingFrequency(blueUFund.Reporting); uf.ReportingTypeID = GetReportingType(blueUFund.ReportingType); uf.Description = Globals.DefaultString; Contact contact = new Contact(); contact.ContactName = blueUFund.ContactName; if (!string.IsNullOrEmpty(blueUFund.Phone)) { Communication comm = new Communication() { CommunicationTypeID = (int)DeepBlue.Models.Admin.Enums.CommunicationType.WorkPhone, CommunicationValue = blueUFund.Phone }; contact.ContactCommunications.Add(new ContactCommunication() { Communication = comm }); } if (!string.IsNullOrEmpty(blueUFund.Email_address)) { Communication comm = new Communication() { CommunicationTypeID = (int)DeepBlue.Models.Admin.Enums.CommunicationType.Email, CommunicationValue = blueUFund.Email_address }; contact.ContactCommunications.Add(new ContactCommunication() { Communication = comm }); } //uf.FundRegisteredOfficeID // TODO: use uf.FundRegisteredOfficeID to store the address Address address = new Address(); address.Address1 = blueUFund.MailingAddress1; address.Address2 = blueUFund.MailingAddress2; string[] parts = new string[3]; if (Util.ParseAddress(address.Address2, out parts)) { address.City = parts[0]; address.State = Globals.States.Where(x => x.Abbr == parts[1].ToUpper().Trim()).First().StateID; address.PostalCode = parts[2]; } address.AddressTypeID = (int)DeepBlue.Models.Admin.Enums.AddressType.Work; address.Country = Globals.DefaultCountryID; //ContactAddress contactAddress = new ContactAddress(); // contactAddress.Address = address; // contact.ContactAddresses.Add(contactAddress); Account account = new Account(); account.BankName = blueUFund.Bank; account.Routing = Convert.ToInt32(blueUFund.ABANumber.Replace("-", string.Empty).Replace(" ", string.Empty)); account.AccountOf = blueUFund.Accountof; account.Account1 = blueUFund.AccountNumber; account.Attention = blueUFund.Attn; account.Reference = blueUFund.Reference; // WARNING: the following fields are present in DeepBlue, but are not present in Blue //uf.LegalFundName //uf.FiscalYearEnd //uf.IsDomestic //uf.FundStructureId //uf.Taxable //uf.Exempt //uf.AddressID //uf.managementfee //uf.incentivefee //uf.taxrate //uf.auditorname //uf.managercontactid //uf.shareclasstypeid //uf.investmenttypeid //account.Phone; //account.Fax; //account.IBAN; //account.FFC; //account.FFCNumber; //account.SWIFT; //account.AccountNumberCash return uf; }
/// <summary> /// Create a new C7_10tblGPPaymentInstructions object. /// </summary> /// <param name="fund">Initial value of the Fund property.</param> /// <param name="sSMA_TimeStamp">Initial value of the SSMA_TimeStamp property.</param> public static C7_10tblGPPaymentInstructions CreateC7_10tblGPPaymentInstructions(global::System.String fund, global::System.Byte[] sSMA_TimeStamp) { C7_10tblGPPaymentInstructions c7_10tblGPPaymentInstructions = new C7_10tblGPPaymentInstructions(); c7_10tblGPPaymentInstructions.Fund = fund; c7_10tblGPPaymentInstructions.SSMA_TimeStamp = sSMA_TimeStamp; return c7_10tblGPPaymentInstructions; }
private static DeepBlue.Models.Entity.UnderlyingFund GetUnderlyingFundFromBlue(C7_10tblGPPaymentInstructions blueUFund, out Address fundRegisteredOffice) { DeepBlue.Models.Entity.UnderlyingFund uf = new DeepBlue.Models.Entity.UnderlyingFund(); uf.EntityID = Globals.DefaultEntityID; // ToDO: IssuerID uf.FundName = blueUFund.Fund; uf.FundTypeID = GetFundType(blueUFund.FundType); uf.IsFeesIncluded = blueUFund.FeesInside.HasValue ? blueUFund.FeesInside.Value : false; uf.VintageYear = blueUFund.VintageYear.HasValue ? (short?)blueUFund.VintageYear : null; // TODO: Convert FundSize to money in DB and re-gen the model try { uf.TotalSize = Convert.ToInt32(blueUFund.FundSize); } catch { uf.TotalSize = Int32.MaxValue; } if (blueUFund.TerminationDate.HasValue) { uf.TerminationYear = Convert.ToInt16(blueUFund.TerminationDate.Value.Year); } // WARNING: these fields are present in blue but absent in deepblue // What are these fields used for in blue? //blueUFund.Website; uf.GeographyID = Globals.Geograpies.First().GeographyID; // WARNING: We dont use the InvestmentTypeID. Do we really need this? // uf.InvestmentTypeID // ShareClass type can be added via the admin screen. However, we dont ask for it when creating a new UF. Should we not ask for it? // uf.ShareClassType // We dont use this field,a s there is no UI element for it. // uf.FundStructureID uf.WebUserName = blueUFund.WebLogin; uf.WebPassword = blueUFund.WebPassword; uf.IndustryID = GetIndustryFocus(blueUFund.Industry_Focus); uf.ReportingFrequencyID = GetReportingFrequency(blueUFund.Reporting); uf.ReportingTypeID = GetReportingType(blueUFund.ReportingType); uf.Description = Globals.DefaultString + blueUFund.Comments ?? string.Empty; // description cannot be over 100 characters if (uf.Description.Length > 100) { uf.Description = uf.Description.Substring(0, 100); } Contact contact = new Contact(); contact.ContactName = blueUFund.ContactName; if (!string.IsNullOrEmpty(blueUFund.Phone)) { Communication comm = new Communication() { CommunicationTypeID = (int)DeepBlue.Models.Admin.Enums.CommunicationType.WorkPhone, CommunicationValue = blueUFund.Phone }; contact.ContactCommunications.Add(new ContactCommunication() { Communication = comm }); } if (!string.IsNullOrEmpty(blueUFund.Email_address)) { Communication comm = new Communication() { CommunicationTypeID = (int)DeepBlue.Models.Admin.Enums.CommunicationType.Email, CommunicationValue = blueUFund.Email_address }; contact.ContactCommunications.Add(new ContactCommunication() { Communication = comm }); } if (!string.IsNullOrEmpty(contact.ContactName)) { uf.UnderlyingFundContacts.Add(new UnderlyingFundContact() { Contact = contact }); } //uf.FundRegisteredOfficeID // TODO: use uf.FundRegisteredOfficeID to store the address // This is the Fund's registered office address, and not the contact's address Address address = null; if (!string.IsNullOrEmpty(blueUFund.MailingAddress1) || !string.IsNullOrEmpty(blueUFund.MailingAddress2)) { address = new Address(); if (!string.IsNullOrEmpty(blueUFund.MailingAddress1)) { address.Address1 = blueUFund.MailingAddress1; } else { address.Address1 = Globals.DefaultStringValue; } // Address 1 has to be less than or equal to 40 characters if (address.Address1.Length > 40) { address.Address1 = address.Address1.Substring(0, 40); } address.Address2 = blueUFund.MailingAddress2; // Address 2 has to be less than or equal to 40 characters if (!string.IsNullOrEmpty(address.Address2) && address.Address2.Length > 40) { address.Address2 = address.Address2.Substring(0, 40); } //string[] parts = new string[3]; //if (Util.ParseAddress(address.Address2, out parts)) { // address.City = parts[0]; // address.State = Globals.States.Where(x => x.Abbr == parts[1].ToUpper().Trim()).First().StateID; // address.PostalCode = parts[2]; //} Util.SetAddress(address.Address2, address); address.AddressTypeID = (int)DeepBlue.Models.Admin.Enums.AddressType.Work; address.Country = Globals.DefaultCountryID; } else { // We have to have the address.. The UI enforces us to have an address address = new Address(); address.Address1 = Globals.DefaultAddress1; address.AddressTypeID = (int)DeepBlue.Models.Admin.Enums.AddressType.Work; address.City = Globals.DefaultCity; address.State = Globals.DefaultStateID; address.PostalCode = Globals.DefaultZip; address.Country = Globals.DefaultCountryID; messageLog.AppendLine("WARNING: " + uf.FundName + " doesnt have an address, so using default address"); } fundRegisteredOffice = address; // You have to have an account# for a successful account to be created if (!string.IsNullOrEmpty(blueUFund.AccountNumber)) { Account account = new Account(); account.BankName = blueUFund.Bank; try { account.Routing = Convert.ToInt32(blueUFund.ABANumber.Replace("-", string.Empty).Replace(" ", string.Empty)); } catch { account.Routing = 111000025; } account.AccountOf = blueUFund.Accountof; if (!string.IsNullOrEmpty(blueUFund.AccountNumber)) { account.Account1 = blueUFund.AccountNumber; } else { account.Account1 = "dummy_account"; } account.Attention = blueUFund.Attn; account.Reference = blueUFund.Reference; uf.Account = account; } // WARNING: the following fields are present in DeepBlue, but are not present in Blue //uf.LegalFundName uf.LegalFundName = uf.FundName; //uf.FiscalYearEnd //uf.IsDomestic //uf.FundStructureId //uf.Taxable //uf.Exempt //uf.AddressID //uf.managementfee //uf.incentivefee //uf.taxrate //uf.auditorname //uf.managercontactid //uf.shareclasstypeid //uf.investmenttypeid //account.Phone; //account.Fax; //account.IBAN; //account.FFC; //account.FFCNumber; //account.SWIFT; //account.AccountNumberCash return uf; }