public List <Device> SelectAllDevices() { List <Device> devs = new List <Device>(); this.con.Open(); try { using (SqlCommand command = new SqlCommand("Select * From Device", this.con)) using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { Device dev = new Device.DeviceBuilder().SetName(reader.GetString(1)).SetManufacturer(reader.GetString(2)).SetType(reader.GetString(3)).SetOs(reader.GetString(4)).SetOsVersion(reader.GetString(5)).SetProcessor(reader.GetString(6)).SetRam(reader.GetInt32(7)).build(); devs.Add(dev); } } } catch (SystemException ex) { MessageBox.Show(string.Format("An error occurred: {0}", ex.Message)); } finally { this.con.Close(); } return(devs); }
public Device SelectDevice(string name) { this.con.Open(); Device dev = null; try { SqlCommand command = new SqlCommand("Select * From Device where name=@name", this.con); command.Parameters.AddWithValue("@name", name); using (SqlDataReader reader = command.ExecuteReader()) { while (reader.Read()) { dev = new Device.DeviceBuilder().SetName(reader.GetString(1)).SetManufacturer(reader.GetString(2)).SetType(reader.GetString(3)).SetOs(reader.GetString(4)).SetOsVersion(reader.GetString(5)).SetProcessor(reader.GetString(6)).SetRam(reader.GetInt32(7)).build(); } } }catch (SystemException ex) { MessageBox.Show(string.Format("An error occurred: {0}", ex.Message)); } finally{ this.con.Close(); } return(dev); }
public int InsertDevice(string name, string manufacturer, string type, string os, string osVersion, string processor, string ram) { Device dev = new Device.DeviceBuilder().SetName(name).SetManufacturer(manufacturer).SetType(type).SetOs(os).SetOsVersion(osVersion).SetProcessor(processor).SetRam(Convert.ToInt32(ram)).build(); if (this.repo.VerifyDevice(dev.Name) == 1) { return(1); } this.repo.InsertDevice(dev); return(0); }
public void UpdateDevice(string name, string manufacturer, string type, string os, string osVersion, string processor, int v) { Device dev = new Device.DeviceBuilder().SetName(name).SetManufacturer(manufacturer).SetType(type).SetOs(os).SetOsVersion(osVersion).SetProcessor(processor).SetRam(v).build(); this.repo.UpdateDevice(dev); }