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:");
}
}
