public bool NoLagCreate(NoLag nl)
{
bool result = false;
MySqlCommand cmd = new MySqlCommand("proc_no_lag_create", conn);
MySqlDataReader reader;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add(new MySqlParameter("p_id_player", nl.Id_player));
cmd.Parameters.Add(new MySqlParameter("p_skype", nl.Skype));
cmd.Parameters.Add(new MySqlParameter("p_name", nl.Name));
cmd.Parameters.Add(new MySqlParameter("p_email", nl.Email));
cmd.Parameters.Add(new MySqlParameter("p_date_requested", DateTime.Now));
try
{
conn.Open();
reader = cmd.ExecuteReader();
result = true;
}
catch (Exception e)
{
conn.Close();
}
finally
{
conn.Close();
}
return(result);
}
public JsonResult Create()
{
bool result = false;
if (_sessionHelper.CurrentPlayer.Id != 0)
{
NoLag nl = new NoLag(_sessionHelper.CurrentPlayer.Id, _sessionHelper.CurrentPlayer.Skype, _sessionHelper.CurrentPlayer.Name, _sessionHelper.CurrentPlayer.Email, DateTime.Now);
result = _noLagBLL.NoLagCreate(nl);
}
return(Json(result));
}
public bool NoLagCreate(NoLag nl)
{
return(_noLagDAL.NoLagCreate(nl));
}