public int Add(string name, string profileText, int sortOrder)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Profile_Insert(name, profileText, sortOrder);
}
}
public int Add(string name, string email, string comment)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Guestbook_Insert(name, email, comment, null);
}
}
public bool Delete(int guestbookID)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Guestbook_Delete(guestbookID);
}
}
public int Add(string url, string title, string note, int sortOrder)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Link_Insert(url, title, note, sortOrder);
}
}
public bool Delete(int gigID)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Gig_Delete(gigID);
}
}
public void Add(string name, string description, int sortOrder)
{
using (SprocWrapper db = new SprocWrapper())
{
db.Gallery_Insert(name, description, sortOrder);
}
}
public bool Delete(int galleryID)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Gallery_Delete(galleryID);
}
}
public bool Update(int newsID,string subject, string newsText)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.News_Update(newsID, subject, newsText);
}
}
public bool Delete(int linkID)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Link_Delete(linkID);
}
}
public bool Delete(int newsID)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.News_Delete(newsID);
}
}
public int Add(string subject, string newsText)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.News_Insert(subject, newsText, DateTime.Now);
}
}
public int Add(string description, string venue, DateTime startDateTime)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Gig_Insert(description, venue, startDateTime);
}
}
public bool Delete(int profileID)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Profile_Delete(profileID);
}
}
public IList<News> Get(string where, string orderBy, int startIndex, int noRecords, out int totalNoRecords)
{
IList<News> news = new List<News>();
using (SprocWrapper db = new SprocWrapper())
{
using (IDataReader reader = db.NewsItems_Get(where, orderBy))
{
FillNewsCollection(reader, news, startIndex, noRecords, out totalNoRecords);
}
}
return news;
}
public IList<Guestbook> Get(string where, string orderBy, int startIndex, int noRecords, out int totalNoRecords)
{
IList<Guestbook> guestbookEntries = new List<Guestbook>();
using (SprocWrapper db = new SprocWrapper())
{
using (IDataReader reader = db.GuestbookEntries_Get(where, orderBy))
{
FillGuestbookCollection(reader, guestbookEntries, startIndex, noRecords, out totalNoRecords);
}
}
return guestbookEntries;
}
public IList<Link> Get(string where, string orderBy, int startIndex, int noRecords, out int totalNoRecords)
{
IList<Link> links = new List<Link>();
using (SprocWrapper db = new SprocWrapper())
{
using (IDataReader reader = db.Links_Get(where, orderBy))
{
FillLinkCollection(reader, links, 0, Int32.MaxValue, out totalNoRecords);
}
}
return links;
}
public IList<Gig> Get(string where, string orderBy, int startIndex, int noRecords, out int totalNoRecords)
{
IList<Gig> gigs = new List<Gig>();
using (SprocWrapper db = new SprocWrapper())
{
using (IDataReader reader = db.Gigs_Get(where, orderBy))
{
FillGigCollection(reader, gigs, 0, Int32.MaxValue, out totalNoRecords);
}
}
return gigs;
}
public IList<Gallery> Get()
{
IList<Gallery> galleries = new List<Gallery>();
using (SprocWrapper db = new SprocWrapper())
{
using (IDataReader reader = db.Gallery_Get(null,"SortOrder ASC"))
{
int total;
FillGalleryCollection(reader, galleries, 0, Int32.MaxValue, out total);
}
}
return galleries;
}
public IList<Profile> GetAll()
{
IList<Profile> galleries = new List<Profile>();
using (SprocWrapper db = new SprocWrapper())
{
using (IDataReader reader = db.Profile_Get())
{
int total;
FillProfileCollection(reader, galleries, 0, Int32.MaxValue, out total);
}
}
return galleries;
}
public Gallery GetGallery(int galleryID)
{
IList<Gallery> galleries = new List<Gallery>();
using (SprocWrapper db = new SprocWrapper())
{
using (IDataReader reader = db.Gallery_Get("GalleryID=" + galleryID.ToString(), "SortOrder ASC"))
{
int total;
FillGalleryCollection(reader, galleries, 0, Int32.MaxValue, out total);
}
}
if (galleries.Count == 1)
return galleries[0];
else
return null;
}
public Profile GetProfile(int profileID)
{
IList<Profile> galleries = new List<Profile>();
using (SprocWrapper db = new SprocWrapper())
{
using (IDataReader reader = db.Profile_Get(profileID))
{
int total;
FillProfileCollection(reader, galleries, 0, Int32.MaxValue, out total);
}
}
if (galleries.Count == 1)
return galleries[0];
else
return null;
}
public bool Update(int linkID, string url, string title, string note, int sortOrder)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Link_Update(linkID, url, title, note, sortOrder);
}
}
public bool Update(int galleryID, string name, string description, int sortOrder, string displayImage)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Gallery_Update(galleryID, name, description, sortOrder, displayImage);
}
}
public bool Update(int gigID, string description, string venue, DateTime startDateTime)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Gig_Update(gigID, description, venue, startDateTime);
}
}
public bool Update(int guestbookID, string reply)
{
Guestbook guestbook=Get(guestbookID);
using (SprocWrapper db = new SprocWrapper())
{
return db.Guestbook_Update(guestbookID, guestbook.Name, guestbook.Email, guestbook.Comment, reply,guestbook.Display);
}
}
public bool Update(int profileID, string name, string profileText, int sortOrder)
{
using (SprocWrapper db = new SprocWrapper())
{
return db.Profile_Update(profileID, name, profileText, sortOrder);
}
}