public static List <Album> GetAll(int postID)
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
var query = (
from a in db.Albums
where a.PostID == postID
orderby a.Rank ascending
select a
);
List <Album> albums = query.ToList();
if (albums.Count == 0)
{
return(albums);
}
foreach (Album album in albums)
{
var imageQuery = (
from i in db.Images
where i.AlbumID == album.AlbumID
orderby i.Main descending
select i
);
album.MainImage = imageQuery.FirstOrDefault();
}
return(albums);
}
}
public void Update()
{
SlickCMSDataContext dc = SlickCMSDataContext.Create();
Property property = dc.Properties.Single(p => p.PropertyID == this.PropertyID);
property.Reference = this.Reference;
property.SaleType = this.SaleType;
property.PropertyType = this.PropertyType;
property.Address1 = this.Address1;
property.Address2 = this.Address2;
property.Address3 = this.Address3;
property.Address4 = this.Address4;
property.PostCode = this.PostCode;
property.Price = this.Price;
property.Parking = this.Parking;
property.Garages = this.Garages;
property.Receptions = this.Receptions;
property.Bedrooms = this.Bedrooms;
property.Bathrooms = this.Bathrooms;
property.Garden = this.Garden;
property.Pets = this.Pets;
property.Conservatory = this.Conservatory;
property.Furnishings = this.Furnishings;
property.Summary = this.Summary;
property.FullDescription = this.FullDescription;
property.KeyFeatures = this.KeyFeatures;
property.RightMoveURL = this.RightMoveURL;
property.DateModified = DateTime.Now;
property.Published = this.Published;
property.Tagline = this.Tagline;
dc.SubmitChanges();
dc.Dispose();
}
public static Album Get(int albumID)
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
return(db.Albums.Where(p => p.AlbumID == albumID).FirstOrDefault());
}
}
public static List <string> SelectFurnishings()
{
SlickCMSDataContext dc = SlickCMSDataContext.Create();
var query = (from p in dc.Properties orderby p.Furnishings ascending select p.Furnishings.ToString()).Distinct();
return(query.ToList());
}
public static List <PostSummary> GetArchived(int postID)
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
var query = (
from p in db.Posts
where
p.Archive != null &&
p.Published == 1 &&
p.Pageable == 0 &&
!p.Deleted &&
p.ParentPage == postID
orderby p.Rank
select new PostSummary
{
PostID = p.PostID,
Title = p.Title,
URL = p.URL,
ParentPage = p.ParentPage,
Archive = p.Archive,
}
);
return(query.ToList());
}
}
public void Delete()
{
SlickCMSDataContext dc = SlickCMSDataContext.Create();
dc.ExecuteCommand("Delete From Documents Where DocumentID = {0}", this.DocumentID);
dc.Dispose();
}
public void Delete()
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
db.ExecuteCommand("Delete From Links Where LinkID = {0}", this.LinkID);
}
}
public static Comment Get(int commentID)
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
return(db.Comments.Where(c => c.CommentID == commentID).FirstOrDefault());
}
}
/// <summary>
/// Searches Properties using a specified search
/// </summary>
/// <param name="skip"></param>
/// <param name="take"></param>
/// <param name="search">Search query</param>
/// <returns></returns>
public List <Property> SelectMultiple(int skip, int take, string search)
{
search = search.ToLower(); //case insensitive searching
SlickCMSDataContext dc = SlickCMSDataContext.Create();
var query = (
from p in dc.Properties
where
p.SaleType.Contains(search) ||
p.PropertyType.Contains(search) ||
p.Price.ToString().Contains(search) ||
//p.Bedrooms.ToString().Contains(search) ||
//p.Bathrooms.ToString().Contains(search) ||
p.Furnishings.Contains(search) ||
p.Address2.Contains(search) ||
p.Address3.Contains(search) ||
p.Address4.Contains(search) ||
p.FullDescription.Contains(search) ||
p.KeyFeatures.Contains(search) ||
p.Summary.Contains(search) ||
p.PostCode.Contains(search)
select p
);
query = query.OrderByDescending(p => p.DateModified);
return(query.Skip(skip).Take(take).ToList());
}
public void Delete(string path)
{
/*SlickCMSDataContext dc = SlickCMSDataContext.Create();
* dc.ExecuteCommand("Delete From Images Where ImageID = {0}", this.ImageID);
* dc.Dispose();*/
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
var obj = (from i in db.Images where i.ImageID == this.ImageID select i).FirstOrDefault();
db.Images.DeleteOnSubmit(obj);
db.SubmitChanges();
}
if (path.Length > 0)
{
string file = path + "[folder]\\" + this.Name + this.Extension;
string thumbImage = file.Replace("[folder]", "thumb");
string largeImage = file.Replace("[folder]", "large");
string originalImage = file.Replace("[folder]", "original");
if (File.Exists(thumbImage))
{
File.Delete(thumbImage);
}
if (File.Exists(largeImage))
{
File.Delete(largeImage);
}
if (File.Exists(originalImage))
{
File.Delete(originalImage);
}
}
}
public Post Select(string archive, string url)
{
using (SlickCMSDataContext dc = SlickCMSDataContext.Create())
{
var query = (
from p in dc.Posts
where
p.URL == url &&
!p.Deleted &&
p.Archive == archive
select p
);
Post post = query.FirstOrDefault();
if (post == null)
{
// TODO: show 404 page
query = (from p in dc.Posts where p.URL == "404" select p);
post = query.FirstOrDefault();
}
return(post);
}
}
public static Newsletter Get(int newsletterID)
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
return(db.Newsletters.Where(p => p.NewsletterID == newsletterID).FirstOrDefault());
}
}
public Post Select(string url)
{
SlickCMSDataContext dc = SlickCMSDataContext.Create();
var query = (
from p in dc.Posts
where
p.URL == url &&
!p.Deleted &&
p.Archive == null // excluding archived posts, as they should now be retrieved using Select() passing in archive
select p
);
Post post = query.FirstOrDefault();
//Post post = dc.Posts.SingleOrDefault(p => p.URL == url);
if (post == null)
{
//show 404 page
// TODO: 404 is no longer stored within database - specify it as a static post object defined within this class?
query = (from p in dc.Posts where p.URL == "404" select p);
post = query.FirstOrDefault();
//post = dc.Posts.SingleOrDefault(p => p.URL == "404");
}
return(post);
}
public static Event Get(int eventID)
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
return(db.Events.Where(e => e.EventID == eventID).FirstOrDefault());
}
}
public static User Get(int userID)
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
return(db.Users.Where(u => u.UserID == userID).FirstOrDefault());
}
}
/// <summary>
/// Gets all images
/// </summary>
/// <param name="postID">Set to ID of the Post, to retrieve all of its images</param>
/// <returns></returns>
public static List <Image> GetAll(int albumID)
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
var query = (
from i in db.Images
where i.AlbumID == albumID
select i
);
/*if (albumID > 0)
* {
* query = query.Where(p => p.AlbumID == albumID);
* }*/
if (albumID == 0)
{
query = query.OrderBy(i => i.Title);
}
else
{
query = query.OrderBy(i => i.Rank);
}
return(query.ToList());
}
}
public static List <PostSummary> SelectSubPages(int parentPage)
{
SlickCMSDataContext dc = SlickCMSDataContext.Create();
var query = (
from p in dc.Posts
where
1 == 1
//&& p.Published == 1
&& p.ParentPage == parentPage &&
p.Pageable == 0 &&
!p.Deleted
//&& p.Archive == null
orderby p.Rank ?? 0 ascending
select new PostSummary
{
Title = p.Title,
URL = p.URL,
PostID = p.PostID,
Published = (p.Published == 1),
Archive = p.Archive,
}
);
return(query.ToList());
}
public static List <PostSummary> SelectNavigation()
{
string[] excludedPages = { "terms-and-conditions", "child-protection-policy" }; // titles to exclude from navigation
SlickCMSDataContext dc = SlickCMSDataContext.Create();
var query = (
from p in dc.Posts
where
1 == 1
//&& p.Published == 1
&& p.Pageable == 0 &&
!excludedPages.Contains(p.URL) &&
p.ParentPage == 0 && // exclude sub-pages and nulls
!p.Deleted
//&& p.Archive == null
//orderby p.Title ascending// TODO: implement ordering
orderby p.Rank ?? 0 ascending
select new PostSummary
{
PostID = p.PostID,
Title = p.Title,
URL = p.URL,
ParentPage = p.ParentPage,
Archive = p.Archive,
Published = (p.Published == 1),
}
);
return(query.ToList());
}
public static Link Get(int linkID)
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
return(db.Links.Where(p => p.LinkID == linkID).FirstOrDefault());
}
}
public void Add()
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
db.Newsletters.InsertOnSubmit(this);
db.SubmitChanges();
}
}
public void Add()
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
db.Announcements.InsertOnSubmit(this);
db.SubmitChanges();
}
}
public static int CountPublished()
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
var query = (from ni in db.NewsItems where ni.Published == 1 select ni);
return(query.Count());
}
}
/// <summary>
/// Gets the ID of the latest Post, useful for carrying out further operations
/// </summary>
/// <returns>ID of the latest Post</returns>
/*public int SelectPostID()
* {
* SlickCMSDataContext dc = SlickCMSDataContext.Create();
* return (from p in dc.Posts orderby p.PostID descending select p.PostID).FirstOrDefault();
* }*/
/// <summary>
/// Retrieves a list of Post titles
/// </summary>
/// <returns>List of PostTitle</returns>
public List <PostTitle> SelectPostTitles()
{
SlickCMSDataContext dc = SlickCMSDataContext.Create();
return((from p in dc.Posts where !p.Deleted select new PostTitle {
Title = p.Title
}).Distinct().OrderBy(p => p.Title).ToList());
}
public void Insert()
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
db.Links.InsertOnSubmit(this);
db.SubmitChanges();
}
}
public static string SelectPostTitle(int postID)
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
var query = (from p in db.Posts where p.PostID == postID select p.Title);
return(query.FirstOrDefault());
}
}
public static int CountBlogPosts()
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
var query = (from p in db.Posts where p.Pageable == 1 && p.Published == 1 select p);
return(query.Count());
}
}
/// <summary>
/// Deletes an existing Comment
/// </summary>
public void Delete()
{
SlickCMSDataContext dc = SlickCMSDataContext.Create();
dc.Comments.DeleteOnSubmit(this);
dc.SubmitChanges();
dc.Dispose();
}
private void LogToDatabase()
{
SlickCMSDataContext db = SlickCMSDataContext.Create();
db.Logs.InsertOnSubmit(this);
db.SubmitChanges();
db.Dispose();
}
public void Delete()
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
Event obj = (from e in db.Events where e.EventID == this.EventID select e).FirstOrDefault();
db.Events.DeleteOnSubmit(obj);
db.SubmitChanges();
}
}
public void Delete()
{
using (SlickCMSDataContext db = SlickCMSDataContext.Create())
{
Newsletter obj = (from n in db.Newsletters where n.NewsletterID == this.NewsletterID select n).FirstOrDefault();
db.Newsletters.DeleteOnSubmit(obj);
db.SubmitChanges();
}
}