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