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); } }
public int CountOfEpsCanBeCreatedBy(string email) { PurchaseRecordQueriesCommands purchaseCQ = new PurchaseRecordQueriesCommands(); AuthQueriesCommands AuthCQ = new AuthQueriesCommands(); Account account = AuthCQ.GetAccountByEmail(email); if (account != null) { var GetListOfUnUsedPurchase = purchaseCQ.GetUnUsedEpPurchaseRecordOf(account); //Returning the count of the unused purchase of Eps for the user return(GetListOfUnUsedPurchase.Count); } else { //No Account Found return(0); } }