public ReviewList GetAll()
{
try
{
_list.Clear();
Database db = new Database("Books");
db.Command.CommandType = System.Data.CommandType.StoredProcedure;
db.Command.CommandText = "tblReviewGETALL";
DataTable dt = db.ExecuteQuery();
//dgvStudent.DataSource = dt;
foreach (DataRow dr in dt.Rows)
{
Review s = new Review();
s.Initialize(dr);
s.InitializeBusinessData(dr);
s.IsDirty = false;
s.IsNew = false;
s.evtIsSavable += new IsSavableHandler(s_evtIsSavable);
_list.Add(s);
}
}
catch(Exception ex)
{
throw;
}
return this;
}
protected void btnPost_Click(object sender, EventArgs e)
{
Review br = new Review();
User user = new User();
user = (User)Session["User"];
br.Title = txtTitle.Text;
br.BookReview = txtBody.Text;
br.UserID = user.ID;
br.BookID = book.ID;
book.Reviews.List.Add(br);
book.Save();
Response.Redirect("default.aspx");
}
private Boolean Insert(Database db)
{
Review review = new Review();
try
{
db.Command.Parameters.Clear();
db.Command.CommandType = CommandType.StoredProcedure;
db.Command.CommandText = "tblReviewINSERT";
base.Initialize(db.Command, Guid.Empty);
db.Command.Parameters.Add("@BookID", SqlDbType.UniqueIdentifier).Value = _BookID;
db.Command.Parameters.Add("@UserID", SqlDbType.UniqueIdentifier).Value = _UserID;
db.Command.Parameters.Add("@Title", SqlDbType.VarChar).Value = Title;
db.Command.Parameters.Add("@BookReview", SqlDbType.VarChar).Value = _Review;
db.ExecuteNonQueryWithTransaction();
base.Initialize(db.Command);
return true;
}
catch (Exception ex)
{
throw;
}
}
public ReviewList GetByBookID(Guid BookID)
{
Database db = new Database("Books");
try
{
db.Command.Parameters.Clear();
db.Command.CommandType = CommandType.StoredProcedure;
db.Command.CommandText = "tblReviewGETBYBOOKID";
db.Command.Parameters.Add("@BookID", SqlDbType.UniqueIdentifier).Value = BookID;
DataTable dt = db.ExecuteQuery();
foreach (DataRow dr in dt.Rows)
{
Review s = new Review();
s.Initialize(dr);
s.InitializeBusinessData(dr);
s.IsDirty = false;
s.IsNew = false;
s.evtIsSavable += new IsSavableHandler(s_evtIsSavable);
_list.Add(s);
}
}
catch (Exception ex)
{
throw;
}
return this;
}
