private void checkIfChanged() { DataTable secT = sectors.getSectorTable(); DataTable sysT = systems.getSystemTable(); DataTable secObT = null; bool changed = false; foreach (DataRow dt in secT.Rows) { if (dt.RowState != DataRowState.Unchanged) { changed = true; } } foreach (DataRow dt2 in sysT.Rows) { if (dt2.RowState != DataRowState.Unchanged) { changed = true; } } if (sectorWindow != null) { secObT = sectorWindow.getSectorObjectsSQL().getSectorObject(); foreach (DataRow secObRow in secObT.Rows) { if (secObRow.RowState == DataRowState.Unchanged) { changed = true; } } } if (changed == true) { DialogResult dr = MessageBox.Show("All your changes will be lost, Do want to save your changes before switching?", "Loss of Information Warning", MessageBoxButtons.YesNo); switch (dr) { case DialogResult.Yes: save_Click(null, null); break; case DialogResult.No: break; } } }
private void mainFrm_Load(object sender, EventArgs e) { pCanvas1.BackColor = Color.Black; factions = new FactionSql(); systems = new SystemsSql(); sectors = new SectorsSql(); baseAssets = new BaseAssetSQL(); mobs = new MobsSQL(); TreeWindow treeWindow = new TreeWindow(systems.getSystemTable(), sectors.getSectorTable()); treeView1.Nodes.AddRange(treeWindow.setupInitialTree()); HE_GlobalVars._ListofFactions = new string[factions.getFactionTable().Rows.Count + 1]; int factionCount = 1; HE_GlobalVars._ListofFactions[0] = "None"; DataTable factionTmp = factions.getFactionTable(); foreach (DataRow r in factionTmp.Rows) { HE_GlobalVars._ListofFactions[factionCount] = r["name"].ToString(); factionCount++; } }
private void button2_Click(object sender, EventArgs e) { DataTable tmp = sectorsSQL.getSectorTable(); bool idTaken = false; foreach (DataRow tr in tmp.Rows) { if (tr["sector_id"].ToString() == sp.SectorID.ToString()) { idTaken = true; } else if (sp.SectorID.ToString() == "0") { idTaken = true; } } if (idTaken == true) { MessageBox.Show("Sorry, the entered sector Id is already taken. \n Please enter a unique one"); } else { DataRow newSectorRow = tmp.NewRow(); String name = sp.Name.Replace("'", "''"); String notes = sp.Notes; String greetings = sp.Greetings; if (sp.Notes != null) { notes = sp.Notes.Replace("'", "''"); } if (sp.Greetings != null) { greetings = sp.Greetings.Replace("'", "''"); } newSectorRow["name"] = name; newSectorRow["notes"] = notes; newSectorRow["greetings"] = greetings; newSectorRow["sector_id"] = sp.SectorID; float xmin = -(sp.Width / 2); float xmax = sp.Width / 2; float ymin = -(sp.Height / 2); float ymax = sp.Height / 2; float zmin = -(sp.Depth / 2); float zmax = sp.Depth / 2; newSectorRow["x_min"] = xmin; newSectorRow["x_max"] = xmax; newSectorRow["y_min"] = ymin; newSectorRow["y_max"] = ymax; newSectorRow["z_min"] = zmin; newSectorRow["z_max"] = zmax; newSectorRow["grid_x"] = sp.GridX; newSectorRow["grid_y"] = sp.GridY; newSectorRow["grid_z"] = sp.GridZ; newSectorRow["fog_near"] = sp.FogNear; newSectorRow["fog_far"] = sp.FogFar; newSectorRow["debris_mode"] = sp.DebrisMode; newSectorRow["light_backdrop"] = sp.LightBackdrop; newSectorRow["fog_backdrop"] = sp.FogBackdrop; newSectorRow["swap_backdrop"] = sp.SwapBackdrop; newSectorRow["backdrop_fog_near"] = sp.BackdropFogNear; newSectorRow["backdrop_fog_far"] = sp.BackdropFogFar; newSectorRow["max_tilt"] = sp.MaxTilt; newSectorRow["auto_level"] = sp.AutoLevel; newSectorRow["impulse_rate"] = sp.ImpulseRate; newSectorRow["decay_velocity"] = sp.DecayVelocity; newSectorRow["decay_spin"] = sp.DecaySpin; newSectorRow["backdrop_asset"] = sp.BackdropAsset; newSectorRow["system_id"] = sp.SystemID; newSectorRow["galaxy_x"] = sp.GalaxyX; newSectorRow["galaxy_y"] = sp.GalaxyY; newSectorRow["galaxy_z"] = sp.GalaxyZ; tmp.Rows.Add(newSectorRow); String systemName = mainFrm.systems.findRowNameByID(int.Parse(newSectorRow["system_id"].ToString())); //Add to treeNode foreach (TreeNode r in tree.Nodes) { if (r.Text == systemName) { TreeNode tmpTNode = new TreeNode(name); r.Nodes.Add(tmpTNode); } } //Add to database sectorsSQL.newRow(newSectorRow); //Add to graphic screen. mainFrm.systemWindow.newSector(newSectorRow); this.Close(); } }