public void GetAndDisplayScores()
{
ListScores.Clear();
ComponentName = ViewModelLocator.SelectedSubjectViewModel.SelectedActivity.Activity;
SqlConnection con = GeneralMethods.ConnectToDatabase();
SqlDataAdapter sda2 = new SqlDataAdapter("SELECT * From [SCORE] WHERE ActivityID='" + ViewModelLocator.SelectedSubjectViewModel.SelectedActivity.ActivityID + "'", con);
DataTable dt = new DataTable();
sda2.Fill(dt);
con.Close();
for (int x = 0; x < dt.Rows.Count; x++)
{
SCORE newScore = new SCORE();
newScore.Date = Convert.ToDateTime(dt.Rows[x]["Date"]);
newScore.Score = Convert.ToInt16(dt.Rows[x]["Score"]);
newScore.Items = Convert.ToInt16(dt.Rows[x]["Items"]);
newScore.ID = Convert.ToInt16(dt.Rows[x]["Id"]);
ListScores.Add(newScore);
}
ComputeTotalItemsAndScore();
ComputeGrade();
if (ListScores.Count != 0)
{
ComputeConvertedGrade();
}
ViewModelLocator.SelectedSubjectViewModel.SelectedActivity.Grade = Grade;
}
void OnTriggerEnter(Collider trigger)
{
if (trigger.gameObject.tag == "Breakables")
{
SCORE.Increment();
Destroy(trigger.gameObject);
}
}
void OnTriggerEnter(Collider other)
{
if (other.tag == "Coin")
{
Destroy(other.gameObject);
}
SCORE sc = SC.GetComponent <SCORE>();
sc.FlagGet();
sc.ScoreUp();
Debug.Log("当たったよ！");
}
public void AddNewScore(SCORE newScore)
{
SqlConnection con = GeneralMethods.ConnectToDatabase();
SqlCommand command = new SqlCommand("INSERT INTO [SCORE] (Score, Items, Date, ActivityID) VALUES (@Score, @Items, @Date, @ActivityID)", con);
command.Parameters.AddWithValue("@Score", newScore.Score);
command.Parameters.AddWithValue("@Items", newScore.Items);
command.Parameters.AddWithValue("@Date", newScore.Date);
command.Parameters.AddWithValue("@ActivityID", ViewModelLocator.SelectedSubjectViewModel.SelectedActivity.ActivityID);
command.ExecuteNonQuery();
con.Close();
GetAndDisplayScores();
}
public void EditScore(SCORE changedScore)
{
SqlConnection con = GeneralMethods.ConnectToDatabase();
SqlCommand command = new SqlCommand("UPDATE [SCORE] SET Score=@Score, Items=@Items, Date=@Date WHERE Id=@Id", con);
command.Parameters.AddWithValue("@Score", changedScore.Score);
command.Parameters.AddWithValue("@Items", changedScore.Items);
command.Parameters.AddWithValue("@Date", changedScore.Date);
command.Parameters.AddWithValue("@Id", ViewModelLocator.ScoresListViewModel.SelectedScore.ID);
command.ExecuteNonQuery();
con.Close();
GetAndDisplayScores();
}
void OnTriggerEnter(Collider col)
{
if (col.gameObject.tag == "Coin")
{
CoinCount.Increment();
SCORE.Increment();
Destroy(col.gameObject);
}
if (col.gameObject.tag == "GOAL")
{
Debug.Log("CLEARED");
Destroy(col.gameObject);
}
}
public void insertScore(ArccView arccView)
{
ARCCDbContext db = new ARCCDbContext();
SCORE arccView2 = new SCORE();
db.Database.ExecuteSqlCommand("TRUNCATE TABLE [SCORE]");
for (int i = 0; i < arccView.scores.Count; i++)
{
if (arccView.scores[i].Proposal_Name != null)
{
db.scoreDB.Add(arccView.scores[i]);
}
}
db.SaveChanges();
}
void FixedUpdate()
{
//вывод сообщений
Gold_txt.text = "Gold :" + PlayerPrefs.GetInt("gold").ToString();
Score.text = "Score :" + SCORE.ToString();
//сохранение в фаил
if (SCORE > HighScore)
{
NewRecord = true;
HighScore = SCORE;
PlayerPrefs.SetInt("records", HighScore);
}
if (damage == 1 && shield > 0)
{
shield = shield - damage;
damage = 0;
}
if (shield == 0 && life > 0 && S > 0)
{
GetComponent <SpriteRenderer>().sprite = sprites[0];
shield_Hp++;
if (shield_Hp == 1000)
{
GetComponent <SpriteRenderer>().sprite = sprites[2];
shield_Hp = 0;
shield = 1;
}
}
if (damage == 1 && shield == 0)
{
life = life - damage;
damage = 0;
}
if (life == 0)
{
GetComponent <SpriteRenderer>().sprite = sprites[1];
lose = true;
Time.timeScale = 0f;
Objects[0].SetActive(true);
Objects[1].SetActive(false);
AudioDeath.Play();
}
}
void Awake()
{
if (S == null)
{
S = this; // Set the private singleton
}
else
{
Debug.LogError("ERROR: ScoreManager.Awake(): S is already set!");
}
// Check for a high score in PlayerPrefs
if (PlayerPrefs.HasKey("HeroHighScore"))
{
_HIGH_SCORE = PlayerPrefs.GetInt("HeroHighScore");
}
scoreText.text = "Score: " + SCORE.ToString();
highscoreText.text = "Highscore: " + _HIGH_SCORE.ToString();
}
private void BtnEdit_Click(object sender, RoutedEventArgs e)
{
if (ViewModelLocator.ScoresListViewModel.SelectedScore != null)
{
var window = new AddScoreWindow();
window.Owner = this;
window.WindowStartupLocation = WindowStartupLocation.CenterOwner;
SCORE changedScore = ViewModelLocator.ScoresListViewModel.SelectedScore as SCORE;
window.DataContext = changedScore;
var result = window.ShowDialog();
if (result == true)
{
ViewModelLocator.ScoresListViewModel.EditScore(changedScore);
ViewModelLocator.ScoresListViewModel.ComputeGrade();
ViewModelLocator.SelectedSubjectViewModel.SelectedActivity.Grade = ViewModelLocator.ScoresListViewModel.ComputeConvertedGrade();
}
}
}
private void BtnAddActivity_Click(object sender, RoutedEventArgs e)
{
var window = new AddScoreWindow();
window.Owner = this;
window.WindowStartupLocation = WindowStartupLocation.CenterOwner;
SCORE newScore = new SCORE();
newScore.Date = DateTime.Now;
window.DataContext = newScore;
var result = window.ShowDialog();
if (result == true)
{
ViewModelLocator.ScoresListViewModel.AddNewScore(newScore);
ViewModelLocator.ScoresListViewModel.ComputeGrade();
ViewModelLocator.SelectedSubjectViewModel.SelectedActivity.Grade = ViewModelLocator.ScoresListViewModel.ComputeConvertedGrade();
}
}
public void AddScore(SCORE score)
{
switch (score)
{
case SCORE.ENEMY_A:
_score += ( int )SCORE.ENEMY_A;
break;
case SCORE.ENEMY_B:
_score += ( int )SCORE.ENEMY_B;
break;
case SCORE.ENEMY_C:
_score += ( int )SCORE.ENEMY_C;
break;
default:
Assert.IsNotNull(null, "[ScoreManager]追加したいスコアタイプが存在しません");
break;
}
}
public static void SetPlayerInfo()
{
for (int count = 0; count < numOfPlayers; count++)
{
LIVES.Add(HotDAMN.INITIAL_LIVES_COUNT);
COINS.Add(0);
SCORE.Add(0);
worldNum.Add(HotDAMN.INITIAL_WORLD_NUMBER);
levelNum.Add(HotDAMN.INITIAL_LEVEL_NUMBER);
midpointHit.Add(false);
MARIO_STATE.Add(null);
firstLevelEntrance.Add(true);
if (count == 1)
{
playerName.Add("LUIGI");
}
else
{
playerName.Add("MARIO");
}
}
}
void AddPoints(int point)
{
_score += point;
scoreText.text = "Score: " + SCORE.ToString();
}
// Update is called once per frame
void Update()
{
SCORE sc = CB.GetComponent <SCORE>();
sc.ScoreUp();
}
