public static int InsertNewsCategory(NewsCategory newsCategory)
{
return(SQLDataAccess.ExecuteScalar <int>("Insert into [Settings].[NewsCategory] ([Name],[SortOrder],[UrlPath]) values (@Name,@SortOrder,@UrlPath); Select SCOPE_IDENTITY ();",
CommandType.Text,
new SqlParameter("@Name", newsCategory.Name),
new SqlParameter("@UrlPath", newsCategory.UrlPath),
new SqlParameter("@SortOrder", newsCategory.SortOrder)));
}
public static void UpdateNewsCategory(NewsCategory newsCategory)
{
SQLDataAccess.ExecuteNonQuery("Update [Settings].[NewsCategory] set [Name]=@name,[UrlPath] = @UrlPath , [SortOrder] = @SortOrder where NewsCategoryID = @NewsCategoryID",
CommandType.Text,
new SqlParameter("@NewsCategoryID", newsCategory.NewsCategoryID),
new SqlParameter("@Name", newsCategory.Name),
new SqlParameter("@UrlPath", newsCategory.UrlPath),
new SqlParameter("@SortOrder", newsCategory.SortOrder));
}
public static int InsertNewsCategory(NewsCategory newsCategory)
{
var id = SQLDataAccess.ExecuteScalar <int>("Insert into [Settings].[NewsCategory] ([Name],[SortOrder],[UrlPath]) values (@Name,@SortOrder,@UrlPath); Select SCOPE_IDENTITY ();",
CommandType.Text,
new SqlParameter("@Name", newsCategory.Name),
new SqlParameter("@UrlPath", newsCategory.UrlPath),
new SqlParameter("@SortOrder", newsCategory.SortOrder));
if (newsCategory.Meta != null)
{
if (!newsCategory.Meta.Title.IsNullOrEmpty() || !newsCategory.Meta.MetaKeywords.IsNullOrEmpty() || !newsCategory.Meta.MetaDescription.IsNullOrEmpty() || !newsCategory.Meta.H1.IsNullOrEmpty())
{
newsCategory.Meta.ObjId = id;
MetaInfoService.SetMeta(newsCategory.Meta);
}
}
return(id);
}
public static void UpdateNewsCategory(NewsCategory newsCategory)
{
SQLDataAccess.ExecuteNonQuery("Update [Settings].[NewsCategory] set [Name]=@name,[UrlPath] = @UrlPath , [SortOrder] = @SortOrder where NewsCategoryID = @NewsCategoryID",
CommandType.Text,
new SqlParameter("@NewsCategoryID", newsCategory.NewsCategoryID),
new SqlParameter("@Name", newsCategory.Name),
new SqlParameter("@UrlPath", newsCategory.UrlPath),
new SqlParameter("@SortOrder", newsCategory.SortOrder));
if (newsCategory.Meta != null)
{
if (newsCategory.Meta.Title.IsNullOrEmpty() && newsCategory.Meta.MetaKeywords.IsNullOrEmpty() && newsCategory.Meta.MetaDescription.IsNullOrEmpty() && newsCategory.Meta.H1.IsNullOrEmpty())
{
if (MetaInfoService.IsMetaExist(newsCategory.NewsCategoryID, MetaType.NewsCategory))
{
MetaInfoService.DeleteMetaInfo(newsCategory.NewsCategoryID, MetaType.NewsCategory);
}
}
else
{
MetaInfoService.SetMeta(newsCategory.Meta);
}
}
}
public static void UpdateNewsCategory(NewsCategory newsCategory)
{
SQLDataAccess.ExecuteNonQuery("Update [Settings].[NewsCategory] set [Name]=@name,[UrlPath] = @UrlPath , [SortOrder] = @SortOrder where NewsCategoryID = @NewsCategoryID",
CommandType.Text,
new SqlParameter("@NewsCategoryID", newsCategory.NewsCategoryID),
new SqlParameter("@Name", newsCategory.Name),
new SqlParameter("@UrlPath", newsCategory.UrlPath),
new SqlParameter("@SortOrder", newsCategory.SortOrder));
}
public static int InsertNewsCategory(NewsCategory newsCategory)
{
return SQLDataAccess.ExecuteScalar<int>("Insert into [Settings].[NewsCategory] ([Name],[SortOrder],[UrlPath]) values (@Name,@SortOrder,@UrlPath); Select SCOPE_IDENTITY ();",
CommandType.Text,
new SqlParameter("@Name", newsCategory.Name),
new SqlParameter("@UrlPath", newsCategory.UrlPath),
new SqlParameter("@SortOrder", newsCategory.SortOrder));
}
protected void grid_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "DeleteCategory")
{
NewsService.DeleteNewsCategory(SQLDataHelper.GetInt(e.CommandArgument));
}
if (e.CommandName == "AddCategory")
{
try
{
GridViewRow footer = grid.FooterRow;
if (!UrlService.IsAvalibleUrl(ParamType.NewsCategory, ((TextBox)footer.FindControl("txtNewUrlPath")).Text))
{
lblError.Text = Resource.Admin_SynonymExist;
lblError.Visible = true;
return;
}
var temp = new NewsCategory
{
Name = ((TextBox)footer.FindControl("txtNewName")).Text,
UrlPath = ((TextBox)footer.FindControl("txtNewUrlPath")).Text,
SortOrder = ((TextBox)footer.FindControl("txtNewSortOrder")).Text.TryParseInt()
};
NewsService.InsertNewsCategory(temp);
}
catch (Exception ex)
{
Debug.LogError(ex);
}
grid.ShowFooter = false;
}
if (e.CommandName == "CancelAdd")
{
grid.ShowFooter = false;
}
}
protected void Page_PreRender(object sender, EventArgs e)
{
if (grid.UpdatedRow != null)
{
try
{
var temp = new NewsCategory
{
NewsCategoryID = grid.UpdatedRow["ID"].TryParseInt(),
Name = grid.UpdatedRow["Name"],
UrlPath = grid.UpdatedRow["UrlPath"],
SortOrder = grid.UpdatedRow["SortOrder"].TryParseInt()
};
if (!UrlService.IsAvalibleUrl(temp.NewsCategoryID, ParamType.NewsCategory, temp.UrlPath))
{
lblError.Text = Resource.Admin_SynonymExist;
lblError.Visible = true;
return;
}
NewsService.UpdateNewsCategory(temp);
}
catch (Exception ex)
{
Debug.LogError(ex);
}
}
DataTable data = _paging.PageItems;
while (data.Rows.Count < 1 && _paging.CurrentPageIndex > 1)
{
_paging.CurrentPageIndex--;
data = _paging.PageItems;
}
var clmn = new DataColumn("IsSelected", typeof(bool)) { DefaultValue = _inverseSelection };
data.Columns.Add(clmn);
if ((_selectionFilter != null) && (_selectionFilter.Values != null))
{
for (int i = 0; i <= data.Rows.Count - 1; i++)
{
int intIndex = i;
if (Array.Exists(_selectionFilter.Values, c => c == (data.Rows[intIndex]["ID"]).ToString()))
{
data.Rows[i]["IsSelected"] = !_inverseSelection;
}
}
}
if (data.Rows.Count < 1)
{
goToPage.Visible = false;
}
grid.DataSource = data;
grid.DataBind();
pageNumberer.PageCount = _paging.PageCount;
lblFound.Text = _paging.TotalRowsCount.ToString();
}