public List <suggestion> list2()
{
List <suggestion> libraryModels = new List <suggestion>();
SqlConnection con = new SqlConnection(path);
con.Open();
SqlCommand cmd = new SqlCommand("select * from suggestions1", con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
suggestion lib = new suggestion();
lib.SuggestionId = reader.GetInt32(0);
lib.BookName = reader.GetString(1);
lib.BookAuthor = reader.GetString(2);
lib.BookPublishedYear = reader.GetInt32(3);
if (!reader.IsDBNull(4))
{
lib.status = reader.GetString(4);
}
if (!reader.IsDBNull(5))
{
lib.BookCategory = reader.GetString(5);
}
libraryModels.Add(lib);
}
reader.Close();
con.Close();
return(libraryModels);
}
public void suggest(suggestion bookk)
{
SqlConnection con = new SqlConnection(path);
con.Open();
SqlCommand cmd = new SqlCommand($"INSERT INTO suggestions1( Book_Name,Book_Published_Year,Book_Author,Book_Category) VALUES('{bookk.BookName}','{bookk.BookPublishedYear}','{bookk.BookAuthor}','{bookk.BookCategory}')", con);
int RowCount = cmd.ExecuteNonQuery();
con.Close();
}