public List <T> SelectData <T>(T item, string whereClause = "") where T : class, new()
{
string query = GenericBuilder.Select(item, whereClause);
DataTable table = connection.Select(query);
List <T> result = Mapper.mapFromTable <T>(table);
return(result);
}
public bool UpdateData <T>(T item) where T : class
{
string query = GenericBuilder.Update(item);
return(connection.Update(query) > 0);
}
public int InsertData <T>(T item) where T : class
{
string query = GenericBuilder.Insert(item);
return(connection.InsertParameterized(query, Mapper.getInsertParameters(item)));
}
