protected void panelonload(object sender, EventArgs e)
{
try
{
var sc = new RecipeServiceSoapClient();
List<MongoMap> mn = new List<MongoMap>();
//Response.Write(sc.Search("mango"));
mn = JsonConvert.DeserializeObject<List<MongoMap>>(sc.DataAnalytics());
// String ca = null, data;
Dictionary<String,Double> dic=new Dictionary<string, Double>();
foreach (var map in mn)
{
dic.Add(map._id,map.value.count);
//Response.Write(map._id+"-"+map.value.count+"<br/>");
if (map.value.count > 100)
{
// ca += map._id.Replace("PT", "") + ",";
BarChartSeries a = new BarChartSeries();
a.Name = map._id.Replace("PT", "");
a.BarColor = GenerateRandomColour().ToString();
a.Data = new[] { Convert.ToDecimal(map.value.count) };
BarChart1.Series.Add(a);
}
GridView2.DataSource = dic;
GridView2.DataBind();
}
// BarChart1.CategoriesAxis = ca.Substring(0, ca.Count() - 1);
}
catch (Exception ex)
{
Response.Write(ex);
}
}
// DATA ACCESS CONFIGURE SECTION
//---------------------------------------------------------------------
//*** create factory (different DbContext for RecipeRow and RemainRow)
//*** how to use config manager
private static void ConfigureDataAccess(IApplicationController controller)
{
// APP CONFIG SECTION
//---------------------------------------------
var config = ConfigurationManager.OpenExeConfiguration(ConfigurationUserLevel.None);
var senderConfig = new SenderConfigurationManager(config);
controller.RegisterInstance <IConfigurationManager <SenderConfiguration> >(senderConfig);
var connectionConfig = new ConnectionStringsConfigurationManager(config);
controller.RegisterInstance <IConfigurationManager <ConnectionStringConfiguration> >(connectionConfig);
var ftpConfig = new FtpConfigurationManager(config);
controller.RegisterInstance <IConfigurationManager <FtpConfiguration> >(ftpConfig);
var guidesConfig = new GuidesConfigurationManager(config);
controller.RegisterInstance <IConfigurationManager <GuidesConfiguration> >(guidesConfig);
var webServiceConfig = new WebServiceConfigurationManager(config);
controller.RegisterInstance <IConfigurationManager <WebServiceConfiguration> >(webServiceConfig);
controller.RegisterService <IConfigurationManager <ConverterTask>, ConverterTaskConfigurationManager>();
// DB CONTEXT SECTION
//---------------------------------------------
var recipesConnection = connectionConfig.Get("recipes");
var recipesDbContext = new DbContext(recipesConnection.ConnectionString, recipesConnection.ProviderName);
var remainsConnection = connectionConfig.Get("remains");
var remainsDbContext = new DbContext(remainsConnection.ConnectionString, remainsConnection.ProviderName);
var guidesConnection = connectionConfig.Get("guides");
var guidesDbContext = new DbContext(guidesConnection.ConnectionString, guidesConnection.ProviderName);
//*** inject into IRepositoty<RecipeRow>
controller.RegisterInstance <DbContext, IRepository <RecipeRow> >(recipesDbContext);
//*** inject into IRepositoty<RemainRow>
controller.RegisterInstance <DbContext, IRepository <RemainRow> >(remainsDbContext);
//*** inject into guides repositories
controller.RegisterInstance <DbContext, IRepository <Mnn> >(guidesDbContext);
controller.RegisterInstance <DbContext, IRepository <TradeName> >(guidesDbContext);
controller.RegisterInstance <DbContext, IRepository <Drug> >(guidesDbContext);
controller.RegisterInstance <DbContext, IRepository <Drugform> >(guidesDbContext);
// REPOSITORY SECTION
//---------------------------------------------
controller.RegisterService <IRepository <RecipeRow>, RecipeRepository>();
controller.RegisterService <IRepository <RemainRow>, RemainRepository>();
controller.RegisterService <IGuideRepository <Mnn>, MnnRepository>();
controller.RegisterService <IGuideRepository <TradeName>, TradeNameRepository>();
controller.RegisterService <IGuideRepository <Drug>, DrugRepository>();
controller.RegisterService <IGuideRepository <Drugform>, DrugformRepository>();
var logRepo = new LogRepository("logs/");
controller.RegisterInstance <IRepository <LogRow> >(logRepo);
var recipesWebServiceConfig = webServiceConfig.Get("RecipeServiceSoap");
var recipesSoapClient = new RecipeServiceSoapClient(recipesWebServiceConfig.Name,
recipesWebServiceConfig.RemoteAddress);
controller.RegisterInstance <RecipeServiceSoap>(recipesSoapClient);
var remainWebServiceConfig = webServiceConfig.Get("DrugstoreServiceSoap");
var drugstoreSoapClient = new DrugstoreServiceSoapClient(remainWebServiceConfig.Name,
remainWebServiceConfig.RemoteAddress);
controller.RegisterInstance <DrugstoreServiceSoap>(drugstoreSoapClient);
}