public static LIB_SubCategory GetLIB_SubCategoryBySubCategoryID(int SubCategoryID)
{
LIB_SubCategory lIB_SubCategory = new LIB_SubCategory();
SqlLIB_SubCategoryProvider sqlLIB_SubCategoryProvider = new SqlLIB_SubCategoryProvider();
lIB_SubCategory = sqlLIB_SubCategoryProvider.GetLIB_SubCategoryBySubCategoryID(SubCategoryID);
return lIB_SubCategory;
}
public static DataSet GetDropDownListAllLIB_SubCategory(int CategoryID)
{
DataSet lIB_SubCategories = new DataSet();
SqlLIB_SubCategoryProvider sqlLIB_SubCategoryProvider = new SqlLIB_SubCategoryProvider();
lIB_SubCategories = sqlLIB_SubCategoryProvider.GetDropDownLisAllLIB_SubCategory(CategoryID);
return lIB_SubCategories;
}
public static DataSet GetAllLIB_SubCategoriesWithRelation()
{
DataSet lIB_SubCategories = new DataSet();
SqlLIB_SubCategoryProvider sqlLIB_SubCategoryProvider = new SqlLIB_SubCategoryProvider();
lIB_SubCategories = sqlLIB_SubCategoryProvider.GetAllLIB_SubCategories();
return lIB_SubCategories;
}
public static void LoadLIB_SubCategoryPage(System.Web.UI.WebControls.GridView gv, System.Web.UI.WebControls.Repeater rptPager, int pageIndex, DropDownList ddlPageSize)
{
int recordCount=0;
int PageSize = int.Parse(ddlPageSize.SelectedValue);
SqlLIB_SubCategoryProvider sqlLIB_SubCategoryProvider = new SqlLIB_SubCategoryProvider();
DataSet ds = sqlLIB_SubCategoryProvider.GetLIB_SubCategoryPageWise(pageIndex, PageSize, out recordCount);
gv.DataSource = ds;
gv.DataBind();
lIB_SubCategoriesPaggination(rptPager, recordCount, pageIndex, PageSize);//
}
public static int InsertLIB_SubCategory(LIB_SubCategory lIB_SubCategory)
{
SqlLIB_SubCategoryProvider sqlLIB_SubCategoryProvider = new SqlLIB_SubCategoryProvider();
return sqlLIB_SubCategoryProvider.InsertLIB_SubCategory(lIB_SubCategory);
}
public static bool DeleteLIB_SubCategory(int lIB_SubCategoryID)
{
SqlLIB_SubCategoryProvider sqlLIB_SubCategoryProvider = new SqlLIB_SubCategoryProvider();
return sqlLIB_SubCategoryProvider.DeleteLIB_SubCategory(lIB_SubCategoryID);
}
public static bool UpdateLIB_SubCategory(LIB_SubCategory lIB_SubCategory)
{
SqlLIB_SubCategoryProvider sqlLIB_SubCategoryProvider = new SqlLIB_SubCategoryProvider();
return sqlLIB_SubCategoryProvider.UpdateLIB_SubCategory(lIB_SubCategory);
}