public static bool AddNewMusic(Music music)
{
const string QUARY = @"Exec dbo.AddNewMusic @ID_Record, @PlayTyme, @BitRate, @Album, @Style";
var connectionString = GetConnectionString();
using (var connection = new SqlConnection(connectionString))
{
using (var command = new SqlCommand(QUARY, connection))
{
command.Parameters.Add("@ID_Record", SqlDbType.Int);
command.Parameters["@ID_Record"].Value = music.IDRecord;
command.Parameters.Add("@PlayTyme", SqlDbType.NVarChar);
command.Parameters["@PlayTyme"].Value = music.PlayTime;
command.Parameters.Add("@BitRate", SqlDbType.Int);
command.Parameters["@BitRate"].Value = music.Bitrate;
command.Parameters.Add("@Album", SqlDbType.NVarChar);
command.Parameters["@Album"].Value = music.Album;
command.Parameters.Add("@Style", SqlDbType.NVarChar);
command.Parameters["@Style"].Value = music.Style;
command.Connection.Open();
int count;
try
{
count = command.ExecuteNonQuery();
}
catch (InvalidCastException)
{
return false;
}
if (count == 1)
{
return true;
}
return false;
}
}
}
public static void AddNewMusic(Music music)
{
RecordAccess.AddNewMusic(music);
}
public static Music GetMusicById(int id)
{
const string QUARY = @"Exec dbo.GetMusicById @ID_Record";
var connectionString = GetConnectionString();
using (var connection = new SqlConnection(connectionString))
{
using (var command = new SqlCommand(QUARY, connection))
{
command.Parameters.Add("@ID_Record", SqlDbType.Int);
command.Parameters["@ID_Record"].Value = id;
command.Connection.Open();
Music result = null;
using (var reader = command.ExecuteReader())
{
while (reader.Read())
{
result = new Music
{
Album = reader["Album"].ToString(),
Bitrate = (int) reader["Bitrate"],
IDRecord = (int) reader["ID_Record"],
PlayTime = reader["PlayTime"].ToString(),
Style = reader["Style"].ToString()
};
}
reader.Close();
}
return result;
}
}
}
