public void Search()
{
using (ProductSPDataSetManager mgr = new ProductSPDataSetManager()) {
try {
DataCollection = mgr.Search(SearchEntity);
RowsAffected = mgr.RowsAffected;
ResultText = "Rows Affected: " + RowsAffected.ToString();
}
catch (Exception ex) {
PublishException(ex);
}
}
}
public void GetAllWithOutputParameter()
{
using (ProductSPDataSetManager mgr = new ProductSPDataSetManager()) {
try {
DataCollection = mgr.GetAllWithOutputParameter();
RowsAffected = mgr.RowsAffected;
ResultText = "Check the Output Window for OUTPUT parameter value";
}
catch (Exception ex) {
PublishException(ex);
}
}
}
public Product Get(int productId)
{
DataCollection = new List <Product>();
using (ProductSPDataSetManager mgr = new ProductSPDataSetManager()) {
try {
Entity = mgr.Get(productId);
RowsAffected = mgr.RowsAffected;
ResultText = "Rows Affected: " + RowsAffected.ToString();
DataCollection.Add(Entity);
}
catch (Exception ex) {
PublishException(ex);
}
}
return(Entity);
}