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); } }
public int PurchaseSoloFor(string userEmail) { PurchaseRecordQueriesCommands PrCQ = new PurchaseRecordQueriesCommands(); AuthQueriesCommands AuthCQ = new AuthQueriesCommands(); var account = AuthCQ.GetAccountByEmail(userEmail); if (account != null) { logic = new GeneralLogics(); var purchaseId = logic.CreateUniqueId(); PurchaseRecord pr = new PurchaseRecord(); pr.Id = purchaseId; pr.Purchased_Category = "solo"; pr.Account_Id = account.Id; pr.PurchaseDate = logic.CurrentIndianTime(); var result = PrCQ.AddPurchaseRecord(pr); if (result == 1) { return(1); } else { return(0); } } else { //Account not found return(2); } }
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 List <ExtendedPlay> GetAllTheEpsOf(string email) { AuthQueriesCommands AuthCQ = new AuthQueriesCommands(); EPQueriesCommands epCQ = new EPQueriesCommands(); return(epCQ.GetAllEpsOf(AuthCQ.GetAccountByEmail(email))); }
public int DeleteAccount(string email) { AuthQueriesCommands authCQ = new AuthQueriesCommands(); var result = authCQ.GetAccountByEmail(email); if (result != null) { var newResult = authCQ.DeleteAccount(result); if (newResult == 1) { //Account active status has been changed successfully return(1); } else { //Exception has been thrown return(2); } } else { //No account found with the email provided return(0); } }
public bool IsBankDetailsExistsOf(string userEmail) { BankQueriesCommands BankCQ = new BankQueriesCommands(); AuthQueriesCommands AuthCQ = new AuthQueriesCommands(); return(BankCQ.IsBankDetailsExistsOf(AuthCQ.GetAccountByEmail(userEmail))); }
public int EditBankDetails(string userEmail, string payee_first_name, string payee_last_name, string payee_bank_name, string payee_bank_account, string payee_bank_ifsc, string payee_bank_branch) { //Code to change the bank details submitted by user BankQueriesCommands BankCQ = new BankQueriesCommands(); AuthQueriesCommands AuthCQ = new AuthQueriesCommands(); var account = AuthCQ.GetAccountByEmail(userEmail); if (account != null) { if (IsBankDetailsExistsOf(userEmail)) { var bankDetails = BankCQ.GetBankDetailOf(account); if (bankDetails != null) { bankDetails.Account_Id = account.Id; bankDetails.PayeeBankAccountNumber = payee_bank_account; bankDetails.PayeeBankName = payee_bank_name; bankDetails.PayeeBankIfscNumber = payee_bank_ifsc; bankDetails.PayeeBankBranch = payee_bank_branch; bankDetails.PayeeFirstName = payee_first_name; bankDetails.PayeeLastName = payee_last_name; bankDetails.Detail_Submitted_At = logic.CurrentIndianTime(); var result = BankCQ.EditBankDetails(bankDetails); if (result == 1) { //Changes done successfully return(1); } else { //Internal error occured while changing bank detais return(4); } } else { //No bank details is associated with the account return(3); } } else { //No bank details found for this account return(2); } } else { //No account found with this email id return(0); } }
public Guid?GetFirstPurchaseIdForSoloOf(string email) { AuthQueriesCommands AuthCQ = new AuthQueriesCommands(); var accountObject = AuthCQ.GetAccountByEmail(email); if (accountObject != null) { PurchaseRecordQueriesCommands prCQ = new PurchaseRecordQueriesCommands(); return(prCQ.GetUnUsedSoloPurchaseRecordOf(accountObject).First().Id); } else { return(null); } }
public bool IsAccountContainsThisPurchase(string email, Guid?purchaseId) { AuthQueriesCommands AuthCQ = new AuthQueriesCommands(); var accountObject = AuthCQ.GetAccountByEmail(email); if (accountObject != null) { PurchaseRecordQueriesCommands prCQ = new PurchaseRecordQueriesCommands(); return(prCQ.GetAllPurchaseRecordsOf(accountObject).Any(rec => rec.Id == purchaseId)); } else { //No account found with this email return(false); } }
public BankDetail GetBankDetailOf(string userEmail) { BankQueriesCommands BankCQ = new BankQueriesCommands(); AuthQueriesCommands AuthCQ = new AuthQueriesCommands(); var accountObject = AuthCQ.GetAccountByEmail(userEmail); if (accountObject != null) { //Account found now returning the bank details return(BankCQ.GetBankDetailOf(accountObject)); } else { //No Account found with this email return(null); } }
public int CountOfSolosCanBeCreatedBy(string userEmail) { PurchaseRecordQueriesCommands purchaseCQ = new PurchaseRecordQueriesCommands(); AuthQueriesCommands AuthCQ = new AuthQueriesCommands(); Account account = AuthCQ.GetAccountByEmail(userEmail); if (account != null) { var GetListOfUnUsedPurchase = purchaseCQ.GetUnUsedSoloPurchaseRecordOf(account); //Returning the count of the unused purchase of Eps for the user return(GetListOfUnUsedPurchase.Count); } else { //No Account Found return(0); } }
public int CountOfAlbumsAlreadyCreatedBy(string email) { PurchaseRecordQueriesCommands purchaseCQ = new PurchaseRecordQueriesCommands(); AuthQueriesCommands AuthCQ = new AuthQueriesCommands(); Account account = AuthCQ.GetAccountByEmail(email); if (account != null) { var GetListOfUnUsedPurchase = purchaseCQ.GetUsedAlbumPurchaseRecordOf(account); //Returning the count of the unused purchase of albums for the user return(GetListOfUnUsedPurchase.Count); } else { //No Account Found return(0); } }
public Account FindAccountByEmail(string email) { AuthQueriesCommands auth = new AuthQueriesCommands(); return(auth.GetAccountByEmail(email)); }