public override DataTable GetDataTable (LaunchpadPortalModuleBase module, string search) { var positions = module.LaunchpadController.FindObjects<PositionInfo> ( @"WHERE CONCAT([Title], ' ', [ShortTitle]) LIKE N'%{0}%'", search, false); return DataTableConstructor.FromIEnumerable (positions); }
public override DataTable GetDataTable (LaunchpadPortalModuleBase module, string search) { var documents = module.LaunchpadController.FindObjects<DocumentInfo> ( @"WHERE CONCAT([ItemID], ' ', [Title], ' ', [Url]) LIKE N'%{0}%'", search, false); return DataTableConstructor.FromIEnumerable (documents); }
public override DataTable GetDataTable (LaunchpadPortalModuleBase module, string search) { var eduPrograms = module.LaunchpadController.FindObjects<EduProgramInfo> ( @"WHERE CONCAT([Code], ' ', [Title]) LIKE N'%{0}%'", search, false); return DataTableConstructor.FromIEnumerable (eduPrograms); }
public override DataTable GetDataTable (LaunchpadPortalModuleBase module, string search) { var dt = new DataTable (); DataRow dr; dt.Columns.Add (new DataColumn ("DivisionID", typeof(int))); dt.Columns.Add (new DataColumn ("ParentDivisionID", typeof(int))); dt.Columns.Add (new DataColumn ("DivisionTermID", typeof(int))); dt.Columns.Add (new DataColumn ("Title", typeof(string))); dt.Columns.Add (new DataColumn ("ShortTitle", typeof(string))); dt.Columns.Add (new DataColumn ("HomePage", typeof(string))); dt.Columns.Add (new DataColumn ("DocumentUrl", typeof(string))); dt.Columns.Add (new DataColumn ("Location", typeof(string))); dt.Columns.Add (new DataColumn ("Phone", typeof(string))); dt.Columns.Add (new DataColumn ("Fax", typeof(string))); dt.Columns.Add (new DataColumn ("Email", typeof(string))); dt.Columns.Add (new DataColumn ("SecondaryEmail", typeof(string))); dt.Columns.Add (new DataColumn ("WebSite", typeof(string))); dt.Columns.Add (new DataColumn ("WorkingHours", typeof(string))); dt.Columns.Add (new DataColumn ("CreatedByUserID", typeof(int))); dt.Columns.Add (new DataColumn ("CreatedOnDate", typeof(DateTime))); dt.Columns.Add (new DataColumn ("LastModifiedByUserID", typeof(int))); dt.Columns.Add (new DataColumn ("LastModifiedOnDate", typeof(DateTime))); foreach (DataColumn column in dt.Columns) column.AllowDBNull = true; var divisions = module.LaunchpadController.FindObjects<DivisionInfo> (false, @"WHERE CONCAT([Title], ' ', [ShortTitle], ' ', [Location], ' ', [Phone], ' ', [Fax], ' ', [Email], ' ', [SecondaryEmail], ' ', [WebSite], ' ', [WorkingHours]) LIKE N'%{0}%'", search); foreach (var division in divisions) { dr = dt.NewRow (); var i = 0; dr [i++] = division.DivisionID; dr [i++] = division.ParentDivisionID ?? Null.NullInteger; dr [i++] = division.DivisionTermID ?? Null.NullInteger; dr [i++] = division.Title; dr [i++] = division.ShortTitle; dr [i++] = division.HomePage; dr [i++] = division.DocumentUrl; dr [i++] = division.Location; dr [i++] = division.Phone; dr [i++] = division.Fax; dr [i++] = division.Email; dr [i++] = division.SecondaryEmail; dr [i++] = division.WebSite; dr [i++] = division.WorkingHours; dr [i++] = division.CreatedByUserID; dr [i++] = division.CreatedOnDate; dr [i++] = division.LastModifiedByUserID; dr [i++] = division.LastModifiedOnDate; dt.Rows.Add (dr); } return dt; }
public override DataTable GetDataTable (LaunchpadPortalModuleBase module, string search) { var documentTypes = module.LaunchpadController.FindObjects<DocumentTypeInfo> ( @"WHERE CONCAT([Type], ' ', [Description]) LIKE N'%{0}%'", search, false); return DataTableConstructor.FromIEnumerable (documentTypes); }
public override DataTable GetDataTable (LaunchpadPortalModuleBase module, string search) { var dt = new DataTable (); DataRow dr; dt.Columns.Add (new DataColumn ("AchievementID", typeof(int))); dt.Columns.Add (new DataColumn ("Title", typeof(string))); dt.Columns.Add (new DataColumn ("ShortTitle", typeof(string))); dt.Columns.Add (new DataColumn ("AchievementType", typeof(string))); foreach (DataColumn column in dt.Columns) column.AllowDBNull = true; var achievements = module.LaunchpadController.FindObjects<AchievementInfo> ( @"WHERE CONCAT ([Title], ' ', [ShortTitle]) LIKE N'%{0}%'", search, false ); foreach (var achievement in achievements) { var col = 0; dr = dt.NewRow (); dr [col++] = achievement.AchievementID; dr [col++] = achievement.Title; dr [col++] = achievement.ShortTitle; dr [col++] = Localization.GetString (AchievementTypeInfo.GetResourceKey (achievement.AchievementType), module.LocalResourceFile); dt.Rows.Add (dr); } return dt; }
public override DataTable GetDataTable (LaunchpadPortalModuleBase module, string search) { var eduLevels = module.LaunchpadController.FindObjects<EduLevelInfo> (false, @"WHERE CONCAT([Title], ' ', [ShortTitle]) LIKE N'%{0}%'", search); return DataTableConstructor.FromIEnumerable (eduLevels); }
public override DataTable GetDataTable (LaunchpadPortalModuleBase module, string search) { var dt = new DataTable (); DataRow dr; dt.Columns.Add (new DataColumn ("PositionID", typeof(int))); dt.Columns.Add (new DataColumn ("Title", typeof(string))); dt.Columns.Add (new DataColumn ("ShortTitle", typeof(string))); dt.Columns.Add (new DataColumn ("Weight", typeof(int))); dt.Columns.Add (new DataColumn ("IsTeacher", typeof(bool))); foreach (DataColumn column in dt.Columns) column.AllowDBNull = true; var positions = module.LaunchpadController.FindObjects<PositionInfo> (false, @"WHERE CONCAT([Title], ' ', [ShortTitle]) LIKE N'%{0}%'", search); foreach (var position in positions) { dr = dt.NewRow (); dr [0] = position.PositionID; dr [1] = position.Title; dr [2] = position.ShortTitle; dr [3] = position.Weight; dr [4] = position.IsTeacher; dt.Rows.Add (dr); } return dt; }
public override DataTable GetDataTable (LaunchpadPortalModuleBase module, string search) { var divisions = module.LaunchpadController.FindObjects<DivisionInfo> ( @"WHERE CONCAT([Title], ' ', [ShortTitle], ' ', [Location], ' ', [Phone], ' ', [Fax], ' ', [Email], ' ', [SecondaryEmail], ' ', [WebSite], ' ', [WorkingHours]) LIKE N'%{0}%'", search, false); return DataTableConstructor.FromIEnumerable (divisions); }
public override DataTable GetDataTable (LaunchpadPortalModuleBase module, string search) { var dt = new DataTable (); DataRow dr; dt.Columns.Add (new DataColumn ("EmployeeID", typeof(int))); dt.Columns.Add (new DataColumn ("UserID", typeof(int))); dt.Columns.Add (new DataColumn ("PhotoFileID", typeof(int))); dt.Columns.Add (new DataColumn ("Phone", typeof(string))); dt.Columns.Add (new DataColumn ("CellPhone", typeof(string))); dt.Columns.Add (new DataColumn ("Fax", typeof(string))); dt.Columns.Add (new DataColumn ("LastName", typeof(string))); dt.Columns.Add (new DataColumn ("FirstName", typeof(string))); dt.Columns.Add (new DataColumn ("OtherName", typeof(string))); dt.Columns.Add (new DataColumn ("Email", typeof(string))); dt.Columns.Add (new DataColumn ("SecondaryEmail", typeof(string))); dt.Columns.Add (new DataColumn ("WebSite", typeof(string))); dt.Columns.Add (new DataColumn ("Messenger", typeof(string))); dt.Columns.Add (new DataColumn ("WorkingPlace", typeof(string))); dt.Columns.Add (new DataColumn ("WorkingHours", typeof(string))); dt.Columns.Add (new DataColumn ("Biography", typeof(string))); dt.Columns.Add (new DataColumn ("ExperienceYears", typeof(int))); dt.Columns.Add (new DataColumn ("ExperienceYearsBySpec", typeof(int))); dt.Columns.Add (new DataColumn ("IsPublished", typeof(bool))); //dt.Columns.Add (new DataColumn ("IsDeleted", typeof(bool))); // TODO: Remove audit fields dt.Columns.Add (new DataColumn ("CreatedByUserID", typeof(int))); dt.Columns.Add (new DataColumn ("CreatedOnDate", typeof(DateTime))); dt.Columns.Add (new DataColumn ("LastModifiedByUserID", typeof(int))); dt.Columns.Add (new DataColumn ("LastModifiedOnDate", typeof(DateTime))); foreach (DataColumn column in dt.Columns) column.AllowDBNull = true; var employees = module.LaunchpadController.FindObjects<EmployeeInfo> ( @"WHERE CONCAT([LastName], ' ', [FirstName], ' ', [OtherName], ' ', [Phone], ' ', [CellPhone], ' ', [Fax], ' ', [Email], ' ', [SecondaryEmail], ' ', [WebSite], ' ', [WorkingHours]) LIKE N'%{0}%'", search, false); foreach (var employee in employees) { dr = dt.NewRow (); var i = 0; dr [i++] = employee.EmployeeID; dr [i++] = employee.UserID ?? Null.NullInteger; dr [i++] = employee.PhotoFileID ?? Null.NullInteger; dr [i++] = employee.Phone; dr [i++] = employee.CellPhone; dr [i++] = employee.Fax; dr [i++] = employee.LastName; dr [i++] = employee.FirstName; dr [i++] = employee.OtherName; dr [i++] = employee.Email; dr [i++] = employee.SecondaryEmail; dr [i++] = Utils.FormatList (": ", employee.WebSiteLabel, employee.WebSite); dr [i++] = employee.Messenger; dr [i++] = employee.WorkingPlace; dr [i++] = employee.WorkingHours; dr [i++] = !string.IsNullOrWhiteSpace (employee.Biography) ? HtmlUtils.Shorten (employee.Biography, 16, "...") : string.Empty; dr [i++] = employee.ExperienceYears ?? Null.NullInteger; dr [i++] = employee.ExperienceYearsBySpec ?? Null.NullInteger; dr [i++] = employee.IsPublished; //dr [i++] = employee.IsDeleted; // TODO: Remove audit fields dr [i++] = employee.CreatedByUserID; dr [i++] = employee.CreatedOnDate; dr [i++] = employee.LastModifiedByUserID; dr [i++] = employee.LastModifiedOnDate; dt.Rows.Add (dr); } return dt; }
public abstract DataTable GetDataTable (LaunchpadPortalModuleBase module, string search);
public virtual void DataBind (LaunchpadPortalModuleBase module, string search = null) { Grid.DataSource = GetDataTable (module, search); module.Session [Grid.ID] = Grid.DataSource; Grid.DataBind (); }