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