Exemplo n.º 1
0
        public bool IsAccountContainsThisEp(string email, Guid epId)
        {
            EPQueriesCommands   EpCQ   = new EPQueriesCommands();
            AuthQueriesCommands AuthCQ = new AuthQueriesCommands();

            var account = AuthCQ.GetAccountByEmail(email.ToLower());

            if (account == null)
            {
                return(false);
            }

            var Eps = EpCQ.GetAllEpsOf(account);

            if (Eps != null)
            {
                if (Eps.Any(rec => rec.Id == epId))
                {
                    return(true);
                }
                else
                {
                    return(false);
                }
            }
            else
            {
                return(false);
            }
        }
Exemplo n.º 2
0
        public List <ExtendedPlay> GetAllTheEpsOf(string email)
        {
            AuthQueriesCommands AuthCQ = new AuthQueriesCommands();
            EPQueriesCommands   epCQ   = new EPQueriesCommands();

            return(epCQ.GetAllEpsOf(AuthCQ.GetAccountByEmail(email)));
        }
Exemplo n.º 3
0
        public int EditEp(Guid epId, string epName, int totalTrack)
        {
            EPQueriesCommands EpCQ = new EPQueriesCommands();

            ExtendedPlay ep = EpCQ.GetEpById(epId);

            if (ep != null)
            {
                if (EpCQ.EPEmptiness(ep) != 1)
                {
                    //Can't edit Ep as one song alredy registered under the album
                    return(2);
                }
                ep.Ep_Name     = epName;
                ep.Total_Track = totalTrack;

                var result = EpCQ.EditEpDetails(ep);

                if (result != 1)
                {
                    //Internal Error occured while changing data for the Ep
                    return(3);
                }
                else
                {
                    //Ep details changed Successfully
                    return(1);
                }
            }
            else
            {
                //No Ep found with the Id provided
                return(0);
            }
        }
Exemplo n.º 4
0
        public int CreateNewEp(string email, string epName, int totalTrack)
        {
            logic = new GeneralLogics();
            PurchaseRecordQueriesCommands purchaseCQ = new PurchaseRecordQueriesCommands();
            EPQueriesCommands             EpCQ       = new EPQueriesCommands();
            AuthQueriesCommands           AuthCQ     = new AuthQueriesCommands();

            Account account = AuthCQ.GetAccountByEmail(email);

            if (account != null)
            {
                var GetListOfUnUsedPurchase = purchaseCQ.GetUnUsedEpPurchaseRecordOf(account);
                if (GetListOfUnUsedPurchase.Count > 0)
                {
                    ExtendedPlay ep = new ExtendedPlay();

                    ep.Id                  = logic.CreateUniqueId();
                    ep.Ep_Name             = epName;
                    ep.Total_Track         = totalTrack;
                    ep.Ep_Creation_Date    = logic.CurrentIndianTime();
                    ep.Submitted_Track     = 0;
                    ep.PurchaseTrack_RefNo = GetListOfUnUsedPurchase.First().Id;

                    var resultCreateEp = EpCQ.CreateEP(ep);
                    if (resultCreateEp == 1)
                    {
                        var purchaseRecord = purchaseCQ.GetPurchaseRecordById(ep.PurchaseTrack_RefNo);

                        purchaseRecord.Usage_Date = logic.CurrentIndianTime();
                        int resultPurchaseRecordUpdate = purchaseCQ.UpdatePurchaseRecord(purchaseRecord);

                        if (resultPurchaseRecordUpdate == 1)
                        {
                            //Ep created, PurchaseRecord is modified with UsageDate. Operation Completed successfully
                            return(1);
                        }
                        else
                        {
                            //Internal error occured while updating the record in PurchaseRecord table.Operation failed
                            return(4);
                        }
                    }
                    else
                    {
                        //Ep creation failed
                        return(3);
                    }
                }
                else
                {
                    //No purchase left to create an music Ep.
                    return(2);
                }
            }
            else
            {
                //No Account Found
                return(0);
            }
        }
Exemplo n.º 5
0
        public List <EpTrackMaster> GetAllTracksWithEpDetails(Guid epId)
        {
            EPQueriesCommands EpCQ = new EPQueriesCommands();

            var result = EpCQ.GetAllTracksWithEpDetails(epId);

            //Result could be null or a list consists of Tracks with store submission report and all.
            return(result);
        }
Exemplo n.º 6
0
        public List <SingleTrackDetail> GetTrackDetailsOfEp(Guid epId)
        {
            EPQueriesCommands epCQ = new EPQueriesCommands();

            var result = epCQ.GetAllTracksOfEp(epId);

            //Result could be null or a list consists of Tracks
            return(result);
        }
Exemplo n.º 7
0
        public int UpdateStoreSubmissionStatusForEpTrack(Guid epId, Guid trackId, int statusCode)
        {
            EPQueriesCommands epCQ = new EPQueriesCommands();

            if (epCQ.UpdateStoreSubmissionStatus(epId, trackId, statusCode) == 1)
            {
                return(1);
            }
            else
            {
                return(0);
            }
        }
Exemplo n.º 8
0
        public bool IsEpFull(Guid epId)
        {
            EPQueriesCommands EpCQ = new EPQueriesCommands();

            if (EpCQ.EPEmptiness(EpCQ.GetEpById(epId)) == 3)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemplo n.º 9
0
        public int DeleteEp(Guid epId)
        {
            EPQueriesCommands EpCQ = new EPQueriesCommands();
            var epObject           = EpCQ.GetEpById(epId);

            if (epObject != null)
            {
                var trackListOftheEp = EpCQ.GetAllTracksOfEp(epId);
                if (trackListOftheEp.Count == 0)
                {
                    var resultOfDeletingEp = EpCQ.DeleteEp(epObject);
                    if (resultOfDeletingEp == 1)
                    {
                        return(1);
                    }
                    else
                    {
                        return(5);
                    }
                }
                else if (trackListOftheEp.Count > 0)
                {
                    var resultOfRemovingSolos = EpCQ.RemoveSingleTracksFromEp(trackListOftheEp);
                    if (resultOfRemovingSolos == 1)
                    {
                        var resultOfDeletingAlbum = EpCQ.DeleteEp(epObject);
                        if (resultOfDeletingAlbum == 1)
                        {
                            return(1);
                        }
                        else
                        {
                            return(4);
                        }
                    }
                    else
                    {
                        return(3);
                    }
                }
                else
                {
                    return(2);
                }
            }
            else
            {
                return(0);
            }
        }
Exemplo n.º 10
0
        public bool IsEpExpired(Guid epId)
        {
            logic = new GeneralLogics();
            EPQueriesCommands EpCQ = new EPQueriesCommands();

            if (EpCQ.GetEpById(epId).PurchaseRecord.Usage_Exp_Date < logic.CurrentIndianTime())
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Exemplo n.º 11
0
        public int CreateNewTrackForEp(Guid epId, string TrackTitle, string ArtistName, bool ArtistAlreadyInSpotify, string ArtistSpotifyUrl, DateTime ReleaseDate, string Genre, string CopyrightClaimerName, string AuthorName, string ComposerName, string ArrangerName, string ProducerName, bool AlreadyHaveAnISRC, string ISRC_Number, int PriceTier, bool ExplicitContent, bool IsTrackInstrumental, string LyricsLanguage, string TrackZipFileLink, string ArtWork_Link)
        {
            EPQueriesCommands             EpCQ       = new EPQueriesCommands();
            PurchaseRecordQueriesCommands PurchaseCQ = new PurchaseRecordQueriesCommands();

            logic = new GeneralLogics();

            var epObject = EpCQ.GetEpById(epId);

            if (epObject != null)
            {
                if (PurchaseCQ.GetPurchaseRecordById(epObject.PurchaseTrack_RefNo).Usage_Exp_Date < logic.CurrentIndianTime())
                {
                    //Can't add more track in the album as purchase expired
                    return(7);
                }

                if (epObject.Total_Track <= epObject.Submitted_Track)
                {
                    //can't add more track in the album as the album is full
                    return(8);
                }

                byte ArtistSpotifyAppearance   = 1;
                byte PresenceOfISRCnumber      = 1;
                byte PresenceOfExplicitContent = 1;
                byte InstrumentalTrackPresence = 1;

                if (ArtistAlreadyInSpotify == false)
                {
                    ArtistSpotifyAppearance = 0;
                }
                if (AlreadyHaveAnISRC == false)
                {
                    PresenceOfISRCnumber = 0;
                }
                if (IsTrackInstrumental == false)
                {
                    InstrumentalTrackPresence = 0;
                }
                if (ExplicitContent == false)
                {
                    PresenceOfExplicitContent = 0;
                }
                SingleTrackDetail std = new SingleTrackDetail();

                std.Id                     = logic.CreateUniqueId();
                std.TrackTitle             = TrackTitle;
                std.ArtistName             = ArtistName;
                std.ArtistAlreadyInSpotify = ArtistSpotifyAppearance;
                std.ArtistSpotifyUrl       = ArtistSpotifyUrl;
                std.ReleaseDate            = ReleaseDate;
                std.Genre                  = Genre;
                std.CopyrightClaimerName   = CopyrightClaimerName;
                std.AuthorName             = AuthorName;
                std.ComposerName           = ComposerName;
                std.ArrangerName           = ArrangerName;
                std.ProducerName           = ProducerName;
                std.AlreadyHaveAnISRC      = PresenceOfISRCnumber;
                std.ISRC_Number            = ISRC_Number;
                std.PriceTier              = PriceTier;
                std.ExplicitContent        = PresenceOfExplicitContent;
                std.IsTrackInstrumental    = InstrumentalTrackPresence;
                std.LyricsLanguage         = LyricsLanguage;
                std.TrackZipFileLink       = TrackZipFileLink;
                std.ArtworkFileLink        = ArtWork_Link.Trim();

                TrackQueriesCommands TrackCQ = new TrackQueriesCommands();
                //add single track
                var singleTrackSaveResult = TrackCQ.AddTrack(std);

                if (singleTrackSaveResult == 1)
                {
                    //Link track with the album. Work on albumtrackMaster table
                    EpTrackMaster etm = new EpTrackMaster();

                    etm.Id           = logic.CreateUniqueId();
                    etm.Ep_Id        = epId;
                    etm.Track_Id     = std.Id;
                    etm.Submitted_At = logic.CurrentIndianTime();
                    //Status = pending
                    etm.StoreSubmissionStatus = 2;

                    var etmSaveResult = TrackCQ.AddtoEpTrackMaster(etm);

                    if (etmSaveResult == 1)
                    {
                        //increment the number of the submitted track for the album
                        epObject.Submitted_Track = epObject.Submitted_Track + 1;

                        var epEditResult = EpCQ.EditEpDetails(epObject);

                        if (epEditResult == 1)
                        {
                            //if it's the first track of the album then set purchase record usage expire time
                            epObject = EpCQ.GetEpById(epId);
                            if (epObject != null)
                            {
                                if (epObject.Submitted_Track == 1)
                                {
                                    PurchaseRecord pr = PurchaseCQ.GetPurchaseRecordById(epObject.PurchaseTrack_RefNo);
                                    if (pr != null)
                                    {
                                        pr.Usage_Exp_Date = logic.CurrentIndianTime().AddHours(24);
                                        var purchaseEditResult = PurchaseCQ.UpdatePurchaseRecord(pr);
                                        if (purchaseEditResult == 1)
                                        {
                                            //purchase expire date set
                                            return(1);
                                        }
                                        else
                                        {
                                            //Error while setting the expire date
                                            return(11);
                                        }
                                    }
                                    else
                                    {
                                        //error while fetching the purchase record of the album
                                        return(10);
                                    }
                                }
                                return(1);
                            }
                            else
                            {
                                //error while fetching the album
                                return(9);
                            }
                        }
                        else
                        {
                            //Error occured while updating album record
                            return(6);
                        }
                    }
                    else
                    {
                        //Error occured while adding albumTrackMaster record
                        return(5);
                    }
                }
                else
                {
                    //Error occured while saving single track to the database
                    return(4);
                }
            }
            else
            {
                //No album found with the provided Album Id
                return(0);
            }
        }
Exemplo n.º 12
0
        public List <EpTrackMaster> GetAllEpsWithTracks()
        {
            EPQueriesCommands epCQ = new EPQueriesCommands();

            return(epCQ.GetAllEpsWithTrackDetail());
        }
Exemplo n.º 13
0
        public ExtendedPlay GetEpById(Guid epId)
        {
            EPQueriesCommands epCQ = new EPQueriesCommands();

            return(epCQ.GetEpById(epId));
        }