private void BindProduct()
{
LudwigContext context = new LudwigContext();
var result = context.SqlQuery <Nop_Product>(this.Query);
List <Nop_Product> lstProduct = result.ToList();
List <Nop_Product> productForBind = new List <Nop_Product>();
if (lstProduct.Count() > 0)
{
int totalRecords = lstProduct.Count;
this.pagerProducts.Visible = this.pagerProducts.PageSize < totalRecords;
for (int i = this.PageIndex; i < totalRecords; i++)
{
productForBind.Add(lstProduct[i]);
}
this.lvResult.DataSource = productForBind;
this.lvResult.DataBind();
this.pnResult.Visible = true;
this.pnSearchForm.Visible = false;
this.ltrError.Visible = false;
}
else
{
this.pnResult.Visible = true;
this.pnSearchForm.Visible = false;
this.ltrError.Visible = true;
}
}
public CatalogBiz()
{
dbContext = new LudwigContext();
}
public InstrumentalBiz()
{
dbContext = new LudwigContext();
}
public CatalogTitleTypeBiz()
{
dbContext = new LudwigContext();
}
public SeriesBiz()
{
dbContext = new LudwigContext();
}
public VideoBiz()
{
dbContext = new LudwigContext();
}
public RoleBiz()
{
dbContext = new LudwigContext();
}
public BaseBiz()
{
dbContext = new LudwigContext();
}
public HtmlContentBiz()
{
dbContext = new LudwigContext();
}
public InstrTitleBiz()
{
context = new LudwigContext();
}
public ReprintSourceBiz()
{
dbContext = new LudwigContext();
}
public PersonBiz()
{
dbContext = new LudwigContext();
}
public CategoryBiz()
{
context = new LudwigContext();
}
public GenerBiz()
{
dbContext = new LudwigContext();
}
public EmailDirectoryBiz()
{
dbContent = new LudwigContext();
}
public PublisherBiz()
{
dbContext = new LudwigContext();
}
public PeriodBiz()
{
dbContext = new LudwigContext();
}
public AudioBiz()
{
dbContext = new LudwigContext();
}
public LicenseBiz()
{
context = new LudwigContext();
}