public static void LoadAwards(String userName) { currentPlayerAwards = MakeNewData(); AwardsData data; // Get the path of the saved game string fullpath; #if WINDOWS fullpath = Path.Combine(Path.Combine(Path.Combine(Path.Combine( Environment.GetFolderPath(Environment.SpecialFolder.MyDocuments), "My Games"), "SHMUP"), "SaveGames"), userName + ".awd"); #elif XBOX fullpath = Path.Combine(HighScoreManager.container.Path, userName + ".awd"); #endif if (!File.Exists(fullpath)) { data = MakeNewData(); MessageManager.newMessage(Strings.NewAwards); } else { // Get the path of the saved game // Open the file FileStream stream = File.Open(fullpath, FileMode.Open, FileAccess.Read); // Read the data from the file XmlSerializer serializer = new XmlSerializer(typeof(AwardsData)); data = (AwardsData)serializer.Deserialize(stream); // Close the file stream.Close(); } GamePadState gps = GamePad.GetState(Microsoft.Xna.Framework.PlayerIndex.One); KeyboardState kbs = Keyboard.GetState(); if (gps.IsButtonDown(Buttons.LeftShoulder) && gps.IsButtonDown(Buttons.RightShoulder) && gps.Triggers.Left > 0.5f && gps.Triggers.Right > 0.5f) { data = MakeNewData(); } else if (kbs.IsKeyDown(Keys.F1) && kbs.IsKeyDown(Keys.F2)) { data = MakeNewData(); } currentPlayerAwards = data; lastScore = data.stats[(int)stats.totalScore]; SaveAwards(userName); }
public static AwardsData MakeNewData() { AwardsData data = new AwardsData(); data.awards = new List<bool>(); int numFalseAwards = 0; for (int i = 0; i < (int)awards.ZZZLASTAWARDTHATISONLYUSEDFORLISTGENERAIONANDITERATION; i++) { data.awards.Add(false); numFalseAwards++; } data.stats = new List<int>(); for (int i = 0; i < (int)stats.ZZZLASTSTATTHATISONLYUSEDFORLISTGENERAIONANDITERATION; i++) { data.stats.Add(0); } data.highestMultiplier = 0; return data; }
private void cmdCleanUp_Click(object sender, EventArgs e) { try { string connStr = ConfigurationManager.ConnectionStrings["connStr"].ConnectionString; string dupQuery = "SELECT Count([Pricing Rate ID]) As Duplicates, [Customer BT], [Origin City], [Origin State], [Origin Zip], " + " [Origin Zip Range], [Dest City], [Dest State], [Dest Zip], [Dest Zip Range] From award_publication_temp " + " WHERE (GETDATE() BETWEEN ISNULL([Effective Date], GETDATE()) AND ISNULL([Expiration Date], GETDATE())) " + " GROUP BY [Customer BT], [Origin City], [Origin State], [Origin Zip], " + " [Origin Zip Range], [Dest City], [Dest State], [Dest Zip], [Dest Zip Range] " + " ORDER BY Duplicates DESC"; SqlConnection conn = new SqlConnection(connStr); SqlCommand cmd = new SqlCommand(dupQuery, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable dt = new DataTable(); conn.Open(); da.Fill(dt); if (dt != null && dt.Rows.Count > 0) { foreach (DataRow row in dt.Rows) { int dups = int.Parse(row[0].ToString()); if (dups > 1) { AwardsData ad = new AwardsData(); ad.Customer = row["Customer BT"].ToString(); ad.OriginCity = row["Origin City"].ToString(); ad.OriginState = row["Origin State"].ToString(); ad.OriginZip = row["Origin Zip"].ToString(); ad.OriginZipRange = row["Origin Zip Range"].ToString(); ad.DestCity = row["Dest City"].ToString(); ad.DestState = row["Dest State"].ToString(); ad.DestZip = row["Dest Zip"].ToString(); ad.DestZipRange = row["Dest Zip Range"].ToString(); string query = "SELECT [Pricing Rate ID] FROM award_publication_temp WHERE [Customer BT] = @customer " + " AND [Origin City] = @originCity AND [Origin State] = @originState AND [Origin Zip] = @originZip " + " AND [Origin Zip Range] = @originZipRange AND [Dest City] = @destCity AND [Dest State] = @destState " + " AND [Dest Zip] = @destZip AND [Dest Zip Range] = @destZipRange " + " ORDER BY [Pricing Rate ID] DESC "; using (SqlCommand command = new SqlCommand(query, conn)) { using (SqlDataAdapter sda = new SqlDataAdapter(command)) { command.Parameters.AddWithValue("@customer", ad.Customer); command.Parameters.AddWithValue("@originCity", ad.OriginCity); command.Parameters.AddWithValue("@originState", ad.OriginState); command.Parameters.AddWithValue("@originZip", ad.OriginZip); command.Parameters.AddWithValue("@originZipRange", ad.OriginZipRange); command.Parameters.AddWithValue("@destCity", ad.DestCity); command.Parameters.AddWithValue("@destState", ad.DestState); command.Parameters.AddWithValue("@destZip", ad.DestZip); command.Parameters.AddWithValue("@destZipRange", ad.DestZipRange); DataTable dtDups = new DataTable(); sda.Fill(dtDups); int nCount = 0; if (dtDups != null && dtDups.Rows.Count > 0) { foreach (DataRow dupRow in dtDups.Rows) { if (nCount > 0) { string pricingRateId = dupRow["Pricing Rate ID"].ToString(); string deleteQry = "DELETE award_publication_temp WHERE [Pricing Rate ID] = '" + pricingRateId + "'"; SqlCommand deleteCmd = new SqlCommand(deleteQry, conn); deleteCmd.ExecuteNonQuery(); } nCount += 1; } } } } } } } conn.Close(); } catch (Exception ex) { MessageBox.Show(ex.Message); } }