private DBase(string db)
{
// Get Database Connection from Registry
_dbConn = "Data Source=" + db;
DbFilename = db;
// Create DataProvider
Db = new SqLiteProvider(_dbConn);
}
protected void grdResult_RowDeleting(object sender, System.Web.UI.WebControls.GridViewDeleteEventArgs e)
{
string query = "DELETE FROM Books WHERE Id = @Id";
Dictionary <string, object> parametters = new Dictionary <string, object>();
parametters.Add("Id", e.Keys[0]);
SqLiteProvider.ExecuteSqlQueryReturnValue(query, parametters, result => grdResultFill());
}
private void grdResultFill()
{
string query = "SELECT * FROM Books";
SqLiteProvider.ExecuteSqlQueryReturnValue(query, null, delegate(SQLiteDataReader reader)
{
grdResult.DataSource = reader;
grdResult.DataBind();
});
}
protected void grdResult_RowUpdating(object sender, System.Web.UI.WebControls.GridViewUpdateEventArgs e)
{
string query = "UPDATE Books";
string where = "WHERE Id = " + e.Keys[0];
Dictionary <string, object> parametters = new Dictionary <string, object>();
parametters.Add("Title", e.NewValues[0] == null ? string.Empty : e.NewValues[0]);
parametters.Add("Author", e.NewValues[1] == null ? string.Empty : e.NewValues[1]);
SqLiteProvider.ExecuteSqlQueryUpdate(query, where, parametters, reader => grdResult_RowCancelingEdit(sender, null));
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string query = "SELECT * FROM books WHERE CHARINDEX (@SearchOption, Title)";
Dictionary <string, object> parametters = new Dictionary <string, object>();
parametters.Add("SearchOption", txtSearch.Text);
SqLiteProvider.ExecuteSqlQueryReturnValue(query, parametters, delegate(SQLiteDataReader reader)
{
grdResult.DataSource = reader;
grdResult.DataBind();
});
}
protected void btnInsert_Click(object sender, EventArgs e)
{
string query = "INSERT INTO Books";
Dictionary <string, object> parametters = new Dictionary <string, object>();
parametters.Add("Title", txtBookTitle.Text);
parametters.Add("Author", txtBookAuthor.Text);
parametters.Add("PublishDate", DateTime.Now);
SqLiteProvider.ExecuteSqlQueryInsert(query, parametters, delegate(int i)
{
grdResultFill();
});
}
