public List <Motherboard> GetAllMB() { var connection = new SqlConnection(connectionString); SqlCommand command = new SqlCommand("Select * FROM MotherBoard"); List <Motherboard> mbs = new List <Motherboard>(); command.Connection = connection; connection.Open(); using (connection) using (var reader = command.ExecuteReader()) { for (int i = 0; i < 1; i++) { reader.Read(); string brand = reader.GetString(1); string model = reader.GetString(2); string socket = reader.GetString(3); Formfactor size = Formfactor.ATX; switch (reader.GetString(4)) { case "ATX": size = Formfactor.ATX; break; case "E-ATX": size = Formfactor.E_ATX; break; case "Mini-ATX": size = Formfactor.Mini_ATX; break; case "Micro-ATX": size = Formfactor.Micro_ATX; break; case "ITX": size = Formfactor.ITX; break; } int memsup = reader.GetInt32(5); int m2_support = reader.GetInt32(6); int sataPorts = reader.GetInt32(7); string lanModule = reader.GetString(8); string soundModule = reader.GetString(9); int usb3 = reader.GetInt32(10); int usb2 = reader.GetInt32(11); int fanheader = reader.GetInt32(12); string rgb = reader.GetString(13); double price = reader.GetDouble(14); Motherboard mb = new Motherboard(brand, model, socket, size, memsup, m2_support, sataPorts, lanModule, soundModule, usb3, usb2, fanheader, rgb, price); mbs.Add(mb); } } connection.Close(); return(mbs); }
/// <summary> /// Vreating a new entry for a PowerSupply /// </summary> /// <param name="brand">Manufacturer of PSU</param> /// <param name="model">Productname of PSU</param> /// <param name="wattage">Maximum Power output of PSU</param> /// <param name="size">Biggest compatible Pc Formfactor</param> /// <param name="efficiency">Standardized Efficiency Rating of PSU</param> /// <param name="modularity">Modularity of PSU</param> /// <param name="multiGPU">Multi GPU capable</param> /// <param name="maxsata">Maximum amount of Sata connectors</param> /// <param name="cabletype">Isolation of Cable(Sleved, Rubber,...)</param> /// <param name="price">MSRP of PSU</param> public PowerSupply(string brand, string model, int wattage, Formfactor size, string efficiency, bool modularity, bool multiGPU, int maxsata, string cabletype, double price) { this.Brand = brand; this.Model = model; this.Wattage = wattage; this.Size = size; this.Efficiency = efficiency; this.Modular = modularity; this.MultiGPU = multiGPU; this.SataConnector = maxsata; this.CableType = cabletype; this.Price = price; }
/// <summary> /// Creating a new Case Entry /// </summary> /// <param name="brand">Manufacturer of Case</param> /// <param name="model">Biggest supported Meinbaord size</param> /// <param name="size">Biggest supported Meinbaord size</param> /// <param name="hdd">Maximum of supported 3.5inch drives</param> /// <param name="ssd">Maximum of supported 2.5inch drives</param> /// <param name="maxrad">Minimum needed PSU size</param> /// <param name="sideglas">Side Panel Material (If no window = "none")</param> /// <param name="fans">All preinstalled Fans</param> /// <param name="color">Color of Case</param> /// <param name="Price">MSRP of Case</param> public Case(string brand, string model, Formfactor size, int hdd, int ssd, int maxrad, string sideglas, List <Fan> fans, string color, double price) { this.Brand = brand; this.Model = model; this.Size = size; this.HDDBays = hdd; this.SSDBays = ssd; this.MaxRad = maxrad; this.SideGlas = sideglas; this.PreinstalledFans = fans; this.Color = color; this.Price = price; }
public IComponent Constructor(OptionCollection options, dynamic modelParserResult) { Formfactor formfactor = Server.FindOrAdd(modelParserResult.Formfactor, options.Formfactors, new Formfactor()); return(new HDD { Brand = Brand, Model = modelParserResult.Model, Benchmark = Benchmark, Price = Price, Url = Url, Formfactor = formfactor.Id, Capacity = modelParserResult.Capacity }); }
/// <summary> /// Creating a new Motherboard entry /// </summary> /// <param name="brand">Name of Manufacturer of MB</param> /// <param name="model">product name of MB</param> /// <param name="socket">Compatible CPU Socket</param> /// <param name="size">standardized Size of MB (E_ATX, ATX, Mini_ATX, Micro_ATX, ITX)</param> /// <param name="memsup">Maximum of supported Memory</param> /// <param name="m_2Slots">Amount of M.2 Slots on MB</param> /// <param name="sataPorts">Amount of Sata POrts on MB</param> /// <param name="lanModule">Model of LAN Module</param> /// <param name="soundModule">Model of Sound Module</param> /// <param name="usb3">Amount of USB 3.1 Ports</param> /// <param name="usb2">Amount of USB 2.0 Ports</param> /// <param name="fanHeader">Amount of all Fan Headers</param> /// <param name="rgb">Supported Lightningcontoll Software</param> /// <param name="price">Price for Product</param> public Motherboard(string brand, string model, string socket, Formfactor size, string memsup, int m_2Slots, int sataPorts, string lanModule, string soundModule, int usb3, int usb2, int fanHeader, string rgb, float price) { this.Brand = brand; this.Model = model; this.Socket = socket; this.Size = size; this.Memorysupport = memsup; this.M_2Slots = m_2Slots; this.SataPorts = sataPorts; this.LanModule = lanModule; this.SoundModule = soundModule; this.Usb3_1Ports = usb3; this.Usb2Ports = usb2; this.FanHeader = fanHeader; this.LightningSoution = rgb; }
public List <PowerSupply> GetAllPowerSupply() { var connection = new SqlConnection(connectionString); SqlCommand command = new SqlCommand("Select * FROM PowerSupply"); List <PowerSupply> powersupplies = new List <PowerSupply>(); command.Connection = connection; connection.Open(); using (connection) using (var reader = command.ExecuteReader()) { for (int i = 0; i < 1; i++) { reader.Read(); string brand = reader.GetString(1); string model = reader.GetString(2); int wattage = reader.GetInt32(3); Formfactor size = Formfactor.ATX; switch (reader.GetString(4)) { case "E-ATX": size = Formfactor.E_ATX; break; case "Mini-ATX": size = Formfactor.Mini_ATX; break; case "Micro-ATX": size = Formfactor.Micro_ATX; break; case "ITX": size = Formfactor.ITX; break; } string effefficiency = reader.GetString(5); bool modularity = false; if (reader.GetSqlBoolean(6) == true) { modularity = true; } bool multigpu = false; if (reader.GetSqlBoolean(7) == true) { multigpu = true; } int maxsata = reader.GetInt32(8); string cabletype = reader.GetString(9); double price = reader.GetDouble(10); PowerSupply powersupply = new PowerSupply(brand, model, wattage, size, effefficiency, modularity, multigpu, maxsata, cabletype, price); powersupplies.Add(powersupply); } } connection.Close(); return(powersupplies); }
public List <Case> GetAllCase(List <Fan> fans) { var connection = new SqlConnection(connectionString); SqlCommand command = new SqlCommand("Select * FROM _CASE"); List <Fan> includedfans = new List <Fan>(); List <Case> cases = new List <Case>(); command.Connection = connection; connection.Open(); using (connection) using (var reader = command.ExecuteReader()) { for (int i = 0; i < 1; i++) { reader.Read(); string brand = reader.GetString(1); string model = reader.GetString(2); Formfactor size = Formfactor.ATX; switch (reader.GetString(3)) { case "ATX": size = Formfactor.ATX; break; case "E-ATX": size = Formfactor.E_ATX; break; case "Mini-ATX": size = Formfactor.Mini_ATX; break; case "Micro-ATX": size = Formfactor.Micro_ATX; break; case "ITX": size = Formfactor.ITX; break; } int hdd = reader.GetInt32(4); int ssd = reader.GetInt32(5); int maxrad = reader.GetInt32(6); string sideglass = reader.GetString(7); foreach (var item in reader.GetString(8).Split(',')) { foreach (var fan in fans) { if (fan.ID == int.Parse(item)) { includedfans.Add(fan); } } } string color = reader.GetString(9); double price = reader.GetDouble(10); Case _case = new Case(brand, model, size, hdd, ssd, maxrad, sideglass, includedfans, color, price); cases.Add(_case); } } connection.Close(); return(cases); }