public System.Data.DataTable GetDatatable(string sql)
{
var databaseB2b = new it.itryframework2.data.DBMapper();
System.Data.DataTable dt = databaseB2b.select(sql);
return(dt);
}
public T GetLast()
{
var databaseB2b = new it.itryframework2.data.DBMapper();
T repo = new T();
T[] arrObjects = databaseB2b.select <T>("Select * from " + repo.TableName + " where " + repo.PrimaryKey + "=(select MAX(" + repo.PrimaryKey + ") as valoreMassimo from " + repo.TableName + " as aliasTable)");
return(arrObjects[0]);
}
public T Get(int id)
{
var databaseB2b = new it.itryframework2.data.DBMapper();
T repo = new T();
T[] arrObjects = databaseB2b.select <T>("Select * from " + repo.TableName + " where " + repo.PrimaryKey + "=" + id);
return(arrObjects[0]);
}
//restituisce un array di oggetti generici data una query
public T[] Get(string sql)
{
var databaseB2b = new it.itryframework2.data.DBMapper();
T repo = new T();
T[] arrObjects = databaseB2b.select <T>(sql);
return(arrObjects);
}
public T[] Get()
{
var databaseB2b = new it.itryframework2.data.DBMapper();
T repo = new T();
T[] arrObjects = databaseB2b.select <T>("Select * from " + repo.TableName);
return(arrObjects);
}
