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); } }