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)); }