private void OnDataBinding(object sender, EventArgs e)
{
Literal lbl = (Literal)sender;
DataGridItem objContainer = (DataGridItem)lbl.NamingContainer;
DataRowView row = objContainer.DataItem as DataRowView;
if (row != null)
{
if (row[sDATA_FIELD] != DBNull.Value)
{
switch (sDATA_FORMAT)
{
case "DateTime":
{
// 03/30/2007 Paul. T10n should never be NULL.
TimeZone T10n = HttpContext.Current.Items["T10n"] as TimeZone;
if (T10n != null)
{
lbl.Text = Sql.ToString(T10n.FromServerTime(row[sDATA_FIELD]));
}
break;
}
case "Date":
{
// 03/30/2007 Paul. T10n should never be NULL.
TimeZone T10n = HttpContext.Current.Items["T10n"] as TimeZone;
if (T10n != null)
{
lbl.Text = Sql.ToDateString(T10n.FromServerTime(row[sDATA_FIELD]));
}
break;
}
case "Currency":
{
// 03/30/2007 Paul. Move init of C10n to minimize use.
// 05/09/2006 Paul. Convert the currency values before displaying.
// The UI culture should already be set to format the currency.
Currency C10n = HttpContext.Current.Items["C10n"] as Currency;
Decimal d = C10n.ToCurrency(Convert.ToDecimal(row[sDATA_FIELD]));
lbl.Text = d.ToString("c");
break;
}
default:
lbl.Text = Sql.ToString(row[sDATA_FIELD]);
break;
}
}
}
else
{
lbl.Text = sDATA_FIELD;
}
}
private void OnDataBinding(object sender, EventArgs e)
{
Literal lbl = (Literal)sender;
DataGridItem objContainer = (DataGridItem)lbl.NamingContainer;
DataRowView row = objContainer.DataItem as DataRowView;
if (row != null)
{
// 04/30/2006 Paul. Use the Context to store pointers to the localization objects.
// This is so that we don't need to require that the page inherits from SplendidPage.
TimeZone T10n = HttpContext.Current.Items["T10n"] as TimeZone;
if (T10n == null)
{
Guid gTIMEZONE = Sql.ToGuid(HttpContext.Current.Session["USER_SETTINGS/TIMEZONE"]);
T10n = TimeZone.CreateTimeZone(gTIMEZONE);
}
// 05/09/2006 Paul. Convert the currency values before displaying.
// The UI culture should already be set to format the currency.
Currency C10n = HttpContext.Current.Items["C10n"] as Currency;
if (C10n == null)
{
Guid gCURRENCY_ID = Sql.ToGuid(HttpContext.Current.Session["USER_SETTINGS/CURRENCY"]);
C10n = Currency.CreateCurrency(gCURRENCY_ID);
}
if (row[sDATA_FIELD] != DBNull.Value)
{
switch (sDATA_FORMAT)
{
case "DateTime":
if (T10n != null)
{
lbl.Text = Sql.ToString(T10n.FromServerTime(row[sDATA_FIELD]));
}
break;
case "Date":
if (T10n != null)
{
lbl.Text = Sql.ToDateString(T10n.FromServerTime(row[sDATA_FIELD]));
}
break;
case "Currency":
{
float f = Sql.ToFloat(row[sDATA_FIELD]);
f = C10n.ToCurrency(f);
Decimal d = Convert.ToDecimal(f);
lbl.Text = d.ToString("c");
break;
}
default:
lbl.Text = Sql.ToString(row[sDATA_FIELD]);
break;
}
}
}
else
{
lbl.Text = sDATA_FIELD;
}
}
public static void AppendDetailViewFields(DataView dvFields, HtmlTable tbl, IDataReader rdr, L10N L10n, TimeZone T10n, CommandEventHandler Page_Command, bool bLayoutMode)
{
HtmlTableRow tr = null;
// 11/28/2005 Paul. Start row index using the existing count so that headers can be specified.
int nRowIndex = tbl.Rows.Count - 1;
int nColIndex = 0;
// 01/07/2006 Paul. Show table borders in layout mode. This will help distinguish blank lines from wrapped lines.
if ( bLayoutMode )
tbl.Border = 1;
HttpSessionState Session = HttpContext.Current.Session;
foreach(DataRowView row in dvFields)
{
Guid gID = Sql.ToGuid (row["ID" ]);
int nFIELD_INDEX = Sql.ToInteger(row["FIELD_INDEX"]);
string sFIELD_TYPE = Sql.ToString (row["FIELD_TYPE" ]);
string sDATA_LABEL = Sql.ToString (row["DATA_LABEL" ]);
string sDATA_FIELD = Sql.ToString (row["DATA_FIELD" ]);
string sDATA_FORMAT = Sql.ToString (row["DATA_FORMAT"]);
string sLIST_NAME = Sql.ToString (row["LIST_NAME" ]);
int nCOLSPAN = Sql.ToInteger(row["COLSPAN" ]);
string sLABEL_WIDTH = Sql.ToString (row["LABEL_WIDTH"]);
string sFIELD_WIDTH = Sql.ToString (row["FIELD_WIDTH"]);
if ( nColIndex == 0 )
{
// 11/25/2005 Paul. Don't pre-create a row as we don't want a blank
// row at the bottom. Add rows just before they are needed.
nRowIndex++;
tr = new HtmlTableRow();
tbl.Rows.Insert(nRowIndex, tr);
}
if ( bLayoutMode )
{
HtmlTableCell tdAction = new HtmlTableCell();
tr.Cells.Add(tdAction);
tdAction.Attributes.Add("class", "tabDetailViewDL");
tdAction.NoWrap = true;
Literal litIndex = new Literal();
tdAction.Controls.Add(litIndex);
litIndex.Text = " " + nFIELD_INDEX.ToString() + " ";
ImageButton btnMoveUp = CreateLayoutImageButton(gID, "Layout.MoveUp" , nFIELD_INDEX, L10n.Term(".LNK_UP" ), Sql.ToString(Session["themeURL"]) + "images/uparrow_inline.gif" , Page_Command);
ImageButton btnMoveDown = CreateLayoutImageButton(gID, "Layout.MoveDown", nFIELD_INDEX, L10n.Term(".LNK_DOWN" ), Sql.ToString(Session["themeURL"]) + "images/downarrow_inline.gif", Page_Command);
ImageButton btnInsert = CreateLayoutImageButton(gID, "Layout.Insert" , nFIELD_INDEX, L10n.Term(".LNK_INS" ), Sql.ToString(Session["themeURL"]) + "images/plus_inline.gif" , Page_Command);
ImageButton btnEdit = CreateLayoutImageButton(gID, "Layout.Edit" , nFIELD_INDEX, L10n.Term(".LNK_EDIT" ), Sql.ToString(Session["themeURL"]) + "images/edit_inline.gif" , Page_Command);
ImageButton btnDelete = CreateLayoutImageButton(gID, "Layout.Delete" , nFIELD_INDEX, L10n.Term(".LNK_DELETE"), Sql.ToString(Session["themeURL"]) + "images/delete_inline.gif" , Page_Command);
tdAction.Controls.Add(btnMoveUp );
tdAction.Controls.Add(btnMoveDown);
tdAction.Controls.Add(btnInsert );
tdAction.Controls.Add(btnEdit );
tdAction.Controls.Add(btnDelete );
}
HtmlTableCell tdLabel = new HtmlTableCell();
HtmlTableCell tdField = new HtmlTableCell();
tr.Cells.Add(tdLabel);
tr.Cells.Add(tdField);
if ( nCOLSPAN > 0 )
{
tdField.ColSpan = nCOLSPAN;
if ( bLayoutMode )
tdField.ColSpan++;
}
tdLabel.Attributes.Add("class", "tabDetailViewDL");
tdLabel.VAlign = "top";
tdLabel.Width = sLABEL_WIDTH;
tdField.Attributes.Add("class", "tabDetailViewDF");
tdField.VAlign = "top";
// 11/28/2005 Paul. Don't use the field width if COLSPAN is specified as we want it to take the rest of the table. The label width will be sufficient.
if ( nCOLSPAN == 0 )
tdField.Width = sFIELD_WIDTH;
Literal litLabel = new Literal();
HyperLink lnkField = null;
tdLabel.Controls.Add(litLabel);
//litLabel.Text = nFIELD_INDEX.ToString() + " (" + nRowIndex.ToString() + "," + nColIndex.ToString() + ")";
try
{
if ( bLayoutMode )
litLabel.Text = sDATA_LABEL;
else if ( sDATA_LABEL.IndexOf(".") >= 0 )
litLabel.Text = L10n.Term(sDATA_LABEL);
else if ( !Sql.IsEmptyString(sDATA_LABEL) && rdr != null )
litLabel.Text = Sql.ToString(rdr[sDATA_LABEL]) + L10n.Term("Calls.LBL_COLON");
// 07/15/2006 Paul. Always put something for the label so that table borders will look right.
else
litLabel.Text = " ";
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
litLabel.Text = ex.Message;
}
if ( String.Compare(sFIELD_TYPE, "Blank", true) == 0 )
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
if ( bLayoutMode )
{
litLabel.Text = "*** BLANK ***";
litField.Text = "*** BLANK ***";
}
else
{
litField.Text = " ";
}
}
else if ( String.Compare(sFIELD_TYPE, "Line", true) == 0 )
{
if ( bLayoutMode )
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
litLabel.Text = "*** LINE ***";
litField.Text = "*** LINE ***";
}
else
{
tr.Cells.Clear();
}
}
else if ( String.Compare(sFIELD_TYPE, "String", true) == 0 )
{
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
else if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/06/2005 Paul. Wrap all string fields in a SPAN tag to simplify regression testing.
HtmlGenericControl spnField = new HtmlGenericControl("span");
tdField.Controls.Add(spnField);
spnField.ID = sDATA_FIELD;
Literal litField = new Literal();
spnField.Controls.Add(litField);
try
{
string[] arrLIST_NAME = sLIST_NAME .Split(' ');
string[] arrDATA_FIELD = sDATA_FIELD.Split(' ');
object[] objDATA_FIELD = new object[arrDATA_FIELD.Length];
for ( int i=0 ; i < arrDATA_FIELD.Length; i++ )
{
if ( arrDATA_FIELD[i].IndexOf(".") >= 0 )
{
objDATA_FIELD[i] = L10n.Term(arrDATA_FIELD[i]);
}
else if ( !Sql.IsEmptyString(sLIST_NAME) )
{
if ( arrLIST_NAME.Length == arrDATA_FIELD.Length )
{
if ( rdr != null )
objDATA_FIELD[i] = L10n.Term("." + arrLIST_NAME[i] + ".", rdr[arrDATA_FIELD[i]]);
else
objDATA_FIELD[i] = String.Empty;
}
}
else if ( !Sql.IsEmptyString(arrDATA_FIELD[i]) )
{
if ( rdr != null && rdr[arrDATA_FIELD[i]] != DBNull.Value)
{
// 12/05/2005 Paul. If the data is a DateTime field, then make sure to perform the timezone conversion.
if ( rdr[arrDATA_FIELD[i]].GetType() == Type.GetType("System.DateTime") )
objDATA_FIELD[i] = T10n.FromServerTime(rdr[arrDATA_FIELD[i]]);
else
objDATA_FIELD[i] = rdr[arrDATA_FIELD[i]];
}
else
objDATA_FIELD[i] = String.Empty;
}
}
if ( rdr != null )
{
// 01/09/2006 Paul. Allow DATA_FORMAT to be optional. If missing, write data directly.
if ( sDATA_FORMAT == String.Empty )
{
for ( int i=0; i < arrDATA_FIELD.Length; i++ )
arrDATA_FIELD[i] = Sql.ToString(objDATA_FIELD[i]);
litField.Text = String.Join(" ", arrDATA_FIELD);
}
else
litField.Text = String.Format(sDATA_FORMAT, objDATA_FIELD);
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
litField.Text = ex.Message;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "CheckBox", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
CheckBox chkField = new CheckBox();
tdField.Controls.Add(chkField);
chkField.Enabled = false ;
chkField.CssClass = "checkbox";
// 03/16/2006 Paul. Give the checkbox a name so that it can be validated with SplendidTest.
chkField.ID = sDATA_FIELD;
try
{
if ( rdr != null )
chkField.Checked = Sql.ToBoolean(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "Button", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
Button btnField = new Button();
tdField.Controls.Add(btnField);
btnField.CssClass = "button";
// 03/16/2006 Paul. Give the button a name so that it can be validated with SplendidTest.
btnField.ID = sDATA_FIELD;
if ( Page_Command != null )
{
btnField.Command += Page_Command;
btnField.CommandName = sDATA_FORMAT ;
}
try
{
if ( bLayoutMode )
{
btnField.Text = sDATA_FIELD;
btnField.Enabled = false ;
}
else if ( sDATA_FIELD.IndexOf(".") >= 0 )
{
btnField.Text = L10n.Term(sDATA_FIELD);
}
else if ( !Sql.IsEmptyString(sDATA_FIELD) && rdr != null )
{
btnField.Text = Sql.ToString(rdr[sDATA_FIELD]);
}
btnField.Attributes.Add("title", btnField.Text);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
btnField.Text = ex.Message;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "Textbox", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
TextBox txtField = new TextBox();
tdField.Controls.Add(txtField);
txtField.ReadOnly = true;
txtField.TextMode = TextBoxMode.MultiLine;
// 03/16/2006 Paul. Give the textbox a name so that it can be validated with SplendidTest.
txtField.ID = sDATA_FIELD;
try
{
string[] arrDATA_FORMAT = sDATA_FORMAT.Split(',');
if ( arrDATA_FORMAT.Length == 2 )
{
txtField.Rows = Sql.ToInteger(arrDATA_FORMAT[0]);
txtField.Columns = Sql.ToInteger(arrDATA_FORMAT[1]);
}
if ( bLayoutMode )
{
txtField.Text = sDATA_FIELD;
}
else if ( !Sql.IsEmptyString(sDATA_FIELD) && rdr != null )
{
txtField.Text = Sql.ToString(rdr[sDATA_FIELD]);
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
txtField.Text = ex.Message;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "HyperLink", true) == 0 )
{
string sURL_FIELD = Sql.ToString (row["URL_FIELD"]);
if ( !Sql.IsEmptyString(sDATA_FIELD) && !Sql.IsEmptyString(sURL_FIELD) )
{
string sURL_FORMAT = Sql.ToString (row["URL_FORMAT"]);
string sURL_TARGET = Sql.ToString (row["URL_TARGET"]);
lnkField = new HyperLink();
tdField.Controls.Add(lnkField);
lnkField.Target = sURL_TARGET;
lnkField.CssClass = "tabDetailViewDFLink";
// 03/16/2006 Paul. Give the hyperlink a name so that it can be validated with SplendidTest.
lnkField.ID = sDATA_FIELD;
try
{
if ( bLayoutMode )
{
lnkField.Text = sDATA_FIELD;
lnkField.Enabled = false ;
}
else if ( rdr != null )
{
if ( !Sql.IsEmptyString(rdr[sDATA_FIELD]) )
{
// 01/09/2006 Paul. Allow DATA_FORMAT to be optional. If missing, write data directly.
if ( sDATA_FORMAT == String.Empty )
lnkField.Text = Sql.ToString(rdr[sDATA_FIELD]);
else
lnkField.Text = String.Format(sDATA_FORMAT, Sql.ToString(rdr[sDATA_FIELD]));
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
lnkField.Text = ex.Message;
}
try
{
if ( bLayoutMode )
{
lnkField.NavigateUrl = sURL_FIELD;
}
else if ( rdr != null )
{
if ( !Sql.IsEmptyString(rdr[sURL_FIELD]) )
{
// 01/09/2006 Paul. Allow DATA_FORMAT to be optional. If missing, write data directly.
if ( sDATA_FORMAT == String.Empty )
lnkField.NavigateUrl = Sql.ToString(rdr[sURL_FIELD]);
else
lnkField.NavigateUrl = String.Format(sURL_FORMAT, Sql.ToString(rdr[sURL_FIELD]));
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
lnkField.NavigateUrl = ex.Message;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "Image", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
Image imgField = new Image();
// 04/13/2006 Paul. Give the image a name so that it can be validated with SplendidTest.
imgField.ID = sDATA_FIELD;
try
{
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
else if ( rdr != null )
{
if ( !Sql.IsEmptyString(rdr[sDATA_FIELD]) )
{
imgField.ImageUrl = "~/Images/Image.aspx?ID=" + Sql.ToString(rdr[sDATA_FIELD]);
// 04/13/2006 Paul. Only add the image if it exists.
tdField.Controls.Add(imgField);
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
lnkField.Text = ex.Message;
}
}
}
else
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
litField.Text = "Unknown field type " + sFIELD_TYPE;
// 01/07/2006 Paul. Don't report the error in layout mode.
if ( !bLayoutMode )
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), "Unknown field type " + sFIELD_TYPE);
}
if ( nCOLSPAN > 0 )
nColIndex = 0;
else
{
nColIndex++;
if ( nColIndex > 1 )
nColIndex = 0;
}
}
}
/*
// 01/16/2006 Paul. If we disable the validator, it will hide it's error message.
// The solution may be to always require server-side validation (disable EnableClientScript).
public static void DisableValidationEditViewFields(string sEDIT_NAME, Control parent)
{
DataTable dtFields = SplendidCache.EditViewFields(sEDIT_NAME);
DataView dvFields = new DataView(dtFields);
dvFields.RowFilter = "UI_REQUIRED = 1";
foreach(DataRowView row in dvFields)
{
string sFIELD_TYPE = Sql.ToString (row["FIELD_TYPE" ]);
string sDATA_FIELD = Sql.ToString (row["DATA_FIELD" ]);
bool bUI_REQUIRED = Sql.ToBoolean(row["UI_REQUIRED" ]);
if ( bUI_REQUIRED && !Sql.IsEmptyString(sDATA_FIELD) )
{
if ( String.Compare(sFIELD_TYPE, "DatePicker", true) == 0 )
{
DatePicker ctlDate = parent.FindControl(sDATA_FIELD) as DatePicker;
if ( ctlDate != null )
ctlDate.DisableValidation();
}
else if ( String.Compare(sFIELD_TYPE, "DateTimePicker", true) == 0 )
{
DateTimePicker ctlDate = parent.FindControl(sDATA_FIELD) as DateTimePicker;
if ( ctlDate != null )
ctlDate.DisableValidation();
}
else if ( String.Compare(sFIELD_TYPE, "DateTimeEdit", true) == 0 )
{
DateTimeEdit ctlDate = parent.FindControl(sDATA_FIELD) as DateTimeEdit;
if ( ctlDate != null )
ctlDate.DisableValidation();
}
else
{
BaseValidator req = parent.FindControl(sDATA_FIELD + "_REQUIRED") as BaseValidator;
if ( req != null )
{
// 01/16/2006 Paul. Enable validator before validating page.
// If we leave the validator control enabled, then it may block an alternate action, like Cancel.
req.Enabled = false;
}
}
}
}
}
*/
public static void AppendEditViewFields(DataView dvFields, HtmlTable tbl, IDataReader rdr, L10N L10n, TimeZone T10n, CommandEventHandler Page_Command, bool bLayoutMode)
{
HtmlTableRow tr = null;
// 11/28/2005 Paul. Start row index using the existing count so that headers can be specified.
int nRowIndex = tbl.Rows.Count - 1;
int nColIndex = 0;
HtmlTableCell tdLabel = null;
HtmlTableCell tdField = null;
// 01/07/2006 Paul. Show table borders in layout mode. This will help distinguish blank lines from wrapped lines.
if ( bLayoutMode )
tbl.Border = 1;
HttpSessionState Session = HttpContext.Current.Session;
foreach(DataRowView row in dvFields)
{
Guid gID = Sql.ToGuid (row["ID" ]);
int nFIELD_INDEX = Sql.ToInteger(row["FIELD_INDEX" ]);
string sFIELD_TYPE = Sql.ToString (row["FIELD_TYPE" ]);
string sDATA_LABEL = Sql.ToString (row["DATA_LABEL" ]);
string sDATA_FIELD = Sql.ToString (row["DATA_FIELD" ]);
string sDISPLAY_FIELD = Sql.ToString (row["DISPLAY_FIELD" ]);
string sCACHE_NAME = Sql.ToString (row["CACHE_NAME" ]);
bool bDATA_REQUIRED = Sql.ToBoolean(row["DATA_REQUIRED" ]);
bool bUI_REQUIRED = Sql.ToBoolean(row["UI_REQUIRED" ]);
string sONCLICK_SCRIPT = Sql.ToString (row["ONCLICK_SCRIPT" ]);
string sFORMAT_SCRIPT = Sql.ToString (row["FORMAT_SCRIPT" ]);
short nFORMAT_TAB_INDEX = Sql.ToShort (row["FORMAT_TAB_INDEX" ]);
int nFORMAT_MAX_LENGTH = Sql.ToInteger(row["FORMAT_MAX_LENGTH"]);
int nFORMAT_SIZE = Sql.ToInteger(row["FORMAT_SIZE" ]);
int nFORMAT_ROWS = Sql.ToInteger(row["FORMAT_ROWS" ]);
int nFORMAT_COLUMNS = Sql.ToInteger(row["FORMAT_COLUMNS" ]);
int nCOLSPAN = Sql.ToInteger(row["COLSPAN" ]);
int nROWSPAN = Sql.ToInteger(row["ROWSPAN" ]);
string sLABEL_WIDTH = Sql.ToString (row["LABEL_WIDTH" ]);
string sFIELD_WIDTH = Sql.ToString (row["FIELD_WIDTH" ]);
// 12/02/2005 Paul. COLSPAN == -1 means that a new column should not be created.
if ( (nCOLSPAN >= 0 && nColIndex == 0) || tr == null )
{
// 11/25/2005 Paul. Don't pre-create a row as we don't want a blank
// row at the bottom. Add rows just before they are needed.
nRowIndex++;
tr = new HtmlTableRow();
tbl.Rows.Insert(nRowIndex, tr);
}
if ( bLayoutMode )
{
HtmlTableCell tdAction = new HtmlTableCell();
tr.Cells.Add(tdAction);
tdAction.Attributes.Add("class", "tabDetailViewDL");
tdAction.NoWrap = true;
Literal litIndex = new Literal();
tdAction.Controls.Add(litIndex);
litIndex.Text = " " + nFIELD_INDEX.ToString() + " ";
ImageButton btnMoveUp = CreateLayoutImageButton(gID, "Layout.MoveUp" , nFIELD_INDEX, L10n.Term(".LNK_UP" ), Sql.ToString(Session["themeURL"]) + "images/uparrow_inline.gif" , Page_Command);
ImageButton btnMoveDown = CreateLayoutImageButton(gID, "Layout.MoveDown", nFIELD_INDEX, L10n.Term(".LNK_DOWN" ), Sql.ToString(Session["themeURL"]) + "images/downarrow_inline.gif", Page_Command);
ImageButton btnInsert = CreateLayoutImageButton(gID, "Layout.Insert" , nFIELD_INDEX, L10n.Term(".LNK_INS" ), Sql.ToString(Session["themeURL"]) + "images/plus_inline.gif" , Page_Command);
ImageButton btnEdit = CreateLayoutImageButton(gID, "Layout.Edit" , nFIELD_INDEX, L10n.Term(".LNK_EDIT" ), Sql.ToString(Session["themeURL"]) + "images/edit_inline.gif" , Page_Command);
ImageButton btnDelete = CreateLayoutImageButton(gID, "Layout.Delete" , nFIELD_INDEX, L10n.Term(".LNK_DELETE"), Sql.ToString(Session["themeURL"]) + "images/delete_inline.gif" , Page_Command);
tdAction.Controls.Add(btnMoveUp );
tdAction.Controls.Add(btnMoveDown);
tdAction.Controls.Add(btnInsert );
tdAction.Controls.Add(btnEdit );
tdAction.Controls.Add(btnDelete );
}
if ( nCOLSPAN >= 0 || tdLabel == null || tdField == null )
{
tdLabel = new HtmlTableCell();
tdField = new HtmlTableCell();
tr.Cells.Add(tdLabel);
tr.Cells.Add(tdField);
if ( nCOLSPAN > 0 )
{
tdField.ColSpan = nCOLSPAN;
if ( bLayoutMode )
tdField.ColSpan++;
}
tdLabel.Attributes.Add("class", "dataLabel");
tdLabel.VAlign = "top";
tdLabel.Width = sLABEL_WIDTH;
tdField.Attributes.Add("class", "dataField");
tdField.VAlign = "top";
// 11/28/2005 Paul. Don't use the field width if COLSPAN is specified as we want it to take the rest of the table. The label width will be sufficient.
if ( nCOLSPAN == 0 )
tdField.Width = sFIELD_WIDTH;
Literal litLabel = new Literal();
tdLabel.Controls.Add(litLabel);
//litLabel.Text = nFIELD_INDEX.ToString() + " (" + nRowIndex.ToString() + "," + nColIndex.ToString() + ")";
try
{
if ( bLayoutMode )
{
if ( String.Compare(sFIELD_TYPE, "Blank", true) == 0 )
litLabel.Text = "*** BLANK ***";
else
litLabel.Text = sDATA_LABEL;
}
else if ( sDATA_LABEL.IndexOf(".") >= 0 )
litLabel.Text = L10n.Term(sDATA_LABEL);
else if ( !Sql.IsEmptyString(sDATA_LABEL) && rdr != null )
litLabel.Text = Sql.ToString(rdr[sDATA_LABEL]) + L10n.Term("Calls.LBL_COLON");
// 07/15/2006 Paul. Always put something for the label so that table borders will look right.
else
litLabel.Text = " ";
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
litLabel.Text = ex.Message;
}
if ( !bLayoutMode && bUI_REQUIRED )
{
Label lblRequired = new Label();
tdLabel.Controls.Add(lblRequired);
lblRequired.CssClass = "required";
lblRequired.Text = L10n.Term(".LBL_REQUIRED_SYMBOL");
}
}
if ( String.Compare(sFIELD_TYPE, "Blank", true) == 0 )
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
if ( bLayoutMode )
litField.Text = "*** BLANK ***";
else
litField.Text = " ";
}
else if ( String.Compare(sFIELD_TYPE, "Label", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
// 07/25/2006 Paul. Align label values to the middle so the line-up with the label.
tdField.VAlign = "middle";
// 07/24/2006 Paul. Set the ID so that the literal control can be accessed.
litField.ID = sDATA_FIELD;
try
{
if ( bLayoutMode )
litField.Text = sDATA_FIELD;
else if ( sDATA_FIELD.IndexOf(".") >= 0 )
litField.Text = L10n.Term(sDATA_FIELD);
else if ( rdr != null )
litField.Text = Sql.ToString(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
litField.Text = ex.Message;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "ListBox", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
DropDownList lstField = new DropDownList();
tdField.Controls.Add(lstField);
lstField.ID = sDATA_FIELD;
lstField.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/04/2005 Paul. Don't populate list if this is a post back.
if ( !Sql.IsEmptyString(sCACHE_NAME) && (bLayoutMode || !tbl.Page.IsPostBack) )
{
switch ( sCACHE_NAME )
{
case "AssignedUser":
lstField.DataValueField = "ID" ;
lstField.DataTextField = "USER_NAME";
lstField.DataSource = SplendidCache.AssignedUser();
break;
case "Currencies":
lstField.DataValueField = "ID" ;
lstField.DataTextField = "NAME_SYMBOL";
lstField.DataSource = SplendidCache.Currencies();
break;
case "Release":
lstField.DataValueField = "ID" ;
lstField.DataTextField = "NAME";
lstField.DataSource = SplendidCache.Release();
break;
case "Manufacturers":
lstField.DataValueField = "ID" ;
lstField.DataTextField = "NAME";
lstField.DataSource = SplendidCache.Manufacturers();
break;
case "Shippers":
lstField.DataValueField = "ID" ;
lstField.DataTextField = "NAME";
lstField.DataSource = SplendidCache.Shippers();
break;
case "ProductTypes":
lstField.DataValueField = "ID" ;
lstField.DataTextField = "NAME";
lstField.DataSource = SplendidCache.ProductTypes();
break;
case "ProductCategories":
lstField.DataValueField = "ID" ;
lstField.DataTextField = "NAME";
lstField.DataSource = SplendidCache.ProductCategories();
break;
case "ContractTypes":
lstField.DataValueField = "ID" ;
lstField.DataTextField = "NAME";
lstField.DataSource = SplendidCache.ContractTypes();
break;
default:
lstField.DataValueField = "NAME" ;
lstField.DataTextField = "DISPLAY_NAME";
lstField.DataSource = SplendidCache.List(sCACHE_NAME);
break;
}
lstField.DataBind();
// 08/08/2006 Paul. Allow onchange code to be stored in the database.
// ListBoxes do not have a useful onclick event, so there should be no problem overloading this field.
if ( !Sql.IsEmptyString(sONCLICK_SCRIPT) )
lstField.Attributes.Add("onchange" , sONCLICK_SCRIPT);
// 02/21/2006 Paul. Move the NONE item inside the !IsPostBack code.
if ( !bUI_REQUIRED )
lstField.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
}
if ( rdr != null )
{
try
{
// 02/21/2006 Paul. All the DropDownLists in the Calls and Meetings edit views were not getting set.
// The problem was a Page.DataBind in the SchedulingGrid and in the InviteesView. Both binds needed to be removed.
lstField.SelectedValue = Sql.ToString(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
}
// 12/04/2005 Paul. Assigned To field will always default to the current user.
else if ( rdr == null && !tbl.Page.IsPostBack && sCACHE_NAME == "AssignedUser")
{
try
{
lstField.SelectedValue = Security.USER_ID.ToString();
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "CheckBox", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
CheckBox chkField = new CheckBox();
tdField.Controls.Add(chkField);
chkField.ID = sDATA_FIELD;
chkField.CssClass = "checkbox";
chkField.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( rdr != null )
chkField.Checked = Sql.ToBoolean(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
chkField.Enabled = false ;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "ChangeButton", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/04/2005 Paul. If the label is PARENT_TYPE, then change the label to a DropDownList.
if ( sDATA_LABEL == "PARENT_TYPE" )
{
tdLabel.Controls.Clear();
DropDownList lstField = new DropDownList();
tdLabel.Controls.Add(lstField);
lstField.ID = sDATA_LABEL;
lstField.TabIndex = nFORMAT_TAB_INDEX;
lstField.Attributes.Add("onChange", "ChangeParentType();");
if ( bLayoutMode || !tbl.Page.IsPostBack )
{
// 07/29/2005 Paul. SugarCRM 3.0 does not allow the NONE option.
lstField.DataValueField = "NAME" ;
lstField.DataTextField = "DISPLAY_NAME";
lstField.DataSource = SplendidCache.List("record_type_display");
lstField.DataBind();
if ( rdr != null )
{
try
{
lstField.SelectedValue = Sql.ToString(rdr[sDATA_LABEL]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
}
}
}
TextBox txtNAME = new TextBox();
tdField.Controls.Add(txtNAME);
txtNAME.ID = sDISPLAY_FIELD;
txtNAME.ReadOnly = true;
txtNAME.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( bLayoutMode )
{
txtNAME.Text = sDISPLAY_FIELD;
txtNAME.Enabled = false ;
}
else if ( !Sql.IsEmptyString(sDISPLAY_FIELD) && rdr != null )
txtNAME.Text = Sql.ToString(rdr[sDISPLAY_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
txtNAME.Text = ex.Message;
}
HtmlInputHidden hidID = new HtmlInputHidden();
tdField.Controls.Add(hidID);
hidID.ID = sDATA_FIELD;
try
{
if ( !Sql.IsEmptyString(sDATA_FIELD) && rdr != null )
hidID.Value = Sql.ToString(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
txtNAME.Text = ex.Message;
}
Literal litNBSP = new Literal();
tdField.Controls.Add(litNBSP);
litNBSP.Text = " ";
HtmlInputButton btnChange = new HtmlInputButton("button");
tdField.Controls.Add(btnChange);
// 05/07/2006 Paul. Specify a name for the check button so that it can be referenced by SplendidTest.
btnChange.ID = sDATA_FIELD + "_btnChange";
btnChange.Attributes.Add("class", "button");
if ( !Sql.IsEmptyString(sONCLICK_SCRIPT) )
btnChange.Attributes.Add("onclick" , sONCLICK_SCRIPT);
btnChange.Attributes.Add("title" , L10n.Term(".LBL_CHANGE_BUTTON_TITLE"));
// 07/31/2006 Paul. Stop using VisualBasic library to increase compatibility with Mono.
btnChange.Attributes.Add("accessKey", L10n.Term(".LBL_CHANGE_BUTTON_KEY").Substring(0, 1));
btnChange.Value = L10n.Term(".LBL_CHANGE_BUTTON_LABEL");
if ( !bLayoutMode && bUI_REQUIRED && !Sql.IsEmptyString(sDATA_FIELD) )
{
RequiredFieldValidatorForHiddenInputs reqID = new RequiredFieldValidatorForHiddenInputs();
reqID.ID = sDATA_FIELD + "_REQUIRED";
reqID.ControlToValidate = hidID.ID;
reqID.ErrorMessage = L10n.Term(".ERR_REQUIRED_FIELD");
reqID.CssClass = "required";
reqID.EnableViewState = false;
// 01/16/2006 Paul. We don't enable required fields until we attempt to save.
// This is to allow unrelated form actions; the Cancel button is a good example.
reqID.EnableClientScript = false;
reqID.Enabled = false;
tdField.Controls.Add(reqID);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "TextBox", true) == 0 || String.Compare(sFIELD_TYPE, "Password", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
TextBox txtField = new TextBox();
tdField.Controls.Add(txtField);
txtField.ID = sDATA_FIELD;
txtField.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( nFORMAT_ROWS > 0 && nFORMAT_COLUMNS > 0 )
{
txtField.Rows = nFORMAT_ROWS ;
txtField.Columns = nFORMAT_COLUMNS;
txtField.TextMode = TextBoxMode.MultiLine;
}
else
{
txtField.MaxLength = nFORMAT_MAX_LENGTH ;
txtField.Attributes.Add("size", nFORMAT_SIZE.ToString());
txtField.TextMode = TextBoxMode.SingleLine;
}
if ( bLayoutMode )
{
txtField.Text = sDATA_FIELD;
txtField.ReadOnly = true ;
}
else if ( !Sql.IsEmptyString(sDATA_FIELD) && rdr != null )
{
int nOrdinal = rdr.GetOrdinal(sDATA_FIELD);
string sTypeName = rdr.GetDataTypeName(nOrdinal);
// 03/04/2006 Paul. Display currency in the proper format.
// Only SQL Server is likely to return the money type, so also include the decimal type.
if ( sTypeName == "money" || rdr[sDATA_FIELD].GetType() == typeof(System.Decimal) )
txtField.Text = Sql.ToDecimal(rdr[sDATA_FIELD]).ToString("#,##0.00");
else
txtField.Text = Sql.ToString(rdr[sDATA_FIELD]);
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
txtField.Text = ex.Message;
}
if ( String.Compare(sFIELD_TYPE, "Password", true) == 0 )
txtField.TextMode = TextBoxMode.Password;
if ( !bLayoutMode && bUI_REQUIRED && !Sql.IsEmptyString(sDATA_FIELD) )
{
RequiredFieldValidator reqNAME = new RequiredFieldValidator();
reqNAME.ID = sDATA_FIELD + "_REQUIRED";
reqNAME.ControlToValidate = txtField.ID;
reqNAME.ErrorMessage = L10n.Term(".ERR_REQUIRED_FIELD");
reqNAME.CssClass = "required";
reqNAME.EnableViewState = false;
// 01/16/2006 Paul. We don't enable required fields until we attempt to save.
// This is to allow unrelated form actions; the Cancel button is a good example.
reqNAME.EnableClientScript = false;
reqNAME.Enabled = false;
tdField.Controls.Add(reqNAME);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "DatePicker", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/03/2005 Paul. UserControls must be loaded.
DatePicker ctlDate = tbl.Page.LoadControl("~/_controls/DatePicker.ascx") as DatePicker;
tdField.Controls.Add(ctlDate);
ctlDate.ID = sDATA_FIELD;
// 05/10/2006 Paul. Set the tab index.
ctlDate.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( rdr != null )
ctlDate.Value = T10n.FromServerTime(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
// 01/16/2006 Paul. We validate elsewhere.
/*
if ( !bLayoutMode && bUI_REQUIRED && !Sql.IsEmptyString(sDATA_FIELD) )
{
ctlDate.Required = true;
}
*/
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "DateTimePicker", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/03/2005 Paul. UserControls must be loaded.
DateTimePicker ctlDate = tbl.Page.LoadControl("~/_controls/DateTimePicker.ascx") as DateTimePicker;
tdField.Controls.Add(ctlDate);
ctlDate.ID = sDATA_FIELD;
// 05/10/2006 Paul. Set the tab index.
ctlDate.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( rdr != null )
ctlDate.Value = T10n.FromServerTime(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "DateTimeEdit", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/03/2005 Paul. UserControls must be loaded.
DateTimeEdit ctlDate = tbl.Page.LoadControl("~/_controls/DateTimeEdit.ascx") as DateTimeEdit;
tdField.Controls.Add(ctlDate);
ctlDate.ID = sDATA_FIELD;
// 05/10/2006 Paul. Set the tab index.
ctlDate.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( rdr != null )
ctlDate.Value = T10n.FromServerTime(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
}
if ( !bLayoutMode && bUI_REQUIRED )
{
ctlDate.EnableNone = false;
}
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "File", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
HtmlInputFile ctlField = new HtmlInputFile();
tdField.Controls.Add(ctlField);
ctlField.ID = sDATA_FIELD;
ctlField.MaxLength = nFORMAT_MAX_LENGTH;
ctlField.Size = nFORMAT_SIZE;
ctlField.Attributes.Add("TabIndex", nFORMAT_TAB_INDEX.ToString());
if ( !bLayoutMode && bUI_REQUIRED )
{
RequiredFieldValidator reqNAME = new RequiredFieldValidator();
reqNAME.ID = sDATA_FIELD + "_REQUIRED";
reqNAME.ControlToValidate = ctlField.ID;
reqNAME.ErrorMessage = L10n.Term(".ERR_REQUIRED_FIELD");
reqNAME.CssClass = "required";
reqNAME.EnableViewState = false;
// 01/16/2006 Paul. We don't enable required fields until we attempt to save.
// This is to allow unrelated form actions; the Cancel button is a good example.
reqNAME.EnableClientScript = false;
reqNAME.Enabled = false;
tdField.Controls.Add(reqNAME);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "Image", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
HtmlInputHidden ctlHidden = new HtmlInputHidden();
if ( !bLayoutMode )
{
tdField.Controls.Add(ctlHidden);
ctlHidden.ID = sDATA_FIELD;
HtmlInputFile ctlField = new HtmlInputFile();
tdField.Controls.Add(ctlField);
// 04/17/2006 Paul. The image needs to reference the file control.
ctlField.ID = sDATA_FIELD + "_File";
Literal litBR = new Literal();
litBR.Text = "<br />";
tdField.Controls.Add(litBR);
}
Image imgField = new Image();
// 04/13/2006 Paul. Give the image a name so that it can be validated with SplendidTest.
imgField.ID = "img" + sDATA_FIELD;
try
{
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
else if ( rdr != null )
{
if ( !Sql.IsEmptyString(rdr[sDATA_FIELD]) )
{
ctlHidden.Value = Sql.ToString(rdr[sDATA_FIELD]);
imgField.ImageUrl = "~/Images/Image.aspx?ID=" + ctlHidden.Value;
// 04/13/2006 Paul. Only add the image if it exists.
tdField.Controls.Add(imgField);
// 04/17/2006 Paul. Provide a clear button.
Literal litClear = new Literal();
litClear.Text = "<br /><input type=\"button\" class=\"button\" onclick=\"form." + ctlHidden.ClientID + ".value='';form." + imgField.ClientID + ".src='';" + "\" value='" + " " + L10n.Term(".LBL_CLEAR_BUTTON_LABEL" ) + " " + "' title='" + L10n.Term(".LBL_CLEAR_BUTTON_TITLE" ) + "' />";
tdField.Controls.Add(litClear);
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex.Message);
Literal litField = new Literal();
litField.Text = ex.Message;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "AddressButtons", true) == 0 )
{
tr.Cells.Remove(tdField);
tdLabel.Width = "10%";
tdLabel.RowSpan = nROWSPAN;
tdLabel.VAlign = "middle";
tdLabel.Align = "center";
tdLabel.Attributes.Remove("class");
tdLabel.Attributes.Add("class", "tabFormAddDel");
HtmlInputButton btnCopyRight = new HtmlInputButton("button");
Literal litSpacer = new Literal();
HtmlInputButton btnCopyLeft = new HtmlInputButton("button");
tdLabel.Controls.Add(btnCopyRight);
tdLabel.Controls.Add(litSpacer );
tdLabel.Controls.Add(btnCopyLeft );
btnCopyRight.Attributes.Add("title" , L10n.Term("Accounts.NTC_COPY_BILLING_ADDRESS" ));
btnCopyRight.Attributes.Add("onclick", "return copyAddressRight()");
btnCopyRight.Value = ">>";
litSpacer.Text = "<br><br>";
btnCopyLeft .Attributes.Add("title" , L10n.Term("Accounts.NTC_COPY_SHIPPING_ADDRESS" ));
btnCopyLeft .Attributes.Add("onclick", "return copyAddressLeft()");
btnCopyLeft .Value = "<<";
nColIndex = 0;
}
else
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
litField.Text = "Unknown field type " + sFIELD_TYPE;
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), "Unknown field type " + sFIELD_TYPE);
}
if ( nCOLSPAN > 0 )
nColIndex = 0;
else if ( nCOLSPAN == 0 )
{
nColIndex++;
if ( nColIndex > 1 )
nColIndex = 0;
}
}
}
public static void AppendEditViewFields(DataView dvFields, HtmlTable tbl, IDataReader rdr, L10N L10n, TimeZone T10n, CommandEventHandler Page_Command, bool bLayoutMode)
{
bool bIsMobile = false;
SplendidPage Page = tbl.Page as SplendidPage;
if ( Page != null )
bIsMobile = Page.IsMobile;
HtmlTableRow tr = null;
// 11/28/2005 Paul. Start row index using the existing count so that headers can be specified.
int nRowIndex = tbl.Rows.Count - 1;
int nColIndex = 0;
HtmlTableCell tdLabel = null;
HtmlTableCell tdField = null;
// 01/07/2006 Paul. Show table borders in layout mode. This will help distinguish blank lines from wrapped lines.
if ( bLayoutMode )
tbl.Border = 1;
// 11/15/2007 Paul. If there are no fields in the detail view, then hide the entire table.
// This allows us to hide the table by removing all detail view fields.
if ( dvFields.Count == 0 && tbl.Rows.Count <= 1 )
tbl.Visible = false;
// 01/27/2008 Paul. We need the schema table to determine if the data label is free-form text.
DataTable tblSchema = null;
if ( rdr != null )
tblSchema = rdr.GetSchemaTable();
// 01/01/2008 Paul. Pull config flag outside the loop.
bool bEnableTeamManagement = Crm.Config.enable_team_management();
bool bRequireTeamManagement = Crm.Config.require_team_management();
// 01/01/2008 Paul. We need a quick way to require user assignments across the system.
bool bRequireUserAssignment = Crm.Config.require_user_assignment();
HttpSessionState Session = HttpContext.Current.Session;
foreach(DataRowView row in dvFields)
{
Guid gID = Sql.ToGuid (row["ID" ]);
int nFIELD_INDEX = Sql.ToInteger(row["FIELD_INDEX" ]);
string sFIELD_TYPE = Sql.ToString (row["FIELD_TYPE" ]);
string sDATA_LABEL = Sql.ToString (row["DATA_LABEL" ]);
string sDATA_FIELD = Sql.ToString (row["DATA_FIELD" ]);
string sDISPLAY_FIELD = Sql.ToString (row["DISPLAY_FIELD" ]);
string sCACHE_NAME = Sql.ToString (row["CACHE_NAME" ]);
bool bDATA_REQUIRED = Sql.ToBoolean(row["DATA_REQUIRED" ]);
bool bUI_REQUIRED = Sql.ToBoolean(row["UI_REQUIRED" ]);
string sONCLICK_SCRIPT = Sql.ToString (row["ONCLICK_SCRIPT" ]);
string sFORMAT_SCRIPT = Sql.ToString (row["FORMAT_SCRIPT" ]);
short nFORMAT_TAB_INDEX = Sql.ToShort (row["FORMAT_TAB_INDEX" ]);
int nFORMAT_MAX_LENGTH = Sql.ToInteger(row["FORMAT_MAX_LENGTH"]);
int nFORMAT_SIZE = Sql.ToInteger(row["FORMAT_SIZE" ]);
int nFORMAT_ROWS = Sql.ToInteger(row["FORMAT_ROWS" ]);
int nFORMAT_COLUMNS = Sql.ToInteger(row["FORMAT_COLUMNS" ]);
int nCOLSPAN = Sql.ToInteger(row["COLSPAN" ]);
int nROWSPAN = Sql.ToInteger(row["ROWSPAN" ]);
string sLABEL_WIDTH = Sql.ToString (row["LABEL_WIDTH" ]);
string sFIELD_WIDTH = Sql.ToString (row["FIELD_WIDTH" ]);
int nDATA_COLUMNS = Sql.ToInteger(row["DATA_COLUMNS" ]);
// 12/02/2007 Paul. Each view can now have its own number of data columns.
// This was needed so that search forms can have 4 data columns. The default is 2 columns.
if ( nDATA_COLUMNS == 0 )
nDATA_COLUMNS = 2;
// 11/25/2006 Paul. If Team Management has been disabled, then convert the field to a blank.
// Keep the field, but treat it as blank so that field indexes will still be valid.
// 12/03/2006 Paul. Allow the team field to be visible during layout.
if ( !bLayoutMode && sDATA_FIELD == "TEAM_ID" )
{
if ( !bEnableTeamManagement )
{
sFIELD_TYPE = "Blank";
bUI_REQUIRED = false;
}
else
{
// 11/25/2006 Paul. Override the required flag with the system value.
// 01/01/2008 Paul. If Team Management is not required, then let the admin decide.
if ( bRequireTeamManagement )
bUI_REQUIRED = true;
}
}
if ( !bLayoutMode && sDATA_FIELD == "ASSIGNED_USER_ID" )
{
// 01/01/2008 Paul. We need a quick way to require user assignments across the system.
if ( bRequireUserAssignment )
bUI_REQUIRED = true;
}
if ( bIsMobile && String.Compare(sFIELD_TYPE, "AddressButtons", true) == 0 )
{
// 11/17/2007 Paul. Skip the address buttons on a mobile device.
continue;
}
// 11/17/2007 Paul. On a mobile device, each new field is on a new row.
// 12/02/2005 Paul. COLSPAN == -1 means that a new column should not be created.
if ( (nCOLSPAN >= 0 && nColIndex == 0) || tr == null || bIsMobile )
{
// 11/25/2005 Paul. Don't pre-create a row as we don't want a blank
// row at the bottom. Add rows just before they are needed.
nRowIndex++;
tr = new HtmlTableRow();
tbl.Rows.Insert(nRowIndex, tr);
}
if ( bLayoutMode )
{
HtmlTableCell tdAction = new HtmlTableCell();
tr.Cells.Add(tdAction);
tdAction.Attributes.Add("class", "tabDetailViewDL");
tdAction.NoWrap = true;
Literal litIndex = new Literal();
tdAction.Controls.Add(litIndex);
litIndex.Text = " " + nFIELD_INDEX.ToString() + " ";
// 05/26/2007 Paul. Fix the terms. The are in the Dropdown module.
ImageButton btnMoveUp = CreateLayoutImageButton(gID, "Layout.MoveUp" , nFIELD_INDEX, L10n.Term("Dropdown.LNK_UP" ), Sql.ToString(Session["themeURL"]) + "images/uparrow_inline.gif" , Page_Command);
ImageButton btnMoveDown = CreateLayoutImageButton(gID, "Layout.MoveDown", nFIELD_INDEX, L10n.Term("Dropdown.LNK_DOWN" ), Sql.ToString(Session["themeURL"]) + "images/downarrow_inline.gif", Page_Command);
ImageButton btnInsert = CreateLayoutImageButton(gID, "Layout.Insert" , nFIELD_INDEX, L10n.Term("Dropdown.LNK_INS" ), Sql.ToString(Session["themeURL"]) + "images/plus_inline.gif" , Page_Command);
ImageButton btnEdit = CreateLayoutImageButton(gID, "Layout.Edit" , nFIELD_INDEX, L10n.Term("Dropdown.LNK_EDIT" ), Sql.ToString(Session["themeURL"]) + "images/edit_inline.gif" , Page_Command);
ImageButton btnDelete = CreateLayoutImageButton(gID, "Layout.Delete" , nFIELD_INDEX, L10n.Term("Dropdown.LNK_DELETE"), Sql.ToString(Session["themeURL"]) + "images/delete_inline.gif" , Page_Command);
tdAction.Controls.Add(btnMoveUp );
tdAction.Controls.Add(btnMoveDown);
tdAction.Controls.Add(btnInsert );
tdAction.Controls.Add(btnEdit );
tdAction.Controls.Add(btnDelete );
}
// 12/03/2006 Paul. Move literal label up so that it can be accessed when processing a blank.
Literal litLabel = new Literal();
if ( nCOLSPAN >= 0 || tdLabel == null || tdField == null )
{
tdLabel = new HtmlTableCell();
tdField = new HtmlTableCell();
tr.Cells.Add(tdLabel);
tr.Cells.Add(tdField);
if ( nCOLSPAN > 0 )
{
tdField.ColSpan = nCOLSPAN;
if ( bLayoutMode )
tdField.ColSpan++;
}
tdLabel.Attributes.Add("class", "dataLabel");
tdLabel.VAlign = "top";
tdLabel.Width = sLABEL_WIDTH;
tdField.Attributes.Add("class", "dataField");
tdField.VAlign = "top";
// 11/28/2005 Paul. Don't use the field width if COLSPAN is specified as we want it to take the rest of the table. The label width will be sufficient.
if ( nCOLSPAN == 0 )
tdField.Width = sFIELD_WIDTH;
tdLabel.Controls.Add(litLabel);
//litLabel.Text = nFIELD_INDEX.ToString() + " (" + nRowIndex.ToString() + "," + nColIndex.ToString() + ")";
try
{
// 12/03/2006 Paul. Move code to blank able in layout mode to blank section below.
if ( bLayoutMode )
litLabel.Text = sDATA_LABEL;
else if ( sDATA_LABEL.IndexOf(".") >= 0 )
litLabel.Text = L10n.Term(sDATA_LABEL);
else if ( !Sql.IsEmptyString(sDATA_LABEL) && rdr != null )
{
// 01/27/2008 Paul. If the data label is not in the schema table, then it must be free-form text.
// It is not used often, but we allow the label to come from the result set. For example,
// when the parent is stored in the record, we need to pull the module name from the record.
if ( tblSchema != null && tblSchema.Columns.Contains(sDATA_LABEL) )
litLabel.Text = Sql.ToString(rdr[sDATA_LABEL]) + L10n.Term("Calls.LBL_COLON");
else
litLabel.Text = sDATA_LABEL;
}
// 07/15/2006 Paul. Always put something for the label so that table borders will look right.
// 07/20/2007 Vandalo. Skip the requirement to create a terminology entry and just so the label.
else
litLabel.Text = sDATA_LABEL; // " ";
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
litLabel.Text = ex.Message;
}
if ( !bLayoutMode && bUI_REQUIRED )
{
Label lblRequired = new Label();
tdLabel.Controls.Add(lblRequired);
lblRequired.CssClass = "required";
lblRequired.Text = L10n.Term(".LBL_REQUIRED_SYMBOL");
}
}
if ( String.Compare(sFIELD_TYPE, "Blank", true) == 0 )
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
if ( bLayoutMode )
{
litLabel.Text = "*** BLANK ***";
litField.Text = "*** BLANK ***";
}
else
{
// 12/03/2006 Paul. Make sure to clear the label. This is necessary to convert a TEAM to blank when disabled.
litLabel.Text = " ";
litField.Text = " ";
}
}
else if ( String.Compare(sFIELD_TYPE, "Label", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
// 07/25/2006 Paul. Align label values to the middle so the line-up with the label.
tdField.VAlign = "middle";
// 07/24/2006 Paul. Set the ID so that the literal control can be accessed.
litField.ID = sDATA_FIELD;
try
{
if ( bLayoutMode )
litField.Text = sDATA_FIELD;
else if ( sDATA_FIELD.IndexOf(".") >= 0 )
litField.Text = L10n.Term(sDATA_FIELD);
else if ( rdr != null )
litField.Text = Sql.ToString(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
litField.Text = ex.Message;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "ListBox", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/02/2007 Paul. If format rows > 0 then this is a list box and not a drop down list.
ListControl lstField = null;
if ( nFORMAT_ROWS > 0 )
{
ListBox lb = new ListBox();
lb.SelectionMode = ListSelectionMode.Multiple;
lb.Rows = nFORMAT_ROWS;
lstField = lb;
}
else
{
lstField = new DropDownList();
}
tdField.Controls.Add(lstField);
lstField.ID = sDATA_FIELD;
lstField.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/04/2005 Paul. Don't populate list if this is a post back.
if ( !Sql.IsEmptyString(sCACHE_NAME) && (bLayoutMode || !tbl.Page.IsPostBack) )
{
// 12/24/2007 Paul. Use an array to define the custom caches so that list is in the Cache module.
// This should reduce the number of times that we have to edit the SplendidDynamic module.
bool bCustomCache = false;
SplendidCacheReference[] arrCustomCaches = SplendidCache.CustomCaches;
foreach ( SplendidCacheReference cache in arrCustomCaches )
{
if ( cache.Name == sCACHE_NAME )
{
lstField.DataValueField = cache.DataValueField;
lstField.DataTextField = cache.DataTextField ;
SplendidCacheCallback cbkDataSource = cache.DataSource;
lstField.DataSource = cbkDataSource();
bCustomCache = true;
}
}
if ( !bCustomCache )
{
lstField.DataValueField = "NAME" ;
lstField.DataTextField = "DISPLAY_NAME";
lstField.DataSource = SplendidCache.List(sCACHE_NAME);
}
lstField.DataBind();
// 08/08/2006 Paul. Allow onchange code to be stored in the database.
// ListBoxes do not have a useful onclick event, so there should be no problem overloading this field.
if ( !Sql.IsEmptyString(sONCLICK_SCRIPT) )
lstField.Attributes.Add("onchange" , sONCLICK_SCRIPT);
// 02/21/2006 Paul. Move the NONE item inside the !IsPostBack code.
// 12/02/2007 Paul. We don't need a NONE record when using multi-selection.
// 12/03/2007 Paul. We do want the NONE record when using multi-selection.
// This will allow searching of fields that are null instead of using the unassigned only checkbox.
if ( !bUI_REQUIRED )
{
lstField.Items.Insert(0, new ListItem(L10n.Term(".LBL_NONE"), ""));
// 12/02/2007 Paul. AppendEditViewFields should be called inside Page_Load when not a postback,
// and in InitializeComponent when it is a postback. If done wrong,
// the page will bind after the list is populated, causing the list to populate again.
// This event will cause the NONE entry to be cleared. Add a handler to catch this problem,
// but the real solution is to call AppendEditViewFields at the appropriate times based on the postback event.
lstField.DataBound += new EventHandler(ListControl_DataBound_AllowNull);
}
}
if ( rdr != null )
{
try
{
// 02/21/2006 Paul. All the DropDownLists in the Calls and Meetings edit views were not getting set.
// The problem was a Page.DataBind in the SchedulingGrid and in the InviteesView. Both binds needed to be removed.
// 12/30/2007 Paul. A customer needed the ability to save and restore the multiple selection.
// 12/30/2007 Paul. Require the XML declaration in the data before trying to treat as XML.
string sVALUE = Sql.ToString(rdr[sDATA_FIELD]);
if ( nFORMAT_ROWS > 0 && sVALUE.StartsWith("<?xml") )
{
XmlDocument xml = new XmlDocument();
xml.LoadXml(sVALUE);
XmlNodeList nlValues = xml.DocumentElement.SelectNodes("Value");
foreach ( XmlNode xValue in nlValues )
{
foreach ( ListItem item in lstField.Items )
{
if ( item.Value == xValue.InnerText )
item.Selected = true;
}
}
}
else
{
lstField.SelectedValue = sVALUE;
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
}
// 12/04/2005 Paul. Assigned To field will always default to the current user.
else if ( rdr == null && !tbl.Page.IsPostBack && sCACHE_NAME == "AssignedUser")
{
try
{
// 12/02/2007 Paul. We don't default the user when using multi-selection.
// This is because this mode is typically used for searching.
if ( nFORMAT_ROWS == 0 )
lstField.SelectedValue = Security.USER_ID.ToString();
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "CheckBox", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
CheckBox chkField = new CheckBox();
tdField.Controls.Add(chkField);
chkField.ID = sDATA_FIELD;
chkField.CssClass = "checkbox";
chkField.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( rdr != null )
chkField.Checked = Sql.ToBoolean(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
// 07/11/2007 Paul. A checkbox can have a click event.
if ( !Sql.IsEmptyString(sONCLICK_SCRIPT) )
chkField.Attributes.Add("onclick", sONCLICK_SCRIPT);
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
chkField.Enabled = false ;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "ChangeButton", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/04/2005 Paul. If the label is PARENT_TYPE, then change the label to a DropDownList.
if ( sDATA_LABEL == "PARENT_TYPE" )
{
tdLabel.Controls.Clear();
DropDownList lstField = new DropDownList();
tdLabel.Controls.Add(lstField);
lstField.ID = sDATA_LABEL;
lstField.TabIndex = nFORMAT_TAB_INDEX;
lstField.Attributes.Add("onChange", "ChangeParentType();");
if ( bLayoutMode || !tbl.Page.IsPostBack )
{
// 07/29/2005 Paul. SugarCRM 3.0 does not allow the NONE option.
lstField.DataValueField = "NAME" ;
lstField.DataTextField = "DISPLAY_NAME";
lstField.DataSource = SplendidCache.List("record_type_display");
lstField.DataBind();
if ( rdr != null )
{
try
{
lstField.SelectedValue = Sql.ToString(rdr[sDATA_LABEL]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
}
}
}
TextBox txtNAME = new TextBox();
tdField.Controls.Add(txtNAME);
txtNAME.ID = sDISPLAY_FIELD;
txtNAME.ReadOnly = true;
txtNAME.TabIndex = nFORMAT_TAB_INDEX;
// 11/25/2006 Paul. Turn off viewstate so that we can fix the text on postback.
txtNAME.EnableViewState = false;
try
{
if ( bLayoutMode )
{
txtNAME.Text = sDISPLAY_FIELD;
txtNAME.Enabled = false ;
}
// 11/25/2006 Paul. The Change text field is losing its value during a postback error.
else if ( tbl.Page.IsPostBack )
{
// 11/25/2006 Paul. In order for this posback fix to work, viewstate must be disabled for this field.
if ( tbl.Page.Request[txtNAME.UniqueID] != null )
txtNAME.Text = Sql.ToString(tbl.Page.Request[txtNAME.UniqueID]);
}
else if ( !Sql.IsEmptyString(sDISPLAY_FIELD) && rdr != null )
txtNAME.Text = Sql.ToString(rdr[sDISPLAY_FIELD]);
// 11/25/2006 Paul. The team name should always default to the current user's private team.
// Make sure not to overwrite the value if this is a postback.
else if ( sDATA_FIELD == "TEAM_ID" && rdr == null && !tbl.Page.IsPostBack )
txtNAME.Text = Security.TEAM_NAME;
// 01/15/2007 Paul. Assigned To field will always default to the current user.
else if ( sDATA_FIELD == "ASSIGNED_USER_ID" && rdr == null && !tbl.Page.IsPostBack )
txtNAME.Text = Security.USER_NAME;
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
txtNAME.Text = ex.Message;
}
HtmlInputHidden hidID = new HtmlInputHidden();
tdField.Controls.Add(hidID);
hidID.ID = sDATA_FIELD;
try
{
if ( !bLayoutMode )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) && rdr != null )
hidID.Value = Sql.ToString(rdr[sDATA_FIELD]);
// 11/25/2006 Paul. The team name should always default to the current user's private team.
// Make sure not to overwrite the value if this is a postback.
// The hidden field does not require the same viewstate fix as the txtNAME field.
else if ( sDATA_FIELD == "TEAM_ID" && rdr == null && !tbl.Page.IsPostBack )
hidID.Value = Security.TEAM_ID.ToString();
// 01/15/2007 Paul. Assigned To field will always default to the current user.
else if ( sDATA_FIELD == "ASSIGNED_USER_ID" && rdr == null && !tbl.Page.IsPostBack )
hidID.Value = Security.USER_ID.ToString();
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
txtNAME.Text = ex.Message;
}
Literal litNBSP = new Literal();
tdField.Controls.Add(litNBSP);
litNBSP.Text = " ";
HtmlInputButton btnChange = new HtmlInputButton("button");
tdField.Controls.Add(btnChange);
// 05/07/2006 Paul. Specify a name for the check button so that it can be referenced by SplendidTest.
btnChange.ID = sDATA_FIELD + "_btnChange";
btnChange.Attributes.Add("class", "button");
if ( !Sql.IsEmptyString(sONCLICK_SCRIPT) )
btnChange.Attributes.Add("onclick" , sONCLICK_SCRIPT);
// 03/31/2007 Paul. SugarCRM now uses Select instead of Change.
btnChange.Attributes.Add("title" , L10n.Term(".LBL_SELECT_BUTTON_TITLE"));
// 07/31/2006 Paul. Stop using VisualBasic library to increase compatibility with Mono.
// 03/31/2007 Paul. Stop using AccessKey for change button.
//btnChange.Attributes.Add("accessKey", L10n.Term(".LBL_SELECT_BUTTON_KEY").Substring(0, 1));
btnChange.Value = L10n.Term(".LBL_SELECT_BUTTON_LABEL");
// 12/03/2007 Paul. Also create a Clear button.
if ( sONCLICK_SCRIPT.IndexOf("Popup();") > 0 )
{
litNBSP = new Literal();
tdField.Controls.Add(litNBSP);
litNBSP.Text = " ";
HtmlInputButton btnClear = new HtmlInputButton("button");
tdField.Controls.Add(btnClear);
btnClear.ID = sDATA_FIELD + "_btnClear";
btnClear.Attributes.Add("class", "button");
btnClear.Attributes.Add("onclick" , sONCLICK_SCRIPT.Replace("Popup();", "('', '');").Replace("return ", "return Change"));
btnClear.Attributes.Add("title" , L10n.Term(".LBL_CLEAR_BUTTON_TITLE"));
btnClear.Value = L10n.Term(".LBL_CLEAR_BUTTON_LABEL");
}
if ( !bLayoutMode && bUI_REQUIRED && !Sql.IsEmptyString(sDATA_FIELD) )
{
RequiredFieldValidatorForHiddenInputs reqID = new RequiredFieldValidatorForHiddenInputs();
reqID.ID = sDATA_FIELD + "_REQUIRED";
reqID.ControlToValidate = hidID.ID;
reqID.ErrorMessage = L10n.Term(".ERR_REQUIRED_FIELD");
reqID.CssClass = "required";
reqID.EnableViewState = false;
// 01/16/2006 Paul. We don't enable required fields until we attempt to save.
// This is to allow unrelated form actions; the Cancel button is a good example.
reqID.EnableClientScript = false;
reqID.Enabled = false;
tdField.Controls.Add(reqID);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "TextBox", true) == 0 || String.Compare(sFIELD_TYPE, "Password", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
TextBox txtField = new TextBox();
tdField.Controls.Add(txtField);
txtField.ID = sDATA_FIELD;
txtField.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( nFORMAT_ROWS > 0 && nFORMAT_COLUMNS > 0 )
{
txtField.Rows = nFORMAT_ROWS ;
txtField.Columns = nFORMAT_COLUMNS;
txtField.TextMode = TextBoxMode.MultiLine;
}
else
{
txtField.MaxLength = nFORMAT_MAX_LENGTH ;
txtField.Attributes.Add("size", nFORMAT_SIZE.ToString());
txtField.TextMode = TextBoxMode.SingleLine;
}
if ( bLayoutMode )
{
txtField.Text = sDATA_FIELD;
txtField.ReadOnly = true ;
}
else if ( !Sql.IsEmptyString(sDATA_FIELD) && rdr != null )
{
int nOrdinal = rdr.GetOrdinal(sDATA_FIELD);
string sTypeName = rdr.GetDataTypeName(nOrdinal);
// 03/04/2006 Paul. Display currency in the proper format.
// Only SQL Server is likely to return the money type, so also include the decimal type.
if ( sTypeName == "money" || rdr[sDATA_FIELD].GetType() == typeof(System.Decimal) )
txtField.Text = Sql.ToDecimal(rdr[sDATA_FIELD]).ToString("#,##0.00");
else
txtField.Text = Sql.ToString(rdr[sDATA_FIELD]);
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
txtField.Text = ex.Message;
}
if ( String.Compare(sFIELD_TYPE, "Password", true) == 0 )
txtField.TextMode = TextBoxMode.Password;
if ( !bLayoutMode && bUI_REQUIRED && !Sql.IsEmptyString(sDATA_FIELD) )
{
RequiredFieldValidator reqNAME = new RequiredFieldValidator();
reqNAME.ID = sDATA_FIELD + "_REQUIRED";
reqNAME.ControlToValidate = txtField.ID;
reqNAME.ErrorMessage = L10n.Term(".ERR_REQUIRED_FIELD");
reqNAME.CssClass = "required";
reqNAME.EnableViewState = false;
// 01/16/2006 Paul. We don't enable required fields until we attempt to save.
// This is to allow unrelated form actions; the Cancel button is a good example.
reqNAME.EnableClientScript = false;
reqNAME.Enabled = false;
tdField.Controls.Add(reqNAME);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "DatePicker", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/03/2005 Paul. UserControls must be loaded.
DatePicker ctlDate = tbl.Page.LoadControl("~/_controls/DatePicker.ascx") as DatePicker;
tdField.Controls.Add(ctlDate);
ctlDate.ID = sDATA_FIELD;
// 05/10/2006 Paul. Set the tab index.
ctlDate.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( rdr != null )
ctlDate.Value = T10n.FromServerTime(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
// 01/16/2006 Paul. We validate elsewhere.
/*
if ( !bLayoutMode && bUI_REQUIRED && !Sql.IsEmptyString(sDATA_FIELD) )
{
ctlDate.Required = true;
}
*/
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "DateRange", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/17/2007 Paul. Use table to align before and after labels.
Table tblDateRange = new Table();
tdField.Controls.Add(tblDateRange);
TableRow trAfter = new TableRow();
TableRow trBefore = new TableRow();
tblDateRange.Rows.Add(trAfter);
tblDateRange.Rows.Add(trBefore);
TableCell tdAfterLabel = new TableCell();
TableCell tdAfterData = new TableCell();
TableCell tdBeforeLabel = new TableCell();
TableCell tdBeforeData = new TableCell();
trAfter .Cells.Add(tdAfterLabel );
trAfter .Cells.Add(tdAfterData );
trBefore.Cells.Add(tdBeforeLabel);
trBefore.Cells.Add(tdBeforeData );
// 12/03/2005 Paul. UserControls must be loaded.
DatePicker ctlDateStart = tbl.Page.LoadControl("~/_controls/DatePicker.ascx") as DatePicker;
DatePicker ctlDateEnd = tbl.Page.LoadControl("~/_controls/DatePicker.ascx") as DatePicker;
Literal litAfterLabel = new Literal();
Literal litBeforeLabel = new Literal();
litAfterLabel .Text = L10n.Term("SavedSearch.LBL_SEARCH_AFTER" );
litBeforeLabel.Text = L10n.Term("SavedSearch.LBL_SEARCH_BEFORE");
//tdField.Controls.Add(litAfterLabel );
//tdField.Controls.Add(ctlDateStart );
//tdField.Controls.Add(litBeforeLabel);
//tdField.Controls.Add(ctlDateEnd );
tdAfterLabel .Controls.Add(litAfterLabel );
tdAfterData .Controls.Add(ctlDateStart );
tdBeforeLabel.Controls.Add(litBeforeLabel);
tdBeforeData .Controls.Add(ctlDateEnd );
ctlDateStart.ID = sDATA_FIELD + "_AFTER";
ctlDateEnd .ID = sDATA_FIELD + "_BEFORE";
// 05/10/2006 Paul. Set the tab index.
ctlDateStart.TabIndex = nFORMAT_TAB_INDEX;
ctlDateEnd .TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( rdr != null )
{
ctlDateStart.Value = T10n.FromServerTime(rdr[sDATA_FIELD]);
ctlDateEnd .Value = T10n.FromServerTime(rdr[sDATA_FIELD]);
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
// 01/16/2006 Paul. We validate elsewhere.
/*
if ( !bLayoutMode && bUI_REQUIRED && !Sql.IsEmptyString(sDATA_FIELD) )
{
ctlDateStart.Required = true;
ctlDateEnd .Required = true;
}
*/
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "DateTimePicker", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/03/2005 Paul. UserControls must be loaded.
DateTimePicker ctlDate = tbl.Page.LoadControl("~/_controls/DateTimePicker.ascx") as DateTimePicker;
tdField.Controls.Add(ctlDate);
ctlDate.ID = sDATA_FIELD;
// 05/10/2006 Paul. Set the tab index.
ctlDate.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( rdr != null )
ctlDate.Value = T10n.FromServerTime(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "DateTimeEdit", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/03/2005 Paul. UserControls must be loaded.
DateTimeEdit ctlDate = tbl.Page.LoadControl("~/_controls/DateTimeEdit.ascx") as DateTimeEdit;
tdField.Controls.Add(ctlDate);
ctlDate.ID = sDATA_FIELD;
// 05/10/2006 Paul. Set the tab index.
ctlDate.TabIndex = nFORMAT_TAB_INDEX;
try
{
if ( rdr != null )
ctlDate.Value = T10n.FromServerTime(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
if ( !bLayoutMode && bUI_REQUIRED )
{
ctlDate.EnableNone = false;
}
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "File", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
HtmlInputFile ctlField = new HtmlInputFile();
tdField.Controls.Add(ctlField);
ctlField.ID = sDATA_FIELD;
ctlField.MaxLength = nFORMAT_MAX_LENGTH;
ctlField.Size = nFORMAT_SIZE;
ctlField.Attributes.Add("TabIndex", nFORMAT_TAB_INDEX.ToString());
if ( !bLayoutMode && bUI_REQUIRED )
{
RequiredFieldValidator reqNAME = new RequiredFieldValidator();
reqNAME.ID = sDATA_FIELD + "_REQUIRED";
reqNAME.ControlToValidate = ctlField.ID;
reqNAME.ErrorMessage = L10n.Term(".ERR_REQUIRED_FIELD");
reqNAME.CssClass = "required";
reqNAME.EnableViewState = false;
// 01/16/2006 Paul. We don't enable required fields until we attempt to save.
// This is to allow unrelated form actions; the Cancel button is a good example.
reqNAME.EnableClientScript = false;
reqNAME.Enabled = false;
tdField.Controls.Add(reqNAME);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "Image", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
HtmlInputHidden ctlHidden = new HtmlInputHidden();
if ( !bLayoutMode )
{
tdField.Controls.Add(ctlHidden);
ctlHidden.ID = sDATA_FIELD;
HtmlInputFile ctlField = new HtmlInputFile();
tdField.Controls.Add(ctlField);
// 04/17/2006 Paul. The image needs to reference the file control.
ctlField.ID = sDATA_FIELD + "_File";
Literal litBR = new Literal();
litBR.Text = "<br />";
tdField.Controls.Add(litBR);
}
Image imgField = new Image();
// 04/13/2006 Paul. Give the image a name so that it can be validated with SplendidTest.
imgField.ID = "img" + sDATA_FIELD;
try
{
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
else if ( rdr != null )
{
if ( !Sql.IsEmptyString(rdr[sDATA_FIELD]) )
{
ctlHidden.Value = Sql.ToString(rdr[sDATA_FIELD]);
imgField.ImageUrl = "~/Images/Image.aspx?ID=" + ctlHidden.Value;
// 04/13/2006 Paul. Only add the image if it exists.
tdField.Controls.Add(imgField);
// 04/17/2006 Paul. Provide a clear button.
Literal litClear = new Literal();
litClear.Text = "<br /><input type=\"button\" class=\"button\" onclick=\"form." + ctlHidden.ClientID + ".value='';form." + imgField.ClientID + ".src='';" + "\" value='" + " " + L10n.Term(".LBL_CLEAR_BUTTON_LABEL" ) + " " + "' title='" + L10n.Term(".LBL_CLEAR_BUTTON_TITLE" ) + "' />";
tdField.Controls.Add(litClear);
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
Literal litField = new Literal();
litField.Text = ex.Message;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "AddressButtons", true) == 0 )
{
tr.Cells.Remove(tdField);
tdLabel.Width = "10%";
tdLabel.RowSpan = nROWSPAN;
tdLabel.VAlign = "middle";
tdLabel.Align = "center";
tdLabel.Attributes.Remove("class");
tdLabel.Attributes.Add("class", "tabFormAddDel");
HtmlInputButton btnCopyRight = new HtmlInputButton("button");
Literal litSpacer = new Literal();
HtmlInputButton btnCopyLeft = new HtmlInputButton("button");
tdLabel.Controls.Add(btnCopyRight);
tdLabel.Controls.Add(litSpacer );
tdLabel.Controls.Add(btnCopyLeft );
btnCopyRight.Attributes.Add("title" , L10n.Term("Accounts.NTC_COPY_BILLING_ADDRESS" ));
btnCopyRight.Attributes.Add("onclick", "return copyAddressRight()");
btnCopyRight.Value = ">>";
litSpacer.Text = "<br><br>";
btnCopyLeft .Attributes.Add("title" , L10n.Term("Accounts.NTC_COPY_SHIPPING_ADDRESS" ));
btnCopyLeft .Attributes.Add("onclick", "return copyAddressLeft()");
btnCopyLeft .Value = "<<";
nColIndex = 0;
}
else
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
litField.Text = "Unknown field type " + sFIELD_TYPE;
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), "Unknown field type " + sFIELD_TYPE);
}
// 12/02/2007 Paul. Each view can now have its own number of data columns.
// This was needed so that search forms can have 4 data columns. The default is 2 columns.
if ( nCOLSPAN > 0 )
nColIndex += nCOLSPAN;
else if ( nCOLSPAN == 0 )
nColIndex++;
if ( nColIndex >= nDATA_COLUMNS )
nColIndex = 0;
}
}
public static void AppendDetailViewFields(DataView dvFields, HtmlTable tbl, IDataReader rdr, L10N L10n, TimeZone T10n, CommandEventHandler Page_Command, bool bLayoutMode)
{
bool bIsMobile = false;
SplendidPage Page = tbl.Page as SplendidPage;
if ( Page != null )
bIsMobile = Page.IsMobile;
HtmlTableRow tr = null;
// 11/28/2005 Paul. Start row index using the existing count so that headers can be specified.
int nRowIndex = tbl.Rows.Count - 1;
int nColIndex = 0;
// 01/07/2006 Paul. Show table borders in layout mode. This will help distinguish blank lines from wrapped lines.
if ( bLayoutMode )
tbl.Border = 1;
// 03/30/2007 Paul. Convert the currency values before displaying.
// The UI culture should already be set to format the currency.
Currency C10n = HttpContext.Current.Items["C10n"] as Currency;
HttpSessionState Session = HttpContext.Current.Session;
// 11/15/2007 Paul. If there are no fields in the detail view, then hide the entire table.
// This allows us to hide the table by removing all detail view fields.
if ( dvFields.Count == 0 && tbl.Rows.Count <= 1 )
tbl.Visible = false;
// 01/27/2008 Paul. We need the schema table to determine if the data label is free-form text.
DataTable tblSchema = null;
if ( rdr != null )
tblSchema = rdr.GetSchemaTable();
// 01/01/2008 Paul. Pull config flag outside the loop.
bool bEnableTeamManagement = Crm.Config.enable_team_management();
foreach(DataRowView row in dvFields)
{
Guid gID = Sql.ToGuid (row["ID" ]);
int nFIELD_INDEX = Sql.ToInteger(row["FIELD_INDEX"]);
string sFIELD_TYPE = Sql.ToString (row["FIELD_TYPE" ]);
string sDATA_LABEL = Sql.ToString (row["DATA_LABEL" ]);
string sDATA_FIELD = Sql.ToString (row["DATA_FIELD" ]);
string sDATA_FORMAT = Sql.ToString (row["DATA_FORMAT"]);
string sLIST_NAME = Sql.ToString (row["LIST_NAME" ]);
int nCOLSPAN = Sql.ToInteger(row["COLSPAN" ]);
string sLABEL_WIDTH = Sql.ToString (row["LABEL_WIDTH"]);
string sFIELD_WIDTH = Sql.ToString (row["FIELD_WIDTH"]);
int nDATA_COLUMNS= Sql.ToInteger(row["DATA_COLUMNS"]);
// 12/02/2007 Paul. Each view can now have its own number of data columns.
// This was needed so that search forms can have 4 data columns. The default is 2 columns.
if ( nDATA_COLUMNS == 0 )
nDATA_COLUMNS = 2;
// 11/25/2006 Paul. If Team Management has been disabled, then convert the field to a blank.
// Keep the field, but treat it as blank so that field indexes will still be valid.
// 12/03/2006 Paul. Allow the team field to be visible during layout.
// 12/03/2006 Paul. The correct field is TEAM_NAME. We don't use TEAM_ID in the detail view.
if ( !bLayoutMode && sDATA_FIELD == "TEAM_NAME" && !bEnableTeamManagement )
{
sFIELD_TYPE = "Blank";
}
// 11/17/2007 Paul. On a mobile device, each new field is on a new row.
if ( nColIndex == 0 || bIsMobile )
{
// 11/25/2005 Paul. Don't pre-create a row as we don't want a blank
// row at the bottom. Add rows just before they are needed.
nRowIndex++;
tr = new HtmlTableRow();
tbl.Rows.Insert(nRowIndex, tr);
}
if ( bLayoutMode )
{
HtmlTableCell tdAction = new HtmlTableCell();
tr.Cells.Add(tdAction);
tdAction.Attributes.Add("class", "tabDetailViewDL");
tdAction.NoWrap = true;
Literal litIndex = new Literal();
tdAction.Controls.Add(litIndex);
litIndex.Text = " " + nFIELD_INDEX.ToString() + " ";
// 05/26/2007 Paul. Fix the terms. The are in the Dropdown module.
ImageButton btnMoveUp = CreateLayoutImageButton(gID, "Layout.MoveUp" , nFIELD_INDEX, L10n.Term("Dropdown.LNK_UP" ), Sql.ToString(Session["themeURL"]) + "images/uparrow_inline.gif" , Page_Command);
ImageButton btnMoveDown = CreateLayoutImageButton(gID, "Layout.MoveDown", nFIELD_INDEX, L10n.Term("Dropdown.LNK_DOWN" ), Sql.ToString(Session["themeURL"]) + "images/downarrow_inline.gif", Page_Command);
ImageButton btnInsert = CreateLayoutImageButton(gID, "Layout.Insert" , nFIELD_INDEX, L10n.Term("Dropdown.LNK_INS" ), Sql.ToString(Session["themeURL"]) + "images/plus_inline.gif" , Page_Command);
ImageButton btnEdit = CreateLayoutImageButton(gID, "Layout.Edit" , nFIELD_INDEX, L10n.Term("Dropdown.LNK_EDIT" ), Sql.ToString(Session["themeURL"]) + "images/edit_inline.gif" , Page_Command);
ImageButton btnDelete = CreateLayoutImageButton(gID, "Layout.Delete" , nFIELD_INDEX, L10n.Term("Dropdown.LNK_DELETE"), Sql.ToString(Session["themeURL"]) + "images/delete_inline.gif" , Page_Command);
tdAction.Controls.Add(btnMoveUp );
tdAction.Controls.Add(btnMoveDown);
tdAction.Controls.Add(btnInsert );
tdAction.Controls.Add(btnEdit );
tdAction.Controls.Add(btnDelete );
}
HtmlTableCell tdLabel = new HtmlTableCell();
HtmlTableCell tdField = new HtmlTableCell();
tr.Cells.Add(tdLabel);
tr.Cells.Add(tdField);
if ( nCOLSPAN > 0 )
{
tdField.ColSpan = nCOLSPAN;
if ( bLayoutMode )
tdField.ColSpan++;
}
tdLabel.Attributes.Add("class", "tabDetailViewDL");
tdLabel.VAlign = "top";
tdLabel.Width = sLABEL_WIDTH;
tdField.Attributes.Add("class", "tabDetailViewDF");
tdField.VAlign = "top";
// 11/28/2005 Paul. Don't use the field width if COLSPAN is specified as we want it to take the rest of the table. The label width will be sufficient.
if ( nCOLSPAN == 0 )
tdField.Width = sFIELD_WIDTH;
Literal litLabel = new Literal();
HyperLink lnkField = null;
tdLabel.Controls.Add(litLabel);
//litLabel.Text = nFIELD_INDEX.ToString() + " (" + nRowIndex.ToString() + "," + nColIndex.ToString() + ")";
try
{
if ( bLayoutMode )
litLabel.Text = sDATA_LABEL;
else if ( sDATA_LABEL.IndexOf(".") >= 0 )
litLabel.Text = L10n.Term(sDATA_LABEL);
else if ( !Sql.IsEmptyString(sDATA_LABEL) && rdr != null )
{
// 01/27/2008 Paul. If the data label is not in the schema table, then it must be free-form text.
// It is not used often, but we allow the label to come from the result set. For example,
// when the parent is stored in the record, we need to pull the module name from the record.
if ( tblSchema != null && tblSchema.Columns.Contains(sDATA_LABEL) )
litLabel.Text = Sql.ToString(rdr[sDATA_LABEL]) + L10n.Term("Calls.LBL_COLON");
else
litLabel.Text = sDATA_LABEL;
}
// 07/15/2006 Paul. Always put something for the label so that table borders will look right.
else
litLabel.Text = " ";
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
litLabel.Text = ex.Message;
}
if ( String.Compare(sFIELD_TYPE, "Blank", true) == 0 )
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
if ( bLayoutMode )
{
litLabel.Text = "*** BLANK ***";
litField.Text = "*** BLANK ***";
}
else
{
// 12/03/2006 Paul. Make sure to clear the label. This is necessary to convert a TEAM to blank when disabled.
litLabel.Text = " ";
litField.Text = " ";
}
}
else if ( String.Compare(sFIELD_TYPE, "Line", true) == 0 )
{
if ( bLayoutMode )
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
litLabel.Text = "*** LINE ***";
litField.Text = "*** LINE ***";
}
else
{
tr.Cells.Clear();
}
}
else if ( String.Compare(sFIELD_TYPE, "String", true) == 0 )
{
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
else if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/06/2005 Paul. Wrap all string fields in a SPAN tag to simplify regression testing.
HtmlGenericControl spnField = new HtmlGenericControl("span");
tdField.Controls.Add(spnField);
spnField.ID = sDATA_FIELD;
Literal litField = new Literal();
spnField.Controls.Add(litField);
try
{
string[] arrLIST_NAME = sLIST_NAME .Split(' ');
string[] arrDATA_FIELD = sDATA_FIELD.Split(' ');
object[] objDATA_FIELD = new object[arrDATA_FIELD.Length];
for ( int i=0 ; i < arrDATA_FIELD.Length; i++ )
{
if ( arrDATA_FIELD[i].IndexOf(".") >= 0 )
{
objDATA_FIELD[i] = L10n.Term(arrDATA_FIELD[i]);
}
else if ( !Sql.IsEmptyString(sLIST_NAME) )
{
if ( arrLIST_NAME.Length == arrDATA_FIELD.Length )
{
if ( rdr != null )
{
// 01/18/2007 Paul. If AssignedUser list, then use the cached value to find the value.
if ( sLIST_NAME == "AssignedUser" )
{
objDATA_FIELD[i] = SplendidCache.AssignedUser(Sql.ToGuid(rdr[arrDATA_FIELD[i]]));
}
else
{
objDATA_FIELD[i] = L10n.Term("." + arrLIST_NAME[i] + ".", rdr[arrDATA_FIELD[i]]);
}
}
else
objDATA_FIELD[i] = String.Empty;
}
}
else if ( !Sql.IsEmptyString(arrDATA_FIELD[i]) )
{
if ( rdr != null && rdr[arrDATA_FIELD[i]] != DBNull.Value)
{
// 12/05/2005 Paul. If the data is a DateTime field, then make sure to perform the timezone conversion.
if ( rdr[arrDATA_FIELD[i]].GetType() == Type.GetType("System.DateTime") )
objDATA_FIELD[i] = T10n.FromServerTime(rdr[arrDATA_FIELD[i]]);
else
objDATA_FIELD[i] = rdr[arrDATA_FIELD[i]];
}
else
objDATA_FIELD[i] = String.Empty;
}
}
if ( rdr != null )
{
// 01/09/2006 Paul. Allow DATA_FORMAT to be optional. If missing, write data directly.
if ( sDATA_FORMAT == String.Empty )
{
for ( int i=0; i < arrDATA_FIELD.Length; i++ )
arrDATA_FIELD[i] = Sql.ToString(objDATA_FIELD[i]);
litField.Text = String.Join(" ", arrDATA_FIELD);
}
else if ( sDATA_FORMAT == "{0:c}" && C10n != null )
{
// 03/30/2007 Paul. Convert DetailView currencies on the fly.
// 05/05/2007 Paul. In an earlier step, we convert NULLs to empty strings.
// Attempts to convert to decimal will generate an error: Input string was not in a correct format.
if ( !(objDATA_FIELD[0] is string) )
{
Decimal d = C10n.ToCurrency(Convert.ToDecimal(objDATA_FIELD[0]));
litField.Text = d.ToString("c");
}
}
else
litField.Text = String.Format(sDATA_FORMAT, objDATA_FIELD);
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
litField.Text = ex.Message;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "CheckBox", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
CheckBox chkField = new CheckBox();
tdField.Controls.Add(chkField);
chkField.Enabled = false ;
chkField.CssClass = "checkbox";
// 03/16/2006 Paul. Give the checkbox a name so that it can be validated with SplendidTest.
chkField.ID = sDATA_FIELD;
try
{
if ( rdr != null )
chkField.Checked = Sql.ToBoolean(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "Button", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
Button btnField = new Button();
tdField.Controls.Add(btnField);
btnField.CssClass = "button";
// 03/16/2006 Paul. Give the button a name so that it can be validated with SplendidTest.
btnField.ID = sDATA_FIELD;
if ( Page_Command != null )
{
btnField.Command += Page_Command;
btnField.CommandName = sDATA_FORMAT ;
}
try
{
if ( bLayoutMode )
{
btnField.Text = sDATA_FIELD;
btnField.Enabled = false ;
}
else if ( sDATA_FIELD.IndexOf(".") >= 0 )
{
btnField.Text = L10n.Term(sDATA_FIELD);
}
else if ( !Sql.IsEmptyString(sDATA_FIELD) && rdr != null )
{
btnField.Text = Sql.ToString(rdr[sDATA_FIELD]);
}
btnField.Attributes.Add("title", btnField.Text);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
btnField.Text = ex.Message;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "Textbox", true) == 0 )
{
/*
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
TextBox txtField = new TextBox();
tdField.Controls.Add(txtField);
txtField.ReadOnly = true;
txtField.TextMode = TextBoxMode.MultiLine;
// 03/16/2006 Paul. Give the textbox a name so that it can be validated with SplendidTest.
txtField.ID = sDATA_FIELD;
try
{
string[] arrDATA_FORMAT = sDATA_FORMAT.Split(',');
if ( arrDATA_FORMAT.Length == 2 )
{
txtField.Rows = Sql.ToInteger(arrDATA_FORMAT[0]);
txtField.Columns = Sql.ToInteger(arrDATA_FORMAT[1]);
}
if ( bLayoutMode )
{
txtField.Text = sDATA_FIELD;
}
else if ( !Sql.IsEmptyString(sDATA_FIELD) && rdr != null )
{
txtField.Text = Sql.ToString(rdr[sDATA_FIELD]);
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
txtField.Text = ex.Message;
}
}
*/
// 07/07/2007 Paul. Instead of using a real textbox, just replace new lines with <br />.
// This will perserve a majority of the HTML formating if it exists.
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
else if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/06/2005 Paul. Wrap all string fields in a SPAN tag to simplify regression testing.
HtmlGenericControl spnField = new HtmlGenericControl("span");
tdField.Controls.Add(spnField);
spnField.ID = sDATA_FIELD;
Literal litField = new Literal();
spnField.Controls.Add(litField);
try
{
if ( rdr != null )
{
string sDATA = Sql.ToString(rdr[sDATA_FIELD]);
// 07/07/2007 Paul. Emails may not have the proper \r\n terminators, so perform a few extra steps to ensure clean data.
sDATA = sDATA.Replace("\r\n", "\n");
sDATA = sDATA.Replace("\r" , "\n");
sDATA = sDATA.Replace("\n" , "<br />\r\n");
litField.Text = sDATA;
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
litField.Text = ex.Message;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "HyperLink", true) == 0 )
{
string sURL_FIELD = Sql.ToString (row["URL_FIELD"]);
if ( !Sql.IsEmptyString(sDATA_FIELD) && !Sql.IsEmptyString(sURL_FIELD) )
{
string sURL_FORMAT = Sql.ToString (row["URL_FORMAT"]);
string sURL_TARGET = Sql.ToString (row["URL_TARGET"]);
lnkField = new HyperLink();
tdField.Controls.Add(lnkField);
lnkField.Target = sURL_TARGET;
lnkField.CssClass = "tabDetailViewDFLink";
// 03/16/2006 Paul. Give the hyperlink a name so that it can be validated with SplendidTest.
lnkField.ID = sDATA_FIELD;
try
{
if ( bLayoutMode )
{
lnkField.Text = sDATA_FIELD;
lnkField.Enabled = false ;
}
else if ( rdr != null )
{
if ( !Sql.IsEmptyString(rdr[sDATA_FIELD]) )
{
// 01/09/2006 Paul. Allow DATA_FORMAT to be optional. If missing, write data directly.
if ( sDATA_FORMAT == String.Empty )
lnkField.Text = Sql.ToString(rdr[sDATA_FIELD]);
else
lnkField.Text = String.Format(sDATA_FORMAT, Sql.ToString(rdr[sDATA_FIELD]));
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
lnkField.Text = ex.Message;
}
try
{
if ( bLayoutMode )
{
lnkField.NavigateUrl = sURL_FIELD;
}
else if ( rdr != null )
{
if ( !Sql.IsEmptyString(rdr[sURL_FIELD]) )
{
// 01/09/2006 Paul. Allow DATA_FORMAT to be optional. If missing, write data directly.
if ( sDATA_FORMAT == String.Empty )
lnkField.NavigateUrl = Sql.ToString(rdr[sURL_FIELD]);
else
lnkField.NavigateUrl = String.Format(sURL_FORMAT, Sql.ToString(rdr[sURL_FIELD]));
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
lnkField.NavigateUrl = ex.Message;
}
}
}
else if ( String.Compare(sFIELD_TYPE, "Image", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
Image imgField = new Image();
// 04/13/2006 Paul. Give the image a name so that it can be validated with SplendidTest.
imgField.ID = sDATA_FIELD;
try
{
if ( bLayoutMode )
{
Literal litField = new Literal();
litField.Text = sDATA_FIELD;
tdField.Controls.Add(litField);
}
else if ( rdr != null )
{
if ( !Sql.IsEmptyString(rdr[sDATA_FIELD]) )
{
imgField.ImageUrl = "~/Images/Image.aspx?ID=" + Sql.ToString(rdr[sDATA_FIELD]);
// 04/13/2006 Paul. Only add the image if it exists.
tdField.Controls.Add(imgField);
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
lnkField.Text = ex.Message;
}
}
}
else
{
Literal litField = new Literal();
tdField.Controls.Add(litField);
litField.Text = "Unknown field type " + sFIELD_TYPE;
// 01/07/2006 Paul. Don't report the error in layout mode.
if ( !bLayoutMode )
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), "Unknown field type " + sFIELD_TYPE);
}
// 12/02/2007 Paul. Each view can now have its own number of data columns.
// This was needed so that search forms can have 4 data columns. The default is 2 columns.
if ( nCOLSPAN > 0 )
nColIndex += nCOLSPAN;
else if ( nCOLSPAN == 0 )
nColIndex++;
if ( nColIndex >= nDATA_COLUMNS )
nColIndex = 0;
}
}
// 05/26/2007 Paul. We need a way set the fields without creating the controls.
public static void SetEditViewFields(System.Web.UI.UserControl Parent, string sEDIT_NAME, IDataReader rdr, L10N L10n, TimeZone T10n)
{
// 01/01/2008 Paul. Pull config flag outside the loop.
bool bEnableTeamManagement = Crm.Config.enable_team_management();
DataTable dtFields = SplendidCache.EditViewFields(sEDIT_NAME);
DataView dvFields = dtFields.DefaultView;
foreach(DataRowView row in dvFields)
{
string sFIELD_TYPE = Sql.ToString (row["FIELD_TYPE" ]);
string sDATA_LABEL = Sql.ToString (row["DATA_LABEL" ]);
string sDATA_FIELD = Sql.ToString (row["DATA_FIELD" ]);
string sDISPLAY_FIELD = Sql.ToString (row["DISPLAY_FIELD" ]);
int nFORMAT_ROWS = Sql.ToInteger(row["FORMAT_ROWS" ]);
if ( sDATA_FIELD == "TEAM_ID" )
{
if ( !bEnableTeamManagement )
{
sFIELD_TYPE = "Blank";
}
}
if ( String.Compare(sFIELD_TYPE, "Blank", true) == 0 )
{
}
else if ( String.Compare(sFIELD_TYPE, "Label", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
Literal litField = Parent.FindControl(sDATA_FIELD) as Literal;
if ( litField != null )
{
try
{
if ( sDATA_FIELD.IndexOf(".") >= 0 )
litField.Text = L10n.Term(sDATA_FIELD);
else
litField.Text = Sql.ToString(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
litField.Text = ex.Message;
}
}
}
}
else if ( String.Compare(sFIELD_TYPE, "ListBox", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
try
{
if ( nFORMAT_ROWS > 0 )
{
// 12/02/2007 Paul. If format rows > 0 then this is a list box and not a drop down list.
ListBox lstField = Parent.FindControl(sDATA_FIELD) as ListBox;
if ( lstField != null )
{
lstField.SelectedValue = Sql.ToString(rdr[sDATA_FIELD]);
}
}
else
{
DropDownList lstField = Parent.FindControl(sDATA_FIELD) as DropDownList;
if ( lstField != null )
{
lstField.SelectedValue = Sql.ToString(rdr[sDATA_FIELD]);
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "CheckBox", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
try
{
CheckBox chkField = Parent.FindControl(sDATA_FIELD) as CheckBox;
if ( chkField != null )
chkField.Checked = Sql.ToBoolean(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "ChangeButton", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
// 12/04/2005 Paul. If the label is PARENT_TYPE, then change the label to a DropDownList.
if ( sDATA_LABEL == "PARENT_TYPE" )
{
DropDownList lstField = Parent.FindControl(sDATA_LABEL) as DropDownList;
if ( lstField != null )
{
try
{
lstField.SelectedValue = Sql.ToString(rdr[sDATA_LABEL]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
}
}
TextBox txtNAME = Parent.FindControl(sDISPLAY_FIELD) as TextBox;
if ( txtNAME != null )
{
try
{
if ( !Sql.IsEmptyString(sDISPLAY_FIELD) )
txtNAME.Text = Sql.ToString(rdr[sDISPLAY_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
txtNAME.Text = ex.Message;
}
HtmlInputHidden hidID = Parent.FindControl(sDATA_FIELD) as HtmlInputHidden;
if ( hidID != null )
{
try
{
hidID.Value = Sql.ToString(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
txtNAME.Text = ex.Message;
}
}
}
}
}
else if ( String.Compare(sFIELD_TYPE, "TextBox", true) == 0 || String.Compare(sFIELD_TYPE, "Password", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
TextBox txtField = Parent.FindControl(sDATA_FIELD) as TextBox;
if ( txtField != null )
{
try
{
int nOrdinal = rdr.GetOrdinal(sDATA_FIELD);
string sTypeName = rdr.GetDataTypeName(nOrdinal);
if ( sTypeName == "money" || rdr[sDATA_FIELD].GetType() == typeof(System.Decimal) )
txtField.Text = Sql.ToDecimal(rdr[sDATA_FIELD]).ToString("#,##0.00");
else
txtField.Text = Sql.ToString(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
txtField.Text = ex.Message;
}
}
}
}
else if ( String.Compare(sFIELD_TYPE, "DatePicker", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
try
{
DatePicker ctlDate = Parent.FindControl(sDATA_FIELD) as DatePicker;
if ( ctlDate != null )
ctlDate.Value = T10n.FromServerTime(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "DateTimePicker", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
try
{
DateTimePicker ctlDate = Parent.FindControl(sDATA_FIELD) as DateTimePicker;
if ( ctlDate != null )
ctlDate.Value = T10n.FromServerTime(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "DateTimeEdit", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
try
{
DateTimeEdit ctlDate = Parent.FindControl(sDATA_FIELD) as DateTimeEdit;
if ( ctlDate != null )
ctlDate.Value = T10n.FromServerTime(rdr[sDATA_FIELD]);
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
}
}
else if ( String.Compare(sFIELD_TYPE, "File", true) == 0 )
{
}
else if ( String.Compare(sFIELD_TYPE, "Image", true) == 0 )
{
if ( !Sql.IsEmptyString(sDATA_FIELD) )
{
try
{
HtmlInputHidden ctlHidden = Parent.FindControl(sDATA_FIELD) as HtmlInputHidden;
Image imgField = Parent.FindControl("img" + sDATA_FIELD) as Image;
if ( ctlHidden != null && imgField != null )
{
if ( !Sql.IsEmptyString(rdr[sDATA_FIELD]) )
{
ctlHidden.Value = Sql.ToString(rdr[sDATA_FIELD]);
imgField.ImageUrl = "~/Images/Image.aspx?ID=" + ctlHidden.Value;
}
}
}
catch(Exception ex)
{
SplendidError.SystemWarning(new StackTrace(true).GetFrame(0), ex);
}
}
}
}
}