public ActionResult Grid([SessionModelBinder(ProductGridKey)] ActionGridOptions options)
{
var filter = new ProductFilter(_dc);
var query = _dc.Products.Where(ProductSpecification.Search(options.SearchString).Predicate).OrderBy(x => x.ID).AsQueryable();
query = filter.Init(options).ApplyFilters(query);
var model = new ProductGridModel(ProductGridKey);
return(View(new ActionGridView <Product>(model, query).Init(options)));
}
public ActionResult GridSetting(ActionGridOptions options, string gridKey)
{
var gridModel = new ProductGridModel(ProductGridKey);
gridModel.Init(options);
var model = new GridSettingView(gridKey)
{
Columns = gridModel.Columns.OrderBy(x => x.Value.Order).ToDictionary(x => x.Key, x => x.Value as IGridColumn),
PageSize = gridModel.PageSize
};
return(View("GridSetting", model));
}
public List <ProductGridModel> GetGrid()
{
List <ProductGridModel> products = new List <ProductGridModel>();
try
{
//open edirik emeliyyati icra etmek ucun
SqlChecking();
//queryni seliqelilik olsun deye bele yaziriq
string query = @"SELECT product.Id as ProductId,product.Name as ProductName," +
"product.Price as ProductPrice,category.Id as CategoryId," +
"category.Name as CategoryName FROM Products as product" +
"INNER JOIN Categories category ON product.CategoryId = category.Id";
//command ile emri veririk
using (SqlCommand sqlCommand = new SqlCommand(query, _SqlConnection))
{
using (SqlDataReader sqlDataReader = sqlCommand.ExecuteReader())
{
while (sqlDataReader.Read())
{
ProductGridModel product = new ProductGridModel()
{
ProductId = Convert.ToInt32(sqlDataReader["ProductId"].ToString()),
ProductName = sqlDataReader["ProductName"].ToString(),
ProductPrice = Convert.ToInt32(sqlDataReader["ProductPrice"].ToString()),
CategoryId = Convert.ToInt32(sqlDataReader["CategoryId"].ToString()),
CategoryName = sqlDataReader["CategoryName"].ToString()
};
products.Add(product);
}
}
}
}
catch (SqlException exception)
{
throw exception;
}
return(products);
}
