public Dictionary<string, string> Read(Guid Id, TablesNames tableName)
{
TableInform table;
DbConnection connection;
DataRow result;
connection = TableInform.Connection;
table = new TableInform(tableName.ToString());
DataRow dr = table.Table.AsEnumerable().SingleOrDefault(r => r.Field<Guid>("ID") == Id);
var dict = table.ConvertRowToDict(dr);
return dict;
}
public void Insert(Dictionary<string, string> dictionary, TablesNames tableName)
{
TableInform table;
DbConnection connection;
DataRow result;
table = new TableInform(tableName.ToString());
connection = TableInform.Connection;
result = table.ConvertDictToRow(dictionary);
table.Table.Rows.Add(result);
table.Update(new DataRow[] { result });
}
public void Delete(Dictionary<string, string> dictionary, TablesNames tableName)
{
TableInform table;
DbConnection connection;
DataRow row;
string IdValue;
IdValue = null;
table = new TableInform(tableName.ToString());
table.Table.PrimaryKey = new DataColumn[] { table.Table.Columns["Id"] };
connection = TableInform.Connection;
if (dictionary.TryGetValue("Id", out IdValue))
{
row = table.Table.Rows.Find(IdValue);
row.Delete();
table.Update(new DataRow[] { row });
}
}
public void Update(Dictionary<string, string> dictionary, TablesNames tableName)
{
TableInform table;
DbConnection connection;
string IdValue;
DataRow row;
IdValue = null;
table = new TableInform(tableName.ToString());
connection = TableInform.Connection;
table.Table.PrimaryKey = new DataColumn[] { table.Table.Columns["Id"] };
if (dictionary.TryGetValue("Id", out IdValue))
{
row = table.Table.Rows.Find(IdValue);
foreach (KeyValuePair<string, string> pair in dictionary)
{
row[pair.Key] = pair.Value;
}
table.Update(new DataRow[] { row });
}
}
public List<Dictionary<string, string>> ReadAll(TablesNames tableName, Gender gender)
{
TableInform table;
DbConnection connection;
DataRow[] rows;
List<Dictionary<string, string>> resultedList;
connection = TableInform.Connection;
resultedList = new List<Dictionary<string, string>>();
table = new TableInform(tableName.ToString());
if (gender == Gender.NotSpecified)
{
rows = table.Table.Select();
}
else
{
string param = String.Format("LEAGUE = '{0}'", gender.ToString());
rows = table.Table.Select(param);
}
foreach (var row in rows)
{
var result = table.ConvertRowToDict(row);
resultedList.Add(result);
}
return resultedList;
}
public List<Dictionary<string, string>> FindSerchResults(string serchableName, TablesNames tableName, Gender gender)
{
TableInform table;
DbConnection connection;
List<Dictionary<string, string>> result;
result = new List<Dictionary<string, string>>();
connection = TableInform.Connection;
table = new TableInform(tableName.ToString());
var rowList = table.Table.AsEnumerable().Where(r => r.Field<string>("Name").Contains(serchableName.ToUpper())).ToList();
if (rowList.Count > 0)
{
foreach (var row in rowList)
{
if (row.Field<string>("League") == gender.ToString())
{
result.Add(table.ConvertRowToDict(row));
}
}
return result;
}
return null;
}
private List<Dictionary<string, string>> ReadByIds(TablesNames tableName, List<Guid> idList)
{
TableInform table;
List<Dictionary<string, string>> resultedList;
resultedList = new List<Dictionary<string, string>>();
table = new TableInform(tableName.ToString());
if (idList.Count > 0)
{
foreach (var id in idList)
{
var row = (from r in table.Table.AsEnumerable()
where r.Field<Guid>("Id") == id
select r).SingleOrDefault();
var result = table.ConvertRowToDict(row);
resultedList.Add(result);
}
return resultedList;
}
return null;
}
private List<Guid> GetTeamsByGameId(TablesNames tableName, Guid gameId)
{
TableInform table;
List<Guid> result;
table = new TableInform(tableName.ToString());
var res = (from r in table.Table.AsEnumerable()
where r.Field<Guid>("Id") == gameId
select r).SingleOrDefault();
result = new List<Guid>();
result.Add((Guid)res["TeamOneId"]);
result.Add((Guid)res["TeamTwoId"]);
return result;
}
private List<Guid> GetPlayersByGameId(TablesNames tableName, Guid gameId)
{
TableInform table;
table = new TableInform(tableName.ToString());
var res = (from r in table.Table.AsEnumerable()
where r.Field<Guid>("GameId") == gameId
select r.Field<Guid>("PlayerId")).ToList();
return res;
}
private List<Guid> GetGamesByTeamId(TablesNames tableName, Guid teamId)
{
TableInform table;
List<Dictionary<string, string>> resultedList;
resultedList = new List<Dictionary<string, string>>();
table = new TableInform(tableName.ToString());
var res = (from r in table.Table.AsEnumerable()
where r.Field<Guid>("TeamOneId") == teamId || r.Field<Guid>("TeamTwoId") == teamId
select r.Field<Guid>("Id")).ToList();
return res;
}
private List<Guid> GetInfoByPlayerId(TablesNames tableName, Guid playerId)
{
TableInform table;
table = new TableInform(tableName.ToString());
string param = (tableName.ToString().Substring(8, 4) + "Id");
var res = (from r in table.Table.AsEnumerable()
where r.Field<Guid>("PlayerId") == playerId
select r.Field<Guid>(param)).ToList();
return res;
}
public List<Dictionary<string, string>> ReadPlayersInfoInGame(Guid gameId, PlayersInfo playersInfo)
{
TableInform table;
DbConnection connection;
List<Dictionary<string, string>> resultedList;
connection = TableInform.Connection;
resultedList = new List<Dictionary<string, string>>();
table = new TableInform(TablesNames.PlayerInGames.ToString());
var rows = table.Table.AsEnumerable().Where(r => r.Field<Guid>("gameId") == gameId && r.Field<bool>(playersInfo.ToString()) == true).Select(r => r.Field<Guid>("PlayerId")).ToList();
resultedList = ReadByIds(TablesNames.Players, rows);
return resultedList;
}
public static TableInform GetTableInfo( string tableName )
{
TableInform table = null;
try
{
table = tableInfoList[ tableName ];
}
catch
{
try
{
table = new TableInform( tableName );
tableInfoList.Add( tableName , table );
}
catch { }
}
return table;
}
