public Snipe GetSnipe(int snipeID) { SqlDataContext myDataConnection = new SqlDataContext(); Query q = new Query(); Criterion crit = new Criterion(); crit.Operator = CriteriaOperator.Equal; crit.PropertyName = "SnipeID"; crit.Value = snipeID; q.Criteria.Add(crit); q.Members.Add("*"); List<Snipe> snipes = myDataConnection.GetByCriteria<Snipe>(q).ToList(); if (snipes.Count != 1) throw new Exception("Error when loading the snipe"); else return snipes[0]; }
public User GetUserForSnipe(Snipe snipe) { SqlDataContext myDataConnection = new SqlDataContext(); Query q = new Query(); Criterion c = new Criterion(); c.Operator = CriteriaOperator.Equal; c.PropertyName = "UserID"; c.Value = snipe.UserID; q.Criteria.Add(c); q.Members.Add("*"); IList<User> userList = myDataConnection.GetByCriteria<User>(q); if (userList.Count != 1) return null; else return userList[0]; }
public void GetSimilarItemsTest() { ServiceEBay target = new ServiceEBay(true); // TODO: Initialize to an appropriate value Snipe snipe = new Snipe(); List<eBayItemData> expected = null; // TODO: Initialize to an appropriate value List<eBayItemData> actual; IList<User> users = new List<User>(); SqlDataContext myDataConnection = new SqlDataContext(); Query q = new Query(); Criterion crit = new Criterion(); crit.Operator = CriteriaOperator.Equal; crit.PropertyName = "UserID"; crit.Value = "2"; q.Criteria.Add(crit); q.Members.Add("*"); users = myDataConnection.GetByCriteria<User>(q); target.User = users[0]; IList<Snipe> snipes = new List<Snipe>(); myDataConnection = new SqlDataContext(); q = new Query(); crit = new Criterion(); crit.Operator = CriteriaOperator.Equal; crit.PropertyName = "SnipeID"; crit.Value = "1"; q.Criteria.Add(crit); q.Members.Add("*"); snipes = myDataConnection.GetByCriteria<Snipe>(q); snipe = snipes[0]; actual = target.GetSimilarItems(snipe); Assert.AreEqual(expected, actual); Assert.Inconclusive("Verify the correctness of this test method."); }