本文整理汇总了C#中MySqlDatabase.GetClientInfo方法的典型用法代码示例。如果您正苦于以下问题:C# MySqlDatabase.GetClientInfo方法的具体用法?C# MySqlDatabase.GetClientInfo怎么用?C# MySqlDatabase.GetClientInfo使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类MySqlDatabase
的用法示例。
在下文中一共展示了MySqlDatabase.GetClientInfo方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
IncludePage(HowItWorksInc, Resources.Resource.incHowItWorks);
IncludePage(ProtectInc, Resources.Resource.incProtect);
IncludePage(RhosMovementInc, Resources.Resource.incRhosMovement);
using (Database db = new MySqlDatabase())
{
UserInfo ui = db.GetUser(Util.UserId);
ClientInfo ci = db.GetClientInfo(Util.UserId);
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 = string.Format(Resources.Resource.spnCredits, Util.GetUserCredits(Util.UserId));
ProtectedLiteral.Text = string.Format(Resources.Resource.spnProtected, 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);
ClickToLinkLiteral.Visible = (CompletedLiteral.Text != string.Empty);
}
if (!IsPostBack)
{
}
}
示例2: AddCoArtist
protected void AddCoArtist(object sender, CommandEventArgs e)
{
bool found = false;
if (CoArtistDropDown.SelectedIndex < 0)
return;
using (Database db = new MySqlDatabase())
{
long userId = Convert.ToInt64(CoArtistDropDown.SelectedValue);
if (userId > 0)
{
UserInfo ui = db.GetUser(userId);
ClientInfo ci = db.GetClientInfo(userId);
Session["user.userid"] = userId;
AddCoArtistRow(CoArtistsTable, ci.GetFullName(), CoArtistRole.Text, ci.ClientId);
DataView dataView = new DataView(CoArtistsTable);
CoArtistsList.DataSource = dataView;
CoArtistsList.DataBind();
found = true;
}
}
if (!found)
ErrorMessage.Text = Resources.Resource.ClientNotFound;
}
示例3: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
if (Request.Params["pid"] != null)
{
long productId;
if (!long.TryParse(Request.Params["pid"], out productId))
productId = 0;
Session["quotation.pid"] = productId;
}
using (Database db = new MySqlDatabase())
{
UserInfo ui = db.GetUser(Util.UserId);
ClientInfo ci = db.GetClientInfo(Util.UserId);
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 = string.Format(Resources.Resource.spnCredits, Util.GetUserCredits(Util.UserId));
ProtectedLiteral.Text = string.Format(Resources.Resource.spnProtected, protectedTracks);
string userDocPath = db.GetUserDocumentPath(ui.UserId, Session["access"] as string);
decimal percentComplete = DetermineCompletion(userDocPath, ui, ci);
CompletedLiteral.Text = string.Empty;
if (percentComplete < 100)
CompletedLiteral.Text = string.Format(Resources.Resource.PercentComplete, percentComplete / 100m);
ClickToLinkLiteral.Visible = (CompletedLiteral.Text != string.Empty);
}
}
示例4: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
Session["bodyid"] = "relationships";
IncludePage(ProtectInc, Resources.Resource.incProtect);
IncludePage(RhosMovementInc, Resources.Resource.incRhosMovement2);
string fullname = string.Empty;
using (Database db = new MySqlDatabase())
{
UserInfo ui = db.GetUser(Util.UserId);
ClientInfo ci = db.GetClientInfo(Util.UserId);
DataSet ds = db.GetRegister(Util.UserId);
int protectedTracks = ds.Tables[0].Rows.Count;
fullname = ci.FirstName; //ci.GetFullName();
LoggedOnTitle.Text = Resources.Resource.LoggedOnTitle;
LoggedOnUserName.Text = string.Format("<span><b>{0}</b></span>", fullname);
CreditsLiteral.Text = Util.GetUserCredits(Util.UserId).ToString();
ProtectedLiteral.Text = protectedTracks.ToString();
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 email = Request.Params["email"] ?? "???";
string format = Resources.Resource.fmtInviteSuccess;
if (Request.Params["mode"] != null)
{
if (Request.Params["mode"] == "1")
format = Resources.Resource.fmtInviteExists;
}
InviteSuccessLiteral.Text = string.Format(format, email);
if (!IsPostBack)
{
}
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);
}
}
示例5: TpIdSearch
protected void TpIdSearch(object sender, CommandEventArgs e)
{
string email = TpIdText.Text;
using (Database db = new MySqlDatabase())
{
long userId = db.GetUserIdByEmail(email);
UserInfo ui = db.GetUser(userId);
ClientInfo ci = db.GetClientInfo(userId);
Session["mgmt.userid"] = userId;
ManagerNameLabel.Text = ci.GetFullName();
}
}
示例6: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
Session["bodyid"] = "relationships";
Session["loggedinUserEmail"] = string.Empty;
Util.GetUserClearanceLevels(Util.UserId, out _vcl, out _ecl);
if (_vcl < 100 && _ecl < 100)
{
divManaccChk.Visible = false;
}
else
{
divManaccChk.Visible = true;
}
using (Database db = new MySqlDatabase())
{
UserInfo ui = db.GetUser(Util.UserId);
ClientInfo ci = db.GetClientInfo(Util.UserId);
DataSet ds = db.GetRegister(Util.UserId);
int protectedTracks = ds.Tables[0].Rows.Count;
Session["loggedinUserEmail"] = ui.Email;
LoggedOnTitle.Text = Resources.Resource.LoggedOnTitle;
LoggedOnUserName.Text = string.Format("<span><b>{0}</b></span>", ci.FirstName); // ci.GetFullName());
CreditsLiteral.Text = Util.GetUserCredits(Util.UserId).ToString();
ProtectedLiteral.Text = protectedTracks.ToString();
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);
}
//------- Highlight the selected lang button ------- !
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);
ddl_Language.SelectedValue = "nl";
}
else
{
ClientScript.RegisterStartupScript(this.GetType(), "HighLightLangBtn", "HighLightLangBtn('" + "ctl00_HeadLoginView_LanguageUS" + "');", true);
ClientScript.RegisterStartupScript(this.GetType(), "UnHighLightLangBtn", "UnHighLightLangBtn('" + "ctl00_HeadLoginView_LanguageNL" + "');", true);
ddl_Language.SelectedValue = "en";
}
}
示例7: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
try
{
IncludePage(AccountOverviewInc, Resources.Resource.incMemberHome);
IncludePage(RhosMovementInc, Resources.Resource.incRhosMovement2);
using (Database db = new MySqlDatabase())
{
UserInfo ui = db.GetUser(Util.UserId);
ClientInfo ci = db.GetClientInfo(Util.UserId);
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 = string.Format(Resources.Resource.spnCredits, Util.GetUserCredits(Util.UserId));
ProtectedLiteral.Text = string.Format(Resources.Resource.spnProtected, protectedTracks);
string userDocPath = db.GetUserDocumentPath(ui.UserId, Session["access"] as string);
decimal percentComplete = DetermineCompletion(userDocPath, ui, ci);
Session["percentComplete"] = percentComplete;
CompletedLiteral.Text = string.Empty;
if (percentComplete < 100)
CompletedLiteral.Text = string.Format(Resources.Resource.PercentComplete, percentComplete / 100m);
ClickToLinkLiteral.Visible = (CompletedLiteral.Text != string.Empty);
}
FillAccountInformation();
int couponEntry = 0;
if (Session["coupon.entry"] != null)
couponEntry = (int)Session["coupon.entry"];
if (!IsPostBack)
{
using (Database db = new MySqlDatabase())
{
int violationState = db.GetUserWhmcsClientId(Util.UserId);
if (violationState == 1)
couponEntry = 3;
}
}
}
catch (Exception ex)
{
Logger.Instance.Write(LogLevel.Error, ex, "AccountOverView<Exception>");
}
}
示例8: Persist
public void Persist(
OAuthTokenResponse me,
string oauth_token,
string oauth_verifier)
{
if (_clientInfo == null)
GetUser();
using (Database db = new MySqlDatabase())
{
ClientInfo ci = db.GetClientInfo(Util.UserId);
db.UpdateSocialCredential(ci.ClientId, SocialConnector.Twitter, "twitterid", Convert.ToString(me.UserId));
db.UpdateSocialCredential(ci.ClientId, SocialConnector.Twitter, "oauthtoken", oauth_token);
db.UpdateSocialCredential(ci.ClientId, SocialConnector.Twitter, "oauthverifier", oauth_verifier);
_clientInfo.TwitterId = me.ScreenName;
db.RegisterClientInfo(
_clientInfo.LastName,
_clientInfo.FirstName,
_clientInfo.AddressLine1,
_clientInfo.AddressLine2,
_clientInfo.ZipCode,
_clientInfo.State,
_clientInfo.City,
_clientInfo.Country,
_clientInfo.Language,
_clientInfo.Telephone,
_clientInfo.Cellular,
_clientInfo.CompanyName,
_clientInfo.UserId,
_clientInfo.AccountOwner,
_clientInfo.BumaCode,
_clientInfo.SenaCode,
_clientInfo.IsrcCode,
_clientInfo.TwitterId,
_clientInfo.FacebookId,
_clientInfo.SoundCloudId,
_clientInfo.SoniallId,
_clientInfo.OwnerKind,
_clientInfo.CreditCardNr,
_clientInfo.CreditCardCvv,
_clientInfo.EmailReceipt,
_clientInfo.Referer,
_clientInfo.Gender,
_clientInfo.Birthdate,
_clientInfo.stagename);
}
}
示例9: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
Session["bodyid"] = "tracks";
IncludePage(SelectProductInc, Resources.Resource.incSelectProduct);
IncludePage(RhosMovementInc, Resources.Resource.incRhosMovement2);
long userId = Util.UserId;
using (Database db = new MySqlDatabase())
{
UserInfo ui = db.GetUser(Util.UserId);
ClientInfo ci = db.GetClientInfo(Util.UserId);
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 = Util.GetUserCredits(Util.UserId).ToString();
ProtectedLiteral.Text = protectedTracks.ToString();
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);
}
getProductList(userId);
SetProductItemLinks();
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);
}
}
示例10: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
IncludePage(FAQInc, Resources.Resource.incFAQ);
//IncludePage(ProtectInc, Resources.Resource.incProtect);
//IncludePage(RhosMovementInc, Resources.Resource.incRhosMovement);
UserInformation();
using (Database db = new MySqlDatabase())
{
UserInfo ui = db.GetUser(Util.UserId);
ClientInfo ci = db.GetClientInfo(Util.UserId);
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 = string.Format(Resources.Resource.spnCredits, Util.GetUserCredits(Util.UserId));
CreditsLiteral.Text = Convert.ToString(Util.GetUserCredits(Util.UserId));
//ProtectedLiteral.Text = string.Format(Resources.Resource.spnProtected, protectedTracks);
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);
}
//------- Highlight the selected lang button ------- !
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);
}
ClientScript.RegisterStartupScript(this.GetType(), "HighLightMenu", "HighLightMenu('" + "Menu4" + "');", true);
}
示例11: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
string retUrl = Request.Params["url"].Trim('#');
string accessToken = string.Empty;
using (Database db = new MySqlDatabase())
{
ClientInfo ci = db.GetClientInfo(Util.UserId);
string[] kvps = retUrl.Split('&');
foreach (string kvp in kvps)
{
string[] parts = kvp.Split('=');
if (parts.Length == 2)
{
string key = parts[0];
string val = parts[1];
if (val.EndsWith(",/social/soundcloud.aspx"))
val = val.Substring(0, val.Length - ",/social/soundcloud.aspx".Length);
if (string.Compare(key, "access_token", true) == 0)
accessToken = val;
db.UpdateSocialCredential(ci.ClientId, SocialConnector.SoundCloud, key, val);
}
}
}
if (!string.IsNullOrEmpty(accessToken))
{
string userName = GetUserData(accessToken);
using (Database db = new MySqlDatabase())
{
UserInfo ui = db.GetUser(Util.UserId);
ClientInfo ci = db.GetClientInfo(ui.UserId);
db.UpdateSoundCloudId(ci.ClientId, userName);
}
}
}
示例12: Page_PreRender
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");
}
}
示例13: Page_Load
protected void Page_Load(object sender, EventArgs e)
{
string scope = Request.QueryString["scope"];
string access_token = Request.QueryString["access_token"];
if (!string.IsNullOrEmpty(access_token))
{
using (Database db = new MySqlDatabase())
{
UserInfo ui = db.GetUser(Util.UserId);
ClientInfo ci = db.GetClientInfo(ui.UserId);
db.UpdateSocialCredential(ci.ClientId, SocialConnector.SoundCloud, "access_token", access_token);
db.UpdateSocialCredential(ci.ClientId, SocialConnector.SoundCloud, "scope", scope);
db.UpdateSoundCloudId(ci.ClientId, GetUserData(access_token));
}
}
}
示例14: CouponCodeGoCommand
protected void CouponCodeGoCommand(object sender, CommandEventArgs e)
{
string couponCode = CouponCodeEdit.Text;
using (Database db = new MySqlDatabase())
{
ClientInfo ci = db.GetClientInfo(Util.UserId);
if (db.CheckActivationCode(couponCode))
{
// Code is ok, raise the number of credits for this user
db.MarkActivationCode(couponCode, Util.UserId);
Config cfg = new Config();
cfg.Load(Server.MapPath("~/Config/trackprotect.config"));
long prodid = 0;
if (cfg["activationcode.productid"] != null)
prodid = Convert.ToInt64(cfg["activationcode.productid"]);
// Get the credits from the database
ProductInfo pi = db.GetProductById(prodid);
if (pi != null && pi.ProductId > 0)
{
// How many credits to issue
string transactionIdCoupon = string.Format("COUPON {0}", couponCode);
long orderId = db.CreateTransaction(Util.UserId, 0m, prodid, pi.Description);
db.UpdateTransaction(orderId.ToString(), "OK", "OK", "Payment Completed", "COUPON", couponCode, couponCode, transactionIdCoupon, "COUPON", 0m, pi, "EUR", Util.GetCountryIso2(ci.Country));
db.UpdateUserCredits(Util.UserId, prodid, pi.Credits);
db.AddCreditHistory(Util.UserId, prodid, pi.Credits, orderId);
Response.Redirect(string.Format("~/Member/CouponSuccess.aspx?cradd={0}", pi.Credits), false);
}
}
else
{
Response.Redirect(string.Format("~/Member/CouponFailure.aspx?couponcode={0}", couponCode), false);
}
}
}
示例15: ddlManagedArtist_SelectedIndexChanged
protected void ddlManagedArtist_SelectedIndexChanged(object sender, EventArgs e)
{
Session["managed.userid"] = ((DropDownList)sender).SelectedValue;
if (Convert.ToInt32(Session["managed.userid"]) > 0)
using (Database db = new MySqlDatabase())
{
ClientInfo _ManagedUserInfo = db.GetClientInfo(Convert.ToInt64(Session["managed.userid"]));
PopulateSocialMediaInfo(db);
Session["ManagedUser"] = _ManagedUserInfo.FirstName;
}
}