public void Insert(T obj) { var databaseB2b = new it.itryframework2.data.DBMapper(); it.itryframework2.interfaces.IGenericObject GenObj = obj; databaseB2b.insert(GenObj); }
public System.Data.DataTable GetDatatable(string sql) { var databaseB2b = new it.itryframework2.data.DBMapper(); System.Data.DataTable dt = databaseB2b.select(sql); return(dt); }
public void Delete(int id) { var databaseB2b = new it.itryframework2.data.DBMapper(); T repo = new T(); databaseB2b.executeNonQuery("Delete from " + repo.TableName + " where " + repo.PrimaryKey + "=" + id); //return arrObjects[0]; }
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 dynamic ExecuteScalar(string sql, bool GetLastInsertedID) { var databaseB2b = new it.itryframework2.data.DBMapper(); dynamic Obj = databaseB2b.executeScalar(sql, false); return(Obj); }
//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(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]); }
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); }
public void Update(int id, T obj) { var databaseB2b = new it.itryframework2.data.DBMapper(); //Valorizza la primary key dell'oggetto con reflection Type myType = obj.GetType(); PropertyInfo pinfo = myType.GetProperty(obj.PrimaryKey); pinfo.SetValue(obj, id, null); it.itryframework2.interfaces.IGenericObject GenObj = obj; databaseB2b.update(GenObj); }