public void SearchBook(GridView GridView1, Dictionary <string, string> queryString)
{
SearchResult searchResult = new SearchResult();
Book book = new Book();
DataTable dt = new DataTable();
try
{
IMongoDatabase mdb = MongoDBConnectionManager.ConnectToMongoDB();
BsonDocument query = new BsonDocument();
if (queryString.ContainsKey("Title"))
{
query.Add("Title", queryString["Title"]);
}
if (queryString.ContainsKey("ISBN"))
{
query.Add("Isbn", queryString["ISBN"]);
}
if (queryString.ContainsKey("Author"))
{
query.Add("Author", queryString["Author"]);
}
if (queryString.ContainsKey("Publisher"))
{
query.Add("Publisher", queryString["Publisher"]);
}
var collection = mdb.GetCollection <Book>("Book");
var sort = Builders <Book> .Sort.Ascending("Title");
if (query.ElementCount > 0)
{
var list = collection.Find(query).Sort(sort).ToList();
dt = ConvertToDataTable(list);
}
else
{
var list = collection.Find(Builders <Book> .Filter.Empty).Sort(sort).ToList();
dt = ConvertToDataTable(list);
}
// Bind Book List to GridView
GridView1.DataSource = dt;
GridView1.DataBind();
}
catch (Exception error)
{
throw new Exception(error.Message);
}
}
public void DeleteBook(ObjectId id)
{
try
{
IMongoDatabase _database = MongoDBConnectionManager.ConnectToMongoDB();
var collection = _database.GetCollection <Book>("Book");
var filter = Builders <Book> .Filter.Eq("_id", id);
var result = collection.DeleteOne(filter);
}
catch (Exception error)
{
throw new Exception(error.Message);
}
}
public void InsertBook(string isbn, string title, string publisher, string author, string description)
{
try
{
IMongoDatabase _database = MongoDBConnectionManager.ConnectToMongoDB();
var collection = _database.GetCollection <Book>("Book");
this.isbn = isbn;
this.title = title;
this.publisher = publisher;
this.author = author;
this.description = description;
collection.InsertOne(this);
}
catch (Exception error)
{
throw new Exception(error.Message);
}
}
public void UpdateBook(ObjectId id, string isbn, string title, string publisher, string description)
{
try
{
IMongoDatabase _database = MongoDBConnectionManager.ConnectToMongoDB();
var collection = _database.GetCollection <Book>("Book");
var filter = Builders <Book> .Filter.Eq("_id", id);
var update = Builders <Book> .Update
.Set("Isbn", isbn)
.Set("Title", title)
.Set("Publisher", publisher)
.Set("Description", description);
var result = collection.UpdateOne(filter, update);
}
catch (Exception error)
{
throw new Exception(error.Message);
}
}