protected void BeginMusicianPage()
{
musicianSlug = core.Http["mn"];
try
{
primitive = new Musician(core, musicianSlug);
}
catch (InvalidMusicianException)
{
core.Functions.Generate404();
return;
}
// We do not have customised domains for musician
if (/*string.IsNullOrEmpty(mus.Domain) ||*/ Hyperlink.Domain == core.Http.Domain)
{
core.PagePath = core.PagePath.Substring(Musician.Key.Length + 1 + 6);
}
if (core.PagePath.Trim(new char[] { '/' }) == "")
{
core.PagePath = Musician.Homepage;
}
if (core.PagePath.Trim(new char[] { '/' }) == "")
{
core.PagePath = "/profile";
}
if (loggedInMember != null)
{
if (loggedInMember.UserInfo.ShowCustomStyles)
{
template.Parse("USER_STYLE_SHEET", string.Format("music/{0}.css", primitive.Key));
}
}
else
{
template.Parse("USER_STYLE_SHEET", string.Format("music/{0}.css", primitive.Key));
}
if (!core.PagePath.StartsWith("/account", StringComparison.Ordinal))
{
BoxSocial.Internals.Application.LoadApplications(core, AppPrimitives.Musician, core.PagePath, BoxSocial.Internals.Application.GetApplications(core, primitive));
core.FootHooks += new Core.HookHandler(core_FootHooks);
HookEventArgs e = new HookEventArgs(core, AppPrimitives.Musician, primitive);
core.InvokeHeadHooks(e);
core.InvokePrimitiveHeadHooks(e);
core.InvokeFootHooks(e);
}
PageTitle = primitive.DisplayName;
}
public Tour(Core core, Musician musician, long tourId)
: base(core)
{
this.musician = musician;
ItemLoad += new ItemLoadHandler(Tour_ItemLoad);
try
{
LoadItem(tourId, new FieldValuePair("musician_id", musician.Id));
}
catch (InvalidItemException)
{
throw new InvalidTourException();
}
}
public MusicianMember(Core core, Musician owner, User user)
: base(core)
{
// load the info into a the new object being created
this.userInfo = user.UserInfo;
this.userProfile = user.Profile;
this.userStyle = user.Style;
this.userId = user.UserId;
this.userName = user.UserName;
this.domain = user.UserDomain;
this.emailAddresses = user.EmailAddresses;
SelectQuery sQuery = MusicianMember.GetSelectQueryStub(core, typeof(MusicianMember));
sQuery.AddCondition("user_id", user.Id);
sQuery.AddCondition("musician_id", owner.Id);
try
{
System.Data.Common.DbDataReader reader = core.Db.ReaderQuery(sQuery);
if (reader.HasRows)
{
reader.Read();
loadItemInfo(typeof(MusicianMember), reader);
reader.Close();
reader.Dispose();
}
else
{
reader.Close();
reader.Dispose();
throw new InvalidMusicianMemberException();
}
}
catch (InvalidItemException)
{
throw new InvalidMusicianMemberException();
}
}
public static Gig Create(Core core, Musician owner, Tour tour, long time, ushort timezone, string city, string venue, string gigAbstract, bool allAges)
{
if (core == null)
{
throw new NullCoreException();
}
// TODO: fix this
Item item = Item.Create(core, typeof(Gig), new FieldValuePair("musician_id", owner.Id),
new FieldValuePair("tour_id", ((tour != null) ? tour.Id : 0)),
new FieldValuePair("gig_time_ut", time),
new FieldValuePair("gig_time_zone", timezone),
new FieldValuePair("gig_city", city),
new FieldValuePair("gig_venue", venue),
new FieldValuePair("gig_abstract", gigAbstract),
new FieldValuePair("gig_all_ages", allAges));
Gig gig = (Gig)item;
if (gig.TourId > 0)
{
UpdateQuery uQuery = new UpdateQuery(typeof(Tour));
uQuery.AddField("tour_gigs", new QueryOperation("tour_gigs", QueryOperations.Addition, "1"));
uQuery.AddCondition("tour_id", gig.TourId);
}
return gig;
}
public Gig(Core core, Musician musician, DataRow gigRow)
: base(core)
{
this.musician = musician;
ItemLoad += new ItemLoadHandler(Gig_ItemLoad);
try
{
loadItemInfo(gigRow);
}
catch (InvalidItemException)
{
throw new InvalidGigException();
}
}
public static List<Tour> GetAll(Core core, Musician owner)
{
List<Tour> tours = new List<Tour>();
SelectQuery query = Tour.GetSelectQueryStub(core, typeof(Tour));
query.AddCondition("musician_id", owner.Id);
DataTable tourTable = core.Db.Query(query);
foreach (DataRow dr in tourTable.Rows)
{
tours.Add(new Tour(core, dr));
}
return tours;
}
public static Tour Create(Core core, Musician owner, string title, short year, string tourAbstract)
{
if (core == null)
{
throw new NullCoreException();
}
// TODO: fix this
Item item = Item.Create(core, typeof(Tour), new FieldValuePair("musician_id", owner.Id),
new FieldValuePair("tour_title", title),
new FieldValuePair("tour_year", year),
new FieldValuePair("tour_abstract", tourAbstract));
return (Tour)item;
}
public Tour(Core core, Musician musician, DataRow tourRow)
: base(core)
{
this.musician = musician;
ItemLoad += new ItemLoadHandler(Tour_ItemLoad);
try
{
loadItemInfo(tourRow);
}
catch (InvalidItemException)
{
throw new InvalidTourException();
}
}
public static Release Create(Core core, Musician musician, ReleaseType releaseType, string title, long coverId)
{
if (core == null)
{
throw new NullCoreException();
}
string slug = title;
Navigation.GenerateSlug(title, ref slug);
slug = Functions.TrimStringToWord(slug);
// TODO: fix this
Item item = Item.Create(core, typeof(Release), new FieldValuePair("musician_id", musician.Id),
new FieldValuePair("release_title", title),
new FieldValuePair("release_slug", slug),
new FieldValuePair("release_type", (byte)releaseType),
new FieldValuePair("release_date_ut", UnixTime.UnixTimeStamp()),
new FieldValuePair("release_cover_art", coverId));
return (Release)item;
}
public static MusicianMember Create(Core core, Musician musician, User member)
{
if (core == null)
{
throw new NullCoreException();
}
InsertQuery iQuery = new InsertQuery(typeof(MusicianMember));
iQuery.AddField("user_id", member.Id);
iQuery.AddField("musician_id", musician.Id);
iQuery.AddField("member_date_ut", UnixTime.UnixTimeStamp());
iQuery.AddField("member_lead", false);
iQuery.AddField("member_instruments", 0);
iQuery.AddField("member_stage_name", string.Empty);
iQuery.AddField("member_biography", string.Empty);
core.Db.Query(iQuery);
MusicianMember newMember = new MusicianMember(core, musician, member);
return newMember;
}
public MusicianMember(Core core, Musician musician, long userId)
: base(core)
{
this.db = db;
SelectQuery query = GetSelectQueryStub(core, UserLoadOptions.All);
query.AddCondition("user_keys.user_id", userId);
query.AddCondition("musician_members.musician_id", musician.Id);
DataTable memberTable = db.Query(query);
if (memberTable.Rows.Count == 1)
{
loadItemInfo(typeof(MusicianMember), memberTable.Rows[0]);
core.LoadUserProfile(userId);
loadUserFromUser(core.PrimitiveCache[userId]);
}
else
{
throw new InvalidUserException();
}
}
public MusicianMember(Core core, Musician owner, string username, UserLoadOptions loadOptions)
: base(core)
{
SelectQuery query = GetSelectQueryStub(core, UserLoadOptions.All);
query.AddCondition("user_keys.username", username);
query.AddCondition("musician_id", owner.Id);
DataTable memberTable = db.Query(query);
if (memberTable.Rows.Count == 1)
{
loadItemInfo(typeof(User), memberTable.Rows[0]);
loadItemInfo(typeof(UserInfo), memberTable.Rows[0]);
loadItemInfo(typeof(UserProfile), memberTable.Rows[0]);
loadItemInfo(typeof(MusicianMember), memberTable.Rows[0]);
}
else
{
throw new InvalidUserException();
}
}
public static string Uri(Core core, Musician.Musician musician)
{
return core.Hyperlink.AppendSid(string.Format("{0}comments",
musician.UriStub));
}
public static Musician Create(Core core, string title, string slug)
{
if (core == null)
{
throw new NullCoreException();
}
Mysql db = core.Db;
SessionState session = core.Session;
if (core.Session.LoggedInMember == null)
{
return null;
}
if (!CheckMusicianNameUnique(core, slug))
{
return null;
}
db.BeginTransaction();
InsertQuery iQuery = new InsertQuery(Musician.GetTable(typeof(Musician)));
iQuery.AddField("musician_name", title);
iQuery.AddField("musician_slug", slug);
iQuery.AddField("musician_name_first", title.ToLower()[0]);
iQuery.AddField("musician_reg_ip", session.IPAddress.ToString());
iQuery.AddField("musician_reg_date_ut", UnixTime.UnixTimeStamp());
long musicianId = db.Query(iQuery);
Musician newMusician = new Musician(core, musicianId);
MusicianMember member = MusicianMember.Create(core, newMusician, session.LoggedInMember);
try
{
ApplicationEntry musicianAe = new ApplicationEntry(core, "Musician");
musicianAe.Install(core, newMusician);
}
catch
{
}
try
{
ApplicationEntry galleryAe = new ApplicationEntry(core, "Gallery");
galleryAe.Install(core, newMusician);
}
catch
{
}
try
{
ApplicationEntry guestbookAe = new ApplicationEntry(core, "GuestBook");
guestbookAe.Install(core, newMusician);
}
catch
{
}
Access.CreateGrantForPrimitive(core, newMusician, User.GetEveryoneGroupKey(core), "VIEW");
Access.CreateGrantForPrimitive(core, newMusician, User.GetRegisteredUsersGroupKey(core), "COMMENT");
Access.CreateGrantForPrimitive(core, newMusician, User.GetRegisteredUsersGroupKey(core), "COMMENT_GIGS");
return newMusician;
}
public static List<Gig> GetAll(Core core, Musician owner)
{
List<Gig> gigs = new List<Gig>();
SelectQuery query = Gig.GetSelectQueryStub(core, typeof(Gig));
query.AddCondition("musician_id", owner.Id);
DataTable gigTable = core.Db.Query(query);
foreach (DataRow dr in gigTable.Rows)
{
gigs.Add(new Gig(core, dr));
}
return gigs;
}
public Gig(Core core, Musician musician, long gigId)
: base(core)
{
this.musician = musician;
ItemLoad += new ItemLoadHandler(Gig_ItemLoad);
try
{
LoadItem(gigId, new FieldValuePair("musician_id", musician.Id));
}
catch (InvalidItemException)
{
throw new InvalidGigException();
}
}
public static Song Create(Core core, Musician owner, string title, string lyrics, byte licenseId)
{
if (core == null)
{
throw new NullCoreException();
}
if (owner.IsMusicianMember(core.Session.LoggedInMember.ItemKey))
{
Item item = Item.Create(core, typeof(Song), new FieldValuePair("musician_id", owner.Id),
new FieldValuePair("song_title", title),
new FieldValuePair("song_lyrics", lyrics),
new FieldValuePair("song_license", licenseId));
return (Song)item;
}
else
{
throw new UnauthorisedToCreateItemException();
}
}