public List <Models.WebContent> GetWebContentByPageId(int pageId, GlobalContentDBEntities db)
{
List <Models.WebContent> webContentByPageId = new List <Models.WebContent>();
//Ignore any content that is tied to a subpage id
foreach (var webContent in db.WebContents)
{
if (webContent.SubPageId == null)
{
webContentByPageId.Add(webContent);
}
}
foreach (var webContent in webContentByPageId.ToList())
{
//Ignore any content that is tied to a subpage id
if (webContent.SubPageId == null)
{
if (webContent.PageId != pageId)
{
webContentByPageId.Remove(webContent);
}
}
}
return(webContentByPageId.OrderBy(x => x.Id).ToList());
}
public void CreateHeroImageText(int newColumnId)
{
Models.WebContent webContent = new Models.WebContent();
GlobalContentDBEntities db = new GlobalContentDBEntities();
using (db)
{
if (webContent.Id == default(int))
{
webContent.ColumnId = newColumnId;
//SETTING Global
//Set text
webContent.TextBody = "Your site name here";
//Set position: absolute
webContent.position = "absolute";
//Set left 30%
webContent.left = "30%";
//Font color
webContent.color = "#f6f6f6";
//Set font size:
webContent.fontSize = "90px";
//Set bottom to 500px
webContent.bottom = "500px";
//Set font family
webContent.fontFamily = "Work Sans";
//SETTING MOBILE
webContent.textMobile = "Your site name here";
webContent.positionMobile = "absolute";
webContent.leftMobile = "18%";
webContent.bottomMobile = "350px";
webContent.fontSizeMobile = "40px";
//SETTING TABLET
webContent.textTablet = "Your site name here";
webContent.positionTablet = "absolute";
webContent.leftTablet = "25%";
webContent.bottomTablet = "250px";
webContent.fontSizeTablet = "60px";
//SETTING LAPTOP
webContent.textLaptop = "Your site name here";
webContent.positionLaptop = "absolute";
webContent.leftLaptop = "30%";
webContent.bottomLaptop = "300px";
webContent.fontSizeLaptop = "60px";
db.WebContents.Add(webContent);
}
else
{
db.Entry(webContent).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public List <Models.WebContent> GetWebContentById(int id, GlobalContentDBEntities db)
{
List <Models.WebContent> webContentById = new List <Models.WebContent>();
foreach (var webContent in db.WebContents)
{
webContentById.Add(webContent);
}
foreach (var webContent in webContentById.ToList())
{
if (webContent.Id != id)
{
webContentById.Remove(webContent);
}
}
return(webContentById.OrderBy(x => x.Id).ToList());
}
public void CreateHalfPageHeroImage(int newColumnId)
{
Models.WebContent webContent = new Models.WebContent();
GlobalContentDBEntities db = new GlobalContentDBEntities();
using (db)
{
if (webContent.Id == default(int))
{
webContent.ColumnId = newColumnId;
//set background image
webContent.backgroundImage = "https://images.unsplash.com/photo-1505739998589-00fc191ce01d?ixid=MXwxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHw%3D&ixlib=rb-1.2.1&auto=format&fit=crop&w=1350&q=80";
//set height to 500px
webContent.height = "400px";
webContent.animationName = "";
//SETTING MOBILE
webContent.heightMobile = "400px";
db.WebContents.Add(webContent);
//SETTING LAPTOP
webContent.heightLaptop = "400px";
//SETTING TABLET
webContent.heightTablet = "400px";
}
else
{
db.Entry(webContent).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public void CreateImageForLeftMidColumn(int colId)
{
Models.WebContent webContent = new Models.WebContent();
GlobalContentDBEntities db = new GlobalContentDBEntities();
using (db)
{
if (webContent.Id == default(int))
{
webContent.ColumnId = colId;
//set background image
//blue orange
webContent.backgroundImage = "https://images.unsplash.com/photo-1561641377-f7456d23aa9b?ixid=MnwxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHx8&ixlib=rb-1.2.1&auto=format&fit=crop&w=1226&q=80";
webContent.animationName = "pulse";
webContent.HyperLink = "https://www.google.com/";
//Set image height to 1000px
webContent.height = "400px";
webContent.width = "400px";
//SETTING MOBILE
db.WebContents.Add(webContent);
}
else
{
db.Entry(webContent).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public List <List <Models.WebContent> > GetContentVMLists(int columnId, GlobalContentDBEntities db)
{
List <List <Models.WebContent> > contentVmList = new List <List <Models.WebContent> >();
List <Models.WebContent> contentByColumnId = new List <Models.WebContent>();
foreach (var content in db.WebContents)
{
if (content.ColumnId == columnId)
{
contentByColumnId.Add(content);
}
}
contentVmList.Add(contentByColumnId);
return(contentVmList);
}
//Get all content by column array method here
public List <Models.WebContent> GetContentByColumnId(int columnId, GlobalContentDBEntities db)
{
List <Models.WebContent> contentByColumnId = new List <Models.WebContent>();
//Ignore any content that is tied to a subpage id
foreach (var webContent in db.WebContents)
{
contentByColumnId.Add(webContent);
}
foreach (var webContent in contentByColumnId.ToList())
{
if (webContent.ColumnId != columnId)
{
contentByColumnId.Remove(webContent);
}
}
return(contentByColumnId.OrderBy(x => x.Id).ToList());
}
public void CreateHeroImage(int newColumnId)
{
Models.WebContent webContent = new Models.WebContent();
GlobalContentDBEntities db = new GlobalContentDBEntities();
using (db)
{
if (webContent.Id == default(int))
{
webContent.ColumnId = newColumnId;
//set background image
//blue orange
webContent.backgroundImage = "https://images.unsplash.com/photo-1494253109108-2e30c049369b?ixid=MXwxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHw%3D&ixlib=rb-1.2.1&auto=format&fit=crop&w=1350&q=80";
//palm trees
//webContent.backgroundImage = "https://images.unsplash.com/photo-1601012608788-21e9c7c0661b?ixid=MXwxMjA3fDB8MHxwaG90by1wYWdlfHx8fGVufDB8fHw%3D&ixlib=rb-1.2.1&auto=format&fit=crop&w=1340&q=80";
//Set image height to 1000px
webContent.height = "1000px";
webContent.animationName = "";
//SETTING MOBILE
webContent.heightMobile = "800px";
db.WebContents.Add(webContent);
}
else
{
db.Entry(webContent).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public WebsiteTemplateProject.Models.WebContent UpsertWebContent(WebsiteTemplateProject.Models.WebContent webContent, GlobalContentDBEntities db)
{
using (db)
{
if (webContent.Id == default(int))
{
//Default settings when first creating text
if (webContent.TextBody != null)
{
webContent.textMobile = webContent.TextBody;
webContent.textTablet = webContent.TextBody;
webContent.textLaptop = webContent.TextBody;
webContent.textAlign = "center";
}
//Default settings when first creating background image
db.WebContents.Add(webContent);
}
else
{
db.Entry(webContent).State = EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (DbEntityValidationException e)
{
var newException = new FormattedDbEntityValidationException(e);
throw newException;
}
return(webContent);
}
}
public WebContentService(GlobalContentDBEntities context)
{
_context = context;
}
public void CreateTextForRightColumnTwo(int colId)
{
Models.WebContent webContent = new Models.WebContent();
GlobalContentDBEntities db = new GlobalContentDBEntities();
using (db)
{
if (webContent.Id == default(int))
{
webContent.ColumnId = colId;
//SETTING Global
//Set text
webContent.TextBody = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.";
//Font color
webContent.color = "#222222";
//Set font size:
webContent.fontSize = "18px";
//Set font family
webContent.fontFamily = "Work Sans";
//Set padding
webContent.padding = "15px";
//Set text align
webContent.textAlign = "center";
webContent.paddingMobile = "15px";
webContent.paddingTablet = "15px";
webContent.paddingLaptop = "15px";
//SETTING MOBILE
webContent.textMobile = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.";
webContent.fontSizeMobile = "18px";
webContent.fontFamily = "Work Sans";
webContent.textAlignMobile = "center";
//SETTING TABLET
webContent.textTablet = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.";
webContent.fontSizeTablet = "18px";
webContent.fontFamily = "Work Sans";
webContent.textAlignTablet = "center";
//SETTING LAPTOP
webContent.textLaptop = "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.";
webContent.fontSizeLaptop = "18px";
webContent.fontFamily = "Work Sans";
webContent.textAlignLaptop = "center";
db.WebContents.Add(webContent);
}
else
{
db.Entry(webContent).State = EntityState.Modified;
}
db.SaveChanges();
}
}
public void CreateHeaderForRightColumnTwo(int midHeaderColId)
{
Models.WebContent webContent = new Models.WebContent();
GlobalContentDBEntities db = new GlobalContentDBEntities();
using (db)
{
if (webContent.Id == default(int))
{
webContent.ColumnId = midHeaderColId;
//SETTING Global
//Set text
webContent.TextBody = "Right Header";
//Font color
webContent.color = "#222222";
//Set font size:
webContent.fontSize = "25px";
//Set font family
webContent.fontFamily = "Work Sans";
//Set padding
webContent.padding = "15px";
//Set text align
webContent.textAlign = "center";
webContent.paddingTablet = "30px";
webContent.paddingLaptop = "30px";
//Set font wieght
webContent.fontWieght = "bold";
//SETTING MOBILE
webContent.textMobile = "";
webContent.fontSizeMobile = "25px";
webContent.fontFamily = "Work Sans";
webContent.textAlignMobile = "center";
//SETTING TABLET
webContent.textTablet = "Right Header";
webContent.fontSizeTablet = "25px";
webContent.fontFamily = "Work Sans";
webContent.textAlignTablet = "center";
//SETTING LAPTOP
webContent.textLaptop = "Right Header";
webContent.fontSizeLaptop = "25px";
webContent.fontFamily = "Work Sans";
webContent.textAlignLaptop = "center";
db.WebContents.Add(webContent);
}
else
{
db.Entry(webContent).State = EntityState.Modified;
}
db.SaveChanges();
}
}