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));
}
