protected override void DataPortal_Fetch(Object criteria)
{
Criteria crit = (Criteria)criteria;
using (SqlConnection cn = new SqlConnection(Singular.Settings.ConnectionString))
{
cn.Open();
try
{
using (SqlCommand cm = cn.CreateCommand())
{
cm.CommandType = CommandType.StoredProcedure;
cm.CommandText = "GetProcs.getROProductPagedList";
crit.AddParameters(cm);
using (SafeDataReader sdr = new SafeDataReader(cm.ExecuteReader()))
{
Fetch(sdr);
}
}
}
finally
{
cn.Close();
}
}
}
protected override void DataPortal_Fetch(object criteriaObject)
{
Criteria criteria = (Criteria)criteriaObject;
using (SqlConnection connection = new SqlConnection(Singular.Settings.ConnectionString))
{
connection.Open();
try
{
using (SqlCommand command = connection.CreateCommand())
{
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "GetProcs.getROUserPagedList";
criteria.AddParameters(command);
command.Parameters.AddWithValue("@UserName", criteria.UserName);
using (SafeDataReader safeDataReader = new SafeDataReader(command.ExecuteReader()))
{
this.Fetch(safeDataReader);
}
}
}
finally
{
connection.Close();
}
}
}
protected override void DataPortal_Fetch(object criteriaObject)
{
Criteria criteria = (Criteria)criteriaObject;
using (SqlConnection connection = new SqlConnection(Singular.Settings.ConnectionString))
{
connection.Open();
try
{
using (SqlCommand command = connection.CreateCommand())
{
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "GetProcs.getROUserPagedList";
if ((criteria.FirstName != null && criteria.FirstName != "") || (criteria.LastName != null && criteria.LastName != ""))
{
MELib.RO.ROUserList rOUserList = RO.ROUserList.GetROUserList();
System.Collections.Generic.List <RO.ROUser> listrOUserList = null;
//filter the list
if (criteria.FirstName.Length != 0 && criteria.LastName.Length != 0)
{
listrOUserList = rOUserList.Where <RO.ROUser>(c => c.FirstName.ToUpper().Contains(criteria.FirstName.ToUpper()) == true && c.LastName.ToUpper().Contains(criteria.LastName.ToUpper()) == true).ToList();
}
if (criteria.FirstName.Length != 0 && criteria.LastName.Length == 0)
{
listrOUserList = rOUserList.Where <RO.ROUser>(c => c.FirstName.ToUpper().Contains(criteria.FirstName.ToUpper()) == true).ToList();
}
if (criteria.FirstName.Length == 0 && criteria.LastName.Length != 0)
{
listrOUserList = rOUserList.Where <RO.ROUser>(c => c.LastName.ToUpper().Contains(criteria.LastName.ToUpper()) == true).ToList();
}
criteria.Filters = listrOUserList.GetXmlIDs <RO.ROUser>();
}
criteria.AddParameters(command);
command.Parameters.AddWithValue("@UserName", criteria.UserName);
command.Parameters.AddWithValue("@EmailAddress", Singular.Misc.NothingDBNull(criteria.EmailAddress));
command.Parameters.AddWithValue("@Filters", Singular.Misc.NothingDBNull(criteria.Filters));
using (SafeDataReader safeDataReader = new SafeDataReader(command.ExecuteReader()))
{
this.Fetch(safeDataReader);
}
}
}
finally
{
connection.Close();
}
}
}
