private string GetColumnHeaders(SqlDataReader sdr)
{
tableWidth = 0;
tableColumns = "tableCols=new Array();\n";
string header = "<thead><tr>";
for (colCount = 0; colCount < sdr.FieldCount; colCount++)
{
string colName = sdr.GetName(colCount);
DataManagerColumn dmc = dmo.getColumn(colName);
if (colName.ToLower().CompareTo("uniquekey") == 0)
{
uniqueKeyCol = 0;
}
else
{
if (dmc.Hidden != 1)
{
tableWidth += columnWidth;
CreateTableColumnDefinition(colName);
header += HeaderCol(sdr, dmc);
}
}
}
header += "</tr></thead>\n";
return(header);
}
// Creates a new instance.
static public DataManagerColumn CreateInstance(long dataManagerOptionId, string name)
{
DataManagerColumn dmc = new DataManagerColumn();
dmc.DataManagerOptionId = dataManagerOptionId;
dmc.Name = name;
dmc.save();
return(dmc);
}
// Called each a new record has been loaded by the DataLoader().
private void RecordLoaded(SqlDataReader sdr)
{
DataManagerColumn dmc = new DataManagerColumn();
dmc.Id = (int)sdr[sdr.GetOrdinal("id")];
dmc.Width = (int)sdr[sdr.GetOrdinal("width")];
dmc.Hidden = (int)sdr[sdr.GetOrdinal("hidden")];
dmc.Name = (string)sdr[sdr.GetOrdinal("name")];
dmc.DataManagerOptionId = (int)sdr[sdr.GetOrdinal("datamanageroption_id")];
Records.Add(dmc);
}
public void resetHiddenColumns()
{
List <RainmakerData> columns = DataManagerColumn.FetchDataSet((" datamanageroption_id=" + Id), null);
foreach (RainmakerData rd in columns)
{
DataManagerColumn dmc = (DataManagerColumn)rd;
dmc.Hidden = 0;
dmc.save();
}
}
// Gets an option column. If that column does not exist it will be
// created with default values.
public DataManagerColumn getColumn(string columnName)
{
List <RainmakerData> columns = DataManagerColumn.FetchDataSet(("name='" + columnName + "' AND datamanageroption_id=" + Id), null);
if (columns.Count >= 1)
{
return((DataManagerColumn)columns[0]);
}
else
{
return(DataManagerColumn.CreateInstance(Id, columnName));
}
}
private void copyColumns(int newId)
{
List <RainmakerData> columns = DataManagerColumn.FetchDataSet((" datamanageroption_id=" + Id), null);
foreach (RainmakerData rd in columns)
{
DataManagerColumn dmc = (DataManagerColumn)rd;
DataManagerColumn newDmc = DataManagerColumn.CreateInstance(newId, dmc.Name);
newDmc.Hidden = dmc.Hidden;
newDmc.Width = dmc.Width;
newDmc.Name = dmc.Name;
newDmc.save();
}
}
private string HeaderCol(SqlDataReader sdr, DataManagerColumn dmc)
{
string sortMsg = "";
if (colCount == (dmo.SortColumn - 1) && (dmo.SortActive == 1))
{
if (dmo.SortDirection == 1)
{
sortMsg = "<div class='columnSortDirection'><img src='resources/up.gif' width='15px'/></div>";
}
else
{
sortMsg = "<div class='columnSortDirection'><img src='resources/down.gif' width='15px'/></div>";
}
}
columnWidth = (int)dmc.Width;
if ((colCount == (sdr.FieldCount - 1)))
{
return(String.Format(@"
<td id=""sizer{0}"" class=""gridHeader"" style=""width: {2}px"">
<table style=""width: 100%; background-color: #CCCCCC; border: 0px solid black"" cellspacing=""0"" cellpadding=""0"">
<tr>
<td style=""background-color: #CCCCCC; width: 30px""><input type=""checkbox"" style=""width: 0px; height: 0px; margin-left: 10px"" onclick=""hideColumn('{3}')""/></td>
<td style=""background-color: #CCCCCC; padding-left: 5px"" onclick=""sortByColumn({0})"">{3}</td>
<td style=""background-color: #CCCCCC"">{4}</td>
<td style=""background-color: #CCCCCC""> </td>
</tr>
</table>
</td>" ,
colCount, colCount, columnWidth, dmc.Name, sortMsg));
}
else
{
return(String.Format(@"
<td id=""sizer{0}"" class=""gridHeader"" style=""width: {2}px"">
<table style=""width: 100%; background-color: #CCCCCC; border: 0px solid black"" cellspacing=""0"" cellpadding=""0"">
<tr>
<td style=""background-color: #CCCCCC; width: 30px""><input type=""checkbox"" style=""width: 0px; height: 0px; margin-left: 10px"" onclick=""hideColumn('{3}')""/></td>
<td style=""background-color: #CCCCCC; padding-left: 5px"" onclick=""sortByColumn({0})"">{3}</td>
<td style=""background-color: #CCCCCC"">{4}</td>
<td class=""columnDragger"" style=""background-color: #666666"" onmousedown=""resizeColumnStart(event, '{0}', '{1}')""> </td>
</tr>
</table>
</td>" ,
colCount, (colCount + 1), columnWidth, dmc.Name, sortMsg));
}
}
private string GetRow(SqlDataReader sdr)
{
ToggleBackgroundColor();
string row = "<tr>";
for (int i = 0; i < sdr.FieldCount; i++)
{
string dataType = (string)sdr.GetFieldType(i).ToString();
string value = (string)sdr[i].ToString();
value = value.Replace("'", "");
if (i == uniqueKeyCol)
{
// Just record this value so it can be tracked later.
rowKeys += String.Format("rowKeys[{0}] = {{id: {1}}};\n", (rowCount - 1), value);
}
else
{
string colName = sdr.GetName(i);
string chooseAction = String.Format(@"onclick=""chooseCell({0}, {1})""", i, rowCount);
if (colName == "PhoneNum")
{
chooseAction = "";
}
DataManagerColumn dmc = dmo.getColumn(colName);
if (dmc.Hidden != 1)
{
// Add this column to the data set that will be displayed.
if (i == 1)
{
row += String.Format("<td id=\"{0}x{1}\" dataType=\"{3}\" class=\"left\" style=\"background-color: {4}\" {5}>{2}</td>", i, rowCount, value, dataType, backgroundColor, chooseAction);
}
else if (i == (sdr.FieldCount - 1))
{
row += String.Format("<td id=\"{0}x{1}\" dataType=\"{3}\" class=\"right\" style=\"background-color: {4}\" {5}>{2}</td>", i, rowCount, value, dataType, backgroundColor, chooseAction);
}
else
{
row += String.Format("<td id=\"{0}x{1}\" dataType=\"{3}\" style=\"background-color: {4}\" {5}>{2}</td>", i, rowCount, value, dataType, backgroundColor, chooseAction);
}
}
}
}
row += "</tr>\n\n";
rowCount++;
return(row);
}
private string GetCSVColumnHeaders(SqlDataReader sdr)
{
string csv = "";
for (colCount = 0; colCount < sdr.FieldCount; colCount++)
{
string colName = sdr.GetName(colCount);
DataManagerColumn dmc = dmo.getColumn(colName);
if (dmc.Hidden != 1)
{
if (csv.Length > 0)
{
csv += ", ";
}
csv += String.Format("{0}", colName);
}
}
csv += "\n";
return(csv);
}
private string GetCSVRow(SqlDataReader sdr)
{
string csv = "";
for (int i = 0; i < sdr.FieldCount; i++)
{
string colName = sdr.GetName(i);
DataManagerColumn dmc = dmo.getColumn(colName);
if (dmc.Hidden != 1)
{
string value = (string)sdr[i].ToString();
// THIS MAY BE BAD BUT IT HIDES COMMAS FROM TH OUTPUT
value = value.Replace(",", "");
if (csv.Length > 0)
{
csv += ", ";
}
csv += String.Format("{0}", value);
}
}
csv += "\n";
return(csv);
}
// Gets a set of records from the Campaign table.
static public List <RainmakerData> FetchDataSet(string options, string order)
{
DataManagerColumn rc = new DataManagerColumn();
return(rc.GetDataSet(options, order));
}
