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