private void StoreSelectListInViewData()
{
ViewData["Categories"] = _dbReadService.GetSelectList <Category>("CategoryId", "Name");
ViewData["Products"] = _dbReadService.GetSelectList <Product>("ProductId", "ItemNumber");
ViewData["Styles"] = _dbReadService.GetSelectList <Style>("StyleId", "Name");
ViewData["Locations"] = _dbReadService.GetSelectList <Location>("LocationId", "Name");
}
public void OnGet(int courseId, string userId)
{
ViewData["Courses"] = _dbReadService.GetSelectList <Course>("Id", "Title");
Input.UserCourse = _dbReadService.Get <UserCourse>(userId, courseId);
Input.UpdatedUserCourse = Input.UserCourse;
var course = _dbReadService.Get <Course>(courseId);
var user = _userService.GetUser(userId);
Input.CourseTitle = course.Title;
Input.Email = user.Email;
}
public void OnGet(string itemNumber, int catId = 0, int styleId = 0, int locationId = 0)
{
items = _dbReadService.GetWithIncludes <ProductInventory>();
productList = _dbReadService.GetWithIncludes <Product>();
ViewData["Categories"] = _dbReadService.GetSelectList <Category>("CategoryId", "Name");
ViewData["Styles"] = _dbReadService.GetSelectList <Style>("StyleId", "Name");
ViewData["Locations"] = _dbReadService.GetSelectList <Location>("LocationId", "Name");
if (styleId > 0)
{
items = items.Where(pv => pv.StyleId == styleId);
}
if (locationId > 0)
{
items = items.Where(pv => pv.LocationId == locationId);
}
if (catId > 0)
{
var products = _dbReadService.Get <Product>()
.Where(p => p.CategoryId == catId)
.Select(p => p.ProductId);
if (products.Count() > 0)
{
items = items.Where(pv => products.Contains(pv.ProductId));
}
else
{
//never true, we do this because we cannot set items to null directly
items = items.Where(pv => pv.ProductId < 0);
}
}
if (!string.IsNullOrEmpty(itemNumber))
{
var product = _dbReadService.Get <Product>()
.Where(p => p.ItemNumber.Equals(itemNumber))
.FirstOrDefault();
if (product != null)
{
items = items.Where(pv => pv.ProductId == product.ProductId);
}
else
{
items = items.Where(pv => pv.ProductId < 0);
}
}
//sort items by category, itemNumber, style and location
items = items.OrderBy(pi => pi.Product.CategoryId).ThenBy(pi => pi.Product.ItemNumber)
.ThenBy(pi => pi.Style.Name).ThenBy(pi => pi.Location.Name);
}
public void OnGet(int id)
{
ViewData["Modules"] = _dbReadService.GetSelectList <Module>("Id", "Title");
Input = _dbReadService.Get <Video>(id, true);
}
public void OnGet(int courseId, string userId)
{
ViewData["Genres"] = _dbReadService.GetSelectList <Genre>("Id", "Title");
Input.UserGenre = _dbReadService.Get <UserGenre>(userId, courseId);
Input.UpdatedUserGenre = Input.UserGenre;
Input.GenreTitle = _dbReadService.Get <Genre>(courseId).Title;
Input.Email = _userService.GetUser(userId).Email;
}
public void OnGet()
{
ViewData["Albums"] = _dbReadService.GetSelectList <Album>("Id", "Title");
ViewData["Thumbnails"] = new SelectList(
new List <string>
{
"/images/video1.jpg",
"/images/video2.jpg",
"/images/video3.jpg",
"/images/video4.jpg",
"/images/video5.jpg"
});
}
public void OnGet(string itemNumber, int catId = 0)
{
ViewData["Categories"] = _dbReadService.GetSelectList <Category>("CategoryId", "Name");
items = _dbReadService.GetWithIncludes <Product>();
if (catId > 0)
{
items = items.Where(p => p.CategoryId == catId);
}
if (!string.IsNullOrEmpty(itemNumber))
{
items = items.Where(p => p.ItemNumber.Equals(itemNumber));
}
items = items.OrderBy(p => p.CategoryId).ThenBy(p => p.ItemNumber);
}
public void OnGet(int id)
{
ViewData["Instructors"] = _dbReadService.GetSelectList <Instructor>("Id", "Name");
Input = _dbReadService.Get <Course>(id);
}
public void OnGet()
{
ViewData["Instructors"] = _dbReadService.GetSelectList <Instructor>("Id", "Name");
}
public void OnGet()
{
ViewData["Modules"] = _dbReadService.GetSelectList <Module>("Id", "Title");
}
public void OnGet(int id)
{
ViewData["Categories"] = _dbReadService.GetSelectList <Category>("CategoryId", "Name");
Input = _dbReadService.Get <Product>(id, false);
}
public void OnGet()
{
ViewData["Categories"] = _dbReadService.GetSelectList <Category>("CategoryId", "Name");
}
public void OnGet()
{
ViewData["Albums"] = _dbReadService.GetSelectList <Album>("Id", "Title");
}
public void OnGet(int id)
{
ViewData["Courses"] = _dbReadService.GetSelectList <Course>("Id", "Title");
Input = _dbReadService.Get <Module>(id);
}
public void OnGet()
{
ViewData["Band"] = _dbReadService.GetSelectList <Band>("Id", "Name");
}
public void OnGet(int id)
{
Input = _dbReadService.Get <Band>(id);
ViewData["Genres"] = _dbReadService.GetSelectList <Genre>("Id", "Title");
}
public void OnGet()
{
ViewData["Genres"] = _dbReadService.GetSelectList <Genre>("Id", "Title");
}
public void OnGet(int id)
{
ViewData["Albums"] = _dbReadService.GetSelectList <Album>("Id", "Title");
Input = _dbReadService.Get <AlbumInfo>(id, true);
}
public void OnGet()
{
ViewData["Courses"] = _dbReadService.GetSelectList <Course>("Id", "Title");
}
public void OnGet(int id)
{
Input = _dbReadService.Get <BandMember>(id);
ViewData["Band"] = _dbReadService.GetSelectList <Band>("Id", "Name");
}
