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