public static void SavePlayerList(PlayerListModel list)
{
using (FFBcontext context = new FFBcontext())
{
PlayerLists PlayerList = new PlayerLists();
PlayerList.ScheduleTypeId = list.Id;
PlayerList.Week = list.Week;
PlayerList.Year = list.Year;
context.PlayerLists.Add(PlayerList);
StreamReader csvreader = new StreamReader(list.File.InputStream);
while (!csvreader.EndOfStream)
{
if (!string.IsNullOrEmpty(csvreader.ReadLine()))
{
var result = csvreader.ReadLine().Split(',');
Players player = new Players();
player.Position = result[0].Replace(@"""", String.Empty);
player.Name = result[1].Replace(@"""", String.Empty);
player.Salary = Convert.ToInt32(result[2]);
player.GameInfo = result[3].Replace(@"""", String.Empty);
player.AvgPointsPerGame = Convert.ToDecimal(result[4]);
player.teamAbbrev = result[5].Replace(@"""", String.Empty);
player.PlayerListId = PlayerList.ScheduleTypeId;
context.Players.Add(player);
}
}
context.SaveChanges();
}
}
public static List<ScheduleTypeModel> GetScheduleTypes()
{
using (FFBcontext context = new FFBcontext())
{
return (from st in context.Schedule_Types
select new ScheduleTypeModel {
Id = st.Id,
Name = st.Name
}).ToList();
}
}
public static List<PlayerModel> GetAllPlayers()
{
using (FFBcontext context = new FFBcontext())
{
return (from p in context.Players
select new PlayerModel {
Id = p.Id,
AvgPointsPerGame = p.AvgPointsPerGame,
GameInfo = p.GameInfo,
Name = p.Name,
Position = p.Position,
Salary = p.Salary,
teamAbbrev = p.teamAbbrev
}).ToList();
}
}
