public JsonResult GetSanPhamPTLoai(int pageIndex, int pageSize)
{
if (Session["maloai"] == null)
{
Session.Add("maloai", "Rau");
}
SanPhamList spl = spbus.LaySanPhamPTLoai(Session["maloai"].ToString(), pageIndex, pageSize);
return(Json(spl, JsonRequestBehavior.AllowGet));
}
public JsonResult GetSanPhamPT(int pageIndex, int pageSize, string productName)
{
if (Session["maloai"] == null)
{
Session.Add("maloai", "Rau");
}
SanPhamList spl = qlsp.LaySanPhamPT(Session["maloai"].ToString(), pageIndex, pageSize, productName);
return(Json(spl, JsonRequestBehavior.AllowGet));
}
public SanPhamList GetSanPham(string maloai, int pageIndex, int pageSize, string productName)
{
SanPhamList spl = new SanPhamList();
List <SanPham> l = new List <SanPham>();
SqlDataReader dr = dc.StoreReaders("GetSanPhams", maloai, pageIndex, pageSize, productName);
while (dr.Read())
{
SanPham s = new SanPham(dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(),
dr[4].ToString(), dr[5].ToString(), double.Parse(dr[6].ToString()));
l.Add(s);
}
spl.SanPhams = l;
dr.NextResult();
while (dr.Read())
{
spl.totalCount = Convert.ToInt32(dr["totalCount"]);
}
return(spl);
}
//Admin
public SanPhamList GetSanPham(int pageIndex, int pageSize)
{
SanPhamList spl = new SanPhamList();
List <SanPham> l = new List <SanPham>();
SqlDataReader dr = dc.StoreReaders("GetSanPhams", pageIndex, pageSize);
while (dr.Read())
{
SanPham s = new SanPham(int.Parse(dr[0].ToString()), dr[1].ToString(), dr[2].ToString(), dr[3].ToString(),
dr[4].ToString(), dr[5].ToString(), double.Parse(dr[6].ToString()));
l.Add(s);
}
spl.SanPhams = l;
dr.NextResult();
while (dr.Read())
{
spl.totalCount = dr["totalCount"].ToString();
}
return(spl);
}
//Admin
public SanPhamList LaySanPhamPT(int pageIndex, int pageSize)
{
SanPhamList spList = SanPhamDAL.GetSanPham(pageIndex, pageSize);
return(spList);
}
public SanPhamList LaySanPhamPTLoai(string maLoai, int pageIndex, int pageSize)
{
SanPhamList spList = SanPhamDAL.GetSanPhamPTLoai(maLoai, pageIndex, pageSize);
return(spList);
}
public JsonResult GetSanPhamPT(int pageIndex, int pageSize)
{
SanPhamList spl = qlsp.LaySanPhamPT(pageIndex, pageSize);
return(Json(spl, JsonRequestBehavior.AllowGet));
}
