public void Edit(librarymodel bookk) { SqlConnection con = new SqlConnection(path); con.Open(); SqlCommand cmd = new SqlCommand($"UPDATE books1 SET Book_Name='{bookk.BookName}',Book_published_year={bookk.BookPublishedYear},Book_author='{bookk.BookAuthor}',Book_category='{bookk.BookCategory}' WHERE Book_Id={bookk.BookId}", con); int RowCount = cmd.ExecuteNonQuery(); con.Close(); }
public string Create(librarymodel lib) { string message; SqlConnection connection = new SqlConnection(path); connection.Open(); SqlCommand cmd = new SqlCommand("CreateBook", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Book_Name", lib.BookName); cmd.Parameters.AddWithValue("@Book_Published_Year", lib.BookPublishedYear); cmd.Parameters.AddWithValue("@Book_Author", lib.BookAuthor); cmd.Parameters.AddWithValue("@Book_Category", lib.BookCategory); cmd.Parameters.AddWithValue("@status", "Available"); message = Convert.ToString(cmd.ExecuteScalar()); connection.Close(); return(message); }
public librarymodel Details(int id) { librarymodel bookk = new librarymodel(); using (SqlConnection con = new SqlConnection(path)) { con.Open(); SqlCommand cmd = new SqlCommand($"SELECT * FROM books1 WHERE Book_Id={id}", con); using (SqlDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { bookk.BookId = id; bookk.BookName = Convert.ToString(reader["Book_Name"]); bookk.BookPublishedYear = Convert.ToInt32(reader["Book_published_year"]); bookk.BookAuthor = Convert.ToString(reader["Book_author"]); bookk.BookCategory = Convert.ToString(reader["Book_category"]); } } } return(bookk); }
public List <librarymodel> BOOKS() { List <librarymodel> libraryModels = new List <librarymodel>(); SqlConnection con = new SqlConnection(path); con.Open(); SqlCommand cmd = new SqlCommand("select * from books1 WHERE status !='Deleted'", con); SqlDataReader reader = cmd.ExecuteReader(); while (reader.Read()) { librarymodel lib = new librarymodel(); lib.BookId = reader.GetInt32(0); lib.BookName = reader.GetString(1); lib.BookPublishedYear = reader.GetInt32(2); lib.BookAuthor = reader.GetString(3); lib.BookCategory = reader.GetString(4); libraryModels.Add(lib); } reader.Close(); con.Close(); return(libraryModels); }
public librarymodel search(string Book_name) { librarymodel bookk = new librarymodel(); using (SqlConnection con = new SqlConnection(path)) { con.Open(); SqlCommand cmd = new SqlCommand($"SELECT * FROM books1 WHERE Book_name='{Book_name}' and status = 'Available' ", con); SqlDataReader reader = cmd.ExecuteReader(); { while (reader.Read()) { bookk.BookId = Convert.ToInt32(reader["Book_id"]); bookk.BookName = Convert.ToString(reader["Book_Name"]); bookk.BookPublishedYear = Convert.ToInt32(reader["Book_published_year"]); bookk.BookAuthor = Convert.ToString(reader["Book_author"]); bookk.BookCategory = Convert.ToString(reader["Book_category"]); } } reader.Close(); con.Close(); } return(bookk); }