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);
}
}
}
});
}
