//для 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);
}
}
