public static StitchDatabaseFileRecord FindManagerInStitch(string managerName, StitchDatabaseFile stitchFile) { StitchDatabaseFileRecord rtn = null; List <StitchDatabaseFileRecord> recs = stitchFile.StitchRecords(); foreach (StitchDatabaseFileRecord rec in recs) { if (rec.ManagerName == managerName) { rtn = rec; break; } } return(rtn); }
public UIManager(AliasNamesRecord aliasNamesRecord, StitchDatabaseFileRecord stitchDatabaseFileRecord, StatsRecord dbStats, StatsRecord citiStats, StatsRecord jlsStats) { // create a new manager file record // in the UI for comparison with // disk file data m_managerFileRecord = new ManagerFileRecord(); // alias names m_managerFileRecord.ManagerName = aliasNamesRecord.ManagerName; m_managerFileRecord.DBManagerName = aliasNamesRecord.DBManagerName; m_managerFileRecord.CITIManagerName = aliasNamesRecord.CITIManagerName; m_managerFileRecord.MorganStanleyManagerName = aliasNamesRecord.MorganStanleyManagerName; m_managerFileRecord.JLSName = aliasNamesRecord.JLS_Has_Data_Sent_directly_from_Mgr; m_managerFileRecord.FirmCode = aliasNamesRecord.FirmCode; m_managerFileRecord.ProgramCode = aliasNamesRecord.ProgramCode; // stitch database if (stitchDatabaseFileRecord != null) { m_managerFileRecord.Strategy = stitchDatabaseFileRecord.Strategy; m_managerFileRecord.SubStrat = stitchDatabaseFileRecord.SubStrat; m_managerFileRecord.MktsFocus = stitchDatabaseFileRecord.MktsFocus; m_existsInStitch = true; } else { m_managerFileRecord.Strategy = String.Empty; m_managerFileRecord.SubStrat = String.Empty; m_managerFileRecord.MktsFocus = String.Empty; m_existsInStitch = false; } // these only exist in manager.csv file m_managerFileRecord.Location = ""; m_managerFileRecord.ContactName = ""; m_managerFileRecord.ContactPhone = ""; //m_aliasNamesRecord = aliasNamesRecord; m_dbStats = dbStats; m_citiStats = citiStats; m_jlsStats = jlsStats; }
private void CreateManagerObjects_FromAliasNamesAndStitch() { m_managers = new List <UIManager>(); UIManager manager = null; StatsRecord dbStats = null; StatsRecord citiStats = null; StatsRecord jlsStats = null; StitchDatabaseFileRecord stitchRec = null; foreach (AliasNamesRecord aliasNamesRecord in m_aliasNamesFile.GetList()) { dbStats = Utility.FindManagerInStats(aliasNamesRecord.ManagerName, m_dbStatsFile); citiStats = Utility.FindManagerInStats(aliasNamesRecord.ManagerName, m_citiStatsFile); jlsStats = Utility.FindManagerInStats(aliasNamesRecord.ManagerName, m_jlsStatsFile); stitchRec = Utility.FindManagerInStitch(aliasNamesRecord.ManagerName, m_stitchDatabaseFile); manager = new UIManager(aliasNamesRecord, stitchRec, dbStats, citiStats, jlsStats); m_managers.Add(manager); } }
public List <StitchDatabaseFileRecord> StitchRecords() { List <StitchDatabaseFileRecord> recs = new List <StitchDatabaseFileRecord>(); string line; string[] fields = null; int CODE_FIRM = 0; string field = string.Empty; for (int i = 1; i < m_lines.Length; i++) { line = m_lines[i]; // skip blank lines if (line.Trim().Length == 0) { continue; } fields = line.Split(','); // create new record object StitchDatabaseFileRecord rec = new StitchDatabaseFileRecord(); field = fields[Number_Idx]; field = field.Replace("\"", ""); rec.Number = field; field = fields[ManagerName_Idx]; field = field.Replace("\"", ""); rec.ManagerName = field; field = fields[MgrCode_Idx]; field = field.Replace("\"", ""); rec.MgrCode = field; field = fields[ProgramCode_Idx]; field = field.Replace("\"", ""); rec.ProgramCode = field; field = fields[Strategy_Idx]; field = field.Replace("\"", ""); rec.Strategy = field; field = fields[SubStrat_Idx]; field = field.Replace("\"", ""); rec.SubStrat = field; field = fields[MktsFocus_Idx]; field = field.Replace("\"", ""); rec.MktsFocus = field; field = fields[Switch_Idx]; field = field.Replace("\"", ""); rec.Switch = field; if (fields.Length < 14) { continue; } field = fields[DB1_Idx]; field = field.Replace("\"", ""); rec.DB1 = field; field = fields[StDt1_Idx]; field = field.Replace("\"", ""); if (field.Trim() != String.Empty) { rec.StDt1 = DateTime.Parse(field); } field = fields[EnDt1_Idx]; field = field.Replace("\"", ""); if (field.Trim() != String.Empty) { rec.EnDt1 = DateTime.Parse(field); } field = fields[DB2_Idx]; field = field.Replace("\"", ""); rec.DB2 = field; field = fields[StDt2_Idx]; field = field.Replace("\"", ""); if (field.Trim() != String.Empty) { rec.StDt2 = DateTime.Parse(field); } field = fields[EnDt2_Idx]; field = field.Replace("\"", ""); if (field.Trim() != String.Empty) { rec.EnDt2 = DateTime.Parse(field); } recs.Add(rec); } return(recs); }