public async Task <IActionResult> Edit(int id, [Bind("Id,NameCategory,DateAdded")] CategoryNews categoryNews) { if (id != categoryNews.Id) { return(NotFound()); } if (ModelState.IsValid) { try { _context.Update(categoryNews); await _context.SaveChangesAsync(); } catch (DbUpdateConcurrencyException) { if (!CategoryNewsExists(categoryNews.Id)) { return(NotFound()); } else { throw; } } return(RedirectToAction(nameof(Index))); } return(View(categoryNews)); }
protected void btnSave_Click(object sender, EventArgs e) { int PId = 0; try { PId = Convert.ToInt32(Request.QueryString["Id"].ToString()); } catch (Exception) { } CategoryNews catNew = new CategoryNews(); int result = 0; catNew.Name = txtName.Text; catNew.Code = txtCatCode.Text; catNew.CreateAt = Utilitys.get_date_server(txtCreateAt.Text); catNew.CreateBy = txtCreateBy.Text; if (PId != 0) { catNew.Id = PId; result = CategoryNewsController.UpdateCategoryNews(catNew); } else { result = CategoryNewsController.InsertCategoryNews(catNew); } if (result == 0) { lblResult.Text = "Can not save infomation!!!"; } else { Response.Redirect("CategoryNewsView.aspx"); } }
public void UpdateCatgoryNews(CategoryNews categoryNews) { if (categoryNews == null) { throw new ArgumentNullException(nameof(categoryNews)); } _categoryNewsRepository.Update(categoryNews); }
public void InsertCategoryNews(CategoryNews categoryNews) { if (categoryNews == null) { throw new ArgumentNullException(nameof(categoryNews)); } _categoryNewsRepository.Insert(categoryNews); }
public async Task <IActionResult> Create([Bind("Id,NameCategory,DateAdded")] CategoryNews categoryNews) { if (ModelState.IsValid) { _context.Add(categoryNews); await _context.SaveChangesAsync(); return(RedirectToAction(nameof(Index))); } return(View(categoryNews)); }
/// <summary> /// Updates the product category mapping /// </summary> /// <param name="productCategory">>Product category mapping</param> public virtual void UpdateProductCategory(CategoryNews productCategory) { if (productCategory == null) { throw new ArgumentNullException(nameof(productCategory)); } _categoryNewsRepository.Update(productCategory); //cache _cacheManager.RemoveByPattern(AgsCatalogDefaults.NewsItemCategoriesPatternCacheKey); }
private void BindData() { CategoryNews catNew = new CategoryNews(); int PId = Convert.ToInt32(Request.QueryString["Id"].ToString()); catNew.Id = PId; DataTable tb = CategoryNewsController.SelectOneCategoryNews(catNew); if (tb.Rows.Count > 0) { txtName.Text = tb.Rows[0]["Name"].ToString(); txtCatCode.Text = tb.Rows[0]["Code"].ToString(); txtCreateAt.Text = Utilitys.parse_datetime_server(tb.Rows[0]["CreateAt"].ToString()); txtCreateBy.Text = tb.Rows[0]["CreateBy"].ToString(); } }
protected void Page_Load(object sender, EventArgs e) { //var web = SPContext.Current.Web; if (!IsPostBack) { CategoryNews catNewsBo = new CategoryNews(SPContext.Current.Web); var catIdFromQuery = Request.QueryString["catId"]; var catId = 0; int.TryParse(catIdFromQuery, out catId); var dt = catNewsBo.get_Category(web, Convert.ToString(catId)); rpLeftMenu.DataSource = dt; rpLeftMenu.DataBind(); } }
public static int DeleteCategoryNews(CategoryNews objCatNews, SqlTransaction tran) { try { SqlParameter[] paramArray = new SqlParameter[] { AddSqlPrameter("@Id", SqlDbType.Int,0, ParameterDirection.Input,objCatNews.Id) }; return ExecuteProcedureNonQuery(tran, "Delete_CategoryNews", paramArray); } catch (Exception) { throw; } }
public async Task Initial() { AllNews = await _dbContext.News.Include(n => n.Images).Include(n => n.Detail).OrderByDescending(n => n.Detail.ClickCount).AsNoTracking().ToListAsync(); BannerNews = AllNews.Where(p => p.Images.Count() > 0).Take(4); TopNewsGroup = new List <TopNewsGroup>(); for (int i = 0; i < GroupNumber; i++) { TopNewsGroup group = new TopNewsGroup(AllNews.Skip(TopNewsGroup.Count() * 3).Take(3)); ((List <TopNewsGroup>)TopNewsGroup).Add(group); } //HotNewsGroup = new HotNewsGroup { ImageNews = AllNews.Where(p => p.Images.Count() > 0).Take(4),News = AllNews.Take(10) }; CategoryNews = new CategoryNews { News = AllNews.Skip(TopNewsGroup.Count() * 3) }; }
public static int InsertCategoryNews(CategoryNews objCatNews, SqlTransaction tran) { try { SqlParameter[] paramArray = new SqlParameter[] { AddSqlPrameter("@Name", SqlDbType.NVarChar, 250, ParameterDirection.Input,objCatNews.Name), AddSqlPrameter("@Code", SqlDbType.VarChar, 250, ParameterDirection.Input,objCatNews.Code), AddSqlPrameter("@CreateAt", SqlDbType.VarChar, 10, ParameterDirection.Input,objCatNews.CreateAt), AddSqlPrameter("@CreateBy", SqlDbType.NVarChar, 250, ParameterDirection.Input,objCatNews.CreateBy), AddSqlPrameter("@Flag", SqlDbType.Char, 1, ParameterDirection.Input,objCatNews.Flag) }; return ExecuteProcedureNonQuery(tran, "Insert_CategoryNews", paramArray); } catch (Exception) { throw; } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { catNew = new CategoryNews(SPContext.Current.Web); newsBo = new News(SPContext.Current.Web); var pageTitle = HttpContext.GetGlobalResourceObject("napas.resource", "News").ToString(); CurrentPage = Request.QueryString["page"] == null ? 1 : int.Parse(Request.QueryString["page"].ToString()); var tbCategories = catNew.get_CategoryNews(web); id = Request.QueryString["catId"] == null ? tbCategories.Rows[0][Constants.CommonField.ID].ToString() : Request.QueryString["catId"].ToString(); if (Request.QueryString["catId"] == null) { if (tbCategories.Rows.Count > 0) { SetSessionString(Constants.SessionText.CategorySession, tbCategories.Rows[0][Constants.CommonField.ID].ToString(), true); } else { SetSessionString(Constants.SessionText.CategorySession, string.Empty, true); } } else { SetSessionString(Constants.SessionText.CategorySession, Request.QueryString["catId"].ToString(), true); } catItem = catNew.get_CategoryInfo(web, Convert.ToInt32(id)); if (catItem != null) { ltCat.Text = catItem.Url2; pageTitle += " - " + catItem.Title; } SetPageTitles(pageTitle); BindDataIntoRepeater(); } }
/// <summary> /// Update category News /// </summary> /// <param name="objCatNews"></param> /// <returns></returns> public static int UpdateCategoryNews(CategoryNews objCatNews) { return UpdateCategoryNews(objCatNews, null); }
/// <summary> /// Select one category news by Id /// </summary> /// <param name="objCatNews"></param> /// <returns></returns> public static DataTable SelectOneCategoryNews(CategoryNews objCatNews) { return SelectOneCategoryNews(objCatNews, null); }
/// <summary> /// Insert new Category News /// </summary> /// <param name="objCatNews"></param> /// <returns></returns> public static int InsertCategoryNews(CategoryNews objCatNews) { return InsertCategoryNews(objCatNews, null); }
/// <summary> /// Delete Category news /// </summary> /// <param name="objCatNews"></param> /// <returns></returns> public static int DeleteCategoryNews(CategoryNews objCatNews) { return DeleteCategoryNews(objCatNews, null); }
public static DataTable SelectOneCategoryNews(CategoryNews objCatNews, SqlTransaction tran) { try { SqlParameter[] paramArray = new SqlParameter[] { AddSqlPrameter("@Id", SqlDbType.Int,0, ParameterDirection.Input,objCatNews.Id) }; return ExecuteProcedure(tran, "SelectOne_CategoryNews", paramArray).Tables[0]; } catch (Exception) { throw; } }