public List <dtoGenre> GetGenres()
{
dalGenre dalGenre = new dalGenre();
List <dtoGenre> listEmp = new List <dtoGenre>();
DataTable Genres = dalGenre.GetGenres();
for (int i = 0; i < Genres.Rows.Count; i++)
{
dtoGenre Genre = new dtoGenre();
DataRow row = Genres.Rows[i];
Genre.GenreID = Convert.ToInt32(row[0]);
Genre.GenreName = row[1].ToString();
listEmp.Add(Genre);
}
return(listEmp);
}
/// <summary>
/// Hàm thêm thể loại
/// </summary>
/// <param name="genre"></param>
/// <returns></returns>
public int InsertGenre(dtoGenre genre)
{
int count = 0;
try
{
string sql = "INSERT [dbo].[Genre] ([GenreName]) VALUES ( @Name)";
SqlParameter parameterName = new SqlParameter("@Name", SqlDbType.NVarChar);
parameterName.Value = genre.GenreName;
count = InsertUpdateDeleteData(sql, new[] { parameterName });
}
finally
{
CloseConnection();
}
return(count);
}
/// <summary>
/// Hàm cập nhập thể loại
/// </summary>
/// <param name="genre"></param>
/// <returns></returns>
public int UpdateGenre(dtoGenre genre)
{
int count = 0;
try
{
string sql = "UPDATE [dbo].[Genre] SET [GenreName] = @Name WHERE [GenreID] = @ID";
SqlParameter parameterID = new SqlParameter("@Name", SqlDbType.Int);
parameterID.Value = genre.GenreID;
SqlParameter parameterName = new SqlParameter("@Name", SqlDbType.NVarChar);
parameterName.Value = genre.GenreName;
count = InsertUpdateDeleteData(sql, new[] { parameterID, parameterName });
}
finally
{
CloseConnection();
}
return(count);
}
