private HtmlGenericControl generateDevice(Device device, DatabaseEntities db)
{
var brandQuery = db.Brands.Where(b => b.brand_id == device.brand_id);
var brand = brandQuery.FirstOrDefault<Brand>();
var operatingSystemQuery = db.OperatingSystems.Where(b => b.operating_system_id == device.operating_system_id);
var operatingSystem = operatingSystemQuery.FirstOrDefault<OperatingSystem>();
var displayQuery = db.Displays.Where(b => b.display_id == device.display_id);
var display = displayQuery.FirstOrDefault<Display>();
HtmlGenericControl deviceDiv = new HtmlGenericControl("DIV");
deviceDiv.Attributes["class"] = "device";
//HtmlGenericControl anchorFirst = new HtmlGenericControl("a");
HtmlAnchor anchorFirst = new HtmlAnchor();
anchorFirst.HRef = String.Format("~/device.aspx?id={0}", device.device_id);
HtmlImage img = new HtmlImage();
img.Src = String.Format("~/images/{0}/{1} {2} .jpg", brand.name, brand.name, device.device_name);
anchorFirst.Controls.Add(img);
HtmlGenericControl h2 = new HtmlGenericControl("h2");
//HtmlGenericControl anchorSecond = new HtmlGenericControl("a");
HtmlAnchor anchorSecond = new HtmlAnchor();
anchorSecond.HRef = String.Format("~/device.aspx?id={0}", device.device_id);
anchorSecond.InnerText = String.Format("{0} {1}", brand.name, device.device_name);
h2.Controls.Add(anchorSecond);
HtmlGenericControl p = new HtmlGenericControl("p");
p.InnerText = String.Format("{0}, экран {1}, {2} ( {3} ), ОЗУ {4}, аккумулятор {5}",
operatingSystem.name, device.screen_size, display.type, device.screen_resolution, device.ram, device.battery_capacity);
HtmlGenericControl clrDiv = new System.Web.UI.HtmlControls.HtmlGenericControl("DIV");
clrDiv.Attributes["class"] = "clr";
HtmlGenericControl priceDiv = new HtmlGenericControl("DIV");
priceDiv.Attributes["class"] = "price";
priceDiv.InnerText = String.Format("{0}", device.price);
deviceDiv.Controls.Add(anchorFirst);
deviceDiv.Controls.Add(h2);
deviceDiv.Controls.Add(p);
deviceDiv.Controls.Add(clrDiv);
deviceDiv.Controls.Add(priceDiv);
return deviceDiv;
}
private HtmlGenericControl generateDevice(Device device, DatabaseEntities db)
{
var brandQuery = db.Brands.Where(b => b.brand_id == device.brand_id);
var brand = brandQuery.FirstOrDefault<Brand>();
var batteryQuery = db.Batteries.Where(b => b.battery_id == device.battery_id);
var battery = batteryQuery.FirstOrDefault<Battery>();
var displayQuery = db.Displays.Where(b => b.display_id == device.display_id);
var display = displayQuery.FirstOrDefault<Display>();
var operatingSystemQuery = db.OperatingSystems.Where(b => b.operating_system_id == device.operating_system_id);
var operatingSystem = operatingSystemQuery.FirstOrDefault<OperatingSystem>();
var processorQuery = db.Processors.Where(b => b.processor_id == device.processor_id);
var processor = processorQuery.FirstOrDefault<Processor>();
var flashToDeviceQuery = db.FlashToDevices.Where(b => b.device_id == device.device_id);
List<FlashToDevice> flashToDeviceList = flashToDeviceQuery.ToList<FlashToDevice>();
string flashTypes = "";
foreach (FlashToDevice type in flashToDeviceList)
{
var flashQuery = db.Flashes.Where(b => b.flash_id == type.flash_id);
var flash = flashQuery.FirstOrDefault<Flash>();
flashTypes += flash.type + " ";
}
if (flashTypes.Trim() == "")
flashTypes = "Отсутсвует";
HtmlGenericControl result = new HtmlGenericControl("div");
HtmlGenericControl descriptionDiv = new HtmlGenericControl("div");
descriptionDiv.Attributes["class"] = "device";
HtmlImage img = new HtmlImage();
img.Src = String.Format("~/images/{0}/{1} {2} .jpg", brand.name, brand.name, device.device_name);
HtmlGenericControl h2 = new HtmlGenericControl("h2");
h2.InnerText = "Описание";
HtmlGenericControl pAboutBrand = new HtmlGenericControl("p");
pAboutBrand.InnerText = String.Format("{0}", brand.information);
//HtmlGenericControl pShortInformation = new HtmlGenericControl("p");
//pShortInformation.InnerText = String.Format("{0}, экран {1}, {2} ( {3} ), ОЗУ {4}, аккумулятор {5}",
// operatingSystem.name, device.screen_size, display.type, device.screen_resolution, device.ram, device.battery_capacity);
HtmlGenericControl clrDiv = new System.Web.UI.HtmlControls.HtmlGenericControl("DIV");
clrDiv.Attributes["class"] = "clr";
HtmlGenericControl priceDiv = new HtmlGenericControl("DIV");
priceDiv.Attributes["class"] = "price";
priceDiv.InnerText = String.Format("{0}", device.price);
descriptionDiv.Controls.Add(img);
descriptionDiv.Controls.Add(h2);
descriptionDiv.Controls.Add(pAboutBrand);
//descriptionDiv.Controls.Add(pShortInformation);
descriptionDiv.Controls.Add(clrDiv);
descriptionDiv.Controls.Add(priceDiv);
HtmlGenericControl h2Descr = new HtmlGenericControl("h2");
h2Descr.InnerText = "Характеристики";
result.Controls.Add(descriptionDiv);
result.Controls.Add(h2Descr);
HtmlGenericControl tableGeneral = new HtmlGenericControl("table");
string[] keysGeneral = { "Производитель", "Операционная система", "Год выпуска"};
string[] valuesGeneral = { brand.name, operatingSystem.name, device.release_year };
tableGeneral = createTable("Общее", keysGeneral, valuesGeneral);
result.Controls.Add(tableGeneral);
HtmlGenericControl tableDisplay = new HtmlGenericControl("table");
string[] keysDisplay = { "Тип дисплея", "Размер экрана", "Разрешение экрана", "Информация о техологии дисплея"};
string[] valuesDisplay = { display.type, device.screen_size, device.screen_resolution, display.information };
tableDisplay = createTable("Дисплей", keysDisplay, valuesDisplay);
result.Controls.Add(tableDisplay);
HtmlGenericControl tableProcessor = new HtmlGenericControl("table");
string[] keysProcessor = { "Тип процессора" };
string[] valuesProcessor = new string[1];
if (processor == null)
valuesProcessor[0] = "Неизвестно";
else
valuesProcessor[0] = processor.name;
tableProcessor = createTable("Процессор", keysProcessor, valuesProcessor);
result.Controls.Add(tableProcessor);
HtmlGenericControl tableMemory = new HtmlGenericControl("table");
string[] keysMemory = { "Оперативная память", "Встроенная память", "Поддержка карт памяти" };
string[] valuesMemory = { device.ram, device.internal_memory, flashTypes};
tableMemory = createTable("Память", keysMemory, valuesMemory);
result.Controls.Add(tableMemory);
HtmlGenericControl tableBattery = new HtmlGenericControl("table");
string[] keysBattery = { "Тип батареи", "Eмкость батареи", "Информация о технологии батареи" };
string[] valuesBatery = { battery.type, device.battery_capacity, battery.information };
tableBattery = createTable("Батарея", keysBattery, valuesBatery);
result.Controls.Add(tableBattery);
return result;
}
private void loadSideBar(Device device, DatabaseEntities db)
{
var brandQuery = db.Brands.Where(b => b.brand_id == device.brand_id);
var brand = brandQuery.FirstOrDefault<Brand>();
HtmlGenericControl title = new HtmlGenericControl("div");
//HtmlGenericControl a = new HtmlGenericControl("a");
HtmlAnchor a = new HtmlAnchor();
a.HRef = String.Format("~/?brand={0}", brand.name);
a.InnerText = brand.name;
title.Attributes["class"] = "title";
title.Controls.Add(a);
HtmlGenericControl ul = new HtmlGenericControl("ul");
List<Device> devicesList = db.Devices.Where(b => b.brand_id == device.brand_id).ToList<Device>();
foreach (Device item in devicesList)
{
HtmlGenericControl li = new HtmlGenericControl("li");
//HtmlGenericControl anchor = new HtmlGenericControl("a");
HtmlAnchor anchor = new HtmlAnchor();
anchor.HRef = String.Format("~/Device.aspx?id={0}", item.device_id);
anchor.InnerText = String.Format("{0}", item.device_name);
li.Controls.Add(anchor);
ul.Controls.Add(li);
}
sidebar.Controls.Add(title);
sidebar.Controls.Add(ul);
}
private void loadDevicePath(Device device, DatabaseEntities db)
{
var brandQuery = db.Brands.Where(b => b.brand_id == device.brand_id);
var brand = brandQuery.FirstOrDefault<Brand>();
HtmlImage firstArrow = new HtmlImage();
firstArrow.Src = "~/images/directory_arrow.png";
HtmlGenericControl brandDiv = new HtmlGenericControl("div");
brandDiv.Attributes["class"] = "directory_path";
//HtmlGenericControl brandAnchor = new HtmlGenericControl("a");
HtmlAnchor brandAnchor = new HtmlAnchor();
brandAnchor.HRef = "~/?brand=" + brand.name;
brandAnchor.Attributes["id"] = "firstDirectory";
brandAnchor.InnerText = brand.name;
brandDiv.Controls.Add(brandAnchor);
HtmlImage secondArrow = new HtmlImage();
secondArrow.Src = "~/images/directory_arrow.png";
HtmlGenericControl deviceDiv = new HtmlGenericControl("div");
deviceDiv.Attributes["class"] = "directory_path";
//HtmlGenericControl deviceAnchor = new HtmlGenericControl("a");
HtmlAnchor deviceAnchor = new HtmlAnchor();
deviceAnchor.HRef = "~/Device.aspx?id=" + device.device_id;
deviceAnchor.Attributes["id"] = "secondDirectory";
deviceAnchor.InnerText = device.device_name;
deviceDiv.Controls.Add(deviceAnchor);
path.Controls.Add(firstArrow);
path.Controls.Add(brandDiv);
path.Controls.Add(secondArrow);
path.Controls.Add(deviceDiv);
}