public List<CollectionPoint> GetCollectionPoints() { CollectionPoint p = null; List < CollectionPoint > points = new List<CollectionPoint>(); string sql = "SELECT * FROM CollectionPoint"; try { connection.Open(); SqlCommand cmd = new SqlCommand(sql, connection); points = CollectionPoint.MapToList(cmd.ExecuteReader()); } finally { connection.Close(); } return points; }
public List<CollectionPoint> GetCollectionPointsByClerk(int clerkId) { CollectionPoint p = null; string sql = "SELECT * FROM CollectionPoint WHERE EmpID = @clerkID"; List<CollectionPoint> points = new List<CollectionPoint>(); try { connection.Open(); SqlCommand cmd = new SqlCommand(sql, connection); cmd.Parameters.AddWithValue("@clerkID", clerkId); points= CollectionPoint.MapToList(cmd.ExecuteReader()); } finally { connection.Close(); } return points; }