public IActionResult CurrentPlanDetails(long userid)
{
DatabaseRepository dbr = new DatabaseRepository(_logger, _env);
Domain.Socioboard.Models.PaymentTransaction details = new PaymentTransaction();
User lsturl = dbr.Single <User>(t => t.Id == userid);
Domain.Socioboard.Enum.SBAccountType type = lsturl.AccountType;
if (type == 0)
{
details.amount = "0";
}
else
{
try
{
IList <PaymentTransaction> lstpayment = dbr.Find <PaymentTransaction>(t => t.userid == userid);
foreach (Domain.Socioboard.Models.PaymentTransaction payment in lstpayment)
{
if (payment.paymentdate.Date.Month == DateTime.UtcNow.Date.Month)
{
details.id = payment.id;
details.itemname = payment.itemname;
details.media = payment.media;
details.payeremail = payment.payeremail;
details.Payername = payment.Payername;
details.paymentdate = payment.paymentdate;
details.paymentId = payment.paymentId;
details.paymentstatus = payment.paymentstatus;
details.PaymentType = payment.PaymentType;
details.subscrdate = payment.subscrdate;
details.trasactionId = payment.trasactionId;
details.userid = payment.userid;
details.amount = payment.amount;
details.email = payment.email;
}
}
}
catch (Exception ex)
{
}
}
return(Ok(details));
}
public IActionResult GoogleLogin(string code, Domain.Socioboard.Enum.SBAccountType accType)
{
string ret = string.Empty;
string objRefresh = string.Empty;
string refreshToken = string.Empty;
string access_token = string.Empty;
oAuthTokenGPlus ObjoAuthTokenGPlus = new oAuthTokenGPlus(_appSettings.GoogleConsumerKey, _appSettings.GoogleConsumerSecret, _appSettings.GoogleRedirectUri);
oAuthToken objToken = new oAuthToken(_appSettings.GoogleConsumerKey, _appSettings.GoogleConsumerSecret, _appSettings.GoogleRedirectUri);
JObject userinfo = new JObject();
try
{
objRefresh = ObjoAuthTokenGPlus.GetRefreshToken(code);
JObject objaccesstoken = JObject.Parse(objRefresh);
_logger.LogInformation(objaccesstoken.ToString());
try
{
refreshToken = objaccesstoken["refresh_token"].ToString();
}
catch { }
access_token = objaccesstoken["access_token"].ToString();
string user = objToken.GetUserInfo("self", access_token.ToString());
_logger.LogInformation(user);
userinfo = JObject.Parse(JArray.Parse(user)[0].ToString());
}
catch (Exception ex)
{
//access_token = objaccesstoken["access_token"].ToString();
//ObjoAuthTokenGPlus.RevokeToken(access_token);
_logger.LogInformation(ex.Message);
_logger.LogError(ex.StackTrace);
ret = "Access Token Not Found";
return(Ok(ret));
}
string EmailId = string.Empty;
try
{
EmailId = (Convert.ToString(userinfo["email"]));
}
catch { }
if (string.IsNullOrEmpty(EmailId))
{
return(Ok("Google Not retuning Email"));
}
try
{
User inMemUser = _redisCache.Get <User>(EmailId);
if (inMemUser != null)
{
return(Ok(inMemUser));
}
}
catch (Exception ex)
{
_logger.LogInformation(ex.Message);
_logger.LogError(ex.StackTrace);
}
DatabaseRepository dbr = new DatabaseRepository(_logger, _appEnv);
IList <User> lstUser = dbr.Find <User>(t => t.EmailId.Equals(EmailId));
if (lstUser != null && lstUser.Count() > 0)
{
DateTime d1 = DateTime.UtcNow;
//User userTable = dbr.Single<User>(t => t.EmailId == EmailId);
//userTable.LastLoginTime = d1;
lstUser.First().LastLoginTime = d1;
dbr.Update <User>(lstUser.First());
_redisCache.Set <User>(lstUser.First().EmailId, lstUser.First());
return(Ok(lstUser.First()));
}
else
{
Domain.Socioboard.Models.Googleplusaccounts gplusAcc = Api.Socioboard.Repositories.GplusRepository.getGPlusAccount(Convert.ToString(userinfo["id"]), _redisCache, dbr);
if (gplusAcc != null && gplusAcc.IsActive == true)
{
return(Ok("GPlus account added by other user."));
}
Domain.Socioboard.Models.User user = new Domain.Socioboard.Models.User();
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;
}
user.PaymentType = Domain.Socioboard.Enum.PaymentType.paypal;
user.ActivationStatus = Domain.Socioboard.Enum.SBUserActivationStatus.Active;
user.CreateDate = DateTime.UtcNow;
user.EmailId = EmailId;
user.ExpiryDate = DateTime.UtcNow.AddDays(1);
user.UserName = "******";
user.EmailValidateToken = "Google";
user.UserType = "User";
user.PaymentStatus = Domain.Socioboard.Enum.SBPaymentStatus.UnPaid;
try
{
user.FirstName = (Convert.ToString(userinfo["name"]));
}
catch { }
user.RegistrationType = Domain.Socioboard.Enum.SBRegistrationType.Google;
int SavedStatus = dbr.Add <Domain.Socioboard.Models.User>(user);
User nuser = dbr.Single <User>(t => t.EmailId.Equals(user.EmailId));
if (SavedStatus == 1 && nuser != null)
{
Groups group = new Groups();
group.adminId = nuser.Id;
group.createdDate = DateTime.UtcNow;
group.groupName = Domain.Socioboard.Consatants.SocioboardConsts.DefaultGroupName;
SavedStatus = dbr.Add <Groups>(group);
if (SavedStatus == 1)
{
Groups ngrp = dbr.Find <Domain.Socioboard.Models.Groups>(t => t.adminId == nuser.Id && t.groupName.Equals(Domain.Socioboard.Consatants.SocioboardConsts.DefaultGroupName)).FirstOrDefault();
GroupMembersRepository.createGroupMember(ngrp.id, nuser, _redisCache, dbr);
// Adding GPlus Profile
Api.Socioboard.Repositories.GplusRepository.AddGplusAccount(userinfo, dbr, nuser.Id, ngrp.id, access_token, refreshToken, _redisCache, _appSettings, _logger);
}
}
return(Ok(nuser));
}
}
public IActionResult FacebookLogin(string AccessToken, Domain.Socioboard.Enum.SBAccountType accType)
{
dynamic profile = FbUser.getFbUser(AccessToken);
if (Convert.ToString(profile) == "Invalid Access Token")
{
return(Ok("Invalid Access Token"));
}
try
{
string EmailId = string.Empty;
try
{
EmailId = (Convert.ToString(profile["email"]));
}
catch { }
if (string.IsNullOrEmpty(EmailId))
{
return(Ok("Facebook Not retuning Email"));
}
try
{
User inMemUser = _redisCache.Get <User>(EmailId);
if (inMemUser != null)
{
return(Ok(inMemUser));
}
}
catch (Exception ex)
{
_logger.LogInformation(ex.Message);
_logger.LogError(ex.StackTrace);
}
DatabaseRepository dbr = new DatabaseRepository(_logger, _appEnv);
IList <User> lstUser = dbr.Find <User>(t => t.EmailId.Equals(EmailId));
if (lstUser != null && lstUser.Count() > 0)
{
DateTime d1 = DateTime.UtcNow;
//User userTable = dbr.Single<User>(t => t.EmailId == EmailId);
//userTable.LastLoginTime = d1;
lstUser.First().LastLoginTime = d1;
dbr.Update <User>(lstUser.First());
_redisCache.Set <User>(lstUser.First().EmailId, lstUser.First());
return(Ok(lstUser.First()));
}
else
{
Domain.Socioboard.Models.Facebookaccounts fbacc = Api.Socioboard.Repositories.FacebookRepository.getFacebookAccount(Convert.ToString(profile["id"]), _redisCache, dbr);
if (fbacc != null && fbacc.IsActive == true)
{
return(Ok("Facebook account added by other user."));
}
Domain.Socioboard.Models.User user = new Domain.Socioboard.Models.User();
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;
}
user.ActivationStatus = Domain.Socioboard.Enum.SBUserActivationStatus.Active;
user.CreateDate = DateTime.UtcNow;
user.EmailId = EmailId;
user.ExpiryDate = DateTime.UtcNow.AddDays(1);
user.PaymentType = Domain.Socioboard.Enum.PaymentType.paypal;
user.UserName = "******";
user.EmailValidateToken = "Facebook";
try
{
user.ProfilePicUrl = "https://graph.facebook.com/" + Convert.ToString(profile["id"]) + "/picture?type=small";
}
catch { }
user.PaymentStatus = Domain.Socioboard.Enum.SBPaymentStatus.UnPaid;
try
{
user.FirstName = (Convert.ToString(profile["name"]));
}
catch { }
user.RegistrationType = Domain.Socioboard.Enum.SBRegistrationType.Faceboook;
int SavedStatus = dbr.Add <Domain.Socioboard.Models.User>(user);
User nuser = dbr.Single <User>(t => t.EmailId.Equals(user.EmailId));
if (SavedStatus == 1 && nuser != null)
{
Groups group = new Groups();
group.adminId = nuser.Id;
group.createdDate = DateTime.UtcNow;
group.groupName = Domain.Socioboard.Consatants.SocioboardConsts.DefaultGroupName;
SavedStatus = dbr.Add <Groups>(group);
if (SavedStatus == 1)
{
Groups ngrp = dbr.Find <Domain.Socioboard.Models.Groups>(t => t.adminId == nuser.Id && t.groupName.Equals(Domain.Socioboard.Consatants.SocioboardConsts.DefaultGroupName)).FirstOrDefault();
GroupMembersRepository.createGroupMember(ngrp.id, nuser, _redisCache, dbr);
// Adding Facebook Profile
Api.Socioboard.Repositories.FacebookRepository.AddFacebookAccount(profile, FbUser.getFbFriends(AccessToken), dbr, nuser.Id, ngrp.id, Domain.Socioboard.Enum.FbProfileType.FacebookProfile, AccessToken, _redisCache, _appSettings, _logger);
}
}
return(Ok(nuser));
}
}
catch
{
return(Ok("Invalid Access Token"));
}
}
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());
}
