// Add the Column Data. public Insert PutColumn(ColumnData columnData) { try { // Here we will Add the column data into the Column SQL & Binders. if (bindObjs.ContainsKey(columnData.GetColumn())) { // This Column is Already Added. return(this); } else { // Only let to proceed if the Column does'nt have the special rows. bool doProceed = true; if (cdb.IsSystemUser) { // The user is the system doProceed = true; } else if (columnData.GetColumn().ElementAt(columnData.GetColumn().Length - 1) == '_') { // This column is not a valid column and must be left only for the system to edit. doProceed = false; AddStatus("User cannot Add " + columnData.GetColumn() + " System Column"); } // Proceed if the user is allowed to. if (doProceed) { // This Columns is valid. if (columnDataBuilder.Length > 0) { columnDataBuilder.Append(", "); columnPlaceHolderBuilder.Append(", "); } // Lets check and add the random. if (columnData.Get().ToString().ToUpper() == RANDOM) { // The user wants to add a column to have random value. columnDataBuilder.Append(columnData.GetColumn()); columnPlaceHolderBuilder.Append(" (ABS(RANDOM())) "); } else { // The user wants a normal column. columnDataBuilder.Append(columnData.GetColumn()); columnPlaceHolderBuilder.Append("@") .Append(columnData.GetColumn()); // Put the Bind object. bindObjs.Add(columnData.GetColumn(), columnData.Get()); } } return(this); } } catch (Exception e) { // There was an Error. AddStatus("Put Column Error : " + e.Message + " : " + e.StackTrace); return(this); } }