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); }