public BEArticles SelectByArticleTypeIDWithROColumns(int articleTypeID)
{
BEArticles ds = new BEArticles();
DAArticles da = new DAArticles();
da.SelectByArticleTypeIDWithROColumns(articleTypeID, ds.tbl_Articles);
return ds;
}
public BEArticles SelectActiveByArticleCategoryID(int articleCategoryID)
{
BEArticles ds = new BEArticles();
DAArticles da = new DAArticles();
da.SelectActiveByArticleCategoryID(articleCategoryID, ds.tbl_Articles);
return ds;
}
public BEArticles SelectAllInactive()
{
BEArticles ds = new BEArticles();
DAArticles da = new DAArticles();
da.SelectAllInactive(ds.tbl_Articles);
return ds;
}
public BEArticles SelectAll()
{
BEArticles ds = new BEArticles();
DAArticleCategories da = new DAArticleCategories();
da.SelectAll(ds.tbl_ArticleCategories);
return ds;
}
public BEArticles SelectArticleByID(int articleID)
{
BEArticles ds = new BEArticles();
DAArticles da = new DAArticles();
da.SelectByID(articleID.ToString(), ds.tbl_Articles);
return ds;
}
private void BindTitle()
{
BPArticleTypes bp = new BPArticleTypes();
DSArticleCategories = bp.SelectArticleTypeByID(SubTypeID);
if (DSArticleCategories.tbl_ArticleTypes.Count > 0)
{
BEArticles.tbl_ArticleTypesRow typeRow = DSArticleCategories.tbl_ArticleTypes[0];
lblTitle.Text = "Browse " + typeRow.ArticleTypeName + " Categories";
btnAdd.Text = "Add New";
}
}
protected DataView GetData()
{
BPArticleCategories bp = new BPArticleCategories();
DSArticleCategories = bp.SelectByArticleTypeID(SubTypeID);
DSArticleCategories.tbl_ArticleCategories.DefaultView.Sort = DSArticleCategories.tbl_ArticleCategories.ArticleCategoryOrderColumn.ColumnName;
BindMoveControl(DSArticleCategories.tbl_ArticleCategories.DefaultView);
DSArticleCategories.tbl_ArticleCategories.DefaultView.RowFilter =
RowFilter(DSArticleCategories.tbl_ArticleCategories.ArticleCategoryNameColumn.ColumnName,
((LinkButton)rptLetters.Items[0].FindControl("lnkLetter")).CommandName,
DSArticleCategories.tbl_ArticleCategories.ArticleCategoryActiveColumn.ColumnName,
lstActive.SelectedValue);
return DSArticleCategories.tbl_ArticleCategories.DefaultView;
}
private void SaveCategoryInfo()
{
bool isNew = false;
BPArticleCategories bp = new BPArticleCategories();
BEArticles ds = new BEArticles();
BEArticles.tbl_ArticleCategoriesRow category = null;
if (ArticleCategoryID > 0)
{
ds = bp.SelectByID(ArticleCategoryID);
category = ds.tbl_ArticleCategories.FindByArticleCategoryID(ArticleCategoryID);
if (category.ArticleCategoryActive && (!chkArticleCategoryActive.Checked))
UpdateCategoryItems();
}
if (category == null)
{
category = ds.tbl_ArticleCategories.Newtbl_ArticleCategoriesRow();
isNew = true;
}
category.ArticleCategoryName = txtArticleCategoryName.Text.Trim();
if (txtArticleCategoryDescription.Text.Trim() != "")
category.ArticleCategoryDescription = txtArticleCategoryDescription.Text.Trim();
else
category.SetArticleCategoryDescriptionNull();
category.ArticleTypeID = SubTypeID;
category.ArticleCategoryActive = chkArticleCategoryActive.Checked;
category.DateModified = DateTime.Now;
category.ModifiedByAdminID = PageUserID;
if (isNew)
{
category.ArticleCategoryOrder = bp.GetArticleCategoryMaxOrder(SubTypeID);
category.DateCreated = DateTime.Now;
ds.tbl_ArticleCategories.Addtbl_ArticleCategoriesRow(category);
}
bp.Update(ds);
}
public void Update(BEArticles ds)
{
DAArticles da = new DAArticles();
da.Update(ds.tbl_Articles);
}
private void SaveArticleInfo()
{
bool isNew = false;
BPArticles bp = new BPArticles();
BEArticles dsArticles = new BEArticles();
BEArticles.tbl_ArticlesRow article = null;
int tempImageID1 = 0;
int tempImageID2 = 0;
if (ArticleID > 0)
{
dsArticles = bp.SelectArticleByID(ArticleID);
article = dsArticles.tbl_Articles.FindByArticleID(ArticleID);
if (!article.IsArticleImageID1Null())
tempImageID1 = article.ArticleImageID1;
if (!article.IsArticleImageID2Null())
tempImageID2 = article.ArticleImageID2;
}
if (article == null)
{
article = dsArticles.tbl_Articles.Newtbl_ArticlesRow();
isNew = true;
}
//page
article.ArticleTitle = txtArticleTitle.Text.Trim();
article.ArticleCategoryID = Convert.ToInt32(ddlCategories.SelectedValue);
if (dtArticleDate.Date != dtArticleDate.MinDate)
article.ArticleDate = dtArticleDate.Date;
else
article.SetArticleDateNull();
if (edtBody1.Text.Trim() == "" || edtBody1.Text.Trim() == "<p> </p>")
article.SetArticleBody1Null();
else
article.ArticleBody1 = edtBody1.Text.Trim();
if (edtBody2.Text.Trim() == "" || edtBody2.Text.Trim() == "<p> </p>")
article.SetArticleBody2Null();
else
article.ArticleBody2 = edtBody2.Text.Trim();
//image 1
if (imgArticleImageID1.SelectedImage > 0)
{
article.ArticleImageID1 = imgArticleImageID1.SelectedImage;
if (ddlArticleImageAlignment1.SelectedValue == "Left" || ddlArticleImageAlignment1.SelectedValue == "Right" || ddlArticleImageAlignment1.SelectedValue == "Top" || ddlArticleImageAlignment1.SelectedValue == "Bottom")
article.ArticleImageAlignment1 = Convert.ToInt32(Enum.Parse(typeof(ImageAlignment), ddlArticleImageAlignment1.SelectedValue));
else
article.SetArticleImageAlignment1Null();
}
else
{
article.SetArticleImageID1Null();
article.SetArticleImageAlignment1Null();
}
//image 2
if (imgArticleImageID2.SelectedImage > 0)
{
article.ArticleImageID2 = imgArticleImageID2.SelectedImage;
if (ddlArticleImageAlignment2.SelectedValue == "Left" || ddlArticleImageAlignment2.SelectedValue == "Right" || ddlArticleImageAlignment2.SelectedValue == "Top" || ddlArticleImageAlignment2.SelectedValue == "Bottom")
article.ArticleImageAlignment2 = Convert.ToInt32(Enum.Parse(typeof(ImageAlignment), ddlArticleImageAlignment2.SelectedValue));
else
article.SetArticleImageAlignment2Null();
}
else
{
article.SetArticleImageID2Null();
article.SetArticleImageAlignment2Null();
}
//external article
if (rblExternalArticle.SelectedValue == "True")
{
article.ExternalArticle = true;
if (txtExternalURL.Text.Trim() != "")
{
if (txtExternalURL.Text.Trim().Length < 8)
article.ExternalURL = "http://" + txtExternalURL.Text.Trim();
else if (txtExternalURL.Text.Trim().Substring(0, 7) != "http://" && txtExternalURL.Text.Trim().Substring(0, 8) != "https://")
article.ExternalURL = "http://" + txtExternalURL.Text.Trim();
else
article.ExternalURL = txtExternalURL.Text.Trim();
}
else
article.SetExternalURLNull();
}
else
{
article.ExternalArticle = false;
article.SetExternalURLNull();
}
if (noBrowsePage)
article.ArticleActive = true;
else
article.ArticleActive = chkArticleActive.Checked;
article.DateModified = DateTime.Now;
article.ModifiedByAdminID = PageUserID;
if (isNew)
{
article.ArticleTypeID = SubTypeID;
article.DateCreated = DateTime.Now;
dsArticles.tbl_Articles.Addtbl_ArticlesRow(article);
}
bp.Update(dsArticles);
ArticleID = article.ArticleID;
if (isNew)
{
//Add to main Pages table
BPPages bpPages = new BPPages();
BEPages dsPages = new BEPages();
BEPages.tbl_PagesRow pageRow = dsPages.tbl_Pages.Newtbl_PagesRow();
pageRow.PageTypeID = PageTypeID;
pageRow.PageTypeSpecificID = ArticleID;
pageRow.SubTypeID = SubTypeID;
dsPages.tbl_Pages.Addtbl_PagesRow(pageRow);
bpPages.Update(dsPages);
}
//Resize images
int[] selectedImageIDs = new int[2];
bool doResize = false;
if (!article.IsArticleImageID1Null() && (article.ArticleImageID1 != tempImageID1))
{
selectedImageIDs[0] = imgArticleImageID1.SelectedImage;
doResize = true;
}
if (!article.IsArticleImageID2Null() && (article.ArticleImageID2 != tempImageID2))
{
selectedImageIDs[1] = imgArticleImageID2.SelectedImage;
doResize = true;
}
if (doResize)
ResizePageImages(selectedImageIDs);
}
