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