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())); } }