static void Main(string[] args) { BaseballEntities be = new BaseballEntities(new Uri("http://www.agilewaysdev.com/BaseballService/Services/AgileWays.Baseball.Service.svc")); var valuePlayers = be.BatterDetails.Where( b => ((((Int32)(b.yearID) > 1980) && ((((Int32?)(b.HR) > (Int32?)20) || ((Int32?)(b.Triples) > (Int32?)10)) || ((Int32?)(b.Doubles) > (Int32?)30) ) ) && (b.salary < (Double?)2000000) ) ) .OrderBy(b => b.salary) .ThenBy(b => b.yearID) .Select( b => new { nameFirst = b.nameFirst, nameLast = b.nameLast, TeamName = b.TeamName, salary = b.salary, AVG = ((Double)(((Int32?)(b.H) * (Int32?)1000) / (Int32?)(b.AB)) / 1000), HR = b.HR, Triples = b.Triples, Doubles = b.Doubles, yearID = b.yearID } ); foreach (var player in valuePlayers) { Console.WriteLine("{0} {1} in {3} made Salary = {2}", player.nameFirst, player.nameLast, player.salary.Value.ToString(), player.yearID.ToString()); } }
static void Main(string[] args) { BaseballEntities be = new BaseballEntities(new Uri("http://www.agilewaysdev.com/BaseballService/Services/AgileWays.Baseball.Service.svc")); bool isNext = true; Console.WriteLine("Enter query:"); while (isNext) { string action = Console.ReadLine(); if (action.ToLower()=="exit") { isNext = false; continue; } string[] parts = action.Split(new char[] { ' ' }); if (parts.Length != 2) { Console.WriteLine("Incorrect format. Use [obj] [criteria] [max]"); } else { switch (parts[0].ToLower()) { case "team": string[] criteria = parts[1].Split(new char[] { ';' }); if (criteria.Length == 1) { //just year specified var items = from t in be.Teams where t.yearID == Convert.ToInt16(criteria[0]) orderby t.name ascending select new { t.name, t.yearID, t.W, t.L, t.attendance }; foreach (var item in items) { Console.WriteLine("{3}\t{0}\t{1}\t{2}", item.yearID, item.W, item.L, item.name); } } else { var items = from t in be.Teams where t.name == criteria[1] && t.yearID == Convert.ToInt16(criteria[0]) orderby t.yearID ascending select new { t.name, t.yearID, t.W, t.L, t.attendance }; foreach (var item in items) { Console.WriteLine("{0} {1} {2}", item.yearID, item.W, item.L); } } break; //case "birthday": // string[] data = parts[1].Split(new char[] { ';' }); //format is first;last;year;month;day // if (data.Length != 5) // { // Console.WriteLine("Incorrect format. Should be first;last;year;month;day"); // break; // } // Birthday_Buddy bb = Birthday_Buddy.CreateBirthday_Buddy( // Convert.ToInt16(data[2]), // Convert.ToInt16(data[3]), // Convert.ToInt16(data[4]), // data[0], // data[1]); // be.AddToBirthday_Buddies(bb); // be.SaveChanges(); // break; case "batter": case "pitcher": default: Console.WriteLine("Invalid object. Use Team, Batter or Pitcher"); break; } } Console.WriteLine("\n\nEnter Query:"); } }