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