public static int AddPaymentTransaction(long userId, string amount, string email, Domain.Socioboard.Enum.PaymentType PaymentType, string paymentId, string trasactionId, Model.DatabaseRepository dbr)
{
try
{
Domain.Socioboard.Models.PaymentTransaction _PaymentTransaction = new Domain.Socioboard.Models.PaymentTransaction();
_PaymentTransaction.amount = amount;
_PaymentTransaction.email = email;
_PaymentTransaction.paymentdate = DateTime.UtcNow;
_PaymentTransaction.userid = userId;
_PaymentTransaction.PaymentType = PaymentType;
_PaymentTransaction.trasactionId = trasactionId;
_PaymentTransaction.paymentId = paymentId;
int isaved = dbr.Add <Domain.Socioboard.Models.PaymentTransaction>(_PaymentTransaction);
return(isaved);
}
catch (Exception)
{
return(0);
}
}
/// <summary>
///
/// </summary>
/// <param name="userId"></param>
/// <param name="amount"></param>
/// <param name="email"></param>
/// <param name="PaymentType"></param>
/// <param name="paymentId"></param>
/// <param name="trasactionId"></param>
/// <param name="subscr_date"></param>
/// <param name="payer_email"></param>
/// <param name="Payername"></param>
/// <param name="payment_status"></param>
/// <param name="item_name"></param>
/// <param name="media"></param>
/// <param name="dbr"></param>
/// <returns></returns>
public static int AddPaymentTransaction(long userId, string amount, string email, Domain.Socioboard.Enum.PaymentType PaymentType, string paymentId, string trasactionId, DateTime subscr_date, string payer_email, string Payername, string payment_status, string item_name, string media, Model.DatabaseRepository dbr)
{
try
{
var paymentTransaction = new Domain.Socioboard.Models.PaymentTransaction
{
amount = amount,
email = email,
paymentdate = DateTime.UtcNow,
userid = userId,
PaymentType = PaymentType,
trasactionId = trasactionId,
paymentId = paymentId,
payeremail = payer_email,
Payername = Payername,
paymentstatus = payment_status,
itemname = item_name,
media = media,
subscrdate = subscr_date
};
return(dbr.Add(paymentTransaction));
}
catch (Exception)
{
return(0);
}
}
public static int AddPaymentTransaction(long userId, string amount, string email, Domain.Socioboard.Enum.PaymentType PaymentType, string paymentId, string trasactionId, DateTime subscr_date, string payer_email, string Payername, string payment_status, string item_name, string media, Model.DatabaseRepository dbr)
{
try
{
Domain.Socioboard.Models.PaymentTransaction _PaymentTransaction = new Domain.Socioboard.Models.PaymentTransaction();
_PaymentTransaction.amount = amount;
_PaymentTransaction.email = email;
_PaymentTransaction.paymentdate = DateTime.UtcNow;
_PaymentTransaction.userid = userId;
_PaymentTransaction.PaymentType = PaymentType;
_PaymentTransaction.trasactionId = trasactionId;
_PaymentTransaction.paymentId = paymentId;
_PaymentTransaction.payeremail = payer_email;
_PaymentTransaction.Payername = Payername;
_PaymentTransaction.paymentstatus = payment_status;
_PaymentTransaction.itemname = item_name;
_PaymentTransaction.media = media;
_PaymentTransaction.subscrdate = subscr_date;
int isaved = dbr.Add <Domain.Socioboard.Models.PaymentTransaction>(_PaymentTransaction);
return(isaved);
}
catch (Exception)
{
return(0);
}
}
public IActionResult UpgradeAccount(string userId, string amount, string UserName, string email, Domain.Socioboard.Enum.PaymentType PaymentType, string trasactionId, string paymentId, Domain.Socioboard.Enum.SBAccountType accType)
{
Model.DatabaseRepository dbr = new Model.DatabaseRepository(_logger, _appEnv);
try
{
User inMemUser = _redisCache.Get <User>(UserName);
if (inMemUser != null)
{
inMemUser.PaymentStatus = Domain.Socioboard.Enum.SBPaymentStatus.Paid;
inMemUser.PayPalAccountStatus = Domain.Socioboard.Enum.PayPalAccountStatus.added;
inMemUser.ExpiryDate = DateTime.UtcNow.AddDays(30);
inMemUser.Id = Convert.ToInt64(userId);
inMemUser.TrailStatus = Domain.Socioboard.Enum.UserTrailStatus.active;
if (accType == Domain.Socioboard.Enum.SBAccountType.Free)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Free;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Deluxe)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Deluxe;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Premium)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Premium;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Topaz)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Topaz;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Platinum)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Platinum;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Gold)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Gold;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Ruby)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Ruby;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Standard)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Standard;
}
dbr.Update <User>(inMemUser);
}
else
{
User _user = dbr.Single <User>(t => t.Id == Convert.ToInt64(userId));
if (_user != null)
{
_user.PaymentStatus = Domain.Socioboard.Enum.SBPaymentStatus.Paid;
_user.PayPalAccountStatus = Domain.Socioboard.Enum.PayPalAccountStatus.added;
_user.ExpiryDate = DateTime.UtcNow.AddDays(30);
_user.Id = Convert.ToInt64(userId);
_user.TrailStatus = Domain.Socioboard.Enum.UserTrailStatus.active;
if (accType == Domain.Socioboard.Enum.SBAccountType.Free)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Free;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Deluxe)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Deluxe;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Premium)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Premium;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Topaz)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Topaz;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Platinum)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Platinum;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Gold)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Gold;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Ruby)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Ruby;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Standard)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Standard;
}
dbr.Update <User>(_user);
}
}
int isaved = Repositories.PaymentTransactionRepository.AddPaymentTransaction(Convert.ToInt64(userId), amount, email, PaymentType, paymentId, trasactionId, dbr);
if (isaved == 1)
{
return(Ok("payment done"));
}
}
catch (Exception ex)
{
_logger.LogInformation(ex.Message);
_logger.LogError(ex.StackTrace);
}
return(Ok());
}
public IActionResult UpgradeAccount(string userId, string amount, string UserName, string email, Domain.Socioboard.Enum.PaymentType PaymentType, string trasactionId, string paymentId, Domain.Socioboard.Enum.SBAccountType accType, DateTime subscr_date, string payer_email, string Payername, string payment_status, string item_name, string media)
{
Model.DatabaseRepository dbr = new Model.DatabaseRepository(_logger, _appEnv);
try
{
string path = _appEnv.WebRootPath + "\\views\\mailtemplates\\invoice.html";
string html = System.IO.File.ReadAllText(path);
html = html.Replace("[paymentId]", paymentId);
html = html.Replace("[subscr_date]", subscr_date.ToString());
html = html.Replace("[payer_email]", payer_email);
html = html.Replace("[Payername]", Payername);
html = html.Replace("[payment_status]", payment_status);
html = html.Replace("[item_name]", item_name);
html = html.Replace("[amount]", amount + "$");
html = html.Replace("[media]", media);
_emailSender.SendMailSendGrid(_appSettings.frommail, "", payer_email, "", "", "Socioboard Payment Invoice", html, _appSettings.SendgridUserName, _appSettings.SendGridPassword);
}
catch (Exception)
{
}
try
{
User inMemUser = _redisCache.Get <User>(UserName);
if (inMemUser != null)
{
inMemUser.PaymentStatus = Domain.Socioboard.Enum.SBPaymentStatus.Paid;
inMemUser.PayPalAccountStatus = Domain.Socioboard.Enum.PayPalAccountStatus.added;
inMemUser.ExpiryDate = DateTime.UtcNow.AddDays(30);
inMemUser.Id = Convert.ToInt64(userId);
inMemUser.TrailStatus = Domain.Socioboard.Enum.UserTrailStatus.active;
if (accType == Domain.Socioboard.Enum.SBAccountType.Free)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Free;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Deluxe)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Deluxe;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Premium)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Premium;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Topaz)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Topaz;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Platinum)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Platinum;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Gold)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Gold;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Ruby)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Ruby;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Standard)
{
inMemUser.AccountType = Domain.Socioboard.Enum.SBAccountType.Standard;
}
dbr.Update <User>(inMemUser);
}
else
{
User _user = dbr.Single <User>(t => t.Id == Convert.ToInt64(userId));
if (_user != null)
{
_user.PaymentStatus = Domain.Socioboard.Enum.SBPaymentStatus.Paid;
_user.PayPalAccountStatus = Domain.Socioboard.Enum.PayPalAccountStatus.added;
_user.ExpiryDate = DateTime.UtcNow.AddDays(30);
_user.Id = Convert.ToInt64(userId);
_user.TrailStatus = Domain.Socioboard.Enum.UserTrailStatus.active;
if (accType == Domain.Socioboard.Enum.SBAccountType.Free)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Free;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Deluxe)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Deluxe;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Premium)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Premium;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Topaz)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Topaz;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Platinum)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Platinum;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Gold)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Gold;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Ruby)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Ruby;
}
else if (accType == Domain.Socioboard.Enum.SBAccountType.Standard)
{
_user.AccountType = Domain.Socioboard.Enum.SBAccountType.Standard;
}
dbr.Update <User>(_user);
}
}
int isaved = Repositories.PaymentTransactionRepository.AddPaymentTransaction(Convert.ToInt64(userId), amount, email, PaymentType, paymentId, trasactionId, subscr_date, payer_email, Payername, payment_status, item_name, media, dbr);
if (isaved == 1)
{
return(Ok("payment done"));
}
}
catch (Exception ex)
{
_logger.LogInformation(ex.Message);
_logger.LogError(ex.StackTrace);
}
return(Ok());
}
