public string StringCreateTable()
{
int productParameterCount = 1;
int featureCount = 1;
string tempString = "CREATE TABLE [dbo].[Products] (";
for (int i = 0; i < parameters.ElementsNumber; i++)
{
switch (parameters.ItemsElement(i))
{
case "SKU":
{
tempString += "[SKU] NVARCHAR(100) NOT NULL, ";
break;
}
case "Brand":
{
tempString += "[Brand] NVARCHAR(100) NOT NULL, ";
break;
}
case "Price":
{
tempString += "[Price] FLOAT NOT NULL, ";
positionPrice = i;
break;
}
case "Weight":
{
tempString += "[Weight] FLOAT NULL, ";
positionWeight = i;
break;
}
case "Feature":
{
tempString += "[Feature" + featureCount + "] NVARCHAR(MAX) NULL, ";
featureCount++;
break;
}
case "Product parameter":
{
tempString += "[Product parameter" + productParameterCount + "] NVARCHAR(MAX) NULL, ";
productParameterCount++;
break;
}
}
}
tempString = tempString.TrimEnd(' ', ',');
tempString += "); alter table [Products] add constraint PK primary key (SKU, Brand);";
return(tempString);
}
public MyListDB(MyList _myList, List <string> _parameters)
{
parameters = new MyItem(_parameters);
header = _myList.Header;
items = _myList.Items;
for (int i = parameters.ElementsNumber - 1; i >= 0; i--)
{
if (parameters.ItemsElement(i) == "Ignore")
{
this.RemoveInClassAtPosition(i);
}
}
}
