public override bool InsertSinger(SingerModel singer)
{
bool existSinger = false;
bool inserted = !existSinger;
List <SingerModel> singers = GetSingers();
try
{
existSinger = singers.Any(x => x.Name == singer.Name);
if (!existSinger)
{
using (SqlConnection connection = Conection.GetConection())
{
string query = "insert into singersTable values (@name, @kindOfMusic, @songs)";
SqlCommand sqlCommand = new SqlCommand(query, connection);
sqlCommand.Parameters.AddWithValue("@name", singer.Name);
sqlCommand.Parameters.AddWithValue("@kindOfMusic", singer.KindOfMusic);
sqlCommand.Parameters.AddWithValue("@songs", string.Join(",", singer.Songs));
connection.Open();
sqlCommand.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(inserted);
}
public override List <SingerModel> GetSingersByKindOfMusic(string kindOfMusic)
{
List <SingerModel> singers = new List <SingerModel>();
try
{
using (SqlConnection connection = Conection.GetConection())
{
string query = "select * from singersTable where kindOfMusic = @kindOfMusic";
SqlCommand sqlCommand = new SqlCommand(query, connection);
sqlCommand.Parameters.AddWithValue("@kindOfMusic", kindOfMusic);
connection.Open();
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
while (sqlDataReader.Read())
{
singers.Add(new SingerModel
{
Name = sqlDataReader.GetString(0),
KindOfMusic = sqlDataReader.GetString(1),
Songs = sqlDataReader.GetString(0).Split(',').ToList()
});
}
}
}
catch (Exception ex)
{
throw ex;
}
return(singers);
}