public void ActiveDeactiveCategory(int CategoryID)
{
using (AustraliaDAL.DataSet1TableAdapters.tblCategoryTableAdapter objCategory = new AustraliaDAL.DataSet1TableAdapters.tblCategoryTableAdapter())
{
objCategory.ActiveDeactiveCategory(CategoryID);
}
}
public DataTable GetDataTotblCategory(string CategoryName)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCategoryTableAdapter objCategory = new AustraliaDAL.DataSet1TableAdapters.tblCategoryTableAdapter())
{
dt = objCategory.GetDataTotblCategory(CategoryName);
}
return(dt);
}
public DataTable GetAllCategory(int CategoryID)
{
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCategoryTableAdapter objCategory = new AustraliaDAL.DataSet1TableAdapters.tblCategoryTableAdapter())
{
dt = objCategory.GetAllCategory(CategoryID);
}
return(dt);
}
public int AddEditCategory(int CategoryID, string Title, string ImageUrl, string Description, string MetaTitle, string MetaKeyword, string MetaDescription)
{
int id;
DataTable dt = new DataTable();
using (AustraliaDAL.DataSet1TableAdapters.tblCategoryTableAdapter objCategory = new AustraliaDAL.DataSet1TableAdapters.tblCategoryTableAdapter())
{
dt = objCategory.AddEditCategory(CategoryID, Title, ImageUrl, Description, MetaTitle, MetaKeyword, MetaDescription);
}
id = Convert.ToInt32(dt.Rows[0]["CategoryID"].ToString());
return(id);
}