public static void init()
{
ContactsEditorViewModel vm = new ContactsEditorViewModel();
OrganizationServiceProxy.GetUserSettings();
// Data Bind Grid
List <Column> columns = GridDataViewBinder.ParseLayout(",entityState,20,First Name,firstname,200,Last Name,lastname,200,Birth Date,birthdate,200,Account Role Code,accountrolecode,200,Number of Children,numberofchildren,100,Currency,transactioncurrencyid,200,Credit Limit,creditlimit,100,Gender,gendercode,100,Owner,ownerid,100");
// Set Column formatters and editors
columns[0].Formatter = delegate(int row, int cell, object value, Column columnDef, object dataContext)
{
EntityStates state = (EntityStates)value;
return(((state == EntityStates.Changed) || (state == EntityStates.Created)) ? "<span class='grid-edit-indicator'></span>" : "");
};
// First Name Column
XrmTextEditor.BindColumn(columns[1]);
// Last Name Column
XrmTextEditor.BindColumn(columns[2]);
// Birth Date Column
XrmDateEditor.BindColumn(columns[3], false);
// Account Code Column
XrmOptionSetEditor.BindColumn(columns[4], "contact", columns[4].Field, true);
// Number of Children Column
XrmNumberEditor.BindColumn(columns[5], 0, 100, 0);
// Currency Column
XrmLookupEditor.BindColumn(columns[6], vm.TransactionCurrencySearchCommand, "transactioncurrencyid", "currencyname", "");
// Credit Limit Column
XrmMoneyEditor.BindColumn(columns[7], -10000, 10000);
// Another optionset
XrmOptionSetEditor.BindColumn(columns[8], "contact", columns[8].Field, true);
// OWner Column
XrmLookupEditor.BindColumn(columns[9], vm.OwnerSearchCommand, "id", "name", "");
// Create Grid
GridDataViewBinder contactGridDataBinder = new GridDataViewBinder();
Grid contactsGrid = contactGridDataBinder.DataBindXrmGrid(vm.Contacts, columns, "container", "pager", true, false);
//contactGridDataBinder.BindClickHandler(contactsGrid);
// Data Bind
ViewBase.RegisterViewModel(vm);
Window.SetTimeout(delegate()
{
vm.Init();
}, 0);
}
public static void Init()
{
PageEx.MajorVersion = 2013;
jQuery.OnDocumentReady(delegate()
{
ValidationApi.RegisterExtenders();
// Init settings
OrganizationServiceProxy.GetUserSettings();
SimpleEditableGridViewModel vm = new SimpleEditableGridViewModel();
// Create Grid
GridDataViewBinder dataViewBinder = new GridDataViewBinder();
dataViewBinder.AddCheckBoxSelectColumn = true;
dataViewBinder.SelectActiveRow = true;
dataViewBinder.MultiSelect = false;
List <Column> columns = new List <Column>();
EditorFactory textEditor = (EditorFactory)Script.Literal("Slick.Editors.Text");
XrmTextEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Title", 150, "title"));
XrmTextEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Author", 150, "author"));
XrmDateEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Published", 150, "publishdate"), true);
XrmMoneyEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Price", 150, "price"), 0, 100);
XrmNumberEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Copies", 150, "numberofcopies"), 0, 1000, 0);
XrmLookupEditorOptions languageLookupOptions =
(XrmLookupEditorOptions)XrmLookupEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Language", 150, "language"), vm.GetLanguages, "id", "name", null).Options;
languageLookupOptions.showImage = false;
OptionSetBindingOptions formatBindingOptions = new OptionSetBindingOptions();
formatBindingOptions.allowEmpty = true;
formatBindingOptions.GetOptionSetsDelegate = vm.GetFormats;
XrmOptionSetEditor.BindColumnWithOptions(GridDataViewBinder.AddColumn(columns, "Format", 150, "format"), formatBindingOptions);
XrmDurationEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Audio Length", 150, "audiolength"));
XrmTimeEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Start Time", 150, "starttime"));
Grid grid = dataViewBinder.DataBindXrmGrid(vm.Books, columns, "booksGridContainer", null, true, true);
ViewBase.RegisterViewModel(vm);
Window.SetTimeout(delegate()
{
vm.LoadBooks();
grid.ResizeCanvas();
}, 0);
});
}
public static void init()
{
ContactsEditorViewModel vm = new ContactsEditorViewModel();
// Data Bind Grid
List <Column> columns = GridDataViewBinder.ParseLayout("entityState,,20,firstname,First Name,200,lastname,Last Name,200,birthdate,Birth Date,200,accountrolecode,Account Role Code,200,numberofchildren,Number of Children,100,transactioncurrencyid,Currency,200,creditlimit,Credit Limit,100");
// Set Column formatters and editors
columns[0].Formatter = delegate(int row, int cell, object value, Column columnDef, object dataContext)
{
EntityStates state = (EntityStates)value;
return(((state == EntityStates.Changed) || (state == EntityStates.Created)) ? "<span class='grid-edit-indicator'></span>" : "");
};
// First Name Column
XrmTextEditor.BindColumn(columns[1]);
// Last Name Column
XrmTextEditor.BindColumn(columns[2]);
// Birth Date Column
XrmDateEditor.BindColumn(columns[3], false);
// Account Code Column
XrmOptionSetEditor.BindColumn(columns[4], "contact", columns[4].Field, true);
// Number of Children Column
XrmNumberEditor.BindColumn(columns[5], 0, 100, 0);
// Currency Column
XrmLookupEditor.BindColumn(columns[6], vm.TransactionCurrencySearchCommand, "transactioncurrencyid", "currencyname", "");
// Credit Limit Column
XrmMoneyEditor.BindColumn(columns[7], -10000, 10000);
// Create Grid
GridDataViewBinder contactGridDataBinder = new GridDataViewBinder();
Grid contactsGrid = contactGridDataBinder.DataBindXrmGrid(vm.Contacts, columns, "container", "pager", true, false);
// Data Bind
ViewBase.RegisterViewModel(vm);
}
private static void InitLocalisedContent()
{
Dictionary <string, string> parameters;
string id;
string logicalName;
int pageSize = 10;
string defaultView = null;
#if DEBUG
id = "C489707F-B5E2-E411-80D5-080027846324";
logicalName = "account";
parameters = new Dictionary <string, string>();
#else
parameters = PageEx.GetWebResourceData(); // The allowed lookup types for the connections - e.g. account, contact, opportunity. This must be passed as a data parameter to the webresource 'account=name&contact=fullname&opportunity=name
id = ParentPage.Data.Entity.GetId();
logicalName = ParentPage.Data.Entity.GetEntityName();
ParentPage.Data.Entity.AddOnSave(CheckForSaved);
#endif
EntityReference parent = new EntityReference(new Guid(id), logicalName, null);
string entities = "account,contact,opportunity,systemuser";
foreach (string key in parameters.Keys)
{
switch (key.ToLowerCase())
{
case "entities":
entities = parameters[key];
break;
case "pageSize":
pageSize = int.Parse(parameters[key]);
break;
case "view":
defaultView = parameters[key];
break;
}
}
// Get the view
QueryParser queryParser = new QueryParser(new string[] { "connection" });
queryParser.GetView("connection", defaultView);
queryParser.QueryMetadata();
EntityQuery connectionViews = queryParser.EntityLookup["connection"];
string viewName = connectionViews.Views.Keys[0];
FetchQuerySettings view = connectionViews.Views[viewName];
vm = new ConnectionsViewModel(parent, entities.Split(","), pageSize, view);
// Bind Connections grid
GridDataViewBinder connectionsGridDataBinder = new GridDataViewBinder();
List <Column> columns = view.Columns;
// Role2Id Column - provided it is in the view!
foreach (Column col in columns)
{
switch (col.Field)
{
case "record2roleid":
XrmLookupEditor.BindColumn(col, vm.RoleSearchCommand, "connectionroleid", "name,category", "");
break;
case "description":
XrmTextEditor.BindColumn(col);
break;
case "effectivestart":
case "effectiveend":
XrmDateEditor.BindColumn(col, true);
break;
}
}
connectionsGrid = connectionsGridDataBinder.DataBindXrmGrid(vm.Connections, columns, "container", "pager", true, false);
connectionsGrid.OnActiveCellChanged.Subscribe(delegate(EventData e, object data)
{
OnCellChangedEventData eventData = (OnCellChangedEventData)data;
vm.SelectedConnection.SetValue((Connection)connectionsGrid.GetDataItem(eventData.Row));
});
connectionsGridDataBinder.BindClickHandler(connectionsGrid);
// Let's not use a hover button because it get's in the way of the editable grid!
//RowHoverPlugin rowButtons = new RowHoverPlugin("gridButtons");
//connectionsGrid.RegisterPlugin(rowButtons);
ViewBase.RegisterViewModel(vm);
OverrideMetadata();
jQuery.Window.Resize(OnResize);
jQuery.OnDocumentReady(delegate()
{
OnResize(null);
vm.Search();
});
}
public static void SetUpGrids(TimeSheetViewModel vm)
{
// Create Timesheet Grid
DataViewBase daysDataView = vm.Days;
List <Column> columns = new List <Column>();
GridDataViewBinder.BindRowIcon(GridDataViewBinder.AddColumn(columns, "", 50, "icon"), "activity");
XrmLookupEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Account", 300, "account"), vm.AccountSeachCommand, "accountid", "name", null);
XrmLookupEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Regarding", 300, "regardingObjectId"), vm.RegardingObjectSearchCommand, "id", "displayName", null);
XrmLookupEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Activity", 300, "activity"), vm.ActivitySearchCommand, "activityid", "subject", "activitytypecode");
string[] daysOfWeek = new string[] { "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat", "Sun", "Mon", "Tue", "Wed", "Thu", "Fri", "Sat" };
int firstDayOfWeek = OrganizationServiceProxy.OrganizationSettings.WeekStartDayCode.Value.Value;
GridDataViewBinder.AddColumn(columns, daysOfWeek[firstDayOfWeek], 50, "day0");
GridDataViewBinder.AddColumn(columns, daysOfWeek[firstDayOfWeek + 1], 50, "day1");
GridDataViewBinder.AddColumn(columns, daysOfWeek[firstDayOfWeek + 2], 50, "day2");
GridDataViewBinder.AddColumn(columns, daysOfWeek[firstDayOfWeek + 3], 50, "day3");
GridDataViewBinder.AddColumn(columns, daysOfWeek[firstDayOfWeek + 4], 50, "day4");
GridDataViewBinder.AddColumn(columns, daysOfWeek[firstDayOfWeek + 5], 50, "day5");
GridDataViewBinder.AddColumn(columns, daysOfWeek[firstDayOfWeek + 6], 50, "day6");
GridDataViewBinder daysDataBinder = new GridDataViewBinder();
daysDataBinder.SelectActiveRow = true;
daysDataBinder.AddCheckBoxSelectColumn = false;
daysGrid = daysDataBinder.DataBindXrmGrid(daysDataView, columns, "timesheetGridContainer", null, true, true);
// Set the totals row meta data
daysDataView.OnGetItemMetaData += delegate(object item)
{
ItemMetaData metaData = new ItemMetaData();
DayEntry day = (DayEntry)item;
if (day != null && day.isTotalRow)
{
metaData.Editor = delegate(EditorArguments args) { return(null); };
metaData.Columns = new Dictionary <object, Column>();
metaData.Columns["Account"] = new Column("editor", null);
metaData.Columns["Regarding"] = new Column("editor", null);
metaData.Columns["Activity"] = new Column("editor", null);
metaData.Formatter = delegate(int row, int cell, object value, Column columnDef, object dataContext)
{
switch (columnDef.Field)
{
case "account":
case "regardingObjectId":
return("");
case "activity":
return("Total");
default:
return(XrmDurationEditor.Formatter(row, cell, value, columnDef, dataContext));
}
};
metaData.CssClasses = "days_total_row";
}
else
{
metaData.Formatter = delegate(int row, int cell, object value, Column columnDef, object dataContext)
{
switch (columnDef.Field)
{
case "account":
case "regardingObjectId":
case "activity":
return(XrmLookupEditor.Formatter(row, cell, value, columnDef, dataContext));
default:
return(XrmDurationEditor.Formatter(row, cell, value, columnDef, dataContext));
}
};
}
return(metaData);
};
daysDataBinder.DataBindSelectionModel(daysGrid, daysDataView);
// ---------------------------------------
// Sessions Grid
// ---------------------------------------
DataViewBase sessionsDataView = vm.SessionDataView;
List <Column> sessionGridCols = new List <Column>();
GridDataViewBinder.AddEditIndicatorColumn(sessionGridCols);
XrmTextEditor.BindColumn(GridDataViewBinder.AddColumn(sessionGridCols, "Activity", 300, "activitypointer_subject")).Editor = null;
XrmDateEditor.BindColumn(GridDataViewBinder.AddColumn(sessionGridCols, "Date", 100, "dev1_starttime"), true);
XrmTimeEditor.BindColumn(GridDataViewBinder.AddColumn(sessionGridCols, "Start", 100, "dev1_starttime")).Validator =
delegate(object value, object item)
{
dev1_session session = (dev1_session)item;
DateTime newStartTime = (DateTime)value;
ValidationResult result = new ValidationResult();
if (session.dev1_EndTime != null)
{
result.Valid = true;
string valueText = (string)value;
// Check if the end time is before the start time
bool isValid = DateTimeEx.GetTimeDuration(newStartTime) < DateTimeEx.GetTimeDuration(session.dev1_EndTime);
result.Valid = isValid;
result.Message = "The start time must be before the end time";
}
else
{
result.Valid = true;
}
return(result);
};
XrmTimeEditor.BindColumn(GridDataViewBinder.AddColumn(sessionGridCols, "End", 100, "dev1_endtime")).Validator =
delegate(object value, object item)
{
dev1_session session = (dev1_session)item;
DateTime newEndTime = (DateTime)value;
ValidationResult result = new ValidationResult();
if (session.dev1_StartTime != null)
{
result.Valid = true;
string valueText = (string)value;
// Check if the end time is before the start time
bool isValid = DateTimeEx.GetTimeDuration(session.dev1_StartTime) < DateTimeEx.GetTimeDuration(newEndTime);
result.Valid = isValid;
result.Message = "The end time must be after the start time";
}
else
{
result.Valid = true;
}
return(result);
};
XrmDurationEditor.BindColumn(GridDataViewBinder.AddColumn(sessionGridCols, "Duration", 70, "dev1_duration"));
XrmTextEditor.BindColumn(GridDataViewBinder.AddColumn(sessionGridCols, "Description", 300, "dev1_description"));
GridDataViewBinder sessionsDataBinder = new GridDataViewBinder();
sessionsDataBinder.SelectActiveRow = false;
sessionsDataBinder.AddCheckBoxSelectColumn = true;
sessionsGrid = sessionsDataBinder.DataBindXrmGrid(sessionsDataView, sessionGridCols, "sessionsGridContainer", null, true, true);
sessionsGrid.OnBeforeEditCell.Subscribe(delegate(EventData e, object args)
{
// Stop the row from being edited if locked
Entity item = (Entity)((EditEventData)args).item;
bool result = sessionsDataView.OnBeforeEdit(item);
Script.Literal("return {0}", result);
});
daysGrid.OnActiveCellChanged.Subscribe(delegate(EventData e, object args)
{
CellSelection activeCell = daysGrid.GetActiveCell();
if (activeCell != null)
{
if (activeCell.Cell < StartDaysColumnIndex)
{
// Whole activity is selected
vm.Days.SelectedDay = null;
}
else
{
vm.Days.SelectedDay = activeCell.Cell - (StartDaysColumnIndex - 1);
}
}
});
}
public static void SetUpGrids(TimeSheetViewModel vm)
{
GridOptions daysGridOpts = new GridOptions();
daysGridOpts.EnableCellNavigation = true;
daysGridOpts.EnableColumnReorder = false;
daysGridOpts.AutoEdit = false;
daysGridOpts.Editable = true;
daysGridOpts.RowHeight = 20;
daysGridOpts.HeaderRowHeight = 25;
daysGridOpts.ForceFitColumns = false;
daysGridOpts.EnableAddRow = true;
// Create Timesheet Grid
DataViewBase daysDataView = vm.Days;
List <Column> columns = new List <Column>();
GridDataViewBinder.BindRowIcon(GridDataViewBinder.AddColumn(columns, "", 50, "icon"), "activity");
XrmLookupEditor.BindColumn(GridDataViewBinder.AddColumn(columns, "Activity", 300, "activity"), vm.ActivitySearchCommand, "activityid", "subject", "activitytypecode");
GridDataViewBinder.AddColumn(columns, "Mon", 50, "day0");
GridDataViewBinder.AddColumn(columns, "Tue", 50, "day1");
GridDataViewBinder.AddColumn(columns, "Wed", 50, "day2");
GridDataViewBinder.AddColumn(columns, "Thu", 50, "day3");
GridDataViewBinder.AddColumn(columns, "Fri", 50, "day4");
GridDataViewBinder.AddColumn(columns, "Sat", 50, "day5");
GridDataViewBinder.AddColumn(columns, "Sun", 50, "day6");
daysGrid = new Grid("#timesheetGridContainer", daysDataView, columns, daysGridOpts);
GridDataViewBinder daysDataBinder = new GridDataViewBinder();
daysDataBinder.DataBindEvents(daysGrid, daysDataView, "timesheetGridContainer");
// Set the totals row meta data
daysDataView.OnGetItemMetaData += delegate(object item)
{
DayEntry day = (DayEntry)item;
if (day != null && day.isTotalRow)
{
ItemMetaData metaData = new ItemMetaData();
metaData.Editor = null;
metaData.Formatter = delegate(int row, int cell, object value, Column columnDef, object dataContext)
{
if (columnDef.Field == "activity")
{
return("Total");
}
else
{
return(Formatters.DefaultFormatter(row, cell, value, columnDef, dataContext));
}
};
metaData.CssClasses = "days_total_row";
return(metaData);
}
else
{
return(null);
}
};
daysDataBinder.DataBindSelectionModel(daysGrid, daysDataView);
// ---------------------------------------
// Sessions Grid
// ---------------------------------------
DataViewBase sessionsDataView = vm.SessionDataView;
List <Column> sessionGridCols = new List <Column>();
GridDataViewBinder.AddEditIndicatorColumn(sessionGridCols);
XrmTextEditor.BindColumn(GridDataViewBinder.AddColumn(sessionGridCols, "Description", 200, "dev1_description"));
XrmDateEditor.BindColumn(GridDataViewBinder.AddColumn(sessionGridCols, "Date", 200, "dev1_starttime"), true);
XrmTimeEditor.BindColumn(GridDataViewBinder.AddColumn(sessionGridCols, "Start", 100, "dev1_starttime")).Validator =
delegate(object value, object item)
{
dev1_session session = (dev1_session)item;
DateTime newStartTime = (DateTime)value;
ValidationResult result = new ValidationResult();
if (session.dev1_EndTime != null)
{
result.Valid = true;
string valueText = (string)value;
// Check if the end time is before the start time
bool isValid = DateTimeEx.GetTimeDuration(newStartTime) < DateTimeEx.GetTimeDuration(session.dev1_EndTime);
result.Valid = isValid;
result.Message = "The start time must be before the end time";
}
else
{
result.Valid = true;
}
return(result);
};
XrmTimeEditor.BindColumn(GridDataViewBinder.AddColumn(sessionGridCols, "End", 100, "dev1_endtime")).Validator =
delegate(object value, object item)
{
dev1_session session = (dev1_session)item;
DateTime newEndTime = (DateTime)value;
ValidationResult result = new ValidationResult();
if (session.dev1_StartTime != null)
{
result.Valid = true;
string valueText = (string)value;
// Check if the end time is before the start time
bool isValid = DateTimeEx.GetTimeDuration(session.dev1_StartTime) < DateTimeEx.GetTimeDuration(newEndTime);
result.Valid = isValid;
result.Message = "The end time must be after the start time";
}
else
{
result.Valid = true;
}
return(result);
};
XrmDurationEditor.BindColumn(GridDataViewBinder.AddColumn(sessionGridCols, "Duration", 200, "dev1_duration"));
GridDataViewBinder sessionsDataBinder = new GridDataViewBinder();
sessionsGrid = sessionsDataBinder.DataBindXrmGrid(sessionsDataView, sessionGridCols, "sessionsGridContainer", null, true, true);
sessionsDataBinder.DataBindSelectionModel(sessionsGrid, sessionsDataView);
daysGrid.OnActiveCellChanged.Subscribe(delegate(EventData e, object args)
{
CellSelection activeCell = daysGrid.GetActiveCell();
if (activeCell != null)
{
if (activeCell.Cell < 2)
{
// Whole activity is selected
vm.Days.SelectedDay = null;
}
else
{
vm.Days.SelectedDay = activeCell.Cell - 1;
}
}
});
}