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