//для nar.dbo.sp_test_read public static MyMusic executeProcSelect(SqlConnection connection, string proc) { string sqlExpression = proc; SqlCommand command = new SqlCommand(sqlExpression, connection); command.CommandType = System.Data.CommandType.StoredProcedure; using (SqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { MyMusic myCollection = new MyMusic(); while (reader.Read()) { myCollection.Tracks.Add(new Track() { Album = reader.GetString(1), Artist = reader.GetString(2), Title = reader.GetString(3), Year = reader.GetInt32(4) }); } reader.Close(); return(myCollection); } return(null); } }
public JsonFile() { MyMusic myCollection = new MyMusic(); myCollection.Tracks = new Track[3]; myCollection.Tracks[0] = new Track() { Artist = "Artist1", Album = "Album1", Title = "Title1", Year = "2015" }; myCollection.Tracks[1] = new Track() { Artist = "Artist2", Album = "Album2", Title = "Title2", Year = "2015" }; myCollection.Tracks[2] = new Track() { Artist = "Artist3", Album = "Album3", Title = "Title3", Year = "2015" }; string serialized = JsonConvert.SerializeObject(myCollection); File.WriteAllText(@"C:\Users\User\AppData\Local\Temp\DataBase.txt", serialized); }
public void TestMethod_MyMusic() { var mymusic = new MyMusic(); mymusic.Album(null, null); mymusic.Song(null, null); mymusic.Band(null, null); }
// для nar.dbo.sp_test_ins public static void executeProcIns(SqlConnection connection, string proc, MyMusic music) { string sqlExpression = proc; using (SqlCommand command = new SqlCommand(sqlExpression, connection)) { command.CommandType = System.Data.CommandType.StoredProcedure; foreach (var track in music.Tracks) { command.Parameters.Clear(); command.Parameters.Add(new SqlParameter("@album", track.Album)); command.Parameters.Add(new SqlParameter("@artist", track.Artist)); command.Parameters.Add(new SqlParameter("@title", track.Title)); command.Parameters.Add(new SqlParameter("@year", track.Year)); var result = command.ExecuteNonQuery(); } } }
public void ListMusic_DoubleClick(object sender, MouseButtonEventArgs e, ListView list) { DependencyObject dep = (DependencyObject)e.OriginalSource; while ((dep != null) && !(dep is ListViewItem)) { dep = VisualTreeHelper.GetParent(dep); } if (dep == null) { return; } MyMusic item = (MyMusic)list.ItemContainerGenerator.ItemFromContainer(dep); _itemSelected = item.Path; list.Visibility = Visibility.Collapsed; OnPropertyChanged("MusicDoubleClick"); }
private void we_edit_Click(object sender, EventArgs e) { try { //Menu_SceneManager manager = new Menu_SceneManager(); CreateMenu_SceneManager manager = new CreateMenu_SceneManager(); WresIDGroup wrestler = (WresIDGroup)we_resultList.SelectedItem; WrestlerID wID = (WrestlerID)wrestler.ID; L.D("Loading " + wrestler.Name + " at " + wrestler.ID); if (global::CreateMenu_SceneManager.edit_data == null) { global::CreateMenu_SceneManager.edit_data = new EditWrestlerData(); } if (global::CreateMenu_SceneManager.edit_data.criticalMoveName == null) { global::CreateMenu_SceneManager.edit_data.criticalMoveName = string.Empty; } if (global::CreateMenu_SceneManager.edit_data.ThemeMusic_Filename == null) { global::CreateMenu_SceneManager.edit_data.ThemeMusic_Filename = string.Empty; } global::CreateMenu_SceneManager.edit_data.appearanceData.Set(global::DataBase.GetAppearanceData(wID)); global::CreateMenu_SceneManager.editWrestlerID = wID; global::CreateMenu_SceneManager.edit_data = global::SaveData.GetInst().GetEditWrestlerData(wID).Clone(); global::CreateMenu_SceneManager.flg_Overwrite = true; global::CreateMenu_SceneManager.user_edit_point = 380; global::CreateMenu_SceneManager.presetEditMode = false; MyMusic.Init(); UnityEngine.SceneManagement.SceneManager.LoadScene("Scene_WrestlerEditMenu"); } catch (Exception ex) { L.D("Edit Click Error: " + ex.StackTrace); } }