public int PopulateDatabase() { try { CustomComputersAspEntities db = new CustomComputersAspEntities(); int materialsid = this.InsertMaterials(); string producerMonitor = this.monitor.GetMonitorProducer(); string ledMonitor = this.monitor.GetLed(); string aspectRatioMonitor = this.monitor.GetAspecRatio().Item1.ToString() + "x" + this.monitor.GetAspecRatio().Item2.ToString(); string matrixMonitor = this.monitor.GetMatrixAndMatrixProducer().Item1; Monitor match = db.Monitors.FirstOrDefault(m => m.led == ledMonitor && m.aspectRatio == aspectRatioMonitor && m.producer == producerMonitor && m.matrix == matrixMonitor && m.materialsId == materialsid); if (match == null) { db.AddToMonitors(new Monitor() { led = ledMonitor, aspectRatio = aspectRatioMonitor, producer = producerMonitor, materialsId = materialsid, matrix = matrixMonitor }); db.SaveChanges(); match = db.Monitors.FirstOrDefault(m => m.led == ledMonitor && m.aspectRatio == aspectRatioMonitor && m.producer == producerMonitor && m.matrix == matrixMonitor && m.materialsId == materialsid); } return match.id; } catch (Exception ex) { Console.WriteLine("Could not successfully populate DB with monitor information. Reason: {0}", ex.Message); return 0; } }
public int PopulateDataBase(int boxId, int monitorId) { try { CustomComputersAspEntities db = new CustomComputersAspEntities(); Configuration match = db.Configurations.FirstOrDefault(c => c.boxId == boxId && c.monitorId == monitorId); if (match == null) { db.AddToConfigurations(new Configuration() { boxId = boxId, monitorId = monitorId }); db.SaveChanges(); match = db.Configurations.FirstOrDefault(c => c.boxId == boxId && c.monitorId == monitorId); } return match.id; } catch (Exception ex) { Console.WriteLine("Could not successfully populate DataBase with Configuration. Reason: {0}", ex.Message); return 0; } }
public int PopulateDataBase() { try { int cpuId = this.InsertCpu(); int videoId = this.InsertVideoCard(); int hddId = this.InsertHdd(); string motherBoard = this.boxSet.GetMotherBoard(); string ram = this.boxSet.GetRam(); string coolSys = this.boxSet.GetCoolingSystem(); string soundCard = this.boxSet.GetSoundCard(); string powerSupply = this.boxSet.GetPowerSupply(); string expansionCard = this.boxSet.GetExpansionCard(); string box = this.boxSet.GetBox(); string usb = this.boxSet.GetRemovableDevices().Item1; string disk = this.boxSet.GetRemovableDevices().Item2; string cardReader = this.boxSet.GetRemovableDevices().Item3; string removableDev = usb + "; " + disk + "; " + cardReader; CustomComputersAspEntities db = new CustomComputersAspEntities(); BoxSet match = db.BoxSets.FirstOrDefault(b => b.cupId == cpuId && b.videoCardId == videoId && b.hddId == hddId && b.motherboard == motherBoard && b.ram == ram && b.coolingSystem == coolSys && b.powerSupply == powerSupply && b.expansionCards == expansionCard && b.box == box && b.removableDevices == removableDev); if (match == null) { db.AddToBoxSets(new BoxSet() { cupId = cpuId, videoCardId = videoId, hddId = hddId, motherboard = motherBoard, ram = ram, coolingSystem = coolSys, powerSupply = powerSupply, expansionCards = expansionCard, box = box, removableDevices = removableDev, }); db.SaveChanges(); match = db.BoxSets.FirstOrDefault(b => b.cupId == cpuId && b.videoCardId == videoId && b.hddId == hddId && b.motherboard == motherBoard && b.ram == ram && b.coolingSystem == coolSys && b.powerSupply == powerSupply && b.expansionCards == expansionCard && b.box == box && b.removableDevices == removableDev); } return(match.id); } catch (Exception ex) { Console.WriteLine("Could not successsfully populate DataBase with BoxSet. Reason: {0}", ex.Message); return(0); } }
public int PopulateDataBase() { try { int cpuId = this.InsertCpu(); int videoId = this.InsertVideoCard(); int hddId = this.InsertHdd(); string motherBoard = this.boxSet.GetMotherBoard(); string ram = this.boxSet.GetRam(); string coolSys = this.boxSet.GetCoolingSystem(); string soundCard = this.boxSet.GetSoundCard(); string powerSupply = this.boxSet.GetPowerSupply(); string expansionCard = this.boxSet.GetExpansionCard(); string box = this.boxSet.GetBox(); string usb = this.boxSet.GetRemovableDevices().Item1; string disk = this.boxSet.GetRemovableDevices().Item2; string cardReader = this.boxSet.GetRemovableDevices().Item3; string removableDev = usb + "; " + disk + "; " + cardReader; CustomComputersAspEntities db = new CustomComputersAspEntities(); BoxSet match = db.BoxSets.FirstOrDefault(b => b.cupId == cpuId && b.videoCardId == videoId && b.hddId == hddId && b.motherboard == motherBoard && b.ram == ram && b.coolingSystem == coolSys && b.powerSupply == powerSupply && b.expansionCards == expansionCard && b.box == box && b.removableDevices == removableDev); if (match == null) { db.AddToBoxSets(new BoxSet() { cupId = cpuId, videoCardId = videoId, hddId = hddId, motherboard = motherBoard, ram = ram, coolingSystem = coolSys, powerSupply = powerSupply, expansionCards = expansionCard, box = box, removableDevices = removableDev, }); db.SaveChanges(); match = db.BoxSets.FirstOrDefault(b => b.cupId == cpuId && b.videoCardId == videoId && b.hddId == hddId && b.motherboard == motherBoard && b.ram == ram && b.coolingSystem == coolSys && b.powerSupply == powerSupply && b.expansionCards == expansionCard && b.box == box && b.removableDevices == removableDev); } return match.id; } catch (Exception ex) { Console.WriteLine("Could not successsfully populate DataBase with BoxSet. Reason: {0}",ex.Message); return 0; } }
private int InsertMaterials() { CustomComputersAspEntities db = new CustomComputersAspEntities(); string standmaterial = this.monitor.GetMaterials().Item1; string displaymaterial = this.monitor.GetMaterials().Item2; Material match = db.Materials.FirstOrDefault(x => x.stand == standmaterial && x.display == displaymaterial); if (match == null) { db.AddToMaterials(new Material() { stand = standmaterial, display = displaymaterial }); db.SaveChanges(); } match = db.Materials.FirstOrDefault(x => x.stand == standmaterial && x.display == displaymaterial); return match.id; }
private void InsertAntivirus() { string antiVirus = this.software.GetAntiVirusAndProducer().Item1; string antiVirusProducer = this.software.GetAntiVirusAndProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Softwares.FirstOrDefault(s => s.name == antiVirus && s.producer == antiVirusProducer && s.configId == this.configId); if (match == null) { db.AddToSoftwares(new Software() { name = antiVirus, producer = antiVirusProducer, type = "antiVirus", configId = this.configId }); db.SaveChanges(); } }
private void InsertVideoCamera() { string videoCamera = this.peripheral.GetVideoCamera(); CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == videoCamera && p.configId == this.configId); if (match == null) { db.AddToPeripherals(new Peripheral() { name = videoCamera, producer = "", type = "videoCamera", configId = this.configId }); db.SaveChanges(); } }
private void InsertOtherDevices() { string otherDevices = this.peripheral.GetOtherDevices(); CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == otherDevices && p.configId == this.configId); if (match == null) { db.AddToPeripherals(new Peripheral() { name = otherDevices, producer = "", type = "otherDevices", configId = this.configId }); db.SaveChanges(); } }
private void InsertMicrophone() { string microphone = this.peripheral.GetMicrophone(); CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == microphone && p.configId == this.configId); if (match == null) { db.AddToPeripherals(new Peripheral() { name = microphone, producer = "", type = "microphone", configId = this.configId }); db.SaveChanges(); } }
private void InsertKeyBoard() { string keyBoardName = this.peripheral.GetKeyBoardAndKeyboardProducer().Item1; string producerName = this.peripheral.GetKeyBoardAndKeyboardProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == keyBoardName && p.producer == producerName && p.configId==this.configId); if(match==null) { db.AddToPeripherals(new Peripheral() { name = keyBoardName, producer = producerName, type = "keyoard", configId = this.configId }); db.SaveChanges(); } }
private void InsertHeadphones() { string headphonesName = this.peripheral.GetHeadphonesAndHeadphoneProducer().Item1; string producerName = this.peripheral.GetHeadphonesAndHeadphoneProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == headphonesName && p.producer == producerName && p.configId==this.configId); if (match == null) { db.AddToPeripherals(new Peripheral() { name = headphonesName, producer = producerName, type = "headphones", configId = this.configId }); db.SaveChanges(); } }
private void InsertKeyBoard() { string keyBoardName = this.peripheral.GetKeyBoardAndKeyboardProducer().Item1; string producerName = this.peripheral.GetKeyBoardAndKeyboardProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == keyBoardName && p.producer == producerName && p.configId == this.configId); if (match == null) { db.AddToPeripherals(new Peripheral() { name = keyBoardName, producer = producerName, type = "keyoard", configId = this.configId }); db.SaveChanges(); } }
private void InsertMouse() { string mousename = this.peripheral.GetMouseAndMouesProducer().Item1; string producername = this.peripheral.GetMouseAndMouesProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == mousename && p.producer == producername && p.configId == this.configId); if (match == null) { db.AddToPeripherals(new Peripheral() { name = mousename, producer = producername, type = "mouse", configId = this.configId }); db.SaveChanges(); } }
private void InsertHeadphones() { string headphonesName = this.peripheral.GetHeadphonesAndHeadphoneProducer().Item1; string producerName = this.peripheral.GetHeadphonesAndHeadphoneProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == headphonesName && p.producer == producerName && p.configId == this.configId); if (match == null) { db.AddToPeripherals(new Peripheral() { name = headphonesName, producer = producerName, type = "headphones", configId = this.configId }); db.SaveChanges(); } }
private void InsertAntivirus() { string antiVirus = this.software.GetAntiVirusAndProducer().Item1; string antiVirusProducer = this.software.GetAntiVirusAndProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Softwares.FirstOrDefault(s => s.name == antiVirus && s.producer == antiVirusProducer && s.configId == this.configId); if (match == null) { db.AddToSoftwares(new Software() { name = antiVirus, producer = antiVirusProducer, type = "antiVirus", configId = this.configId }); db.SaveChanges(); } }
private void InsertOther() { string other = this.software.GetOther().Item1; string otherProducer = this.software.GetOther().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Softwares.FirstOrDefault(s => s.name == other && s.producer == otherProducer && s.configId == this.configId); if (match == null) { db.AddToSoftwares(new Software() { name = other, producer = otherProducer, type = "other", configId = this.configId }); db.SaveChanges(); } }
private int InsertVideoCard() { string video = this.boxSet.GetVideoCardAndVideoCardProducer().Item1; string videoProducer = this.boxSet.GetVideoCardAndVideoCardProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); VideoCard match = db.VideoCards.FirstOrDefault(v => v.name == video && v.producer == videoProducer); if (match == null) { db.AddToVideoCards(new VideoCard() { name = video, producer = videoProducer }); db.SaveChanges(); match = db.VideoCards.FirstOrDefault(v => v.name == video && v.producer == videoProducer); } return(match.id); }
private int InsertCpu() { string cpu = this.boxSet.GetCpuAndCpuProducer().Item1; string cpuProducer = this.boxSet.GetCpuAndCpuProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); Cpu match = db.Cpus.FirstOrDefault(c => c.name == cpu && c.producer == cpuProducer); if (match == null) { db.AddToCpus(new Cpu() { name = cpu, producer = cpuProducer }); db.SaveChanges(); match = db.Cpus.FirstOrDefault(c => c.name == cpu && c.producer == cpuProducer); } return(match.id); }
private int InsertHdd() { string hdd = this.boxSet.GetHddAndHddProducer().Item1; string hddProducer = this.boxSet.GetHddAndHddProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); Hdd match = db.Hdds.FirstOrDefault(h => h.name == hdd && h.producer == hddProducer); if (match == null) { db.AddToHdds(new Hdd() { name = hdd, producer = hddProducer }); db.SaveChanges(); match = db.Hdds.FirstOrDefault(h => h.name == hdd && h.producer == hddProducer); } return(match.id); }
private void InsertGame(int gameNumber) { int newGameNumber = gameNumber - 1; string game = this.software.GetGameAndProducer(newGameNumber).Item1; string gameProducer = this.software.GetGameAndProducer(newGameNumber).Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Softwares.FirstOrDefault(s => s.name == game && s.producer == gameProducer && s.configId == this.configId); if (match == null) { db.AddToSoftwares(new Software() { name = game, producer = gameProducer, type = "game", configId = this.configId }); db.SaveChanges(); } }
private void InsertMouse() { string mousename = this.peripheral.GetMouseAndMouesProducer().Item1; string producername = this.peripheral.GetMouseAndMouesProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == mousename && p.producer == producername && p.configId==this.configId); if (match == null) { db.AddToPeripherals(new Peripheral() { name = mousename, producer = producername, type = "mouse", configId = this.configId }); db.SaveChanges(); } }
private void InsertVideoCamera() { string videoCamera = this.peripheral.GetVideoCamera(); CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == videoCamera && p.configId==this.configId); if (match == null) { db.AddToPeripherals(new Peripheral() { name = videoCamera, producer = "", type = "videoCamera", configId = this.configId }); db.SaveChanges(); } }
private void InsertGame(int gameNumber) { int newGameNumber = gameNumber - 1; string game = this.software.GetGameAndProducer(newGameNumber).Item1; string gameProducer = this.software.GetGameAndProducer(newGameNumber).Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Softwares.FirstOrDefault(s => s.name == game && s.producer == gameProducer && s.configId == this.configId); if(match == null) { db.AddToSoftwares(new Software() { name = game, producer = gameProducer, type = "game", configId = this.configId }); db.SaveChanges(); } }
private void InsertMicrophone() { string microphone = this.peripheral.GetMicrophone(); CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == microphone && p.configId==this.configId); if (match == null) { db.AddToPeripherals(new Peripheral() { name = microphone, producer = "", type = "microphone", configId = this.configId }); db.SaveChanges(); } }
private void InsertOtherDevices() { string otherDevices = this.peripheral.GetOtherDevices(); CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Peripherals.FirstOrDefault(p => p.name == otherDevices && p.configId==this.configId); if (match == null) { db.AddToPeripherals(new Peripheral() { name = otherDevices, producer = "", type = "otherDevices", configId = this.configId }); db.SaveChanges(); } }
private void InsertOther() { string other = this.software.GetOther().Item1; string otherProducer = this.software.GetOther().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); var match = db.Softwares.FirstOrDefault(s => s.name == other && s.producer == otherProducer && s.configId == this.configId); if (match == null) { db.AddToSoftwares(new Software() { name = other, producer = otherProducer, type = "other", configId = this.configId }); db.SaveChanges(); } }
private int InsertHdd() { string hdd = this.boxSet.GetHddAndHddProducer().Item1; string hddProducer = this.boxSet.GetHddAndHddProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); Hdd match = db.Hdds.FirstOrDefault(h => h.name == hdd && h.producer == hddProducer); if (match == null) { db.AddToHdds(new Hdd() { name = hdd, producer = hddProducer }); db.SaveChanges(); match = db.Hdds.FirstOrDefault(h => h.name == hdd && h.producer == hddProducer); } return match.id; }
private int InsertVideoCard() { string video = this.boxSet.GetVideoCardAndVideoCardProducer().Item1; string videoProducer = this.boxSet.GetVideoCardAndVideoCardProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); VideoCard match = db.VideoCards.FirstOrDefault(v => v.name == video && v.producer == videoProducer); if (match == null) { db.AddToVideoCards(new VideoCard() { name = video, producer = videoProducer }); db.SaveChanges(); match = db.VideoCards.FirstOrDefault(v => v.name == video && v.producer == videoProducer); } return match.id; }
private int InsertCpu() { string cpu = this.boxSet.GetCpuAndCpuProducer().Item1; string cpuProducer = this.boxSet.GetCpuAndCpuProducer().Item2; CustomComputersAspEntities db = new CustomComputersAspEntities(); Cpu match = db.Cpus.FirstOrDefault(c => c.name == cpu && c.producer == cpuProducer); if (match == null) { db.AddToCpus(new Cpu() { name = cpu, producer = cpuProducer }); db.SaveChanges(); match = db.Cpus.FirstOrDefault(c => c.name == cpu && c.producer == cpuProducer); } return match.id; }