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); }