public DataTable biouserbelongsTo(string andorclause)
{
DataTable dt= new DataTable();
if(new bioControl().BeforeSelect()==true){
dt=new Connectoperations().selectdatable("bio,user","*","where bio.id=bio.user_id "+ andorclause);
if(new bioControl().AfterSelect()==true){
return dt;
}
else
{
return new DataTable();
}
}
return dt;
}
public DataTable usercoursehasMany(string andorclause)
{
DataTable dt= new DataTable();
if(new userControl().BeforeSelect()==true){
dt=new Connectoperations().selectdatable("user,course","*","where user.id=course.user_id "+ andorclause);
if(new userControl().AfterSelect()==true){
return dt;
}
else
{
return new DataTable();
}
}
return dt;
}
public DataTable selecttableuser(string attributes,string where)
{
DataTable dt= new DataTable();
if(new userControl().BeforeSelect()==true){
dt=new Connectoperations().selectdatable("user",attributes,where);
if(new userControl().AfterSelect()==true){
return dt;
}
else
{
return new DataTable();
}
}
return dt;
}
public string selectsinglevalueuser(string attribute,string where)
{
string str= "";
if(new userControl().BeforeSelect()==true){
str=new Connectoperations().singleval("user",attribute,where);
if(new userControl().AfterSelect()==true){
return str;
}
else
{
return "";
}
}
return str;
}
