public static clsModelGroup getModelPortfolioClientList(string strIFACode, string strModelGroup, string strModelName) { clsModelGroup _clsModelGroup = new clsModelGroup(); List <clsPortfolio> listPortfolio = new List <clsPortfolio>(); SqlConnection con = new clsSystem_DBConnection(clsSystem_DBConnection.strConnectionString.NavIntegrationDB).propConnection; SqlCommand cmd = new SqlCommand(); SqlDataReader dr; string strClientID = string.Empty; string strPortfolioID = string.Empty; con.Open(); cmd.Connection = con; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "SWITCH_ModelPortfolioClientGet"; cmd.Parameters.Add("", System.Data.SqlDbType.NVarChar).Value = strIFACode; cmd.Parameters.Add("", System.Data.SqlDbType.NVarChar).Value = strModelGroup; cmd.Parameters.Add("", System.Data.SqlDbType.NVarChar).Value = strModelName; dr = cmd.ExecuteReader(); while (dr.Read()) { _clsModelGroup.propModelID = dr["ModelID"].ToString(); _clsModelGroup.propModelIFA = dr["ModelIFA"].ToString(); _clsModelGroup.propModelGroup = dr["ModelGroup"].ToString(); _clsModelGroup.propModelName = dr["ModelName"].ToString(); strClientID = dr["ClientID"].ToString(); strPortfolioID = dr["ClientPortfolioID"].ToString(); clsPortfolio _clsPortfolio = new clsPortfolio(); //_clsPortfolio.(strClientID, strPortfolioID); _clsPortfolio.propClient = new clsClient(strClientID); listPortfolio.Add(_clsPortfolio); } return(_clsModelGroup); }
public static clsModelGroup getModelPortfolioClientList(string strIFACode, string strModelGroup, string strModelName) { clsModelGroup _clsModelGroup = new clsModelGroup(); List<clsPortfolio> listPortfolio = new List<clsPortfolio>(); SqlConnection con = new clsSystem_DBConnection(clsSystem_DBConnection.strConnectionString.NavIntegrationDB).propConnection; SqlCommand cmd = new SqlCommand(); SqlDataReader dr; string strClientID = string.Empty; string strPortfolioID = string.Empty; con.Open(); cmd.Connection = con; cmd.CommandType = System.Data.CommandType.StoredProcedure; cmd.CommandText = "SWITCH_ModelPortfolioClientGet"; cmd.Parameters.Add("", System.Data.SqlDbType.NVarChar).Value = strIFACode; cmd.Parameters.Add("", System.Data.SqlDbType.NVarChar).Value = strModelGroup; cmd.Parameters.Add("", System.Data.SqlDbType.NVarChar).Value = strModelName; dr = cmd.ExecuteReader(); while (dr.Read()) { _clsModelGroup.propModelID = dr["ModelID"].ToString(); _clsModelGroup.propModelIFA = dr["ModelIFA"].ToString(); _clsModelGroup.propModelGroup = dr["ModelGroup"].ToString(); _clsModelGroup.propModelName = dr["ModelName"].ToString(); strClientID = dr["ClientID"].ToString(); strPortfolioID = dr["ClientPortfolioID"].ToString(); clsPortfolio _clsPortfolio = new clsPortfolio(); //_clsPortfolio.(strClientID, strPortfolioID); _clsPortfolio.propClient = new clsClient(strClientID); listPortfolio.Add(_clsPortfolio); } return _clsModelGroup; }