public static List<TopicalApplicationModel> GetTopicalApplicationModel()
{
List<TopicalApplicationModel> topicalApplicationCollection = new List<TopicalApplicationModel>();
try
{
IConnection connection = new Connection();
string sqlConnection = connection.GetDataSourceValue("BH.Application.RouteConfirmation.config", "DataSource", "InitialCatalog", "UserID", "Password", "BH.Application.RouteConfirmation");
IDataHandler dataHandler = new DataHandler();
List<StoredProcedureParameter> storedProcedureParameters = new List<StoredProcedureParameter>();
storedProcedureParameters.Add(new StoredProcedureParameter("@DataItemCode", SqlDbType.VarChar, "GEN_BodySite_SUG"));
storedProcedureParameters.Add(new StoredProcedureParameter("@FormName", SqlDbType.VarChar, "PRX_Topicals"));
DataTable dataTable = dataHandler.GetStoredProcedureResults(sqlConnection, "BH_MLM_ObsValueListing_Sp", storedProcedureParameters);
foreach (DataRow dataRow in dataTable.Rows)
topicalApplicationCollection.Add(new TopicalApplicationModel(dataRow["Value"].ToString(), dataRow["Value"].ToString()));
dataTable.Dispose();
}
catch
{
throw;
}
return topicalApplicationCollection;
}