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);
}
}
protected void Login_Click(object sender, EventArgs e)
{
using (Database db = new MySqlDatabase())
{
if (db.AdminLoginAuthentication(Email.Text.Trim(), Password.Text.Trim()))
{
Session["AdminLogin"] = Email.Text.Trim();
Response.Redirect("ManagePages.aspx");
}
else
{
CustomValidator CustomValidatorCtrl = new CustomValidator();
CustomValidatorCtrl.IsValid = false;
CustomValidatorCtrl.ValidationGroup = "LoginUserValidationGroup";
CustomValidatorCtrl.ErrorMessage = "Login Failed !";
this.Page.Form.Controls.Add(CustomValidatorCtrl);
Session.Remove("AdminLogin");
}
}
}
public override DbCommand CreateCommand()
{
var db = new MySqlDatabase("");
var cm = db.CreateCommand();
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = this.GetStoredProcedureName();
DbParameter p = null;
p = db.CreateParameter("PK_IntColumn", MySqlDbType.Int32, 10, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Value = this.PK_IntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("PK_TimestampColumn", MySqlDbType.Timestamp, null, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.Input;
p.Value = this.PK_TimestampColumn;
cm.Parameters.Add(p);
for (int i = 0; i < cm.Parameters.Count; i++)
{
if (cm.Parameters[i].Value == null) cm.Parameters[i].Value = DBNull.Value;
}
return cm;
}
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)
{
}
}
public Token GenerateToken(string email, string name, string mobile, int passengers, decimal payableAmount, string refId, string reqId)
{
try
{
int tokenId;
var db = new MySqlDatabase(DbConfiguration.TokenDB);
var createDate = DateTime.Now;
var expiryDate = createDate.AddHours(48);
MySqlCommand cmd = CommandBuilder.BuildGenerateTokenCommand(db.Connection, email, name, mobile, passengers, payableAmount, createDate, expiryDate, refId, reqId);
db.ExecuteNonQuery(cmd, "outTokenId", out tokenId);
if (tokenId != 0)
return new Token
{
Id = tokenId.ToString(),
EmailId = email,
Name = name,
Mobile = mobile,
PassengersCount = passengers,
PayableAmount = payableAmount,
TokenCreationDate = createDate,
TokenExpirationDate = expiryDate,
PaymentReferenceId = refId,
RequestId = reqId
};
}
catch (Exception ex)
{
DBExceptionLogger.LogException(ex, Source, "GenerateToken", Severity.Critical);
return null;
}
return null;
}
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;
}
public Account CreateAccount(string email, string firstName, string lastName, string mobile, string hashPwd,
bool isEmailVerified = false)
{
try
{
int accountId;
var db = new MySqlDatabase(DbConfiguration.DatabaseWrite);
MySqlCommand cmd = CommandBuilder.BuildCreateAccountCommand(db.Connection, email, firstName, lastName,
mobile ?? "", hashPwd, isEmailVerified);
db.ExecuteNonQuery(cmd, "outaccountid", out accountId);
if (accountId != 0)
return new Account
{
AccountId = accountId.ToString(),
Email = email,
FirstName = firstName,
LastName = lastName,
Mobile = mobile,
IsEmailActivated = false,
IsMobileVerified = false,
IsEnabled = true
};
}
catch (Exception ex)
{
DBExceptionLogger.LogException(ex, Source, "CreateAccount", Severity.Critical);
return null;
}
return null;
}
protected void AcceptUser(object sender, CommandEventArgs e)
{
if (Session["mgmt.userid"] == null)
return;
int mgrVcl = 0, mgrEcl = 0;
Util.GetUserClearanceLevels(Util.UserId, out mgrVcl, out mgrEcl);
int vcl = 0, ecl = 0, tmp = 0;
if (int.TryParse(VclText.Text, out tmp))
vcl = tmp;
if (int.TryParse(EclText.Text, out tmp))
ecl = tmp;
// Rights entered may not be higher then the rights of the manager
if (vcl <= mgrVcl && ecl <= mgrEcl)
{
long userIdToManage = (long)Session["mgmt.userid"];
using (Database db = new MySqlDatabase())
{
db.RegisterUserRights(userIdToManage, vcl, ecl);
Session.Remove("mgmt.userid");
ManagerNameLabel.Text = string.Empty;
}
UpdateManagerTable();
}
else
{
ResultMessage.Text = Resources.Resource.UserRightsTooHigh;
}
}
private static void HandleConnectionError(MySqlDatabase db, Exception ex, int? tryCount) {
if(log.IsErrorEnabled) {
log.Error("Database Connection 생성 및 Open 수행 시에 예외가 발생했습니다. ConnectionString=[{0}]", db.ConnectionString);
log.Error(ex);
}
var timeout = Math.Min(MaxTimeout, Math.Abs(tryCount.GetValueOrDefault(1)) * 50);
Thread.Sleep(timeout);
}
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);
}
}
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();
}
}
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>");
}
}
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";
}
}
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);
}
}
protected void ArtistsTable_RowCommand(object sender, GridViewCommandEventArgs e)
{
int rowIndex = Convert.ToInt32(e.CommandArgument);
// Retrieve the row that contains the button
// from the Rows collection.
GridViewRow row = ArtistsTable.Rows[rowIndex];
HiddenField hfd = row.FindControl("HiddenFieldUserId") as HiddenField;
switch (e.CommandName)
{
case "DeleteUser":
if (hfd != null)
{
long targetId = 0;
if (!long.TryParse(hfd.Value, out targetId))
targetId = 0;
if (targetId > 0)
{
long sourceId = Util.UserId;
using (Database db = new MySqlDatabase())
{
db.DeleteRelation(sourceId, targetId, 1);
}
}
}
break;
case "RelateUser":
if (hfd != null)
{
long targetId = 0;
if (!long.TryParse(hfd.Value, out targetId))
targetId = 0;
if (targetId > 0)
{
long sourceId = Util.UserId;
using (Database db = new MySqlDatabase())
{
UserInfo targetUi = db.GetUser(targetId);
ClientInfo targetCI = db.GetClientInfo(targetId);
RequestConfirmation(targetUi.Email, 1, targetCI.FirstName, targetCI.LastName);
}
}
}
break;
}
FillManagedRelationsTable();
}
public void UpdateVoucherCount(string voucherCode)
{
try
{
var db = new MySqlDatabase(DbConfiguration.DatabaseRead);
MySqlCommand command = CommandBuilder.BuildUpdateVoucherCommand(voucherCode, db.Connection);
db.ExecuteNonQuery(command);
}
catch (Exception ex)
{
DBExceptionLogger.LogException(ex, Source, "GetPaymentProviderDetails", Severity.Critical);
}
}
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);
}
}
public bool ChangeMobile(string accountId, string mobile)
{
try
{
var db = new MySqlDatabase(DbConfiguration.DatabaseWrite);
int result;
db.ExecuteNonQuery(CommandBuilder.BuildChangeMobileCommand(accountId, mobile, db.Connection), "result",
out result);
return result == 1;
}
catch (Exception ex)
{
DBExceptionLogger.LogException(ex, Source, "ChangeMobile", Severity.Critical);
return false;
}
}
protected void AddSubGenre_Click(object sender, EventArgs e)
{
using (Database db = new MySqlDatabase())
{
db.AddSubGenre(addSubGenreText.Text.Trim(), Convert.ToInt32(ViewState["GenreID"]));
SubGenreList.DataSource = db.getSubGenreList(Convert.ToInt32(ViewState["GenreID"]));
SubGenreList.DataTextField = "Value";
SubGenreList.DataValueField = "Key";
SubGenreList.DataBind();
SubGenreList.Items.Insert(0, new ListItem("--Select--", "Select"));
SubGenreList.Items.Insert(1, new ListItem("--Add New Sub Genre--", "Add"));
GenreList.SelectedValue = Convert.ToString(ViewState["GenreID"]);
}
divAddSubGenre.Visible = false;
}
public List<SupplierInfo> GetSuppliers(string mode)
{
try
{
var db = new MySqlDatabase(DbConfiguration.DatabaseRead);
MySqlCommand command = CommandBuilder.BuildGetSuppliersCommand(mode, db.Connection);
DataSet dataSet = db.ExecuteQuery(command);
return GetSuppliers(dataSet);
}
catch (Exception ex)
{
DBExceptionLogger.LogException(ex, Source, "GetSuppliers", Severity.Critical);
return null;
}
}
public Voucher GetVoucher(string voucherCode)
{
try
{
var db = new MySqlDatabase(DbConfiguration.DatabaseRead);
MySqlCommand command = CommandBuilder.BuildGetVoucherCommand(voucherCode, db.Connection);
DataSet dataSet = db.ExecuteQuery(command);
return GetVoucher(dataSet);
}
catch (Exception ex)
{
DBExceptionLogger.LogException(ex, Source, "GetPaymentProviderDetails", Severity.Critical);
return null;
}
}
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);
}
}
}
public List<FlightRequest> GetFlightRequests()
{
List<FlightRequest> flightRequests = new List<FlightRequest>();
var db = new MySqlDatabase(DbConfiguration.DatabaseRead);
try
{
DataSet dataset = db.ExecuteQuery(CommandBuilder.BuildGetFlightRequestCommand(db.Connection));
if (dataset != null && dataset.Tables.Count > 0)
{
if (dataset.Tables[0].Rows != null && dataset.Tables[0].Rows.Count > 0)
{
foreach (DataRow row in dataset.Tables[0].Rows)
{
if (!Convert.IsDBNull(row["RequestId"]))
{
var request = new FlightRequest()
{
RequestId = row["RequestId"].GetString(),
FriendlyRequestId = row["FriendlyRequestId"].GetString(),
RequestAddDate = row["AddDate"].GetDate(),
FirstName = row["FirstName"].GetString(),
LastName = row["LastName"].GetString(),
FromAirportName = row["FromAirportName"].GetString(),
ToAirportName = row["ToAirportName"].GetString(),
TravelDate = row["TravelDate"].GetDate(),
RequesterBidAmount = row["BidAmount"].GetDecimal(),
AirlineBidAmount = row["AirlineBidAmount"].GetDecimal(),
TrainPnr = row["TrainPnr"].GetString(),
PaxCount = row["PaxCount"].GetInt(),
ProcessedDate = DateTime.Now
};
flightRequests.Add(request);
}
}
}
}
}
catch (Exception ex)
{
DBExceptionLogger.LogException(ex, Source, "GetFlightRequests", Severity.Critical);
throw ex;
}
return flightRequests;
}
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);
}
private void FillQuotationsList()
{
QuotationsList.Rows.Clear();
using (Database db = new MySqlDatabase())
{
DataTable temp = db.GetAllOpenQuotations();
foreach (DataRow row in temp.Rows)
{
DataRow newRow = QuotationsList.NewRow();
newRow["date"] = row["date"];
newRow["email"] = row["email"];
newRow["amount"] = row["amount"];
string statuscode = row["statuscode"] as string;
int credits = 0;
if (statuscode.StartsWith("RFQ"))
{
int pos = statuscode.IndexOf('(');
if (pos > -1)
statuscode = statuscode.Substring(pos);
pos = statuscode.IndexOf(')');
if (pos > -1)
statuscode = statuscode.Substring(0, pos);
string[] parts = statuscode.Split(':');
if (parts.Length == 2)
{
if (!int.TryParse(parts[1], out credits))
credits = 0;
}
}
newRow["credits"] = credits;
newRow["transaction_id"] = row["transaction_id"];
newRow["user_id"] = row["user_id"];
QuotationsList.Rows.Add(newRow);
}
}
DataView dataView = new DataView(QuotationsList);
quotationsList.DataSource = dataView;
quotationsList.DataBind();
}
public SupplierInfo GetSupplier(string provider, string mode)
{
try
{
var db = new MySqlDatabase(DbConfiguration.DatabaseRead);
MySqlCommand command = CommandBuilder.BuildGetSupplierCommand(provider, mode, db.Connection);
DataSet dataSet = db.ExecuteQuery(command);
var suppliers = GetSuppliers(dataSet);
if (suppliers != null && suppliers.Count > 0)
return suppliers[0];
}
catch (Exception ex)
{
DBExceptionLogger.LogException(ex, Source, "GetSuppliers", Severity.Critical);
}
return null;
}
public SalesSummary GetSalesSummary(string fromAirport, string toAirport, string airlineCode, DateTime date)
{
try
{
var db = new MySqlDatabase(DbConfiguration.DatabaseRead);
MySqlCommand command = CommandBuilder.BuildGetSalesSummaryCommand(fromAirport, toAirport, airlineCode,
date, db.Connection);
DataSet dataSet = db.ExecuteQuery(command);
SalesSummary salesSummary = GetSalesSummary(dataSet);
return salesSummary;
}
catch (Exception ex)
{
DBExceptionLogger.LogException(ex, Source, "GetSalesSummary", Severity.Critical);
return null;
}
}
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 AddGenre_Click(object sender, EventArgs e)
{
GenreList.DataSource = null;
GenreList.DataBind();
using (Database db = new MySqlDatabase())
{
db.AddGenre(addGenreText.Text.Trim());
GenreList.DataSource = db.getGenreList();
GenreList.DataTextField = "Value";
GenreList.DataValueField = "Key";
GenreList.DataBind();
GenreList.Items.Insert(0, new ListItem("--Select--", "Select"));
GenreList.Items.Insert(1, new ListItem("--Add New Genre--", "Add"));
}
EditGenre.Visible = false;
divAddGenre.Visible = false;
divDeleteGenre.Visible = false;
divSubGenre.Visible = false;
}
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));
}
}
}
public async Task TestDynamic()
{
var database = new MySqlDatabase("Server=127.0.0.1;Uid=test;Pwd=test!123;Database=butterfly_db_test");
await DynamicUnitTest.TestDatabase(database);
}
public TalentController(MySqlDatabase mySqlDatabase)
{
this.MySqlDatabase = mySqlDatabase;
}
public StoreController(MySqlDatabase mySqlDb)
{
this.MySqlDatabase = mySqlDb;
}
public void Create(CreateAccountPostData data)
{
MySqlDatabase.ExecuteNoneQuery($"insert into accounts(username, password, email, authKey) values ('{data.Username}','{data.Password}','{data.Email}','{Hash.Sha256(data.Username + data.Password)}')");
}
public static MySqlConnection CreateMySqlConnection(this MySqlDatabase db, ref bool newConnectionCreated)
{
return((MySqlConnection)AdoTool.CreateTransactionScopeConnection(db,
ref newConnectionCreated,
database => ((MySqlDatabase)database).OpenConnection(15)));
}
private static Database CreateDB(string connKey)
{
if (string.IsNullOrEmpty(connKey))
{
LogHelper.Logger.Error($"没有找到配置文件中的[{connKey}]节点.");
return(null);
}
if (_dbDatabases.ContainsKey(connKey) == true)
{
return(_dbDatabases[connKey]);
}
try
{
Database dbTmp = null;
dbTmp = DatabaseFactory.CreateDatabase(connKey);
try
{
string strConnstring = dbTmp.ConnectionString;
string noProviderStr = strConnstring;
if (_providerRex.Match(strConnstring).Value.Length > 0)
{
noProviderStr = strConnstring.Replace(_providerRex.Match(strConnstring).Value, "");
}
if (dbTmp.DbProviderFactory is System.Data.OleDb.OleDbFactory)
{
var dbOledb = new OledbDatabase(strConnstring);
LogHelper.Logger.Info("数据库对象创建成功（OLEDB）");
_dbDatabases.Add(connKey, dbOledb);
return(dbOledb);
}
else if (dbTmp.DbProviderFactory is System.Data.OracleClient.OracleClientFactory)
{
var dbOracle = new OracleDatabase(noProviderStr);
LogHelper.Logger.Info("数据库对象创建成功（Oracle）");
_dbDatabases.Add(connKey, dbOracle);
return(dbOracle);
}
else if (dbTmp.DbProviderFactory is MySql.Data.MySqlClient.MySqlClientFactory)
{
var dbMySql = new MySqlDatabase(noProviderStr);
LogHelper.Logger.Info("数据库对象创建成功（MySQL）");
_dbDatabases.Add(connKey, dbMySql);
return(dbMySql);
}
else
{
var dbLocal = new SqlDatabase(noProviderStr);
LogHelper.Logger.Info("数据库对象创建成功（默认SQLServer）");
_dbDatabases.Add(connKey, dbLocal);
return(dbLocal);
}
}
catch (Exception ex)
{
LogHelper.Logger.Error(ex, "创建数据库失败.");
}
}
catch (Exception ex)
{
LogHelper.Logger.Error(ex, "创建数据库失败.");
}
return(null);
}
public AuctionController(ILogger <AuctionController> logger, MySqlDatabase database)
{
_logger = logger;
_database = database;
}
public async Task <IActionResult> showFlights(Destination sd, Destination ed, Boolean transfers)
{
FlightListModel flights = await MySqlDatabase.FilterFlights(sd, ed, transfers);
return(View("Index", flights));
}
public UpdateExpenseDetailsCommandHandler(MySqlDatabase database)
{
this.database = database;
}
public GetSettlementByIdQueryHandler(MySqlDatabase database)
{
this.database = database;
}
public CustomUserController(MySqlDatabase mySqlDatabase, IHubContext <FlightsHub> hubcontext)
{
this.MySqlDatabase = mySqlDatabase;
this.HubContext = hubcontext;
}
public GetExpensesByStatusQueryHandler(MySqlDatabase database)
{
this.database = database;
}
// Gán giá trị cho Mysql
public UserController(MySqlDatabase mySqlDb, IWebHostEnvironment hostEnvironment)
{
this.MySqlDatabase = mySqlDb;
this._hostEnvironment = hostEnvironment;
}
public override DbCommand CreateCommand()
{
var db = new MySqlDatabase("");
var cm = db.CreateCommand();
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = this.GetStoredProcedureName();
DbParameter p = null;
p = db.CreateParameter("CharColumn", MySqlDbType.String, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.CharColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("NCharColumn", MySqlDbType.String, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.NCharColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("VarCharColumn", MySqlDbType.VarChar, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.VarCharColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("NVarCharColumn", MySqlDbType.VarChar, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.NVarCharColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BitColumn", MySqlDbType.Bit, 1, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.BitColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TinyIntColumn", MySqlDbType.Byte, 3, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.TinyIntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("SmallIntColumn", MySqlDbType.Int16, 5, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.SmallIntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("MediumIntColumn", MySqlDbType.Int24, 7, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.MediumIntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("IntColumn", MySqlDbType.Int32, 10, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.IntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BigIntColumn", MySqlDbType.Int64, 19, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.BigIntColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TinyIntUnsignedColumn", MySqlDbType.UByte, 3, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.TinyIntUnsignedColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("SmallIntUnsignedColumn", MySqlDbType.UInt16, 5, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.SmallIntUnsignedColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("MediumIntUnsignedColumn", MySqlDbType.UInt24, 7, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.MediumIntUnsignedColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("IntUnsignedColumn", MySqlDbType.UInt32, 10, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.IntUnsignedColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BigIntUnsignedColumn", MySqlDbType.UInt64, 20, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.BigIntUnsignedColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("FloatColumn", MySqlDbType.Float, 8, 4);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.FloatColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("DoubleColumn", MySqlDbType.Double, 9, 5);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.DoubleColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("DecimalColumn", MySqlDbType.Decimal, 10, 5);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.DecimalColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("NumericColumn", MySqlDbType.Decimal, 10, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.NumericColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("DateColumn", MySqlDbType.Date, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.DateColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("DateTimeColumn", MySqlDbType.DateTime, null, 5);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.DateTimeColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TimeColumn", MySqlDbType.Time, null, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.TimeColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("YearColumn", MySqlDbType.Year, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.YearColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BinaryColumn", MySqlDbType.Binary, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.BinaryColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("VarBinaryColumn", MySqlDbType.VarBinary, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 100;
p.Value = this.VarBinaryColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TinyBlobColumn", MySqlDbType.TinyBlob, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 255;
p.Value = this.TinyBlobColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("MediumBlobColumn", MySqlDbType.MediumBlob, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 16777215;
p.Value = this.MediumBlobColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("BlobColumn", MySqlDbType.Blob, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 65535;
p.Value = this.BlobColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("LongBlobColumn", MySqlDbType.LongBlob, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 2147483647;
p.Value = this.LongBlobColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TinyTextColumn", MySqlDbType.TinyText, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 255;
p.Value = this.TinyTextColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TextColumn", MySqlDbType.Text, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 65535;
p.Value = this.TextColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("MediumTextColumn", MySqlDbType.MediumText, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 16777215;
p.Value = this.MediumTextColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("LongTextColumn", MySqlDbType.LongText, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 2147483647;
p.Value = this.LongTextColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("TimestampColumn", MySqlDbType.Timestamp, null, 0);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Value = this.TimestampColumn;
cm.Parameters.Add(p);
p = db.CreateParameter("EnumColumn", MySqlDbType.Enum, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 7;
p.Value = this.EnumColumn.ToStringFromEnum();
cm.Parameters.Add(p);
p = db.CreateParameter("SetColumn", MySqlDbType.Set, null, null);
p.SourceColumn = p.ParameterName;
p.Direction = ParameterDirection.InputOutput;
p.Size = 20;
p.Value = this.SetColumn.ToStringFromEnum();
cm.Parameters.Add(p);
for (int i = 0; i < cm.Parameters.Count; i++)
{
if (cm.Parameters[i].Value == null)
{
cm.Parameters[i].Value = DBNull.Value;
}
}
return(cm);
}
static void Main(string[] args)
{
string errmsg = "";
string fname;
string[] stuff = new string[20];
string[] parts = new string[20];
int choice;
string tableName = "";
string Title;
int i = 0;
string[] title, platform, company, year;
title = new string[20];
platform = new string[20];
company = new string[20];
year = new string[20];
List <string>[] results;
MySqlDatabase mysql = new MySqlDatabase();
GamesDBQuery dbq = new GamesDBQuery();
do
{
choice = showMenu();
switch (choice)
{
case 1:
Console.WriteLine();
Console.WriteLine("Enter the title: ");
title[i] = Console.ReadLine();
Console.WriteLine("Enter the platform: ");
platform[i] = Console.ReadLine();
Console.WriteLine("Enter the company name: ");
company[i] = Console.ReadLine();
Console.WriteLine("Enter the year released: ");
year[i] = Console.ReadLine();
i++;
Console.WriteLine();
break;
case 2:
Console.WriteLine();
Console.WriteLine("Enter title of video game to delete: ");
Title = Console.ReadLine();
for (int j = 0; j < title.Length; j++)
{
if (title[j] == Title)
{
title[j] = null;
platform[j] = null;
company[j] = null;
year[j] = null;
}
}
Console.WriteLine();
break;
case 3:
Console.WriteLine();
for (int j = 0; j < title.Length; j++)
{
if (title[j] != null && title[j] != "")
{
Console.WriteLine(title[j] + ", " + platform[j] + ", " + company[j] + ", " + year[j]);
}
}
Console.WriteLine();
break;
case 4:
Console.WriteLine("Enter file name to save to.");
fname = Console.ReadLine();
Serializer.SaveToBinary(title, platform, company, year, fname);
break;
case 5:
Console.WriteLine();
Console.WriteLine("Enter file name to read from.");
fname = Console.ReadLine();
stuff = Serializer.LoadFromBinary(fname);
if (stuff != null)
{
for (int j = 0; j < stuff.Length; j++)
{
parts = stuff[j].Split(' ');
if (parts[0] != "")
{
title[j] = parts[0];
platform[j] = parts[1];
company[j] = parts[2];
year[j] = parts[3];
i++;
}
}
}
Console.WriteLine();
break;
case 6:
Console.WriteLine();
Console.Write("Enter the name of the database server: ");
host = Console.ReadLine();
Console.Write("Enter the name of the database on server {0}: ", host);
db = Console.ReadLine();
Console.Write("Enter the user name for database {0}: ", host);
user = Console.ReadLine();
Console.Write("Enter the password for database {0}: ", host);
pass = Console.ReadLine();
dbq = new GamesDBQuery(host, db, user, pass);
if (dbq.OpenConnection(ref errmsg))
{
Console.WriteLine();
Console.WriteLine("Connection to {0}.{1} successful!", host, db);
Console.WriteLine();
}
else
{
Console.WriteLine();
Console.WriteLine("Error: " + errmsg);
Console.WriteLine();
}
break;
case 7:
Console.WriteLine();
Console.WriteLine("The current database is {0}.{1}.", host, db);
Console.Write("Enter name of table you want to add to: ");
tableName = Console.ReadLine();
for (int j = 0; j < title.Length; j++)
{
if (title[j] != null && title[j] != "")
{
dbq.InsertGame(tableName, title[j], platform[j], year[j], company[j], ref errmsg);
}
}
Console.WriteLine();
break;
case 8:
Console.WriteLine();
Console.WriteLine("The current database is {0}.{1}.", host, db);
Console.Write("Enter name of table you want to read from: ");
tableName = Console.ReadLine();
results = dbq.SelectAsStrings("select * from " + tableName, ref errmsg);
if (results != null)
{
Console.WriteLine();
Console.WriteLine("Your video game collection was successfully loaded.");
Console.WriteLine();
DBOutput.WriteTabulatedData(results);
Console.WriteLine();
}
else
{
Console.WriteLine();
Console.WriteLine("An error occured " + errmsg);
Console.WriteLine();
}
break;
case 9:
Console.WriteLine();
Console.Write("Enter name of table you want to read from: ");
tableName = Console.ReadLine();
Console.Write("Enter the Title of the Video Game to find: ");
Title = Console.ReadLine();
results = dbq.SelectAsStrings("select * from " + tableName + " where Title='" + Title + "';", ref errmsg);
if (results != null)
{
Console.WriteLine();
DBOutput.WriteTabulatedData(results);
Console.WriteLine();
}
else
{
Console.WriteLine();
Console.WriteLine("An error occured " + errmsg);
Console.WriteLine();
}
break;
}
} while (choice != 10);
}
public void TestMethod_ConnectionString()
{
string value = MySqlDatabase.ConnectionString(Settings.MySQLDatabase.HOSTNAME, Settings.MySQLDatabase.UID, Settings.MySQLDatabase.PWD, Settings.MySQLDatabase.Database, out _errOut);
General.HasValue(value, _errOut);
}
public StatsSynchroniser()
{
_mySqlDatabase = new MySqlDatabase();
_sqliteDatabase = new SqliteDatabase(true);
_useGlobal = true;
}
public PetsController(MySqlDatabase mySqlDatabase)
{
this.MySqlDatabase = mySqlDatabase;
}
static void Main(string[] args)
{
Console.Write(typeof(string).Assembly.ImageRuntimeVersion);
Console.ReadKey();
////////////// LOGGER ////////////////////
/************ CONSOLE *******************/
// 1. Get a LoggerManager
LoggerManager loggerManager = new LoggerManager();
//// 2. Create a new Logger
ILogger myLogger = loggerManager.CreateLogger();
////3. Log
myLogger.Log("Hello World !");
/************ CONSOLE with custom log pattern *******************/
////////////// TESTS 1 ////////////////////
ILogger myLogger2 = loggerManager.CreateLogger("testLogger");
string myPattern = LogElements.LOGGER_NAME.StrRef() + " / " + LogElements.MESSAGE.StrRef() + " / " + LogElements.TIMESTAMP.StrRef();
ConsoleAppender myConsoleApp = (ConsoleAppender)myLogger2.AddAppender(AppenderType.CONSOLE);
myConsoleApp.Layout = myPattern;
myLogger2.Error("Salut les gens ;)");
////////////// TESTS 2 ////////////////////
/************ Not log if log level lower than logger level *******************/
ILogger myLogger3 = loggerManager.CreateLogger("testLogger3");
myLogger3.Level = Level.ERROR;
myLogger3.Trace("Un nouveau log"); // doesn't log
////////////// TESTS 3 ////////////////////
/************ Duplicate Log **************/
ILogger myLogger4 = loggerManager.CreateLogger("testLogger4");
myLogger4.Level = Level.DEBUG;
myLogger4.Warn("Un warn log");
ILogger myLogger4_2 = loggerManager.DuplicateLogger("testLogger4");
myLogger4_2.Warn("Un warn log dupliqué");
//string myLogger4Name = myLogger4.Name;
//string myLogger4Parent = myLogger4.Parent;
//Console.WriteLine(myLogger4Name);
//Console.WriteLine("Parent : " + myLogger4Parent);
//string myLogger4_2Name = myLogger4_2.Name;
//string myLogger4_2Parent = myLogger4_2.Parent;
//Console.WriteLine(myLogger4_2Name);
//Console.WriteLine("Parent : " + myLogger4_2Parent);
////////////// TESTS 5 ////////////////////
/************ MESSAGE BOX **************/
ILogger myLogger5 = loggerManager.CreateLogger("testLogger5");
MessageBoxAppender myConsoleApp5 = (MessageBoxAppender)myLogger5.AddAppender(AppenderType.MESSAGE_BOX);
ModalBox myBox = new ModalBox(LogElements.LOGGER_NAME.StrRef());
myConsoleApp5.Box = myBox;
myLogger5.Warn("Bonjour !");
////////////// TESTS 6 ////////////////////
/************ MESSAGE BOX **************/
ILogger myLogger6 = loggerManager.CreateLogger("testLogger6");
MessageBoxAppender myConsoleApp6 = (MessageBoxAppender)myLogger6.AddAppender(AppenderType.MESSAGE_BOX);
string captionPattern = LogElements.TIMESTAMP.StrRef() + " - " + LogElements.LEVEL.StrRef();
ModalBox myBox2 = new ModalBox(captionPattern, MessageBoxIcon.Error);
myBox2.Buttons = MessageBoxButtons.OKCancel;
myBox2.SetAction(DialogResult.OK, () => Console.WriteLine("Anne"));
myConsoleApp6.Box = myBox2;
myLogger6.Error("Bonjour !");
//myLogger6.Trace("Bonjour Trace !");
//myLogger6.Debug("Bonjour Debug !");
//myLogger6.Info("Bonjour info !");
//myLogger6.Warn("Bonjour warn !");
////////////// TESTS 7 ////////////////////
/************ TOAST **************/
ToastAppender mytoastApp6 = (ToastAppender)myLogger6.AddAppender(AppenderType.TOAST);
string ligne1 = LogElements.TIMESTAMP.StrRef("T") + " - " + LogElements.LOGGER_NAME.StrRef();
string ligne2 = LogElements.MESSAGE.StrRef();
ToastLayout toastLay = new ToastLayout(ligne1, ligne2);
mytoastApp6.ToastLayout = toastLay;
myLogger6.Error("Bonjour Bonjour!");
myLogger6.Error("Bonjour Hello!");
////////////// TESTS 8 ////////////////////
/************ DATABASE **************/
// Database information
MySqlDatabase dbSettings = DatabaseFactory.MySqlDb.Set
.DatabaseName("logDb")
.Server("localhost")
.UserId("root").ToMySqlDatabase;
// Create a logger
ILogger myLog = loggerManager.CreateLogger("myLog");
// Create a database Appender (correspond à une base de donnée)
DataBaseAppender myDbApp = (DataBaseAppender)myLog.AddAppender(AppenderType.DATABASE);
myDbApp.AttachDB(dbSettings);
myLog.Error("Game Modeler !");
////////////// TESTS 8 ////////////////////
/************ MESSAGE_BOX_CUSTOM with Xaml file **************/
// Create a logger
ILogger myLogger7 = loggerManager.CreateLogger("testLogger7");
// Create a database Appender (correspond à une base de donnée)
IAppender myMBCApp = myLogger7.AddAppender(AppenderType.MESSAGE_BOX_CUSTOM, typeof(MessageBoxCustom));
myLogger7.Error("Game Modeler !");
myLogger7.Error("Game Modeler 2!");
////////////// TESTS 9 ////////////////////
/************ FILE APPENDER **************/
var myFileApp = (FileAppender)myLogger7.AddAppender(AppenderType.FILE);
myFileApp.Set.Name("testLoggerXml")
.Path(@"C:\Users\")
.Type(FileAppenderType.TEXT);
myLogger7.Error("test du logger");
myLogger7.Info("deuxième log");
}
public ProductController(MySqlDatabase mySqlDatabase)
{
this.MySqlDatabase = mySqlDatabase;
}
public GetAllExpensesQueryHandler(MySqlDatabase database)
{
this.database = database;
}
/// <summary>
/// 创建一个数据提供程序实例
/// </summary>
/// <param name="connectionStringName"></param>
/// <returns></returns>
public static Database Create(string connectionStringName)
{
CheckUtil.ArgumentNotNullOrEmpty(connectionStringName, "connectionStringName");
ConnectionStringSettings css = ConfigurationManager.ConnectionStrings[connectionStringName];
if (css == null)
{
throw new Exception(string.Format(Resources.Data.ConnectionStringNameNotFound, connectionStringName));
}
string connectionString = css.ConnectionString;
string providerName = css.ProviderName;
Database db = new SqlServerDatabase(connectionString);
DbProviderFactory providerFactory = null;
if (string.IsNullOrEmpty(providerName))
{
return(db);
}
//if (css.ProviderName == "System.Data.OleDb")
//{
// providerFactory = OleDbFactory.Instance;
//}
//else
//{
// providerFactory = DbProviderFactories.GetFactory(css.ProviderName);
//}
//if (providerFactory == null) throw new Exception(string.Format(Resources.Data.DataProviderNotFound, css.ProviderName));
switch (providerName)
{
//case "System.Data.SqlClient":
// break;
case "System.Data.Odbc":
db = new OdbcDatabase(connectionString);
break;
case "System.Data.OleDb":
db = new OleDbDatabase(connectionString);
break;
case "System.Data.OracleClient":
db = new OracleDatabase(connectionString);
break;
case "Oracle.ManagedDataAccess.Client":
db = new OracleDatabase(connectionString);
break;
case "Devart.Data.Oracle": //http://evget.com/zh-CN/product/954/feature.aspx http://www.devart.com/
case "DDTek.Oracle": //http://www.datadirect.com/index.html
providerFactory = DbProviderFactories.GetFactory(providerName);
db = new OracleDatabase(connectionString, providerFactory);
break;
case "System.Data.SQLite":
providerFactory = DbProviderFactories.GetFactory(providerName);
db = new SQLiteDatabase(connectionString, providerFactory);
break;
case "MySql.Data.MySqlClient":
providerFactory = DbProviderFactories.GetFactory(providerName);
db = new MySqlDatabase(connectionString, providerFactory);
break;
case "IBM.Data.DB2":
providerFactory = DbProviderFactories.GetFactory(providerName);
db = new DB2Database(connectionString, providerFactory);
break;
case "FirebirdSql.Data.FirebirdClient":
providerFactory = DbProviderFactories.GetFactory(providerName);
db = new FirebirdDatabase(connectionString, providerFactory);
break;
default:
break;
}
return(db);
}
void Start()
{
sb = new StringBuilder();
sb.AppendLine("<html><head><style>h1 { line-height:160%; font-size: 20pt; } h2 { line-height:160%; font-size: 14pt; } body { font-family: \"Segoe UI\", Arial; line-height: 150%; } table { border: 1px solid #5C5C5C; border-collapse: collapse; } td { font-size: 10pt; padding: 4px; border: 1px solid #5C5C5C; } .code { font-family: \"Courier New\"; font-size: 10pt; line-height:110%; } </style></head>");
sb.AppendLine("<body>");
using (MySqlConnection conn = new MySqlConnection(Program.ConnectionString))
{
try
{
conn.Open();
cmd = new MySqlCommand();
cmd.Connection = conn;
myDatabase = new MySqlDatabase();
myDatabase.GetDatabaseInfo(cmd, GetTotalRowsMethod.InformationSchema);
myServer = new MySqlServer();
myServer.GetServerInfo(cmd);
int stage = 1;
while (stage < 13)
{
try
{
switch (stage)
{
case 1: LoadDatabase(); break;
case 2: LoadUser(); break;
case 3: LoadGlobalPrivilege(); break;
case 4: LoadViewPrivilege(); break;
case 5: LoadFunctionPrivilege(); break;
case 6: LoadVariables(); break;
case 7: LoadTables(); break;
case 8: LoadFunctions(); break;
case 9: LoadProcedures(); break;
case 10: LoadTriggers(); break;
case 11: LoadViews(); break;
case 12: LoadEvents(); break;
default: break;
}
}
catch (Exception ex)
{
WriteError(ex.Message);
}
stage += 1;
}
conn.Close();
}
catch (Exception exCon)
{
WriteError(exCon.Message);
}
}
sb.Append("</body>");
sb.Append("</html>");
}
public HomeController(MySqlDatabase mySqlDatabase)
{
this.MySqlDatabase = mySqlDatabase;
}
public MysqlController(MySqlDatabase mySqlDatabase)
{
_mySqlDatabase = mySqlDatabase;
}
public GetExpenseByIdQueryHandler(MySqlDatabase database)
{
this.database = database;
}
public BeerController(MySqlDatabase db)
{
this.db = db.Connection.CreateCommand() as MySqlCommand;
}
public AddReconciliationCommandHandler(MySqlDatabase database)
{
this.database = database;
}
public NewsController(ILogger <NewsController> logger, MySqlDatabase database)
{
_logger = logger;
_database = database;
}
public UpdateSettlementStatusCommandHandler(MySqlDatabase database)
{
this.database = database;
}
