public DataTable catNested(string cname)
{
objcat = new CATEGORYTableAdapter();
return(objcat.CatNested(cname));
}
public DataTable getCategory()
{
objcat = new CATEGORYTableAdapter();
return(objcat.GetCategory());
}
public bool updatecategoryvacancy(int vacancy, int catId)
{
objcat = new CATEGORYTableAdapter();
return(objcat.UpdateCategoryVacancy(vacancy, catId) > 0);
}
public bool deleteCategory(int id)
{
objcat = new CATEGORYTableAdapter();
return(objcat.DeleteCategory(id) > 0);
}
public bool updateCategory(string cat, int id)
{
objcat = new CATEGORYTableAdapter();
return(objcat.UpdateCategory(cat, id) > 0);
}
public bool insertCategory(string cat, int id)
{
objcat = new CATEGORYTableAdapter();
return(objcat.InsertCategory(cat, id) > 0);
}
public DataTable getCatById(int cid)
{
objcat = new CATEGORYTableAdapter();
return(objcat.GetCatById(cid));
}
public DsMaster GetCategory()
{
var ta = new CATEGORYTableAdapter {Connection = {ConnectionString = _constr}};
var catds = new DsMaster();
ta.Fill(catds.CATEGORY);
return catds;
}
