private static DBgl_WorkflowGroup GetItemGroupFromReader(IDataReader dataReader)
{
DBgl_WorkflowGroup objItem = new DBgl_WorkflowGroup();
objItem.CreatedUser = SqlHelper.GetString(dataReader, "CreatedUser");
objItem.Legs = SqlHelper.GetInt(dataReader, "Legs");
return(objItem);
}
public static DBgl_WorkflowGroupCollection GetItemGroupPagging(int page, int rec, string strSearch, out int TotalRecords)
{
TotalRecords = 0;
DBgl_WorkflowGroupCollection ItemCollection = new DBgl_WorkflowGroupCollection();
Database db = SqlHelper.CreateConnection(SqlHelper.MyConnection);
DbCommand dbCommand = db.GetStoredProcCommand("gl_WorkflowGroup_Paging");
db.AddInParameter(dbCommand, "Page", DbType.Int32, page);
db.AddInParameter(dbCommand, "RecsPerPage", DbType.Int32, rec);
db.AddInParameter(dbCommand, "SearchValue", DbType.String, strSearch);
db.AddOutParameter(dbCommand, "TotalRecords", DbType.Int32, 0);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
while (dataReader.Read())
{
DBgl_WorkflowGroup item = GetItemGroupFromReader(dataReader);
ItemCollection.Add(item);
}
}
TotalRecords = Convert.ToInt32(db.GetParameterValue(dbCommand, "@TotalRecords"));
return(ItemCollection);
}