public Player PlayerLogin(string email)
{
MySqlCommand cmd = new MySqlCommand("proc_player_login", conn);
MySqlDataReader reader;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("p_email", email));
Player player = null;
try
{
conn.Open();
reader = cmd.ExecuteReader();
if (reader.Read())
{
player = new Player();
player.Id = (int)reader.GetValue(0);
player.Password = reader.GetValue(1).ToString();
}
}
catch (Exception e)
{
conn.Close();
LogError.GenerateError("PlayerDAL", "PlayerLogin", e.InnerException.ToString());
}
finally
{
conn.Close();
}
return(player);
}
public List <Player> PlayerAvailabeSelect()
{
MySqlCommand cmd = new MySqlCommand("proc_player_list", conn);
MySqlDataReader reader;
cmd.CommandType = CommandType.StoredProcedure;
List <Player> players = new List <Player>();
Player player = new Player();
try
{
conn.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
player.Id = (int)reader.GetValue(0);
player.Name = reader.GetValue(1).ToString();
player.Birthday = DateTime.Parse(reader.GetValue(2).ToString());
player.Nick = reader.GetValue(4).ToString();
player.Email = reader.GetValue(6).ToString();
player.Skype = reader.GetValue(7).ToString();
player.Champion = (Champions)Enum.Parse(typeof(Champions), reader.GetValue(8).ToString(), true);
player.Role1 = (Roles)Enum.Parse(typeof(Roles), reader.GetValue(9).ToString(), true);
player.Role2 = (Roles)Enum.Parse(typeof(Roles), reader.GetValue(10).ToString(), true);
player.IdRiot = long.Parse(reader.GetValue(14).ToString());
player.State = (States)Enum.Parse(typeof(States), reader.GetValue(17).ToString(), true);
player.Schedule = (Schedule)Enum.Parse(typeof(Schedule), reader.GetValue(18).ToString(), true);
player.Schedule = (Schedule)Enum.Parse(typeof(Schedule), reader.GetValue(20).ToString(), true);
players.Add(player);
player = new Player();
}
}
catch (Exception e)
{
LogError.GenerateError("PlayerDAL", "PlayerAvailabeSelect", e.InnerException.ToString());
conn.Close();
}
finally
{
conn.Close();
}
return(players);
}