protected void Page_Load(object sender, EventArgs e)
{
if (Session != null)
{
// Store essential session information temporarily
string culture = Session["culture"] as string ?? "nl-NL";
Session["culture"] = null;
// Restore the essential session information
Session["culture"] = culture;
}
if (!Request.IsAuthenticated)
{
if (Request.Params["pid"] != null || Request.Params["tid"] != null)
{
Response.Redirect(string.Format("~/Account/Login.aspx?tid={0}&pid={1}",
Request.Params["tid"],
Request.Params["pid"]), false);
}
else
{
Response.Redirect("~/Default.aspx", false);
}
}
ShowLoggedOnView();
Literal name = HeadLoginView.FindControl("HeadLoginName") as Literal;
if (name != null)
{
if (Session["userid"] != null)
{
long userId = Util.UserId;
using (Database db = new MySqlDatabase())
{
ClientInfo ci = db.GetClientInfo(userId);
name.Text = string.Format(" {0}", ci.FirstName);// ci.GetFullName());
}
}
}
if (!IsPostBack)
{
BasePage obj = new BasePage();
obj.IncludePage(FooterLiteral, Resources.Resource.FooterSection);
}
}
protected void AuthenticateUser()
{
string userID = Request.QueryString["userId"];
string key = Request.QueryString["key"].Replace(" ", "+");
string pwd = EncryptionClass.Decrypt(key);
string email = string.Empty;
using (Database db = new MySqlDatabase())
{
UserInfo ui = db.GetUser(Convert.ToInt64(userID));
email = ui.Email;
ClientInfo ci = db.GetClientInfo(Convert.ToInt64(userID));
Session["UserName"] = ci.GetFullName();
}
string username = Membership.GetUserNameByEmail(email);
FormsAuthentication.SetAuthCookie(username, false);
FormsAuthenticationTicket ticket1 =
new FormsAuthenticationTicket(
1, // version
username, // get username from the form
DateTime.Now, // issue time is now
DateTime.Now.AddMinutes(10), // expires in 10 minutes
false, // cookie is not persistent
"" // role assignment is stored
// in userData
);
HttpCookie cookie1 = new HttpCookie(
FormsAuthentication.FormsCookieName,
FormsAuthentication.Encrypt(ticket1));
Response.Cookies.Add(cookie1);
Membership.ValidateUser(username, pwd);
// 4. Do the redirect.
String returnUrl1;
// the login is successful
returnUrl1 = "FirstLogon.aspx";
Response.Redirect(returnUrl1);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!User.Identity.IsAuthenticated)
Response.Redirect("~/");
long userid = Util.UserId;
if (!IsPostBack)
{
Country.Items.Clear();
string[] countries = Util.GetCountries();
foreach (string country in countries)
Country.Items.Add(new ListItem(country));
Country.SelectedIndex = Country.Items.IndexOf(Country.Items.FindByText("Netherlands"));
if (userid > 0)
{
using (Database db = new MySqlDatabase())
{
ClientInfo ci = db.GetClientInfo(userid);
if (ci != null && ci.ClientId > 0)
{
LastName.Text = ci.LastName;
FirstName.Text = ci.FirstName;
AddressLine1.Text = ci.AddressLine1;
AddressLine2.Text = ci.AddressLine2;
Zipcode.Text = ci.ZipCode;
State.Text = ci.State;
City.Text = ci.City;
Country.SelectedIndex = Country.Items.IndexOf(Country.Items.FindByText(ci.Country));
Telephone.Text = ci.Telephone;
Cellular.Text = ci.Cellular;
AccountOwner.Text = ci.AccountOwner;
TwitterID.Text = ci.TwitterId;
FacebookID.Text = ci.FacebookId;
OwnerKind.SelectedIndex = OwnerKind.Items.IndexOf(OwnerKind.Items.FindByText(ci.OwnerKind));
CreditCardNr.Text = ci.CreditCardNr;
CVVNr.Text = ci.CreditCardCvv;
EmailForReceipt.Text = ci.EmailReceipt;
Referer.Text = ci.Referer;
}
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
IncludePage(ActivateInc, Resources.Resource.incActivate);
IncludePage(ProtectInc, Resources.Resource.incProtect);
IncludePage(RhosMovementInc, Resources.Resource.incRhosMovement);
if (!IsPostBack)
{
if (Request.Params["uid"] != null)
{
string uid = Request.Params["uid"];
using (Database db = new MySqlDatabase())
{
// Check the UID against the database
long userId = db.GetUserIdByUid(uid);
db.ActivateUser(userId);
}
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
//audioFilePath = Convert.ToString(Session["sound"]);
//lblSound.Text = "Sound : " + Convert.ToString(Session["soundName"]);
string MusicFile = string.Empty;
using (Database db = new MySqlDatabase())
{
MusicFile = db.GetMusicPathByRegID(Convert.ToInt32(Request.QueryString["play"]));
//MusicFile = db.GetMusicPathByRegID(Convert.ToInt32(Session["songId"]));
if (MusicFile.Contains("/trackprotect_repos/repository"))
{
QTPlayer1.MOVFile = ConfigurationManager.AppSettings["SiteNavigationLink"] + MusicFile.Substring(MusicFile.IndexOf("/trackprotect_repos/repository")).Replace("\\", "/");
}
else
{
QTPlayer1.MOVFile = ConfigurationManager.AppSettings["SiteNavigationLink"] + "/trackprotect_repos/repository" + MusicFile.Replace("\\", "/");
}
}
}
public static ConfirmationRequestResult RequestConfirmation(
string email,
string firstname,
string lastname,
string guid,
long requestingUserId,
int relationType,
string language = "")
{
long requestedUserId = 0;
ClientInfo requestingClientInfo = null;
ClientInfo requestedClientInfo = null;
using (Database db = new MySqlDatabase())
{
requestedUserId = db.GetUserIdByEmail(email);
requestingClientInfo = db.GetClientInfo(requestingUserId);
requestedClientInfo = db.GetClientInfo(requestedUserId);
if (db.RelationExists(requestingUserId, requestedUserId, relationType))
return ConfirmationRequestResult.Exists;
if (db.ConfirmationExists(requestingUserId, email))
return ConfirmationRequestResult.AlreadyRequested;
db.RequestConfirmation(guid, requestingUserId, requestedUserId, email, relationType);
}
string fullName = requestedClientInfo.GetFullName();
if (string.IsNullOrEmpty(fullName) || fullName == " ")
fullName = firstname;
if (!string.IsNullOrEmpty(fullName))
fullName += " ";
fullName += lastname;
string templatePath = string.Empty;
string subject = string.Empty;
if (relationType == 1)
{
if (!string.IsNullOrEmpty(language))
{
if (language.ToLower().Contains("en"))
{
templatePath = "~/Templates/confirmmgmt.tpl";
subject = "invites you as a managed musician";
}
else if (language.ToLower().Contains("du"))
{
templatePath = "~/Templates/nl/confirmmgmt.tpl";
subject = "nodigt je uit als managed muzikant";
}
}
else
{
templatePath = Resources.Resource.ConfirmMgmtTemplate;
subject = Resources.Resource.InviteManagedArtistSubject;
}
}
else
{
if (!string.IsNullOrEmpty(language))
{
if (language.ToLower().Contains("en"))
{
templatePath = "~/Templates/confirm.tpl";
subject = "invites you as a co-creator";
}
else if (language.ToLower().Contains("du"))
{
templatePath = "~/Templates/nl/confirm.tpl";
subject = "heeft je als co-creator uitgenodigd";
}
}
else
{
templatePath = Resources.Resource.ConfirmTemplate;
subject = Resources.Resource.InviteRelationsubject;
}
}
using (TextReader rdr = new StreamReader(HttpContext.Current.Server.MapPath(templatePath)))
{
string body = rdr.ReadToEnd();
string link = string.Empty;
if (requestedUserId != 0)
link =
string.Format(ConfigurationManager.AppSettings["SiteNavigationLink"] + "/Member/Confirm.aspx?id={0}&tp={1}", guid, relationType);
else
link =
string.Format(ConfigurationManager.AppSettings["SiteNavigationLink"] +
"/Member/Confirm.aspx?id={0}&tp={1}&requestingUserinfo={2}", guid, relationType, EncryptionClass.Encrypt(fullName));
body = body.Replace("{%EmailHeaderLogo%}", ConfigurationManager.AppSettings["EmailHeaderLogo"]);
body = body.Replace("{%EmailmailToLink%}", ConfigurationManager.AppSettings["EmailmailToLink"]);
body = body.Replace("{%SiteNavigationLink%}", ConfigurationManager.AppSettings["SiteNavigationLink"]);
body = body.Replace("{%EmailFooterLogo%}", ConfigurationManager.AppSettings["EmailFooterLogo"]);
body = body.Replace("{%EmailFBlink%}", ConfigurationManager.AppSettings["EmailFBlink"]);
body = body.Replace("{%EmailFBLogo%}", ConfigurationManager.AppSettings["EmailFBLogo"]);
body = body.Replace("{%EmailTwitterLink%}", ConfigurationManager.AppSettings["EmailTwitterLink"]);
body = body.Replace("{%EmailTwitterLogo%}", ConfigurationManager.AppSettings["EmailTwitterLogo"]);
body = body.Replace("{%EmailSoundCloudLink%}", ConfigurationManager.AppSettings["EmailSoundCloudLink"]);
body = body.Replace("{%EmailSoundCloudLogo%}", ConfigurationManager.AppSettings["EmailSoundCloudLogo"]);
body = body.Replace("{%receivingRelation%}", fullName);
body = body.Replace("{%firstname%}", requestingClientInfo.FirstName);
body = body.Replace("{%lastname%}", requestingClientInfo.LastName);
body = body.Replace("{%confirmlink%}", link);
if (!string.IsNullOrEmpty(requestedClientInfo.FirstName))
body = body.Replace("{%firstname_invitee%}", requestedClientInfo.FirstName);
else
body = body.Replace("{%firstname_invitee%}", fullName);
body = body.Replace("{%firstname_invitor%}", requestingClientInfo.FirstName);
body = body.Replace("{%FAQ%}", ConfigurationManager.AppSettings["SiteNavigationLink"] + "/FAQ.aspx");
body = body.Replace("{%lastname_invitor%}", requestingClientInfo.LastName);
try
{
Util.SendEmail(new string[] { email }, "*****@*****.**", requestingClientInfo.FirstName + " " + subject, body, null, 0);
}
catch { return ConfirmationRequestResult.Failed; }
}
return ConfirmationRequestResult.Success;
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session != null)
{
// Store essential session information temporarily
string culture = Session["culture"] as string ?? "nl-NL";
// Restore the essential session information
Session.Clear();
Session.RemoveAll();
Session["culture"] = culture;
}
if (!IsPostBack)
{
long userId = Util.UserId;
Session["bodyid"] = "user-home";
#region Generating product information and binding their price ------- !
List<Product> listProductInformation = new List<Product>();
using (Database db = new MySqlDatabase())
{
ClientInfo ci = null;
if (userId > -1)
ci = db.GetClientInfo(userId);
string currency = "EUR";
string countryIso2 = "NL";
string currencyFmt = "{0} {1:N2}";
if (ci != null)
{
countryIso2 = Util.GetCountryIso2(ci.Country);
currency = Util.GetCurrencyIsoNameByCountryIso2("NL");
currencyFmt = Util.GetCurrencyFormatByCountryIso2("NL");
}
string culture = "en-US";
if (Session["culture"] != null)
culture = Session["culture"] as string;
if (culture.Length == 2)
{
switch (culture)
{
case "nl":
culture += "-NL";
break;
case "en":
culture += "US";
break;
case "NL":
culture = "nl-" + culture;
break;
case "US":
culture = "en" + culture;
break;
}
}
ProductInfoList pil = db._GetProducts();
string price = string.Empty;
string link = string.Empty;
int i = 0;
foreach (ProductInfo prod in pil)
{
//Added by Nagesh
ProductPriceInfoList ppil = db.GetProductPrices(prod.ProductId, culture);
if (ppil[0].Price > 0m)
{
price = string.Format(
currencyFmt,
Util.GetCurrencySymbolByCountryIso2("NL"),
ppil[0].Price);
}
else
{
price = Resources.Resource.Quotation;
}
if (ppil[0].Price > 0m)
{
// Normal products, just process them
//link = string.Format(Session["userid"] != null ?
// "/Member/BuyProduct.aspx?pid={0}&country={1}&price={2}" :
// "/Account/Login.aspx?pid={0}&country={1}&price={2}",
// prod.ProductId, countryIso2, ppil[0].Price);
link = string.Format(Session["userid"] != null ?
"/Member/BuyProduct.aspx?pid={0}&country={1}&price={2}" :
"/Account/Login.aspx?pid={0}&country={1}&price={2}",
prod.ProductId, "NL", ppil[0].Price);
}
else
{
// Special products, check the description field to
// find out more about the product
switch (prod.Extra.ToLower())
{
case "subscription":
link = string.Format(Session["userid"] != null ?
"/Member/Subscription.aspx?pid={0}&country={1}&price={2}" :
"/Account/Login.aspx?pid={0}&country={1}&price={2}&sub=1"
);
break;
default:
link = string.Format(Session["userid"] != null ?
"/Member/Quotation.aspx?pid={0}&country={1}&price={2}" :
"/Account/Login.aspx?pid={0}&country={1}&price={2}&sub=0",
prod.ProductId, countryIso2, 0);
break;
}
}
//End Here
string desc = db.GetProduct_Desc_Price(prod.ProductId, culture);
Product _product = new Product();
_product.ProductPlan = prod.ProductPlan;
_product.Credits = Convert.ToString(prod.Credits);
_product.ProductDesc = desc.Split('#')[0];
_product.ProductPrice = desc.Split('#')[1];
_product.ProductId = prod.ProductId;
listProductInformation.Add(_product);
string planCss = "plans";
if (i == 3)
{
planCss = "plans managed";
}
ltrProducts.Text = ltrProducts.Text + "<li> <div class='" + planCss + "'><div class='icon-img'><i class='icon-logo'></i></div><h2 class='plan-title'> " + _product.ProductPlan + "<span class='number'>" + _product.Credits + "</span></h2><p class='description'>" + _product.ProductDesc + "</p><div class='row'><div class='small-6 columns'> <h2 class='price'>" + price + "</h2></div> <div class='small-6 columns'><a href=" + link + " class='button'>" + Resources.Resource.BuyNow + "</a></div></div><p class='footnote'> " + _product.ProductPrice + "</p> </div></li>";
i++;
}
}
#endregion
#region Setting en/nl contents ------- !
//ProductList.DataSource = listProductInformation;
//ProductList.DataBind();
if (Session["culture"] == null)
{
string _culture = "nl-NL";
string lang = "en";
if (Request.UserLanguages != null)
lang = Request.UserLanguages[0] ?? "en";
lang = lang.Split(';')[0].Trim();
switch (lang)
{
case "en":
_culture = "en-US";
break;
case "nl":
_culture = "nl-NL";
break;
}
Session["culture"] = _culture;
Culture = _culture;
UICulture = _culture;
Thread.CurrentThread.CurrentCulture = CultureInfo.CreateSpecificCulture(_culture);
Thread.CurrentThread.CurrentUICulture = new CultureInfo(_culture);
}
IncludePage(InfoGraphicLiteral, Resources.Resource.InfoGraphicSection);
IncludePage(UpsLiteral, Resources.Resource.UpsSection);
IncludePage(AboutLiteral, Resources.Resource.AboutSection);
IncludePage(IntroLiteral, Resources.Resource.IntroSection);
IncludePage(FooterLiteral, Resources.Resource.FooterSection);
IncludePage(FAQLiteral, Resources.Resource.FAQTop10);
IncludePage(newsLiteral, Resources.Resource.NewsLiteral);
#endregion
FormsAuthentication.SignOut();
}
//------- Highlight the selected lang button ------- !
if (Convert.ToString(Session["culture"]).Contains("nl"))
{
ClientScript.RegisterStartupScript(this.GetType(), "HighLightLangBtn", "HighLightLangBtn('" + "LanguageNL" + "');", true);
ClientScript.RegisterStartupScript(this.GetType(), "UnHighLightLangBtn", "UnHighLightLangBtn('" + "LanguageUS" + "');", true);
ClientScript.RegisterStartupScript(this.GetType(), "HighLightLangBtn", "HighLightLangBtn('" + "btnNLSmall" + "');", true);
ClientScript.RegisterStartupScript(this.GetType(), "UnHighLightLangBtn", "UnHighLightLangBtn('" + "btnENSmall" + "');", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "HighLightLangBtn", "HighLightLangBtn('" + "LanguageUS" + "');", true);
ClientScript.RegisterStartupScript(this.GetType(), "UnHighLightLangBtn", "UnHighLightLangBtn('" + "LanguageNL" + "');", true);
ClientScript.RegisterStartupScript(this.GetType(), "HighLightLangBtn", "HighLightLangBtn('" + "btnENSmall" + "');", true);
ClientScript.RegisterStartupScript(this.GetType(), "UnHighLightLangBtn", "UnHighLightLangBtn('" + "btnNLSmall" + "');", true);
}
}
public override bool ValidateUser(string username, string password)
{
bool isValid = false;
using (Database db = new MySqlDatabase())
{
UserState us = db.VerifyUser(username, password);
if (us.State >= 0)
{
UserInfo ui = db.GetUser(username, password);
if (ui != null && CheckPassword(md5(password), ui.Password))
{
if (ui.IsApproved > 0)
{
isValid = true;
HttpContext.Current.Session["access"] = password;
HttpContext.Current.Session["useruid"] = ui.UserUid;
HttpContext.Current.Session["userid"] = ui.UserId;
db.UpdateUserLogon(username, _applicationName);
string culture = "en-US";
ClientInfo ci = db.GetClientInfo(ui.UserId);
if (ci != null)
{
if (!string.IsNullOrEmpty(ci.Country) && !string.IsNullOrEmpty(ci.Language))
{
string cultLang = Util.GetLanguageCodeByEnglishName(ci.Language);
string cultCtry = Util.GetCountryIso2(ci.Country);
culture = string.Format("{0}-{1}", cultLang, cultCtry);
}
}
if (string.IsNullOrEmpty(culture) || culture == "-")
culture = "en-US";
//HttpContext.Current.Session["culture"] = culture;
}
}
}
}
return isValid;
}
public override bool UnlockUser(string username)
{
bool res = false;
using (Database db = new MySqlDatabase())
{
res = db.UnlockUser(username, _applicationName);
}
return res;
}
public override string GetUserNameByEmail(string email)
{
string username = string.Empty;
using (Database db = new MySqlDatabase())
{
username = db.GetUserNameByEmail(email, _applicationName);
}
if (username == null)
username = string.Empty;
return username;
}
public override bool ChangePassword(string username, string oldPwd, string newPwd)
{
if (!ValidateUser(username, oldPwd))
return false;
ValidatePasswordEventArgs args =
new ValidatePasswordEventArgs(username, newPwd, true);
OnValidatingPassword(args);
if (args.Cancel)
{
if (args.FailureInformation != null)
throw args.FailureInformation;
throw new MembershipPasswordException("Change password canceled due to new password validation failure.");
}
int rowsAffected = 0;
using (Database db = new MySqlDatabase())
{
rowsAffected = db.ChangePassword(username, _applicationName, newPwd);
}
if (rowsAffected > 0)
return true;
return false; // update failed
}
protected void Page_Load(object sender, EventArgs e)
{
new BasePage();
Session["bodyid"] = "coupon";
Control ctrlDiv = this.Master.FindControl("logoutDiv");
ctrlDiv.Visible = false;
if (!IsPostBack)
{
if (!string.IsNullOrEmpty(Request.QueryString["TrackID"]))
{
using (Database db = new MySqlDatabase())
{
IDictionary<string, string> trackInfo = new Dictionary<string, string>();
try
{
string decryptString = EncryptionClass.Decrypt(Request.QueryString["TrackID"]);
if (!string.IsNullOrEmpty(decryptString))
{
if (Convert.ToInt32(decryptString) != 0)
{
trackInfo = db.getTrackInformationByID(Convert.ToInt32(decryptString));
StageName.Text = trackInfo["StageName"];
TrackName.Text = trackInfo["TrackName"];
ISRCCode.Text = trackInfo["isrcCode"];
string tags = string.Empty;
tags = tags + (string.IsNullOrEmpty(trackInfo["genre1"]) ? string.Empty : trackInfo["genre1"] + " ");
tags = tags + (string.IsNullOrEmpty(trackInfo["genre2"]) ? string.Empty : trackInfo["genre2"] + " ");
tags = tags + (string.IsNullOrEmpty(trackInfo["genre3"]) ? string.Empty : trackInfo["genre3"] + " ");
tags = tags + (string.IsNullOrEmpty(trackInfo["subgenre1"]) ? string.Empty : trackInfo["subgenre1"] + " ");
tags = tags + (string.IsNullOrEmpty(trackInfo["subgenre2"]) ? string.Empty : trackInfo["subgenre2"] + " ");
tags = tags + (string.IsNullOrEmpty(trackInfo["subgenre3"]) ? string.Empty : trackInfo["subgenre3"] + " ");
tags = tags + (string.IsNullOrEmpty(trackInfo["tag1"]) ? string.Empty : trackInfo["tag1"] + " ");
tags = tags + (string.IsNullOrEmpty(trackInfo["tag2"]) ? string.Empty : trackInfo["tag2"] + " ");
tags = tags + (string.IsNullOrEmpty(trackInfo["tag3"]) ? string.Empty : trackInfo["tag3"] + " ");
AddedTags.Text = tags;
}
else
{
StageName.Text = TrackName.Text = ISRCCode.Text = AddedTags.Text = Resources.Resource.NoTrackInfoFound;
ClientScript.RegisterStartupScript
(this.GetType(), "alert", "alert('" + Resources.Resource.TrackInfoCannotShown + "');", true);
}
}
else
{
StageName.Text = TrackName.Text = ISRCCode.Text = AddedTags.Text = Resources.Resource.NoTrackInfoFound;
ClientScript.RegisterStartupScript
(this.GetType(), "alert", "alert('" + Resources.Resource.TrackInfoCannotShown + "');", true);
}
}
catch
{
StageName.Text = TrackName.Text = ISRCCode.Text = AddedTags.Text = Resources.Resource.NoTrackInfoFound;
ClientScript.RegisterStartupScript
(this.GetType(), "alert", "alert('" + Resources.Resource.TrackInfoCannotShown + "');", true);
}
}
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "alert", "alert('" + Resources.Resource.NoTrackInfoFound + "');", true);
}
}
if (Convert.ToString(Session["culture"]).Contains("nl"))
{
ClientScript.RegisterStartupScript(this.GetType(), "HighLightLangBtn", "HighLightLangBtn('" + "ctl00_LanguageNL" + "');", true);
ClientScript.RegisterStartupScript(this.GetType(), "UnHighLightLangBtn", "UnHighLightLangBtn('" + "ctl00_LanguageUS" + "');", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "HighLightLangBtn", "HighLightLangBtn('" + "ctl00_LanguageUS" + "');", true);
ClientScript.RegisterStartupScript(this.GetType(), "UnHighLightLangBtn", "UnHighLightLangBtn('" + "ctl00_LanguageNL" + "');", true);
}
}
protected void Page_PreRender(Object o, EventArgs e)
{
using (Database db = new MySqlDatabase())
{
ClientInfo ci = db.GetClientInfo(Util.UserId);
bool isNotExpired = true;
Facebook.AuthenticationService authService = new Facebook.AuthenticationService();
Facebook.Me me;
string accessToken = string.Empty;
if (authService.TryAuthenticate(out me, out accessToken))
{
isNotExpired = true;
}
else
{
db.RemoveSocialCredential(ci.ClientId, SocialConnector.Facebook);
db.UpdateFacebookID(ci.ClientId);
isNotExpired = false;
}
if (!string.IsNullOrEmpty(ci.SoundCloudId))
SoundcloudItag.Attributes.Add("class", "soundcloud");
else
SoundcloudItag.Attributes.Add("class", "soundcloud disabled");
if (isNotExpired)
FacebookHeading.Attributes.Add("class", "social facebook");
else
FacebookHeading.Attributes.Add("class", "social facebook disabled");
if (!string.IsNullOrEmpty(ci.TwitterId))
TwitterHeading.Attributes.Add("class", "social twitter");
else
TwitterHeading.Attributes.Add("class", "social twitter disabled");
}
}
protected void Page_Load(object sender, EventArgs e)
{
Session["bodyid"] = "user-home";
//IncludePage(PayResultInc, Resources.Resource.incPayResult);
//IncludePage(RhosMovementInc, Resources.Resource.incRhosMovement2);
using (Database db = new MySqlDatabase())
{
UserInfo ui = db.GetUser(Util.UserId);
email = ui.Email;
ClientInfo ci = db.GetClientInfo(Util.UserId);
name = ci.FirstName;
DataSet ds = db.GetRegister(Util.UserId);
int protectedTracks = ds.Tables[0].Rows.Count;
LoggedOnTitle.Text = Resources.Resource.LoggedOnTitle;
LoggedOnUserName.Text = string.Format("<span><b>{0}</b></span>", ci.FirstName); // ci.GetFullName());
CreditsLiteral.Text = Convert.ToString(Util.GetUserCredits(Util.UserId));
ProtectedLiteral.Text = Convert.ToString(protectedTracks);
decimal percentComplete = 0m;
if (Session["percentComplete"] != null)
percentComplete = Convert.ToDecimal(Session["percentComplete"]);
CompletedLiteral.Text = string.Empty;
if (percentComplete < 100)
CompletedLiteral.Text = string.Format(Resources.Resource.PercentComplete, percentComplete / 100m);
divAccPerCompleted.Visible = ClickToLinkLiteral.Visible = (CompletedLiteral.Text != string.Empty);
}
string res = Request.Params["res"] ?? "unknown";
if (!string.IsNullOrEmpty(res))
{
switch (res.ToLower())
{
case "success":
ProcessTransaction();
break;
case "error":
ProcessFailure();
break;
case "postback":
ProcessPostback();
break;
default:
break;
}
}
if (Convert.ToString(Session["culture"]).Contains("nl"))
{
ClientScript.RegisterStartupScript(this.GetType(), "HighLightLangBtn", "HighLightLangBtn('" + "ctl00_HeadLoginView_LanguageNL" + "');", true);
ClientScript.RegisterStartupScript(this.GetType(), "UnHighLightLangBtn", "UnHighLightLangBtn('" + "ctl00_HeadLoginView_LanguageUS" + "');", true);
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "HighLightLangBtn", "HighLightLangBtn('" + "ctl00_HeadLoginView_LanguageUS" + "');", true);
ClientScript.RegisterStartupScript(this.GetType(), "UnHighLightLangBtn", "UnHighLightLangBtn('" + "ctl00_HeadLoginView_LanguageNL" + "');", true);
}
CreditsLiteral.Text = Convert.ToString(Util.GetUserCredits(Util.UserId));
}
private void ProcessTransaction()
{
long userId = Util.UserId;
long prodId = 0L;
string country = "NL";
string currency = "EUR";
string culture = "nl-NL";
decimal amount = 0m;
if (Session["pid"] != null)
prodId = Convert.ToInt64(Session["pid"]);
if (Session["amt"] != null)
amount = Convert.ToDecimal(Session["amt"]);
if (Session["culture"] != null)
culture = Session["culture"] as string;
country = culture.Substring(3);
currency = Util.GetCurrencyIsoNameByCountryIso2(country);
Logger.Instance.Write(LogLevel.Info, "Process successful transaction: {0}", Request.RawUrl);
string res = Request.Params["res"] ?? string.Empty;
string status = Request.Params["Status"] ?? string.Empty;
string statusCode = Request.Params["StatusCode"] ?? string.Empty;
string merchant = Request.Params["Merchant"] ?? string.Empty;
string orderId = Request.Params["OrderID"] ?? string.Empty;
string paymentId = Request.Params["PaymentID"] ?? string.Empty;
string reference = Request.Params["Reference"] ?? string.Empty;
string transid = Request.Params["TransactionID"] ?? string.Empty;
string paymentMethod = Request.Params["PaymentMethod"] ?? string.Empty;
if (!string.IsNullOrEmpty(statusCode))
statusCode = Uri.UnescapeDataString(statusCode);
using (Database db = new MySqlDatabase())
{
StringBuilder sb = new StringBuilder();
ProductInfo pi = db.GetProductById(prodId);
switch (db.UpdateTransaction(orderId, res, status, statusCode, merchant, paymentId, reference,
transid, paymentMethod, amount, pi, currency, country))
{
case TransactionResult.Success:
{
long Transaction_id = 0;
long.TryParse(orderId, out Transaction_id);
db.UpdateUserCredits(userId, prodId, pi.Credits);
db.AddCreditHistory(userId, prodId, pi.Credits, Transaction_id);
sb.Append("<div>");
sb.AppendFormat("<p><strong>{0}</strong></p>", Resources.Resource.TransactionSuccessful);
sb.AppendFormat(Resources.Resource.HasCreditsNow, Util.GetUserCredits(userId));
sb.Append("</div>");
}
break;
case TransactionResult.NotFound:
{
sb.Append("<div>");
sb.AppendFormat("<p><strong>{0}</strong></p>", Resources.Resource.TransactionFailed);
sb.AppendFormat(Resources.Resource.HasCreditsNow, Util.GetUserCredits(userId));
sb.Append("</div>");
}
break;
case TransactionResult.AlreadyCompleted:
{
sb.Append("<div>");
sb.AppendFormat("<p><strong>{0}</strong></p>", Resources.Resource.TransactionAlreadyCompleted);
sb.AppendFormat(Resources.Resource.HasCreditsNow, Util.GetUserCredits(userId));
sb.Append("</div>");
}
break;
}
ResultLiteral.Text = sb.ToString();
}
sendMail(orderId, Resources.Resource.CreditPurchaseSuccessSubject, Resources.Resource.CreditPurchaseSuccessBody);
}
public override MembershipUser GetUser(string username, bool userIsOnline)
{
MembershipUser user = null;
using (Database db = new MySqlDatabase())
{
user = db.GetUser(Name, username, _applicationName, userIsOnline);
}
return user;
}
public override MembershipUser GetUser(object providerUserKey, bool userIsOnline)
{
MembershipUser u = null;
using (Database db = new MySqlDatabase())
{
u = db.GetUser(Name, providerUserKey, _applicationName, userIsOnline);
}
return u;
}
public override bool ChangePasswordQuestionAndAnswer(string username,
string password, string newQuestion, string newAnswer)
{
if (!ValidateUser(username, password))
return false;
int rowsAffected = 0;
using (Database db = new MySqlDatabase())
{
rowsAffected = db.ChangePasswordQuestionAndAnswer(username, _applicationName, newQuestion, newAnswer);
}
return (rowsAffected > 0);
}
public override string ResetPassword(string username, string answer)
{
if (!EnablePasswordReset)
throw new NotSupportedException("Password reset is not enabled.");
if (string.IsNullOrEmpty(answer) && RequiresQuestionAndAnswer)
{
UpdateFailureCount(username, "passwordAnswer");
throw new ProviderException("Password answer required for password reset.");
}
string newPassword = System.Web.Security.Membership.GeneratePassword(NEW_PASSWORD_LENGTH, MinRequiredNonAlphanumericCharacters);
ValidatePasswordEventArgs args = new ValidatePasswordEventArgs(username, newPassword, true);
OnValidatingPassword(args);
if (args.Cancel)
{
if (args.FailureInformation != null)
throw args.FailureInformation;
else
throw new MembershipPasswordException("Reset password canceled due to password validation failure.");
}
string res = string.Empty;
using (Database db = new MySqlDatabase())
{
res = db.ResetPassword(
username,
_applicationName,
answer, newPassword,
PasswordAttemptWindow,
RequiresQuestionAndAnswer,
PasswordFormat,
MaxInvalidPasswordAttempts,
this);
}
if (!string.IsNullOrEmpty(res))
return newPassword;
throw new MembershipPasswordException("User not found, or user is locked out. Password not reset.");
}
public override MembershipUser CreateUser(
string username,
string password,
string email,
string question,
string answer,
bool isApproved,
object providerUserKey,
out MembershipCreateStatus status)
{
if (string.IsNullOrEmpty(username))
username = email;
status = MembershipCreateStatus.ProviderError;
ValidatePasswordEventArgs args =
new ValidatePasswordEventArgs(username, password, true);
OnValidatingPassword(args);
if (args.Cancel)
{
status = MembershipCreateStatus.InvalidPassword;
return null;
}
if (RequiresUniqueEmail && GetUserNameByEmail(email) != "")
{
status = MembershipCreateStatus.DuplicateEmail;
return null;
}
MembershipUser user = GetUser(username, false);
if (user == null)
{
if (providerUserKey == null)
{
providerUserKey = Guid.NewGuid();
}
else
{
if (!(providerUserKey is Guid))
{
status = MembershipCreateStatus.InvalidProviderUserKey;
return null;
}
}
int subscriptionType = 0;
if (HttpContext.Current.Session["subscriptiontype"] != null)
subscriptionType = (int)HttpContext.Current.Session["subscriptiontype"];
using (Database db = new MySqlDatabase())
{
if (db.RegisterUser(
username,
_applicationName,
email,
"",
password,
question,
answer,
subscriptionType) > 0)
status = MembershipCreateStatus.Success;
}
return GetUser(username, false);
}
status = MembershipCreateStatus.DuplicateUserName;
return null;
}
public override void UpdateUser(MembershipUser user)
{
using (Database db = new MySqlDatabase())
{
db.UpdateUser(user, _applicationName);
}
}
public override bool DeleteUser(string username, bool deleteAllRelatedData)
{
bool res = false;
using (Database db = new MySqlDatabase())
{
res = db.DeleteUser(username, _applicationName, deleteAllRelatedData);
}
return res;
}
private void UpdateFailureCount(string username, string failureType)
{
using (Database db = new MySqlDatabase())
{
db.UpdateFailureCount(username, _applicationName, failureType, PasswordAttemptWindow, MaxInvalidPasswordAttempts);
}
}
public override MembershipUserCollection FindUsersByName(string usernameToMatch, int pageIndex, int pageSize, out int totalRecords)
{
MembershipUserCollection users = new MembershipUserCollection();
using (Database db = new MySqlDatabase())
{
users = db.FindUsersByName(Name, usernameToMatch, _applicationName, pageIndex, pageSize, out totalRecords);
}
return users;
}
protected void Page_Load(object sender, EventArgs e)
{
IncludePage(SelectProductInc, Resources.Resource.incSelectProduct);
IncludePage(RhosMovementInc, Resources.Resource.incRhosMovement2);
long userId = Util.UserId;
divSignUp.Visible = (Session["userid"] == null);
if (!IsPostBack)
{
using (Database db = new MySqlDatabase())
{
ClientInfo ci = null;
if (userId > -1)
ci = db.GetClientInfo(userId);
string currency = "EUR";
string countryIso2 = "NL";
string currencyFmt = "{0} {1:N2}";
if (ci != null)
{
countryIso2 = Util.GetCountryIso2(ci.Country);
currency = Util.GetCurrencyIsoNameByCountryIso2("NL");
currencyFmt = Util.GetCurrencyFormatByCountryIso2("NL");
}
string culture = "en-US";
if (Session["culture"] != null)
culture = Session["culture"] as string;
if (culture.Length == 2)
{
switch (culture)
{
case "nl":
culture += "-NL";
break;
case "en":
culture += "US";
break;
case "NL":
culture = "nl-" + culture;
break;
case "US":
culture = "en" + culture;
break;
}
}
ProductInfoList pil = db.GetProducts();
int i = 0;
foreach (ProductInfo prod in pil)
{
ProductPriceInfoList ppil = db.GetProductPrices(prod.ProductId, culture);
TableRow row = new TableRow();
row.VerticalAlign = VerticalAlign.Top;
TableCell cell = new TableCell();
if (i < 4)
{
Image img = new Image();
img.ImageUrl = string.Format(Resources.Resource.imgVaultFmt, _desc[i]);
cell.Controls.Add(img);
++i;
}
else
{
cell.Text = " ";
}
row.Cells.Add(cell);
string desc = db.GetProductTitle(prod.ProductId, culture);
cell = new TableCell();
Literal lit = new Literal();
lit.Text = "<div style=\"margin-left:8px;margin-right:8px;\">" + desc + "</div>";
cell.Controls.Add(lit);
row.Cells.Add(cell);
cell = new TableCell();
cell.Width = Unit.Pixel(50);
cell.Font.Bold = true;
cell.HorizontalAlign = HorizontalAlign.Center;
if (ppil[0].Price > 0m)
{
cell.Text = string.Format(
currencyFmt,
Util.GetCurrencySymbolByCountryIso2("NL"),
ppil[0].Price);
}
else
{
cell.Text = Resources.Resource.Quotation;
}
row.Cells.Add(cell);
cell = new TableCell();
HyperLink hl = new HyperLink();
hl.CssClass = "linkBuy";
if (string.IsNullOrEmpty(countryIso2))
countryIso2 = "NL";
if (ppil[0].Price > 0m)
{
// Normal products, just process them
hl.NavigateUrl = string.Format(Session["userid"] != null ?
"~/Member/BuyProduct.aspx?pid={0}&country={1}&price={2}" :
"~/Account/Login.aspx?pid={0}&country={1}&price={2}",
prod.ProductId, countryIso2, ppil[0].Price);
hl.ImageUrl = Resources.Resource.imgBuyCredits;
}
else
{
// Special products, check the description field to
// find out more about the product
switch (prod.Extra.ToLower())
{
case "subscription":
hl.NavigateUrl = string.Format(Session["userid"] != null ?
"~/Member/Subscription.aspx?pid={0}&country={1}&price={2}" :
"~/Account/Login.aspx?pid={0}&country={1}&price={2}&sub=1"
);
break;
default:
hl.NavigateUrl = string.Format(Session["userid"] != null ?
"~/Member/Quotation.aspx?pid={0}&country={1}&price={2}" :
"~/Account/Login.aspx?pid={0}&country={1}&price={2}&sub=0",
prod.ProductId, countryIso2, 0);
hl.ImageUrl = Resources.Resource.imgQuotation;
break;
}
}
cell.Controls.Add(hl);
row.Cells.Add (cell);
ProductTable.Rows.Add (row);
}
}
}
else
{
}
}
public override MembershipUserCollection GetAllUsers(int pageIndex, int pageSize, out int totalRecords)
{
totalRecords = 0;
MembershipUserCollection users = new MembershipUserCollection();
using (Database db = new MySqlDatabase())
{
totalRecords = db.GetUserCount(_applicationName);
if (totalRecords <= 0)
return users;
users = db.GetAllUsers(Name, _applicationName, pageIndex, pageSize);
}
return users;
}
public static ConfirmationResult ProcessConfirmation(string guid, int relationType)
{
ConfirmationResult result = ConfirmationResult.ConfirmationFailed;
string emailRequested = string.Empty;
string emailRequesting = string.Empty;
ClientInfo requestingClientInfo = null;
ClientInfo requestedClientInfo = null;
using (Database db = new MySqlDatabase())
{
result = db.ProcessConfirmation(guid, relationType, out emailRequested, out emailRequesting);
long requestedUserId = db.GetUserIdByEmail(emailRequested);
long requestingUserId = db.GetUserIdByEmail(emailRequesting);
requestingClientInfo = db.GetClientInfo(requestingUserId);
requestedClientInfo = db.GetClientInfo(requestedUserId);
}
if (result == ConfirmationResult.Success)
{
string _template = string.Empty;
if (relationType == 1)
_template = Resources.Resource.ConfirmRequestorTemplate;
else
_template = Resources.Resource.TemplateConfirmrelationcreate;
using (TextReader rdr = new StreamReader(HttpContext.Current.Server.MapPath(_template)))
{
string body = rdr.ReadToEnd();
body = body.Replace("{%EmailHeaderLogo%}", ConfigurationManager.AppSettings["EmailHeaderLogo"]);
body = body.Replace("{%EmailmailToLink%}", ConfigurationManager.AppSettings["EmailmailToLink"]);
body = body.Replace("{%SiteNavigationLink%}", ConfigurationManager.AppSettings["SiteNavigationLink"]);
body = body.Replace("{%EmailFooterLogo%}", ConfigurationManager.AppSettings["EmailFooterLogo"]);
body = body.Replace("{%EmailFBlink%}", ConfigurationManager.AppSettings["EmailFBlink"]);
body = body.Replace("{%EmailFBLogo%}", ConfigurationManager.AppSettings["EmailFBLogo"]);
body = body.Replace("{%EmailTwitterLink%}", ConfigurationManager.AppSettings["EmailTwitterLink"]);
body = body.Replace("{%EmailTwitterLogo%}", ConfigurationManager.AppSettings["EmailTwitterLogo"]);
body = body.Replace("{%EmailSoundCloudLink%}", ConfigurationManager.AppSettings["EmailSoundCloudLink"]);
body = body.Replace("{%EmailSoundCloudLogo%}", ConfigurationManager.AppSettings["EmailSoundCloudLogo"]);
body = body.Replace("{%receivingRelation%}", requestingClientInfo.GetFullName());
body = body.Replace("{%firstname%}", requestedClientInfo.FirstName);
body = body.Replace("{%lastname%}", requestedClientInfo.LastName);
body = body.Replace("{%firstname_invitee%}", requestedClientInfo.FirstName);
body = body.Replace("{%firstname_invitor%}", requestingClientInfo.FirstName);
body = body.Replace("{%lastname_invitor%}", requestingClientInfo.LastName);
body = body.Replace("{%FAQ%}", ConfigurationManager.AppSettings["SiteNavigationLink"] + "/FAQ.aspx");
try
{
Util.SendEmail(new string[] { emailRequesting }, "*****@*****.**",
Resources.Resource.ConfirmationManagedMusician, body, null, 0);
}
catch (Exception ex)
{
Logger.Instance.Write(LogLevel.Error, ex, "[ProcessConfirmation]");
}
}
}
return result;
}
public override int GetNumberOfUsersOnline()
{
int numOnline = 0;
using (Database db = new MySqlDatabase())
{
numOnline = db.GetNumberOfUsersOnline(_applicationName);
}
return numOnline;
}
private static string GetConfiguration(string key)
{
string res = null;
using (Database db = new MySqlDatabase())
{
res = db.GetSetting(key);
}
return res;
}
public override string GetPassword(string username, string answer)
{
if (!EnablePasswordRetrieval)
throw new ProviderException("Password retrieval not enabled.");
if (PasswordFormat == MembershipPasswordFormat.Hashed)
throw new ProviderException("Cannot retrieve hashed passwords.");
string password = null;
string passwordAnswer = null;
using (Database db = new MySqlDatabase())
{
password = db.GetPassword(username, answer, _applicationName, out passwordAnswer);
}
if (RequiresQuestionAndAnswer && !CheckPassword(answer, passwordAnswer))
{
UpdateFailureCount(username, "passwordAnswer");
throw new MembershipPasswordException("Incorrect password answer.");
}
if (PasswordFormat == MembershipPasswordFormat.Encrypted)
password = UnEncodePassword(password);
return password;
}
