public static void adjustTableColumnWidths(JTable paramJTable, int paramInt1, int paramInt2, bool paramBoolean1, bool paramBoolean2, bool paramBoolean3)
{
TableColumnModel tableColumnModel = paramJTable.ColumnModel;
for (sbyte b = 0; b < tableColumnModel.ColumnCount; b++)
{
TableUtils.autoResizeColumn(paramJTable, b, true, paramBoolean1, paramInt1, paramInt2, paramBoolean2, paramBoolean3);
}
}
public static void setAllTableColumnWidth(JTable paramJTable, int paramInt)
{
TableColumnModel tableColumnModel = paramJTable.ColumnModel;
for (sbyte b = 0; b < tableColumnModel.ColumnCount; b++)
{
TableColumn tableColumn = tableColumnModel.getColumn(b);
tableColumn.PreferredWidth = paramInt;
}
}
/// <summary>
/// Delete redshift data
/// </summary>
/// <param name="model"></param>
/// <param name="sqlquery"></param>
/// <returns></returns>
public ResponseModelDto DeleteRedshiftData(TableColumnModel model, string sqlquery)
{
ResponseModelDto responsemodel = new ResponseModelDto();
if (model.ColumnsList.Count > 0)
{
using (var conn = new NpgsqlConnection(CommonClass.GetConnectionString(_settings.ServerName, _settings.Port, _settings.UserName, _settings.Password, _settings.Database)))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
for (int i = 0; i < model.ColumnsList.Count; i++)
{
switch (model.ColumnsList[i].DataType.ToString())
{
case "date":
cmd.Parameters.AddWithValue(model.ColumnsList[i].ColumnName, NpgsqlDbType.Date, string.IsNullOrEmpty(model.ColumnValue) ? (DateTime?)null : Convert.ToDateTime(CommonClass.ChangeDateFormat(model.ColumnsList[i].ColumnValue)));
break;
case "text":
cmd.Parameters.AddWithValue(model.ColumnsList[i].ColumnName, NpgsqlDbType.Varchar, model.ColumnsList[i].ColumnValue);
break;
case "int":
cmd.Parameters.AddWithValue(model.ColumnsList[i].ColumnName, NpgsqlDbType.Integer, Convert.ToInt32(model.ColumnsList[i].ColumnValue));
break;
case "bool":
cmd.Parameters.AddWithValue(model.ColumnsList[i].ColumnName, NpgsqlDbType.Boolean, model.ColumnValue);
break;
case "float":
cmd.Parameters.AddWithValue(model.ColumnsList[i].ColumnName, NpgsqlDbType.Double, model.ColumnValue);
break;
}
}
cmd.Connection = conn;
cmd.CommandText = sqlquery;
cmd.ExecuteReader();
}
}
responsemodel.StatusCode = "200";
responsemodel.Status = true;
responsemodel.Message = "Data successfully deleted";
}
return(responsemodel);
}
public static void adjustTableColumnWidths(JTable paramJTable, int paramInt)
{
TableColumnModel tableColumnModel = paramJTable.ColumnModel;
for (sbyte b = 0; b < tableColumnModel.ColumnCount; b++)
{
TableColumn tableColumn = tableColumnModel.getColumn(b);
if (tableColumn.Width > paramInt)
{
tableColumn.PreferredWidth = paramInt;
}
}
}
public static void setAllTableColumnWidthFromAnotherTable(JTable paramJTable1, JTable paramJTable2)
{
TableColumnModel tableColumnModel1 = paramJTable1.ColumnModel;
TableColumnModel tableColumnModel2 = paramJTable2.ColumnModel;
if (tableColumnModel2.ColumnCount < tableColumnModel1.ColumnCount)
{
return;
}
for (sbyte b = 0; b < tableColumnModel1.ColumnCount; b++)
{
tableColumnModel1.getColumn(b).PreferredWidth = tableColumnModel2.getColumn(b).PreferredWidth;
}
}
/// <summary>
/// Sets the column model for this table to <code>newModel</code> and registers
/// for listener notifications from the new column model.
/// </summary>
public void setColumnModel(TableColumnModel @columnModel)
{
}
public ActionResult ShowInlineEditing(ITableColumnService tableColumnService, ILocalizationService localizationService, TableColumnModel column, int index, string tableName)
{
if (column.ColumnDataTypeId == 470 || column.ColumnDataTypeId == 471)
{
var model = new TextEditorModel()
{
LabelName = localizationService.GetLocalizedData(column.Id.ToString() + ";" + DataType.TableName + ";ColumnName"),
Name = tableName + "[" + index.ToString() + "]." + column.ColumnName,
Value = column.ColumnValue,
PlaceHolder = localizationService.GetLocalizedData(column.Id.ToString() + ";" + DataType.TableName + ";ColumnName")
};
if (column.ColumnDataTypeId == 471)
{
model.Type = "Number";
}
return(PartialView(UrlHelpers.FloatingTemplate("_TextEditor.cshtml"), model));
}
else
if (column.ColumnDataTypeId == 472)
{
var model = new DatePickerModel()
{
LabelName = localizationService.GetLocalizedData(column.Id.ToString() + ";" + DataType.TableName + ";ColumnName"),
Name = tableName + "[" + index.ToString() + "]." + column.ColumnName,
DateFormat = "dd/MM/yyyy",
Vertical = "top",
PlaceHolder = localizationService.GetLocalizedData(column.Id.ToString() + ";" + DataType.TableName + ";ColumnName")
};
if (column.ColumnValue != null && !string.IsNullOrEmpty(column.ColumnValue))
{
model.Value = DateTime.Parse(column.ColumnValue);
}
else
{
model.Value = null;
}
return(PartialView(UrlHelpers.FloatingTemplate("_DatePicker.cshtml"), model));
}
else
if (column.ColumnDataTypeId == 473)
{
var model = new DropdownListModel()
{
LabelName = localizationService.GetLocalizedData(column.Id.ToString() + ";" + DataType.TableName + ";ColumnName"),
DataType = DataType.MasterData,
PropertyName = "Name",
IsAnimationLabel = false,
IsTagsInput = false,
IsMultipleLanguage = false,
ValueField = "Id",
DisplayField = "Name",
Name = tableName + "[" + index.ToString() + "]." + column.ColumnName,
Value = column.ColumnValue
};
var responseColumn = tableColumnService.ExcuteSqlString(column.SqlData);
if (responseColumn != null)
{
var resultColumn = JsonConvert.DeserializeObject <HrmResultModel <dynamic> >(responseColumn);
if (!CheckPermission(resultColumn))
{
//return to Access Denied
}
else
{
model.Data = resultColumn.Results;
}
}
return(PartialView(UrlHelpers.FloatingTemplate("_Dropdown.cshtml"), model));
}
else
if (column.ColumnDataTypeId == 10519)
{
var model = new CheckboxModel()
{
LabelName = localizationService.GetLocalizedData(column.Id.ToString() + ";" + DataType.TableName + ";ColumnName"),
Name = tableName + "[" + index.ToString() + "]." + column.ColumnName,
Value = column.ColumnValue,
};
return(PartialView(UrlHelpers.FloatingTemplate("_Checkbox.cshtml"), model));
}
else
{
return(Content("<div class=\"hrm-v2-td-template\"><span id=\"original-row-column-\"" + column.Id + ">" + column.ColumnValue + "</span></div>"));
}
}
public ActionResult FilterValueSelector(ITableColumnService tableColumnService, TableColumnModel column)
{
if (column.ColumnDataTypeId == 473)
{
var model = new DropdownListModel()
{
IsAnimationLabel = false,
IsTagsInput = true,
IsMultipleLanguage = false,
ValueField = "Id",
DisplayField = "Name",
Name = "filter-value-" + column.Id,
};
if (column.IsChecked)
{
model.ValueMultiSelect = JsonConvert.DeserializeObject <List <string> >(column.FilterValue.ToString());
}
var responseColumn = tableColumnService.ExcuteSqlString(column.SqlData);
if (responseColumn != null)
{
var resultColumn = JsonConvert.DeserializeObject <HrmResultModel <dynamic> >(responseColumn);
if (!CheckPermission(resultColumn))
{
//return to Access Denied
}
else
{
model.Data = resultColumn.Results;
}
}
return(PartialView(UrlHelpers.FloatingTemplate("_Dropdown.cshtml"), model));
}
else
if (column.ColumnDataTypeId == 472)
{
var model = new DatePickerModel()
{
Name = "filter-value-" + column.Id,
DateFormat = "dd/MM/yyyy",
Vertical = "top"
};
if (column.IsChecked)
{
model.Value = DateTime.ParseExact(column.FilterValue, "dd/MM/yyyy", CultureInfo.InvariantCulture);
}
return(PartialView(UrlHelpers.FloatingTemplate("_DatePicker.cshtml"), model));
}
else
if (column.ColumnDataTypeId == 470 || column.ColumnDataTypeId == 471)
{
var model = new TagsInputModel()
{
Name = "filter-value-" + column.Id
};
if (column.IsChecked)
{
model.Value = column.FilterValue ?? string.Empty;
}
return(PartialView(UrlHelpers.FloatingTemplate("_MultiSelect.cshtml"), model));
}
return(null);
}
/// <summary>
/// Constructs a TableColumnModelEvent object.
/// </summary>
public TableColumnModelEvent(TableColumnModel @source, int @from, int @to)
{
}
/// <summary>
/// Save redshift data
/// </summary>
/// <param name="model"></param>
public ResponseModelDto SaveRedshiftData(TableColumnModel model)
{
ResponseModelDto responsemodel = new ResponseModelDto();
var qry = String.Format("insert into {0} ({1}) values ({2})", model.TableName, model.ColumnName, model.ColumnValue);
using (var conn = new NpgsqlConnection(CommonClass.GetConnectionString(_settings.ServerName, _settings.Port, _settings.UserName, _settings.Password, _settings.Database)))
{
conn.Open();
using (var cmd = new NpgsqlCommand())
{
for (int i = 0; i < model.ColumnsList.Count; i++)
{
switch (model.ColumnsList[i].DataType.ToString())
{
case "date":
cmd.Parameters.AddWithValue(model.ColumnsList[i].ColumnName, NpgsqlDbType.Date, string.IsNullOrEmpty(model.ColumnValue) ? (DateTime?)null : Convert.ToDateTime(CommonClass.ChangeDateFormat(model.ColumnsList[i].ColumnValue)));
break;
case "text":
cmd.Parameters.AddWithValue(model.ColumnsList[i].ColumnName, NpgsqlDbType.Varchar, model.ColumnsList[i].ColumnValue);
break;
case "int":
cmd.Parameters.AddWithValue(model.ColumnsList[i].ColumnName, NpgsqlDbType.Integer, Convert.ToInt32(model.ColumnsList[i].ColumnValue));
break;
case "bool":
cmd.Parameters.AddWithValue(model.ColumnsList[i].ColumnName, NpgsqlDbType.Boolean, Convert.ToBoolean(model.ColumnsList[i].ColumnValue));
break;
case "float":
cmd.Parameters.AddWithValue(model.ColumnsList[i].ColumnName, NpgsqlDbType.Double, Convert.ToDouble(model.ColumnsList[i].ColumnValue));
break;
}
}
cmd.Connection = conn;
cmd.CommandText = qry;
if (!CommonClass.VerifyQuery(qry))
{
cmd.ExecuteReader();
responsemodel.Message = "Data successfully saved";
responsemodel.StatusCode = "200";
responsemodel.Status = true;
}
else
{
responsemodel.Message = "Characters are not valid in query";
responsemodel.StatusCode = "400";
responsemodel.Status = false;
}
}
}
return(responsemodel);
}
/// <summary>
/// Constructs a <code>JTable</code> that is initialized with
/// <code>dm</code> as the data model, <code>cm</code>
/// as the column model, and a default selection model.
/// </summary>
public JTable(TableModel @dm, TableColumnModel @cm)
{
}
public ActionResult RowInlineEditor(TableColumnModel column, int index, string tableName)
{
return(ShowInlineEditing(_tableColumnService, _localizationService, column, index, tableName));
}
/// <summary>
/// Constructs a TableColumnModelEvent object.
/// </summary>
public TableColumnModelEvent(TableColumnModel @source, int @from, int @to)
{
}
public ActionResult FilterSelector(TableColumnModel column)
{
return(FilterValueSelector(_tableColumnService, column));
}
/// <summary>
/// Sets the column model for this table to <code>newModel</code> and registers
/// for listener notifications from the new column model.
/// </summary>
public void setColumnModel(TableColumnModel @columnModel)
{
}
/// <summary>
/// Constructs a <code>JTable</code> that is initialized with
/// <code>dm</code> as the data model, <code>cm</code> as the
/// column model, and <code>sm</code> as the selection model.
/// </summary>
public JTable(TableModel @dm, TableColumnModel @cm, ListSelectionModel @sm)
{
}
/// <summary>
/// Constructs a <code>JTable</code> that is initialized with
/// <code>dm</code> as the data model, <code>cm</code>
/// as the column model, and a default selection model.
/// </summary>
public JTable(TableModel @dm, TableColumnModel @cm)
{
}
/// <summary>
/// Constructs a <code>JTable</code> that is initialized with
/// <code>dm</code> as the data model, <code>cm</code> as the
/// column model, and <code>sm</code> as the selection model.
/// </summary>
public JTable(TableModel @dm, TableColumnModel @cm, ListSelectionModel @sm)
{
}
/// <summary>
/// Constructs a <code>JTableHeader</code> which is initialized with
/// <code>cm</code> as the column model.
/// </summary>
public JTableHeader(TableColumnModel @cm)
{
}
/// <summary>
/// Constructs a <code>JTableHeader</code> which is initialized with
/// <code>cm</code> as the column model.
/// </summary>
public JTableHeader(TableColumnModel @cm)
{
}
