public ActionResult Details(int id)
{
ShowCategory ViewModel = new ShowCategory();
string url = "CategoryData/FindCategory/" + id;
HttpResponseMessage response = client.GetAsync(url).Result;
//Can catch the status code (200 OK, 301 REDIRECT), etc.
Debug.WriteLine(response.StatusCode);
if (response.IsSuccessStatusCode)
{
//Put data into Category Data Transfer Object
CategoryDto SelectedCategory = response.Content.ReadAsAsync <CategoryDto>().Result;
ViewModel.Category = SelectedCategory;//Seen in the ViewModel Folder
url = "CategoryData/GetProjectForCategory/" + id;
response = client.GetAsync(url).Result;
//Can catch the status code (200 OK, 301 REDIRECT), etc.
Debug.WriteLine(response.StatusCode);
IEnumerable <ProjectDto> SelectedProjects = response.Content.ReadAsAsync <IEnumerable <ProjectDto> >().Result;
ViewModel.CategoryProjects = SelectedProjects;//Seen in the ViewModel Folder
return(View(ViewModel));
}
else
{
return(RedirectToAction("Error"));
}
}
public async Task Handle(ShowCategory message)
{
var category = await repository.Get(message.Id.ToString());
category.Show();
await repository.Save(category);
}
public ActionResult List(int id)
{
//degugging:
Debug.WriteLine("List all categories");
//category side: list all category:
string cate_query = "SELECT * FROM Categories ";
List <Category> listCategories = db.Categories.SqlQuery(cate_query).ToList();
//chemical side: one category to many chemicals:
//get selected category:
string main_query = "SELECT * FROM Categories WHERE CategoryID = @id";
var pk_parameter = new SqlParameter("@id", id);
Category Category = db.Categories.SqlQuery(main_query, pk_parameter).FirstOrDefault();
string che_query = "SELECT * FROM Chemicals INNER JOIN Categories ON Categories.CategoryID = Chemicals.CategoryID WHERE Chemicals.CategoryID = @id";
var fk_parameter = new SqlParameter("@id", id);
List <Chemical> chemicals = db.Chemicals.SqlQuery(che_query, fk_parameter).ToList();
ShowCategory Viewmodel = new ShowCategory();
Viewmodel.category = Category;
Viewmodel.chemicals = chemicals;
return(View(Viewmodel));
}
/// <summary>
/// 添加信息信息
/// </summary>
/// <param name="inputDtos">要添加的店铺信息DTO信息</param>
/// <returns>业务操作结果</returns>
public OperationResult AddShowCategorys(params ShowCategoryInputDto[] inputDtos)
{
return(ShowCategoryRepository.Insert(inputDtos,
dto =>
{
if (ShowCategoryRepository.CheckExists(c => c.Name == dto.Name && c.Parent.Id == dto.ParentId))
{
throw new Exception("分类：{0}已经存在，不能添加同名".FormatWith(dto.Name));
}
},
(dto, entity) =>
{
if (dto.ParentId.HasValue && dto.ParentId.Value > 0)
{
ShowCategory parentCategory = ShowCategoryRepository.GetByKey(dto.ParentId.Value);
if (parentCategory == null)
{
throw new Exception("父级不存在");
}
parentCategory.Children.Add(entity);
entity.Parent = parentCategory;
}
return entity;
}));
}
//show:
public ActionResult Show(int id)
{
string main_query = "SELECT * FROM Categories WHERE CategoryID = @id";
var pk_parameter = new SqlParameter("@id", id);
Category Category = db.Categories.SqlQuery(main_query, pk_parameter).FirstOrDefault();
string che_query = "SELECT * FROM Chemicals INNER JOIN Categories ON Categories.CategoryID = Chemicals.CategoryID WHERE Chemicals.CategoryID = @id";
var fk_parameter = new SqlParameter("@id", id);
List <Chemical> chemicals = db.Chemicals.SqlQuery(che_query, fk_parameter).ToList();
ShowCategory Viewmodel = new ShowCategory();
Viewmodel.category = Category;
Viewmodel.chemicals = chemicals;
return(View(Viewmodel));
}
public ActionResult Show(int?id, string ComicSearchKey)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Category category = db.Categories.SqlQuery("select * from categories where categoryid=@CategoryId", new SqlParameter("@CategoryId", id)).FirstOrDefault();
if (category == null)
{
return(HttpNotFound());
}
//display all the comics belong to a categories
string DisplayComicQuery = "select * from Comics inner join ComicCategories on Comics.ComicId = ComicCategories.Comic_ComicId where Category_CategoryId = @id";
SqlParameter param = new SqlParameter("@id", id);
List <Comic> Comics = db.Comics.SqlQuery(DisplayComicQuery, param).ToList();
ShowCategory viewmodel = new ShowCategory();
viewmodel.Category = category; //display the chosen category
viewmodel.Comics = Comics; //display all the comics
string SearchComicQuery = "Select * from comics";
if (ComicSearchKey != "")
{
SearchComicQuery += " where ComicName like " + "'%" + ComicSearchKey + "%'" +
" or ComicYear like " + "'%" + ComicSearchKey + "%'" +
" or ComicDesc like " + "'%" + ComicSearchKey + "%'" + " or ComicPrice like " + "'%" + ComicSearchKey + "%'";
}
//Parameterized query
SqlParameter[] sqlparams = new SqlParameter[1];
sqlparams[0] = new SqlParameter("@ComicSearchKey", ComicSearchKey);
db.Comics.SqlQuery(SearchComicQuery, sqlparams);
return(View(viewmodel));
}
public ActionResult Update(ShowCategoryInputDto[] dtos)
{
dtos.CheckNotNull("dtos");
OperationResult result = GoodsContract.EditShowCategorys(dtos);
ShowCategory showCategory = result.Data as ShowCategory;
if (showCategory != null)
{
return(Json(new ShowCategoryTreeListNodeViewModel
{
Id = showCategory.Id,
ParentId = showCategory.Parent != null ? showCategory.Parent.Id.ToString() : null,
Name = showCategory.Name,
SortCode = showCategory.SortCode,
Link = showCategory.Link,
Logo = showCategory.Logo,
IsShow = showCategory.IsShow
}));
}
else
{
return(Json(result.ToAjaxResult()));
}
}
