protected virtual GridData InitializeChecklistExecutionAssetsGridData(HtmlHelper html, ViewContext viewContext)
{
var toolbarOptions = new GridToolBarOptions(false);
var commandOptions = new GridCommandButtonOptions(true, displayAddButtonInGridHeader: false, displayDeleteButton: false);
var gridData = new GridData(GridConstants.rigChecklistBAAssetsGrid, BaseController, "DisplayAssets", initializeCallBack: true, callBackRoute: new { Controller = BaseController, Action = "DisplayAssets" }, toolbarOptions: toolbarOptions, commandButtonOptions: commandOptions, showPager: false)
{
Title = ""
};
var assetValueCombo = new GridCombo("assetvalue", GetYesNoNaValues(), "Id", "DisplayValue", "Id");
var displayColumns = new List <GridDisplayColumn>
{
new GridDisplayColumn("GroupName", displayName: "Group", order: 30, width: 10, columnType: MVCxGridViewColumnType.TextBox, isReadOnly: true, allowEditLayout: DefaultBoolean.False, allowSort: DefaultBoolean.False, allowHeaderFilter: DefaultBoolean.False),
new GridDisplayColumn("SystemName", displayName: "System", order: 40, width: 70, columnType: MVCxGridViewColumnType.TextBox, isReadOnly: true, allowEditLayout: DefaultBoolean.False, allowSort: DefaultBoolean.False, allowHeaderFilter: DefaultBoolean.False),
new GridDisplayColumn("SubSystemName", displayName: "SubSystem", order: 40, width: 70, columnType: MVCxGridViewColumnType.TextBox, isReadOnly: true, allowEditLayout: DefaultBoolean.False, allowSort: DefaultBoolean.False, allowHeaderFilter: DefaultBoolean.False),
new GridDisplayColumn("SubSystemName", displayName: "SubSystem", order: 40, width: 70, columnType: MVCxGridViewColumnType.TextBox, isReadOnly: true, allowEditLayout: DefaultBoolean.False, allowSort: DefaultBoolean.False, allowHeaderFilter: DefaultBoolean.False),
new GridDisplayColumn("AssetValue", displayName: "Value", order: 40, width: 70, columnType: MVCxGridViewColumnType.ComboBox, allowSort: DefaultBoolean.False, allowHeaderFilter: DefaultBoolean.False, lookup: assetValueCombo),
new GridDisplayColumn("ChecklistGroupId", order: 200, width: 0, displayName: "Checklist Group Id", isVisible: false),
new GridDisplayColumn("AssetGroupId", order: 200, width: 0, displayName: "Asset Group Id", isVisible: false),
new GridDisplayColumn("SystemId", order: 200, width: 0, displayName: "System Id", isVisible: false),
new GridDisplayColumn("SubSystemId", order: 200, width: 0, displayName: "Sub System Id", isVisible: false),
new GridDisplayColumn("Id", order: 200, width: 0, displayName: "Rig Group Asset Id", isVisible: false),
};
gridData.DisplayColumns = displayColumns;
gridData.Routes.Add(new GridRoute(GridRouteTypes.Update, new { Controller = BaseController, Action = "UpdateAsset" }));
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("AssetValue", displayName: "Asset"),
new GridEditLayoutColumn("ChecklistGroupId", displayName: "Checklist Group Id"),
new GridEditLayoutColumn("Id", displayName: "Rig Group Asset Id")
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, editMode: GridViewEditingMode.EditFormAndDisplayRow
, processLayout: i =>
{
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = Unit.Percentage(100);
}
);
return(gridData);
}
private void InitializeSubChildTagGridData(GridData gridData, string createAction, string deleteAction, int id, string name)
{
gridData.ToolBarOptions.DisplayXlsExport = true;
if (ViewData["ChecklistQuestionTags"] == null)
{
ViewData["ChecklistQuestionTags"] = GetQuestionTags();
}
var oapChecklistQuestionTags = ViewData["ChecklistQuestionTags"] as ObservableCollection <OapChecklistQuestionTag>;
var oapChecklistQuestionTagsCombo = new GridCombo("OapChecklistQuestionTags", oapChecklistQuestionTags);
oapChecklistQuestionTagsCombo.DisplayColumnName = "Tag";
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("OapChecklistQuestionTagId", displayName: "Tag", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapChecklistQuestionTagsCombo, width: 100, editLayoutWidth: 45),
new GridDisplayColumn("OapChecklistQuestionId", displayName: "Question", width: 20, isVisible: false),
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = GridData.Controller, Action = "CreateChecklistQuestionTagMap" }),
//new GridRoute(GridRouteTypes.Update, new { Controller = GridData.Controller, Action = "UpdateChecklistQuestionTagMap" }),
new GridRoute(GridRouteTypes.Delete, new { Controller = GridData.Controller, Action = "DeleteChecklistQuestionTagMap" }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("OapChecklistQuestionTagId", displayName: "Tag"),
new GridEditLayoutColumn("OapChecklistQuestionId", isVisible: false)
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, i =>
{
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = System.Web.UI.WebControls.Unit.Percentage(100);
}
, columnCount: 1);
gridData.RowInitializeEvent = (s, e) =>
{
e.NewValues["OapChecklistQuestionId"] = id;
gridData.DefaultNewRowInitializeFields(e);
};
gridData.CallBackRoute = new { Controller = gridData.Controller, Action = gridData.Action, OapChecklistQuestionId = id, oapChecklistQuestionName = name };
}
private void InitializeGridData(GridData gridData, string createAction, string updateAction, string deleteAction)
{
var lkpList = Ensco.Utilities.UtilitySystem.GetLookupList("Rig");
if (lkpList == null)
{
lkpList = new LookupListModel <dynamic>();
lkpList.Items = new List <object>();
}
var items = (lkpList.Items as List <object>)?.Cast <RigModel>();
if (ViewData["Rig"] == null)
{
ViewData["Rig"] = items;
}
var oapRigs = ViewData["Rig"];
var oapRigsCombo = new GridCombo("RigModel", oapRigs);
if (ViewData["Checklists"] == null)
{
ViewData["Checklists"] = GetOapChecklists();
}
var oapChecklists = ViewData["Checklists"] as ObservableCollection <OapChecklist>;
var oapChecklistsCombo = new GridCombo("OapChecklist", oapChecklists);
if (ViewData["WorkInstruction"] == null)
{
ViewData["WorkInstruction"] = GetWorkInstructions();
}
var oapWorkInstructions = ViewData["WorkInstruction"] as ObservableCollection <OapWorkInstruction>;
var oapWorkInstructionsCombo = new GridCombo("OapWorkInstruction", oapWorkInstructions, "Id", "Title");
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("RigId", displayName: "Rig", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapRigsCombo, width: 12, editLayoutWidth: 100),
new GridDisplayColumn("OapChecklistId", displayName: "Checklist Protocol", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapChecklistsCombo, width: 20, editLayoutWidth: 100),
new GridDisplayColumn("OapWorkInstructionId", displayName: "Work Instruction", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapWorkInstructionsCombo, width: 20, editLayoutWidth: 100),
new GridDisplayColumn("Order", displayName: "Order", width: 5, editLayoutWidth: 100),
new GridDisplayColumn("Description", displayName: "Description", width: 25, editLayoutWidth: 100),
new GridDisplayColumn("StartDateTime", displayName: "Start Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, editLayoutWidth: 100, displayFormat: "g"),
new GridDisplayColumn("EndDateTime", displayName: "End Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, editLayoutWidth: 100, displayFormat: "g"),
new GridDisplayColumn("CreatedDateTime", displayName: "Date Created", isReadOnly: true, width: 0, displayFormat: "g", isVisible: false),
new GridDisplayColumn("CreatedBy", displayName: "Created By", isReadOnly: true, width: 0, isVisible: false),
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = gridData.Controller, Action = createAction }),
new GridRoute(GridRouteTypes.Update, new { Controller = gridData.Controller, Action = updateAction }),
new GridRoute(GridRouteTypes.Delete, new { Controller = gridData.Controller, Action = deleteAction }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("RigId", displayName: "Rig"),
new GridEditLayoutColumn("OapChecklistId", displayName: "Checklist / Protocol"),
new GridEditLayoutColumn("OapWorkInstructionId", displayName: "Work Instruction"),
new GridEditLayoutColumn("Order", displayName: "Order"),
new GridEditLayoutColumn("Description", displayName: "Description"),
new GridEditLayoutColumn("StartDateTime", displayName: "Start Date"),
new GridEditLayoutColumn("EndDateTime", displayName: "End Date")
};
gridData.FormLayout = new GridEditFormLayout(GridData.LayoutColumns
, i =>
{
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = System.Web.UI.WebControls.Unit.Percentage(100);
}, columnCount: 2
, editMode: GridViewEditingMode.EditFormAndDisplayRow);
}
private void InitializeGridData(HtmlHelper html, ViewContext viewContext, GridData gridData, string createAction, string updateAction, string deleteAction)
{
//if (ViewData["OapTypes"] == null)
//{
// var allOapTypes = GetOapTypes();
// ViewData["OapTypes"] = allOapTypes.Where(h => h.ParentHierarchyId == null);
// ViewData["OapSubTypes"] = allOapTypes.Where(h => h.ParentHierarchyId != null);
//}
if (ViewData["Users"] == null)
{
ViewData["Users"] = GetUsers(PeopleClient);
}
var users = ViewData["Users"] as IEnumerable <Person>;
var usersCombo = new GridCombo("Users", users);
var lkpList = Ensco.Utilities.UtilitySystem.GetLookupList("Rig");
if (lkpList == null)
{
lkpList = new LookupListModel <dynamic>();
lkpList.Items = new List <object>();
}
var items = (lkpList.Items as List <object>)?.Cast <RigModel>();
if (ViewData["Rig"] == null)
{
ViewData["Rig"] = items;
}
var oapRigs = ViewData["Rig"];
var oapRigsCombo = new GridCombo("RigModel", oapRigs);
// OapAudit t = new OapAudit();
// t.OapAuditProtocols[0].RigOapCheckListId
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("Id", displayName: "Audit Id", columnAction: c =>
{
c.FieldName = "Id";
c.Caption = Translate("Audit Id");
c.Width = Unit.Percentage(5);
c.CellStyle.HorizontalAlign = HorizontalAlign.Center;
//c.SortDescending();
c.EditorProperties().HyperLink(hl =>
{
Session["isAuditIdClick"] = false;
var url = Url.Action("Index", "OapAuditReport", new RouteValueDictionary(new { Area = "coap", Id = "{0}" }));
hl.NavigateUrlFormatString = HttpUtility.UrlDecode(url);
hl.TextField = "Id";
}
);
}),
new GridDisplayColumn("Description", displayName: "Audit Description", width: 40, editLayoutWidth: 100),
// new GridDisplayColumn("CreatedBy", displayName: "Lead Assessor", order:20,columnType:MVCxGridViewColumnType.TextBox, width:15),
new GridDisplayColumn("UpdatedBy", displayName: "Lead Assessor1", order: 45, columnType: MVCxGridViewColumnType.TextBox, width: 0, editLayoutWidth: 100,
columnAction: CommonUtilities.GetPassportColumnAction(html, viewContext, "UpdatedBy", "Assessor", Translate("Lead Assessor"), users), isVisible: false),
// new GridDisplayColumn("# Protocols", displayName:"Oap Type", columnType:MVCxGridViewColumnType.ComboBox, lookup:oapTypeCombo, width:15, editLayoutWidth:100),
new GridDisplayColumn("RigId", displayName: "Rig", width: 0, columnType: MVCxGridViewColumnType.ComboBox, lookup: oapRigsCombo, editLayoutWidth: 100, isVisible: false
),
new GridDisplayColumn("IsCVT", displayName: "Is CVT?", columnType: MVCxGridViewColumnType.CheckBox, width: 0, editLayoutWidth: 10, isVisible: false),
new GridDisplayColumn("RepeatFinding", displayName: "Repeat Findings", columnType: MVCxGridViewColumnType.CheckBox, width: 0, editLayoutWidth: 10, isVisible: false),
new GridDisplayColumn("AuditLevel", displayName: "Audit Level", columnType: MVCxGridViewColumnType.ComboBox, width: 0, editLayoutWidth: 100, isVisible: false, columnAction: c => {
c.Name = "AuditLevel";
c.Caption = "Audit Level";
c.FieldName = "AuditLevel";
c.Width = Unit.Percentage(100);
c.EditorProperties().ComboBox(cb =>
{
cb.DataSource = Enum.GetNames(typeof(AuditLevel));
cb.Width = Unit.Percentage(100);
});
}),
new GridDisplayColumn("StartDateTime", displayName: "Date Started", columnType: MVCxGridViewColumnType.DateEdit, width: 15, editLayoutWidth: 100, displayFormat: "g"
),
new GridDisplayColumn("EndDateTime", displayName: "Date Completed", columnType: MVCxGridViewColumnType.DateEdit, width: 15, editLayoutWidth: 100, displayFormat: "g"
),
new GridDisplayColumn("OapAuditProtocols", displayName: "# Prototocols", columnAction: c =>
{
c.FieldName = "OapAuditProtocols";
c.Caption = "# Protocols";
c.UnboundType = DevExpress.Data.UnboundColumnType.Integer;
c.Width = Unit.Percentage(8);
c.CellStyle.HorizontalAlign = HorizontalAlign.Center;
}
),
new GridDisplayColumn("", displayName: "# Findings", width: 10),
new GridDisplayColumn("Status", displayName: "Status", width: 10, editLayoutWidth: 100, isReadOnly: true),
new GridDisplayColumn("AuditPurpose", displayName: "Audit Purpose", columnType: MVCxGridViewColumnType.ComboBox, width: 0, editLayoutWidth: 100, isVisible: false, columnAction: c => {
c.Name = "AuditPurpose";
c.Caption = "Audit Purpose";
c.FieldName = "AuditPurpose";
c.Width = Unit.Percentage(100);
c.EditorProperties().ComboBox(cb =>
{
cb.DataSource = Enum.GetNames(typeof(AuditPurpose));
cb.Width = Unit.Percentage(100);
});
}),
//new GridDisplayColumn("CreatedBy", displayName:"Created By", isReadOnly:true, width:10),
//new GridDisplayColumn("CreatedDateTime", displayName:"Date Created", columnType:MVCxGridViewColumnType.DateEdit, width:10, isReadOnly:true, displayFormat: "g"),
//new GridDisplayColumn("UpdatedBy", displayName:"Updated By", width:10, isReadOnly:true ),
//new GridDisplayColumn("UpdatedDateTime", displayName:"Date Updated", columnType:MVCxGridViewColumnType.DateEdit, width:10, isReadOnly:true, displayFormat: "g")
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = gridData.Controller, Action = createAction }),
new GridRoute(GridRouteTypes.Update, new { Controller = gridData.Controller, Action = updateAction }),
new GridRoute(GridRouteTypes.Delete, new { Controller = gridData.Controller, Action = deleteAction }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("Description", displayName: "Description", columnType: MVCxGridViewColumnType.Memo, layoutAction: col => {
col.ColumnSpan = 2;
col.Width = Unit.Percentage(100);
}),
new GridEditLayoutColumn("RigId", displayName: "Rig", columnType: MVCxGridViewColumnType.ComboBox),
new GridEditLayoutColumn("IsCVT", displayName: "Is CVT?", columnType: MVCxGridViewColumnType.CheckBox),
new GridEditLayoutColumn("AuditLevel", displayName: "Audit Level", columnType: MVCxGridViewColumnType.ComboBox),
new GridEditLayoutColumn("RepeatFinding", displayName: "Repeat Findings", columnType: MVCxGridViewColumnType.CheckBox),
new GridEditLayoutColumn("UpdatedBy", displayName: "Lead Assessor"),
new GridEditLayoutColumn("Status", displayName: "Status"),
new GridEditLayoutColumn("AuditPurpose", displayName: "Audit Purpose", columnType: MVCxGridViewColumnType.ComboBox),
new GridEditLayoutColumn("StartDateTime", displayName: "Start Date", columnType: MVCxGridViewColumnType.DateEdit),
new GridEditLayoutColumn("EndDateTime", displayName: "End Date", columnType: MVCxGridViewColumnType.DateEdit),
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, editMode: GridViewEditingMode.PopupEditForm
, processLayout: i => {
i.ShowUpdateButton = true;
i.ShowCancelButton = true;
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
}
, columnCount: 2
, emptyLayputItemCount: 3
);
gridData.RowInitializeEvent = (s, e) =>
{
e.NewValues["UpdatedBy"] = UtilitySystem.CurrentUserId;
e.NewValues["Status"] = "Open";
e.NewValues["IsCVT"] = false;
// e.NewValues["RigId"] = -1;
e.NewValues["RepeatFinding"] = false;
e.NewValues["StartDateTime"] = string.Empty;
e.NewValues["EndDateTime"] = string.Empty;
e.NewValues["SiteId"] = UtilitySystem.Settings.ConfigSettings["SiteId"];
//gridData.DefaultNewRowInitializeFields(e);
};
}
protected virtual GridData InitializePreviousFindingsGridData(HtmlHelper html)
{
var gridData = new GridData(GridConstants.rigChecklistPreviousFindingGrid, false, true, BaseController)
{
Name = rigFindingPagePreviousFindingsGrid
};
//Finding Type dropdown
if (ViewData["FindingType"] == null)
{
ViewData["FindingType"] = GetClient <FindingTypeClient>().GetAllAsync().Result?.Result?.Data;
}
var findingTypes = ViewData["FindingType"] as IEnumerable <FindingType>;
var findingTypeCombo = new GridCombo("FindingTypeCombo", findingTypes, selectedIndexChangedEvent: "findingTypeOnSelectedeChanged");
//Finding Sub Type dropdown
if (ViewData["FindingSubType"] == null)
{
ViewData["FindingSubType"] = GetClient <FindingSubTypeClient>().GetAllAsync().Result?.Result?.Data;
}
var findingSubTypes = ViewData["FindingSubType"] as IEnumerable <FindingSubType>;
//Criticality
if (ViewData["Criticalities"] == null)
{
ViewData["Criticalities"] = GetClient <LookupClient>().GetAllCriticalityAsync().Result?.Result?.Data;
}
var criticalities = ViewData["Criticalities"] as IEnumerable <Criticality>;
var criticalityCombo = new GridCombo("CriticalitiesCombo", criticalities);
//Users
if (ViewData["Users"] == null)
{
ViewData["Users"] = GetClient <PeopleClient>().GetAllAsync().Result?.Result?.Data;
}
var users = ViewData["Users"] as IEnumerable <Person>;
var usersCombo = new GridCombo("UsersCombo", users);
var displayColumns = new List <GridDisplayColumn>
{
new GridDisplayColumn("RigChecklistFindingInternalId", order: 20, displayName: "Finding Id", isReadOnly: true, columnAction: c => {
c.FieldName = "RigChecklistFindingInternalId";
c.Caption = "Finding Id";
c.EditorProperties().HyperLink(hl =>
{
var url = Url.Action("List", gridData.EditController, new RouteValueDictionary(new { Id = "{0}" }));
hl.NavigateUrlFormatString = HttpUtility.UrlDecode(url);
hl.TextField = "RigChecklistFindingInternalId";
}
);
}, width: 30, editLayoutWidth: 100),
new GridDisplayColumn("FindingTypeId", displayName: "Finding Type", width: 40, columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, lookup: findingTypeCombo),
new GridDisplayColumn("FindingSubTypeId", displayName: "Finding Sub Type", columnType: MVCxGridViewColumnType.ComboBox, columnAction: c => {
c.Name = "FindingSubTypeId";
c.Caption = "Finding Sub Type";
c.FieldName = "FindingSubTypeId";
c.Width = Unit.Percentage(40);
c.EditorProperties().ComboBox(cb =>
{
cb.CallbackRouteValues = new { Controller = BaseController, Action = "GetFindingSubTypes", TextField = "Name", ValueField = "Id" };
cb.TextField = "Name";
cb.ValueField = "Id";
cb.DataSource = findingSubTypes;
cb.ClientSideEvents.BeginCallback = "findingSubTypeBeginCallback";
cb.ClientSideEvents.EndCallback = "findingSubTypeEndCallback";
cb.Width = Unit.Percentage(100);
});
}),
new GridDisplayColumn("CriticalityId", displayName: "Criticality", width: 15, columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, lookup: criticalityCombo),
new GridDisplayColumn("Reason", displayName: "Description", width: 40, columnType: MVCxGridViewColumnType.TextBox, editLayoutWidth: 100, isVisible: false),
new GridDisplayColumn("FindingDate", displayName: "Finding Date", width: 25, columnType: MVCxGridViewColumnType.DateEdit, displayFormat: "dd/MM/yyyy hh:mm tt", editLayoutWidth: 100, isReadOnly: true),
new GridDisplayColumn("AssignedUserId", displayName: "Assigned", width: 15, columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, lookup: usersCombo),
new GridDisplayColumn("CapaId", displayName: "CAPA", width: 30, columnType: MVCxGridViewColumnType.TextBox, editLayoutWidth: 100),
new GridDisplayColumn("Status", displayName: "Status", width: 30, columnType: MVCxGridViewColumnType.TextBox, editLayoutWidth: 100, isReadOnly: true),
new GridDisplayColumn("Id", displayName: "Finding", width: 0, columnType: MVCxGridViewColumnType.TextBox, editLayoutWidth: 100, isVisible: false)
};
gridData.DisplayColumns = displayColumns;
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, editMode: GridViewEditingMode.EditFormAndDisplayRow
, processLayout: i =>
{
i.ShowUpdateButton = false;
i.ShowCancelButton = false;
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = Unit.Percentage(100);
}
, columnCount: 2
, emptyLayputItemCount: 0
);
return(gridData);
}
private void InitializeGridData(GridData gridData, string createAction, string updateAction, string deleteAction)
{
if (ViewData["OapTypes"] == null)
{
var allOapTypes = GetOapTypes();
ViewData["OapTypes"] = allOapTypes.Where(h => h.ParentHierarchyId == null);
ViewData["OapSubTypes"] = allOapTypes.Where(h => h.ParentHierarchyId != null);
}
if (ViewData["ProtocolFormTypes"] == null)
{
ViewData["ProtocolFormTypes"] = GetOapProtocolFormTypes();
}
if (ViewData["FrequencyTypes"] == null)
{
ViewData["FrequencyTypes"] = GetOapFrequencyTypes();
}
var oapTypes = ViewData["OapTypes"] as IEnumerable <OapHierarchy>;
var oapSubTypes = ViewData["OapSubTypes"] as IEnumerable <OapHierarchy>;
var oapProtocolFormTypes = ViewData["ProtocolFormTypes"] as ObservableCollection <OapProtocolFormType>;
var oapFrequencyTypes = ViewData["FrequencyTypes"] as ObservableCollection <OapFrequencyType>;
var oapTypeCombo = new GridCombo()
{
Name = "OapType",
DataSource = oapTypes,
KeyColumnName = "Id",
DisplayColumnName = "Name",
ValueColumnName = "Id",
SelectedIndexChangedEvent = "OapTypeOnSelectedeChanged"
};
var oapSubTypeCombo = new GridCombo()
{
Name = "OapSubType",
DataSource = new ObservableCollection <OapHierarchy>(),
KeyColumnName = "Id",
DisplayColumnName = "Name",
ValueColumnName = "Id",
CallbackRouteValues = new { Controller = "OapChecklists", Action = "GetOapSubTypes", Id = "OapSubTypeId" }
};
var oapProtocolFormTypeCombo = new GridCombo()
{
Name = "OapProtocolFormType",
DataSource = oapProtocolFormTypes,
KeyColumnName = "Id",
DisplayColumnName = "Name",
ValueColumnName = "Id"
};
var oapFrequencyTypeCombo = new GridCombo()
{
Name = "OapFrequencyType",
DataSource = oapFrequencyTypes,
KeyColumnName = "Id",
DisplayColumnName = "Name",
ValueColumnName = "Id"
};
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("Name", displayName: "Name", width: 15, editLayoutWidth: 100),
new GridDisplayColumn("Description", displayName: "Description", width: 15, editLayoutWidth: 100),
new GridDisplayColumn("OapTypeId", displayName: "Oap Type", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapTypeCombo, width: 10, editLayoutWidth: 100),
new GridDisplayColumn("OapSubTypeId", displayName: "Oap Sub Type", columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, columnAction: c => {
c.Name = "OapSubTypeId";
c.Caption = "Oap Sub Type";
c.FieldName = "OapSubTypeId";
c.Width = Unit.Percentage(10);
c.EditorProperties().ComboBox(cb =>
{
cb.CallbackRouteValues = new { Controller = "OapChecklists", Action = "GetOapSubTypes", TextField = "Name", ValueField = "Id" };
cb.TextField = "Name";
cb.ValueField = "Id";
cb.DataSource = oapSubTypes;
cb.ClientSideEvents.BeginCallback = "OapSubTypeBeginCallback";
cb.ClientSideEvents.EndCallback = "OapSubTypeEndCallback";
cb.Width = Unit.Percentage(20);
});
}),
new GridDisplayColumn("OapProtocolFormTypeId", displayName: "Protocol Form Type", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapProtocolFormTypeCombo, width: 10, editLayoutWidth: 100),
new GridDisplayColumn("OapFrequencyTypeId", displayName: "Frequency Type", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapFrequencyTypeCombo, width: 10, editLayoutWidth: 100),
new GridDisplayColumn("Randomize", displayName: "Randomize", columnType: MVCxGridViewColumnType.CheckBox, width: 7),
new GridDisplayColumn("ControlNumber", displayName: "Control Number", width: 10, editLayoutWidth: 100),
new GridDisplayColumn("StartDateTime", displayName: "Start Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, editLayoutWidth: 100, displayFormat: "g"),
new GridDisplayColumn("EndDateTime", displayName: "End Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, editLayoutWidth: 100, displayFormat: "g"),
new GridDisplayColumn("CreatedBy", displayName: "Created By", isReadOnly: true, width: 0, isVisible: false),
new GridDisplayColumn("CreatedDateTime", displayName: "Date Created", columnType: MVCxGridViewColumnType.DateEdit, width: 0, isReadOnly: true, displayFormat: "g", isVisible: false),
new GridDisplayColumn("UpdatedBy", displayName: "Updated By", width: 0, isReadOnly: true, isVisible: false),
new GridDisplayColumn("UpdatedDateTime", displayName: "Date Updated", columnType: MVCxGridViewColumnType.DateEdit, width: 0, isReadOnly: true, displayFormat: "g", isVisible: false)
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = gridData.Controller, Action = createAction }),
new GridRoute(GridRouteTypes.Update, new { Controller = gridData.Controller, Action = updateAction }),
new GridRoute(GridRouteTypes.Delete, new { Controller = gridData.Controller, Action = deleteAction }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("Name", displayName: "Name"),
new GridEditLayoutColumn("Description", displayName: "Description"),
new GridEditLayoutColumn("OapTypeId", displayName: "Oap Type"),
new GridEditLayoutColumn("OapSubTypeId", displayName: "Oap Sub Type"),
new GridEditLayoutColumn("OapProtocolFormTypeId", displayName: "Oap Protocol Form Type"),
new GridEditLayoutColumn("OapFrequencyTypeId", displayName: "Oap Frequency Type"),
new GridEditLayoutColumn("Randomize", displayName: "Randomize", width: 50),
new GridEditLayoutColumn("ControlNumber", displayName: "ControlNumber"),
new GridEditLayoutColumn("StartDateTime", displayName: "Start Date", columnType: MVCxGridViewColumnType.DateEdit),
new GridEditLayoutColumn("EndDateTime", displayName: "End Date", columnType: MVCxGridViewColumnType.DateEdit),
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, editMode: GridViewEditingMode.EditFormAndDisplayRow
, processLayout: i => {
i.ShowUpdateButton = true;
i.ShowCancelButton = true;
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
}
, columnCount: 2
, emptyLayputItemCount: 1
);
}
protected virtual void InitializeRigChecklistGridData(HtmlHelper html, ViewContext viewContext, GridData gridData, string createAction, string updateAction, string deleteAction)
{
if (ViewData["Users"] == null)
{
ViewData["Users"] = CommonUtilities.GetUsers(PeopleClient);
}
var users = ViewData["Users"] as IEnumerable <Person>;
var usersCombo = new GridCombo("Users", users);
if (ViewData["Checklists"] == null)
{
ViewData["Checklists"] = GetChecklistData(true);
}
var locationLookup = OapUtilities.GetLookup <LocationModel>("Location");
var locations = new GridCombo("Location", locationLookup);
if (ViewData["Checklists"] == null)
{
ViewData["Checklists"] = GetChecklistData(true);
}
var checklists = ViewData["Checklists"] as IEnumerable <OapChecklist>;
var oapChecklistCombo = new GridCombo("OapChecklist", checklists);
var lkpList = Ensco.Utilities.UtilitySystem.GetLookupList("Position");
if (lkpList == null)
{
lkpList = new LookupListModel <dynamic>();
lkpList.Items = new List <object>();
}
var items = (lkpList.Items as List <object>)?.Cast <PositionModel>();
if (ViewData["Position"] == null)
{
ViewData["Position"] = items;
}
var positions = ViewData["Position"];
var positionsCombo = new GridCombo("PositionModel", positions);
gridData.ToolBarOptions.DisplayXlsExport = true;
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("Id", displayName: "Checklist Id", order: 10, columnAction: c => {
c.FieldName = "Id";
c.Caption = Translate("Checklist Id");
c.Width = Unit.Percentage(5);
c.CellStyle.HorizontalAlign = HorizontalAlign.Center;
c.EditorProperties().HyperLink(hl =>
{
Session["isChecklistIdClick"] = true;
var url = Url.Action("List", gridData.EditController, new RouteValueDictionary(new { Id = "{0}" }));
hl.NavigateUrlFormatString = HttpUtility.UrlDecode(url);
hl.TextField = "RigChecklistUniqueId";
}
);
}, editLayoutWidth: 100, isWidthAndHeightInPercentage: false),
new GridDisplayColumn("Title", displayName: "Title", order: 20, width: 20, editLayoutWidth: 100),
new GridDisplayColumn("Description", displayName: "Description", order: 30, width: 20, editLayoutWidth: 100, columnType: MVCxGridViewColumnType.Memo),
new GridDisplayColumn("OapchecklistId", displayName: "Checklist Type", order: 40, columnType: MVCxGridViewColumnType.ComboBox, lookup: oapChecklistCombo, width: 20, editLayoutWidth: 100),
new GridDisplayColumn("OwnerName", displayName: "Lead Assessor", order: 42, columnType: MVCxGridViewColumnType.TextBox, width: 12),
new GridDisplayColumn("OwnerId", displayName: "Lead Assessor1", order: 45, columnType: MVCxGridViewColumnType.TextBox, width: 0, editLayoutWidth: 100,
columnAction: CommonUtilities.GetPassportColumnAction(html, viewContext, "OwnerId", "Assessor", Translate("Lead Assessor"), users), isVisible: false),
new GridDisplayColumn("PositionId", displayName: "Position", columnType: MVCxGridViewColumnType.ComboBox, lookup: positionsCombo, order: 50, width: 12, editLayoutWidth: 100),
new GridDisplayColumn("ChecklistDateTime", displayName: "Checklist Date", order: 60, columnType: MVCxGridViewColumnType.DateEdit, width: 25, editLayoutWidth: 100, displayFormat: "g"),
new GridDisplayColumn("Status", displayName: "Status", order: 65, width: 15, isReadOnly: true, editLayoutWidth: 100),
new GridDisplayColumn("CreatedBy", displayName: "Created By", order: 997, isReadOnly: true, width: 0, isVisible: false),
new GridDisplayColumn("CreatedDateTime", displayName: "Date Created", order: 998, columnType: MVCxGridViewColumnType.DateEdit, width: 0, isReadOnly: true, displayFormat: "g", isVisible: false),
new GridDisplayColumn("UpdatedBy", displayName: "Updated By", order: 999, width: 0, isReadOnly: true, isVisible: false),
new GridDisplayColumn("UpdatedDateTime", displayName: "Date Updated", order: 1000, columnType: MVCxGridViewColumnType.DateEdit, width: 0, isReadOnly: true, displayFormat: "g", isVisible: false),
new GridDisplayColumn("RigChecklistUniqueId", displayName: "Checklist Id1", order: 1001, width: 0, isVisible: false),
//new GridDisplayColumn("SiteId", displayName:"Site Id", order:1010, width:0, isVisible:false)
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = gridData.Controller, Action = createAction }),
new GridRoute(GridRouteTypes.Update, new { Controller = gridData.Controller, Action = updateAction }),
new GridRoute(GridRouteTypes.Delete, new { Controller = gridData.Controller, Action = deleteAction }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("Title", displayName: "Title", layoutAction: col => {
col.Width = Unit.Percentage(100);
col.ColumnSpan = 2;
}),
new GridEditLayoutColumn("Description", displayName: "Description", columnType: MVCxGridViewColumnType.Memo, layoutAction: col => {
col.ColumnSpan = 2;
col.Width = Unit.Percentage(100);
}),
new GridEditLayoutColumn("OapchecklistId", displayName: "Checklist Type"),
new GridEditLayoutColumn("OwnerId", displayName: "Lead Assessor"),
new GridEditLayoutColumn("ChecklistDateTime", displayName: "Date & Time", columnType: MVCxGridViewColumnType.DateEdit),
new GridEditLayoutColumn("Status", displayName: "Status", isVisible: false),
new GridEditLayoutColumn("RigChecklistUniqueId", isVisible: false),
new GridEditLayoutColumn("SiteId", isVisible: false)
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, editMode: GridViewEditingMode.PopupEditForm
, processLayout: i => {
i.ShowUpdateButton = true;
i.ShowCancelButton = true;
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
}
, columnCount: 2
, emptyLayputItemCount: 3
);
gridData.RowInitializeEvent = (s, e) =>
{
e.NewValues["OwnerId"] = UtilitySystem.CurrentUserId;
e.NewValues["Status"] = "Open";
e.NewValues["ChecklistDateTime"] = DateTime.UtcNow;
//e.NewValues["SiteId"] = UtilitySystem.Settings.ConfigSettings["SiteId"];
gridData.DefaultNewRowInitializeFields(e);
};
}
private void InitializeGridData(GridData gridData, string createAction, string updateAction, string deleteAction)
{
gridData.ToolBarOptions.DisplayXlsExport = true;
if (ViewData["ChecklistLayouts"] == null)
{
ViewData["ChecklistLayouts"] = GetOapChecklistLayouts();
}
var oapChecklistLayouts = ViewData["ChecklistLayouts"] as ObservableCollection <OapChecklistLayout>;
var oapChecklistLayoutCombo = new GridCombo("OapChecklistLayout", oapChecklistLayouts);
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("Name", displayName: "Name", width: 20, editLayoutWidth: 100),
new GridDisplayColumn("Description", displayName: "Description", width: 40, editLayoutWidth: 100),
new GridDisplayColumn("IsProtocol", displayName: "Protocol", columnType: MVCxGridViewColumnType.CheckBox, width: 5, editLayoutWidth: 100),
new GridDisplayColumn("ChecklistLayoutId", displayName: "Checklist Layout", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapChecklistLayoutCombo, width: 15, editLayoutWidth: 100),
new GridDisplayColumn("StartDateTime", displayName: "Start Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, displayFormat: "g", editLayoutWidth: 100),
new GridDisplayColumn("EndDateTime", displayName: "End Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, displayFormat: "g", editLayoutWidth: 100),
new GridDisplayColumn("Code", displayName: "Code", width: 0, isVisible: false),
new GridDisplayColumn("CreatedBy", displayName: "Created By", isReadOnly: true, width: 0, isVisible: false),
new GridDisplayColumn("CreatedDateTime", displayName: "Date Created", columnType: MVCxGridViewColumnType.DateEdit, width: 0, isReadOnly: true, displayFormat: "g", isVisible: false),
new GridDisplayColumn("UpdatedBy", displayName: "Updated By", width: 0, isReadOnly: true, isVisible: false),
new GridDisplayColumn("UpdatedDateTime", displayName: "Date Updated", columnType: MVCxGridViewColumnType.DateEdit, width: 0, isReadOnly: true, displayFormat: "g", isVisible: false)
};
gridData.Buttons = new List <GridButton>()
{
new GridButton(GridButtonTypes.Add),
new GridButton(GridButtonTypes.Update),
new GridButton(GridButtonTypes.Delete),
new GridButton(GridButtonTypes.Cancel),
new GridButton(GridButtonTypes.Edit)
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = gridData.Controller, Action = createAction }),
new GridRoute(GridRouteTypes.Update, new { Controller = gridData.Controller, Action = updateAction }),
new GridRoute(GridRouteTypes.Delete, new { Controller = gridData.Controller, Action = deleteAction }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("Name", displayName: "Name"),
new GridEditLayoutColumn("Description", displayName: "Description"),
new GridEditLayoutColumn("IsProtocol", displayName: "Protocol"),
new GridEditLayoutColumn("ChecklistLayoutId", displayName: "Checklist Layout"),
new GridEditLayoutColumn("StartDateTime", displayName: "Start Date"),
new GridEditLayoutColumn("EndDateTime", displayName: "End Date"),
new GridEditLayoutColumn("Code", displayName: "Code"),
};
gridData.FormLayout = new GridEditFormLayout(GridData.LayoutColumns
, i =>
{
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = System.Web.UI.WebControls.Unit.Percentage(100);
},
columnCount: 3);
}
private void InitializeGridData(GridData gridData, string createAction, string updateAction, string deleteAction)
{
gridData.ToolBarOptions.DisplayXlsExport = true;
if (ViewData["Checklists"] == null)
{
ViewData["Checklists"] = GetOapChecklists();
}
if (ViewData["Graphics"] == null)
{
ViewData["Graphics"] = GetGraphics();
}
var oapChecklists = ViewData["Checklists"] as ObservableCollection <OapChecklist>;
var oapGraphics = ViewData["Graphics"] as ObservableCollection <OapGraphic>;
var oapChecklistCombo = new GridCombo("OapChecklist", oapChecklists);
var oapGraphicsCombo = new GridCombo("OapGraphic", oapGraphics);
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("OapChecklistId", displayName: "Checklist", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapChecklistCombo, width: 15, editLayoutWidth: 100),
new GridDisplayColumn("OapGraphicId", displayName: "Graphic", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapGraphicsCombo, width: 15, editLayoutWidth: 100),
new GridDisplayColumn("Name", displayName: "Group Name", width: 20, editLayoutWidth: 100),
new GridDisplayColumn("Description", displayName: "Group Description", width: 30, editLayoutWidth: 100),
new GridDisplayColumn("Order", displayName: "Order", columnType: MVCxGridViewColumnType.SpinEdit, width: 5, editLayoutWidth: 100, columnAction: c => {
c.FieldName = "Order";
c.Caption = Translate("Order");
c.Width = Unit.Percentage(5);
c.CellStyle.HorizontalAlign = HorizontalAlign.Left;
}),
new GridDisplayColumn("StartDateTime", displayName: "Start Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, editLayoutWidth: 100, displayFormat: "g"),
new GridDisplayColumn("EndDateTime", displayName: "End Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, editLayoutWidth: 100, displayFormat: "g"),
new GridDisplayColumn("CreatedBy", displayName: "Created By", isReadOnly: true, width: 0, isVisible: false),
new GridDisplayColumn("CreatedDateTime", displayName: "Date Created", columnType: MVCxGridViewColumnType.DateEdit, width: 0, isReadOnly: true, displayFormat: "g", isVisible: false),
new GridDisplayColumn("UpdatedBy", displayName: "Updated By", width: 0, isReadOnly: true, isVisible: false),
new GridDisplayColumn("UpdatedDateTime", displayName: "Date Updated", columnType: MVCxGridViewColumnType.DateEdit, width: 0, isReadOnly: true, displayFormat: "g", isVisible: false)
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = gridData.Controller, Action = createAction }),
new GridRoute(GridRouteTypes.Update, new { Controller = gridData.Controller, Action = updateAction }),
new GridRoute(GridRouteTypes.Delete, new { Controller = gridData.Controller, Action = deleteAction }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("OapChecklistId", displayName: "Checklist"),
new GridEditLayoutColumn("OapGraphicId", displayName: "Graphic"),
new GridEditLayoutColumn("Name", displayName: "Group Name"),
new GridEditLayoutColumn("Description", displayName: "Group Description"),
new GridEditLayoutColumn("Order", displayName: "Order"),
new GridEditLayoutColumn("StartDateTime", displayName: "Start Date"),
new GridEditLayoutColumn("EndDateTime", displayName: "End Date"),
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, editMode: GridViewEditingMode.EditFormAndDisplayRow
, processLayout: i => {
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = System.Web.UI.WebControls.Unit.Percentage(100);
}
, columnCount: 3
, emptyLayputItemCount: 1
);
}
private void InitializeGridData(GridData gridData, string createAction, string updateAction, string deleteAction)
{
gridData.ToolBarOptions.DisplayXlsExport = true;
if (ViewData["SystemGroup"] == null)
{
ViewData["SystemGroup"] = GetSystemGroups();
}
var oapSystemGroups = ViewData["SystemGroup"] as ObservableCollection <OapSystemGroup>;
var oapSystemGroupsCombo = new GridCombo("OapSystemGroup", oapSystemGroups);
if (ViewData["System"] == null)
{
ViewData["System"] = GetSystems();
}
var oapSystems = ViewData["System"] as ObservableCollection <OapSystem>;
var oapSystemsCombo = new GridCombo("OapSystem", oapSystems);
if (ViewData["SubSystem"] == null)
{
ViewData["SubSystem"] = GetSubSystems();
}
var oapSubSystems = ViewData["SubSystem"] as ObservableCollection <OapSubSystem>;
var oapSubSystemsCombo = new GridCombo("OapSubSystem", oapSubSystems);
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("Id", displayName: "ID", width: 10, editLayoutWidth: 50),
new GridDisplayColumn("OapChecklistGroupId", displayName: "Group Id", width: 20, editLayoutWidth: 50),
new GridDisplayColumn("OapSystemGroupId", displayName: "System Group", width: 15, columnType: MVCxGridViewColumnType.ComboBox, lookup: oapSystemGroupsCombo, editLayoutWidth: 50),
new GridDisplayColumn("OapSystemId", displayName: "System", width: 15, columnType: MVCxGridViewColumnType.ComboBox, lookup: oapSystemsCombo, editLayoutWidth: 50),
new GridDisplayColumn("OapSubSystemId", displayName: "Sub System", width: 15, columnType: MVCxGridViewColumnType.ComboBox, lookup: oapSubSystemsCombo, editLayoutWidth: 50),
new GridDisplayColumn("Order", displayName: "Order", width: 5, editLayoutWidth: 50),
new GridDisplayColumn("Description", displayName: "Description", width: 25, editLayoutWidth: 50),
new GridDisplayColumn("SafetyCritical", displayName: "SC", isReadOnly: true, columnType: MVCxGridViewColumnType.CheckBox, width: 10),
new GridDisplayColumn("OperationalCritical", displayName: "OC", isReadOnly: true, columnType: MVCxGridViewColumnType.CheckBox, width: 10),
new GridDisplayColumn("ClientCritical", displayName: "CC", isReadOnly: true, columnType: MVCxGridViewColumnType.CheckBox, width: 10),
new GridDisplayColumn("EnvironmentalCritical", displayName: "EC", isReadOnly: true, columnType: MVCxGridViewColumnType.CheckBox, width: 10),
new GridDisplayColumn("NonCritical", displayName: "NC", isReadOnly: true, columnType: MVCxGridViewColumnType.CheckBox, width: 10),
new GridDisplayColumn("ACritical", displayName: "AC", isReadOnly: true, columnType: MVCxGridViewColumnType.CheckBox, width: 10),
new GridDisplayColumn("ReferenceId", displayName: "Reference Id", isVisible: false, columnType: MVCxGridViewColumnType.TextBox)
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = gridData.Controller, Action = createAction }),
new GridRoute(GridRouteTypes.Update, new { Controller = gridData.Controller, Action = updateAction }),
new GridRoute(GridRouteTypes.Delete, new { Controller = gridData.Controller, Action = deleteAction }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("OapChecklistGroupId", displayName: "Group"),
new GridEditLayoutColumn("OapSystemGroupId", displayName: "System Group"),
new GridEditLayoutColumn("OapSystemId", displayName: "System"),
new GridEditLayoutColumn("OapSubSystemId", displayName: "Sub System"),
new GridEditLayoutColumn("Order", displayName: "Order"),
new GridEditLayoutColumn("Description", displayName: "Description"),
new GridEditLayoutColumn("ReferenceId", displayName: "Reference Id")
};
gridData.FormLayout = new GridEditFormLayout(GridData.LayoutColumns
, i => {
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = System.Web.UI.WebControls.Unit.Percentage(100);
}, 2
, editMode: GridViewEditingMode.EditFormAndDisplayRow);
gridData.RowInitializeEvent = (s, e) =>
{
e.NewValues["ReferenceId"] = 0;
gridData.DefaultNewRowInitializeFields(e);
};
}
private void InitializeGridData(GridData gridData, string createAction, string updateAction, string deleteAction)
{
gridData.ToolBarOptions.DisplayXlsExport = true;
if (ViewData["ChecklistGroups"] == null)
{
ViewData["ChecklistGroups"] = GetOapChecklistGroups();
}
if (ViewData["ChecklistSubGroups"] == null)
{
ViewData["ChecklistSubGroups"] = GetChecklistSubGroups();
}
var oapChecklistGroups = ViewData["ChecklistGroups"] as ObservableCollection <OapChecklistGroup>;
var oapChecklistSubGroups = ViewData["ChecklistSubGroups"] as ObservableCollection <OapChecklistSubGroup>;
var oapChecklistGroupCombo = new GridCombo("OapChecklistGroups", oapChecklistGroups);
oapChecklistGroupCombo.SelectedIndexChangedEvent = "OapChecklistGroupOnSelectedChanged";
oapChecklistGroupCombo.DisplayColumnName = "Name";
var oapChecklistSubGroupsCombo = new GridCombo("ChecklistSubGroups", oapChecklistSubGroups);
oapChecklistSubGroupsCombo.CallbackRouteValues = new { Controller = "OapChecklistTopics", Action = "GetOapChecklistSubGroups", Id = "OapChecklistSubGroupId" };
oapChecklistSubGroupsCombo.DisplayColumnName = "Name";
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("OapChecklistGroupId", displayName: "Group", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapChecklistGroupCombo, width: 15, editLayoutWidth: 100),
new GridDisplayColumn("OapChecklistSubGroupId", displayName: "Sub Group", editLayoutWidth: 100, columnAction: c => {
c.Name = "OapChecklistSubGroupId";
c.Caption = Translate("Sub Group");
c.FieldName = "OapChecklistSubGroupId";
c.Width = Unit.Percentage(15);
c.EditorProperties().ComboBox(cb =>
{
cb.CallbackRouteValues = new { Controller = "OapChecklistTopics", Action = "GetOapChecklistSubGroups", TextField = "Name", ValueField = "Id" };
cb.TextField = "Name";
cb.ValueField = "Id";
cb.DataSource = oapChecklistSubGroups;
cb.ClientSideEvents.BeginCallback = "OapChecklistSubGroupBeginCallback";
cb.ClientSideEvents.EndCallback = "OapChecklistSubGroupEndCallback";
cb.Width = Unit.Percentage(100);
});
}),
new GridDisplayColumn("Topic", displayName: "Topic", width: 20, editLayoutWidth: 100),
new GridDisplayColumn("Description", displayName: "Description", width: 30, editLayoutWidth: 100),
new GridDisplayColumn("Order", displayName: "Order", columnType: MVCxGridViewColumnType.SpinEdit, width: 5, editLayoutWidth: 100),
new GridDisplayColumn("StartDateTime", displayName: "Start Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, editLayoutWidth: 100, displayFormat: "g"),
new GridDisplayColumn("EndDateTime", displayName: "End Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, editLayoutWidth: 100, displayFormat: "g")
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = gridData.Controller, Action = createAction }),
new GridRoute(GridRouteTypes.Update, new { Controller = gridData.Controller, Action = updateAction }),
new GridRoute(GridRouteTypes.Delete, new { Controller = gridData.Controller, Action = deleteAction }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("OapChecklistGroupId", displayName: "Group"),
new GridEditLayoutColumn("OapChecklistSubGroupId", displayName: "Sub Group"),
new GridEditLayoutColumn("Topic", displayName: "Topic"),
new GridEditLayoutColumn("Order", displayName: "Order"),
new GridEditLayoutColumn("Description", displayName: "Description"),
new GridEditLayoutColumn("StartDateTime", displayName: "Start Date"),
new GridEditLayoutColumn("EndDateTime", displayName: "End Date"),
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, editMode: GridViewEditingMode.EditFormAndDisplayRow
, processLayout: i =>
{
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = System.Web.UI.WebControls.Unit.Percentage(100);
}
, columnCount: 3
, emptyLayputItemCount: 1
);
}
private void InitializeSubChildRelatedQuestionGridData(GridData gridData, string createAction, string deleteAction, int id, string name)
{
gridData.ToolBarOptions.DisplayXlsExport = true;
if (ViewData["Checklists"] == null)
{
ViewData["Checklists"] = GetOapChecklists();
}
var oapChecklists = ViewData["Checklists"] as ObservableCollection <OapChecklist>;
var oapChecklistCombo = new GridCombo("OapChecklist", oapChecklists);
oapChecklistCombo.SelectedIndexChangedEvent = "OapChecklistOnSelectedChanged";
oapChecklistCombo.DisplayColumnName = "Name";
gridData.ButtonOptions.DisplayEditButton = false;
if (ViewData["ChecklistQuestions"] == null)
{
ViewData["ChecklistQuestions"] = GetQuestions();
}
var oapChecklistQuestions = ViewData["ChecklistQuestions"] as List <OapChecklistQuestion>;
var oapChecklistQuestionsCombo = new GridCombo("oapChecklistQuestions", oapChecklistQuestions, "Id", "Question");
oapChecklistQuestionsCombo.CallbackRouteValues = new { Controller = "OapChecklistTopics", Action = "GetChecklistQuestions" };
oapChecklistQuestionsCombo.DisplayColumnName = "Question";
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("ChecklistId", displayName: "Checklist", columnType: MVCxGridViewColumnType.ComboBox, width: 25, lookup: oapChecklistCombo, editLayoutWidth: 100),
new GridDisplayColumn("OapChecklistRelatedQuestionId", displayName: "Related Question", columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, columnAction: c => {
c.Name = "OapChecklistRelatedQuestionId";
c.Caption = "Related Question";
c.FieldName = "OapChecklistRelatedQuestionId";
c.Width = Unit.Percentage(100);
c.EditorProperties().ComboBox(cb =>
{
cb.CallbackRouteValues = new { Controller = "OapChecklistTopics", Action = "GetChecklistQuestions", TextField = "Question", ValueField = "Id" };
cb.TextField = "Question";
cb.ValueField = "Id";
cb.DataSource = oapChecklistQuestions;
cb.ClientSideEvents.BeginCallback = "OapChecklistQuestionsBeginCallback";
cb.ClientSideEvents.EndCallback = "OapChecklistQuestionsEndCallback";
cb.Width = Unit.Percentage(100);
});
}),
new GridDisplayColumn("OapChecklistQuestionId", displayName: "Question", isVisible: false)
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = GridData.Controller, Action = "CreateChecklistQuestionRelatedQuestionMap" }),
//new GridRoute(GridRouteTypes.Update, new { Controller = GridData.Controller, Action = "UpdateChecklistQuestionRelatedQuestionMap" }),
new GridRoute(GridRouteTypes.Delete, new { Controller = GridData.Controller, Action = "DeleteChecklistQuestionRelatedQuestionMap" }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("ChecklistId", displayName: "Checklist"),
new GridEditLayoutColumn("OapChecklistRelatedQuestionId", displayName: "Related Question"),
new GridEditLayoutColumn("OapChecklistQuestionId", isVisible: false)
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, processLayout: i => {
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = Unit.Percentage(100);
}
, columnCount: 2);
gridData.RowInitializeEvent = (s, e) =>
{
e.NewValues["OapChecklistQuestionId"] = id;
gridData.DefaultNewRowInitializeFields(e);
};
gridData.CallBackRoute = new { Controller = gridData.Controller, Action = gridData.Action, OapChecklistQuestionId = id, oapChecklistQuestionName = name };
}
private void InitializeChildGridData(GridData gridData, string createAction, string updateAction, string deleteAction, int id, string name)
{
gridData.ToolBarOptions.DisplayXlsExport = true;
if (ViewData["ChecklistQuestionDataType"] == null)
{
ViewData["ChecklistQuestionDataType"] = GetQuestionDataTypes();
}
var oapChecklistQuestionDataTypes = ViewData["ChecklistQuestionDataType"] as ObservableCollection <OapChecklistQuestionDataType>;
var oapChecklistQuestionDataTypeCombo = new GridCombo("oapChecklistQuestionDataTypes", oapChecklistQuestionDataTypes);
if (ViewData["OapFrequency"] == null)
{
ViewData["OapFrequency"] = GetFrequencies();
}
var oapFrequencies = ViewData["OapFrequency"] as ObservableCollection <OapFrequency>;
var oapFrequencyCombo = new GridCombo("ChecklistOapFrequencies", oapFrequencies);
var radioButtonDisplayTypeId = oapChecklistQuestionDataTypes?.FirstOrDefault(dt => dt.Code.Equals("RBL", StringComparison.InvariantCultureIgnoreCase));
dynamic spinEditProperties = new System.Dynamic.ExpandoObject();
spinEditProperties.NumberType = SpinEditNumberType.Float;
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("Question", displayName: "Question", width: 15, editLayoutWidth: 100),
new GridDisplayColumn("Description", displayName: "Sub Group Description", width: 15, editLayoutWidth: 100),
new GridDisplayColumn("Help", displayName: "Help Text", width: 10),
new GridDisplayColumn("Order", displayName: "Order", columnType: MVCxGridViewColumnType.SpinEdit, width: 5, editLayoutWidth: 100),
new GridDisplayColumn("Weight", displayName: "Scoring Weight", columnType: MVCxGridViewColumnType.SpinEdit, width: 5, editLayoutWidth: 100, editorProperties: spinEditProperties),
new GridDisplayColumn("Maximum", displayName: "Scoring Max", columnType: MVCxGridViewColumnType.SpinEdit, width: 5, editLayoutWidth: 100, editorProperties: spinEditProperties),
new GridDisplayColumn("YesValue", displayName: "Yes Value", columnType: MVCxGridViewColumnType.SpinEdit, width: 5, editLayoutWidth: 100),
new GridDisplayColumn("EditNoValue", displayName: "Edit No Value", columnType: MVCxGridViewColumnType.CheckBox, width: 5, editLayoutWidth: 100),
new GridDisplayColumn("Randomize", displayName: "Randomize", columnType: MVCxGridViewColumnType.CheckBox, width: 5, editLayoutWidth: 100),
new GridDisplayColumn("OapFrequencyId", displayName: "Frequency", columnType: MVCxGridViewColumnType.ComboBox, width: 5, editLayoutWidth: 100, lookup: oapFrequencyCombo),
new GridDisplayColumn("OapChecklistQuestionDataTypeId", displayName: "Display Type", columnType: MVCxGridViewColumnType.ComboBox, width: 5, editLayoutWidth: 100, lookup: oapChecklistQuestionDataTypeCombo),
new GridDisplayColumn("StartDateTime", displayName: "Start Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, editLayoutWidth: 100, displayFormat: "g"),
new GridDisplayColumn("EndDateTime", displayName: "End Date", columnType: MVCxGridViewColumnType.DateEdit, width: 7, editLayoutWidth: 100, displayFormat: "g"),
new GridDisplayColumn("CreatedBy", displayName: "Created By", isReadOnly: true, width: 0, isVisible: false),
new GridDisplayColumn("CreatedDateTime", displayName: "Date Created", columnType: MVCxGridViewColumnType.DateEdit, width: 0, isReadOnly: true, displayFormat: "g", isVisible: false),
new GridDisplayColumn("UpdatedBy", displayName: "Updated By", width: 0, isReadOnly: true, isVisible: false),
new GridDisplayColumn("UpdatedDateTime", displayName: "Date Updated", columnType: MVCxGridViewColumnType.DateEdit, width: 0, isReadOnly: true, displayFormat: "g", isVisible: false),
new GridDisplayColumn("OapChecklistTopicId", displayName: "Checklist Topic Id", width: 0, isVisible: false)
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = GridData.Controller, Action = "CreateChecklistQuestion" }),
new GridRoute(GridRouteTypes.Update, new { Controller = GridData.Controller, Action = "UpdateChecklistQuestion" }),
new GridRoute(GridRouteTypes.Delete, new { Controller = GridData.Controller, Action = "DeleteChecklistQuestion" }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("Question", displayName: "Question"),
new GridEditLayoutColumn("Description", displayName: "Description"),
new GridEditLayoutColumn("Order", displayName: "Order"),
new GridEditLayoutColumn("Weight", displayName: "Scoring Weight"),
new GridEditLayoutColumn("Maximum", displayName: "Scoring Max"),
new GridEditLayoutColumn("YesValue", displayName: "Yes Value"),
new GridEditLayoutColumn("EditNoValue", displayName: "Edit No Value"),
new GridEditLayoutColumn("Randomize", displayName: "Randomize"),
new GridEditLayoutColumn("OapFrequencyId", displayName: "Frequency"),
new GridEditLayoutColumn("OapChecklistQuestionDataTypeId", displayName: "Display Type"),
new GridEditLayoutColumn("StartDateTime", displayName: "Start Date"),
new GridEditLayoutColumn("EndDateTime", displayName: "End Date"),
new GridEditLayoutColumn("OapChecklistTopicId", displayName: "Checklist Group Id", isVisible: false)
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, i =>
{
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = System.Web.UI.WebControls.Unit.Percentage(100);
}
, columnCount: 2
);
gridData.RowInitializeEvent = (s, e) =>
{
e.NewValues["OapChecklistTopicId"] = id;
e.NewValues["OapChecklistQuestionDataTypeId"] = radioButtonDisplayTypeId;
gridData.DefaultNewRowInitializeFields(e);
};
gridData.CallBackRoute = new { Controller = gridData.Controller, Action = gridData.Action, oapChecklistTopicId = id, oapChecklistTopicName = name };
}
protected virtual GridData InitializeChecklistFindingsGridData(HtmlHelper html)
{
var action = "DisplayFindings";
var gridData = new GridData(GridConstants.rigChecklistFindingGrid, BaseController, action, "Findings", "AddFinding", "Add Finding", "search findings", initializeCallBack: true, historicalRow: false, editController: "FindingsPage", key: "Id");
gridData.ToolBarOptions.DisplayXlsExport = true;
if (EnableSave())
{
gridData.SetGridReadOnly();
}
//Finding Type dropdown
if (ViewData["FindingType"] == null)
{
ViewData["FindingType"] = GetClient <FindingTypeClient>().GetAllAsync().Result?.Result?.Data;
}
var findingTypes = ViewData["FindingType"] as IEnumerable <FindingType>;
var findingTypeCombo = new GridCombo("FindingTypeCombo", findingTypes, selectedIndexChangedEvent: "findingTypeOnSelectedeChanged");
//Finding Sub Type dropdown
if (ViewData["FindingSubType"] == null)
{
ViewData["FindingSubType"] = GetClient <FindingSubTypeClient>().GetAllAsync().Result?.Result?.Data;
}
var findingSubTypes = ViewData["FindingSubType"] as IEnumerable <FindingSubType>;
if (ViewData["Criticalities"] == null)
{
ViewData["Criticalities"] = GetClient <LookupClient>().GetAllCriticalityAsync().Result?.Result?.Data;
}
var criticalities = ViewData["Criticalities"] as IEnumerable <Criticality>;
var criticalityCombo = new GridCombo("CriticalitiesCombo", criticalities);
var questionsCombo = new GridCombo("QuestionsCombo", Questions, keyColumnName: "Id", displayColumnName: "OapChecklistQuestion.Question");
var displayColumns = new List <GridDisplayColumn>
{
new GridDisplayColumn("RigChecklistFindingInternalId", order: 10, displayName: "Finding Id", isReadOnly: true, columnAction: c => {
c.FieldName = "RigChecklistFindingInternalId";
c.Caption = Translate("Finding Id");
c.CellStyle.HorizontalAlign = HorizontalAlign.Center;
c.SetDataItemTemplateContent(container => {
html.DevExpress().HyperLink(hl =>
{
var id = DataBinder.Eval(container.DataItem, "Id");
var internalId = DataBinder.Eval(container.DataItem, "RigChecklistFindingInternalId");
var url = Url.Action("List", gridData.EditController, new RouteValueDictionary(new { Id = id, checklistId = Protocol.Id }));
hl.NavigateUrl = HttpUtility.UrlDecode(url);
hl.Properties.Text = internalId.ToString();
}).Render();
});
}, width: 30, editLayoutWidth: 100),
new GridDisplayColumn("RigOapChecklistQuestionId", order: 20, displayName: Translate("Question"), width: 40, columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, lookup: questionsCombo),
new GridDisplayColumn("FindingTypeId", order: 30, displayName: Translate("Finding Type"), width: 20, columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, lookup: findingTypeCombo),
new GridDisplayColumn("FindingSubTypeId", order: 40, displayName: "Finding Sub Type", columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, columnAction: c => {
c.Name = "FindingSubTypeId";
c.Caption = Translate("Finding Sub Type");
c.FieldName = "FindingSubTypeId";
c.Width = Unit.Percentage(20);
c.EditorProperties().ComboBox(cb =>
{
cb.CallbackRouteValues = new { Controller = BaseController, Action = "GetFindingSubTypes", TextField = "Name", ValueField = "Id" };
cb.TextField = "Name";
cb.ValueField = "Id";
cb.DataSource = findingSubTypes;
cb.ClientSideEvents.BeginCallback = "findingSubTypeBeginCallback";
cb.ClientSideEvents.EndCallback = "findingSubTypeEndCallback";
cb.Width = Unit.Percentage(100);
});
}),
new GridDisplayColumn("CriticalityId", order: 50, displayName: "Criticality", width: 10, columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, lookup: criticalityCombo),
new GridDisplayColumn("FindingDate", order: 60, displayName: "Finding Date", width: 20, columnType: MVCxGridViewColumnType.DateEdit, displayFormat: "g", editLayoutWidth: 100, isReadOnly: true),
new GridDisplayColumn("IsRepeat", order: 70, displayName: "Repeat", columnType: MVCxGridViewColumnType.CheckBox, width: 20, editLayoutWidth: 100),
new GridDisplayColumn("Status", order: 80, displayName: "Status", width: 25, columnType: MVCxGridViewColumnType.TextBox, editLayoutWidth: 100, isReadOnly: true),
new GridDisplayColumn("Reason", order: 100, displayName: "Description", width: 40, columnType: MVCxGridViewColumnType.TextBox, editLayoutWidth: 100, isVisible: false),
new GridDisplayColumn("Id", order: 200, displayName: "Finding", width: 0, columnType: MVCxGridViewColumnType.TextBox, editLayoutWidth: 100, isVisible: false)
};
gridData.DisplayColumns = displayColumns;
gridData.Routes.Add(new GridRoute(GridRouteTypes.Add, new { Controller = BaseController, Action = "CreateFinding" }));
gridData.Routes.Add(new GridRoute(GridRouteTypes.Update, new { Controller = BaseController, Action = "UpdateFinding" }));
gridData.Routes.Add(new GridRoute(GridRouteTypes.Delete, new { Controller = BaseController, Action = "DeleteFinding" }));
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("RigOapChecklistQuestionId", displayName: "Question"),
new GridEditLayoutColumn("FindingDate", displayName: "Finding Date"),
new GridEditLayoutColumn("FindingTypeId", displayName: "Finding Type"),
new GridEditLayoutColumn("FindingSubTypeId", displayName: "Finding Sub Type"),
new GridEditLayoutColumn("Criticality", displayName: "Criticality"),
new GridEditLayoutColumn("Reason", displayName: "Description"),
new GridEditLayoutColumn("Status", displayName: "Status"),
new GridEditLayoutColumn("Id", displayName: "Id", isVisible: false)
};
gridData.RowInitializeEvent = (s, e) =>
{
e.NewValues["Id"] = Guid.Empty;
e.NewValues["FindingDate"] = DateTime.UtcNow;
e.NewValues["Status"] = "Open";
gridData.DefaultNewRowInitializeFields(e);
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, editMode: GridViewEditingMode.EditFormAndDisplayRow
, processLayout: i =>
{
i.ShowUpdateButton = true;
i.ShowCancelButton = true;
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = Unit.Percentage(100);
}
, columnCount: 2
, emptyLayputItemCount: 0
);
return(gridData);
}
protected override void InitializeRigChecklistGridData(HtmlHelper html, ViewContext viewContext, GridData gridData, string createAction, string updateAction, string deleteAction)
{
gridData.EditController = "OapProtocol";
base.InitializeRigChecklistGridData(html, viewContext, gridData, createAction, updateAction, deleteAction);
if (ViewData["Protocols"] == null)
{
ViewData["Protocols"] = GetProtocols();
}
var protocols = ViewData["Protocols"] as IEnumerable <OapChecklist>;
var oapProtocolsCombo = new GridCombo("OapChecklist", protocols);
//Remove Display Columns
var columnId = gridData.DisplayColumns.ToList().FirstOrDefault(c => c.Name.Equals("Id"));
gridData.DisplayColumns.Remove(columnId);
var columnTitle = gridData.DisplayColumns.ToList().FirstOrDefault(c => c.Name.Equals("Title"));
gridData.DisplayColumns.Remove(columnTitle);
var columnProtocols = gridData.DisplayColumns.ToList().FirstOrDefault(c => c.Name.Equals("OapchecklistId"));
gridData.DisplayColumns.Remove(columnProtocols);
var columnDescription = gridData.DisplayColumns.ToList().FirstOrDefault(c => c.Name.Equals("Description"));
gridData.DisplayColumns.Remove(columnDescription);
var columnPosition = gridData.DisplayColumns.ToList().FirstOrDefault(c => c.Name.Equals("PositionId"));
gridData.DisplayColumns.Remove(columnPosition);
var columnChecklistDateTime = gridData.DisplayColumns.ToList().FirstOrDefault(c => c.Name.Equals("ChecklistDateTime"));
gridData.DisplayColumns.Remove(columnChecklistDateTime);
//Add Display Columns
gridData.DisplayColumns.Insert(1,
new GridDisplayColumn("Id", displayName: "Checklist Id", order: 10, columnAction: c =>
{
c.FieldName = "Id";
c.Caption = Translate("Checklist Id");
c.Width = Unit.Percentage(5);
c.CellStyle.HorizontalAlign = HorizontalAlign.Center;
c.EditorProperties().HyperLink(hl =>
{
Session["isChecklistIdClick"] = true;
var url = Url.Action("List", gridData.EditController, new RouteValueDictionary(new { Id = "{0}" }));
hl.NavigateUrlFormatString = HttpUtility.UrlDecode(url);
hl.TextField = "RigChecklistUniqueId";
}
);
}));
gridData.DisplayColumns.Insert(2, new GridDisplayColumn("OapchecklistId", displayName: "Protocol", order: 20, columnType: MVCxGridViewColumnType.ComboBox, lookup: oapProtocolsCombo, width: 20, editLayoutWidth: 100));
gridData.DisplayColumns.Insert(2, new GridDisplayColumn("OapchecklistId", editLayoutWidth: 100, editLayoutHeight: 100, isVisible: false, columnAction: c =>
{
c.FieldName = "OapchecklistId";
c.Caption = Translate("Protocol");
//c.Width = Unit.Percentage(20);
c.SetEditItemTemplateContent(con =>
{
html.DevExpress().DropDownEdit(dd =>
{
dd.Name = "OapChecklistId";
dd.Width = Unit.Percentage(100);
dd.Height = Unit.Percentage(100);
dd.SetDropDownWindowTemplateContent(cc =>
{
html.DevExpress().ListBox(listBoxSettings =>
{
listBoxSettings.Name = "checkProtocolListBox";
listBoxSettings.ControlStyle.Border.BorderWidth = 0;
listBoxSettings.ControlStyle.BorderBottom.BorderWidth = 1;
listBoxSettings.ControlStyle.BorderBottom.BorderColor = Color.FromArgb(0xDCDCDC);
listBoxSettings.Height = Unit.Pixel(200);
listBoxSettings.Width = Unit.Percentage(100);
listBoxSettings.Properties.TextField = oapProtocolsCombo.DisplayColumnName;
listBoxSettings.Properties.ValueField = oapProtocolsCombo.KeyColumnName;
//listBoxSettings.Properties.EnableSelectAll = true;
listBoxSettings.Properties.FilteringSettings.ShowSearchUI = true;
listBoxSettings.Properties.SelectionMode = ListEditSelectionMode.CheckColumn;
listBoxSettings.Properties.ClientSideEvents.SelectedIndexChanged = "updateText";
listBoxSettings.Properties.ClientSideEvents.Init = "updateText";
}).BindList(oapProtocolsCombo.DataSource).GetHtml();
});
dd.Properties.AnimationType = AnimationType.None;
dd.Properties.ClientSideEvents.TextChanged = "synchronizeListBoxValues";
dd.Properties.ClientSideEvents.DropDown = "synchronizeListBoxValues";
}).GetHtml();
});
})); //added for multi select of protocols
gridData.DisplayColumns.Insert(3, new GridDisplayColumn("OapType", displayName: "OAP Type", order: 30, width: 20));
//Add EditLayout Columns
var editColumnTitle = gridData.LayoutColumns.ToList().FirstOrDefault(c => c.Name.Equals("Title"));
gridData.LayoutColumns.Remove(editColumnTitle);
var editColumnDescription = gridData.LayoutColumns.ToList().FirstOrDefault(c => c.Name.Equals("Description"));
gridData.LayoutColumns.Remove(editColumnDescription);
var editColumnChecklistDateTime = gridData.LayoutColumns.ToList().FirstOrDefault(c => c.Name.Equals("ChecklistDateTime"));
gridData.LayoutColumns.Remove(editColumnChecklistDateTime);
var editColumnOapchecklistId = gridData.LayoutColumns.ToList().FirstOrDefault(c => c.Name.Equals("OapchecklistId"));
if (editColumnOapchecklistId != null)
{
editColumnOapchecklistId.DisplayName = "Protocol Type";
}
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, editMode: GridViewEditingMode.PopupEditForm
, processLayout: i =>
{
i.ShowUpdateButton = true;
i.ShowCancelButton = true;
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
}
, emptyLayputItemCount: 2
);
}
private void InitializeGridData(GridData gridData, string createAction, string updateAction, string deleteAction)
{
if (ViewData["OapProtocols"] == null)
{
var allOapProtocols = GetProtocols();
ViewData["OapProtocols"] = allOapProtocols;
}
if (ViewData["ProtocolQuestions"] == null)
{
ViewData["ProtocolQuestions"] = GetOapProtocolQuestions();
}
var oapProtocols = ViewData["OapProtocols"] as IEnumerable <OapChecklist>;
var oapProtocolQuestions = ViewData["ProtocolQuestions"] as IEnumerable <OapChecklistQuestion>;
var oapProtocolCombo = new GridCombo()
{
Name = "OapProtocol",
DataSource = oapProtocols,
KeyColumnName = "Id",
DisplayColumnName = "Name",
ValueColumnName = "Id",
SelectedIndexChangedEvent = "OapProtocolOnSelectedeChanged"
};
var oapProtocolQuestionCombo = new GridCombo()
{
Name = "OapProtocolQuestion",
DataSource = oapProtocolQuestions,
KeyColumnName = "Id",
DisplayColumnName = "Name",
ValueColumnName = "Id",
CallbackRouteValues = new { Controller = "OapProtocolQuestionHeaders", Action = "GetOapProtocolQuestions", Id = "OapSubTypeId" }
};
gridData.DisplayColumns = new List <GridDisplayColumn>()
{
new GridDisplayColumn("Section", displayName: "Section", width: 15, editLayoutWidth: 25),
new GridDisplayColumn("Description", displayName: "Description", width: 25, editLayoutWidth: 30),
new GridDisplayColumn("OapProtocolId", displayName: "Protocol", columnType: MVCxGridViewColumnType.ComboBox, lookup: oapProtocolCombo, width: 15, editLayoutWidth: 20),
new GridDisplayColumn("OapChecklistQuestionId", displayName: "Question", columnType: MVCxGridViewColumnType.ComboBox, columnAction: c => {
c.Name = "OapChecklistQuestionId";
c.Caption = "Question";
c.FieldName = "OapChecklistQuestionId";
c.Width = Unit.Percentage(15);
c.EditorProperties().ComboBox(cb =>
{
cb.CallbackRouteValues = new { Controller = "OapProtocolQuestionHeaders", Action = "GetProtocolQuestions", TextField = "Name", ValueField = "Id" };
cb.TextField = "Name";
cb.ValueField = "Id";
cb.DataSource = oapProtocolQuestions;
cb.ClientSideEvents.BeginCallback = "OapProtocolQuestionBeginCallback";
cb.ClientSideEvents.EndCallback = "OapProtocolQuestionEndCallback";
cb.Width = Unit.Percentage(20);
});
}),
new GridDisplayColumn("Criticality", displayName: "Criticality", columnType: MVCxGridViewColumnType.ComboBox, lookup: CommonDataLists.GetCriticalityCombo(), width: 15, editLayoutWidth: 20),
new GridDisplayColumn("BasicCause", displayName: "BasicCause", width: 15, editLayoutWidth: 20),
new GridDisplayColumn("StartDateTime", displayName: "Start Date", columnType: MVCxGridViewColumnType.DateEdit, width: 10, editLayoutWidth: 30, displayFormat: "g"),
new GridDisplayColumn("EndDateTime", displayName: "End Date", columnType: MVCxGridViewColumnType.DateEdit, width: 10, editLayoutWidth: 30, displayFormat: "g"),
new GridDisplayColumn("CreatedBy", displayName: "Created By", isReadOnly: true, width: 10),
new GridDisplayColumn("CreatedDateTime", displayName: "Date Created", columnType: MVCxGridViewColumnType.DateEdit, width: 10, isReadOnly: true, displayFormat: "g"),
new GridDisplayColumn("UpdatedBy", displayName: "Updated By", width: 10, isReadOnly: true),
new GridDisplayColumn("UpdatedDateTime", displayName: "Date Updated", columnType: MVCxGridViewColumnType.DateEdit, width: 10, isReadOnly: true, displayFormat: "g")
};
gridData.Routes = new List <GridRoute>()
{
new GridRoute(GridRouteTypes.Add, new { Controller = gridData.Controller, Action = createAction }),
new GridRoute(GridRouteTypes.Update, new { Controller = gridData.Controller, Action = updateAction }),
new GridRoute(GridRouteTypes.Delete, new { Controller = gridData.Controller, Action = deleteAction }),
};
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("Section", displayName: "Section", width: 50),
new GridEditLayoutColumn("Description", displayName: "Description", width: 50),
new GridEditLayoutColumn("OapProtocolId", displayName: "Protocol", width: 50),
new GridEditLayoutColumn("OapChecklistQuestionId", displayName: "Question", width: 50),
new GridEditLayoutColumn("Criticality", displayName: "Criticality", width: 50),
new GridEditLayoutColumn("BasicCause", displayName: "BasicCause", width: 50),
new GridEditLayoutColumn("StartDateTime", displayName: "Start Date", columnType: MVCxGridViewColumnType.DateEdit, width: 50),
new GridEditLayoutColumn("EndDateTime", displayName: "End Date", columnType: MVCxGridViewColumnType.DateEdit, width: 50),
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, editMode: GridViewEditingMode.EditFormAndDisplayRow
, processLayout: i => {
i.ShowUpdateButton = true;
i.ShowCancelButton = true;
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
}
, columnCount: 2
, emptyLayputItemCount: 1
);
}
protected virtual GridData InitializeChecklistFindingsGridData(HtmlHelper html)
{
var action = "DisplayFindings";
var gridData = new GridData(GridConstants.rigChecklistFindingGrid, BaseController, action, "Findings", "AddNewFinding", "Add Finding", "search findings", initializeCallBack: true, historicalRow: false, editController: "FindingsPage", key: "Id");
gridData.ToolBarOptions.DisplayXlsExport = true;
if (!EnableSave())
{
gridData.SetGridReadOnly();
}
if (ViewData["FindingType"] == null)
{
ViewData["FindingType"] = CommonUtilities.GetFindingTypes(GetClient <FindingTypeClient>());
}
if (ViewData["FindingSubType"] == null)
{
ViewData["FindingSubType"] = CommonUtilities.GetFindingSubTypes(GetClient <FindingSubTypeClient>());
}
if (ViewData["Criticalities"] == null)
{
ViewData["Criticalities"] = CommonUtilities.GetCriticalities(GetClient <LookupClient>());
}
var questions = (from q in Questions
select q.OapChecklistQuestion).ToList();
var questionsCombo = new GridCombo("QuestionsCombo", Questions, keyColumnName: "Id", displayColumnName: "Question");
var findingTypes = ViewData["FindingType"] as IEnumerable <FindingType>;
var findingTypeCombo = new GridCombo("FindingTypeCombo", findingTypes, selectedIndexChangedEvent: "findingTypeOnSelectedeChanged");
var findingSubTypes = ViewData["FindingSubType"] as IEnumerable <FindingSubType>;
var criticalities = ViewData["Criticalities"] as IEnumerable <Criticality>;
var criticalityCombo = new GridCombo("CriticalitiesCombo", criticalities);
//dynamic lkpList = new List<object>();
//var capaItems = new List<CapaLookupModel>();
//if (Session["CapaId"] == null)
//{
// lkpList = Ensco.Utilities.UtilitySystem.GetLookupList("Capa");
// lkpList.BoundFieldName = "CapaId";
// lkpList.DisplayField = "ActionRequired";
// Session["CapaId"] = lkpList;
//}
//else
//{
// lkpList = Session["CapaId"];
//}
//if (lkpList == null)
//{
// lkpList = new LookupListModel<dynamic>();
// lkpList.Items = new List<object>();
//}
//else
//{
// capaItems.AddRange((lkpList.Items as List<object>)?.Cast<CapaLookupModel>());
//}
var displayColumns = new List <GridDisplayColumn>
{
new GridDisplayColumn("RigChecklistFindingInternalId", order: 10, displayName: "Finding Id", isReadOnly: true, columnAction: c => {
c.FieldName = "RigChecklistFindingInternalId";
c.Caption = Translate("Finding Id");
c.CellStyle.HorizontalAlign = HorizontalAlign.Center;
c.SetDataItemTemplateContent(container => {
html.DevExpress().HyperLink(hl =>
{
var id = DataBinder.Eval(container.DataItem, "Id");
var internalId = DataBinder.Eval(container.DataItem, "RigChecklistFindingInternalId");
var url = Url.Action("List", gridData.EditController, new RouteValueDictionary(new { Id = id, checklistId = RigChecklist.Id }));
hl.NavigateUrl = HttpUtility.UrlDecode(url);
hl.Properties.Text = internalId.ToString();
}
).Render();
});
}, width: 30, editLayoutWidth: 100),
new GridDisplayColumn("RigOapChecklistQuestionId", order: 20, displayName: Translate("Question"), width: 40, columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, lookup: questionsCombo),
new GridDisplayColumn("FindingTypeId", order: 30, displayName: Translate("Finding Type"), width: 20, columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, lookup: findingTypeCombo),
new GridDisplayColumn("FindingSubTypeId", order: 40, displayName: "Finding Sub Type", columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, columnAction: c => {
c.Name = "FindingSubTypeId";
c.Caption = Translate("Finding Sub Type");
c.FieldName = "FindingSubTypeId";
c.Width = Unit.Percentage(20);
c.EditorProperties().ComboBox(cb =>
{
cb.CallbackRouteValues = new { Controller = BaseController, Action = "GetFindingSubTypes", TextField = "Name", ValueField = "Id" };
cb.TextField = "Name";
cb.ValueField = "Id";
cb.DataSource = findingSubTypes;
cb.ClientSideEvents.BeginCallback = "findingSubTypeBeginCallback";
cb.ClientSideEvents.EndCallback = "findingSubTypeEndCallback";
cb.Width = Unit.Percentage(100);
});
}),
new GridDisplayColumn("CriticalityId", order: 50, displayName: "Criticality", width: 10, columnType: MVCxGridViewColumnType.ComboBox, editLayoutWidth: 100, lookup: criticalityCombo),
new GridDisplayColumn("FindingDate", order: 60, displayName: "Finding Date", width: 20, columnType: MVCxGridViewColumnType.DateEdit, displayFormat: "g", editLayoutWidth: 100, isReadOnly: true),
new GridDisplayColumn("IsRepeat", order: 70, displayName: "Repeat", columnType: MVCxGridViewColumnType.CheckBox, width: 20, editLayoutWidth: 100),
new GridDisplayColumn("Status", order: 80, displayName: "Status", width: 25, columnType: MVCxGridViewColumnType.TextBox, editLayoutWidth: 100, isReadOnly: true),
//new GridDisplayColumn(
// "CapaId", order:90, displayName: "CAPA",
// width: 30, columnType: MVCxGridViewColumnType.TextBox, editLayoutWidth:100,isVisible:false ),
//columnAction: (column) => {
// column.Name = "Capa";
// column.FieldName = "CapaId";
// column.Caption = Translate("CAPA");
// column.SetDataItemTemplateContent( cont => {
// if (int.TryParse(DataBinder.Eval(cont.DataItem,"CapaId")?.ToString(),out int capaId))
// {
// var capa = capaItems.FirstOrDefault(m => m.Id == capaId);
// html.ViewContext.Writer.Write(capa?.Name);
// }
// });
// column.SetEditItemTemplateContent(cont => {
// html.RenderAction("GridLookupPartial", "Common", new { Area = "Common", name = column.FieldName, lookup = "Capa", multi = false, selected = DataBinder.Eval(cont.DataItem,"CapaId"), displayField = "ActionRequired" });
// });
//}),
new GridDisplayColumn("Reason", order: 100, displayName: "Description", width: 40, columnType: MVCxGridViewColumnType.TextBox, editLayoutWidth: 100, isVisible: false),
new GridDisplayColumn("Id", order: 200, displayName: "Finding", width: 0, columnType: MVCxGridViewColumnType.TextBox, editLayoutWidth: 100, isVisible: false)
};
gridData.DisplayColumns = displayColumns;
gridData.Routes.Add(new GridRoute(GridRouteTypes.Add, new { Controller = BaseController, Action = "CreateFinding" }));
gridData.Routes.Add(new GridRoute(GridRouteTypes.Update, new { Controller = BaseController, Action = "UpdateFinding" }));
gridData.Routes.Add(new GridRoute(GridRouteTypes.Delete, new { Controller = BaseController, Action = "DeleteFinding" }));
gridData.LayoutColumns = new List <GridEditLayoutColumn>()
{
new GridEditLayoutColumn("RigOapChecklistQuestionId", displayName: "Question"),
new GridEditLayoutColumn("FindingDate", displayName: "Finding Date"),
new GridEditLayoutColumn("FindingTypeId", displayName: "Finding Type"),
new GridEditLayoutColumn("FindingSubTypeId", displayName: "Finding Sub Type"),
new GridEditLayoutColumn("Criticality", displayName: "Criticality"),
new GridEditLayoutColumn("Reason", displayName: "Description"),
new GridEditLayoutColumn("Status", displayName: "Status"),
//new GridEditLayoutColumn("CapaId", displayName:"CAPA"),
new GridEditLayoutColumn("Id", displayName: "Id", isVisible: false)
};
gridData.RowInitializeEvent = (s, e) =>
{
e.NewValues["Id"] = Guid.Empty;
e.NewValues["FindingDate"] = DateTime.UtcNow;
e.NewValues["Status"] = "Open";
gridData.DefaultNewRowInitializeFields(e);
};
gridData.FormLayout = new GridEditFormLayout(
gridData.LayoutColumns
, editMode: GridViewEditingMode.EditFormAndDisplayRow
, processLayout: i =>
{
i.ShowUpdateButton = true;
i.ShowCancelButton = true;
i.HorizontalAlign = FormLayoutHorizontalAlign.Right;
i.Width = Unit.Percentage(100);
}
, columnCount: 2
, emptyLayputItemCount: 0
);
return(gridData);
}
