public DataTable GetRoles() // Get all the user's roll from roll Table
{
using (DbAccess db = new DbAccess())
{
DataTable dt = db.ExecuteDataTable("select * from Role");
return dt;
}
}
public DataTable GetClasses()
{
using (DbAccess db = new DbAccess())
{
DataTable dt = db.ExecuteDataTable("select * from Class");
return dt;
}
}
public DataTable TotrecpNos(int adno)
{
using (DbAccess db = new DbAccess())
{
DataTable dt = db.ExecuteDataTable("select COUNT(ReceiptNo) trecpno from StudentFee where AdmNo='" + adno + "'");
//where UID='" + id + "'
return dt;
}
}
public DataTable GetList()
{
DbAccess db = new DbAccess();
return db.ExecuteDataTable("Org_List");
}