private void DataPortal_Fetch(TapMangoPlant.Criteria criteria) { TransactionHandler.ProcessTransaction((tr) => { using (var cm = tr.CreateCommand()) { this.RaiseListChangedEvents = false; cm.CommandText = "usp_TapMangoPlant"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("@action", criteria.Action); cm.Parameters.AddWithValue("@Id", criteria.Id); using (var dr = new SafeDataReader(cm.ExecuteReader())) { while (dr.Read()) { this.Add(new TapMangoPlant(dr)); } } this.RaiseListChangedEvents = true; } }); }
public static TapMangoPlantList GetAll() { var criteria = new TapMangoPlant.Criteria { Action = "select" }; return(DataPortal.Fetch <TapMangoPlantList>(criteria)); }
private void DataPortal_Delete(TapMangoPlant.Criteria criteria) { TransactionHandler.ProcessTransaction((tr) => { using (var cm = tr.CreateCommand()) { cm.CommandText = "usp_TapMangoPlant"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("@action", "delete"); cm.Parameters.AddWithValue("@Id", criteria.Id); cm.ExecuteNonQuery(); this.MarkNew(); } }); }
private void DataPortal_Fetch(TapMangoPlant.Criteria criteria) { TransactionHandler.ProcessTransaction((tr) => { using (var cm = tr.CreateCommand()) { cm.CommandText = "usp_TapMangoPlant"; cm.CommandType = CommandType.StoredProcedure; cm.Parameters.AddWithValue("@action", criteria.Action); cm.Parameters.AddWithValue("@Id", criteria.Id); using (var dr = new SafeDataReader(cm.ExecuteReader())) { if (dr.Read()) { FillSelf(dr); } } } }); }