public BEPages SelectAll()
{
BEPages ds = new BEPages();
DAPages da = new DAPages();
da.SelectAll(ds.tbl_Pages);
return ds;
}
public BEPages SelectActivePagesAllTypes()
{
BEPages ds = new BEPages();
DAPages da = new DAPages();
da.SelectActivePagesAllTypes(ds.tbl_Pages);
return ds;
}
public BEPages SelectActiveRelatedPageLinks(int originPageTypeID, int originPageTypeSpecificID)
{
BEPages ds = new BEPages();
DAPages da = new DAPages();
da.SelectActiveRelatedPageLinks(originPageTypeID, originPageTypeSpecificID, ds.tbl_Pages);
return ds;
}
public BEPages SelectByOriginPageTypeSpecificIDAndOriginPageTypeID(int originPageTypeSpecificID, int originPageTypeID)
{
BEPages ds = new BEPages();
DARelatedPageLinks da = new DARelatedPageLinks();
da.SelectByOriginPageTypeSpecificIDAndOriginPageTypeID(originPageTypeSpecificID, originPageTypeID, ds.tbl_RelatedPageLinks);
return ds;
}
public BEPages SelectActivePagesByPageTypeID(int pageTypeID)
{
BEPages ds = new BEPages();
DAPages da = new DAPages();
da.SelectActivePagesByPageTypeID(pageTypeID, ds.tbl_Pages);
return ds;
}
public BEPages SelectAllInactive()
{
BEPages ds = new BEPages();
DARelatedPageLinks da = new DARelatedPageLinks();
da.SelectAllInactive(ds.tbl_RelatedPageLinks);
return ds;
}
public BEPages SelectByPageTypeID(int pageTypeID)
{
BEPages ds = new BEPages();
DASearchableFields da = new DASearchableFields();
da.SelectByPageTypeID(pageTypeID, ds.tbl_SearchableFields);
return ds;
}
public BEPages SelectAll()
{
BEPages ds = new BEPages();
DASearchableFields da = new DASearchableFields();
da.SelectAll(ds.tbl_SearchableFields);
return ds;
}
public BEPages SelectAllInactive()
{
BEPages ds = new BEPages();
DAPageTypes da = new DAPageTypes();
da.SelectAllInactive(ds.tbl_PageTypes);
return ds;
}
public BEPages SelectSearchable()
{
BEPages ds = new BEPages();
DAPageTypes da = new DAPageTypes();
da.SelectSearchable(ds.tbl_PageTypes);
return ds;
}
public BEPages SelectByPageTypeIDAndPageTypeSpecificID(int pageTypeID, int pageTypeSpecificID)
{
BEPages ds = new BEPages();
DAPages da = new DAPages();
da.SelectByPageTypeIDAndPageTypeSpecificID(pageTypeID, pageTypeSpecificID, ds.tbl_Pages);
return ds;
}
public BEPages SelectLinkedPagesByPageTypeSpecificIDAndPageTypeID(int pageTypeSpecificID, int pageTypeID)
{
BEPages ds = new BEPages();
DARelatedPageLinks da = new DARelatedPageLinks();
da.SelectLinkedPagesByPageTypeSpecificIDAndPageTypeID(pageTypeSpecificID, pageTypeID, ds.tbl_RelatedPageLinks);
return ds;
}
public BEPages SelectRelatedPageLinkByID(int relatedPageLinkID)
{
BEPages ds = new BEPages();
DARelatedPageLinks da = new DARelatedPageLinks();
da.SelectByID(relatedPageLinkID.ToString(), ds.tbl_RelatedPageLinks);
return ds;
}
public BEPages SelectSearchableFieldByID(int searchableFieldID)
{
BEPages ds = new BEPages();
DASearchableFields da = new DASearchableFields();
da.SelectByID(searchableFieldID.ToString(), ds.tbl_SearchableFields);
return ds;
}
public BEPages SelectPageTypeByID(int pageTypeID)
{
BEPages ds = new BEPages();
DAPageTypes da = new DAPageTypes();
da.SelectByID(pageTypeID.ToString(), ds.tbl_PageTypes);
return ds;
}
private void SaveAnimalInfo()
{
bool isNew = false;
BPAnimals bp = new BPAnimals();
BEAnimals dsAnimals = new BEAnimals();
BEAnimals.tbl_AnimalsRow animal = null;
if (AnimalID > 0)
{
dsAnimals = bp.SelectAnimalByID(AnimalID);
animal = dsAnimals.tbl_Animals.FindByAnimalID(AnimalID);
}
if (animal == null)
{
animal = dsAnimals.tbl_Animals.Newtbl_AnimalsRow();
isNew = true;
}
//page
animal.AnimalTitle = txtAnimalTitle.Text.Trim();
animal.AnimalTypeID = Convert.ToInt32(ddlAnimalTypes.SelectedValue);
animal.AnimalGender = rblGender.SelectedValue;
if (edtAnimalDescription.Text.Trim() == "" || edtAnimalDescription.Text.Trim() == "<p> </p>")
animal.SetAnimalDescriptionNull();
else
animal.AnimalDescription = edtAnimalDescription.Text.Trim();
if (txtAnimalMicrochipped.Text.Trim() != "")
animal.AnimalMicrochipped = txtAnimalMicrochipped.Text.Trim();
else
animal.SetAnimalMicrochippedNull();
if (txtAnimalNeutered.Text.Trim() != "")
animal.AnimalNeutered = txtAnimalNeutered.Text.Trim();
else
animal.SetAnimalNeuteredNull();
if (txtAnimalVaccinations.Text.Trim() != "")
animal.AnimalVaccinations = txtAnimalVaccinations.Text.Trim();
else
animal.SetAnimalVaccinationsNull();
if (dtAnimalIntakeDate.Date != dtAnimalIntakeDate.MinDate)
animal.AnimalIntakeDate = dtAnimalIntakeDate.Date;
else
animal.SetAnimalIntakeDateNull();
if (chkAdopted.Checked)
{
animal.Adopted = true;
animal.Adoptable = false;
}
else
{
animal.Adopted = false;
animal.Adoptable = chkIsAdoptable.Checked;
}
if (chkAnimalActive.Checked)
{
animal.AnimalActive = true;
animal.FeaturedAnimal = chkFeaturedAnimal.Checked;
}
else
{
animal.AnimalActive = false;
animal.FeaturedAnimal = false;
}
animal.DateModified = DateTime.Now;
animal.ModifiedByAdminID = Convert.ToInt32(COPRUser.COPRIdentity.MemberID);
if (isNew)
{
animal.AnimalOrder = bp.GetAnimalMaxOrder();
animal.DateCreated = DateTime.Now;
dsAnimals.tbl_Animals.Addtbl_AnimalsRow(animal);
}
bp.Update(dsAnimals);
AnimalID = animal.AnimalID;
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 = AnimalID;
pageRow.SetSubTypeIDNull();
dsPages.tbl_Pages.Addtbl_PagesRow(pageRow);
bpPages.Update(dsPages);
PageID = pageRow.PageID;
}
AddUpdateImageCategory(animal.AnimalTitle);
}
public void Update(BEPages ds)
{
DAPageTypes da = new DAPageTypes();
da.Update(ds.tbl_PageTypes);
}
private void SaveStoryInfo()
{
bool isNew = false;
BPStories bp = new BPStories();
BEStories dsStories = new BEStories();
BEStories.tbl_StoriesRow story = null;
if (StoryID > 0)
{
dsStories = bp.SelectStoryByID(StoryID);
story = dsStories.tbl_Stories.FindByStoryID(StoryID);
}
if (story == null)
{
story = dsStories.tbl_Stories.Newtbl_StoriesRow();
isNew = true;
}
//page
story.StoryTitle = txtPageTitle.Text.Trim();
if (edtContentBody1.Text.Trim() == "" || edtContentBody1.Text.Trim() == "<p> </p>")
story.SetStoryBody1Null();
else
story.StoryBody1 = edtContentBody1.Text.Trim();
story.StoryActive = chkStoryActive.Checked;
story.DateModified = DateTime.Now;
story.ModifiedByAdminID = PageUserID;
if (isNew)
{
story.StoryTypeID = SubTypeID;
story.StoryOrder = bp.GetStoryMaxOrder(SubTypeID);
story.DateCreated = DateTime.Now;
dsStories.tbl_Stories.Addtbl_StoriesRow(story);
}
bp.Update(dsStories);
StoryID = story.StoryID;
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 = StoryID;
pageRow.SubTypeID = SubTypeID;
dsPages.tbl_Pages.Addtbl_PagesRow(pageRow);
bpPages.Update(dsPages);
PageID = pageRow.PageID;
}
AddUpdateImageCategory(story.StoryTitle);
}
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);
}
public BEPages SearchPages(string selectClause, string whereClause, string tableName)
{
BEPages ds = new BEPages();
DAPages da = new DAPages();
da.SearchPages(selectClause, whereClause, tableName, ds.tbl_SearchResults);
return ds;
}
//public BEPages SelectAllActive()
//{
// BEPages ds = new BEPages();
// DASearchableFields da = new DASearchableFields();
// da.SelectAllActive(ds.tbl_SearchableFields);
// return ds;
//}
//public BEPages SelectAllInactive()
//{
// BEPages ds = new BEPages();
// DASearchableFields da = new DASearchableFields();
// da.SelectAllInactive(ds.tbl_SearchableFields);
// return ds;
//}
public void Update(BEPages ds)
{
DASearchableFields da = new DASearchableFields();
da.Update(ds.tbl_SearchableFields);
}
public void Update(BEPages ds)
{
DARelatedPageLinks da = new DARelatedPageLinks();
da.Update(ds.tbl_RelatedPageLinks);
}
private void SaveHomeInfo()
{
bool isNew = false;
BPHome bp = new BPHome();
BEHome ds = new BEHome();
BEHome.tbl_HomeRow homeRow = null;
int tempImageID1 = 0;
if (HomeID > 0)
{
ds = bp.SelectHomeByID(HomeID);
homeRow = ds.tbl_Home.FindByHomeID(HomeID);
if (!homeRow.IsHomeImageIDNull())
tempImageID1 = homeRow.HomeImageID;
}
if (homeRow == null)
{
homeRow = ds.tbl_Home.Newtbl_HomeRow();
isNew = true;
}
homeRow.HomeTitle = txtHomeTitle.Text.Trim();
if (txtHomeTitleFR.Text.Trim() != "")
homeRow.HomeTitleFR = txtHomeTitleFR.Text.Trim();
else
homeRow.SetHomeTitleFRNull();
if (txtHomeText.Text.Trim() != "")
homeRow.HomeText = txtHomeText.Text.Trim();
else
homeRow.SetHomeTextNull();
if (txtHomeTextFR.Text.Trim() != "")
homeRow.HomeTextFR = txtHomeTextFR.Text.Trim();
else
homeRow.SetHomeTextFRNull();
if (imgHomeImage.SelectedImage > 0)
homeRow.HomeImageID = imgHomeImage.SelectedImage;
else
homeRow.SetHomeImageIDNull();
homeRow.DateModified = DateTime.Now;
homeRow.ModifiedByAdminID = Convert.ToInt32(PageUserID);
if (isNew)
{
homeRow.HomeActive = true;
homeRow.DateCreated = DateTime.Now;
ds.tbl_Home.Addtbl_HomeRow(homeRow);
}
bp.Update(ds);
HomeID = homeRow.HomeID;
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 = HomeID;
dsPages.tbl_Pages.Addtbl_PagesRow(pageRow);
bpPages.Update(dsPages);
}
SaveLinkInfo(isNew);
//Resize images
int[] selectedImageIDs = new int[1];
bool doResize = false;
if (!homeRow.IsHomeImageIDNull() && (homeRow.HomeImageID != tempImageID1))
{
selectedImageIDs[0] = homeRow.HomeImageID;
doResize = true;
}
//if (!homeRow.IsLinkList2ImageIDNull() && (homeRow.LinkList2ImageID != tempImageID2))
//{
// selectedImageIDs[1] = imgLinkList2Image.SelectedImage;
// doResize = true;
//}
if (doResize)
ResizePageImages(selectedImageIDs);
}
