public void DeleteManager(string managerName, string team)
{
lock (_sycnRoot)
{
var deleteManager = from t in dc.Teams
where t.TeamName == team && t.Managers.ManagerName == managerName
select t.Managers;
foreach (var manager in deleteManager)
{
try
{
dc.Managers.DeleteOnSubmit(manager);
dc.SubmitChanges();
using (StreamWriter w = File.AppendText("NbaLog.txt"))
{
Log("Delete manager: " + manager.ManagerName, w);
}
}
catch (SqlException ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Delete player exception: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Delete player exception: " + ex.Message));
}
catch (Exception ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Delete player exception: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Delete player exception: " + ex.Message));
}
}
broadCast(managerName + " was deleted!", "Delete Manager");
}
}
//DATA BASE GLOBAL
public void InsertUser(string userName, string password)
{
lock (_sycnRoot)
{
dc.GetTable <Users>().InsertOnSubmit(new Users
{
UserName = userName,
Password = password
});
/* save the changes on the data base */
try
{
dc.SubmitChanges();
using (StreamWriter w = File.AppendText("NbaLog.txt"))
{
Log("New user insert: " + userName, w);
}
}
catch (SqlException ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Unable to insert user: "******"Unable to insert user: "******"Unable to insert user: "******"Unable to insert user: " + ex.Message));
}
}
}
public void UpdateWinAndLose(string win, string lose)
{
lock (_sycnRoot)
{
try
{
var teamWin = from t in dc.Teams
where t.TeamName == win
select t;
foreach (var team in teamWin)
{
team.Wins++;
using (StreamWriter w = File.AppendText("NbaLog.txt"))
{
Log("Update team " + team.TeamName + " wins", w);
}
}
var teamLost = from t in dc.Teams
where t.TeamName == lose
select t;
foreach (var team in teamLost)
{
team.Losses++;
using (StreamWriter w = File.AppendText("NbaLog.txt"))
{
Log("Update team " + team.TeamName + " losses", w);
}
}
dc.SubmitChanges();
}
catch (SqlException ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Update win and losses exception: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Update win and losses exception: " + ex.Message));
}
catch (Exception ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Update win and losses exception: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Update win and losses exception: " + ex.Message));
}
}
}
public void InsertPlayer(string playerName, string teamName, int age, double height, double weight, string position, int expYears, int titles, byte[] file_byte, string agent)
{
lock (_sycnRoot)
{
var playersTable = dc.GetTable <Players>();
try
{
System.Data.Linq.Binary file_binary = new System.Data.Linq.Binary(file_byte);
playersTable.InsertOnSubmit(new Players()
{
PlayerName = playerName,
TeamName = teamName,
Age = age,
Height = height,
Weight = weight,
Position = position,
ExeperienceYears = expYears,
NumberOfTitles = titles,
Picture = file_binary,
AgentName = agent,
MVP = 0
});
dc.SubmitChanges();
using (StreamWriter w = File.AppendText("NbaLog.txt"))
{
Log("New player insert: " + playerName, w);
}
}
catch (SqlException ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Unable to insert player: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Unable to insert player: " + ex.Message));
}
catch (Exception ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Unable to insert player: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Unable to insert player: " + ex.Message));
}
broadCast("player " + playerName + " was added to data base!", "Add Player");
}
}
public void InsertGame(string homeTeam, string awayTeam, string MVP, DateTime gameDate, int homeScore, int awayScore, int fixtures)
{
lock (_sycnRoot)
{
var gamesTable = dc.GetTable <Games>();
try
{
gamesTable.InsertOnSubmit(new Games()
{
HomeTeam = homeTeam,
AwayTeam = awayTeam,
MVP = MVP,
GameDate = gameDate,
AwayTeamScore = homeScore,
HomeTeamScore = awayScore,
Fixture = fixtures
});
dc.SubmitChanges();
using (StreamWriter w = File.AppendText("NbaLog.txt"))
{
Log("New game insert: " + homeTeam + " - " + awayTeam + ", fixture: " + fixtures, w);
}
}
catch (SqlException ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Manager insertion exception: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Game insertion exception: " + ex.Message));
}
catch (Exception ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Manager insertion exception: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Game insertion exception: " + ex.Message));
}
broadCast("game " + homeTeam + " vs " + awayTeam + " was added to data base!", "Add Game");
}
}
public void UpdateMVP(string playerMVP)
{
lock (_sycnRoot)
{
try
{
var players = from p in dc.Players
where p.PlayerName == playerMVP.Substring(0, p.PlayerName.Length) &&
p.TeamName == playerMVP.Substring(p.PlayerName.Length + 1, p.TeamName.Length)
select p;
foreach (var player in players)
{
player.MVP++;
dc.SubmitChanges();
using (StreamWriter w = File.AppendText("NbaLog.txt"))
{
Log("Update player: " + player.PlayerName, w);
}
}
}
catch (SqlException ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Update MVP exception: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Update MVP exception: " + ex.Message));
}
catch (Exception ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Update MVP exception: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Update MVP exception: " + ex.Message));
}
}
}
public void connectDB()
{
dc = new NBADataContext(connectionString);
try
{
if (!dc.DatabaseExists())
{
dc.CreateDatabase();
}
}
catch (SqlException ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Unable to connect data base: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Unable to connect data base: " + ex.Message));
}
catch (Exception ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Unable to connect data base: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Unable to connect data base: " + ex.Message));
}
}
public void InsertManager(string managerName, string team, int age, int expYears, int titles)
{
lock (_sycnRoot)
{
var managersTable = dc.GetTable <Managers>();
try
{
managersTable.InsertOnSubmit(new Managers()
{
ManagerName = managerName,
TeamName = team,
Age = age,
ExperienceYears = expYears,
NumberOfTitles = titles
});
dc.SubmitChanges();
using (StreamWriter w = File.AppendText("NbaLog.txt"))
{
Log("New manager insert: " + managerName, w);
}
}
catch (SqlException ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Manager insertion exception: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Manager insertion exception: " + ex.Message));
}
catch (Exception ex)
{
DataBaseException fault = new DataBaseException();
fault.Message = "Manager insertion exception: " + ex.Message;
throw new FaultException <DataBaseException>(fault, new FaultReason("Manager insertion exception: " + ex.Message));
}
broadCast("manager " + managerName + " was added to data base!", "Add Manager");
}
}
