public DataTable GetActiveUsers() { return(oMySql.GetDataTable("SELECT User, DateTime, Now(), (TIME_TO_SEC(NOW()) - TIME_TO_SEC(DateTime))/60 FROM `user` Where DateTime is not null and (TIME_TO_SEC(NOW()) - TIME_TO_SEC(DateTime))/60 <10")); }
public DataTable GetAll() { return(oMySql.GetDataTable(String.Format("Select * from Teacher Where CompanyID='{0}' And CustomerID='{1}'", this.CompanyID, this.CustomerID))); }