/// <summary> /// Index table configuration /// </summary> public static DataTableConfig TestTable() { var table = new DataTableConfig <Person, Guid>("PersonsTest_Index"); table.AddProperty(e => e.User.UserName, c => c.Caption("Username").SortAscending()); table.AddProperty(e => e.FirstName); table.AddProperty(e => e.LastName); table.AddProperty(e => e.EmailAddress1); table.AddProperty(e => e.MobileNumber1); table.AddProperty(e => e.TypeOfAccount); table.AddProperty(e => e.AreaLevel1, c => c.Caption("Area1")); table.AddProperty(e => e.User.LastLoginDate, c => c.Caption("Last log in")); table.AddProperty(e => e.IsLocked); table.AddProperty(e => e.CreationTime, c => c.Caption("Created On") /*.Visible(false)*/); table.AddProperty(e => e.LastModificationTime, c => c.Caption("Updated On").Visible(false)); table.AddProperty(e => e.IsContractor); table.OnRequestToFilterStatic = (criteria, input) => { criteria.FilterClauses.Add($"{nameof(Person.User)} != null"); }; return(table); }
public static DataTableConfig <ScheduledJobExecution, Guid> JobExecutionsTable() { var table = new DataTableConfig <ScheduledJobExecution, Guid>("ScheduledJob_Executions_test"); table.UseDtos = true; table.DetailsUrl = url => "/api/services/Scheduler/ScheduledJobExecution/Get"; table.CreateUrl = url => "/api/services/Scheduler/ScheduledJobExecution/Create"; table.UpdateUrl = url => "/api/services/Scheduler/ScheduledJobExecution/Update"; table.DeleteUrl = url => "/api/services/Scheduler/ScheduledJobExecution/Delete"; table.AddProperty(e => e.StartedOn, m => m.SortDescending()); //table.AddHtmlColumn("triggerLink", // (e, html, url) => e.Trigger != null // ? html.SPAActionLink($"{e.Trigger.Description} ({e.Trigger.CronString})", "Details", "ScheduledJobTrigger", new { id = e.Trigger.Id }).ToString() // : "-", c => c.Caption("Trigger")); table.AddProperty(e => e.FinishedOn); table.AddProperty(e => e.Status); table.AddProperty(e => e.StartedBy); table.AddProperty(e => e.ErrorMessage); //table.AddHtmlColumn("LogFile", // (e, html, url) => !string.IsNullOrWhiteSpace(e.LogFilePath) // ? html.Shesha().AjaxDownload(url.Action("Download", "VirtualFile", new { path = e.LogFilePath }), Path.GetFileName(e.LogFilePath)).ToHtmlString() // : null, // t => t.Caption("Log File").WidthPixels(150)); return(table); }
/// <summary> /// Custom Index table configuration /// </summary> public static DataTableConfig BackupFilesIndex() { var table = new DataTableConfig <BackupFileDto, int>("BackupFiles_Index"); table.AddProperty(e => e.FileName); return(table); }
/// <summary> /// Index table configuration /// </summary> /// <returns></returns> public static DataTableConfig IndexTable() { var table = new DataTableConfig <CheckList, Guid>("CheckList_Index"); table.AddProperty(e => e.Name); table.AddProperty(e => e.Description); return(table); }
/// <summary> /// Mobile Devices index table /// </summary> /// <returns></returns> public static DataTableConfig IndexTable() { var table = new DataTableConfig <MobileDevice, Guid>("MobileDevices_Index"); table.AddProperty(e => e.Name, c => c.SortAscending()); table.AddProperty(e => e.IMEI); table.AddProperty(e => e.CreatorUser.UserName, c => c.Caption("Created By")); table.AddProperty(e => e.CreationTime, c => c.Caption("Created On")); table.AddProperty(e => e.IsLocked); return(table); }
/// <summary> /// Mobile Devices index table /// </summary> /// <returns></returns> public static DataTableConfig IndexTable() { var table = new DataTableConfig <ReferenceList, Guid>("ReferenceLists_Index"); table.AddProperty(e => e.Name, c => c.SortAscending()); table.AddProperty(e => e.Namespace); table.AddProperty(e => e.Description); table.AddProperty(e => e.HardLinkToApplication); table.AddProperty(e => e.CreationTime, c => c.Caption("Created On")); return(table); }
/// <summary> /// Index table configuration /// </summary> /// <returns></returns> public static DataTableConfig IndexTable() { var table = new DataTableConfig <ScheduledJob, Guid>("ScheduledJob_Index"); table.AddProperty(e => e.JobNamespace, m => m.WidthPixels(105)); table.AddProperty(e => e.JobName, m => m.WidthPixels(235)); table.AddProperty(e => e.JobDescription, m => m.WidthPixels(350)); table.AddProperty(e => e.StartupMode, m => m.WidthPixels(80)); table.AddProperty(e => e.JobStatus, m => m.WidthPixels(70)); return(table); }
/// <summary> /// Notifications index table /// </summary> /// <returns></returns> public static DataTableConfig IndexTable() { var table = new DataTableConfig <Notification, Guid>("Notifications_Index"); table.AddProperty(e => e.Name, c => c.SortAscending()); table.AddProperty(e => e.Description); table.AddProperty(e => e.CreationTime, c => c.Caption("Created On").Visible(false)); table.AddProperty(e => e.LastModificationTime, c => c.Caption("Updated On").Visible(false)); return(table); }
public string GetDarpperUpdateSql(DataTableConfig config) { string update = "update [" + config.TableName + "] set "; foreach (var column in config.Column) { update += "[" + (column.Alias ?? column.Name) + "]=@" + column.Name + ","; } update = update.Trim(','); update += " where " + (config.Key.Alias ?? config.Key.Name) + "=@" + (config.Key.Alias ?? config.Key.Name); return(update); }
/// <summary> /// Custom Index table configuration /// </summary> public static DataTableConfig IndexTableFull() { var table = new DataTableConfig <EntityHistoryItemDto, int>("EntityHistoryFull_Index"); table.AddProperty(e => e.EventText, p => p.WidthPixels(185)); table.AddProperty(e => e.ExtendedDescription); table.AddProperty(e => e.UserFullName, p => p.WidthPixels(130)); table.AddProperty(e => e.CreationTime, p => p.WidthPixels(160)); table.AddProperty(e => e.EntityTypeFullName, c => c.Visible(false).AllowShowHide(false)); table.AddProperty(e => e.EntityId, c => c.Visible(false).AllowShowHide(false)); return(table); }
/// <summary> /// Index table configuration /// </summary> public static DataTableConfig IndexTable() { var table = new DataTableConfig <ShaRole, Guid>("ShaRoles_Index"); table.AddProperty(e => e.Name, c => c.SortAscending()); //table.AddProperty(e => e.NameSpace, c => c.HiddenByDefault()); table.AddProperty(e => e.Description); table.AddProperty(e => e.CreationTime, c => c.Caption("Created On").Visible(false)); table.AddProperty(e => e.LastModificationTime, c => c.Caption("Updated On").Visible(false)); return(table); }
/// <summary> /// Table configuration for entity picker /// </summary> public static DataTableConfig PersonPickerTable() { var table = new DataTableConfig <Person, Guid>("Persons_Picker"); table.AddProperty(e => e.FullName, c => c.SortAscending()); table.AddProperty(e => e.EmailAddress1); table.OnRequestToFilterStatic = (criteria, input) => { criteria.FilterClauses.Add($"{nameof(Person.User)} != null"); }; return(table); }
/// <summary> /// Areas index table /// </summary> /// <returns></returns> public static DataTableConfig IndexTable() { var table = new DataTableConfig <Area, Guid>("Areas_Index"); table.AddProperty(e => e.Name, c => c.SortAscending()); table.AddProperty(e => e.ShortName); table.AddProperty(e => e.ParentArea.Name, c => c.Caption("Parent Area")); table.AddProperty(e => e.AreaType); table.AddProperty(e => e.Comments); table.AddProperty(e => e.CreationTime, c => c.Caption("Created On").Visible(false)); table.AddProperty(e => e.LastModificationTime, c => c.Caption("Updated On").Visible(false)); return(table); }
/// <summary> /// Index table configuration. Note: It's just a temporary solution /// </summary> public static DataTableConfig IndexTable() { var table = new DataTableConfig <Form, Guid>("Forms_Index"); table.AddProperty(e => e.Name); table.AddProperty(e => e.Path); table.AddProperty(e => e.Description); table.AddProperty(e => e.ModelType); table.AddProperty(e => e.Settings); table.AddProperty(e => e.CreationTime, c => c.Caption("Created On").HiddenByDefault()); table.AddProperty(e => e.LastModificationTime, c => c.Caption("Updated On").HiddenByDefault()); return(table); }
/// <summary> /// Notification Templates index table /// </summary> /// <returns></returns> public static DataTableConfig IndexTable() { var table = new DataTableConfig <NotificationTemplate, Guid>("NotificationTemplates_Index"); table.AddProperty(e => e.Name, c => c.SortAscending()); table.AddProperty(e => e.SendType); table.AddProperty(e => e.BodyFormat); table.AddProperty(e => e.Subject); table.AddProperty(e => e.Body); table.AddProperty(e => e.CreationTime, c => c.Caption("Created On").Visible(false)); table.AddProperty(e => e.LastModificationTime, c => c.Caption("Updated On").Visible(false)); return(table); }
public string GetDarpperInsertSql(DataTableConfig config) { string insert = "insert into [" + config.TableName + "] ("; foreach (var column in config.Column) { insert += "[" + (column.Alias ?? column.Name) + "],"; } insert = insert.Trim(',') + ")Values("; foreach (var column in config.Column) { insert += "@" + column.Name + ","; } insert = insert.Trim(',') + ");select @@IDENTITY;"; return(insert); }
public static DataTableConfig IndexTable() { var table = new DataTableConfig <User, Int64>("Users_Index"); table.AddProperty(e => e.UserName, c => c.SortAscending()); table.AddProperty(e => e.Name); table.AddProperty(e => e.Surname); table.AddProperty(e => e.EmailAddress); table.AddProperty(e => e.PhoneNumber); table.AddProperty(e => e.CreatorUser); table.AddProperty(e => e.CreatorUserId); table.AddProperty(e => e.CreationTime); table.AddProperty(e => e.IsActive); return(table); }
/// <summary> /// Index table configuration /// </summary> public static DataTableConfig IndexTable() { var table = new DataTableConfig <ShaUserLoginAttempt, Guid>("LogonAudit_Index"); table.AddProperty(e => e.CreationTime, c => c.Caption("Date").SortDescending()); table.AddProperty(e => e.Result); table.AddProperty(e => e.UserNameOrEmailAddress); table.AddProperty(e => e.BrowserInfo); table.AddProperty(e => e.ClientIpAddress); table.AddProperty(e => e.DeviceName); table.AddProperty(e => e.IMEI); table.AddProperty(e => e.ClientName); table.AddProperty(e => e.LoginAttemptNumber); return(table); }
/// <summary> /// Notification Templates index table /// </summary> /// <returns></returns> public static DataTableConfig IndexTable() { var table = new DataTableConfig <NotificationMessage, Guid>("NotificationMessages_Index"); table.AddProperty(e => e.CreationTime, c => c.Caption("Created On").SortDescending()); table.AddProperty(e => e.Notification.Name, c => c.Caption("Notification")); table.AddProperty(e => e.Recipient); table.AddProperty(e => e.SendType); table.AddProperty(e => e.RecipientText); table.AddProperty(e => e.Subject); table.AddProperty(e => e.Body); return(table); }
public DapperBaseSQL GetDapperBaseSQL(Type type) { DapperSqlHelper dapperSql = new DapperSqlHelper(); DataTableConfig config = new DataTableConfig(type); DapperBaseSQL dapperBaseSQL = new DapperBaseSQL { Get = dapperSql.GetDarpperModelSql(config), GetList = dapperSql.GetDarpperModelListSql(config) + " where 1=1", Insert = dapperSql.GetDarpperInsertSql(config), Update = dapperSql.GetDarpperUpdateSql(config), Delete = dapperSql.GetDarpperDeleteSql(config), TableConifg = config }; return(dapperBaseSQL); }
/// <summary> /// Notification Templates index table /// </summary> /// <returns></returns> public static DataTableConfig IndexTable() { var table = new DataTableConfig <OtpAuditItem, Guid>("OtpAuditItems_Index"); //table.AddProperty(e => e.Id, c => c.HiddenByDefault()); table.AddProperty(e => e.CreationTime, c => c.Caption("Created On").SortDescending()); table.AddProperty(e => e.SendTo); table.AddProperty(e => e.SendType); table.AddProperty(e => e.RecipientType, c => c.HiddenByDefault()); table.AddProperty(e => e.RecipientId, c => c.HiddenByDefault()); table.AddProperty(e => e.ExpiresOn); table.AddProperty(e => e.Otp); table.AddProperty(e => e.ActionType); table.AddProperty(e => e.SentOn); table.AddProperty(e => e.SendStatus); table.AddProperty(e => e.ErrorMessage); return(table); }
public string GetDarpperModelListSql(DataTableConfig config) { string selectSqlFormat = " select {0} from [" + config.TableName + "]"; string columnsSql = "[" + config.Key.Name + "],"; foreach (var column in config.Column) { if (!string.IsNullOrEmpty(column.Alias)) { columnsSql += "[" + column.Alias + "] as " + column.Name; } else { columnsSql += "[" + column.Name + "]"; } columnsSql += ","; } string selectSql = string.Format(selectSqlFormat, columnsSql.Trim(',')); return(selectSql); }
/// <summary> /// Index table configuration /// </summary> public static DataTableConfig IndexTable() { var table = new DataTableConfig <EntityConfig, Guid>("EntityConfigs_Index"); table.AddProperty(e => e.Namespace); table.AddProperty(e => e.ClassName); table.AddProperty(e => e.FriendlyName); table.AddProperty(e => e.TypeShortAlias); table.AddProperty(e => e.TableName); table.AddProperty(e => e.DiscriminatorValue); table.AddProperty(e => e.Source); table.AddProperty(e => e.CreationTime, c => c.Caption("Created On") /*.Visible(false)*/); table.AddProperty(e => e.LastModificationTime, c => c.Caption("Updated On").Visible(false)); //table.OnRequestToFilterStatic = (criteria, input) => //{ // criteria.FilterClauses.Add($"{nameof(Person.User)} != null"); //}; return(table); }
public virtual ActionResult ListConfig(bool showProject = false, TaskSorting sorting = TaskSorting.Title) { var config = new DataTableConfig(); config.Searching = true; config.PageLength = 25; config.SetupServerDataSource(Url.Action(MVC.Tasks.ListData()), FormMethod.Post); config.Columns = new List<DataTableConfig.Column>(columns); config.Columns[(int)TaskListColumns.ProjectName].Visible = showProject; config.Columns[(int)TaskListColumns.Delete].Visible = this.Can(MVC.Tasks.Delete()); switch (sorting) { case TaskSorting.Title: { config.AddOrder((int)TaskListColumns.Title, DataTables.Mvc.Column.OrderDirection.Ascendant); break; } case TaskSorting.Priority: { config.AddOrder((int)TaskListColumns.Priority, DataTables.Mvc.Column.OrderDirection.Descendant); break; } } var json = JsonConvert.SerializeObject(config); return Content(json, "application/json"); }
public string GetDarpperDeleteSql(DataTableConfig config) { string delete = " delete " + config.TableName + " where +" + config.Key.Name + "=@" + (config.Key.Alias ?? config.Key.Name); return(delete); }
public TableController(IPlacementContext context) { this.config = context.Config; this.options = context.Options; }
public virtual ActionResult ListConfig(ReportSorting sorting = ReportSorting.Title) { var config = new DataTableConfig(); config.Searching = true; config.SetupServerDataSource(Url.Action(MVC.Reporting.ListData()), FormMethod.Post); config.Columns = new List<DataTableConfig.Column>(columns); switch (sorting) { case ReportSorting.Title: { config.AddOrder((int)ReportListColumns.Title, DataTables.Mvc.Column.OrderDirection.Ascendant); break; } case ReportSorting.Project: { config.AddOrder((int)ReportListColumns.ProjectName, DataTables.Mvc.Column.OrderDirection.Descendant); break; } case ReportSorting.Step: { config.AddOrder((int)ReportListColumns.Step, DataTables.Mvc.Column.OrderDirection.Descendant); break; } } var json = JsonConvert.SerializeObject(config); return Content(json, "application/json"); }
protected void Application_Start() { GlobalConfiguration.Configure(WebApiConfig.Register); DataTableConfig.CheckDataTable(); }
public DataTableConfigBuilder() { _element = new DataTableConfig(); }