public void Inserting_Defaults_Correctly_Handles_Single_Quotes()
{
var expectedValue = "Hello, 'World'.";
var schemaName = "dbo";
var tableName = "testtable";
DropAndCreateTestTable(schemaName, tableName, "[col1manual] int, [col2withdefault] varchar(200)");
var columns = new string[] { "col1manual" };
var data = new object[]
{
new object[] { 1 }
};
var defaults = new ColumnDefaults();
defaults.AddDefault(new KeyValuePair <string, object>("col2withdefault", expectedValue));
tester.InsertData(schemaName, tableName, columns, data, defaults);
var results = tester.ExecuteStatementWithResult(string.Format("select * from {0}.{1};", schemaName, tableName));
var actualValue = results.Tables[0].Rows[0]["col2withdefault"];
Assert.AreEqual(expectedValue, actualValue);
}
public void I_Can_Insert_Several_Rows_With_Defaults_And_No_Other_Data()
{
var expectedCount = 5;
var schemaName = "dbo";
var tableName = "testtable";
DropAndCreateTestTable(schemaName, tableName, "[col1manual] int, [col2withdefault] varchar(200)");
var columns = new string[0];
var data = new object[]
{
null,
null,
null,
null,
null
};
var defaults = new ColumnDefaults();
defaults.AddDefault(new KeyValuePair <string, object>("col2withdefault", "defaultvalue"));
tester.InsertData(schemaName, tableName, columns, data, defaults);
var results = tester.ExecuteStatementWithResult(string.Format("select * from {0}.{1};", schemaName, tableName));
var actualCount = results.Tables[0].Rows.Count;
Assert.AreEqual(expectedCount, actualCount);
}
public void Data_Specified_For_A_Column_Overrides_The_Default_Data()
{
var expectedValue = "Hello, World.";
var schemaName = "dbo";
var tableName = "testtable";
DropAndCreateTestTable(schemaName, tableName, "[col1manual] int, [col2withdefault] varchar(200)");
var columns = new string[] { "col1manual", "col2withdefault" };
var data = new object[]
{
new object[] { 1, expectedValue }
};
var defaults = new ColumnDefaults();
defaults.AddDefault(new KeyValuePair <string, object>("col2withdefault", "Column's default value"));
tester.InsertData(schemaName, tableName, columns, data, defaults);
var results = tester.ExecuteStatementWithResult(string.Format("select * from {0}.{1};", schemaName, tableName));
var actualValue = results.Tables[0].Rows[0]["col2withdefault"];
Assert.AreEqual(expectedValue, actualValue);
}
public static void RegsterGrids()
{
ColumnDefaults colDefaults = new ColumnDefaults()
{
EnableSorting = true
};
}
private static void RegisterGrid(GridDefaults gridDefaults, ColumnDefaults colDefauls, string gridName)
{
MVCGridDefinitionTable.Add(GRID_NAME, new MVCGridBuilder <ProductItemModel>(gridDefaults, colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
BuildColumns(cols);
})
.WithSorting(true, "Name", SortDirection.Asc)
.WithFiltering(true)
.WithAdditionalQueryOptionNames(FILTER_NAME, FILTER_DESC)
.WithRetrieveDataMethod((context) =>
{
var service = DependencyResolver.Current.GetService <IProductsService>();
var result = service.GetProducts();
var options = context.QueryOptions;
var query = result.Items.AsQueryable();
var name = options.GetAdditionalQueryOptionString(FILTER_NAME);
var desc = options.GetAdditionalQueryOptionString(FILTER_DESC);
query = FilterData(options, query, name, desc);
return(new QueryResult <ProductItemModel>()
{
Items = query.ToList(),
TotalRecords = result.Items.Count()
});
})
);
}
public void InsertDataWithNullsWikiExample()
{
// Setup the Database Tester object using the MS SQL implementation
var connectionstring = @"Data Source=(localdb)\MSSQLLocalDB;Initial Catalog=tempdb;Integrated Security=SSPI;";
VulcanAnalytics.DBTester.DatabaseTester tester = new VulcanAnalytics.DBTester.MsSqlDatabaseTester(connectionstring);
// Create a table to insert data into
tester.ExecuteStatementWithoutResult("drop table if exists [dbo].[TestPerson];");
tester.ExecuteStatementWithoutResult("create table [dbo].[TestPerson]([TestId] int, [Name] varchar(255), [ModifiedDate] datetime, [ModifiedBy] sysname);");
// Set the defaults for the insert
var defaults = new ColumnDefaults();
defaults.AddDefault(new KeyValuePair <string, object>("ModifiedBy", "DarrenComeau"));
// Parameters for InsertData method
var schemaName = "dbo";
var tableName = "TestPerson";
var columns = new string[] { "TestId", "Name", "ModifiedDate" };
var data = new object[]
{
new Object[] { 1, "Joe", "2018-09-28T12:49:13.576" },
new Object[] { 2, null, "2018-10-01T18:31:29.256" }
};
// Call the Insertdata method to insert the rows
tester.InsertData(schemaName, tableName, columns, data, defaults);
}
public void ColumnDefaults_When_Assigned_Is_Not_Empty()
{
var columnDefaults = new ColumnDefaults();
columnDefaults.AddDefault(new KeyValuePair <string, object>("Hello", "World"));
Assert.IsFalse(columnDefaults.IsEmpty);
}
public void I_Cannot_Add_Duplicate_Column_Value_Pair()
{
var columnDefaults = new ColumnDefaults();
var columnDefault = new KeyValuePair <string, object>("Hello", "World");
columnDefaults.AddDefault(columnDefault);
columnDefaults.AddDefault(columnDefault);
}
private static ColumnDefaults GetColDefauls()
{
ColumnDefaults colDefauls = new ColumnDefaults()
{
EnableSorting = true,
AllowChangeVisibility = false,
};
return(colDefauls);
}
public void I_Can_Add_And_Retrieve_A_Column_Value_Pair()
{
var columnDefaults = new ColumnDefaults();
var columnDefault = new KeyValuePair <string, object>("Hello", "World");
columnDefaults.AddDefault(columnDefault);
foreach (var defaultColumn in columnDefaults)
{
Assert.AreEqual(columnDefault, defaultColumn);
}
}
public void I_Receive_An_Error_When_No_Rows_Supplied_Even_With_Defaults()
{
var schemaName = "dbo";
var tableName = "testtable";
DropAndCreateTestTable(schemaName, tableName, "[col1manual] int, [col2withdefault] varchar(200)");
var columns = new string[] { "col1manual" };
var data = new object[0];
var defaults = new ColumnDefaults();
defaults.AddDefault(new KeyValuePair <string, object>("col2withdefault", "defaultvalue"));
tester.InsertData(schemaName, tableName, columns, data, defaults);
}
public static void GetGridDefinition()
{
var colDefaults = new ColumnDefaults()
{
EnableSorting = true
};
MVCGridDefinitionTable.Add(USERS_LIST, new MVCGridBuilder <UserDTO>(colDefaults)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithSorting(sorting: true, defaultSortColumn: nameof(UserDTO.FirstName), defaultSortDirection: SortDirection.Dsc)
.WithPaging(paging: true, itemsPerPage: 15, allowChangePageSize: true, maxItemsPerPage: 100)
.WithAdditionalQueryOptionNames("search")
.AddColumns(cols =>
{
cols.Add("Username").WithHeaderText("User Name").WithVisibility(true, true).WithValueExpression(p => p.FirstName).WithSorting(false);
cols.Add("FirstName").WithHeaderText("First Name").WithVisibility(true, true).WithValueExpression(p => p.LastName).WithSorting(false);
cols.Add("CellNumber").WithHeaderText("Cell Number").WithVisibility(true, true).WithValueExpression(p => p.Cellphone).WithSorting(false);
cols.Add("Actions").WithHtmlEncoding(false)
.WithSorting(false)
.WithHeaderText("Actions")
.WithValueExpression(x =>
{
return($"<a id='{Security.Encrypt(x.UserId)}' class='btn btn-success btn-sm' style='color: #fff;' onclick='EditUser(this)'> <i class='fa fa-edit' aria-hidden='true'></i> Edit</a> " +
$"<a id='{Security.Encrypt(x.UserId)}' class='btn btn-danger btn-sm ' style='color: #fff;' onclick='DeleteUser(this)'><i class='fa fa-trash' aria-hidden='true'></i> Delete</a>");
});
})
.WithAdditionalSetting(MVCGrid.Rendering.BootstrapRenderingEngine.SettingNameTableClass, "table table-striped table-bordered table-hover table-sm") // Example of changing table css class
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
var globalSearch = options.GetAdditionalQueryOptionString("search");
var sortColumn = options.GetSortColumnData <string>();
var userServiceClient = new UserServiceClient();
var usersList = userServiceClient.GetUsers().ToList();
if (options.GetLimitOffset().HasValue)
{
usersList = usersList.Skip(options.GetLimitOffset().Value).Take(options.GetLimitRowcount().Value).ToList();
}
return(new QueryResult <UserDTO>()
{
Items = usersList,
TotalRecords = usersList.Count,
});
})
);
}
public static void RegisterGrids()
{
ColumnDefaults colDefauls = new ColumnDefaults()
{
EnableSorting = true
};
MVCGridDefinitionTable.Add("AuthorSearch", new MVCGridBuilder <Author>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Delete").WithHtmlEncoding(false)
.WithSorting(false)
.WithHeaderText(" ")
.WithValueExpression(p => p.AuthorId.ToString())
.WithValueTemplate("<a class='authorSelectLink' value='{Value}' ><i class='glyphicon glyphicon-arrow-left'></i><span class='sr-only'>Details</span></span> </a>");
cols.Add("AuthorFirstName").WithHeaderText("Name")
.WithValueExpression(p => p.AuthorFirstName);
cols.Add("AuthorMiddleName").WithHeaderText("Mid. name")
.WithValueExpression(p => p.AuthorMiddleName);
cols.Add("AuthorLastName").WithHeaderText("Last name")
.WithValueExpression(p => p.AuthorLastName);
})
.WithAdditionalQueryOptionNames("Search")
.WithAdditionalSetting("RenderLoadingDiv", false)
.WithSorting(true, "AuthorLastName")
.WithPaging(true, 5)
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = new UnitOfWork(new DAL.HLibDBContext());
string globalSearch = options.GetAdditionalQueryOptionString("Search");
var items = repo.AuthorsRP.GetData(out totalRecords, globalSearch, options.SortColumnName, options.SortDirection == SortDirection.Dsc, options.GetLimitOffset(), options.GetLimitRowcount());
return(new QueryResult <Author>()
{
Items = items,
TotalRecords = totalRecords
});
})
);
}
public static SignalRMVCGridBuilder Test2()
{
ColumnDefaults colDefauls = new ColumnDefaults()
{
EnableSorting = true
};
return(new SignalRMVCGridBuilder("TestGrid2", SignalRGridType.Individual, colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithSorting(sorting: true, defaultSortColumn: "Id", defaultSortDirection: SortDirection.Dsc)
.WithPaging(paging: true, itemsPerPage: 10, allowChangePageSize: true, maxItemsPerPage: 100)
.AddColumns(cols =>
{
cols.Add("Id").WithValueExpression((p, c) => p.Id.ToString())
.WithAllowChangeVisibility(true);
cols.Add("FirstName").WithHeaderText("First Name")
.WithVisibility(true, true)
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithVisibility(true, true)
.WithValueExpression(p => p.LastName);
cols.Add("FullName").WithHeaderText("Full Name")
.WithValueTemplate("{Model.FirstName} {Model.LastName}")
.WithVisibility(visible: false, allowChangeVisibility: true)
.WithSorting(false);
cols.Add("StartDate").WithHeaderText("Start Date")
.WithVisibility(visible: true, allowChangeVisibility: true)
.WithValueExpression(p => p.StartDate == null ? p.StartDate.ToShortDateString() : "");
cols.Add("Status")
.WithSortColumnData("Active")
.WithVisibility(visible: true, allowChangeVisibility: true)
.WithHeaderText("Status")
.WithValueExpression(p => p.Active ? "Active" : "Inactive")
.WithCellCssClassExpression(p => p.Active ? "success" : "danger");
cols.Add("Gender").WithValueExpression((p, c) => p.Gender)
.WithAllowChangeVisibility(true);
cols.Add("Email")
.WithVisibility(visible: false, allowChangeVisibility: true)
.WithValueExpression(p => p.Email);
})
.ToSignalRGrid());
}
public void I_Receive_An_Error_When_No_Defaults_And_No_Other_Data_Supplied()
{
var schemaName = "dbo";
var tableName = "testtable";
DropAndCreateTestTable(schemaName, tableName, "[col1manual] int, [col2withdefault] varchar(200)");
var columns = new string[0];
var data = new object[]
{
null,
null,
null,
null,
null
};
var defaults = new ColumnDefaults();
tester.InsertData(schemaName, tableName, columns, data, defaults);
}
public void I_Can_Loop_Over_All_Defaults()
{
var expectedCount = 4;
var columnDefaults = new ColumnDefaults();
var i = 0;
while (i < expectedCount)
{
var keyString = string.Format("Hello {0}", i);
columnDefaults.AddDefault(new KeyValuePair <string, object>(keyString, "World"));
i++;
}
var actualCount = 0;
foreach (var columnDefault in columnDefaults)
{
actualCount++;
}
Assert.AreEqual(expectedCount, actualCount);
}
public static MVCGridBuilder <Person> Test()
{
ColumnDefaults colDefauls = new ColumnDefaults()
{
EnableSorting = true
};
return(new MVCGridBuilder <Person>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithSorting(sorting: true, defaultSortColumn: "Id", defaultSortDirection: SortDirection.Dsc)
.WithPaging(paging: true, itemsPerPage: 10, allowChangePageSize: true, maxItemsPerPage: 100)
.AddColumns(cols =>
{
cols.Add("Id").WithValueExpression((p, c) => p.Id.ToString())
.WithAllowChangeVisibility(true);
cols.Add("FirstName").WithHeaderText("First Name")
.WithVisibility(true, true)
.WithValueExpression(p => p.FirstName);
cols.Add("LastName").WithHeaderText("Last Name")
.WithVisibility(true, true)
.WithValueExpression(p => p.LastName);
cols.Add("FullName").WithHeaderText("Full Name")
.WithValueTemplate("{Model.FirstName} {Model.LastName}")
.WithVisibility(visible: false, allowChangeVisibility: true)
.WithSorting(false);
cols.Add("StartDate").WithHeaderText("Start Date")
.WithVisibility(visible: true, allowChangeVisibility: true)
.WithValueExpression(p => p.StartDate == null ? p.StartDate.ToShortDateString() : "");
cols.Add("Status")
.WithSortColumnData("Active")
.WithVisibility(visible: true, allowChangeVisibility: true)
.WithHeaderText("Status")
.WithValueExpression(p => p.Active ? "Active" : "Inactive")
.WithCellCssClassExpression(p => p.Active ? "success" : "danger");
cols.Add("Gender").WithValueExpression((p, c) => p.Gender)
.WithAllowChangeVisibility(true);
cols.Add("Email")
.WithVisibility(visible: false, allowChangeVisibility: true)
.WithValueExpression(p => p.Email);
})
.WithRetrieveDataMethod((context) =>
{
QueryOptions queryOptions = context.QueryOptions;
int pageIndex = queryOptions.PageIndex.Value;
int pageSize = queryOptions.ItemsPerPage.Value;
int totalCount = 120;
List <Person> persons = new List <Person>();
for (int x = 0; totalCount > x; x++)
{
Person person = new Person()
{
Id = x,
FirstName = "Alpha",
LastName = "Shabazz",
Active = true,
Email = "*****@*****.**",
Employee = true,
Gender = "Male",
StartDate = DateTime.Now,
};
persons.Add(person);
}
persons = persons.Skip(pageIndex * pageSize).Take(pageSize).ToList();
return new QueryResult <Person>()
{
Items = persons,
TotalRecords = totalCount
};
}));
}
public static void RegisterGrids()
{
// Default column settings
ColumnDefaults colDefaults = new ColumnDefaults()
{
EnableSorting = true
};
// Grid Definitions
MVCGridDefinitionTable.Add("UserInputs60Hz", new MVCGridBuilder <UserInputs60Hz>(colDefaults)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithSorting(sorting: true, defaultSortColumn: "Id", defaultSortDirection: SortDirection.Dsc)
.WithPaging(paging: true, itemsPerPage: 10, allowChangePageSize: true, maxItemsPerPage: 100)
.WithAdditionalQueryOptionNames("search")
.AddColumns(cols =>
{
cols.Add("Id").WithHeaderText("Id")
.WithVisibility(true, true)
.WithValueExpression(p => p.Id.ToString());
cols.Add("TransSize").WithHeaderText("TransSize")
.WithVisibility(true, true)
.WithValueExpression(p => p.TransSize.ToString());
cols.Add("Impedance").WithHeaderText("Impedance")
.WithVisibility(true, true)
.WithValueExpression(p => p.Impedance.ToString());
cols.Add("SCC").WithHeaderText("SCC")
.WithVisibility(true, true)
.WithValueExpression(p => p.SCC.ToString());
cols.Add("FaultClearing").WithHeaderText("Fault Clearing")
.WithVisibility(true, true)
.WithValueExpression(p => p.FaultClearing.ToString());
cols.Add("Voltage").WithHeaderText("Voltage")
.WithVisibility(true, true)
.WithValueExpression(p => p.Voltage.ToString());
cols.Add("FreeAir").WithHeaderText("Free Air")
.WithVisibility(true, true)
.WithValueExpression(p => p.FreeAir.ToString());
cols.Add("IPAddress").WithHeaderText("IP Address")
.WithVisibility(true, true)
.WithValueExpression(p => p.IPAddress);
cols.Add("date").WithHeaderText("Date Added")
.WithVisibility(visible: true, allowChangeVisibility: true)
.WithValueExpression(p => p.date.HasValue ? p.date.Value.ToShortDateString() : "");
})
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
string globalSearch = options.GetAdditionalQueryOptionString("search");
string sortColumn = options.GetSortColumnData <string>();
var repo = DependencyResolver.Current.GetService <UserInputs60HzRepository>();
var items = repo.GetData(out totalRecords, globalSearch, options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return(new QueryResult <UserInputs60Hz>()
{
Items = items,
TotalRecords = totalRecords
});
})
);
MVCGridDefinitionTable.Add("UserInputsDC", new MVCGridBuilder <UserInputsDC>(colDefaults)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithSorting(sorting: true, defaultSortColumn: "Id", defaultSortDirection: SortDirection.Dsc)
.WithPaging(paging: true, itemsPerPage: 10, allowChangePageSize: true, maxItemsPerPage: 100)
.WithQueryStringPrefix("grid2")
.WithAdditionalQueryOptionNames("search")
.AddColumns(cols =>
{
cols.Add("Id").WithHeaderText("Id")
.WithVisibility(true, true)
.WithValueExpression(p => p.Id.ToString());
cols.Add("PotMaxExp").WithHeaderText("PotMaxExp")
.WithVisibility(true, true)
.WithValueExpression(p => p.PotMaxExp.ToString());
cols.Add("AvailSCC").WithHeaderText("Available SCC")
.WithVisibility(true, true)
.WithValueExpression(p => p.AvailSCC.ToString());
cols.Add("Duration").WithHeaderText("Duration")
.WithVisibility(true, true)
.WithValueExpression(p => p.Duration.ToString());
cols.Add("IPAddress").WithHeaderText("IP Address")
.WithVisibility(true, true)
.WithValueExpression(p => p.IPAddress.ToString());
cols.Add("date").WithHeaderText("Date Added")
.WithVisibility(visible: true, allowChangeVisibility: true)
.WithValueExpression(p => p.date.HasValue ? p.date.Value.ToShortDateString() : "");
})
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
string globalSearch = options.GetAdditionalQueryOptionString("search");
string sortColumn = options.GetSortColumnData <string>();
var repo = DependencyResolver.Current.GetService <UserInputsDCRepository>();
var items = repo.GetData(out totalRecords, globalSearch, options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return(new QueryResult <UserInputsDC>()
{
Items = items,
TotalRecords = totalRecords
});
})
);
MVCGridDefinitionTable.Add("UserIP", new MVCGridBuilder <UserIP>(colDefaults)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithSorting(sorting: true, defaultSortColumn: "Id", defaultSortDirection: SortDirection.Dsc)
.WithPaging(paging: true, itemsPerPage: 10, allowChangePageSize: true, maxItemsPerPage: 100)
.WithAdditionalQueryOptionNames("search")
.AddColumns(cols =>
{
cols.Add("IPAddress").WithHeaderText("IP Address")
.WithVisibility(true, true)
.WithValueExpression(p => p.IPAddress.ToString());
cols.Add("DateAdded").WithHeaderText("Date Added")
.WithVisibility(visible: true, allowChangeVisibility: true)
.WithValueExpression(p => p.DateAdded.HasValue ? p.DateAdded.Value.ToShortDateString() : "");
})
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
string globalSearch = options.GetAdditionalQueryOptionString("search");
string sortColumn = options.GetSortColumnData <string>();
var repo = DependencyResolver.Current.GetService <UserIPRepository>();
var items = repo.GetData(out totalRecords, globalSearch, options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return(new QueryResult <UserIP>()
{
Items = items,
TotalRecords = totalRecords
});
})
);
}
public SignalRMVCGridBuilder(string gridName, SignalRGridType signalRGridType, ColumnDefaults columnDefaults) : base(null, columnDefaults)
{
InitializeSignalR(gridName, signalRGridType);
}
public static void RegisterGrids()
{
try
{
ColumnDefaults colDefauls = new ColumnDefaults()
{
EnableSorting = true
};
MVCGridDefinitionTable.Add("PresidentsGrid", new MVCGridBuilder <PresidentModel>(colDefauls)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
cols.Add("Id").WithSorting(false)
.WithHeaderText("Id").WithValueExpression(i => i.id.ToString());
cols.Add("Name").WithHeaderText("President")
.WithValueExpression(i => i.Name);
cols.Add("Birthday").WithSorting(false)
.WithHeaderText("Birth Day").WithValueExpression(i => i.Birthday);
cols.Add("Birthplace").WithSorting(false)
.WithHeaderText("Birth Place").WithValueExpression(i => i.Birthplace);
cols.Add("Deathday").WithSorting(false)
.WithHeaderText("Death Day").WithValueExpression(i => i.Deathday);
cols.Add("Deathplace").WithSorting(false)
.WithHeaderText("Death Place").WithValueExpression(i => i.Deathplace);
})
.WithSorting(true, "Name")
.WithRetrieveDataMethod((context) =>
{
List <PresidentModel> presidents = HomeController.GetAllPresident();
var options = context.QueryOptions;
var result = new QueryResult <PresidentModel>();
if (!String.IsNullOrWhiteSpace(options.SortColumnName))
{
if (options.SortDirection.ToString() == "Asc")
{
presidents = presidents.OrderBy(x => x.Name).ToList();
}
else if (options.SortDirection.ToString() == "Dsc")
{
presidents = presidents.OrderByDescending(x => x.Name).ToList();
}
result.Items = presidents;
}
else
{
result.Items = presidents;
}
result.TotalRecords = presidents.Count;
return(result);
})
);
}
catch (Exception ex)
{
}
}
public static void RegisterGrids()
{
GridDefaults gridDefaults = new GridDefaults()
{
Paging = true,
ItemsPerPage = 20,
Sorting = true,
NoResultsMessage = "Sorry, no results were found"
};
ColumnDefaults colDefaults = new ColumnDefaults()
{
EnableSorting = true
};
MVCGridDefinitionTable.Add("StudentGrid", new MVCGridBuilder <tblStudent>(colDefaults)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
// Add your columns here
cols.Add("StudID").WithValueExpression(p => p.StudID.ToString());
cols.Add("StudCode").WithValueExpression(p => p.StudCode.ToString());
cols.Add("FullName").WithHeaderText("FullName")
.WithValueExpression(p => p.FullName);
})
.WithSorting(true, "StudCode")
.WithPaging(true, 10)
.WithRetrieveDataMethod((context) =>
{
var result = new QueryResult <tblStudent>();
using (var db = new SchoolTimeContext())
{
result.Items = db.tblStudents.ToList();
}
return(result);
})
);
MVCGridDefinitionTable.Add("SujectsGrid", new MVCGridBuilder <tblSuject>()
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
// Add your columns here
cols.Add("SujectID").WithValueExpression(p => p.SujectID.ToString());
cols.Add("SujectCode").WithValueExpression(p => p.SujectCode.ToString());
cols.Add("SujectName").WithValueExpression(p => p.SujectName.ToString());
})
.WithRetrieveDataMethod((context) =>
{
var result = new QueryResult <tblSuject>();
using (var db = new SchoolTimeContext())
{
result.Items = db.tblSujects.ToList();
}
return(result);
})
);
MVCGridDefinitionTable.Add("TeacherGrid", new MVCGridBuilder <tblTeacher>()
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.AddColumns(cols =>
{
// Add your columns here
cols.Add("teachID").WithValueExpression(p => p.teachID.ToString());
cols.Add("teachCode").WithValueExpression(p => p.teachCode.ToString());
cols.Add("FullName").WithValueExpression(p => p.FullName.ToString());
})
.WithRetrieveDataMethod((context) =>
{
var result = new QueryResult <tblTeacher>();
using (var db = new SchoolTimeContext())
{
result.Items = db.tblTeachers.ToList();
}
return(result);
})
);
}
public void New_ColumnDefaults_Are_Empty()
{
var columnDefaults = new ColumnDefaults();
Assert.IsTrue(columnDefaults.IsEmpty);
}
public static void RegisterGrids()
{
ColumnDefaults colDefaults = new ColumnDefaults()
{
EnableSorting = true
};
// MVCGridDefinitionTable.Add("Vehicles", new MVCGridBuilder<Vehicle>(colDefaults)
// .WithAuthorizationType(AuthorizationType.AllowAnonymous)
// .AddColumns(cols =>
// {
// cols.Add("Id").WithSorting(false)
// .WithValueExpression(p => p.Id.ToString());
// cols.Add("Vin").WithHeaderText("Vin")
// .WithValueExpression(p => p.Vin);
// cols.Add("Make").WithHeaderText("Make")
// .WithValueExpression(p => p.Make);
// cols.Add("Model").WithHeaderText("Model")
// .WithValueExpression(p => p.Model);
// cols.Add("Year").WithHeaderText("Year")
// .WithValueExpression(p => p.Year);
// cols.Add("CurrentMileage").WithHeaderText("Current Mileage")
// .WithValueExpression(p => p.CurrentMileage);
// })
//// .WithSorting(true, "Make")
// .WithPaging(true, 2)
// .WithRetrieveDataMethod((context) =>
// {
// var options = context.QueryOptions;
// var result = new QueryResult<Vehicle>();
// var query = Repository.getVehicles().AsQueryable();
// result.TotalRecords = query.Count();
// //if (!String.IsNullOrWhiteSpace(options.SortColumnName))
// //{
// // switch (options.SortColumnName.ToLower())
// // {
// // case "vin":
// // query = query.OrderBy(p => p.Vin, options.SortDirection);
// // break;
// // case "make":
// // query = query.OrderBy(p => p.Make, options.SortDirection);
// // break;
// // }
// //}
// if (options.GetLimitOffset().HasValue)
// {
// query = query.Skip(options.GetLimitOffset().Value).Take(options.GetLimitRowcount().Value);
// }
// result.Items = query.ToList();
// return result;
// })
// );
MVCGridDefinitionTable.Add("Vehicles", new MVCGridBuilder <Vehicle>(colDefaults)
.WithAuthorizationType(AuthorizationType.AllowAnonymous)
.WithSorting(sorting: true, defaultSortColumn: "Id", defaultSortDirection: SortDirection.Dsc)
.WithPaging(paging: true, itemsPerPage: 10, allowChangePageSize: true, maxItemsPerPage: 100)
.WithAdditionalQueryOptionNames("search")
.AddColumns(cols =>
{
cols.Add("Id").WithValueExpression((p, c) => c.UrlHelper.Action("detail", "demo", new { id = p.Id }))
.WithValueTemplate("<a href='{Value}'>{Model.Id}</a>", false)
.WithPlainTextValueExpression(p => p.Id.ToString());
cols.Add("Make").WithHeaderText("Make")
.WithVisibility(true, true)
.WithValueExpression(p => p.Make);
cols.Add("Model").WithHeaderText("Model")
.WithVisibility(true, true)
.WithValueExpression(p => p.Model);
cols.Add("Year").WithHeaderText("Year")
.WithVisibility(true, true)
.WithValueExpression(p => p.Year);
cols.Add("Vin").WithHeaderText("Vin")
.WithVisibility(true, true)
.WithValueExpression(p => p.Vin);
cols.Add("CurrentMileage").WithHeaderText("Current Mileage")
.WithVisibility(true, true)
.WithValueExpression(p => p.CurrentMileage);
})
//.WithAdditionalSetting(MVCGrid.Rendering.BootstrapRenderingEngine.SettingNameTableClass, "notreal") // Example of changing table css class
.WithRetrieveDataMethod((context) =>
{
var options = context.QueryOptions;
int totalRecords;
var repo = DependencyResolver.Current.GetService <VehicleRepository>();
string globalSearch = options.GetAdditionalQueryOptionString("search");
string sortColumn = options.GetSortColumnData <string>();
var items = repo.GetData(out totalRecords, globalSearch, options.GetLimitOffset(), options.GetLimitRowcount(),
sortColumn, options.SortDirection == SortDirection.Dsc);
return(new QueryResult <Vehicle>()
{
Items = items,
TotalRecords = totalRecords
});
})
);
}
public static void RegisterGrid(GridDefaults gridDefaults, ColumnDefaults colDefauls)
{
RegisterGrid(gridDefaults, colDefauls, GRID_NAME);
}
