public IList <BsBook> FindBsBooks()
{
IList <BsBook> list = new List <BsBook>();
string sort = "";
string sql = String.Format("select * from BsBook");
DataTable dt = SqlHelper.ExecuteQuery(sql);
if (dt != null)
{
BsBook bsBook = null;
foreach (DataRow row in dt.Rows)
{
bsBook = new BsBook();
//bsBook.BsCategory.Name = row["CatName"].ToString();
bsBook.ID = Int32.Parse(row["id"].ToString());
bsBook.CatID = Int32.Parse(row["catID"].ToString());
bsBook.Name = row["name"].ToString();
bsBook.Image = row["image"].ToString();
bsBook.Price = decimal.Parse(row["price"].ToString());
bsBook.Summary = row["summary"].ToString();
bsBook.Author = row["author"].ToString();
list.Add(bsBook);
}
}
return(list);
}
public IList <BsBook> FindBsBooks(int catID, string name, string author, string sortExpression, int startRowIndex, int maximumRows)
{
IList <BsBook> list = new List <BsBook>();
string sort = "";
if (!String.IsNullOrEmpty(sortExpression))
{
sort = string.Format("order by b.{0}", sortExpression);
}
string sql = String.Format("select a.name as CatName,b.* from BsCategory a,BsBook b where a.id=b.catID and {0} b.Name like '%{1}%' and b.author like '%{2}%' {3}", (catID == 0 ? "" : "b.catID=" + catID + " and"), name, author, sort);
DataTable dt = SqlHelper.ExecuteQuery(sql, startRowIndex, maximumRows);
if (dt != null)
{
BsBook bsBook = null;
foreach (DataRow row in dt.Rows)
{
bsBook = new BsBook();
bsBook.BsCategory.Name = row["CatName"].ToString();
bsBook.ID = Int32.Parse(row["id"].ToString());
bsBook.CatID = Int32.Parse(row["catID"].ToString());
bsBook.Name = row["name"].ToString();
bsBook.Image = row["image"].ToString();
bsBook.Price = decimal.Parse(row["price"].ToString());
bsBook.Summary = row["summary"].ToString();
bsBook.Author = row["author"].ToString();
list.Add(bsBook);
}
}
return(list);
}
public BsBook FindBsBook(int id)
{
BsBook bsBook = null;
string sql = String.Format("select a.name as CatName,b.* from BsCategory a, BsBook b where a.id=b.catID and b.id={0}", id);
SqlDataReader sdr = SqlHelper.ExecuteReader(sql);
if (sdr.Read())
{
bsBook = new BsBook(sdr.GetString(0), sdr.GetInt32(1), sdr.GetInt32(2), sdr.GetString(3), sdr.GetString(4), sdr.GetDecimal(5), sdr.GetString(6), sdr.GetString(7));
}
sdr.Close();
return(bsBook);
}
protected void Page_Load(object sender, EventArgs e)
{
int id = Int32.Parse(Request.QueryString["id"]);
BsBook bsBook = bsBookBLL.FindBsBook(id);
CartItem item = new CartItem();
item.ID = id;
item.Name = bsBook.Name;
item.Price = bsBook.Price;
item.Quantity = 1;
Profile.BsCartBLL.AddItem(item);
Profile.Save();
Response.Redirect("~/Web/User/CartBrowse.aspx");
}
public int AddBsBook(BsBook bsBook)
{
return(bsBookDAL.AddBsBook(bsBook));
}
public int EditBsBook(BsBook bsBook)
{
return(bsBookDAL.EditBsBook(bsBook));
}
public int AddBsBook(BsBook bsBook)
{
string sql = String.Format("insert into BsBook(catID,name,image,price,summary,author) values ({0},'{1}','{2}',{3},'{4}','{5}')", bsBook.CatID, bsBook.Name, bsBook.Image, bsBook.Price, bsBook.Summary, bsBook.Author);
return(SqlHelper.ExecuteNonQuery(sql));
}
public int EditBsBook(BsBook bsBook)
{
string sql = String.Format("update BsBook set catID={0},name='{1}',price={2},summary='{3}',author='{4}' where id={5}", bsBook.CatID, bsBook.Name, bsBook.Price, bsBook.Summary, bsBook.Author, bsBook.ID);
return(SqlHelper.ExecuteNonQuery(sql));
}
