public void DeleteSubCategory(int SubCategoryID)
{
using (AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter objSubCategory = new AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter())
{
objSubCategory.DeleteAllSubCategory(SubCategoryID);
}
}
public DataTable GetDataTotblSubCategory(int CategoryID, string SubCategoryName)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter objSubCategory = new AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter())
{
dt = objSubCategory.GetDataTotblSubCategory(CategoryID, SubCategoryName);
}
return(dt);
}
public DataTable GetSubCategoryByCategoryID(int CategoryID, bool IsActive)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter objSubCategory = new AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter())
{
dt = objSubCategory.GetSubCategoryByCategoryID(CategoryID, IsActive);
}
return(dt);
}
public DataTable GetAllSubCategory(int SubCategoryID)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter objSubCategory = new AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter())
{
dt = objSubCategory.GetAllSubCategory(SubCategoryID);
}
return(dt);
}
public int AddEditSubCategory(int SubCategoryID, string Title, string ImageUrl, string Description, int CategoryID, string MetaTitle, string MetaKeyword, string MetaDescription)
{
int id;
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter objSubCategory = new AustraliaDAL.DataSet1TableAdapters.tblSubCategoryTableAdapter())
{
dt = objSubCategory.AddEditSubCategory(SubCategoryID, Title, ImageUrl, Description, CategoryID, MetaTitle, MetaKeyword, MetaDescription);
}
id = Convert.ToInt32(dt.Rows[0]["SubCategoryID"].ToString());
return(id);
}
