public static DPalabras PalabraRandom(String pPalabra, String pCategoria, String pRegion) { DPalabras palabra = new DPalabras(); try { SqlCommand obtenerPalabraRandom = new SqlCommand("PalabraRandom", DConexion.ObtnerConexion()); obtenerPalabraRandom.CommandType = CommandType.StoredProcedure; obtenerPalabraRandom.Parameters.Add("@palabra", SqlDbType.VarChar, 30).Value = pPalabra; obtenerPalabraRandom.Parameters.Add("@categoria", SqlDbType.VarChar, 500).Value = pCategoria; obtenerPalabraRandom.Parameters.Add("@region", SqlDbType.VarChar, 300).Value = pRegion; SqlDataReader rdr = obtenerPalabraRandom.ExecuteReader(CommandBehavior.CloseConnection); rdr.Read(); palabra.Palabra = rdr.GetString(0); palabra.Definicion = rdr.GetString(1); palabra.Imagen = rdr.GetString(2); palabra.Seña = rdr.GetString(3); palabra.Categoria = rdr.GetString(4); palabra.Region = rdr.GetString(5); return(palabra); } catch (Exception) { return(palabra); } }
public static bool DeleteRegion(String pRegion) { SqlCommand sql = new SqlCommand("DeleteRegiones", DConexion.ObtnerConexion()); sql.CommandType = CommandType.StoredProcedure; sql.Parameters.Add("@Region", SqlDbType.VarChar, 20).Value = pRegion; try { int r = sql.ExecuteNonQuery(); sql.Connection.Close(); return(r > 0); } catch (Exception) { sql.Connection.Close(); return(false); } }
public static bool InsertarCategoria(String pCategoria) { SqlCommand sql = new SqlCommand("InsertCategorias", DConexion.ObtnerConexion()); sql.CommandType = CommandType.StoredProcedure; sql.Parameters.Add("@Categoria", SqlDbType.VarChar, 20).Value = pCategoria; try { int r = sql.ExecuteNonQuery(); sql.Connection.Close(); return(r > 0); } catch (Exception) { sql.Connection.Close(); return(false); } }
public static bool DeleteUsuario(int pId) { SqlCommand sql = new SqlCommand("DeleteUsuarios", DConexion.ObtnerConexion()); sql.CommandType = CommandType.StoredProcedure; sql.Parameters.Add("@Id", SqlDbType.Int).Value = pId; try { int r = sql.ExecuteNonQuery(); sql.Connection.Close(); return(r > 0); } catch (Exception) { sql.Connection.Close(); return(false); } }
public static bool InsertarPalabra(String pPalabra, String pDefinicion, String pImagen, String pSeña, List <string> pRegion, List <string> pCategoria) { try { SqlCommand Insert = new SqlCommand("InsertPalabras", DConexion.ObtnerConexion()); Insert.CommandType = CommandType.StoredProcedure; Insert.Parameters.Add("@Palabra", SqlDbType.VarChar, 30).Value = pPalabra; Insert.Parameters.Add("@Definicion", SqlDbType.VarChar, 500).Value = pDefinicion; Insert.Parameters.Add("@imagen", SqlDbType.VarChar, 300).Value = pImagen; int r = Insert.ExecuteNonQuery(); Insert.Connection.Close(); foreach (var item in pCategoria) { SqlCommand RelCategoriaPalabra = new SqlCommand("InsertRelCategoriaPalabra", DConexion.ObtnerConexion()); RelCategoriaPalabra.CommandType = CommandType.StoredProcedure; RelCategoriaPalabra.Parameters.Add("@Palabra", SqlDbType.VarChar, 20).Value = pPalabra; RelCategoriaPalabra.Parameters.Add("@categoria", SqlDbType.VarChar, 20).Value = item; r = RelCategoriaPalabra.ExecuteNonQuery(); RelCategoriaPalabra.Connection.Close(); } foreach (var item in pRegion) { SqlCommand InsertSenia = new SqlCommand("InsertSenia", DConexion.ObtnerConexion()); InsertSenia.CommandType = CommandType.StoredProcedure; InsertSenia.Parameters.Add("@Palabra", SqlDbType.VarChar, 20).Value = pPalabra; InsertSenia.Parameters.Add("@Region", SqlDbType.VarChar, 20).Value = item; InsertSenia.Parameters.Add("@senia", SqlDbType.VarChar, 300).Value = pSeña; r = InsertSenia.ExecuteNonQuery(); InsertSenia.Connection.Close(); } return(r > 0); } catch (Exception) { return(false); } }
public static List <DRegiones> ObtenerRegiones() { List <DRegiones> LRegiones = new List <DRegiones>(); SqlConnection conexion = DConexion.ObtnerConexion(); SqlCommand command = new SqlCommand("SelectRegiones", conexion); command.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { DRegiones Region = new DRegiones(); Region.Id = Convert.ToInt32(reader["Id"].ToString()); Region.Region = reader["Region"].ToString(); LRegiones.Add(Region); } conexion.Close(); return(LRegiones); }
public static List <DCategorias> ObtenerCategorias() { List <DCategorias> LCategorias = new List <DCategorias>(); SqlConnection conexion = DConexion.ObtnerConexion(); SqlCommand command = new SqlCommand("SelectCategorias", conexion); command.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { DCategorias Categoria = new DCategorias(); Categoria.Id = Convert.ToInt32(reader["Id"].ToString()); Categoria.Categoria = reader["Categoria"].ToString(); LCategorias.Add(Categoria); } conexion.Close(); return(LCategorias); }
public static bool InsertarUsuario(String pNombre, String pPassword, String pPerfil) { SqlCommand sql = new SqlCommand("InsertUsuarios", DConexion.ObtnerConexion()); sql.CommandType = CommandType.StoredProcedure; sql.Parameters.Add("@Nombre", SqlDbType.VarChar, 20).Value = pNombre; sql.Parameters.Add("@Password", SqlDbType.VarChar, 50).Value = pPassword; sql.Parameters.Add("@Perfil", SqlDbType.VarChar, 15).Value = pPerfil; try { int r = sql.ExecuteNonQuery(); sql.Connection.Close(); return(r > 0); } catch (Exception) { sql.Connection.Close(); return(false); } }
public static List <DUsuarios> Usuarios() { List <DUsuarios> LUsuarios = new List <DUsuarios>(); SqlConnection conexion = DConexion.ObtnerConexion(); SqlCommand command = new SqlCommand("SelectUsuarios", conexion); command.CommandType = System.Data.CommandType.StoredProcedure; SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { DUsuarios Usuario = new DUsuarios(); Usuario.Id = Convert.ToInt32(reader["Id"].ToString()); Usuario.Nombre = reader["Nombre"].ToString(); Usuario.Password = reader["Password"].ToString(); Usuario.Perfil = reader["Perfil"].ToString(); LUsuarios.Add(Usuario); } conexion.Close(); return(LUsuarios); }