private string GetColNames(JQGrid grid)
{
string[] array = new string[grid.Columns.Count];
for (int i = 0; i < grid.Columns.Count; i++)
{
JQGridColumn jQGridColumn = grid.Columns[i];
array[i] = (string.IsNullOrEmpty(jQGridColumn.HeaderText) ? jQGridColumn.DataField : jQGridColumn.HeaderText);
}
return(new JavaScriptSerializer().Serialize(array));
}
internal static JsonTreeResponse PrepareJsonTreeResponse(JsonTreeResponse response, JQGrid grid, DataTable dt)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
response.rows[i] = new Hashtable();
for (int j = 0; j < grid.Columns.Count; j++)
{
JQGridColumn jQGridColumn = grid.Columns[j];
string value = "";
if (!string.IsNullOrEmpty(jQGridColumn.DataField))
{
int ordinal = dt.Columns[jQGridColumn.DataField].Ordinal;
value = (string.IsNullOrEmpty(jQGridColumn.DataFormatString) ? dt.Rows[i].ItemArray[ordinal].ToString() : jQGridColumn.FormatDataValue(dt.Rows[i].ItemArray[ordinal], jQGridColumn.HtmlEncode));
}
response.rows[i].Add(jQGridColumn.DataField, value);
}
try {
response.rows[i].Add("tree_level", dt.Rows[i]["tree_level"] as int?);
} catch {
}
try {
response.rows[i].Add("tree_parent", Convert.ToString(dt.Rows[i]["tree_parent"]));
} catch {
}
try {
response.rows[i].Add("tree_leaf", dt.Rows[i]["tree_leaf"] as bool?);
} catch {
}
try {
response.rows[i].Add("tree_expanded", dt.Rows[i]["tree_expanded"] as bool?);
} catch {
}
try {
response.rows[i].Add("tree_loaded", dt.Rows[i]["tree_loaded"] as bool?);
} catch {
}
try {
response.rows[i].Add("tree_icon", dt.Rows[i]["tree_icon"] as string);
} catch {
}
}
return(response);
}
private static string ConstructLinqFilterExpression(JQGrid grid, Util.SearchArguments args)
{
JQGridColumn jQGridColumn = grid.Columns.Find((JQGridColumn c) => c.DataField == args.SearchColumn);
if (jQGridColumn.DataType == null)
{
throw new DataTypeNotSetException("JQGridColumn.DataType must be set in order to perform search operations.");
}
string filterExpressionCompare = (jQGridColumn.DataType == typeof(string)) ? "{0} {1} \"{2}\"" : "{0} {1} {2}";
if (jQGridColumn.DataType == typeof(DateTime))
{
DateTime dateTime = DateTime.Parse(args.SearchString);
string str = string.Format("({0},{1},{2})", dateTime.Year, dateTime.Month, dateTime.Day);
filterExpressionCompare = "{0} {1} DateTime" + str;
}
string str2 = string.Format("{0} != null AND ", args.SearchColumn);
return(str2 + Util.GetLinqExpression(filterExpressionCompare, args, jQGridColumn.SearchCaseSensitive, jQGridColumn.DataType));
}
internal static JsonResponse PrepareJsonResponse(JsonResponse response, JQGrid grid, DataTable dt)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
string[] array = new string[grid.Columns.Count];
for (int j = 0; j < grid.Columns.Count; j++)
{
JQGridColumn jQGridColumn = grid.Columns[j];
string text = "";
if (!string.IsNullOrEmpty(jQGridColumn.DataField))
{
int ordinal = dt.Columns[jQGridColumn.DataField].Ordinal;
text = (string.IsNullOrEmpty(jQGridColumn.DataFormatString) ? dt.Rows[i].ItemArray[ordinal].ToString() : jQGridColumn.FormatDataValue(dt.Rows[i].ItemArray[ordinal], jQGridColumn.HtmlEncode));
}
array[j] = text;
}
string id = array[Util.GetPrimaryKeyIndex(grid)];
JsonRow jsonRow = new JsonRow();
jsonRow.id = id;
jsonRow.cell = array;
response.rows[i] = jsonRow;
}
return(response);
}
private void ApplyFormatterOptions(JQGridColumn column)
{
Hashtable hashtable = new Hashtable();
Hashtable delOptions = new Hashtable();
if (column.EditActionIconsColumn)
{
hashtable["keys"] = column.EditActionIconsSettings.SaveOnEnterKeyPress;
hashtable["editbutton"] = column.EditActionIconsSettings.ShowEditIcon;
hashtable["delbutton"] = column.EditActionIconsSettings.ShowDeleteIcon;
if (!string.IsNullOrEmpty(column.EditActionIconsSettings.Events.AfterSave))
{
hashtable["afterSave"] = column.EditActionIconsSettings.Events.AfterSave;
}
if (!string.IsNullOrEmpty(column.EditActionIconsSettings.Events.OnSuccess))
{
hashtable["onSuccess"] = column.EditActionIconsSettings.Events.OnSuccess;
}
if (!string.IsNullOrEmpty(column.EditActionIconsSettings.Events.OnError))
{
hashtable["onError"] = column.EditActionIconsSettings.Events.OnError;
}
if (!column.EditActionIconsSettings.ReloadAfterDelete)
{
delOptions["reloadAfterSubmit"] = false;
}
hashtable["delOptions"] = delOptions;
}
if (column.Formatter != null)
{
JQGridColumnFormatter formatter = column.Formatter;
if (formatter is LinkFormatter)
{
LinkFormatter linkFormatter = (LinkFormatter)formatter;
this._jsonValues["formatter"] = "link";
if (!string.IsNullOrEmpty(linkFormatter.Target))
{
hashtable["target"] = linkFormatter.Target;
}
}
if (formatter is EmailFormatter)
{
this._jsonValues["formatter"] = "email";
}
if (formatter is IntegerFormatter)
{
IntegerFormatter integerFormatter = (IntegerFormatter)formatter;
this._jsonValues["formatter"] = "integer";
if (!string.IsNullOrEmpty(integerFormatter.ThousandsSeparator))
{
hashtable["thousandsSeparator"] = integerFormatter.ThousandsSeparator;
}
if (!string.IsNullOrEmpty(integerFormatter.DefaultValue))
{
hashtable["defaultValue"] = integerFormatter.DefaultValue;
}
}
if (formatter is NumberFormatter)
{
NumberFormatter numberFormatter = (NumberFormatter)formatter;
this._jsonValues["formatter"] = "number";
if (!string.IsNullOrEmpty(numberFormatter.ThousandsSeparator))
{
hashtable["thousandsSeparator"] = numberFormatter.ThousandsSeparator;
}
if (!string.IsNullOrEmpty(numberFormatter.DefaultValue))
{
hashtable["defaultValue"] = numberFormatter.DefaultValue;
}
if (!string.IsNullOrEmpty(numberFormatter.DecimalSeparator))
{
hashtable["decimalSeparator"] = numberFormatter.DecimalSeparator;
}
if (numberFormatter.DecimalPlaces != -1)
{
hashtable["decimalPlaces"] = numberFormatter.DecimalPlaces;
}
}
if (formatter is CurrencyFormatter)
{
CurrencyFormatter currencyFormatter = (CurrencyFormatter)formatter;
this._jsonValues["formatter"] = "currency";
if (!string.IsNullOrEmpty(currencyFormatter.ThousandsSeparator))
{
hashtable["thousandsSeparator"] = currencyFormatter.ThousandsSeparator;
}
if (!string.IsNullOrEmpty(currencyFormatter.DefaultValue))
{
hashtable["defaultValue"] = currencyFormatter.DefaultValue;
}
if (!string.IsNullOrEmpty(currencyFormatter.DecimalSeparator))
{
hashtable["decimalSeparator"] = currencyFormatter.DecimalSeparator;
}
if (currencyFormatter.DecimalPlaces != -1)
{
hashtable["decimalPlaces"] = currencyFormatter.DecimalPlaces;
}
if (!string.IsNullOrEmpty(currencyFormatter.Prefix))
{
hashtable["prefix"] = currencyFormatter.Prefix;
}
if (!string.IsNullOrEmpty(currencyFormatter.Prefix))
{
hashtable["suffix"] = currencyFormatter.Suffix;
}
}
if (formatter is CheckBoxFormatter)
{
CheckBoxFormatter checkBoxFormatter = (CheckBoxFormatter)formatter;
this._jsonValues["formatter"] = "checkbox";
if (checkBoxFormatter.Enabled)
{
hashtable["disabled"] = false;
}
}
if (formatter is CustomFormatter)
{
CustomFormatter customFormatter = (CustomFormatter)formatter;
if (!string.IsNullOrEmpty(customFormatter.FormatFunction))
{
this._jsonValues["formatter"] = customFormatter.FormatFunction;
}
if (!string.IsNullOrEmpty(customFormatter.UnFormatFunction))
{
this._jsonValues["unformat"] = customFormatter.UnFormatFunction;
}
}
}
if (hashtable.Count > 0)
{
this._jsonValues["formatoptions"] = hashtable;
}
}
public void FromColumn(JQGridColumn column)
{
this._jsonValues["index"] = (this._jsonValues["name"] = column.DataField);
if (column.Width != 150)
{
this._jsonValues["width"] = column.Width;
}
if (!column.Sortable)
{
this._jsonValues["sortable"] = false;
}
if (column.PrimaryKey)
{
this._jsonValues["key"] = true;
}
if (!column.Visible)
{
this._jsonValues["hidden"] = true;
}
if (!column.Searchable)
{
this._jsonValues["search"] = false;
}
if (column.TextAlign != TextAlign.Left)
{
this._jsonValues["align"] = column.TextAlign.ToString().ToLower();
}
if (!column.Resizable)
{
this._jsonValues["resizable"] = false;
}
if (!string.IsNullOrEmpty(column.CssClass))
{
this._jsonValues["classes"] = column.CssClass;
}
if (column.Fixed)
{
this._jsonValues["fixed"] = true;
}
if (column.GroupSummaryType != GroupSummaryType.None)
{
switch (column.GroupSummaryType)
{
case GroupSummaryType.Min: {
this._jsonValues["summaryType"] = "min";
break;
}
case GroupSummaryType.Max: {
this._jsonValues["summaryType"] = "max";
break;
}
case GroupSummaryType.Sum: {
this._jsonValues["summaryType"] = "sum";
break;
}
case GroupSummaryType.Avg: {
this._jsonValues["summaryType"] = "avg";
break;
}
case GroupSummaryType.Count: {
this._jsonValues["summaryType"] = "count";
break;
}
}
}
if (!string.IsNullOrEmpty(column.GroupTemplate))
{
this._jsonValues["summaryTpl"] = column.GroupTemplate;
}
if (column.Formatter != null || column.EditActionIconsColumn)
{
this.ApplyFormatterOptions(column);
}
if (column.EditActionIconsColumn)
{
this._jsonValues["formatter"] = "actions";
}
if (column.Searchable)
{
Hashtable hashtable = new Hashtable();
if (column.SearchType == SearchType.DropDown)
{
this._jsonValues["stype"] = "select";
}
if (!column.Visible)
{
hashtable["searchhidden"] = true;
}
if (column.SearchList.Count <SelectListItem>() > 0)
{
StringBuilder stringBuilder = new StringBuilder();
int num = 0;
foreach (SelectListItem current in column.SearchList)
{
stringBuilder.AppendFormat("{0}:{1}", current.Value, current.Text);
num++;
if (num < column.SearchList.Count <SelectListItem>())
{
stringBuilder.Append(";");
}
if (current.Selected)
{
hashtable["defaultValue"] = current.Value;
}
}
hashtable["value"] = stringBuilder.ToString();
}
hashtable["sopt"] = GetSupportedSearchOperations(column.SearchSupportedOperations);
if (column.SearchType == SearchType.DatePicker || column.SearchType == SearchType.AutoComplete)
{
hashtable["dataInit"] = "attachSearchControlsScript" + column.DataField;
}
this._jsonValues["searchoptions"] = hashtable;
}
if (column.Editable)
{
Hashtable hashtable2 = new Hashtable();
this._jsonValues["editable"] = true;
if (column.EditType != EditType.TextBox)
{
this._jsonValues["edittype"] = this.GetEditType(column.EditType);
}
if (column.EditType == EditType.CheckBox)
{
column.EditList.Clear();
column.EditList.Add(new SelectListItem {
Value = "true:false"
});
}
if (column.EditType == EditType.Custom)
{
Guard.IsNotNullOrEmpty(column.EditTypeCustomCreateElement, "JQGridColumn.EditTypeCustomCreateElement", " should be set to the name of the javascript function creating the element when EditType = EditType.Custom");
Guard.IsNotNullOrEmpty(column.EditTypeCustomGetValue, "JQGridColumn.EditTypeCustomGetValue", " should be set to the name of the javascript function getting the value from the element when EditType = EditType.Custom");
hashtable2["custom_element"] = column.EditTypeCustomCreateElement;
hashtable2["custom_value"] = column.EditTypeCustomGetValue;
}
foreach (JQGridEditFieldAttribute current2 in column.EditFieldAttributes)
{
hashtable2[current2.Name] = current2.Value;
}
if (column.EditType == EditType.DatePicker || column.EditType == EditType.AutoComplete)
{
hashtable2["dataInit"] = "attachEditControlsScript" + column.DataField;
}
if (column.EditList.Count <SelectListItem>() > 0)
{
StringBuilder stringBuilder2 = new StringBuilder();
int num2 = 0;
foreach (SelectListItem current3 in column.EditList)
{
stringBuilder2.AppendFormat("{0}:{1}", current3.Value, current3.Text);
num2++;
if (num2 < column.EditList.Count <SelectListItem>())
{
stringBuilder2.Append(";");
}
}
hashtable2["value"] = stringBuilder2.ToString();
}
if (hashtable2.Count > 0)
{
this._jsonValues["editoptions"] = hashtable2;
}
Hashtable hashtable3 = new Hashtable();
if (column.EditDialogColumnPosition != 0)
{
hashtable3["colpos"] = column.EditDialogColumnPosition;
}
if (column.EditDialogRowPosition != 0)
{
hashtable3["rowpos"] = column.EditDialogRowPosition;
}
if (!string.IsNullOrEmpty(column.EditDialogLabel))
{
hashtable3["label"] = column.EditDialogLabel;
}
if (!string.IsNullOrEmpty(column.EditDialogFieldPrefix))
{
hashtable3["elmprefix"] = column.EditDialogFieldPrefix;
}
if (!string.IsNullOrEmpty(column.EditDialogFieldSuffix))
{
hashtable3["elmsuffix"] = column.EditDialogFieldSuffix;
}
if (hashtable3.Count > 0)
{
this._jsonValues["formoptions"] = hashtable3;
}
Hashtable hashtable4 = new Hashtable();
if (!column.Visible && column.Editable)
{
hashtable4["edithidden"] = true;
}
if (column.EditClientSideValidators != null)
{
foreach (JQGridEditClientSideValidator current4 in column.EditClientSideValidators)
{
if (current4 is DateValidator)
{
hashtable4["date"] = true;
}
if (current4 is EmailValidator)
{
hashtable4["email"] = true;
}
if (current4 is IntegerValidator)
{
hashtable4["integer"] = true;
}
if (current4 is MaxValueValidator)
{
hashtable4["maxValue"] = ((MaxValueValidator)current4).MaxValue;
}
if (current4 is MinValueValidator)
{
hashtable4["minValue"] = ((MinValueValidator)current4).MinValue;
}
if (current4 is NumberValidator)
{
hashtable4["number"] = true;
}
if (current4 is RequiredValidator)
{
hashtable4["required"] = true;
}
if (current4 is TimeValidator)
{
hashtable4["time"] = true;
}
if (current4 is UrlValidator)
{
hashtable4["url"] = true;
}
if (current4 is CustomValidator)
{
hashtable4["custom"] = true;
hashtable4["custom_func"] = ((CustomValidator)current4).ValidationFunction;
}
}
}
if (hashtable4.Count > 0)
{
this._jsonValues["editrules"] = hashtable4;
}
}
}
public JsonColModel(JQGridColumn column, JQGrid grid) : this(grid)
{
this.FromColumn(column);
}
