public static List <Fabric> Get(string request) { Shared.SQLDatabaseConnetion connection = new Shared.SQLDatabaseConnetion(); List <Fabric> resultList = new List <Fabric>(); try { SqlDataReader reader = connection.Get(request); while (reader.Read()) { int id = Convert.ToInt32(reader.GetValue(0)); string name = Convert.ToString(reader.GetValue(1)); double length = Convert.ToDouble(reader.GetValue(2)); double price = Convert.ToDouble(reader.GetValue(3)); int manufacturerId = Convert.ToInt32(reader.GetValue(4)); string photoLink = Convert.ToString(reader.GetValue(5)); Independent.Manufacturer newManufacturer = getManufacturerById(manufacturerId); Fabric newObject = new Fabric(id, name, length, price, newManufacturer, photoLink); resultList.Add(newObject); } connection.closeConnection(); } catch (SqlException exception) { Console.WriteLine(exception.Message); Console.WriteLine("ModelList is Empty"); } return(resultList); }
public static void Add(Fabric fabric) { Shared.SQLDatabaseConnetion connection = new Shared.SQLDatabaseConnetion(); Independent.ManufacturerNetworkProxy.Add(fabric.manufacturer); connection.Insert(String.Format(Shared.RequestConsts.Put.Dependable.putFabricRequest, fabric.id, fabric.name, fabric.length, fabric.price, fabric.manufacturer.id, fabric.photoLink)); }