public DataTable devuelveDatos(object obj)
{
string cadenaWhere = "";
bool edo = false;
BO.Historia data = (BO.Historia)obj;
bd = new BaseDB();
if (data.Id_historia > 0)
{
cadenaWhere += " id_historia=@id_historia and";
bd.Cmd.Parameters.Add("@id_historia", SqlDbType.Int);
bd.Cmd.Parameters["@id_historia"].Value = data.Id_historia;
edo = true;
}
if (edo == true)
{
cadenaWhere = "WHERE " + cadenaWhere.Remove(cadenaWhere.Length - 3, 3);
}
sql = " SELECT * FROM historia " + cadenaWhere;
DataTable dt = new DataTable();
bd.execQuery(sql).Fill(dt);
return(dt);
}
public DataTable GetTipoUsuario()
{
bd = new BaseDB();
sql = " SELECT * FROM tipo_usuario";
DataTable dt = new DataTable();
bd.execQuery(sql).Fill(dt);
return(dt);
}
public DataTable GetTopRows_Descendent()
{
bd = new BaseDB();
sql = "SELECT TOP(10) * FROM historia ORDER BY id_historia DESC;";
DataTable dt = new DataTable();
bd.execQuery(sql).Fill(dt);
return(dt);
}
public DataTable GetCiudades()
{
bd = new BaseDB();
sql = " SELECT * FROM ciudad";
DataTable dt = new DataTable();
bd.execQuery(sql).Fill(dt);
return(dt);
}
public DataTable GetEstados()
{
bd = new BaseDB();
sql = " SELECT * FROM estado";
DataTable dt = new DataTable();
bd.execQuery(sql).Fill(dt);
return(dt);
}
public DataTable GetPaises()
{
bd = new BaseDB();
sql = " SELECT * FROM pais";
DataTable dt = new DataTable();
bd.execQuery(sql).Fill(dt);
return(dt);
}
public DataTable GetStatus()
{
bd = new BaseDB();
sql = " SELECT * FROM status_historia";
DataTable dt = new DataTable();
bd.execQuery(sql).Fill(dt);
return(dt);
}
public DataTable recuperaHistoria()
{
BO.Historia data = new BO.Historia();
bd = new BaseDB();
sql = " SELECT * FROM VISTA_HISTORIA";
DataTable dt = new DataTable();
bd.execQuery(sql).Fill(dt);
return(dt);
}
public DataTable getPreviewLastStories()
{
BO.Historia data = new BO.Historia();
bd = new BaseDB();
sql = " SELECT * FROM VIEW_PREW_LAST_STORIES ";
DataTable dt = new DataTable();
bd.execQuery(sql).Fill(dt);
return(dt);
}
public DataTable GetStoriesByAuthor(string id_autor)
{
bd = new BaseDB();
sql = "DEVOLVER_HISTORIA";
bd.Cmd.CommandType = CommandType.StoredProcedure;
bd.Cmd.Parameters.AddWithValue("@id_autor", id_autor);
DataTable dt = new DataTable();
bd.execQuery(sql).Fill(dt);
return(dt);
}
public DataTable devuelveDatos(object obj)
{
string cadenaWhere = "";
bool edo = false;
BO.Usuario data = (BO.Usuario)obj;
bd = new BaseDB();
if (data.Id_usuario > 0)
{
cadenaWhere += " id_usuario=@id_usuario and";
bd.Cmd.Parameters.Add("@id_usuario", SqlDbType.Int);
bd.Cmd.Parameters["@id_usuario"].Value = data.Id_usuario;
edo = true;
}
if (data.Username != null)
{
cadenaWhere += " username=@username and";
bd.Cmd.Parameters.Add("@username", SqlDbType.VarChar);
bd.Cmd.Parameters["@username"].Value = data.Username;
edo = true;
}
if (data.Contrasenia != null)
{
cadenaWhere += " contrasenia=@contrasenia and";
bd.Cmd.Parameters.Add("@contrasenia", SqlDbType.VarChar);
bd.Cmd.Parameters["@contrasenia"].Value = data.Contrasenia;
edo = true;
}
if (edo == true)
{
cadenaWhere = "WHERE " + cadenaWhere.Remove(cadenaWhere.Length - 3, 3);
}
sql = " SELECT * FROM usuario " + cadenaWhere;
DataTable dt = new DataTable();
bd.execQuery(sql).Fill(dt);
return(dt);
}
