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