public int createRuleta(Ruletas ruleta) { var number = Enumerable.Range(0, 30); var color = Enumerable.Range(0, 1); try { command = new SqlCommand("dbo.insertRuleta", conn.getCon()); command.CommandType = CommandType.StoredProcedure; SqlParameter paramId = new SqlParameter("@id", SqlDbType.Int); SqlParameter paramState = new SqlParameter("@state", SqlDbType.Int); SqlParameter paramNumber = new SqlParameter("@number", SqlDbType.Int); SqlParameter paramColor = new SqlParameter("@color", SqlDbType.Int); paramId.Direction = ParameterDirection.Output; command.Parameters.Add(paramId); paramState.Direction = ParameterDirection.Output; command.Parameters.Add(paramState); paramNumber.Direction = ParameterDirection.Output; command.Parameters.Add(paramNumber); paramColor.Direction = ParameterDirection.Output; command.Parameters.Add(paramColor); command.Parameters.AddWithValue("state", 0); command.Parameters.AddWithValue("number", number); command.Parameters.AddWithValue("color", color); return(Convert.ToInt32(command.ExecuteScalar())); } catch (Exception) { throw; } finally { conn.closeConnection(); } }
public List <Ruletas> ruletasList() { List <Ruletas> ruletasList = new List <Ruletas>(); string findAll = "SELECT * FROM ruletas"; try { command = new SqlCommand(findAll, conn.getCon()); conn.getCon().Open(); SqlDataReader read = command.ExecuteReader(); while (read.Read()) { Ruletas ruleta = new Ruletas(); ruleta.id_ruleta = Convert.ToInt32(read[10.ToString()]); ruleta.state = Convert.ToInt32(read[1].ToString()); ruleta.number = Convert.ToInt32(read[2].ToString()); ruleta.color = Convert.ToInt32(read[2].ToString()); ruletasList.Add(ruleta); } } catch (Exception) { throw; } finally { conn.closeConnection(); } return(ruletasList); }
public ActionResult NewRoulete(Ruletas ruleta, string name, Boolean estado, string entrada1) { ruleta.name = name; ruleta.id = ""; ruleta.estado = estado; string json = JsonConvert.SerializeObject(ruleta); dynamic respuesta = DBapli.Post("http://rouletteapi.azurewebsites.net/api/Ruletas", json); ViewBag.ruletas = respuesta; return(RedirectToAction("AllRoulette")); }
public int PostRuleta(Ruletas ruleta) { try { return(ruletaDao.createRuleta(ruleta)); } catch (Exception e) { return(-1); } }
public ActionResult CloseRouletes(Ruletas ruleta, Boolean estado, string name, string id) { ruleta.id = id; string Url = "http://rouletteapi.azurewebsites.net/api/Ruletas/" + ruleta.id; ruleta.name = name; ruleta.estado = false; string json = JsonConvert.SerializeObject(ruleta); dynamic respuesta = DBapli.Put(Url, json); ViewBag.ruletas = respuesta; return(RedirectToAction("AllRoulette")); }
// DELETE: api/Ruletas/5 public HttpResponseMessage Delete([FromBody] Ruletas Ru) { int resp = 0; HttpResponseMessage msg = null; try { using (RouletteEntities2 entities = new RouletteEntities2()) { entities.Entry(Ru).State = EntityState.Deleted; resp = entities.SaveChanges(); msg = Request.CreateResponse(HttpStatusCode.OK, resp); } } catch (Exception ex) { msg = Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex.Message); } return(msg); }
internal List <Ruletas> ConsultarRuletas() { List <Ruletas> ListRull = new List <Ruletas>(); using (SqlConnection con = new SqlConnection(conexion)) { string sentencia = querySQL(3, new Ruleta { }); SqlCommand cmd = new SqlCommand(sentencia, con); con.Open(); SqlDataReader rd = cmd.ExecuteReader(); while (rd.Read()) { Ruletas rull = new Ruletas(); rull.idRuleta = rd.GetInt32(0); rull.Resultado = rd.GetInt32(1); rull.EstadoRuleta = rd.GetBoolean(2); rull.Cierres = new RuletaDAO().ConsultarCierres(rull.idRuleta); ListRull.Add(rull); } } return(ListRull); }