private void RegisterWineDict(WineDataContext db)
{
var wines = from w in db.Wine
select new
{
w.WineId,
w.WineType
};
Dictionary <int, string> WineDict = wines.ToDictionary(w => w.WineId, w => w.WineType);
Application[ConstName.WineDict] = WineDict;
}
private void RegisterGrapedict(WineDataContext db)
{
var grapes = from g in db.Grape
select new
{
g.GrapeId,
g.GrapeType
};
Dictionary <int, string> GrapeDict = grapes.ToDictionary(g => g.GrapeId, g => g.GrapeType);
Application[ConstName.GrapeDict] = GrapeDict;
}
private void RegisterProducerDict(WineDataContext db)
{
var producers = from p in db.Producer
select new
{
p.ProducerId,
p.ProducerName
};
Dictionary <int, string> ProducerDict = producers.ToDictionary(p => p.ProducerId, p => p.ProducerName);
Application[ConstName.ProducerDict] = ProducerDict;
}
private void RegisterTasteDict(WineDataContext db)
{
var tastes = from t in db.Taste
select new
{
t.TasteType,
t.TasteDesc
};
Dictionary <string, string> TasteDict = tastes.ToDictionary(t => t.TasteType.Trim(), p => p.TasteDesc);
Application[ConstName.TasteDict] = TasteDict;
}
private void InitialDictionary()
{
WineDataContext db = new WineDataContext();
RegisterCountryDict(db);
RegisterRegionDict(db);
RegisterSubRegionDict(db);
RegisterGrapedict(db);
RegisterWineDict(db);
RegisterProducerDict(db);
RegisterTasteDict(db);
}
private void RegisterSubRegionDict(WineDataContext db)
{
var subRegions = from s in db.SubRegion
select new
{
s.SubRegionCode,
s.SubRegionName
};
Dictionary <string, string> SubRegionDict = subRegions.ToDictionary(s => s.SubRegionCode.Trim(), s => s.SubRegionName);
SubRegionDict.Add("", "Not Found");
Application[ConstName.SubRegionDict] = SubRegionDict;
}
private void RegisterRegionDict(WineDataContext db)
{
var regions = from r in db.Region
select new
{
r.RegionCode,
r.RegionName
};
Dictionary <string, string> RegionDict = regions.ToDictionary(r => r.RegionCode.Trim(), r => r.RegionName);
RegionDict.Add("", "Not Found");
Application[ConstName.RegionDict] = RegionDict;
}
private void RegisterCountryDict(WineDataContext db)
{
var countries = from c in db.Country
select new
{
c.CountryCode,
c.CountryName
};
Dictionary <string, string> CountryDict = countries.ToDictionary(c => c.CountryCode.Trim(), c => c.CountryName);
CountryDict.Add("", "Not Found");
Application[ConstName.CountryDict] = CountryDict;
}