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